[Cwispy-devel] cwispy2/dbdump cwispy2-mysql-schema.sql,1.56,1.57

[Martin J. G. <mor...@us...>]

Update of /cvsroot/cwispy/cwispy2/dbdump
In directory sc8-pr-cvs4.sourceforge.net:/tmp/cvs-serv20400

Modified Files:
	cwispy2-mysql-schema.sql 
Log Message:
we need seq tables where data is prefilled, else it will bomb on trying to edit/add data to those tables

Index: cwispy2-mysql-schema.sql
===================================================================
RCS file: /cvsroot/cwispy/cwispy2/dbdump/cwispy2-mysql-schema.sql,v
retrieving revision 1.56
retrieving revision 1.57
diff -u -d -r1.56 -r1.57
--- cwispy2-mysql-schema.sql	30 Nov 2007 13:34:10 -0000	1.56
+++ cwispy2-mysql-schema.sql	13 Mar 2008 18:04:17 -0000	1.57
@@ -217,6 +217,21 @@
 INSERT INTO customertype VALUES (6,'Public Limited Company', 7);
 
 #
+# Table structure for 'customertype_seq
+#
+
+CREATE TABLE `customertype_seq` (
+  `sequence` int(11) NOT NULL auto_increment,
+  PRIMARY KEY  (`sequence`)
+) ENGINE=InnoDB AUTO_INCREMENT=2;
+
+#
+# Dumping data for table 'customertype_seq'
+#
+
+INSERT INTO `customertype_seq` VALUES (6);
+
+#
 # Table structure for table 'events'
 #
 
@@ -252,6 +267,21 @@
 INSERT INTO eventtype VALUES (4,'Other');
 
 #
+# Table structure for 'eventtyoe_seq'
+#
+
+CREATE TABLE `eventtype_seq` (
+  `sequence` int(11) NOT NULL auto_increment,
+  PRIMARY KEY  (`sequence`)
+) ENGINE=InnoDB AUTO_INCREMENT=2;
+
+#
+# Data for 'eventtype_seq'
+#
+
+INSERT INTO `eventtype_seq` VALUES (4);
+
+#
 # Table structure for table 'invoiceitems'
 #
 
@@ -372,6 +402,21 @@
 INSERT INTO `paymenttype` VALUES ('4','PayPal');
 
 #
+# Table structure for paymenttype_seq
+#
+
+CREATE TABLE `paymenttype_seq` (
+  `sequence` int(11) NOT NULL auto_increment,
+  PRIMARY KEY  (`sequence`)
+) ENGINE=InnoDB AUTO_INCREMENT=2;
+
+#
+# Data for paymenttype_seq
+#
+
+INSERT INTO `paymenttype_seq` VALUES (4);
+
+#
 # Table structure for table 'paypalconfig'
 #
 
@@ -593,3 +638,14 @@
 #
 
 INSERT INTO users (userid, username, password, language) VALUES (1,'admin','$1$tuVqeul1$o0DpCAOByooYBnm5tOAe71','English.php');
+
+# Table structure for users_seq
+
+CREATE TABLE `users_seq` (
+  `sequence` int(11) NOT NULL auto_increment,
+  PRIMARY KEY  (`sequence`)
+) ENGINE=InnoDB AUTO_INCREMENT=2;
+
+# Data
+
+INSERT INTO `users_seq` VALUES (1);