[Koha-cvs] CVS: koha/updater updatedatabase,1.92,1.93

[Paul POULAIN]

Update of /cvsroot/koha/koha/updater
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29694/updater

Modified Files:
        updatedatabase 
Log Message:
bugfixes

Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.92
retrieving revision 1.93
diff -C2 -r1.92 -r1.93
*** updatedatabase      6 Aug 2004 16:38:42 -0000       1.92
--- updatedatabase      12 Aug 2004 14:50:50 -0000      1.93
***************
*** 302,305 ****
--- 302,306 ----
                                isbn char(10) default NULL,
                                mailoverseeing smallint(1) default 0,
+                               biblionumber int(11) default NULL,
                                PRIMARY KEY  (suggestionnumber),
                                KEY suggestedby (suggestedby),
***************
*** 336,340 ****
                                                numberingmethod varchar(100) 
default '',
                                                notes text,
-                                               arrivalplanified varchar(100) 
NOT NULL default '',
                                                status varchar(100) NOT NULL 
default '',
                                                add1 int(11) default 0,
--- 337,340 ----
***************
*** 358,383 ****
                                                PRIMARY KEY  (subscriptionid)
                                                )",
- #                                             seqnum1 int(11) default '0',
- #                                             startseqnum1 int(11) default 
'0',
- #                                             seqtype1 int(11) default '0',
- #                                             freq1 int(11) default '0',
- #                                             step1 int(11) default '0',
- #                                             seqnum2 int(11) default '0',
- #                                             step2 int(11) default '0',
- #                                             startseqnum2 int(11) default 
'0',
- #                                             freq2 int(11) default '0',
- #                                             seqtype2 int(11) default '0',
- #                                             seqnum3 int(11) default '0',
- #                                             freq3 int(11) default '0',
- #                                             notes varchar(100) NOT NULL 
default '',
- #                                             step3 int(11) default '0',
- #                                             pos3 int(11) NOT NULL default 
'0',
- #                                             pos2 int(11) NOT NULL default 
'0',
- #                                             pos1 int(11) NOT NULL default 
'0',
- #                                             seqtype3 int(11) default '0',
- 
        subscriptionhistory => "(biblionumber int(11) NOT NULL default '0',
                                                        subscriptionid int(11) 
NOT NULL default '0',
!                                                       startdate date NOT NULL 
default '0000-00-00',
                                                        enddate date default 
'0000-00-00',
                                                        missinglist longtext 
NOT NULL,
--- 358,364 ----
                                                PRIMARY KEY  (subscriptionid)
                                                )",
        subscriptionhistory => "(biblionumber int(11) NOT NULL default '0',
                                                        subscriptionid int(11) 
NOT NULL default '0',
!                                                       histstartdate date NOT 
NULL default '0000-00-00',
                                                        enddate date default 
'0000-00-00',
                                                        missinglist longtext 
NOT NULL,
***************
*** 1388,1391 ****
--- 1369,1375 ----
  
  # $Log$
+ # Revision 1.93  2004/08/12 14:50:50  tipaul
+ # bugfixes
+ #
  # Revision 1.92  2004/08/06 16:38:42  tipaul
  # changing DB structure to calculate next issue number.