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

(-)a/installer/data/mysql/kohastructure.sql (-6 / +5 lines)
Lines 502-508 CREATE TABLE collections ( Link Here
502
  colDesc text NOT NULL,
502
  colDesc text NOT NULL,
503
  colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.'
503
  colBranchcode varchar(10) DEFAULT NULL, -- 'branchcode for branch where item should be held.'
504
  PRIMARY KEY (colId)
504
  PRIMARY KEY (colId)
505
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
505
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
506
506
507
--
507
--
508
-- Constraints for table `collections`
508
-- Constraints for table `collections`
Lines 519-525 CREATE TABLE collections_tracking ( Link Here
519
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
519
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
520
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
520
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
521
  PRIMARY KEY (collections_tracking_id)
521
  PRIMARY KEY (collections_tracking_id)
522
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
522
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
523
523
524
--
524
--
525
-- Table structure for table `courses`
525
-- Table structure for table `courses`
Lines 983-989 CREATE TABLE `export_format` ( Link Here
983
  `encoding` varchar(255) NOT NULL,
983
  `encoding` varchar(255) NOT NULL,
984
  `type` varchar(255) DEFAULT 'marc',
984
  `type` varchar(255) DEFAULT 'marc',
985
  PRIMARY KEY  (`export_format_id`)
985
  PRIMARY KEY  (`export_format_id`)
986
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used for CSV export';
986
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used for CSV export';
987
987
988
988
989
--
989
--
Lines 1948-1954 CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history Link Here
1948
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1948
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1949
  KEY `userid` (`userid`),
1949
  KEY `userid` (`userid`),
1950
  KEY `sessionid` (`sessionid`)
1950
  KEY `sessionid` (`sessionid`)
1951
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opac search history results';
1951
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Opac search history results';
1952
1952
1953
1953
1954
--
1954
--
Lines 3031-3037 CREATE TABLE `aqcontract` ( Link Here
3031
  PRIMARY KEY  (`contractnumber`),
3031
  PRIMARY KEY  (`contractnumber`),
3032
  CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
3032
  CONSTRAINT `booksellerid_fk1` FOREIGN KEY (`booksellerid`)
3033
       REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3033
       REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3034
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3034
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
3035
3035
3036
--
3036
--
3037
-- Table structure for table `aqorders`
3037
-- Table structure for table `aqorders`
3038
- 

Return to bug 11944