cvs: pear /Perm_LiveUser/docs/examples/example3 demodata.sql /Perm_LiveUser/docs/examples/example4 demodata.sql
/Perm_LiveUser/docs/examples/example5 create_db.sql
| From: | Lukas Smith | Date: | Thu, 11 Mar 2004 12:26:43 +0000 |
| Subject: | cvs: pear /Perm_LiveUser/docs/examples/example3 demodata.sql /Perm_LiveUser/docs/examples/example4 demodata.sql /Perm_LiveUser/docs/examples/example5 create_db.sql |
||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-17301@lists.php.net to get a copy of this message | ||
lsmith Thu Mar 11 07:26:43 2004 EDT
Modified files:
/pear/Perm_LiveUser/docs/examples/example3 demodata.sql
/pear/Perm_LiveUser/docs/examples/example4 demodata.sql
/pear/Perm_LiveUser/docs/examples/example5 create_db.sql
Log:
- removed table creation of liveuser tables, use the generic sql files instead
http://cvs.php.net/diff.php/pear/Perm_LiveUser/docs/examples/example3/demodata.sql?r1=1.1&r2=1.2&ty=u Index: pear/Perm_LiveUser/docs/examples/example3/demodata.sql diff -u pear/Perm_LiveUser/docs/examples/example3/demodata.sql:1.1 pear/Perm_LiveUser/docs/examples/example3/demodata.sql:1.2 --- pear/Perm_LiveUser/docs/examples/example3/demodata.sql:1.1 Thu Feb 5 15:26:44 2004 +++ pear/Perm_LiveUser/docs/examples/example3/demodata.sql Thu Mar 11 07:26:41 2004 @@ -1,167 +1,4 @@ -# $Id: demodata.sql,v 1.1 2004/02/05 20:26:44 arnaud Exp $ - -# Creating tables ... - -CREATE TABLE liveuser_users ( -auth_user_id varchar(32) NOT NULL default '0', -handle varchar(32) NOT NULL default '', -passwd varchar(32) NOT NULL default '', -lastlogin datetime default NULL, -owner_user_id bigint UNSIGNED default NULL, -owner_group_id int(11) UNSIGNED default NULL, -is_active char(1) NOT NULL default 'N', -UNIQUE KEY auth_user_id (auth_user_id,handle), -KEY auth_user_id_2 (auth_user_id,handle)); - - -CREATE TABLE liveuser_applications( -application_id INT UNSIGNED DEFAULT 0 NOT NULL, -application_define_name VARCHAR(20) NOT NULL, -PRIMARY KEY (application_id), -UNIQUE UC_application_define_name (application_define_name)); - - -CREATE TABLE liveuser_areas( -area_id INT UNSIGNED DEFAULT 0 NOT NULL, -application_id INT UNSIGNED NOT NULL, -area_define_name VARCHAR(20) NOT NULL, -PRIMARY KEY (area_id), -UNIQUE UC_area_id (area_id), -INDEX IDX_liveuser_areas_application_id (application_id)); - - -CREATE TABLE liveuser_rights( -right_id INT UNSIGNED DEFAULT 0 NOT NULL, -area_id INT UNSIGNED NOT NULL, -right_define_name VARCHAR(50) NOT NULL, -has_implied CHAR(1) DEFAULT 'N' NOT NULL, -has_level CHAR(1) DEFAULT 'N' NOT NULL, -has_scope CHAR(1) DEFAULT 'N' NOT NULL, -PRIMARY KEY (right_id), -UNIQUE UC_right_id (right_id), -INDEX IDX_liveuser_rights_area_id (area_id)); - - -CREATE TABLE liveuser_right_scopes( -right_id INT UNSIGNED NOT NULL, -type TINYINT UNSIGNED DEFAULT 0 NOT NULL, -INDEX IDX_liveuser_right_scopes_right_id (right_id)); - - -CREATE TABLE liveuser_right_implied( -right_id INT UNSIGNED NOT NULL, -implied_right_id INT UNSIGNED NOT NULL, -INDEX IDX_liveuser_right_implied_right_id (right_id), -INDEX IDX_liveuser_right_implied_implied_right_id (implied_right_id)); - - -CREATE TABLE liveuser_languages( -language_id SMALLINT UNSIGNED DEFAULT 0 NOT NULL, -two_letter_name CHAR(2) DEFAULT NULL, -native_name VARCHAR(50) DEFAULT NULL, -PRIMARY KEY (language_id), -UNIQUE UC_language_id (language_id)); - - -CREATE TABLE liveuser_area_names( -area_id INT UNSIGNED NOT NULL, -language_id SMALLINT UNSIGNED NOT NULL, -area_name VARCHAR(20) NOT NULL, -area_comment VARCHAR(255) DEFAULT NULL, -INDEX IDX_liveuser_area_names_area_id (area_id), -INDEX IDX_liveuser_area_names_language_id (language_id)); - - -CREATE TABLE liveuser_perm_users( -perm_user_id BIGINT UNSIGNED DEFAULT 0 NOT NULL, -auth_user_id VARCHAR(32) DEFAULT 0 NOT NULL, -type TINYINT UNSIGNED DEFAULT NULL, -auth_container_name VARCHAR(32) NOT NULL, -PRIMARY KEY (perm_user_id), -UNIQUE UC_user_id (perm_user_id)); - - -CREATE TABLE liveuser_area_admin_areas( -area_id INT UNSIGNED NOT NULL, -perm_user_id BIGINT UNSIGNED NOT NULL, -INDEX IDX_liveuser_area_admin_areas_area_id (area_id), -INDEX IDX_liveuser_area_admin_areas_user_id (perm_user_id)); - - -CREATE TABLE liveuser_userrights( -perm_user_id BIGINT UNSIGNED NOT NULL, -right_id INT UNSIGNED NOT NULL, -right_level TINYINT UNSIGNED DEFAULT NULL, -INDEX IDX_liveuser_userrights_user_id (perm_user_id), -INDEX IDX_liveuser_userrights_right_id (right_id)); - - -CREATE TABLE liveuser_language_names( -language_id SMALLINT UNSIGNED NOT NULL, -native_language_id SMALLINT UNSIGNED DEFAULT 0 NOT NULL, -native_name VARCHAR(50) DEFAULT NULL, -INDEX IDX_liveuser_language_names_language_id (language_id)); - - -CREATE TABLE liveuser_groups( -group_id INT UNSIGNED DEFAULT 0 NOT NULL, -owner_user_id BIGINT UNSIGNED NOT NULL, -owner_group_id INT UNSIGNED NOT NULL, -is_active CHAR(1) DEFAULT 'N' NOT NULL, -group_define_name VARCHAR(32) NOT NULL, -PRIMARY KEY (group_id), -UNIQUE UC_group_id (group_id), -INDEX IDX_liveuser_groups_owner_user_id (owner_user_id), -INDEX IDX_liveuser_groups_owner_group_id (owner_group_id)); - - -CREATE TABLE liveuser_groupusers( -perm_user_id BIGINT UNSIGNED NOT NULL, -group_id INT UNSIGNED NOT NULL, -INDEX IDX_liveuser_groupusers_user_id (perm_user_id), -INDEX IDX_liveuser_groupusers_group_id (group_id)); - - -CREATE TABLE liveuser_rights_names( -right_id INT UNSIGNED NOT NULL, -language_id SMALLINT UNSIGNED NOT NULL, -right_name VARCHAR(20) NOT NULL, -right_comment VARCHAR(255) DEFAULT NULL, -INDEX IDX_liveuser_rights_names_right_id (right_id), -INDEX IDX_liveuser_rights_names_language_id (language_id)); - - -CREATE TABLE liveuser_group_subgroups( -group_id INT UNSIGNED NOT NULL, -subgroup_id INT UNSIGNED NOT NULL, -INDEX IDX_liveuser_group_subgroups_group_id (group_id), -INDEX IDX_liveuser_group_subgroups_subgroup_id (subgroup_id)); - - -CREATE TABLE liveuser_group_names( -group_id INT UNSIGNED NOT NULL, -language_id SMALLINT UNSIGNED NOT NULL, -group_name VARCHAR(20) NOT NULL, -group_comment VARCHAR(255) DEFAULT NULL, -INDEX IDX_liveuser_group_names_group_id (group_id), -INDEX IDX_liveuser_group_names_language_id (language_id)); - - -CREATE TABLE liveuser_application_names( -application_id INT UNSIGNED NOT NULL, -language_id SMALLINT UNSIGNED NOT NULL, -application_name VARCHAR(20) NOT NULL, -application_comment VARCHAR(255), -INDEX IDX_liveuser_application_names_application_id (application_id), -INDEX IDX_liveuser_application_names_language_id (language_id)); - - -CREATE TABLE liveuser_grouprights( -group_id INT UNSIGNED NOT NULL, -right_id INT UNSIGNED NOT NULL, -right_level TINYINT UNSIGNED DEFAULT NULL, -INDEX IDX_liveuser_grouprights_group_id (group_id), -INDEX IDX_liveuser_grouprights_right_id (right_id)); +# $Id: demodata.sql,v 1.2 2004/03/11 12:26:41 lsmith Exp $ # Dumping data for table `liveuser_users` # Password for user "boss": test @@ -171,22 +8,6 @@ INSERT INTO liveuser_users (auth_user_id, handle, passwd, lastlogin, owner_user_id, owner_group_id, is_active) VALUES ('c4ca4238a0b923820dcc509a6f75849b', 'boss', 'test', NULL, NULL, 1, 'Y'); INSERT INTO liveuser_users (auth_user_id, handle, passwd, lastlogin, owner_user_id, owner_group_id, is_active) VALUES ('c81e728d9d4c2f636f067f89cc14862c', 'hoss', 'bonanza', NULL, 1, NULL, 'Y'); -# -# Dumping data for table `liveuser_application_names` -# - - -# -# Dumping data for table `liveuser_applications` -# - - -# -# Dumping data for table `liveuser_area_admin_areas` -# - - -# # Dumping data for table `liveuser_area_names` # @@ -215,11 +36,6 @@ INSERT INTO liveuser_group_names (group_id, language_id, group_name, group_comment) VALUES (2, 2, 'Genies', 'The true genii (unrecognized but brilliant)'); # -# Dumping data for table `liveuser_group_subgroups` -# - - -# # Dumping data for table `liveuser_grouprights` # @@ -269,15 +85,6 @@ INSERT INTO liveuser_perm_users (perm_user_id, auth_user_id, type, auth_container_name) VALUES (2, 'c81e728d9d4c2f636f067f89cc14862c', 1, ''); # -# Dumping data for table `liveuser_right_implied` -# - -# -# Dumping data for table `liveuser_right_scopes` -# - - -# # Dumping data for table `liveuser_rights` # http://cvs.php.net/diff.php/pear/Perm_LiveUser/docs/examples/example4/demodata.sql?r1=1.1&r2=1.2&ty=u Index: pear/Perm_LiveUser/docs/examples/example4/demodata.sql diff -u pear/Perm_LiveUser/docs/examples/example4/demodata.sql:1.1 pear/Perm_LiveUser/docs/examples/example4/demodata.sql:1.2 --- pear/Perm_LiveUser/docs/examples/example4/demodata.sql:1.1 Thu Feb 5 15:26:45 2004 +++ pear/Perm_LiveUser/docs/examples/example4/demodata.sql Thu Mar 11 07:26:42 2004 @@ -10,19 +10,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_application_names` -# - -CREATE TABLE liveuser_application_names ( - application_id int(10) unsigned NOT NULL default '0', - language_id smallint(5) unsigned NOT NULL default '0', - application_name varchar(20) NOT NULL default '', - application_comment varchar(255) default NULL, - KEY IDX_liveuser_application_names_application_id (application_id), - KEY IDX_liveuser_application_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_application_names` # @@ -30,17 +17,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_applications` -# - -CREATE TABLE liveuser_applications ( - application_id int(10) unsigned NOT NULL default '0', - application_define_name varchar(20) NOT NULL default '', - PRIMARY KEY (application_id), - UNIQUE KEY UC_application_define_name (application_define_name) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_applications` # @@ -48,36 +24,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_area_admin_areas` -# - -CREATE TABLE liveuser_area_admin_areas ( - area_id int(10) unsigned NOT NULL default '0', - perm_user_id bigint(20) unsigned NOT NULL default '0', - KEY IDX_liveuser_area_admin_areas_area_id (area_id), - KEY IDX_liveuser_area_admin_areas_user_id (perm_user_id) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_area_admin_areas` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_area_names` -# - -CREATE TABLE liveuser_area_names ( - area_id int(10) unsigned NOT NULL default '0', - language_id smallint(5) unsigned NOT NULL default '0', - area_name varchar(20) NOT NULL default '', - area_comment varchar(255) default NULL, - KEY IDX_liveuser_area_names_area_id (area_id), - KEY IDX_liveuser_area_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_area_names` # @@ -85,19 +31,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_areas` -# - -CREATE TABLE liveuser_areas ( - area_id int(10) unsigned NOT NULL default '0', - application_id int(10) unsigned NOT NULL default '0', - area_define_name varchar(20) NOT NULL default '', - PRIMARY KEY (area_id), - UNIQUE KEY UC_area_id (area_id), - KEY IDX_liveuser_areas_application_id (application_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_areas` # @@ -105,19 +38,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_group_names` -# - -CREATE TABLE liveuser_group_names ( - group_id int(11) NOT NULL default '0', - language_id smallint(5) unsigned NOT NULL default '0', - group_name varchar(20) NOT NULL default '', - group_comment varchar(255) default NULL, - KEY IDX_liveuser_group_names_group_id (group_id), - KEY IDX_liveuser_group_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_group_names` # @@ -127,35 +47,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_group_subgroups` -# - -CREATE TABLE liveuser_group_subgroups ( - group_id int(11) NOT NULL default '0', - subgroup_id int(11) NOT NULL default '0', - KEY IDX_liveuser_group_subgroups_group_id (group_id), - KEY IDX_liveuser_group_subgroups_subgroup_id (subgroup_id) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_group_subgroups` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_grouprights` -# - -CREATE TABLE liveuser_grouprights ( - group_id int(11) NOT NULL default '0', - right_id int(10) unsigned NOT NULL default '0', - right_level tinyint(3) unsigned default NULL, - KEY IDX_liveuser_grouprights_group_id (group_id), - KEY IDX_liveuser_grouprights_right_id (right_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_grouprights` # @@ -165,22 +56,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_groups` -# - -CREATE TABLE liveuser_groups ( - group_id int(11) NOT NULL default '0', - owner_user_id bigint(20) unsigned NOT NULL default '0', - owner_group_id int(11) NOT NULL default '0', - is_active char(1) NOT NULL default 'N', - group_define_name varchar(32) NOT NULL default '', - PRIMARY KEY (group_id), - UNIQUE KEY UC_group_id (group_id), - KEY IDX_liveuser_groups_owner_user_id (owner_user_id), - KEY IDX_liveuser_groups_owner_group_id (owner_group_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_groups` # @@ -190,17 +65,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_groupusers` -# - -CREATE TABLE liveuser_groupusers ( - perm_user_id bigint(20) unsigned NOT NULL default '0', - group_id int(11) NOT NULL default '0', - KEY IDX_liveuser_groupusers_user_id (perm_user_id), - KEY IDX_liveuser_groupusers_group_id (group_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_groupusers` # @@ -212,17 +76,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_language_names` -# - -CREATE TABLE liveuser_language_names ( - language_id smallint(5) unsigned NOT NULL default '0', - native_language_id smallint(5) unsigned NOT NULL default '0', - native_name varchar(50) default NULL, - KEY IDX_liveuser_language_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_language_names` # @@ -230,18 +83,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_languages` -# - -CREATE TABLE liveuser_languages ( - language_id smallint(5) unsigned NOT NULL default '0', - two_letter_name char(2) default NULL, - native_name varchar(50) default NULL, - PRIMARY KEY (language_id), - UNIQUE KEY UC_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_languages` # @@ -249,19 +90,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_perm_users` -# - -CREATE TABLE liveuser_perm_users ( - perm_user_id bigint(20) unsigned NOT NULL default '0', - auth_user_id varchar(32) NOT NULL default '0', - type tinyint(3) unsigned default NULL, - auth_container_name varchar(32) NOT NULL default '', - PRIMARY KEY (perm_user_id), - UNIQUE KEY UC_user_id (perm_user_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_perm_users` # @@ -272,17 +100,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_right_implied` -# - -CREATE TABLE liveuser_right_implied ( - right_id int(10) unsigned NOT NULL default '0', - implied_right_id int(10) unsigned NOT NULL default '0', - KEY IDX_liveuser_right_implied_right_id (right_id), - KEY IDX_liveuser_right_implied_implied_right_id (implied_right_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_right_implied` # @@ -291,38 +108,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_right_scopes` -# - -CREATE TABLE liveuser_right_scopes ( - right_id int(10) unsigned NOT NULL default '0', - type tinyint(3) unsigned NOT NULL default '0', - KEY IDX_liveuser_right_scopes_right_id (right_id) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_right_scopes` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_rights` -# - -CREATE TABLE liveuser_rights ( - right_id int(10) unsigned NOT NULL default '0', - area_id int(10) unsigned NOT NULL default '0', - right_define_name varchar(50) NOT NULL default '', - has_implied char(1) NOT NULL default 'N', - has_level char(1) NOT NULL default 'N', - has_scope char(1) NOT NULL default 'N', - PRIMARY KEY (right_id), - UNIQUE KEY UC_right_id (right_id), - KEY IDX_liveuser_rights_area_id (area_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_rights` # @@ -332,19 +117,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_rights_names` -# - -CREATE TABLE liveuser_rights_names ( - right_id int(10) unsigned NOT NULL default '0', - language_id smallint(5) unsigned NOT NULL default '0', - right_name varchar(20) NOT NULL default '', - right_comment varchar(255) default NULL, - KEY IDX_liveuser_rights_names_right_id (right_id), - KEY IDX_liveuser_rights_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_rights_names` # @@ -354,18 +126,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_userrights` -# - -CREATE TABLE liveuser_userrights ( - perm_user_id bigint(20) unsigned NOT NULL default '0', - right_id int(10) unsigned NOT NULL default '0', - right_level tinyint(3) unsigned default NULL, - KEY IDX_liveuser_userrights_user_id (perm_user_id), - KEY IDX_liveuser_userrights_right_id (right_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_userrights` # @@ -373,23 +133,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_users` -# - -CREATE TABLE liveuser_users ( - auth_user_id varchar(32) NOT NULL default '0', - handle varchar(32) NOT NULL default '', - passwd varchar(32) NOT NULL default '', - currentlogin datetime default NULL, - lastlogin datetime default NULL, - owner_user_id bigint(20) unsigned default NULL, - owner_group_id int(11) unsigned default NULL, - is_active char(1) NOT NULL default 'N', - UNIQUE KEY auth_user_id (auth_user_id,handle), - KEY auth_user_id_2 (auth_user_id,handle) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_users` # http://cvs.php.net/diff.php/pear/Perm_LiveUser/docs/examples/example5/create_db.sql?r1=1.1&r2=1.2&ty=u Index: pear/Perm_LiveUser/docs/examples/example5/create_db.sql diff -u pear/Perm_LiveUser/docs/examples/example5/create_db.sql:1.1 pear/Perm_LiveUser/docs/examples/example5/create_db.sql:1.2 --- pear/Perm_LiveUser/docs/examples/example5/create_db.sql:1.1 Thu Feb 5 15:26:45 2004 +++ pear/Perm_LiveUser/docs/examples/example5/create_db.sql Thu Mar 11 07:26:43 2004 @@ -10,20 +10,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_applications` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_applications` ( - `application_id` int(10) unsigned NOT NULL default '0', - `application_define_name` varchar(20) NOT NULL default '', - PRIMARY KEY (`application_id`), - UNIQUE KEY `application_define_name` (`application_define_name`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_applications` # @@ -31,18 +17,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_applications_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_applications_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=2 ; - -# # Dumping data for table `liveuser_applications_seq` # @@ -50,40 +24,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_area_admin_areas` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_area_admin_areas` ( - `area_id` int(11) NOT NULL default '0', - `perm_user_id` bigint(20) NOT NULL default '0', - PRIMARY KEY (`area_id`,`perm_user_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_area_admin_areas` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_areas` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_areas` ( - `area_id` int(10) unsigned NOT NULL default '0', - `application_id` int(11) NOT NULL default '0', - `area_define_name` varchar(20) NOT NULL default '', - PRIMARY KEY (`area_id`), - KEY `IDX_liveuser_areas_application_id` (`application_id`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_areas` # @@ -91,18 +31,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_areas_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_areas_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=2 ; - -# # Dumping data for table `liveuser_areas_seq` # @@ -110,142 +38,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_group_subgroups` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_group_subgroups` ( - `group_id` int(11) NOT NULL default '0', - `subgroup_id` int(11) NOT NULL default '0', - PRIMARY KEY (`group_id`,`subgroup_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_group_subgroups` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_grouprights` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_grouprights` ( - `group_id` int(11) NOT NULL default '0', - `right_id` int(11) NOT NULL default '0', - `right_level` tinyint(3) unsigned default NULL, - PRIMARY KEY (`group_id`,`right_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_grouprights` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_groups` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# Last check: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_groups` ( - `group_id` int(10) unsigned NOT NULL default '0', - `owner_perm_user_id` bigint(20) NOT NULL default '0', - `owner_group_id` int(11) NOT NULL default '0', - `is_active` char(1) NOT NULL default 'N', - `group_define_name` varchar(32) NOT NULL default '', - PRIMARY KEY (`group_id`), - KEY `IDX_liveuser_groups_owner_group_id` (`owner_group_id`), - KEY `IDX_liveuser_groups_owner_perm_user_id` (`owner_perm_user_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_groups` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_groups_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_groups_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1 ; - -# -# Dumping data for table `liveuser_groups_seq` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_groupusers` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_groupusers` ( - `perm_user_id` bigint(20) NOT NULL default '0', - `group_id` int(11) NOT NULL default '0', - PRIMARY KEY (`group_id`,`perm_user_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_groupusers` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_languages` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_languages` ( - `language_id` smallint(5) unsigned NOT NULL default '0', - `two_letter_name` char(2) default 'NU', - `native_name` varchar(50) default NULL, - PRIMARY KEY (`language_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_languages` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_perm_users` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 22, 2003 at 09:26 AM -# - -CREATE TABLE `liveuser_perm_users` ( - `perm_user_id` bigint(20) unsigned NOT NULL default '0', - `auth_user_id` varchar(32) NOT NULL default '0', - `type` tinyint(3) unsigned default NULL, - `auth_container_name` varchar(32) NOT NULL default '', - PRIMARY KEY (`perm_user_id`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_perm_users` # @@ -253,82 +45,10 @@ INSERT INTO `liveuser_perm_users` VALUES (2, '02ec099f2d602cc4968c5267970be132', NULL, 'DB_Medium'); # -------------------------------------------------------- -# -# Table structure for table `liveuser_perm_users_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Nov 22, 2003 at 09:26 AM -# - -CREATE TABLE `liveuser_perm_users_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=3 ; - -# -# Dumping data for table `liveuser_perm_users_seq` -# - INSERT INTO `liveuser_perm_users_seq` VALUES (2); # -------------------------------------------------------- # -# Table structure for table `liveuser_right_implied` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_right_implied` ( - `right_id` int(11) NOT NULL default '0', - `implied_right_id` int(11) NOT NULL default '0', - PRIMARY KEY (`implied_right_id`,`right_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_right_implied` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_right_scopes` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_right_scopes` ( - `right_id` int(11) NOT NULL default '0', - `type` tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (`right_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_right_scopes` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_rights` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_rights` ( - `right_id` int(10) unsigned NOT NULL default '0', - `area_id` int(11) NOT NULL default '0', - `right_define_name` varchar(50) NOT NULL default '', - `has_implied` char(1) NOT NULL default 'N', - `has_level` char(1) NOT NULL default 'N', - `has_scope` char(1) NOT NULL default 'N', - PRIMARY KEY (`right_id`), - KEY `IDX_liveuser_rights_area_id` (`area_id`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_rights` # @@ -337,18 +57,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_rights_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_rights_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=3 ; - -# # Dumping data for table `liveuser_rights_seq` # @@ -356,42 +64,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_translations` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_translations` ( - `section_id` int(16) unsigned NOT NULL default '0', - `section_type` varchar(16) NOT NULL default '', - `language_id` smallint(5) unsigned default NULL, - `name` varchar(50) NOT NULL default '', - `comment` varchar(255) default NULL, - PRIMARY KEY (`section_id`,`section_type`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_translations` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_userrights` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 22, 2003 at 09:27 AM -# - -CREATE TABLE `liveuser_userrights` ( - `perm_user_id` bigint(20) NOT NULL default '0', - `right_id` int(11) NOT NULL default '0', - `right_level` tinyint(3) unsigned default NULL, - PRIMARY KEY (`right_id`,`perm_user_id`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_userrights` # @@ -401,24 +73,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_users` -# -# Creation: Nov 13, 2003 at 08:18 PM -# Last update: Nov 22, 2003 at 09:33 AM -# - -CREATE TABLE `liveuser_users` ( - `auth_user_id` varchar(32) NOT NULL default '0', - `handle` varchar(32) NOT NULL default '', - `passwd` varchar(32) NOT NULL default '', - `lastlogin` datetime default NULL, - `owner_user_id` bigint(20) unsigned default NULL, - `owner_group_id` int(11) unsigned default NULL, - `is_active` char(1) NOT NULL default 'N', - PRIMARY KEY (`auth_user_id`,`handle`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_users` # @@ -465,7 +119,4 @@ # Dumping data for table `news_seq` # -INSERT INTO `news_seq` VALUES (3); - - - +INSERT INTO `news_seq` VALUES (3); \ No newline at end of file
http://cvs.php.net/diff.php/pear/Perm_LiveUser/docs/examples/example3/demodata.sql?r1=1.1&r2=1.2&ty=u Index: pear/Perm_LiveUser/docs/examples/example3/demodata.sql diff -u pear/Perm_LiveUser/docs/examples/example3/demodata.sql:1.1 pear/Perm_LiveUser/docs/examples/example3/demodata.sql:1.2 --- pear/Perm_LiveUser/docs/examples/example3/demodata.sql:1.1 Thu Feb 5 15:26:44 2004 +++ pear/Perm_LiveUser/docs/examples/example3/demodata.sql Thu Mar 11 07:26:41 2004 @@ -1,167 +1,4 @@ -# $Id: demodata.sql,v 1.1 2004/02/05 20:26:44 arnaud Exp $ - -# Creating tables ... - -CREATE TABLE liveuser_users ( -auth_user_id varchar(32) NOT NULL default '0', -handle varchar(32) NOT NULL default '', -passwd varchar(32) NOT NULL default '', -lastlogin datetime default NULL, -owner_user_id bigint UNSIGNED default NULL, -owner_group_id int(11) UNSIGNED default NULL, -is_active char(1) NOT NULL default 'N', -UNIQUE KEY auth_user_id (auth_user_id,handle), -KEY auth_user_id_2 (auth_user_id,handle)); - - -CREATE TABLE liveuser_applications( -application_id INT UNSIGNED DEFAULT 0 NOT NULL, -application_define_name VARCHAR(20) NOT NULL, -PRIMARY KEY (application_id), -UNIQUE UC_application_define_name (application_define_name)); - - -CREATE TABLE liveuser_areas( -area_id INT UNSIGNED DEFAULT 0 NOT NULL, -application_id INT UNSIGNED NOT NULL, -area_define_name VARCHAR(20) NOT NULL, -PRIMARY KEY (area_id), -UNIQUE UC_area_id (area_id), -INDEX IDX_liveuser_areas_application_id (application_id)); - - -CREATE TABLE liveuser_rights( -right_id INT UNSIGNED DEFAULT 0 NOT NULL, -area_id INT UNSIGNED NOT NULL, -right_define_name VARCHAR(50) NOT NULL, -has_implied CHAR(1) DEFAULT 'N' NOT NULL, -has_level CHAR(1) DEFAULT 'N' NOT NULL, -has_scope CHAR(1) DEFAULT 'N' NOT NULL, -PRIMARY KEY (right_id), -UNIQUE UC_right_id (right_id), -INDEX IDX_liveuser_rights_area_id (area_id)); - - -CREATE TABLE liveuser_right_scopes( -right_id INT UNSIGNED NOT NULL, -type TINYINT UNSIGNED DEFAULT 0 NOT NULL, -INDEX IDX_liveuser_right_scopes_right_id (right_id)); - - -CREATE TABLE liveuser_right_implied( -right_id INT UNSIGNED NOT NULL, -implied_right_id INT UNSIGNED NOT NULL, -INDEX IDX_liveuser_right_implied_right_id (right_id), -INDEX IDX_liveuser_right_implied_implied_right_id (implied_right_id)); - - -CREATE TABLE liveuser_languages( -language_id SMALLINT UNSIGNED DEFAULT 0 NOT NULL, -two_letter_name CHAR(2) DEFAULT NULL, -native_name VARCHAR(50) DEFAULT NULL, -PRIMARY KEY (language_id), -UNIQUE UC_language_id (language_id)); - - -CREATE TABLE liveuser_area_names( -area_id INT UNSIGNED NOT NULL, -language_id SMALLINT UNSIGNED NOT NULL, -area_name VARCHAR(20) NOT NULL, -area_comment VARCHAR(255) DEFAULT NULL, -INDEX IDX_liveuser_area_names_area_id (area_id), -INDEX IDX_liveuser_area_names_language_id (language_id)); - - -CREATE TABLE liveuser_perm_users( -perm_user_id BIGINT UNSIGNED DEFAULT 0 NOT NULL, -auth_user_id VARCHAR(32) DEFAULT 0 NOT NULL, -type TINYINT UNSIGNED DEFAULT NULL, -auth_container_name VARCHAR(32) NOT NULL, -PRIMARY KEY (perm_user_id), -UNIQUE UC_user_id (perm_user_id)); - - -CREATE TABLE liveuser_area_admin_areas( -area_id INT UNSIGNED NOT NULL, -perm_user_id BIGINT UNSIGNED NOT NULL, -INDEX IDX_liveuser_area_admin_areas_area_id (area_id), -INDEX IDX_liveuser_area_admin_areas_user_id (perm_user_id)); - - -CREATE TABLE liveuser_userrights( -perm_user_id BIGINT UNSIGNED NOT NULL, -right_id INT UNSIGNED NOT NULL, -right_level TINYINT UNSIGNED DEFAULT NULL, -INDEX IDX_liveuser_userrights_user_id (perm_user_id), -INDEX IDX_liveuser_userrights_right_id (right_id)); - - -CREATE TABLE liveuser_language_names( -language_id SMALLINT UNSIGNED NOT NULL, -native_language_id SMALLINT UNSIGNED DEFAULT 0 NOT NULL, -native_name VARCHAR(50) DEFAULT NULL, -INDEX IDX_liveuser_language_names_language_id (language_id)); - - -CREATE TABLE liveuser_groups( -group_id INT UNSIGNED DEFAULT 0 NOT NULL, -owner_user_id BIGINT UNSIGNED NOT NULL, -owner_group_id INT UNSIGNED NOT NULL, -is_active CHAR(1) DEFAULT 'N' NOT NULL, -group_define_name VARCHAR(32) NOT NULL, -PRIMARY KEY (group_id), -UNIQUE UC_group_id (group_id), -INDEX IDX_liveuser_groups_owner_user_id (owner_user_id), -INDEX IDX_liveuser_groups_owner_group_id (owner_group_id)); - - -CREATE TABLE liveuser_groupusers( -perm_user_id BIGINT UNSIGNED NOT NULL, -group_id INT UNSIGNED NOT NULL, -INDEX IDX_liveuser_groupusers_user_id (perm_user_id), -INDEX IDX_liveuser_groupusers_group_id (group_id)); - - -CREATE TABLE liveuser_rights_names( -right_id INT UNSIGNED NOT NULL, -language_id SMALLINT UNSIGNED NOT NULL, -right_name VARCHAR(20) NOT NULL, -right_comment VARCHAR(255) DEFAULT NULL, -INDEX IDX_liveuser_rights_names_right_id (right_id), -INDEX IDX_liveuser_rights_names_language_id (language_id)); - - -CREATE TABLE liveuser_group_subgroups( -group_id INT UNSIGNED NOT NULL, -subgroup_id INT UNSIGNED NOT NULL, -INDEX IDX_liveuser_group_subgroups_group_id (group_id), -INDEX IDX_liveuser_group_subgroups_subgroup_id (subgroup_id)); - - -CREATE TABLE liveuser_group_names( -group_id INT UNSIGNED NOT NULL, -language_id SMALLINT UNSIGNED NOT NULL, -group_name VARCHAR(20) NOT NULL, -group_comment VARCHAR(255) DEFAULT NULL, -INDEX IDX_liveuser_group_names_group_id (group_id), -INDEX IDX_liveuser_group_names_language_id (language_id)); - - -CREATE TABLE liveuser_application_names( -application_id INT UNSIGNED NOT NULL, -language_id SMALLINT UNSIGNED NOT NULL, -application_name VARCHAR(20) NOT NULL, -application_comment VARCHAR(255), -INDEX IDX_liveuser_application_names_application_id (application_id), -INDEX IDX_liveuser_application_names_language_id (language_id)); - - -CREATE TABLE liveuser_grouprights( -group_id INT UNSIGNED NOT NULL, -right_id INT UNSIGNED NOT NULL, -right_level TINYINT UNSIGNED DEFAULT NULL, -INDEX IDX_liveuser_grouprights_group_id (group_id), -INDEX IDX_liveuser_grouprights_right_id (right_id)); +# $Id: demodata.sql,v 1.2 2004/03/11 12:26:41 lsmith Exp $ # Dumping data for table `liveuser_users` # Password for user "boss": test @@ -171,22 +8,6 @@ INSERT INTO liveuser_users (auth_user_id, handle, passwd, lastlogin, owner_user_id, owner_group_id, is_active) VALUES ('c4ca4238a0b923820dcc509a6f75849b', 'boss', 'test', NULL, NULL, 1, 'Y'); INSERT INTO liveuser_users (auth_user_id, handle, passwd, lastlogin, owner_user_id, owner_group_id, is_active) VALUES ('c81e728d9d4c2f636f067f89cc14862c', 'hoss', 'bonanza', NULL, 1, NULL, 'Y'); -# -# Dumping data for table `liveuser_application_names` -# - - -# -# Dumping data for table `liveuser_applications` -# - - -# -# Dumping data for table `liveuser_area_admin_areas` -# - - -# # Dumping data for table `liveuser_area_names` # @@ -215,11 +36,6 @@ INSERT INTO liveuser_group_names (group_id, language_id, group_name, group_comment) VALUES (2, 2, 'Genies', 'The true genii (unrecognized but brilliant)'); # -# Dumping data for table `liveuser_group_subgroups` -# - - -# # Dumping data for table `liveuser_grouprights` # @@ -269,15 +85,6 @@ INSERT INTO liveuser_perm_users (perm_user_id, auth_user_id, type, auth_container_name) VALUES (2, 'c81e728d9d4c2f636f067f89cc14862c', 1, ''); # -# Dumping data for table `liveuser_right_implied` -# - -# -# Dumping data for table `liveuser_right_scopes` -# - - -# # Dumping data for table `liveuser_rights` # http://cvs.php.net/diff.php/pear/Perm_LiveUser/docs/examples/example4/demodata.sql?r1=1.1&r2=1.2&ty=u Index: pear/Perm_LiveUser/docs/examples/example4/demodata.sql diff -u pear/Perm_LiveUser/docs/examples/example4/demodata.sql:1.1 pear/Perm_LiveUser/docs/examples/example4/demodata.sql:1.2 --- pear/Perm_LiveUser/docs/examples/example4/demodata.sql:1.1 Thu Feb 5 15:26:45 2004 +++ pear/Perm_LiveUser/docs/examples/example4/demodata.sql Thu Mar 11 07:26:42 2004 @@ -10,19 +10,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_application_names` -# - -CREATE TABLE liveuser_application_names ( - application_id int(10) unsigned NOT NULL default '0', - language_id smallint(5) unsigned NOT NULL default '0', - application_name varchar(20) NOT NULL default '', - application_comment varchar(255) default NULL, - KEY IDX_liveuser_application_names_application_id (application_id), - KEY IDX_liveuser_application_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_application_names` # @@ -30,17 +17,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_applications` -# - -CREATE TABLE liveuser_applications ( - application_id int(10) unsigned NOT NULL default '0', - application_define_name varchar(20) NOT NULL default '', - PRIMARY KEY (application_id), - UNIQUE KEY UC_application_define_name (application_define_name) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_applications` # @@ -48,36 +24,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_area_admin_areas` -# - -CREATE TABLE liveuser_area_admin_areas ( - area_id int(10) unsigned NOT NULL default '0', - perm_user_id bigint(20) unsigned NOT NULL default '0', - KEY IDX_liveuser_area_admin_areas_area_id (area_id), - KEY IDX_liveuser_area_admin_areas_user_id (perm_user_id) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_area_admin_areas` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_area_names` -# - -CREATE TABLE liveuser_area_names ( - area_id int(10) unsigned NOT NULL default '0', - language_id smallint(5) unsigned NOT NULL default '0', - area_name varchar(20) NOT NULL default '', - area_comment varchar(255) default NULL, - KEY IDX_liveuser_area_names_area_id (area_id), - KEY IDX_liveuser_area_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_area_names` # @@ -85,19 +31,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_areas` -# - -CREATE TABLE liveuser_areas ( - area_id int(10) unsigned NOT NULL default '0', - application_id int(10) unsigned NOT NULL default '0', - area_define_name varchar(20) NOT NULL default '', - PRIMARY KEY (area_id), - UNIQUE KEY UC_area_id (area_id), - KEY IDX_liveuser_areas_application_id (application_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_areas` # @@ -105,19 +38,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_group_names` -# - -CREATE TABLE liveuser_group_names ( - group_id int(11) NOT NULL default '0', - language_id smallint(5) unsigned NOT NULL default '0', - group_name varchar(20) NOT NULL default '', - group_comment varchar(255) default NULL, - KEY IDX_liveuser_group_names_group_id (group_id), - KEY IDX_liveuser_group_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_group_names` # @@ -127,35 +47,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_group_subgroups` -# - -CREATE TABLE liveuser_group_subgroups ( - group_id int(11) NOT NULL default '0', - subgroup_id int(11) NOT NULL default '0', - KEY IDX_liveuser_group_subgroups_group_id (group_id), - KEY IDX_liveuser_group_subgroups_subgroup_id (subgroup_id) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_group_subgroups` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_grouprights` -# - -CREATE TABLE liveuser_grouprights ( - group_id int(11) NOT NULL default '0', - right_id int(10) unsigned NOT NULL default '0', - right_level tinyint(3) unsigned default NULL, - KEY IDX_liveuser_grouprights_group_id (group_id), - KEY IDX_liveuser_grouprights_right_id (right_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_grouprights` # @@ -165,22 +56,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_groups` -# - -CREATE TABLE liveuser_groups ( - group_id int(11) NOT NULL default '0', - owner_user_id bigint(20) unsigned NOT NULL default '0', - owner_group_id int(11) NOT NULL default '0', - is_active char(1) NOT NULL default 'N', - group_define_name varchar(32) NOT NULL default '', - PRIMARY KEY (group_id), - UNIQUE KEY UC_group_id (group_id), - KEY IDX_liveuser_groups_owner_user_id (owner_user_id), - KEY IDX_liveuser_groups_owner_group_id (owner_group_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_groups` # @@ -190,17 +65,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_groupusers` -# - -CREATE TABLE liveuser_groupusers ( - perm_user_id bigint(20) unsigned NOT NULL default '0', - group_id int(11) NOT NULL default '0', - KEY IDX_liveuser_groupusers_user_id (perm_user_id), - KEY IDX_liveuser_groupusers_group_id (group_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_groupusers` # @@ -212,17 +76,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_language_names` -# - -CREATE TABLE liveuser_language_names ( - language_id smallint(5) unsigned NOT NULL default '0', - native_language_id smallint(5) unsigned NOT NULL default '0', - native_name varchar(50) default NULL, - KEY IDX_liveuser_language_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_language_names` # @@ -230,18 +83,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_languages` -# - -CREATE TABLE liveuser_languages ( - language_id smallint(5) unsigned NOT NULL default '0', - two_letter_name char(2) default NULL, - native_name varchar(50) default NULL, - PRIMARY KEY (language_id), - UNIQUE KEY UC_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_languages` # @@ -249,19 +90,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_perm_users` -# - -CREATE TABLE liveuser_perm_users ( - perm_user_id bigint(20) unsigned NOT NULL default '0', - auth_user_id varchar(32) NOT NULL default '0', - type tinyint(3) unsigned default NULL, - auth_container_name varchar(32) NOT NULL default '', - PRIMARY KEY (perm_user_id), - UNIQUE KEY UC_user_id (perm_user_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_perm_users` # @@ -272,17 +100,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_right_implied` -# - -CREATE TABLE liveuser_right_implied ( - right_id int(10) unsigned NOT NULL default '0', - implied_right_id int(10) unsigned NOT NULL default '0', - KEY IDX_liveuser_right_implied_right_id (right_id), - KEY IDX_liveuser_right_implied_implied_right_id (implied_right_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_right_implied` # @@ -291,38 +108,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_right_scopes` -# - -CREATE TABLE liveuser_right_scopes ( - right_id int(10) unsigned NOT NULL default '0', - type tinyint(3) unsigned NOT NULL default '0', - KEY IDX_liveuser_right_scopes_right_id (right_id) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_right_scopes` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_rights` -# - -CREATE TABLE liveuser_rights ( - right_id int(10) unsigned NOT NULL default '0', - area_id int(10) unsigned NOT NULL default '0', - right_define_name varchar(50) NOT NULL default '', - has_implied char(1) NOT NULL default 'N', - has_level char(1) NOT NULL default 'N', - has_scope char(1) NOT NULL default 'N', - PRIMARY KEY (right_id), - UNIQUE KEY UC_right_id (right_id), - KEY IDX_liveuser_rights_area_id (area_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_rights` # @@ -332,19 +117,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_rights_names` -# - -CREATE TABLE liveuser_rights_names ( - right_id int(10) unsigned NOT NULL default '0', - language_id smallint(5) unsigned NOT NULL default '0', - right_name varchar(20) NOT NULL default '', - right_comment varchar(255) default NULL, - KEY IDX_liveuser_rights_names_right_id (right_id), - KEY IDX_liveuser_rights_names_language_id (language_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_rights_names` # @@ -354,18 +126,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_userrights` -# - -CREATE TABLE liveuser_userrights ( - perm_user_id bigint(20) unsigned NOT NULL default '0', - right_id int(10) unsigned NOT NULL default '0', - right_level tinyint(3) unsigned default NULL, - KEY IDX_liveuser_userrights_user_id (perm_user_id), - KEY IDX_liveuser_userrights_right_id (right_id) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_userrights` # @@ -373,23 +133,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_users` -# - -CREATE TABLE liveuser_users ( - auth_user_id varchar(32) NOT NULL default '0', - handle varchar(32) NOT NULL default '', - passwd varchar(32) NOT NULL default '', - currentlogin datetime default NULL, - lastlogin datetime default NULL, - owner_user_id bigint(20) unsigned default NULL, - owner_group_id int(11) unsigned default NULL, - is_active char(1) NOT NULL default 'N', - UNIQUE KEY auth_user_id (auth_user_id,handle), - KEY auth_user_id_2 (auth_user_id,handle) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_users` # http://cvs.php.net/diff.php/pear/Perm_LiveUser/docs/examples/example5/create_db.sql?r1=1.1&r2=1.2&ty=u Index: pear/Perm_LiveUser/docs/examples/example5/create_db.sql diff -u pear/Perm_LiveUser/docs/examples/example5/create_db.sql:1.1 pear/Perm_LiveUser/docs/examples/example5/create_db.sql:1.2 --- pear/Perm_LiveUser/docs/examples/example5/create_db.sql:1.1 Thu Feb 5 15:26:45 2004 +++ pear/Perm_LiveUser/docs/examples/example5/create_db.sql Thu Mar 11 07:26:43 2004 @@ -10,20 +10,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_applications` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_applications` ( - `application_id` int(10) unsigned NOT NULL default '0', - `application_define_name` varchar(20) NOT NULL default '', - PRIMARY KEY (`application_id`), - UNIQUE KEY `application_define_name` (`application_define_name`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_applications` # @@ -31,18 +17,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_applications_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_applications_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=2 ; - -# # Dumping data for table `liveuser_applications_seq` # @@ -50,40 +24,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_area_admin_areas` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_area_admin_areas` ( - `area_id` int(11) NOT NULL default '0', - `perm_user_id` bigint(20) NOT NULL default '0', - PRIMARY KEY (`area_id`,`perm_user_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_area_admin_areas` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_areas` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_areas` ( - `area_id` int(10) unsigned NOT NULL default '0', - `application_id` int(11) NOT NULL default '0', - `area_define_name` varchar(20) NOT NULL default '', - PRIMARY KEY (`area_id`), - KEY `IDX_liveuser_areas_application_id` (`application_id`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_areas` # @@ -91,18 +31,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_areas_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_areas_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=2 ; - -# # Dumping data for table `liveuser_areas_seq` # @@ -110,142 +38,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_group_subgroups` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_group_subgroups` ( - `group_id` int(11) NOT NULL default '0', - `subgroup_id` int(11) NOT NULL default '0', - PRIMARY KEY (`group_id`,`subgroup_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_group_subgroups` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_grouprights` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_grouprights` ( - `group_id` int(11) NOT NULL default '0', - `right_id` int(11) NOT NULL default '0', - `right_level` tinyint(3) unsigned default NULL, - PRIMARY KEY (`group_id`,`right_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_grouprights` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_groups` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# Last check: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_groups` ( - `group_id` int(10) unsigned NOT NULL default '0', - `owner_perm_user_id` bigint(20) NOT NULL default '0', - `owner_group_id` int(11) NOT NULL default '0', - `is_active` char(1) NOT NULL default 'N', - `group_define_name` varchar(32) NOT NULL default '', - PRIMARY KEY (`group_id`), - KEY `IDX_liveuser_groups_owner_group_id` (`owner_group_id`), - KEY `IDX_liveuser_groups_owner_perm_user_id` (`owner_perm_user_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_groups` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_groups_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_groups_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=1 ; - -# -# Dumping data for table `liveuser_groups_seq` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_groupusers` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_groupusers` ( - `perm_user_id` bigint(20) NOT NULL default '0', - `group_id` int(11) NOT NULL default '0', - PRIMARY KEY (`group_id`,`perm_user_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_groupusers` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_languages` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_languages` ( - `language_id` smallint(5) unsigned NOT NULL default '0', - `two_letter_name` char(2) default 'NU', - `native_name` varchar(50) default NULL, - PRIMARY KEY (`language_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_languages` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_perm_users` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 22, 2003 at 09:26 AM -# - -CREATE TABLE `liveuser_perm_users` ( - `perm_user_id` bigint(20) unsigned NOT NULL default '0', - `auth_user_id` varchar(32) NOT NULL default '0', - `type` tinyint(3) unsigned default NULL, - `auth_container_name` varchar(32) NOT NULL default '', - PRIMARY KEY (`perm_user_id`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_perm_users` # @@ -253,82 +45,10 @@ INSERT INTO `liveuser_perm_users` VALUES (2, '02ec099f2d602cc4968c5267970be132', NULL, 'DB_Medium'); # -------------------------------------------------------- -# -# Table structure for table `liveuser_perm_users_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Nov 22, 2003 at 09:26 AM -# - -CREATE TABLE `liveuser_perm_users_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=3 ; - -# -# Dumping data for table `liveuser_perm_users_seq` -# - INSERT INTO `liveuser_perm_users_seq` VALUES (2); # -------------------------------------------------------- # -# Table structure for table `liveuser_right_implied` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_right_implied` ( - `right_id` int(11) NOT NULL default '0', - `implied_right_id` int(11) NOT NULL default '0', - PRIMARY KEY (`implied_right_id`,`right_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_right_implied` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_right_scopes` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_right_scopes` ( - `right_id` int(11) NOT NULL default '0', - `type` tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (`right_id`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_right_scopes` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_rights` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 13, 2003 at 07:47 PM -# - -CREATE TABLE `liveuser_rights` ( - `right_id` int(10) unsigned NOT NULL default '0', - `area_id` int(11) NOT NULL default '0', - `right_define_name` varchar(50) NOT NULL default '', - `has_implied` char(1) NOT NULL default 'N', - `has_level` char(1) NOT NULL default 'N', - `has_scope` char(1) NOT NULL default 'N', - PRIMARY KEY (`right_id`), - KEY `IDX_liveuser_rights_area_id` (`area_id`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_rights` # @@ -337,18 +57,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_rights_seq` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_rights_seq` ( - `id` int(10) unsigned NOT NULL auto_increment, - PRIMARY KEY (`id`) -) TYPE=MyISAM AUTO_INCREMENT=3 ; - -# # Dumping data for table `liveuser_rights_seq` # @@ -356,42 +64,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_translations` -# -# Creation: Aug 17, 2003 at 12:10 PM -# Last update: Aug 17, 2003 at 12:10 PM -# - -CREATE TABLE `liveuser_translations` ( - `section_id` int(16) unsigned NOT NULL default '0', - `section_type` varchar(16) NOT NULL default '', - `language_id` smallint(5) unsigned default NULL, - `name` varchar(50) NOT NULL default '', - `comment` varchar(255) default NULL, - PRIMARY KEY (`section_id`,`section_type`) -) TYPE=MyISAM; - -# -# Dumping data for table `liveuser_translations` -# - -# -------------------------------------------------------- - -# -# Table structure for table `liveuser_userrights` -# -# Creation: Nov 13, 2003 at 07:47 PM -# Last update: Nov 22, 2003 at 09:27 AM -# - -CREATE TABLE `liveuser_userrights` ( - `perm_user_id` bigint(20) NOT NULL default '0', - `right_id` int(11) NOT NULL default '0', - `right_level` tinyint(3) unsigned default NULL, - PRIMARY KEY (`right_id`,`perm_user_id`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_userrights` # @@ -401,24 +73,6 @@ # -------------------------------------------------------- # -# Table structure for table `liveuser_users` -# -# Creation: Nov 13, 2003 at 08:18 PM -# Last update: Nov 22, 2003 at 09:33 AM -# - -CREATE TABLE `liveuser_users` ( - `auth_user_id` varchar(32) NOT NULL default '0', - `handle` varchar(32) NOT NULL default '', - `passwd` varchar(32) NOT NULL default '', - `lastlogin` datetime default NULL, - `owner_user_id` bigint(20) unsigned default NULL, - `owner_group_id` int(11) unsigned default NULL, - `is_active` char(1) NOT NULL default 'N', - PRIMARY KEY (`auth_user_id`,`handle`) -) TYPE=MyISAM; - -# # Dumping data for table `liveuser_users` # @@ -465,7 +119,4 @@ # Dumping data for table `news_seq` # -INSERT INTO `news_seq` VALUES (3); - - - +INSERT INTO `news_seq` VALUES (3); \ No newline at end of file