Lines 559-565
CREATE TABLE `aqbudgets` (
Link Here
|
559 |
`budget_expend` decimal(28,6) DEFAULT 0.000000 COMMENT 'budget warning at amount', |
559 |
`budget_expend` decimal(28,6) DEFAULT 0.000000 COMMENT 'budget warning at amount', |
560 |
`budget_notes` longtext DEFAULT NULL COMMENT 'notes related to this fund', |
560 |
`budget_notes` longtext DEFAULT NULL COMMENT 'notes related to this fund', |
561 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this fund was last touched (created or modified)', |
561 |
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'date and time this fund was last touched (created or modified)', |
562 |
`budget_period_id` int(11) DEFAULT NULL COMMENT 'id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id)', |
562 |
`budget_period_id` int(11) NOT NULL COMMENT 'id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id)', |
563 |
`sort1_authcat` varchar(80) DEFAULT NULL COMMENT 'statistical category for this fund', |
563 |
`sort1_authcat` varchar(80) DEFAULT NULL COMMENT 'statistical category for this fund', |
564 |
`sort2_authcat` varchar(80) DEFAULT NULL COMMENT 'second statistical category for this fund', |
564 |
`sort2_authcat` varchar(80) DEFAULT NULL COMMENT 'second statistical category for this fund', |
565 |
`budget_owner_id` int(11) DEFAULT NULL COMMENT 'borrowernumber of the person who owns this fund (borrowers.borrowernumber)', |
565 |
`budget_owner_id` int(11) DEFAULT NULL COMMENT 'borrowernumber of the person who owns this fund (borrowers.borrowernumber)', |