View | Details | Raw Unified | Return to bug 11944
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-6 / +5 lines)
Lines 482-488 CREATE TABLE collections ( Link Here
482
  colDesc text NOT NULL,
482
  colDesc text NOT NULL,
483
  colBranchcode varchar(4) DEFAULT NULL comment 'branchcode for branch where item should be held.',
483
  colBranchcode varchar(4) DEFAULT NULL comment 'branchcode for branch where item should be held.',
484
  PRIMARY KEY (colId)
484
  PRIMARY KEY (colId)
485
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
485
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
486
486
487
--
487
--
488
-- Table: collections_tracking
488
-- Table: collections_tracking
Lines 493-499 CREATE TABLE collections_tracking ( Link Here
493
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
493
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
494
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
494
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
495
  PRIMARY KEY (collections_tracking_id)
495
  PRIMARY KEY (collections_tracking_id)
496
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
496
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
497
497
498
--
498
--
499
-- Table structure for table `courses`
499
-- Table structure for table `courses`
Lines 957-963 CREATE TABLE `export_format` ( Link Here
957
  `encoding` varchar(255) NOT NULL,
957
  `encoding` varchar(255) NOT NULL,
958
  `type` varchar(255) DEFAULT 'marc',
958
  `type` varchar(255) DEFAULT 'marc',
959
  PRIMARY KEY  (`export_format_id`)
959
  PRIMARY KEY  (`export_format_id`)
960
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used for CSV export';
960
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used for CSV export';
961
961
962
962
963
--
963
--
Lines 1917-1923 CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history Link Here
1917
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1917
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1918
  KEY `userid` (`userid`),
1918
  KEY `userid` (`userid`),
1919
  KEY `sessionid` (`sessionid`)
1919
  KEY `sessionid` (`sessionid`)
1920
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opac search history results';
1920
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Opac search history results';
1921
1921
1922
1922
1923
--
1923
--
Lines 2982-2988 CREATE TABLE `aqcontract` ( Link Here
2982
  PRIMARY KEY  (`contractnumber`),
2982
  PRIMARY KEY  (`contractnumber`),
2983
  CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
2983
  CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
2984
       REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2984
       REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2985
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2985
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
2986
2986
2987
--
2987
--
2988
-- Table structure for table `aqorders`
2988
-- Table structure for table `aqorders`
2989
- 

Return to bug 11944