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

(-)a/installer/data/mysql/kohastructure.sql (-7 / +6 lines)
Lines 1379-1385 CREATE TABLE `printers` ( Link Here
1379
  `printername` varchar(40) NOT NULL default '',
1379
  `printername` varchar(40) NOT NULL default '',
1380
  `printqueue` varchar(20) default NULL,
1380
  `printqueue` varchar(20) default NULL,
1381
  `printtype` varchar(20) default NULL,
1381
  `printtype` varchar(20) default NULL,
1382
  PRIMARY KEY  (`printername`)
1382
  PRIMARY KEY (`printername`)
1383
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1383
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1384
1384
1385
--
1385
--
Lines 1471-1477 CREATE TABLE saved_reports ( Link Here
1471
   `report_id` int(11) default NULL,
1471
   `report_id` int(11) default NULL,
1472
   `report` longtext,
1472
   `report` longtext,
1473
   `date_run` datetime default NULL,
1473
   `date_run` datetime default NULL,
1474
   PRIMARY KEY  (`id`)
1474
   PRIMARY KEY (`id`)
1475
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1475
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1476
1476
1477
--
1477
--
Lines 1485-1491 CREATE TABLE `search_field` ( Link Here
1485
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
1485
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
1486
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
1486
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
1487
  PRIMARY KEY (`id`),
1487
  PRIMARY KEY (`id`),
1488
  UNIQUE KEY (`name` (191) )
1488
  UNIQUE KEY (`name` (191))
1489
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1489
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1490
1490
1491
--
1491
--
Lines 1504-1510 CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history Link Here
1504
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1504
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1505
  KEY `userid` (`userid`),
1505
  KEY `userid` (`userid`),
1506
  KEY `sessionid` (`sessionid`),
1506
  KEY `sessionid` (`sessionid`),
1507
  PRIMARY KEY  (`id`)
1507
  PRIMARY KEY (`id`)
1508
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results';
1508
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results';
1509
1509
1510
--
1510
--
Lines 1518-1524 CREATE TABLE `search_marc_map` ( Link Here
1518
  marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for',
1518
  marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for',
1519
  marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field',
1519
  marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field',
1520
  PRIMARY KEY(`id`),
1520
  PRIMARY KEY(`id`),
1521
  UNIQUE key(index_name, marc_field(191), marc_type),
1521
  UNIQUE key `index_name` (`index_name`, `marc_field` (191), `marc_type`),
1522
  INDEX (`index_name`)
1522
  INDEX (`index_name`)
1523
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1523
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1524
1524
Lines 1559-1565 CREATE TABLE `serial` ( -- issues related to subscriptions Link Here
1559
  `claimdate` date default NULL, -- date claimed
1559
  `claimdate` date default NULL, -- date claimed
1560
  claims_count int(11) default 0, -- number of claims made related to this issue
1560
  claims_count int(11) default 0, -- number of claims made related to this issue
1561
  `routingnotes` text, -- notes from the routing list
1561
  `routingnotes` text, -- notes from the routing list
1562
  PRIMARY KEY  (`serialid`)
1562
  PRIMARY KEY (`serialid`)
1563
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1563
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1564
1564
1565
--
1565
--
1566
- 

Return to bug 18336