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 |
- |
|
|