diff options
author | Preston Cody <codeman@gentoo.org> | 2007-03-14 01:07:40 +0000 |
---|---|---|
committer | Preston Cody <codeman@gentoo.org> | 2007-03-14 01:07:40 +0000 |
commit | 3ccfc5df101740e57743d1ad809b92a69e350492 (patch) | |
tree | fc3b34bf2303d183ea02d7c1ec25fafbfab38b43 /docs | |
parent | updating the database schemas. the additions may be temporary tables. (diff) | |
download | scire-3ccfc5df101740e57743d1ad809b92a69e350492.tar.gz scire-3ccfc5df101740e57743d1ad809b92a69e350492.tar.bz2 scire-3ccfc5df101740e57743d1ad809b92a69e350492.zip |
adding in default phpgacl db creation so as to avoid having those stupid setup.php pages.
svn path=/; revision=181
Diffstat (limited to 'docs')
-rw-r--r-- | docs/scire.sql | 217 |
1 files changed, 217 insertions, 0 deletions
diff --git a/docs/scire.sql b/docs/scire.sql index a839b78..cf6faea 100644 --- a/docs/scire.sql +++ b/docs/scire.sql @@ -1,6 +1,7 @@ CREATE DATABASE IF NOT EXISTS scire; GRANT SELECT, INSERT, UPDATE, DELETE ON scire.* TO 'hobbit' IDENTIFIED BY 'moria'; GRANT SELECT, INSERT, UPDATE, DELETE ON scire.* TO 'hobbit'@'localhost' IDENTIFIED BY 'moria'; +ALTER DATABASE scire DEFAULT CHARACTER SET latin1; USE scire; DROP TABLE IF EXISTS users; @@ -230,3 +231,219 @@ category VARCHAR(30), homepage VARCHAR(90), PRIMARY KEY (id) ) TYPE=MyISAM; + + +#########PHPGACL CODE########## +CREATE TABLE gacl_phpgacl ( + name VARCHAR(230) NOT NULL, + value VARCHAR(230) NOT NULL, + PRIMARY KEY (name) +); + +DELETE FROM gacl_phpgacl WHERE name='version'; + +INSERT INTO gacl_phpgacl (name,value) VALUES ('version','3.3.6'); + +DELETE FROM gacl_phpgacl WHERE name='schema_version'; + +INSERT INTO gacl_phpgacl (name,value) VALUES ('schema_version','2.1'); + +CREATE TABLE gacl_acl ( + id INTEGER NOT NULL DEFAULT 0, + section_value VARCHAR(230) NOT NULL DEFAULT 'system', + allow INTEGER NOT NULL DEFAULT 0, + enabled INTEGER NOT NULL DEFAULT 0, + return_value TEXT, + note TEXT, + updated_date INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (id) +); + +ALTER TABLE gacl_acl ADD INDEX gacl_enabled_acl (enabled); + +ALTER TABLE gacl_acl ADD INDEX gacl_section_value_acl (section_value); + +ALTER TABLE gacl_acl ADD INDEX gacl_updated_date_acl (updated_date); + +CREATE TABLE gacl_acl_sections ( + id INTEGER NOT NULL DEFAULT 0, + value VARCHAR(230) NOT NULL, + order_value INTEGER NOT NULL DEFAULT 0, + name VARCHAR(230) NOT NULL, + hidden INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (id) +); + +ALTER TABLE gacl_acl_sections ADD UNIQUE INDEX gacl_value_acl_sections (value); + +ALTER TABLE gacl_acl_sections ADD INDEX gacl_hidden_acl_sections (hidden); + +DELETE FROM gacl_acl_sections WHERE id=1 AND value='system'; + +INSERT INTO gacl_acl_sections (id,value,order_value,name) VALUES (1,'system',1,'System'); + +DELETE FROM gacl_acl_sections WHERE id=2 AND value='user'; + +INSERT INTO gacl_acl_sections (id,value,order_value,name) VALUES (2,'user',2,'User'); + +CREATE TABLE gacl_aco ( + id INTEGER NOT NULL DEFAULT 0, + section_value VARCHAR(240) NOT NULL DEFAULT '0', + value VARCHAR(240) NOT NULL, + order_value INTEGER NOT NULL DEFAULT 0, + name VARCHAR(255) NOT NULL, + hidden INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (id) +); + +ALTER TABLE gacl_aco ADD UNIQUE INDEX gacl_section_value_value_aco (section_value, value); + +ALTER TABLE gacl_aco ADD INDEX gacl_hidden_aco (hidden); + +CREATE TABLE gacl_aco_map ( + acl_id INTEGER NOT NULL DEFAULT 0, + section_value VARCHAR(230) NOT NULL DEFAULT '0', + value VARCHAR(230) NOT NULL, + PRIMARY KEY (acl_id, section_value, value) +); + +CREATE TABLE gacl_aco_sections ( + id INTEGER NOT NULL DEFAULT 0, + value VARCHAR(230) NOT NULL, + order_value INTEGER NOT NULL DEFAULT 0, + name VARCHAR(230) NOT NULL, + hidden INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (id) +); + +ALTER TABLE gacl_aco_sections ADD UNIQUE INDEX gacl_value_aco_sections (value); + +ALTER TABLE gacl_aco_sections ADD INDEX gacl_hidden_aco_sections (hidden); + +CREATE TABLE gacl_aro ( + id INTEGER NOT NULL DEFAULT 0, + section_value VARCHAR(240) NOT NULL DEFAULT '0', + value VARCHAR(240) NOT NULL, + order_value INTEGER NOT NULL DEFAULT 0, + name VARCHAR(255) NOT NULL, + hidden INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (id) +); + +ALTER TABLE gacl_aro ADD UNIQUE INDEX gacl_section_value_value_aro (section_value, value); + +ALTER TABLE gacl_aro ADD INDEX gacl_hidden_aro (hidden); + +CREATE TABLE gacl_aro_map ( + acl_id INTEGER NOT NULL DEFAULT 0, + section_value VARCHAR(230) NOT NULL DEFAULT '0', + value VARCHAR(230) NOT NULL, + PRIMARY KEY (acl_id, section_value, value) +); + +CREATE TABLE gacl_aro_sections ( + id INTEGER NOT NULL DEFAULT 0, + value VARCHAR(230) NOT NULL, + order_value INTEGER NOT NULL DEFAULT 0, + name VARCHAR(230) NOT NULL, + hidden INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (id) +); + +ALTER TABLE gacl_aro_sections ADD UNIQUE INDEX gacl_value_aro_sections (value); + +ALTER TABLE gacl_aro_sections ADD INDEX gacl_hidden_aro_sections (hidden); + +CREATE TABLE gacl_axo ( + id INTEGER NOT NULL DEFAULT 0, + section_value VARCHAR(240) NOT NULL DEFAULT '0', + value VARCHAR(240) NOT NULL, + order_value INTEGER NOT NULL DEFAULT 0, + name VARCHAR(255) NOT NULL, + hidden INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (id) +); + +ALTER TABLE gacl_axo ADD UNIQUE INDEX gacl_section_value_value_axo (section_value, value); + +ALTER TABLE gacl_axo ADD INDEX gacl_hidden_axo (hidden); + +CREATE TABLE gacl_axo_map ( + acl_id INTEGER NOT NULL DEFAULT 0, + section_value VARCHAR(230) NOT NULL DEFAULT '0', + value VARCHAR(230) NOT NULL, + PRIMARY KEY (acl_id, section_value, value) +); + +CREATE TABLE gacl_axo_sections ( + id INTEGER NOT NULL DEFAULT 0, + value VARCHAR(230) NOT NULL, + order_value INTEGER NOT NULL DEFAULT 0, + name VARCHAR(230) NOT NULL, + hidden INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (id) +); + +ALTER TABLE gacl_axo_sections ADD UNIQUE INDEX gacl_value_axo_sections (value); + +ALTER TABLE gacl_axo_sections ADD INDEX gacl_hidden_axo_sections (hidden); + +CREATE TABLE gacl_aro_groups ( + id INTEGER NOT NULL DEFAULT 0, + parent_id INTEGER NOT NULL DEFAULT 0, + lft INTEGER NOT NULL DEFAULT 0, + rgt INTEGER NOT NULL DEFAULT 0, + name VARCHAR(255) NOT NULL, + value VARCHAR(255) NOT NULL, + PRIMARY KEY (id, value) +); + +ALTER TABLE gacl_aro_groups ADD INDEX gacl_parent_id_aro_groups (parent_id); + +ALTER TABLE gacl_aro_groups ADD UNIQUE INDEX gacl_value_aro_groups (value); + +ALTER TABLE gacl_aro_groups ADD INDEX gacl_lft_rgt_aro_groups (lft, rgt); + +CREATE TABLE gacl_groups_aro_map ( + group_id INTEGER NOT NULL DEFAULT 0, + aro_id INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (group_id, aro_id) +); + +ALTER TABLE gacl_groups_aro_map ADD INDEX gacl_aro_id (aro_id); + +CREATE TABLE gacl_aro_groups_map ( + acl_id INTEGER NOT NULL DEFAULT 0, + group_id INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (acl_id, group_id) +); + +CREATE TABLE gacl_axo_groups ( + id INTEGER NOT NULL DEFAULT 0, + parent_id INTEGER NOT NULL DEFAULT 0, + lft INTEGER NOT NULL DEFAULT 0, + rgt INTEGER NOT NULL DEFAULT 0, + name VARCHAR(255) NOT NULL, + value VARCHAR(255) NOT NULL, + PRIMARY KEY (id, value) +); + +ALTER TABLE gacl_axo_groups ADD INDEX gacl_parent_id_axo_groups (parent_id); + +ALTER TABLE gacl_axo_groups ADD UNIQUE INDEX gacl_value_axo_groups (value); + +ALTER TABLE gacl_axo_groups ADD INDEX gacl_lft_rgt_axo_groups (lft, rgt); + +CREATE TABLE gacl_groups_axo_map ( + group_id INTEGER NOT NULL DEFAULT 0, + axo_id INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (group_id, axo_id) +); + +ALTER TABLE gacl_groups_axo_map ADD INDEX gacl_axo_id (axo_id); + +CREATE TABLE gacl_axo_groups_map ( + acl_id INTEGER NOT NULL DEFAULT 0, + group_id INTEGER NOT NULL DEFAULT 0, + PRIMARY KEY (acl_id, group_id) +); |