11 lines
391 B
MySQL
11 lines
391 B
MySQL
|
CREATE TABLE IF NOT EXISTS Weeks (
|
||
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
||
|
|
number INTEGER NOT NULL CHECK (number > 0),
|
||
|
|
is_last_week INTEGER NOT NULL,
|
||
|
|
rendered_text VARCHAR NOT NULL,
|
||
|
|
raw_text VARCHAR NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
-- This is to upgrade from version 1.0 to 1.1 with an existing database
|
||
|
|
INSERT INTO Weeks (number, is_last_week, rendered_text, raw_text) VALUES (1, 1, "", "");
|