Lines 2510-2517
DROP TABLE IF EXISTS `aqbudgets`;
Link Here
|
2510 |
CREATE TABLE `aqbudgets` ( |
2510 |
CREATE TABLE `aqbudgets` ( |
2511 |
`budget_id` int(11) NOT NULL auto_increment, |
2511 |
`budget_id` int(11) NOT NULL auto_increment, |
2512 |
`budget_parent_id` int(11) default NULL, |
2512 |
`budget_parent_id` int(11) default NULL, |
2513 |
`budget_code` varchar(30) default NULL, |
2513 |
`budget_code` varchar(30) NOT NULL, |
2514 |
`budget_name` varchar(80) default NULL, |
2514 |
`budget_name` varchar(80) NOT NULL, |
2515 |
`budget_branchcode` varchar(10) default NULL, |
2515 |
`budget_branchcode` varchar(10) default NULL, |
2516 |
`budget_amount` decimal(28,6) NULL default '0.00', |
2516 |
`budget_amount` decimal(28,6) NULL default '0.00', |
2517 |
`budget_encumb` decimal(28,6) NULL default '0.00', |
2517 |
`budget_encumb` decimal(28,6) NULL default '0.00', |
Lines 2523-2529
CREATE TABLE `aqbudgets` (
Link Here
|
2523 |
`sort2_authcat` varchar(80) default NULL, |
2523 |
`sort2_authcat` varchar(80) default NULL, |
2524 |
`budget_owner_id` int(11) default NULL, |
2524 |
`budget_owner_id` int(11) default NULL, |
2525 |
`budget_permission` int(1) default '0', |
2525 |
`budget_permission` int(1) default '0', |
2526 |
PRIMARY KEY (`budget_id`) |
2526 |
PRIMARY KEY (`budget_id`), |
|
|
2527 |
UNIQUE KEY `uniq_budget_name_aqbudgets` (`budget_name`), |
2528 |
UNIQUE KEY `uniq_budget_code_aqbudgets` (`budget_code` |
2527 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2529 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2528 |
|
2530 |
|
2529 |
|
2531 |
|
Lines 2538-2549
CREATE TABLE `aqbudgetperiods` (
Link Here
|
2538 |
`budget_period_startdate` date NOT NULL, |
2540 |
`budget_period_startdate` date NOT NULL, |
2539 |
`budget_period_enddate` date NOT NULL, |
2541 |
`budget_period_enddate` date NOT NULL, |
2540 |
`budget_period_active` tinyint(1) default '0', |
2542 |
`budget_period_active` tinyint(1) default '0', |
2541 |
`budget_period_description` mediumtext, |
2543 |
`budget_period_description` varchar(255) NOT NULL, |
2542 |
`budget_period_total` decimal(28,6), |
2544 |
`budget_period_total` decimal(28,6), |
2543 |
`budget_period_locked` tinyint(1) default NULL, |
2545 |
`budget_period_locked` tinyint(1) default NULL, |
2544 |
`sort1_authcat` varchar(10) default NULL, |
2546 |
`sort1_authcat` varchar(10) default NULL, |
2545 |
`sort2_authcat` varchar(10) default NULL, |
2547 |
`sort2_authcat` varchar(10) default NULL, |
2546 |
PRIMARY KEY (`budget_period_id`) |
2548 |
PRIMARY KEY (`budget_period_id`), |
|
|
2549 |
UNIQUE KEY `uniq_aqbudgetperiods` (`budget_period_description`) |
2547 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2550 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2548 |
|
2551 |
|
2549 |
-- |
2552 |
-- |