[Koha-cvs] koha/updater updatedatabase [rel_3_0]

[Bruno Toumi]

CVSROOT:	/sources/koha
Module name:	koha
Branch:		rel_3_0
Changes by:	Bruno Toumi <btoumi>	06/10/30 09:41:45

Modified files:
	updater        : updatedatabase 

Log message:
	remove auto increment for accountno in accountlines table

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/updater/updatedatabase?cvsroot=koha&only_with_tag=rel_3_0&r1=1.157.2.13&r2=1.157.2.14

Patches:
Index: updatedatabase
===================================================================
RCS file: /sources/koha/koha/updater/updatedatabase,v
retrieving revision 1.157.2.13
retrieving revision 1.157.2.14
diff -u -b -r1.157.2.13 -r1.157.2.14
--- updatedatabase	20 Oct 2006 10:35:05 -0000	1.157.2.13
+++ updatedatabase	30 Oct 2006 09:41:45 -0000	1.157.2.14
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: updatedatabase,v 1.157.2.13 2006/10/20 10:35:05 alaurin Exp $
+# $Id: updatedatabase,v 1.157.2.14 2006/10/30 09:41:45 btoumi Exp $
 
 # Database Updater
 # This script checks for required updates to the database.
@@ -198,12 +198,12 @@
  		     )",
 
    charges	=> "(
-			  charge_id varchar(5) NOT NULL default '',
-  			  description text NOT NULL,
-  			  amount decimal(28,6) NOT NULL default '0.000000',
-                          min int(4) NOT NULL default '0',
-  			  max int(4) NOT NULL default '0',
-                          level int(1) NOT NULL default '0',
+			  `charge_id` varchar(5) NOT NULL default '',
+  			  `description` text NOT NULL,
+  			  `amount` decimal(28,6) NOT NULL default '0.000000',
+                          `min` int(4) NOT NULL default '0',
+  			  `max` int(4) NOT NULL default '0',
+                          `level` int(1) NOT NULL default '0',
                           PRIMARY KEY  (`charge_id`)
  		     )",
 
@@ -218,6 +218,7 @@
 	auth_subfield_structure =>{ 'hidden' => 'TINYINT(3) NOT NULL default 0', 'kohafield' => 'VARCHAR(45) NOT NULL', 'linkid' =>  'TINYINT(1) NOT NULL default 0', 'isurl' => 'TINYINT(1)', 'frameworkcode'=>'VARCHAR(8) NOT  NULL'},
 	serial =>{ 'publisheddate' => 'date', 'itemnumber'=>'text NULL','routingnotes'=>'text NULL',},
     statistics => { 'associatedborrower' => 'integer'},
+    	 	
 #    tablename        => { 'field' => 'fieldtype' },
 );
 
@@ -408,12 +409,6 @@
 			default	=> '0',
 			extra	=> '',
 		},
-		{
-                       field   => 'accountno',
-                        type    => 'int(11)',
-                       null    => 'NOT NULL',
-		       extra   => 'auto_increment',
-	       },
 																							
 	],
 	
@@ -794,21 +789,22 @@
 	    {
 	        indexname => 'categorycode',
 	        content   => 'categorycode',
-	        type      => 'PRI',
+	       
 	    }
 	],
+ 	
 	itemtypes => [
 	    {
 	        indexname => 'itemtype',
 	        content   => 'itemtype',
-	        type => 'PRI',
+	        
 	    }
 	],
 	branches => [
 	    {
 	        indexname => 'branchcode',
 	        content   => 'branchcode',
-	        type      => 'PRI',
+	        
 	    }
 	]
 );
@@ -1670,6 +1666,9 @@
 $sth->execute;
 
 
+
+
+
 # MOVE all tables TO UTF-8 and innoDB
 $sth = $dbh->prepare("show table status");
 $sth->execute;
@@ -1860,6 +1859,9 @@
 exit;
 
 # $Log: updatedatabase,v $
+# Revision 1.157.2.14  2006/10/30 09:41:45  btoumi
+# remove auto increment for accountno in accountlines table
+#
 # Revision 1.157.2.13  2006/10/20 10:35:05  alaurin
 # new program : branchoverdues.pl
 #