1234567891011121314151617181920212223242526272829303132333435363738 |
- CREATE TABLE IF NOT EXISTS menus (
- id INTEGER PRIMARY KEY AUTOINCREMENT,
- entree VARCHAR(255) NOT NULL,
- plat VARCHAR(255) NOT NULL,
- dessert VARCHAR(255) NOT NULL,
- entree_alternative VARCHAR(255) NOT NULL,
- plat_alternative VARCHAR(255) NOT NULL,
- dessert_alternative VARCHAR(255) NOT NULL,
- concerned_day DATE DEFAULT CURRENT_DATE
- );
- CREATE TABLE IF NOT EXISTS users (
- id INTEGER PRIMARY KEY AUTOINCREMENT,
- firstname VARCHAR(255) NOT NULL,
- lastname VARCHAR(255) NOT NULL,
- hashed_password VARCHAR(40) NOT NULL,
- society VARCHAR(255) DEFAULT "ovh",
- BP VARCHAR(5) NOT NULL,
- address VARCHAR(255) NOT NULL,
- administrator SMALLINT DEFAULT 0
- );
- CREATE TABLE IF NOT EXISTS orders (
- id INTEGER PRIMARY KEY AUTOINCREMENT,
- id_user INTEGER NOT NULL,
- entree VARCHAR(255) NOT NULL,
- plat VARCHAR(255) NOT NULL,
- dessert VARCHAR(255) NOT NULL,
- comments TEXT,
- concerned_day DATE DEFAULT CURRENT_DATE
- );
- CREATE TABLE IF NOT EXISTS config (
- key VARCHAR(255) NOT NULL,
- value VARCHAR(255) NOT NULL
- );
|