bif-doc-table-projects - project current meta data
0.1.0_18 (2014-05-04)
#!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 )
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.
projects
projects_tree
Modified on INSERT, UPDATE, and DELETE.
projects_tomerge
Cascading DELETEs.
updates
bif-doc-func-new-project, bif-doc-table-topics, bif-doc-table-projects-tomerge, bif-doc-table-project-status, bif-doc-table-projects-tree, bif-doc-table-updates
Mark Lawrence <nomad@null.net>
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.
To install App::bif, copy and paste the appropriate command in to your terminal.
cpanm
cpanm App::bif
CPAN shell
perl -MCPAN -e shell install App::bif
For more information on module installation, please visit the detailed CPAN module installation guide.