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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +19 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`),
2852
  KEY `branch` (`branch`),
2851
  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,
2852
  CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2854
  CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`),
2853
  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 2902-2907 CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis Link Here
2902
  PRIMARY KEY  (`id`),
2904
  PRIMARY KEY  (`id`),
2903
  KEY `listprice` (`listprice`),
2905
  KEY `listprice` (`listprice`),
2904
  KEY `invoiceprice` (`invoiceprice`),
2906
  KEY `invoiceprice` (`invoiceprice`),
2907
  KEY `name` (`name`(255)),
2905
  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,
2906
  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
2907
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2910
) 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
2930
  `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)
2931
  `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)
2932
  `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`)
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`),
2931
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2939
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2932
2940
2933
--
2941
--
Lines 2980-2985 CREATE TABLE `aqbudgets_planning` ( Link Here
2980
  `authvalue` varchar(30) NOT NULL,
2988
  `authvalue` varchar(30) NOT NULL,
2981
  `display` tinyint(1) DEFAULT 1,
2989
  `display` tinyint(1) DEFAULT 1,
2982
  PRIMARY KEY  (`plan_id`),
2990
  PRIMARY KEY  (`plan_id`),
2991
  KEY `budget_id` (`budget_id`),
2992
  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
2993
  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;
2994
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2985
2995
Lines 3003-3008 CREATE TABLE aqcontacts ( Link Here
3003
  serialsprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for serials messages
3013
  serialsprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for serials messages
3004
  booksellerid int(11) not NULL,
3014
  booksellerid int(11) not NULL,
3005
  PRIMARY KEY  (id),
3015
  PRIMARY KEY  (id),
3016
  KEY `booksellerid` (`booksellerid`),
3006
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
3017
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
3007
       REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE
3018
       REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE
3008
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
3019
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
Lines 3020-3025 CREATE TABLE `aqcontract` ( Link Here
3020
  `contractdescription` mediumtext,
3031
  `contractdescription` mediumtext,
3021
  `booksellerid` int(11) not NULL,
3032
  `booksellerid` int(11) not NULL,
3022
  PRIMARY KEY  (`contractnumber`),
3033
  PRIMARY KEY  (`contractnumber`),
3034
  KEY `booksellerid` (`booksellerid`),
3023
  CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
3035
  CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
3024
       REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3036
       REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3025
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
3037
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
Lines 3070-3075 CREATE TABLE `aqorders` ( -- information related to the basket line items Link Here
3070
  KEY `basketno` (`basketno`),
3082
  KEY `basketno` (`basketno`),
3071
  KEY `biblionumber` (`biblionumber`),
3083
  KEY `biblionumber` (`biblionumber`),
3072
  KEY `budget_id` (`budget_id`),
3084
  KEY `budget_id` (`budget_id`),
3085
  KEY `invoiceid` (`invoiceid`),
3086
  KEY `subscriptionid` (`subscriptionid`),
3087
  KEY `parent_ordernumber` (`parent_ordernumber`),
3088
  KEY `orderstatus` (`orderstatus`),
3073
  CONSTRAINT `aqorders_budget_id_fk` FOREIGN KEY (`budget_id`) REFERENCES `aqbudgets` (`budget_id`) ON DELETE CASCADE ON UPDATE CASCADE,
3089
  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,
3090
  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,
3091
  CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE CASCADE,
Lines 3135-3140 CREATE TABLE aqinvoices ( Link Here
3135
  shipmentcost decimal(28,6) default NULL,  -- shipment cost
3151
  shipmentcost decimal(28,6) default NULL,  -- shipment cost
3136
  shipmentcost_budgetid int(11) default NULL,   -- foreign key to aqbudgets, link the shipment cost to a budget
3152
  shipmentcost_budgetid int(11) default NULL,   -- foreign key to aqbudgets, link the shipment cost to a budget
3137
  PRIMARY KEY (invoiceid),
3153
  PRIMARY KEY (invoiceid),
3154
  KEY `booksellerid` (`booksellerid`),
3155
  KEY `shipmentcost_budgetid` (`shipmentcost_budgetid`),
3138
  CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE,
3156
  CONSTRAINT aqinvoices_fk_aqbooksellerid FOREIGN KEY (booksellerid) REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE,
3139
  CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
3157
  CONSTRAINT aqinvoices_fk_shipmentcost_budgetid FOREIGN KEY (shipmentcost_budgetid) REFERENCES aqbudgets (budget_id) ON DELETE SET NULL ON UPDATE CASCADE
3140
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3158
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3141
- 

Return to bug 14053