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

(-)a/installer/data/mysql/kohastructure.sql (-14 / +13 lines)
Lines 899-908 CREATE TABLE `import_records` ( Link Here
899
-- Table structure for `import_record_matches`
899
-- Table structure for `import_record_matches`
900
--
900
--
901
DROP TABLE IF EXISTS `import_record_matches`;
901
DROP TABLE IF EXISTS `import_record_matches`;
902
CREATE TABLE `import_record_matches` (
902
CREATE TABLE `import_record_matches` ( -- matches found when importing a batch of records
903
  `import_record_id` int(11) NOT NULL,
903
  `import_record_id` int(11) NOT NULL, -- the id given to the imported bib record (import_records.import_record_id)
904
  `candidate_match_id` int(11) NOT NULL,
904
  `candidate_match_id` int(11) NOT NULL, -- the biblio the imported record matches (biblio.biblionumber)
905
  `score` int(11) NOT NULL default 0,
905
  `score` int(11) NOT NULL default 0, -- the match score
906
  CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`)
906
  CONSTRAINT `import_record_matches_ibfk_1` FOREIGN KEY (`import_record_id`)
907
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
907
             REFERENCES `import_records` (`import_record_id`) ON DELETE CASCADE ON UPDATE CASCADE,
908
  KEY `record_score` (`import_record_id`, `score`)
908
  KEY `record_score` (`import_record_id`, `score`)
Lines 1710-1725 CREATE TABLE `roadtype` ( -- road types defined in administration and used in pa Link Here
1710
--
1710
--
1711
1711
1712
DROP TABLE IF EXISTS `saved_sql`;
1712
DROP TABLE IF EXISTS `saved_sql`;
1713
CREATE TABLE saved_sql (
1713
CREATE TABLE saved_sql ( -- saved reports
1714
   `id` int(11) NOT NULL auto_increment,
1714
   `id` int(11) NOT NULL auto_increment, -- unique id and primary key assigned by Koha
1715
   `borrowernumber` int(11) default NULL,
1715
   `borrowernumber` int(11) default NULL, -- the staff member who created this report (borrowers.borrowernumber)
1716
   `date_created` datetime default NULL,
1716
   `date_created` datetime default NULL, -- the date this report was created
1717
   `last_modified` datetime default NULL,
1717
   `last_modified` datetime default NULL, -- the date this report was last edited
1718
   `savedsql` text,
1718
   `savedsql` text, -- the SQL for this report
1719
   `last_run` datetime default NULL,
1719
   `last_run` datetime default NULL,
1720
   `report_name` varchar(255) default NULL,
1720
   `report_name` varchar(255) default NULL, -- the name of this report
1721
   `type` varchar(255) default NULL,
1721
   `type` varchar(255) default NULL, -- always 1 for tabular
1722
   `notes` text,
1722
   `notes` text, -- the notes or description given to this report
1723
   `cache_expiry` int NOT NULL default 300,
1723
   `cache_expiry` int NOT NULL default 300,
1724
   `public` boolean NOT NULL default FALSE,
1724
   `public` boolean NOT NULL default FALSE,
1725
   PRIMARY KEY  (`id`),
1725
   PRIMARY KEY  (`id`),
1726
- 

Return to bug 6716