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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +2 lines)
Lines 766-771 CREATE TABLE `article_requests` ( Link Here
766
  `patron_notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
766
  `patron_notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
767
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
767
  `status` enum('PENDING','PROCESSING','COMPLETED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
768
  `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
768
  `notes` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
769
  `format` enum('PHOTOCOPY', 'SCAN') NOT NULL DEFAULT 'PHOTOCOPY',
770
  `urls` MEDIUMTEXT,
769
  `created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL',
771
  `created_on` timestamp NULL DEFAULT NULL COMMENT 'Be careful with two timestamps in one table not allowing NULL',
770
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
772
  `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
771
  PRIMARY KEY (`id`),
773
  PRIMARY KEY (`id`),
772
- 

Return to bug 20472