1 -- Version 1 is the initial structure.
3 id INTEGER PRIMARY KEY,
4 version INTEGER NOT NULL UNIQUE,
9 id INTEGER PRIMARY KEY,
11 password TEXT NOT NULL, -- Hashed and salted.
16 id INTEGER PRIMARY KEY,
17 user_id
INTEGER NOT NULL,
19 estimate_time
INTEGER,
22 FOREIGN KEY(user_id
) REFERENCES User(id)
25 CREATE TABLE Quantity (
26 id INTEGER PRIMARY KEY,
31 CREATE TABLE Ingredient (
32 id INTEGER PRIMARY KEY,
35 input_step_id
INTEGER NOT NULL,
37 FOREIGN KEY(quantity_id
) REFERENCES Quantity(id),
38 FOREIGN KEY(input_step_id
) REFERENCES Step(id)
41 CREATE TABLE [Group] (
42 id INTEGER PRIMARY KEY,
47 id INTEGER PRIMARY KEY,
49 group_id
INTEGER NOT NULL,
51 FOREIGN KEY(group_id
) REFERENCES [Group](id)
54 CREATE TABLE IntermediateSubstance (
55 id INTEGER PRIMARY KEY,
58 output_step_id
INTEGER NOT NULL,
59 input_step_id
INTEGER NOT NULL,
61 FOREIGN KEY(quantity_id
) REFERENCES Quantity(id),
62 FOREIGN KEY(output_step_id
) REFERENCES Step(id),
63 FOREIGN KEY(input_step_id
) REFERENCES Step(id)