· 8 years ago · Feb 26, 2018, 11:56 AM
1CREATE TABLE IF NOT EXISTS `mydb`.`oppgave` (
2 `oppgave_ID` INT NOT NULL AUTO_INCREMENT,
3 `oppgavetekst` VARCHAR(255) NOT NULL,
4 `alt_1` VARCHAR(255) NOT NULL,
5 `alt_2` VARCHAR(255) NOT NULL,
6 `alt_3` VARCHAR(255) NULL,
7 `alt_4` VARCHAR(255) NULL,
8 `alt_5` VARCHAR(255) NULL,
9 `illustrasjon_link` VARCHAR(255) NULL,
10 `oppgave_type` VARCHAR(45) NOT NULL,
11 `alt_1_korrekt` TINYINT NULL,
12 `alt_2_korrekt` TINYINT NULL,
13 `alt_3_korrekt` TINYINT NULL,
14 `alt_4_korrekt` TINYINT NULL,
15 `alt_5_korrekt` TINYINT NULL,
16 PRIMARY KEY (`oppgave_ID`))