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

(-)a/installer/data/mysql/kohastructure.sql (-7 / +6 lines)
Lines 1349-1355 CREATE TABLE `printers` ( Link Here
1349
  `printername` varchar(40) NOT NULL default '',
1349
  `printername` varchar(40) NOT NULL default '',
1350
  `printqueue` varchar(20) default NULL,
1350
  `printqueue` varchar(20) default NULL,
1351
  `printtype` varchar(20) default NULL,
1351
  `printtype` varchar(20) default NULL,
1352
  PRIMARY KEY  (`printername`)
1352
  PRIMARY KEY (`printername`)
1353
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1353
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1354
1354
1355
--
1355
--
Lines 1441-1447 CREATE TABLE saved_reports ( Link Here
1441
   `report_id` int(11) default NULL,
1441
   `report_id` int(11) default NULL,
1442
   `report` longtext,
1442
   `report` longtext,
1443
   `date_run` datetime default NULL,
1443
   `date_run` datetime default NULL,
1444
   PRIMARY KEY  (`id`)
1444
   PRIMARY KEY (`id`)
1445
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1445
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1446
1446
1447
--
1447
--
Lines 1455-1461 CREATE TABLE `search_field` ( Link Here
1455
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
1455
  `label` varchar(255) NOT NULL COMMENT 'the human readable name of the field, for display',
1456
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
1456
  `type` ENUM('', 'string', 'date', 'number', 'boolean', 'sum') NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine',
1457
  PRIMARY KEY (`id`),
1457
  PRIMARY KEY (`id`),
1458
  UNIQUE KEY (`name` (191) )
1458
  UNIQUE KEY (`name` (191))
1459
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1459
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1460
1460
1461
--
1461
--
Lines 1474-1480 CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history Link Here
1474
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1474
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP, -- the date and time the search was run
1475
  KEY `userid` (`userid`),
1475
  KEY `userid` (`userid`),
1476
  KEY `sessionid` (`sessionid`),
1476
  KEY `sessionid` (`sessionid`),
1477
  PRIMARY KEY  (`id`)
1477
  PRIMARY KEY (`id`)
1478
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results';
1478
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Opac search history results';
1479
1479
1480
--
1480
--
Lines 1488-1494 CREATE TABLE `search_marc_map` ( Link Here
1488
  marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for',
1488
  marc_type ENUM('marc21', 'unimarc', 'normarc') NOT NULL COMMENT 'what MARC type this map is for',
1489
  marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field',
1489
  marc_field VARCHAR(255) NOT NULL COMMENT 'the MARC specifier for this field',
1490
  PRIMARY KEY(`id`),
1490
  PRIMARY KEY(`id`),
1491
  UNIQUE key(index_name, marc_field(191), marc_type),
1491
  UNIQUE key `index_name` (`index_name`, `marc_field` (191), `marc_type`),
1492
  INDEX (`index_name`)
1492
  INDEX (`index_name`)
1493
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1493
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1494
1494
Lines 1529-1535 CREATE TABLE `serial` ( -- issues related to subscriptions Link Here
1529
  `claimdate` date default NULL, -- date claimed
1529
  `claimdate` date default NULL, -- date claimed
1530
  claims_count int(11) default 0, -- number of claims made related to this issue
1530
  claims_count int(11) default 0, -- number of claims made related to this issue
1531
  `routingnotes` text, -- notes from the routing list
1531
  `routingnotes` text, -- notes from the routing list
1532
  PRIMARY KEY  (`serialid`)
1532
  PRIMARY KEY (`serialid`)
1533
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1533
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1534
1534
1535
--
1535
--
1536
- 

Return to bug 18336