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

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

Return to bug 14053