Code cleaning : POD added, GPL header added, SQL queries moved on modules.

[koha.git] / misc / koha.mysql

diff --git a/misc/koha.mysql b/misc/koha.mysql
index 2166a7f..a656b24 100644 (file)
--- a/misc/koha.mysql
+++ b/misc/koha.mysql
@@ -365,7 +365,7 @@ CREATE TABLE biblioitems (
   itemtype varchar(4) default NULL,
   isbn varchar(14) default NULL,
   issn varchar(9) default NULL,
-  dewey double(8,6) default NULL,
+  dewey varchar(50) default NULL,
   subclass char(3) default NULL,
   publicationyear smallint(6) default NULL,
   publishercode varchar(255) default NULL,
@@ -641,7 +641,7 @@ CREATE TABLE deletedbiblioitems (
   itemtype varchar(4) default NULL,
   isbn varchar(14) default NULL,
   issn varchar(9) default NULL,
-  dewey double(8,6) default NULL,
+  dewey varchar(50) default NULL,
   subclass char(3) default NULL,
   publicationyear smallint(6) default NULL,
   publishercode varchar(255) default NULL,
@@ -1160,7 +1160,7 @@ CREATE TABLE subscription (
   aqbudgetid int(11) default '0',
   weeklength tinyint(4) default '0',
   monthlength tinyint(4) default '0',
-  numberlength tinyint(4) default '0',
+  numberlength smallint(4) default '0',
   periodicity tinyint(4) default '0',
   dow varchar(100) default '',
   numberingmethod varchar(100) default '',