cvs: pear /Perm_LiveUser/sql liveUser_MDB.sql
| From: | Markus Wolff | Date: | Wed, 21 Aug 2002 22:44:06 +0000 |
| Subject: | cvs: pear /Perm_LiveUser/sql liveUser_MDB.sql | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-5871@lists.php.net to get a copy of this message | ||
mw21st Wed Aug 21 18:44:06 2002 EDT
Added files:
/pear/Perm_LiveUser/sql liveUser_MDB.sql
Log:
Initial commit, second try with the now correct package name Perm_LiveUser
Index: pear/Perm_LiveUser/sql/liveUser_MDB.sql +++ pear/Perm_LiveUser/sql/liveUser_MDB.sql # phpMyAdmin MySQL-Dump # version 2.3.0 # http://phpwizard.net/phpMyAdmin/ # http://www.phpmyadmin.net/ (download page) # # Host: localhost # Erstellungszeit: 20. August 2002 um 20:53 # Server Version: 3.23.41 # PHP-Version: 4.2.0 # Datenbank: `liveUser_MDB` # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_area_admin_areas` # CREATE TABLE liveUser_area_admin_areas ( user_id bigint(20) NOT NULL default '0', autharea_id int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_area_admin_areas` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_autharea_names` # CREATE TABLE liveUser_autharea_names ( autharea_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', autharea_name char(20) NOT NULL default '', autharea_comment char(255) default NULL, UNIQUE KEY group_id (autharea_id,language_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_autharea_names` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authareas` # CREATE TABLE liveUser_authareas ( autharea_id int(11) NOT NULL default '0', area_define_name char(20) NOT NULL default '', area_comment char(255) default NULL, UNIQUE KEY autharea_id (autharea_id), KEY autharea_id_2 (autharea_id,area_define_name) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authareas` # INSERT INTO liveUser_authareas VALUES (1, 'TestArea', 'Eine AuthArea zum testen.'); INSERT INTO liveUser_authareas VALUES (2, 'Area51', 'Noch eine Testarea'); INSERT INTO liveUser_authareas VALUES (3, 'Coffeemaker', 'Kaffemaschine'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authareas_seq` # CREATE TABLE liveUser_authareas_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authareas_seq` # INSERT INTO liveUser_authareas_seq VALUES (3); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authright_implied` # CREATE TABLE liveUser_authright_implied ( authright_id int(11) NOT NULL default '0', implied_authright_id int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authright_implied` # INSERT INTO liveUser_authright_implied VALUES (7, 6); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authright_scopes` # CREATE TABLE liveUser_authright_scopes ( authright_id int(11) NOT NULL default '0', type int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authright_scopes` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authrights` # CREATE TABLE liveUser_authrights ( authright_id int(11) NOT NULL default '0', autharea_id int(11) NOT NULL default '0', authright_define_name char(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', UNIQUE KEY authright_id (authright_id), KEY authright_id_2 (authright_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authrights` # INSERT INTO liveUser_authrights VALUES (1, 1, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (2, 1, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (3, 1, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (4, 1, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (5, 2, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (7, 3, 'LIVEUSER_DRINK_COFFEE', 'Y', 'Y', 'Y'); INSERT INTO liveUser_authrights VALUES (6, 3, 'LIVEUSER_MAKE_COFFEE', 'N', 'N', 'N'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authrights_names` # CREATE TABLE liveUser_authrights_names ( authright_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', authright_name char(20) NOT NULL default '', authright_comment char(255) default NULL, UNIQUE KEY group_id (authright_id,language_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authrights_names` # INSERT INTO liveUser_authrights_names VALUES (1, 1, 'Read', 'Leserechte'); INSERT INTO liveUser_authrights_names VALUES (2, 1, 'New', 'Neues anlegen'); INSERT INTO liveUser_authrights_names VALUES (3, 1, 'Change', 'Vorhandenes ändern'); INSERT INTO liveUser_authrights_names VALUES (4, 1, 'Delete', 'Löschen'); INSERT INTO liveUser_authrights_names VALUES (5, 1, 'Read', 'Lesen in Area51'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authrights_seq` # CREATE TABLE liveUser_authrights_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authrights_seq` # INSERT INTO liveUser_authrights_seq VALUES (7); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_group_names` # CREATE TABLE liveUser_group_names ( group_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', group_name char(20) NOT NULL default '', group_comment char(255) default NULL, UNIQUE KEY group_id (group_id,language_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_group_names` # INSERT INTO liveUser_group_names VALUES (1, 1, 'Dummies', 'Die Dummy-Gruppe'); INSERT INTO liveUser_group_names VALUES (2, 1, 'Genies', 'Die wahren Genies (verkannt, aber brilliant)'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_group_subgroups` # CREATE TABLE liveUser_group_subgroups ( group_id int(11) NOT NULL default '0', subgroup_id int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_group_subgroups` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_grouprights` # CREATE TABLE liveUser_grouprights ( group_id int(11) NOT NULL default '0', authright_id int(11) NOT NULL default '0', authright_level tinyint(4) default NULL ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_grouprights` # INSERT INTO liveUser_grouprights VALUES (1, 3, NULL); INSERT INTO liveUser_grouprights VALUES (1, 4, NULL); INSERT INTO liveUser_grouprights VALUES (2, 5, NULL); INSERT INTO liveUser_grouprights VALUES (1, 7, 2); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_groups` # CREATE TABLE liveUser_groups ( group_id int(11) NOT NULL default '0', owner_user_id bigint(20) default NULL, owner_group_id int(11) default NULL, is_active char(1) NOT NULL default 'N', UNIQUE KEY group_id (group_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_groups` # INSERT INTO liveUser_groups VALUES (1, 1, NULL, 'Y'); INSERT INTO liveUser_groups VALUES (2, 1, 1, 'Y'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_groups_seq` # CREATE TABLE liveUser_groups_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_groups_seq` # INSERT INTO liveUser_groups_seq VALUES (2); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_groupusers` # CREATE TABLE liveUser_groupusers ( group_id int(11) NOT NULL default '0', user_id bigint(20) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_groupusers` # INSERT INTO liveUser_groupusers VALUES (1, 1); INSERT INTO liveUser_groupusers VALUES (1, 2); INSERT INTO liveUser_groupusers VALUES (2, 1); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_language_names` # CREATE TABLE liveUser_language_names ( native_language_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', native_name char(50) default NULL ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_language_names` # INSERT INTO liveUser_language_names VALUES (2, 1, 'german'); INSERT INTO liveUser_language_names VALUES (2, 1, 'Englisch'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_languages` # CREATE TABLE liveUser_languages ( language_id int(11) NOT NULL default '0', two_letter_name char(2) default NULL, native_name char(50) default NULL, UNIQUE KEY two_letter_name (two_letter_name), UNIQUE KEY language_id (language_id), KEY language_id_2 (language_id), KEY two_letter_name_2 (two_letter_name) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_languages` # INSERT INTO liveUser_languages VALUES (1, 'de', 'Deutsch'); INSERT INTO liveUser_languages VALUES (2, 'en', 'english'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_languages_seq` # CREATE TABLE liveUser_languages_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_languages_seq` # INSERT INTO liveUser_languages_seq VALUES (2); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_profiles` # CREATE TABLE liveUser_profiles ( profile_id bigint(20) NOT NULL default '0', user_id bigint(20) NOT NULL default '0', vorname char(35) NOT NULL default '', name char(35) NOT NULL default '', anrede char(35) default NULL, firma char(50) default NULL, email char(50) NOT NULL default '', telefon char(20) default NULL, UNIQUE KEY profile_id (profile_id), KEY profile_id_2 (profile_id,user_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_profiles` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_profiles_seq` # CREATE TABLE liveUser_profiles_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_profiles_seq` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_userrights` # CREATE TABLE liveUser_userrights ( user_id bigint(20) NOT NULL default '0', authright_id int(11) NOT NULL default '0', authright_level tinyint(4) default NULL ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_userrights` # INSERT INTO liveUser_userrights VALUES (1, 1, 1); INSERT INTO liveUser_userrights VALUES (1, 2, 1); INSERT INTO liveUser_userrights VALUES (1, 3, -1); INSERT INTO liveUser_userrights VALUES (1, 6, 1); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_users` # CREATE TABLE liveUser_users ( user_id bigint(20) NOT NULL default '0', handle char(20) NOT NULL default '', password char(20) NOT NULL default '', type tinyint(4) NOT NULL default '0', currentlogin datetime default NULL, lastlogin datetime default NULL, owner_user_id bigint(20) default NULL, owner_group_id int(11) default NULL, is_active char(1) NOT NULL default 'N', UNIQUE KEY user_id (user_id,handle), KEY user_id_2 (user_id,handle) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_users` # INSERT INTO liveUser_users VALUES (1, 'mwolff', 'lappoid', 1, NULL, NULL, NULL, 1, 'Y'); INSERT INTO liveUser_users VALUES (2, 'hoss', 'bonanza', 0, NULL, NULL, 1, NULL, 'N'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_users_seq` # CREATE TABLE liveUser_users_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_users_seq` # INSERT INTO liveUser_users_seq VALUES (2);
Index: pear/Perm_LiveUser/sql/liveUser_MDB.sql +++ pear/Perm_LiveUser/sql/liveUser_MDB.sql # phpMyAdmin MySQL-Dump # version 2.3.0 # http://phpwizard.net/phpMyAdmin/ # http://www.phpmyadmin.net/ (download page) # # Host: localhost # Erstellungszeit: 20. August 2002 um 20:53 # Server Version: 3.23.41 # PHP-Version: 4.2.0 # Datenbank: `liveUser_MDB` # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_area_admin_areas` # CREATE TABLE liveUser_area_admin_areas ( user_id bigint(20) NOT NULL default '0', autharea_id int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_area_admin_areas` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_autharea_names` # CREATE TABLE liveUser_autharea_names ( autharea_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', autharea_name char(20) NOT NULL default '', autharea_comment char(255) default NULL, UNIQUE KEY group_id (autharea_id,language_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_autharea_names` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authareas` # CREATE TABLE liveUser_authareas ( autharea_id int(11) NOT NULL default '0', area_define_name char(20) NOT NULL default '', area_comment char(255) default NULL, UNIQUE KEY autharea_id (autharea_id), KEY autharea_id_2 (autharea_id,area_define_name) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authareas` # INSERT INTO liveUser_authareas VALUES (1, 'TestArea', 'Eine AuthArea zum testen.'); INSERT INTO liveUser_authareas VALUES (2, 'Area51', 'Noch eine Testarea'); INSERT INTO liveUser_authareas VALUES (3, 'Coffeemaker', 'Kaffemaschine'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authareas_seq` # CREATE TABLE liveUser_authareas_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authareas_seq` # INSERT INTO liveUser_authareas_seq VALUES (3); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authright_implied` # CREATE TABLE liveUser_authright_implied ( authright_id int(11) NOT NULL default '0', implied_authright_id int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authright_implied` # INSERT INTO liveUser_authright_implied VALUES (7, 6); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authright_scopes` # CREATE TABLE liveUser_authright_scopes ( authright_id int(11) NOT NULL default '0', type int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authright_scopes` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authrights` # CREATE TABLE liveUser_authrights ( authright_id int(11) NOT NULL default '0', autharea_id int(11) NOT NULL default '0', authright_define_name char(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', UNIQUE KEY authright_id (authright_id), KEY authright_id_2 (authright_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authrights` # INSERT INTO liveUser_authrights VALUES (1, 1, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (2, 1, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (3, 1, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (4, 1, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (5, 2, '', 'N', 'N', 'N'); INSERT INTO liveUser_authrights VALUES (7, 3, 'LIVEUSER_DRINK_COFFEE', 'Y', 'Y', 'Y'); INSERT INTO liveUser_authrights VALUES (6, 3, 'LIVEUSER_MAKE_COFFEE', 'N', 'N', 'N'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authrights_names` # CREATE TABLE liveUser_authrights_names ( authright_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', authright_name char(20) NOT NULL default '', authright_comment char(255) default NULL, UNIQUE KEY group_id (authright_id,language_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authrights_names` # INSERT INTO liveUser_authrights_names VALUES (1, 1, 'Read', 'Leserechte'); INSERT INTO liveUser_authrights_names VALUES (2, 1, 'New', 'Neues anlegen'); INSERT INTO liveUser_authrights_names VALUES (3, 1, 'Change', 'Vorhandenes ändern'); INSERT INTO liveUser_authrights_names VALUES (4, 1, 'Delete', 'Löschen'); INSERT INTO liveUser_authrights_names VALUES (5, 1, 'Read', 'Lesen in Area51'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_authrights_seq` # CREATE TABLE liveUser_authrights_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_authrights_seq` # INSERT INTO liveUser_authrights_seq VALUES (7); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_group_names` # CREATE TABLE liveUser_group_names ( group_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', group_name char(20) NOT NULL default '', group_comment char(255) default NULL, UNIQUE KEY group_id (group_id,language_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_group_names` # INSERT INTO liveUser_group_names VALUES (1, 1, 'Dummies', 'Die Dummy-Gruppe'); INSERT INTO liveUser_group_names VALUES (2, 1, 'Genies', 'Die wahren Genies (verkannt, aber brilliant)'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_group_subgroups` # CREATE TABLE liveUser_group_subgroups ( group_id int(11) NOT NULL default '0', subgroup_id int(11) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_group_subgroups` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_grouprights` # CREATE TABLE liveUser_grouprights ( group_id int(11) NOT NULL default '0', authright_id int(11) NOT NULL default '0', authright_level tinyint(4) default NULL ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_grouprights` # INSERT INTO liveUser_grouprights VALUES (1, 3, NULL); INSERT INTO liveUser_grouprights VALUES (1, 4, NULL); INSERT INTO liveUser_grouprights VALUES (2, 5, NULL); INSERT INTO liveUser_grouprights VALUES (1, 7, 2); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_groups` # CREATE TABLE liveUser_groups ( group_id int(11) NOT NULL default '0', owner_user_id bigint(20) default NULL, owner_group_id int(11) default NULL, is_active char(1) NOT NULL default 'N', UNIQUE KEY group_id (group_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_groups` # INSERT INTO liveUser_groups VALUES (1, 1, NULL, 'Y'); INSERT INTO liveUser_groups VALUES (2, 1, 1, 'Y'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_groups_seq` # CREATE TABLE liveUser_groups_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_groups_seq` # INSERT INTO liveUser_groups_seq VALUES (2); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_groupusers` # CREATE TABLE liveUser_groupusers ( group_id int(11) NOT NULL default '0', user_id bigint(20) NOT NULL default '0' ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_groupusers` # INSERT INTO liveUser_groupusers VALUES (1, 1); INSERT INTO liveUser_groupusers VALUES (1, 2); INSERT INTO liveUser_groupusers VALUES (2, 1); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_language_names` # CREATE TABLE liveUser_language_names ( native_language_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', native_name char(50) default NULL ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_language_names` # INSERT INTO liveUser_language_names VALUES (2, 1, 'german'); INSERT INTO liveUser_language_names VALUES (2, 1, 'Englisch'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_languages` # CREATE TABLE liveUser_languages ( language_id int(11) NOT NULL default '0', two_letter_name char(2) default NULL, native_name char(50) default NULL, UNIQUE KEY two_letter_name (two_letter_name), UNIQUE KEY language_id (language_id), KEY language_id_2 (language_id), KEY two_letter_name_2 (two_letter_name) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_languages` # INSERT INTO liveUser_languages VALUES (1, 'de', 'Deutsch'); INSERT INTO liveUser_languages VALUES (2, 'en', 'english'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_languages_seq` # CREATE TABLE liveUser_languages_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_languages_seq` # INSERT INTO liveUser_languages_seq VALUES (2); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_profiles` # CREATE TABLE liveUser_profiles ( profile_id bigint(20) NOT NULL default '0', user_id bigint(20) NOT NULL default '0', vorname char(35) NOT NULL default '', name char(35) NOT NULL default '', anrede char(35) default NULL, firma char(50) default NULL, email char(50) NOT NULL default '', telefon char(20) default NULL, UNIQUE KEY profile_id (profile_id), KEY profile_id_2 (profile_id,user_id) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_profiles` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_profiles_seq` # CREATE TABLE liveUser_profiles_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_profiles_seq` # # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_userrights` # CREATE TABLE liveUser_userrights ( user_id bigint(20) NOT NULL default '0', authright_id int(11) NOT NULL default '0', authright_level tinyint(4) default NULL ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_userrights` # INSERT INTO liveUser_userrights VALUES (1, 1, 1); INSERT INTO liveUser_userrights VALUES (1, 2, 1); INSERT INTO liveUser_userrights VALUES (1, 3, -1); INSERT INTO liveUser_userrights VALUES (1, 6, 1); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_users` # CREATE TABLE liveUser_users ( user_id bigint(20) NOT NULL default '0', handle char(20) NOT NULL default '', password char(20) NOT NULL default '', type tinyint(4) NOT NULL default '0', currentlogin datetime default NULL, lastlogin datetime default NULL, owner_user_id bigint(20) default NULL, owner_group_id int(11) default NULL, is_active char(1) NOT NULL default 'N', UNIQUE KEY user_id (user_id,handle), KEY user_id_2 (user_id,handle) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_users` # INSERT INTO liveUser_users VALUES (1, 'mwolff', 'lappoid', 1, NULL, NULL, NULL, 1, 'Y'); INSERT INTO liveUser_users VALUES (2, 'hoss', 'bonanza', 0, NULL, NULL, 1, NULL, 'N'); # -------------------------------------------------------- # # Tabellenstruktur für Tabelle `liveUser_users_seq` # CREATE TABLE liveUser_users_seq ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; # # Daten für Tabelle `liveUser_users_seq` # INSERT INTO liveUser_users_seq VALUES (2);