1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| CREATE TABLE table
(
id INTEGER,
champ1 INTEGER,
champ2 INTEGER
);
CREATE TABLE type
(
id INTEGER UNIQUE,
category_id INTEGER NOT NULL,
is_activated BOOLEAN DEFAULT false NOT NULL,
created_at DATETIME NOT NULL,
updated_at DATETIME NOT NULL
);
CREATE TABLE category
(
id INTEGER,
name VARCHAR(255),
description TEXT NOT NULL,
is_activated BOOLEAN DEFAULT false NOT NULL,
created_at DATETIME NOT NULL,
updated_at DATETIME NOT NULL
);
ALTER TABLE table ADD FOREIGN KEY (champ1,champ2) REFERENCES type (id,id);
ALTER TABLE type ADD FOREIGN KEY (category_id) REFERENCES category (id); |
Partager