View | Details | Raw Unified | Return to bug 6716
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-27 / +26 lines)
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
- 

Return to bug 6716