|
Lines 2627-2648
CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
Link Here
|
| 2627 |
-- |
2627 |
-- |
| 2628 |
|
2628 |
|
| 2629 |
DROP TABLE IF EXISTS `aqbudgets`; |
2629 |
DROP TABLE IF EXISTS `aqbudgets`; |
| 2630 |
CREATE TABLE `aqbudgets` ( |
2630 |
CREATE TABLE `aqbudgets` ( -- information related to Funds |
| 2631 |
`budget_id` int(11) NOT NULL auto_increment, |
2631 |
`budget_id` int(11) NOT NULL auto_increment, -- primary key and unique number assigned to each fund by Koha |
| 2632 |
`budget_parent_id` int(11) default NULL, |
2632 |
`budget_parent_id` int(11) default NULL, -- if this fund is a child of another this will include the parent id (aqbudgets.budget_id) |
| 2633 |
`budget_code` varchar(30) default NULL, |
2633 |
`budget_code` varchar(30) default NULL, -- code assigned to the fund by the user |
| 2634 |
`budget_name` varchar(80) default NULL, |
2634 |
`budget_name` varchar(80) default NULL, -- name assigned to the fund by the user |
| 2635 |
`budget_branchcode` varchar(10) default NULL, |
2635 |
`budget_branchcode` varchar(10) default NULL, -- branch that this fund belongs to (branches.branchcode) |
| 2636 |
`budget_amount` decimal(28,6) NULL default '0.00', |
2636 |
`budget_amount` decimal(28,6) NULL default '0.00', -- total amount for this fund |
| 2637 |
`budget_encumb` decimal(28,6) NULL default '0.00', |
2637 |
`budget_encumb` decimal(28,6) NULL default '0.00', -- not used in the code |
| 2638 |
`budget_expend` decimal(28,6) NULL default '0.00', |
2638 |
`budget_expend` decimal(28,6) NULL default '0.00', -- not used in the code |
| 2639 |
`budget_notes` mediumtext, |
2639 |
`budget_notes` mediumtext, -- notes related to this fund |
| 2640 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2640 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time this fund was last touched (created or modified) |
| 2641 |
`budget_period_id` int(11) default NULL, |
2641 |
`budget_period_id` int(11) default NULL, -- id of the budget that this fund belongs to (aqbudgetperiods.budget_period_id) |
| 2642 |
`sort1_authcat` varchar(80) default NULL, |
2642 |
`sort1_authcat` varchar(80) default NULL, -- statistical category for this fund |
| 2643 |
`sort2_authcat` varchar(80) default NULL, |
2643 |
`sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund |
| 2644 |
`budget_owner_id` int(11) default NULL, |
2644 |
`budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber) |
| 2645 |
`budget_permission` int(1) default '0', |
2645 |
`budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone) |
| 2646 |
PRIMARY KEY (`budget_id`) |
2646 |
PRIMARY KEY (`budget_id`) |
| 2647 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2647 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 2648 |
|
2648 |
|
|
Lines 2669-2684
CREATE TABLE aqbudgetborrowers (
Link Here
|
| 2669 |
|
2669 |
|
| 2670 |
|
2670 |
|
| 2671 |
DROP TABLE IF EXISTS `aqbudgetperiods`; |
2671 |
DROP TABLE IF EXISTS `aqbudgetperiods`; |
| 2672 |
CREATE TABLE `aqbudgetperiods` ( |
2672 |
CREATE TABLE `aqbudgetperiods` ( -- information related to Budgets |
| 2673 |
`budget_period_id` int(11) NOT NULL auto_increment, |
2673 |
`budget_period_id` int(11) NOT NULL auto_increment, -- primary key and unique number assigned by Koha |
| 2674 |
`budget_period_startdate` date NOT NULL, |
2674 |
`budget_period_startdate` date NOT NULL, -- date when the budget starts |
| 2675 |
`budget_period_enddate` date NOT NULL, |
2675 |
`budget_period_enddate` date NOT NULL, -- date when the budget ends |
| 2676 |
`budget_period_active` tinyint(1) default '0', |
2676 |
`budget_period_active` tinyint(1) default '0', -- whether this budget is active or not (1 for yes, 0 for no) |
| 2677 |
`budget_period_description` mediumtext, |
2677 |
`budget_period_description` mediumtext, -- description assigned to this budget |
| 2678 |
`budget_period_total` decimal(28,6), |
2678 |
`budget_period_total` decimal(28,6), -- total amount available in this budget |
| 2679 |
`budget_period_locked` tinyint(1) default NULL, |
2679 |
`budget_period_locked` tinyint(1) default NULL, -- whether this budget is locked or not (1 for yes, 0 for no) |
| 2680 |
`sort1_authcat` varchar(10) default NULL, |
2680 |
`sort1_authcat` varchar(10) default NULL, -- statistical category for this budget |
| 2681 |
`sort2_authcat` varchar(10) default NULL, |
2681 |
`sort2_authcat` varchar(10) default NULL, -- second statistical category for this budget |
| 2682 |
PRIMARY KEY (`budget_period_id`) |
2682 |
PRIMARY KEY (`budget_period_id`) |
| 2683 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2683 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 2684 |
|
2684 |
|
| 2685 |
- |
|
|