testdrive.db

CREATE TABLE tbl_user (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    username VARCHAR(128) NOT NULL,
    password VARCHAR(128) NOT NULL,
    email VARCHAR(128) NOT NULL
);

CREATE TABLE tbl_news (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    title VARCHAR(128) NOT NULL,
    content TEXT,
    published INTEGER NOT NULL,
    create_time TIMESTAMP NOT NULL,
    update_time TIMESTAMP,
    tags TEXT,
);

CREATE TABLE tbl_menu (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    ORDER INTEGER NOT NULL,
    title VARCHAR(128) NOT NULL,
    link TEXT NOT NULL,
    published BOOLEAN NOT NULL,
);