[Koha-cvs] koha/misc/sql-datas/en/mandatory kohatables.sql [rel

koha-cvs
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-cvs] koha/misc/sql-datas/en/mandatory kohatables.sql [rel_TG]

From:	Tumer Garip
Subject:	[Koha-cvs] koha/misc/sql-datas/en/mandatory kohatables.sql [rel_TG]
Date:	Sat, 05 May 2007 13:07:35 +0000
CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_TG
Changes by:     Tumer Garip <tgarip1957>        07/05/05 13:07:35

Modified files:
        misc/sql-datas/en/mandatory: kohatables.sql 

Log message:
        Koha tables mysql5 compliant

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/sql-datas/en/mandatory/kohatables.sql?cvsroot=koha&only_with_tag=rel_TG&r1=1.1.2.2&r2=1.1.2.3

Patches:
Index: kohatables.sql
===================================================================
RCS file: /sources/koha/koha/misc/sql-datas/en/mandatory/Attic/kohatables.sql,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -b -r1.1.2.2 -r1.1.2.3
--- kohatables.sql      11 Apr 2007 11:54:04 -0000      1.1.2.2
+++ kohatables.sql      5 May 2007 13:07:35 -0000       1.1.2.3
@@ -1,25 +1,55 @@
-DROP DATABASE IF EXISTS `koha`;
-CREATE DATABASE `koha`;
-USE  `kohatest`;
+-- MySQL dump 10.11
+--
+-- Host: localhost    Database: koha
+-- ------------------------------------------------------
+-- Server version      5.0.37-community-nt
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, 
FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `access_counters`
+--
+
+DROP TABLE IF EXISTS `access_counters`;
+CREATE TABLE `access_counters` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `url` varchar(245) NOT NULL default '',
+  `counter` int(10) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `accountlines`
+--
+
 DROP TABLE IF EXISTS `accountlines`;
 CREATE TABLE `accountlines` (
   `borrowernumber` int(11) NOT NULL default '0',
   `accountno` smallint(6) NOT NULL default '0',
   `itemnumber` int(11) default NULL,
-  `date` date default NULL,
+  `dates` date default NULL,
   `amount` decimal(28,6) default NULL,
   `description` text character set utf8,
   `dispute` text character set utf8,
   `accounttype` varchar(5) character set utf8 default NULL,
   `amountoutstanding` decimal(28,6) default NULL,
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `offset` int(10) unsigned default NULL,
   `accountid` bigint(20) unsigned NOT NULL auto_increment,
   PRIMARY KEY  (`accountid`),
   KEY `acctsborridx` (`borrowernumber`),
   KEY `offset` (`offset`),
   KEY `acct` (`accountno`)
-) ENGINE=MyISAM AUTO_INCREMENT=14045 DEFAULT CHARSET=utf8 
COLLATE=utf8_turkish_ci;
+) ENGINE=MyISAM AUTO_INCREMENT=15804 DEFAULT CHARSET=utf8 
COLLATE=utf8_turkish_ci;
 
 --
 -- Table structure for table `accountoffsets`
@@ -31,7 +61,7 @@
   `accountno` smallint(6) NOT NULL default '0',
   `offsetaccount` smallint(6) NOT NULL default '0',
   `offsetamount` decimal(28,6) default NULL,
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
@@ -40,16 +70,16 @@
 
 DROP TABLE IF EXISTS `action_logs`;
 CREATE TABLE `action_logs` (
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `user` varchar(45) NOT NULL default '',
   `module` varchar(45) NOT NULL default '',
-  `action` varchar(45) NOT NULL default '',
+  `actions` varchar(45) NOT NULL,
   `object` varchar(45) NOT NULL default '',
   `info` text NOT NULL,
   `id` int(10) unsigned NOT NULL auto_increment,
   PRIMARY KEY  (`id`),
-  KEY `time` (`timestamp`),
-  KEY `action` (`action`)
+  KEY `time` USING BTREE (`timestamped`),
+  KEY `action` USING BTREE (`actions`)
 ) ENGINE=MyISAM AUTO_INCREMENT=25661 DEFAULT CHARSET=utf8;
 
 --
@@ -139,7 +169,7 @@
   `nocalc` int(11) default NULL,
   `invoicedisc` decimal(3,2) default NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `aqbudget`
@@ -211,7 +241,7 @@
   `subscription` tinyint(1) default NULL,
   `serialid` varchar(30) default NULL,
   `basketno` int(11) default NULL,
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `rrp` decimal(13,2) default NULL,
   `ecost` decimal(13,2) default NULL,
   `gst` decimal(13,2) default NULL,
@@ -220,7 +250,7 @@
   `sort2` varchar(80) default NULL,
   `discount` decimal(3,2) NOT NULL default '0.00',
   PRIMARY KEY  (`ordernumber`)
-) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `attempted_contacts`
@@ -233,8 +263,9 @@
   `address` varchar(255) default NULL,
   `result` varchar(100) default NULL,
   `message` text,
-  `date` datetime default NULL,
-  KEY `borrowernumber` (`borrowernumber`)
+  `dates` datetime default NULL,
+  KEY `borrowernumber` (`borrowernumber`),
+  KEY `date` USING BTREE (`dates`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
@@ -246,8 +277,7 @@
   `authid` bigint(20) unsigned NOT NULL default '0',
   `authtypecode` varchar(10) NOT NULL default '',
   `datecreated` date NOT NULL default '0000-00-00',
-  `marc` blob NOT NULL,
-  `marcxml` text NOT NULL,
+  `marcxml` longtext NOT NULL,
   PRIMARY KEY  (`authid`),
   KEY `authority` (`authtypecode`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -318,7 +348,7 @@
   `lib` char(80) default NULL,
   PRIMARY KEY  (`id`),
   KEY `name` (`category`)
-) ENGINE=MyISAM AUTO_INCREMENT=4601 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=4665 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `biblio`
@@ -327,7 +357,7 @@
 DROP TABLE IF EXISTS `biblio`;
 CREATE TABLE `biblio` (
   `biblionumber` int(11) NOT NULL default '0',
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `frameworkcode` varchar(45) default '',
   `itemtype` varchar(45) default NULL,
   `marcxml` longtext NOT NULL,
@@ -376,7 +406,8 @@
   `seealso` text,
   `link` varchar(80) default NULL,
   PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
-  KEY `tab` (`frameworkcode`,`tab`)
+  KEY `tab` (`frameworkcode`,`tab`),
+  KEY `hidden` (`hidden`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
@@ -406,7 +437,7 @@
   `owner` char(80) default NULL,
   `category` char(1) default NULL,
   PRIMARY KEY  (`shelfnumber`)
-) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `borexp`
@@ -443,7 +474,7 @@
   `altsuburb` text,
   `altcity` text,
   `altphone` text,
-  `dateofbirth` date default NULL,
+  `dateofbirth` date default '0000-00-00',
   `branchcode` varchar(4) NOT NULL default '',
   `categorycode` varchar(2) default NULL,
   `dateenrolled` date default NULL,
@@ -476,7 +507,17 @@
   UNIQUE KEY `cardnumber` (`cardnumber`),
   KEY `borrowernumber` (`borrowernumber`),
   FULLTEXT KEY `names` (`surname`,`firstname`)
-) ENGINE=MyISAM AUTO_INCREMENT=25524 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=25845 DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `borrowers_to_borrowers`
+--
+
+DROP TABLE IF EXISTS `borrowers_to_borrowers`;
+CREATE TABLE `borrowers_to_borrowers` (
+  `borrower1` int(11) default NULL,
+  `borrower2` int(11) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `branchcategories`
@@ -536,6 +577,19 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
+-- Table structure for table `careers`
+--
+
+DROP TABLE IF EXISTS `careers`;
+CREATE TABLE `careers` (
+  `id_career` mediumint(9) NOT NULL auto_increment,
+  `id_institution` smallint(6) NOT NULL default '0',
+  `career_name` varchar(50) NOT NULL default '',
+  PRIMARY KEY  (`id_career`),
+  KEY `id_institution` (`id_institution`)
+) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
+
+--
 -- Table structure for table `categories`
 --
 
@@ -602,14 +656,14 @@
   `biblionumber` int(10) unsigned NOT NULL auto_increment,
   `itemtype` varchar(45) default NULL,
   `frameworkcode` varchar(45) default NULL,
-  `timestamp` timestamp NOT NULL default '0000-00-00 00:00:00',
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `marcxml` text,
   `title` varchar(245) default NULL,
   `author` varchar(245) default NULL,
   `isbn` varchar(45) default NULL,
   `issn` varchar(45) default NULL,
   PRIMARY KEY  (`biblionumber`)
-) ENGINE=MyISAM AUTO_INCREMENT=150916 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=164059 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `deletedborrowers`
@@ -675,7 +729,7 @@
 DROP TABLE IF EXISTS `deleteditems`;
 CREATE TABLE `deleteditems` (
   `itemnumber` int(11) NOT NULL default '0',
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `biblionumber` varchar(45) default NULL,
   `barcode` varchar(45) default NULL,
   `marcxml` text,
@@ -743,7 +797,8 @@
   `seealso` text,
   `link` varchar(80) default NULL,
   PRIMARY KEY  (`frameworkcode`,`tagfield`,`tagsubfield`),
-  KEY `tab` (`frameworkcode`,`tab`)
+  KEY `tab` (`frameworkcode`,`tab`),
+  KEY `hidden` (`hidden`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
@@ -776,16 +831,15 @@
   `issuingbranch` char(18) default NULL,
   `returndate` date default NULL,
   `lastreneweddate` date default NULL,
-  `return` char(4) default NULL,
   `renewals` tinyint(4) NOT NULL default '0',
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `issue_date` date default NULL,
   PRIMARY KEY  (`issid`),
   KEY `issuesborridx` (`borrowernumber`),
   KEY `issuesitemidx` (`itemnumber`),
-  KEY `bordate` (`borrowernumber`,`timestamp`),
-  KEY `duedate` (`date_due`)
-) ENGINE=MyISAM AUTO_INCREMENT=72433 DEFAULT CHARSET=utf8;
+  KEY `duedate` (`date_due`),
+  KEY `bordate` USING BTREE (`borrowernumber`,`timestamped`)
+) ENGINE=MyISAM AUTO_INCREMENT=94207 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `issuingrules`
@@ -819,14 +873,14 @@
   `itemnumber` int(11) NOT NULL default '0',
   `biblionumber` int(11) NOT NULL default '0',
   `barcode` varchar(20) default NULL,
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `marcxml` longtext NOT NULL,
   `ctype` varchar(45) NOT NULL default '',
   PRIMARY KEY  (`itemnumber`),
   UNIQUE KEY `itembarcodeidx` USING BTREE (`barcode`),
   KEY `itembibnoidx` (`biblionumber`),
-  KEY `timestamp` (`timestamp`),
-  KEY `ctype` (`ctype`)
+  KEY `ctype` (`ctype`),
+  KEY `timestamp` USING BTREE (`timestamped`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
@@ -862,7 +916,7 @@
   `intrashow` tinyint(1) unsigned zerofill NOT NULL default '0',
   PRIMARY KEY  (`id`),
   KEY `marctokoha` USING BTREE (`kohafield`)
-) ENGINE=MyISAM AUTO_INCREMENT=329 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=331 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `letter`
@@ -897,7 +951,7 @@
   PRIMARY KEY  (`id`),
   KEY `title` (`title`),
   KEY `isbn` (`isbn`)
-) ENGINE=MyISAM AUTO_INCREMENT=41672 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=50505 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `mediatypetable`
@@ -947,12 +1001,12 @@
   `title` varchar(250) NOT NULL default '',
   `edata` text,
   `lang` varchar(4) NOT NULL default '',
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `image` varchar(250) default NULL,
   `href` varchar(250) default NULL,
   `section` varchar(45) NOT NULL default '',
   PRIMARY KEY  (`idelectronic`)
-) ENGINE=MyISAM AUTO_INCREMENT=263 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=269 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `opac_news`
@@ -964,9 +1018,9 @@
   `title` varchar(250) NOT NULL default '',
   `new` text NOT NULL,
   `lang` varchar(4) NOT NULL default '',
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   PRIMARY KEY  (`idnew`)
-) ENGINE=MyISAM AUTO_INCREMENT=133 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=164 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `overduerules`
@@ -998,10 +1052,10 @@
   `phr_resultcount` int(11) NOT NULL default '0',
   `phr_ip` varchar(30) NOT NULL default '',
   `user` varchar(45) default NULL,
-  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `dates` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `actual` text NOT NULL,
   KEY `phr_ip` (`phr_ip`),
-  KEY `date` (`date`)
+  KEY `date` USING BTREE (`dates`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
@@ -1030,7 +1084,7 @@
   `title` varchar(50) NOT NULL default '',
   `description` text NOT NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `reserveconstraints`
@@ -1042,7 +1096,7 @@
   `reservedate` date NOT NULL default '0000-00-00',
   `biblionumber` int(11) NOT NULL default '0',
   `biblioitemnumber` int(11) default NULL,
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   KEY `borrowernumber` (`borrowernumber`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
@@ -1059,7 +1113,7 @@
   `rettime` datetime default NULL,
   `duetime` datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (`resid`)
-) ENGINE=MyISAM AUTO_INCREMENT=1642 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=2025 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `reserves`
@@ -1077,8 +1131,8 @@
   `cancellationdate` date default NULL,
   `reservenotes` text,
   `priority` smallint(6) default NULL,
-  `found` char(1) default NULL,
-  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `found` varchar(2) default NULL,
+  `timestamped` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `itemnumber` int(11) default NULL,
   `reservefrom` date NOT NULL default '0000-00-00',
   `reserveto` date NOT NULL default '0000-00-00',
@@ -1086,7 +1140,7 @@
   `reserveid` int(10) unsigned NOT NULL auto_increment,
   PRIMARY KEY  (`reserveid`),
   KEY `borrowernumber` (`borrowernumber`)
-) ENGINE=MyISAM AUTO_INCREMENT=728 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=1165 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `reviews`
@@ -1123,7 +1177,7 @@
   `serialid` int(11) NOT NULL auto_increment,
   `biblionumber` varchar(100) NOT NULL default '',
   `subscriptionid` varchar(100) NOT NULL default '',
-  `serialseq` varchar(100) NOT NULL default '',
+  `serialseq` varchar(100) default NULL,
   `status` tinyint(4) NOT NULL default '0',
   `planneddate` date NOT NULL default '0000-00-00',
   `notes` text NOT NULL,
@@ -1132,7 +1186,7 @@
   `itemnumber` int(10) unsigned NOT NULL default '0',
   `claimdate` date NOT NULL default '0000-00-00',
   PRIMARY KEY  (`serialid`)
-) ENGINE=MyISAM AUTO_INCREMENT=967 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=1562 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `sessions`
@@ -1148,6 +1202,22 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 --
+-- Table structure for table `shelf_requests`
+--
+
+DROP TABLE IF EXISTS `shelf_requests`;
+CREATE TABLE `shelf_requests` (
+  `idrequest` int(11) NOT NULL auto_increment,
+  `shelfnumber` int(11) NOT NULL default '0',
+  `request_name` varchar(50) NOT NULL default '',
+  `request_type` varchar(50) NOT NULL default '',
+  `status` varchar(50) NOT NULL default '',
+  `request_date` date NOT NULL default '0000-00-00',
+  `coments` varchar(250) NOT NULL default '',
+  PRIMARY KEY  (`idrequest`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
 -- Table structure for table `shelfcontents`
 --
 
@@ -1157,8 +1227,10 @@
   `itemnumber` int(11) NOT NULL default '0',
   `flags` int(11) default NULL,
   `biblionumber` varchar(20) NOT NULL default '',
+  `id` int(10) unsigned NOT NULL auto_increment,
+  PRIMARY KEY  (`id`),
   KEY `shelfnumber` (`shelfnumber`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `sms_messages`
@@ -1175,7 +1247,7 @@
   `user_phone` varchar(45) default NULL,
   PRIMARY KEY  (`smsid`),
   KEY `user` (`userid`)
-) ENGINE=MyISAM AUTO_INCREMENT=1161 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=2057 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `special_holidays`
@@ -1203,7 +1275,7 @@
   `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
   `branch` varchar(4) default NULL,
   `proccode` varchar(4) default NULL,
-  `value` double(16,4) default NULL,
+  `value` varchar(20) default NULL,
   `type` varchar(16) default NULL,
   `other` text,
   `usercode` varchar(10) default NULL,
@@ -1252,7 +1324,7 @@
   `whenmorethan1` int(11) default '0',
   `setto1` int(11) default NULL,
   `lastvalue1` int(11) default NULL,
-  `add2` int(11) default '0',
+  `add2` int(11) default NULL,
   `every2` int(11) default '0',
   `whenmorethan2` int(11) default '0',
   `setto2` int(11) default NULL,
@@ -1273,7 +1345,7 @@
   `letter` varchar(20) default NULL,
   `publisheddate` date default NULL,
   PRIMARY KEY  (`subscriptionid`)
-) ENGINE=MyISAM AUTO_INCREMENT=183 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=266 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `subscriptionhistory`
@@ -1323,7 +1395,7 @@
   `title` varchar(80) default NULL,
   `copyrightdate` smallint(6) default NULL,
   `publishercode` varchar(255) default NULL,
-  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update 
CURRENT_TIMESTAMP,
+  `dates` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `volumedesc` varchar(255) default NULL,
   `publicationyear` smallint(6) default '0',
   `place` varchar(255) default NULL,
@@ -1334,7 +1406,7 @@
   PRIMARY KEY  (`suggestionid`),
   KEY `suggestedby` (`suggestedby`),
   KEY `managedby` (`managedby`)
-) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
+) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;
 
 --
 -- Table structure for table `systempreferences`
@@ -1408,7 +1480,15 @@
   `server` varchar(45) NOT NULL default '',
   `operation` varchar(45) NOT NULL default '',
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=163746 DEFAULT CHARSET=utf8;
-
+) ENGINE=MyISAM AUTO_INCREMENT=13588 DEFAULT CHARSET=utf8;
+/*!40103 SET address@hidden */;
 
+/*!40101 SET address@hidden */;
+/*!40014 SET address@hidden */;
+/*!40014 SET address@hidden */;
+/*!40101 SET address@hidden */;
+/*!40101 SET address@hidden */;
+/*!40101 SET address@hidden */;
+/*!40111 SET address@hidden */;
 
+-- Dump completed on 2007-05-05 13:05:06
[Prev in Thread]
Current Thread
[Next in Thread]
[Koha-cvs] koha/misc/sql-datas/en/mandatory kohatables.sql [rel_TG], Tumer Garip <=
Prev by Date: [Koha-cvs] koha bookshelves/addbookbybiblionumber.pl catal... [rel_TG]
Next by Date: [Koha-cvs] koha/koha-tmpl/intranet-tmpl/npl/en/catalogue d... [rel_2_2]
Previous by thread: [Koha-cvs] koha bookshelves/addbookbybiblionumber.pl catal... [rel_TG]
Next by thread: [Koha-cvs] koha/koha-tmpl/intranet-tmpl/npl/en/catalogue d... [rel_2_2]
Index(es):
- Date
- Thread