-- DROP TABLE IF EXISTS share;
-- DROP TABLE IF EXISTS file;

CREATE TABLE IF NOT EXISTS share
(
    share_id    TEXT UNIQUE PRIMARY KEY NOT NULL,
    share_pwd   TEXT                    NULL,
    share_name  TEXT                    NOT NULL,
    folder      TEXT                    NULL,
    create_time TIMESTAMP               NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS file
(
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    share_id        TEXT NOT NULL,
    parent_file_id  TEXT NOT NULL,
    file_id         TEXT NOT NULL,
    type            TEXT NOT NULL,
    name            TEXT NOT NULL,
    alias           TEXT NULL,
    download_status INTEGER default 0,
    FOREIGN KEY (share_id) REFERENCES share (share_id)
);