[Koha-cvs] koha/installer kohastructure.sql [rel_3

koha-cvs
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/installer kohastructure.sql [rel_3_0]

From:	Ryan Higgins
Subject:	[Koha-cvs] koha/installer kohastructure.sql [rel_3_0]
Date:	Sun, 04 Mar 2007 23:13:35 +0000
CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_3_0
Changes by:     Ryan Higgins <rych>     07/03/04 23:13:35

Modified files:
        installer      : kohastructure.sql 

Log message:
        fix constraints definitions

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/installer/kohastructure.sql?cvsroot=koha&only_with_tag=rel_3_0&r1=1.1.2.1&r2=1.1.2.2

Patches:
Index: kohastructure.sql
===================================================================
RCS file: /sources/koha/koha/installer/Attic/kohastructure.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -b -r1.1.2.1 -r1.1.2.2
--- kohastructure.sql   9 Feb 2007 21:04:17 -0000       1.1.2.1
+++ kohastructure.sql   4 Mar 2007 23:13:35 -0000       1.1.2.2
@@ -2132,9 +2132,9 @@
 -- Contraintes pour la table `accountlines`
 -- 
 ALTER TABLE `accountlines`
-  ADD CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) 
REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) 
REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `accountlines`
-  ADD CONSTRAINT `accountlines_ibfk_1` FOREIGN KEY (`borrowernumber`) 
REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,  
ADD CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES 
`items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
+  ADD CONSTRAINT `accountlines_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES 
`items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
 
 -- 
 -- Contraintes pour la table `aqbasket`
@@ -2146,25 +2146,25 @@
 -- Contraintes pour la table `aqbooksellers`
 -- 
 ALTER TABLE `aqbooksellers`
-  ADD CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES 
`currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES 
`currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `aqbooksellers`
-  ADD CONSTRAINT `aqbooksellers_ibfk_1` FOREIGN KEY (`listprice`) REFERENCES 
`currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT 
`aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) REFERENCES `currency` 
(`currency`) ON DELETE CASCADE ON UPDATE CASCADE;
+  ADD CONSTRAINT `aqbooksellers_ibfk_2` FOREIGN KEY (`invoiceprice`) 
REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE;
 
 -- 
 -- Contraintes pour la table `aqorderbreakdown`
 -- 
 ALTER TABLE `aqorderbreakdown`
-  ADD CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) 
REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) 
REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `aqorderbreakdown`
-  ADD CONSTRAINT `aqorderbreakdown_ibfk_1` FOREIGN KEY (`ordernumber`) 
REFERENCES `aqorders` (`ordernumber`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD 
CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) REFERENCES 
`aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE;
+    ADD CONSTRAINT `aqorderbreakdown_ibfk_2` FOREIGN KEY (`bookfundid`) 
REFERENCES `aqbookfund` (`bookfundid`) ON DELETE CASCADE ON UPDATE CASCADE;
 
 -- 
 -- Contraintes pour la table `aqorders`
 -- 
 ALTER TABLE `aqorders`
-  ADD CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES 
`aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES 
`aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `aqorders`
-  ADD CONSTRAINT `aqorders_ibfk_1` FOREIGN KEY (`basketno`) REFERENCES 
`aqbasket` (`basketno`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT 
`aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` 
(`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL;
+    ADD CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES 
`biblio` (`biblionumber`) ON DELETE SET NULL ON UPDATE SET NULL;
 
 -- 
 -- Contraintes pour la table `auth_tag_structure`
@@ -2182,60 +2182,60 @@
 -- Contraintes pour la table `borrowers`
 -- 
 ALTER TABLE `borrowers`
-  ADD CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES 
`categories` (`categorycode`),
+  ADD CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES 
`categories` (`categorycode`);
 ALTER TABLE `borrowers`
-  ADD CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES 
`categories` (`categorycode`),  ADD CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY 
(`branchcode`) REFERENCES `branches` (`branchcode`);
+    ADD CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES 
`branches` (`branchcode`);
 
 -- 
 -- Contraintes pour la table `branchtransfers`
 -- 
 ALTER TABLE `branchtransfers`
-  ADD CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) 
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) 
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `branchtransfers`
-  ADD CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) 
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD 
CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES 
`branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,
+   ADD CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES 
`branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `branchtransfers`
-  ADD CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) 
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD 
CONSTRAINT `branchtransfers_ibfk_2` FOREIGN KEY (`tobranch`) REFERENCES 
`branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT 
`branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` 
(`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
+   ADD CONSTRAINT `branchtransfers_ibfk_3` FOREIGN KEY (`itemnumber`) 
REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
 
 -- 
 -- Contraintes pour la table `issues`
 -- 
 ALTER TABLE `issues`
-  ADD CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES 
`borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,
+  ADD CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES 
`borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL;
 ALTER TABLE `issues`
-  ADD CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES 
`borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL,  ADD 
CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` 
(`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
+    ADD CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES 
`items` (`itemnumber`) ON DELETE SET NULL ON UPDATE SET NULL;
 
 -- 
 -- Contraintes pour la table `issuingrules`
 -- 
 ALTER TABLE `issuingrules`
-  ADD CONSTRAINT `issuingrules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES 
`categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `issuingrules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES 
`categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `issuingrules`
-  ADD CONSTRAINT `issuingrules_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES 
`categories` (`categorycode`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD 
CONSTRAINT `issuingrules_ibfk_2` FOREIGN KEY (`itemtype`) REFERENCES 
`itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE;
+    ADD CONSTRAINT `issuingrules_ibfk_2` FOREIGN KEY (`itemtype`) REFERENCES 
`itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE;
 
 -- 
 -- Contraintes pour la table `items`
 -- 
 ALTER TABLE `items`
-  ADD CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES 
`biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES 
`biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `items`
-  ADD CONSTRAINT `items_ibfk_1` FOREIGN KEY (`biblioitemnumber`) REFERENCES 
`biblioitems` (`biblioitemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD 
CONSTRAINT `items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` 
(`branchcode`) ON UPDATE CASCADE;
+    ADD CONSTRAINT `items_ibfk_2` FOREIGN KEY (`holdingbranch`) REFERENCES 
`branches` (`branchcode`) ON UPDATE CASCADE;
 
 -- 
 -- Contraintes pour la table `reserves`
 -- 
 ALTER TABLE `reserves`
-  ADD CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES 
`borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES 
`borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `reserves`
-  ADD CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES 
`borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD 
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` 
(`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES 
`biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `reserves`
-  ADD CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES 
`borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD 
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` 
(`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT 
`reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) 
ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES 
`items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `reserves`
-  ADD CONSTRAINT `reserves_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES 
`borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD 
CONSTRAINT `reserves_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` 
(`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT 
`reserves_ibfk_3` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) 
ON DELETE CASCADE ON UPDATE CASCADE,  ADD CONSTRAINT `reserves_ibfk_4` FOREIGN 
KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON 
UPDATE CASCADE;
+   ADD CONSTRAINT `reserves_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES 
`branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
 
 -- 
 -- Contraintes pour la table `shelfcontents`
 -- 
 ALTER TABLE `shelfcontents`
-  ADD CONSTRAINT `shelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES 
`bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
+  ADD CONSTRAINT `shelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES 
`bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE `shelfcontents`
-  ADD CONSTRAINT `shelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES 
`bookshelf` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,  ADD 
CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` 
(`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
+    ADD CONSTRAINT `shelfcontents_ibfk_2` FOREIGN KEY (`itemnumber`) 
REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
[Prev in Thread]
Current Thread
[Next in Thread]
[Koha-cvs] koha/installer kohastructure.sql [rel_3_0], Ryan Higgins <=
- [Koha-cvs] koha/installer kohastructure.sql [rel_3_0], Ryan Higgins, 2007/03/04
Prev by Date: [Koha-cvs] koha/tools koha-news.pl [rel_3_0]
Next by Date: [Koha-cvs] koha/misc/sql-datas/en/mandatory 01_auth_types.... [rel_3_0]
Previous by thread: [Koha-cvs] koha/tools koha-news.pl [rel_3_0]
Next by thread: [Koha-cvs] koha/installer kohastructure.sql [rel_3_0]
Index(es):
- Date
- Thread