Skip to content
Snippets Groups Projects

Update Database creation script with fields

1 file
+ 6
2
Compare changes
  • Side-by-side
  • Inline
-- Created by Vertabelo (http://vertabelo.com)
-- Last modification date: 2018-05-14 07:26:48.076
-- Last modification date: 2018-05-15 10:14:22.089
-- tables
-- Table: Availability
@@ -24,7 +24,9 @@ CREATE TABLE CourseEdition (
id int NOT NULL,
owner int NOT NULL,
course_code varchar(50) NOT NULL,
name varchar(255) NOT NULL,
teacher varchar(255) NOT NULL,
study_year int NOT NULL,
year int NOT NULL,
quarter int NOT NULL,
last_modified timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
@@ -176,10 +178,12 @@ CREATE TABLE User (
id int NOT NULL,
first_name varchar(255) NOT NULL,
last_name varchar(255) NOT NULL,
gender varchar(5) NULL,
netid varchar(100) NOT NULL,
email varchar(255) NOT NULL,
tshirt_gender char(1) NULL,
tshirt_size varchar(10) NULL,
gdpr_accepted bool NOT NULL DEFAULT false,
gdpr_time timestamp NULL
last_modified timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT id PRIMARY KEY (id)
Loading