[Koha-cvs] koha/installer kohastructure.sql

[Henri-Damien LAURENT]

CVSROOT:	/cvsroot/koha
Module name:	koha
Changes by:	Henri-Damien LAURENT <hdl>	07/07/11 12:08:09

Modified files:
	installer      : kohastructure.sql 

Log message:
	minor changes in SQL

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/installer/kohastructure.sql?cvsroot=koha&r1=1.7&r2=1.8

Patches:
Index: kohastructure.sql
===================================================================
RCS file: /cvsroot/koha/koha/installer/kohastructure.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -b -r1.7 -r1.8
--- kohastructure.sql	11 Jul 2007 10:27:11 -0000	1.7
+++ kohastructure.sql	11 Jul 2007 12:08:09 -0000	1.8
@@ -417,13 +417,13 @@
   `issn` varchar(9) default NULL,
   `dewey` varchar(30) default '',
   `subclass` varchar(3) default NULL,
-  `publicationyear` smallint(6) default NULL,
+  `publicationyear` text,
   `publishercode` varchar(255) default NULL,
   `volumedate` date default NULL,
-  `volumeddesc` varchar(255) default NULL,
-  `seriestitle` text NOT NULL,
-  `seriesissn` text NOT NULL,
-  `seriesvolume` text NOT NULL,
+  `volumeddesc` text,
+  `collectiontitle` mediumtext NOT NULL,
+  `collectionissn` text NOT NULL,
+  `collectionvolume` mediumtext NOT NULL,
   `editionstatement` text NOT NULL,
   `editionreponsability` text NOT NULL,
   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
@@ -433,7 +433,7 @@
   `size` varchar(255) default NULL,
   `place` varchar(255) default NULL,
   `lccn` varchar(25) default NULL,
-  `marc` blob,
+  `marc` longblob,
   `url` varchar(255) default NULL,
   `lcsort` varchar(25) default NULL,
   `ccode` varchar(4) default NULL,