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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +11 lines)
Lines 2853-2858 CREATE TABLE `aqbasket` ( -- stores data about baskets in acquisitions Link Here
2853
  KEY `booksellerid` (`booksellerid`),
2853
  KEY `booksellerid` (`booksellerid`),
2854
  KEY `basketgroupid` (`basketgroupid`),
2854
  KEY `basketgroupid` (`basketgroupid`),
2855
  KEY `contractnumber` (`contractnumber`),
2855
  KEY `contractnumber` (`contractnumber`),
2856
  KEY `authorisedby` (`authorisedby`),
2856
  CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,
2857
  CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE,
2857
  CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2858
  CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2858
  CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,
2859
  CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE,
Lines 2907-2912 CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis Link Here
2907
  PRIMARY KEY  (`id`),
2908
  PRIMARY KEY  (`id`),
2908
  KEY `listprice` (`listprice`),
2909
  KEY `listprice` (`listprice`),
2909
  KEY `invoiceprice` (`invoiceprice`),
2910
  KEY `invoiceprice` (`invoiceprice`),
2911
  KEY `name` (`name`(255)),
2910
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2912
  CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
2911
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2913
  CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE
2912
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2914
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Lines 2932-2938 CREATE TABLE `aqbudgets` ( -- information related to Funds Link Here
2932
  `sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund
2934
  `sort2_authcat` varchar(80) default NULL, -- second statistical category for this fund
2933
  `budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber)
2935
  `budget_owner_id` int(11) default NULL, -- borrowernumber of the person who owns this fund (borrowers.borrowernumber)
2934
  `budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone)
2936
  `budget_permission` int(1) default '0', -- level of permission for this fund (used only by the owner, only by the library, or anyone)
2935
  PRIMARY KEY  (`budget_id`)
2937
  PRIMARY KEY  (`budget_id`),
2938
  KEY `budget_parent_id` (`budget_parent_id`),
2939
  KEY `budget_code` (`budget_code`),
2940
  KEY `budget_branchcode` (`budget_branchcode`),
2941
  KEY `budget_period_id` (`budget_period_id`),
2942
  KEY `budget_owner_id` (`budget_owner_id`)
2936
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2943
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2937
2944
2938
--
2945
--
Lines 2985-2990 CREATE TABLE `aqbudgets_planning` ( Link Here
2985
  `authvalue` varchar(30) NOT NULL,
2992
  `authvalue` varchar(30) NOT NULL,
2986
  `display` tinyint(1) DEFAULT 1,
2993
  `display` tinyint(1) DEFAULT 1,
2987
  PRIMARY KEY  (`plan_id`),
2994
  PRIMARY KEY  (`plan_id`),
2995
  KEY `budget_period_id` (`budget_period_id`),
2988
  CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE
2996
  CONSTRAINT `aqbudgets_planning_ifbk_1` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE
2989
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2997
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2990
2998
Lines 3074-3079 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3074
  KEY `basketno` (`basketno`),
3082
  KEY `basketno` (`basketno`),
3075
  KEY `biblionumber` (`biblionumber`),
3083
  KEY `biblionumber` (`biblionumber`),
3076
  KEY `budget_id` (`budget_id`),
3084
  KEY `budget_id` (`budget_id`),
3085
  KEY `parent_ordernumber` (`parent_ordernumber`),
3086
  KEY `orderstatus` (`orderstatus`),
3077
  CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,
3087
  CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,
3078
  CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
3088
  CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES `aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
3079
  CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3089
  CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
3080
- 

Return to bug 14053