From 213f1c2f4de5bc7f43ecd021438f281f1abad986 Mon Sep 17 00:00:00 2001
From: tipaul <tipaul>
Date: Mon, 18 Jul 2005 15:11:06 +0000
Subject: [PATCH] changing dewey to varchar(30)

---
 misc/koha.mysql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/misc/koha.mysql b/misc/koha.mysql
index 2166a7fc8b..bd64390e83 100644
--- 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,
-- 
2.39.5