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

(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1219-1225 CREATE TABLE `bookings` ( Link Here
1219
  `end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking',
1219
  `end_date` datetime DEFAULT NULL COMMENT 'the end date of the booking',
1220
  `creation_date` timestamp DEFAULT current_timestamp() COMMENT 'the timestamp for when a booking was created',
1220
  `creation_date` timestamp DEFAULT current_timestamp() COMMENT 'the timestamp for when a booking was created',
1221
  `modification_date` timestamp DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the timestamp for when a booking has been updated',
1221
  `modification_date` timestamp DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'the timestamp for when a booking has been updated',
1222
  `status` enum('created', 'cancelled') NOT NULL DEFAULT 'created' COMMENT 'current status of the booking',
1222
  `status` enum('new', 'cancelled', 'completed') NOT NULL DEFAULT 'new' COMMENT 'current status of the booking',
1223
  PRIMARY KEY (`booking_id`),
1223
  PRIMARY KEY (`booking_id`),
1224
  KEY `patron_id` (`patron_id`),
1224
  KEY `patron_id` (`patron_id`),
1225
  KEY `biblio_id` (`biblio_id`),
1225
  KEY `biblio_id` (`biblio_id`),
1226
- 

Return to bug 37601