nojima / carbon Goto Github PK

CREATE TABLE commits (
    id INTEGER NOT NULL,
    user_id INTEGER NOT NULL REFERENCES users (id) ON DELETE RESTRICT,
    created_at DATETIME NOT NULL,
    parent1_id INTEGER,
    parent2_id INTEGER,
    message TEXT,

    PRIMARY KEY (id, folder_id)
);

CREATE TABLE blobs (
    id INTEGER NOT NULL,
    document_id INTEGER NOT NULL REFERENCES documents (id) ON DELETE RESTRICT,
    title TEXT NOT NULL,
    content TEXT NOT NULL,

    PRIMARY KEY (id, folder_id)
);

CREATE TABLE documents (
    id INTEGER NOT NULL,

    PRIMARY KEY (id, folder_id)
);

CREATE TABLE tags (
    id INTEGER NOT NULL,
    name VARCHAR(255) NOT NULL,

    PRIMARY KEY (id, folder_id)
);

CREATE TABLE links (
    commit_id INTEGER NOT NULL REFERENCES commits (id) ON DELETE CASCADE,
    blob_id INTEGER NOT NULL REFERENCES blobs (id) ON DELETE CASCADE,

    PRIMARY KEY (commit_id, blob_id, folder_id)
);

CREATE TABLE taggings (
    blob_id INTEGER NOT NULL REFERENCES blobs (id) ON DELETE CASCADE,
    tag_id INTEGER NOT NULL REFERENCES tags (id) ON DELETE CASCADE,

    PRIMARY KEY (blob_id, tag_id, folder_id)
);

CREATE TABLE references (
    id INTEGER NOT NULL,
    folder_id INTEGER NOT NULL REFERENCES folders (id) ON DELETE CASCADE,
    commit_id INTEGER NOT NULL REFERENCES commits (id) ON DELETE CASCADE,
    name VARCHAR(255) NOT NULL,

    PRIMARY KEY (id, folder_id)
);