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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +11 lines)
Lines 2849-2854 CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions Link Here
2849
  KEY `booksellerid` (`booksellerid`),
2849
  KEY `booksellerid` (`booksellerid`),
2850
  KEY `basketgroupid` (`basketgroupid`),
2850
  KEY `basketgroupid` (`basketgroupid`),
2851
  KEY `contractnumber` (`contractnumber`),
2851
  KEY `contractnumber` (`contractnumber`),
2852
  KEY `authorisedby` (`authorisedby`),
2852
  CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,
2853
  CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,
2853
  CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2854
  CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2854
  CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,
2855
  CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,
Lines 2903-2908 CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis Link Here
2903
  PRIMARY KEY  (`id`),
2904
  PRIMARY KEY  (`id`),
2904
  KEY `listprice` (`listprice`),
2905
  KEY `listprice` (`listprice`),
2905
  KEY `invoiceprice` (`invoiceprice`),
2906
  KEY `invoiceprice` (`invoiceprice`),
2907
  KEY `name` (`name`(255)),
2906
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2908
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2907
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2909
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2908
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2910
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Lines 2928-2934 CREATE TABLE `aqbudgets` ( -- information related to Funds Link Here
2928
  `sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund
2930
  `sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund
2929
  `budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber)
2931
  `budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber)
2930
  `budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone)
2932
  `budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone)
2931
  PRIMARY KEY  (`budget_id`)
2933
  PRIMARY KEY  (`budget_id`),
2934
  KEY `budget_parent_id` (`budget_parent_id`),
2935
  KEY `budget_code` (`budget_code`),
2936
  KEY `budget_branchcode` (`budget_branchcode`),
2937
  KEY `budget_period_id` (`budget_period_id`),
2938
  KEY `budget_owner_id` (`budget_owner_id`)
2932
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2939
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2933
2940
2934
--
2941
--
Lines 2981-2986 CREATE TABLE `aqbudgets_planning` ( Link Here
2981
  `authvalue` varchar(30) NOT NULL,
2988
  `authvalue` varchar(30) NOT NULL,
2982
  `display` tinyint(1) DEFAULT 1,
2989
  `display` tinyint(1) DEFAULT 1,
2983
  PRIMARY KEY  (`plan_id`),
2990
  PRIMARY KEY  (`plan_id`),
2991
  KEY `budget_period_id` (`budget_period_id`),
2984
  CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE
2992
  CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE
2985
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2993
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2986
2994
Lines 3071-3076 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3071
  KEY `basketno` (`basketno`),
3079
  KEY `basketno` (`basketno`),
3072
  KEY `biblionumber` (`biblionumber`),
3080
  KEY `biblionumber` (`biblionumber`),
3073
  KEY `budget_id` (`budget_id`),
3081
  KEY `budget_id` (`budget_id`),
3082
  KEY `parent_ordernumber` (`parent_ordernumber`),
3083
  KEY `orderstatus` (`orderstatus`),
3074
  CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,
3084
  CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,
3075
  CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
3085
  CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
3076
  CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3086
  CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3077
- 

Return to bug 14053