[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
 #