Mercurial Mercurial > poweradmin / comparison
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
docs/poweradmin-pgsql-db-structure.sql
changeset 113 e7a448dba024
parent 106 41d05ff53708
child 118 839a18931017
equal deleted inserted replaced
112:0e5d362abf5a 113:e7a448dba024 
     7   description text NOT NULL,
 
     7   description text NOT NULL,
 
     8   perm_templ integer default 0,
 
     8   perm_templ integer default 0,
 
     9   active smallint default 0
 
     9   active smallint default 0
 
    10 );
 
    10 );
 
    11 
    11 
    12 INSERT INTO users VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3','Administrator','admin@example.net','Administrator with full rights.',1,1);
 
    12 INSERT INTO users (username, password, fullname, email, description, perm_templ, active) VALUES ('admin','21232f297a57a5a743894a0e4a801fc3','Administrator','admin@example.net','Administrator with full rights.',1,1);
 
    13 
    13 
    14 CREATE TABLE perm_items (
 
    14 CREATE TABLE perm_items (
 
    15   id SERIAL PRIMARY KEY,
 
    15   id SERIAL PRIMARY KEY,
 
    16   name varchar(64) NOT NULL,
 
    16   name varchar(64) NOT NULL,
 
    17   descr text NOT NULL
 
    17   descr text NOT NULL
 
    18 );
 
    18 );
 
    19 
    19 
    20 INSERT INTO perm_items VALUES (41,'zone_master_add','User is allowed to add new master zones.'),(42,'zone_slave_add','User is allowed to add new slave zones.'),(43,'zone_content_view_own','User is allowed to see the content and meta data of zones he owns.'),(44,'zone_content_edit_own','User is allowed to edit the content of zones he owns.'),(45,'zone_meta_edit_own','User is allowed to edit the meta data of zones he owns.'),(46,'zone_content_view_others','User is allowed to see the content and meta data of zones he does not own.'),(47,'zone_content_edit_others','User is allowed to edit the content of zones he does not own.'),(48,'zone_meta_edit_others','User is allowed to edit the meta data of zones he does not own.'),(49,'search','User is allowed to perform searches.'),(50,'supermaster_view','User is allowed to view supermasters.'),(51,'supermaster_add','User is allowed to add new supermasters.'),(52,'supermaster_edit','User is allowed to edit supermasters.'),(53,'user_is_ueberuser','User has full access. God-like. Redeemer.'),(54,'user_view_others','User is allowed to see other users and their details.'),(55,'user_add_new','User is allowed to add new users.'),(56,'user_edit_own','User is allowed to edit their own details.'),(57,'user_edit_others','User is allowed to edit other users.'),(58,'user_passwd_edit_others','User is allowed to edit the password of other users.'),(59,'user_edit_templ_perm','User is allowed to change the permission template that is assigned to a user.'),(60,'templ_perm_add','User is allowed to add new permission templates.'),(61,'templ_perm_edit','User is allowed to edit existing permission templates.');
 
    20 INSERT INTO perm_items (name, descr) VALUES ('user_is_ueberuser','User has full access. God-like. Redeemer.'),('zone_master_add','User is allowed to add new master zones.'),('zone_slave_add','User is allowed to add new slave zones.'),('zone_content_view_own','User is allowed to see the content and meta data of zones he owns.'),('zone_content_edit_own','User is allowed to edit the content of zones he owns.'),('zone_meta_edit_own','User is allowed to edit the meta data of zones he owns.'),('zone_content_view_others','User is allowed to see the content and meta data of zones he does not own.'),('zone_content_edit_others','User is allowed to edit the content of zones he does not own.'),('zone_meta_edit_others','User is allowed to edit the meta data of zones he does not own.'),('search','User is allowed to perform searches.'),('supermaster_view','User is allowed to view supermasters.'),('supermaster_add','User is allowed to add new supermasters.'),('supermaster_edit','User is allowed to edit supermasters.'),('user_view_others','User is allowed to see other users and their details.'),('user_add_new','User is allowed to add new users.'),('user_edit_own','User is allowed to edit their own details.'),('user_edit_others','User is allowed to edit other users.'),('user_passwd_edit_others','User is allowed to edit the password of other users.'),('user_edit_templ_perm','User is allowed to change the permission template that is assigned to a user.'),('templ_perm_add','User is allowed to add new permission templates.'),('templ_perm_edit','User is allowed to edit existing permission templates.');
 
    21 
    21 
    22 CREATE TABLE perm_templ (
 
    22 CREATE TABLE perm_templ (
 
    23   id SERIAL PRIMARY KEY,
 
    23   id SERIAL PRIMARY KEY,
 
    24   name varchar(128) NOT NULL,
 
    24   name varchar(128) NOT NULL,
 
    25   descr text NOT NULL
 
    25   descr text NOT NULL
 
    26 );
 
    26 );
 
    27 
    27 
    28 INSERT INTO perm_templ VALUES (1,'Administrator','Administrator template with full rights.');
 
    28 INSERT INTO perm_templ (name, descr) VALUES ('Administrator','Administrator template with full rights.');
 
    29 
    29 
    30 CREATE TABLE perm_templ_items (
 
    30 CREATE TABLE perm_templ_items (
 
    31   id SERIAL PRIMARY KEY,
 
    31   id SERIAL PRIMARY KEY,
 
    32   templ_id integer NOT NULL,
 
    32   templ_id integer NOT NULL,
 
    33   perm_id integer NOT NULL
 
    33   perm_id integer NOT NULL
 
    34 );
 
    34 );
 
    35 
    35 
    36 INSERT INTO perm_templ_items VALUES (249,1,53);
 
    36 INSERT INTO perm_templ_items (templ_id, perm_id) VALUES (1,1);
 
    37 
    37 
    38 CREATE TABLE zones (
 
    38 CREATE TABLE zones (
 
    39   id SERIAL PRIMARY KEY,
 
    39   id SERIAL PRIMARY KEY,
 
    40   domain_id integer default 0,
 
    40   domain_id integer default 0,
 
    41   owner integer default 0,
 
    41   owner integer default 0,
poweradmin