NAME

bif-sql-table-projects - project current meta data

VERSION

0.1.0 (yyyy-mm-dd)

DEFINITION

#!sqlite
CREATE TABLE projects (
    id integer NOT NULL PRIMARY KEY,
    parent_id integer,
    name varchar(40) NOT NULL,
    title varchar(1024) NOT NULL,
    path varchar collate nocase UNIQUE,
    status_id integer NOT NULL DEFAULT -1,
    FOREIGN KEY(id) REFERENCES topics(id)
        ON DELETE CASCADE
    FOREIGN KEY(parent_id) REFERENCES projects(id)
        ON DELETE CASCADE,
    FOREIGN KEY(status_id,id) REFERENCES project_status(id,project_id)
        DEFERRABLE INITIALLY DEFERRED
)

DESCRIPTION

Table projects contains the project-specific meta data for a topic. Rows should only be inserted into this table by func_new_project() and only updated by triggers on the projects_tomerge table. Deleting directly from this table is fine.

AFFECTED TABLES

• projects_tree

  Modified on INSERT, UPDATE, and DELETE.

• projects_tomerge

  Cascading DELETEs.

• updates

  Cascading DELETEs.

SEE ALSO

bif-sql-func-new-project, bif-sql-table-topics, bif-sql-table-projects-tomerge, bif-sql-table-project-status, bif-sql-table-projects-tree, bif-sql-table-updates

AUTHOR

Mark Lawrence <nomad@null.net>

COPYRIGHT AND LICENSE

Copyright 2013-2014 Mark Lawrence <nomad@null.net>

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.