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

(-)a/installer/data/mysql/atomicupdate/bug_xxxxx_club_enrollments.date_created.sql (-1 / +1 lines)
Line 1 Link Here
1
ALTER TABLE club_enrollments MODIFY date_created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;
1
ALTER TABLE club_enrollments MODIFY date_created timestamp NOT NULL;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 4039-4045 CREATE TABLE IF NOT EXISTS club_enrollments ( Link Here
4039
  borrowernumber int(11) NOT NULL,
4039
  borrowernumber int(11) NOT NULL,
4040
  date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
4040
  date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
4041
  date_canceled timestamp NULL DEFAULT NULL,
4041
  date_canceled timestamp NULL DEFAULT NULL,
4042
  date_created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
4042
  date_created timestamp NULL DEFAULT NULL,
4043
  date_updated timestamp NULL DEFAULT NULL,
4043
  date_updated timestamp NULL DEFAULT NULL,
4044
  branchcode varchar(10) NULL DEFAULT NULL,
4044
  branchcode varchar(10) NULL DEFAULT NULL,
4045
  PRIMARY KEY (id),
4045
  PRIMARY KEY (id),
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +1 lines)
Lines 14198-14204 if( CheckVersion( $DBversion ) ) { Link Here
14198
          borrowernumber int(11) NOT NULL,
14198
          borrowernumber int(11) NOT NULL,
14199
          date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14199
          date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14200
          date_canceled timestamp NULL DEFAULT NULL,
14200
          date_canceled timestamp NULL DEFAULT NULL,
14201
          date_created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
14201
          date_created timestamp NULL DEFAULT NULL,
14202
          date_updated timestamp NULL DEFAULT NULL,
14202
          date_updated timestamp NULL DEFAULT NULL,
14203
          branchcode varchar(10) NULL DEFAULT NULL,
14203
          branchcode varchar(10) NULL DEFAULT NULL,
14204
          PRIMARY KEY (id),
14204
          PRIMARY KEY (id),
14205
- 

Return to bug 20175