Home » Authentication » LiveUser » Bug #1196

[2004-04-13 14:14 UTC] mtacker at itfuture dot de

Description:
------------
Well, the provided SQL-Example is not really usefull.

Take this one instead:

# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 13, 2004 at 04:22 PM
# Server version: 4.0.15
# PHP Version: 4.3.3
#
# Database : `lu_test`
#

# --------------------------------------------------------

#
# Table structure for table `liveuser_application_names`
#

DROP TABLE IF EXISTS `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 `application_names_application_id` (`application_id`),
KEY `application_names_language_id` (`language_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_application_names`
#

INSERT INTO `liveuser_application_names` VALUES (1, 1, 'BACKOFFICE', 'BackOffice for testing');
INSERT INTO `liveuser_application_names` VALUES (1, 1, 'BACKOFFICE', 'BackOffice for testing');
INSERT INTO `liveuser_application_names` VALUES (1, 1, 'BACKOFFICE', 'BackOffice for testing');
INSERT INTO `liveuser_application_names` VALUES (1, 1, 'BACKOFFICE', 'BackOffice for testing');
INSERT INTO `liveuser_application_names` VALUES (1, 1, 'BACKOFFICE', 'BackOffice for testing');
INSERT INTO `liveuser_application_names` VALUES (1, 1, 'BACKOFFICE', 'BackOffice for testing');
INSERT INTO `liveuser_application_names` VALUES (1, 1, 'BACKOFFICE', 'BackOffice for testing');
INSERT INTO `liveuser_application_names` VALUES (1, 1, 'BACKOFFICE', 'BackOffice for testing');

# --------------------------------------------------------

#
# Table structure for table `liveuser_applications`
#

DROP TABLE IF EXISTS `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 `application_define_name` (`application_define_name`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_applications`
#

INSERT INTO `liveuser_applications` VALUES (1, 'BACKOFFICE');

# --------------------------------------------------------

#
# Table structure for table `liveuser_area_admin_areas`
#

DROP TABLE IF EXISTS `liveuser_area_admin_areas`;
CREATE TABLE `liveuser_area_admin_areas` (
`area_id` int(11) unsigned NOT NULL default '0',
`perm_user_id` int(11) unsigned 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_area_names`
#

DROP TABLE IF EXISTS `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 `area_names_area_id` (`area_id`),
KEY `area_names_language_id` (`language_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_area_names`
#

INSERT INTO `liveuser_area_names` VALUES (1, 1, 'NEWS', 'News');
INSERT INTO `liveuser_area_names` VALUES (1, 1, 'NEWS', 'News');
INSERT INTO `liveuser_area_names` VALUES (1, 1, 'NEWS', 'News');
INSERT INTO `liveuser_area_names` VALUES (1, 1, 'NEWS', 'News');
INSERT INTO `liveuser_area_names` VALUES (1, 1, 'NEWS', 'News');
INSERT INTO `liveuser_area_names` VALUES (1, 1, 'NEWS', 'News');
INSERT INTO `liveuser_area_names` VALUES (1, 1, 'NEWS', 'News');
INSERT INTO `liveuser_area_names` VALUES (1, 1, 'NEWS', 'News');

# --------------------------------------------------------

#
# Table structure for table `liveuser_areas`
#

DROP TABLE IF EXISTS `liveuser_areas`;
CREATE TABLE `liveuser_areas` (
`area_id` int(11) unsigned NOT NULL default '0',
`application_id` int(11) unsigned NOT NULL default '0',
`area_define_name` varchar(20) NOT NULL default '',
PRIMARY KEY (`area_id`),
KEY `areas_application_id` (`application_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_areas`
#

INSERT INTO `liveuser_areas` VALUES (1, 1, 'NEWS');

# --------------------------------------------------------

#
# Table structure for table `liveuser_group_names`
#

DROP TABLE IF EXISTS `liveuser_group_names`;
CREATE TABLE `liveuser_group_names` (
`group_name_id` int(11) unsigned NOT NULL default '0',
`group_id` int(11) unsigned NOT NULL default '0',
`group_name` varchar(32) NOT NULL default '',
`group_comment` tinytext NOT NULL,
PRIMARY KEY (`group_name_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_group_names`
#

INSERT INTO `liveuser_group_names` VALUES (1, 1, 'ADMINS', 'The admin group can change everything.');
INSERT INTO `liveuser_group_names` VALUES (2, 2, 'GroupA', 'Standard user group.');
INSERT INTO `liveuser_group_names` VALUES (3, 3, 'GroupB', 'Another group.');

# --------------------------------------------------------

#
# Table structure for table `liveuser_group_subgroups`
#

DROP TABLE IF EXISTS `liveuser_group_subgroups`;
CREATE TABLE `liveuser_group_subgroups` (
`group_id` int(11) unsigned NOT NULL default '0',
`subgroup_id` int(11) unsigned 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`
#

DROP TABLE IF EXISTS `liveuser_grouprights`;
CREATE TABLE `liveuser_grouprights` (
`group_id` int(11) unsigned NOT NULL default '0',
`right_id` int(11) unsigned 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`
#

INSERT INTO `liveuser_grouprights` VALUES (1, 3, 3);
INSERT INTO `liveuser_grouprights` VALUES (2, 3, 2);
INSERT INTO `liveuser_grouprights` VALUES (3, 2, 1);

# --------------------------------------------------------

#
# Table structure for table `liveuser_groups`
#

DROP TABLE IF EXISTS `liveuser_groups`;
CREATE TABLE `liveuser_groups` (
`group_id` int(10) unsigned NOT NULL default '0',
`owner_user_id` int(11) unsigned default NULL,
`owner_group_id` int(11) unsigned default NULL,
`is_active` char(1) NOT NULL default 'N',
`group_define_name` varchar(32) NOT NULL default '',
PRIMARY KEY (`group_id`),
KEY `groups_owner_user_id` (`owner_user_id`),
KEY `groups_owner_group_id` (`owner_group_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_groups`
#

INSERT INTO `liveuser_groups` VALUES (1, 0, 0, 'Y', 'ADMINS');
INSERT INTO `liveuser_groups` VALUES (2, 0, 0, 'Y', 'GroupA');
INSERT INTO `liveuser_groups` VALUES (3, 0, 0, 'Y', 'GroupB');

# --------------------------------------------------------

#
# Table structure for table `liveuser_groupusers`
#

DROP TABLE IF EXISTS `liveuser_groupusers`;
CREATE TABLE `liveuser_groupusers` (
`perm_user_id` int(11) unsigned NOT NULL default '0',
`group_id` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`group_id`,`perm_user_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_groupusers`
#

INSERT INTO `liveuser_groupusers` VALUES (1, 1);
INSERT INTO `liveuser_groupusers` VALUES (2, 2);
INSERT INTO `liveuser_groupusers` VALUES (3, 2);
INSERT INTO `liveuser_groupusers` VALUES (2, 3);
INSERT INTO `liveuser_groupusers` VALUES (4, 3);

# --------------------------------------------------------

#
# Table structure for table `liveuser_languages`
#

DROP TABLE IF EXISTS `liveuser_languages`;
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`),
UNIQUE KEY `two_letter_name` (`two_letter_name`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_languages`
#

INSERT INTO `liveuser_languages` VALUES (1, 'en', 'English');

# --------------------------------------------------------

#
# Table structure for table `liveuser_perm_users`
#

DROP TABLE IF EXISTS `liveuser_perm_users`;
CREATE TABLE `liveuser_perm_users` (
`perm_user_id` int(11) unsigned NOT NULL default '0',
`auth_user_id` varchar(32) NOT NULL default '0',
`perm_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`
#

INSERT INTO `liveuser_perm_users` VALUES (1, 'c14cbf141ab1b7cd009356f555b607dc', 1, '');
INSERT INTO `liveuser_perm_users` VALUES (2, '185cd5095e899ab43a225e42d7232807', 1, '');
INSERT INTO `liveuser_perm_users` VALUES (3, '11551a03b7de857163fd2e519c16a960', 1, '');
INSERT INTO `liveuser_perm_users` VALUES (4, '7ddf260b66b9a5c182a91a413f1aa461', 1, '');

# --------------------------------------------------------

#
# Table structure for table `liveuser_right_implied`
#

DROP TABLE IF EXISTS `liveuser_right_implied`;
CREATE TABLE `liveuser_right_implied` (
`right_id` int(11) unsigned NOT NULL default '0',
`implied_right_id` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`implied_right_id`,`right_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_right_implied`
#

INSERT INTO `liveuser_right_implied` VALUES (2, 1);
INSERT INTO `liveuser_right_implied` VALUES (3, 2);

# --------------------------------------------------------

#
# Table structure for table `liveuser_right_scopes`
#

DROP TABLE IF EXISTS `liveuser_right_scopes`;
CREATE TABLE `liveuser_right_scopes` (
`right_id` int(11) unsigned NOT NULL default '0',
`right_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`
#

DROP TABLE IF EXISTS `liveuser_rights`;
CREATE TABLE `liveuser_rights` (
`right_id` int(10) unsigned NOT NULL default '0',
`area_id` int(11) 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 `right_define_name` (`right_define_name`),
KEY `rights_area_id` (`area_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_rights`
#

INSERT INTO `liveuser_rights` VALUES (1, 1, 'NEW', 'N', 'N', 'N');
INSERT INTO `liveuser_rights` VALUES (2, 1, 'CHANGE', 'Y', 'Y', 'N');
INSERT INTO `liveuser_rights` VALUES (3, 1, 'DELETE', 'Y', 'Y', 'N');

# --------------------------------------------------------

#
# Table structure for table `liveuser_translations`
#

DROP TABLE IF EXISTS `liveuser_translations`;
CREATE TABLE `liveuser_translations` (
`section_id` int(16) unsigned NOT NULL default '0',
`section_type` tinyint(3) unsigned NOT NULL default '0',
`language_id` smallint(5) unsigned default NULL,
`name` varchar(50) NOT NULL default '',
`description` varchar(255) default NULL,
PRIMARY KEY (`section_id`,`section_type`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_translations`
#

# --------------------------------------------------------

#
# Table structure for table `liveuser_userrights`
#

DROP TABLE IF EXISTS `liveuser_userrights`;
CREATE TABLE `liveuser_userrights` (
`perm_user_id` int(11) unsigned NOT NULL default '0',
`right_id` int(11) unsigned NOT NULL default '0',
`right_level` tinyint(3) default NULL,
PRIMARY KEY (`right_id`,`perm_user_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_userrights`
#

INSERT INTO `liveuser_userrights` VALUES (2, 2, 3);

# --------------------------------------------------------

#
# Table structure for table `liveuser_users`
#

DROP TABLE IF EXISTS `liveuser_users`;
CREATE TABLE `liveuser_users` (
`auth_user_id` varchar(32) NOT NULL default '0',
`handle` varchar(16) NOT NULL default '',
`passwd` varchar(32) NOT NULL default '',
`lastlogin` varchar(19) NOT NULL default '',
`is_active` enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (`auth_user_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_users`
#

INSERT INTO `liveuser_users` VALUES ('c14cbf141ab1b7cd009356f555b607dc', 'admin', '098f6bcd4621d373cade4e832627b4f6', '2004-04-13 16:19:09', 'Y');
INSERT INTO `liveuser_users` VALUES ('185cd5095e899ab43a225e42d7232807', 'userA', '098f6bcd4621d373cade4e832627b4f6', '2003-03-16 23:01:56', 'Y');
INSERT INTO `liveuser_users` VALUES ('11551a03b7de857163fd2e519c16a960', 'userB', '098f6bcd4621d373cade4e832627b4f6', '2003-03-16 23:01:45', 'Y');
INSERT INTO `liveuser_users` VALUES ('7ddf260b66b9a5c182a91a413f1aa461', 'userC', '098f6bcd4621d373cade4e832627b4f6', '2004-04-13 16:18:50', 'Y');

# --------------------------------------------------------

#
# Table structure for table `news`
#

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`news_id` int(11) NOT NULL auto_increment,
`created_at` varchar(19) NOT NULL default '',
`valid_to` varchar(19) NOT NULL default '',
`news` tinytext NOT NULL,
`owner_user_id` int(11) NOT NULL default '0',
`owner_group_id` int(11) NOT NULL default '0',
PRIMARY KEY (`news_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# Dumping data for table `news`
#

INSERT INTO `news` VALUES (1, '2003-03-16 22:17:21', '2003-03-30 23:17:21', 'Just testing my rights.', 3, 2);
INSERT INTO `news` VALUES (2, '2003-03-16 21:53:41', '2003-04-13 22:53:41', 'Another test ;-)', 1, 1);
INSERT INTO `news` VALUES (3, '2003-03-16 22:42:27', '2003-04-06 23:42:27', 'Yeah! I can make some test postings here', 2, 2);
INSERT INTO `news` VALUES (4, '2003-03-16 23:00:29', '2003-03-23 23:00:29', 'LiveUser is really a cool tool :-)', 4, 3);

[2004-04-14 10:17 UTC] mtacker at itfuture dot de

This error occurs:
---------------------------------------
SQL-query : INSERT INTO liveuser_applications VALUES ( 1, 'BACKOFFICE' )

MySQL said: #1146 - Table 'lu_test.liveuser_applications' doesn't exist
---------------------------------------

Some tables are not created.
Just execute the SQL-Script in an empty DB.

I apologize my previous SQL-Dump. Don't know where
phpmyadmin took these extra lines from.
See the fixed one below.

# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Apr 13, 2004 at 04:15 PM
# Server version: 4.0.15
# PHP Version: 4.3.3
#
# Database : `lu_test`
#

# --------------------------------------------------------

#
# Table structure for table `liveuser_application_names`
#

DROP TABLE IF EXISTS `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 `application_names_application_id` (`application_id`),
KEY `application_names_language_id` (`language_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_application_names`
#

INSERT INTO `liveuser_application_names` VALUES (1, 1, 'BACKOFFICE', 'BackOffice for testing');

# --------------------------------------------------------

#
# Table structure for table `liveuser_applications`
#

DROP TABLE IF EXISTS `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 `application_define_name` (`application_define_name`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_applications`
#

INSERT INTO `liveuser_applications` VALUES (1, 'BACKOFFICE');

# --------------------------------------------------------

#
# Table structure for table `liveuser_area_admin_areas`
#

DROP TABLE IF EXISTS `liveuser_area_admin_areas`;
CREATE TABLE `liveuser_area_admin_areas` (
`area_id` int(11) unsigned NOT NULL default '0',
`perm_user_id` int(11) unsigned 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_area_names`
#

DROP TABLE IF EXISTS `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 `area_names_area_id` (`area_id`),
KEY `area_names_language_id` (`language_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_area_names`
#

INSERT INTO `liveuser_area_names` VALUES (1, 1, 'NEWS', 'News');

# --------------------------------------------------------

#
# Table structure for table `liveuser_areas`
#

DROP TABLE IF EXISTS `liveuser_areas`;
CREATE TABLE `liveuser_areas` (
`area_id` int(11) unsigned NOT NULL default '0',
`application_id` int(11) unsigned NOT NULL default '0',
`area_define_name` varchar(20) NOT NULL default '',
PRIMARY KEY (`area_id`),
KEY `areas_application_id` (`application_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_areas`
#

INSERT INTO `liveuser_areas` VALUES (1, 1, 'NEWS');

# --------------------------------------------------------

#
# Table structure for table `liveuser_group_names`
#

DROP TABLE IF EXISTS `liveuser_group_names`;
CREATE TABLE `liveuser_group_names` (
`group_name_id` int(11) unsigned NOT NULL default '0',
`group_id` int(11) unsigned NOT NULL default '0',
`group_name` varchar(32) NOT NULL default '',
`group_comment` tinytext NOT NULL,
PRIMARY KEY (`group_name_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_group_names`
#

INSERT INTO `liveuser_group_names` VALUES (1, 1, 'ADMINS', 'The admin group can change everything.');
INSERT INTO `liveuser_group_names` VALUES (2, 2, 'GroupA', 'Standard user group.');
INSERT INTO `liveuser_group_names` VALUES (3, 3, 'GroupB', 'Another group.');

# --------------------------------------------------------

#
# Table structure for table `liveuser_group_subgroups`
#

DROP TABLE IF EXISTS `liveuser_group_subgroups`;
CREATE TABLE `liveuser_group_subgroups` (
`group_id` int(11) unsigned NOT NULL default '0',
`subgroup_id` int(11) unsigned 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`
#

DROP TABLE IF EXISTS `liveuser_grouprights`;
CREATE TABLE `liveuser_grouprights` (
`group_id` int(11) unsigned NOT NULL default '0',
`right_id` int(11) unsigned 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`
#

INSERT INTO `liveuser_grouprights` VALUES (1, 3, 3);
INSERT INTO `liveuser_grouprights` VALUES (2, 3, 2);
INSERT INTO `liveuser_grouprights` VALUES (3, 2, 1);

# --------------------------------------------------------

#
# Table structure for table `liveuser_groups`
#

DROP TABLE IF EXISTS `liveuser_groups`;
CREATE TABLE `liveuser_groups` (
`group_id` int(10) unsigned NOT NULL default '0',
`owner_user_id` int(11) unsigned default NULL,
`owner_group_id` int(11) unsigned default NULL,
`is_active` char(1) NOT NULL default 'N',
`group_define_name` varchar(32) NOT NULL default '',
PRIMARY KEY (`group_id`),
KEY `groups_owner_user_id` (`owner_user_id`),
KEY `groups_owner_group_id` (`owner_group_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_groups`
#

INSERT INTO `liveuser_groups` VALUES (1, 0, 0, 'Y', 'ADMINS');
INSERT INTO `liveuser_groups` VALUES (2, 0, 0, 'Y', 'GroupA');
INSERT INTO `liveuser_groups` VALUES (3, 0, 0, 'Y', 'GroupB');

# --------------------------------------------------------

#
# Table structure for table `liveuser_groupusers`
#

DROP TABLE IF EXISTS `liveuser_groupusers`;
CREATE TABLE `liveuser_groupusers` (
`perm_user_id` int(11) unsigned NOT NULL default '0',
`group_id` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`group_id`,`perm_user_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_groupusers`
#

INSERT INTO `liveuser_groupusers` VALUES (1, 1);
INSERT INTO `liveuser_groupusers` VALUES (2, 2);
INSERT INTO `liveuser_groupusers` VALUES (3, 2);
INSERT INTO `liveuser_groupusers` VALUES (2, 3);
INSERT INTO `liveuser_groupusers` VALUES (4, 3);

# --------------------------------------------------------

#
# Table structure for table `liveuser_languages`
#

DROP TABLE IF EXISTS `liveuser_languages`;
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`),
UNIQUE KEY `two_letter_name` (`two_letter_name`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_languages`
#

INSERT INTO `liveuser_languages` VALUES (1, 'en', 'English');

# --------------------------------------------------------

#
# Table structure for table `liveuser_perm_users`
#

DROP TABLE IF EXISTS `liveuser_perm_users`;
CREATE TABLE `liveuser_perm_users` (
`perm_user_id` int(11) unsigned NOT NULL default '0',
`auth_user_id` varchar(32) NOT NULL default '0',
`perm_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`
#

INSERT INTO `liveuser_perm_users` VALUES (1, 'c14cbf141ab1b7cd009356f555b607dc', 1, '');
INSERT INTO `liveuser_perm_users` VALUES (2, '185cd5095e899ab43a225e42d7232807', 1, '');
INSERT INTO `liveuser_perm_users` VALUES (3, '11551a03b7de857163fd2e519c16a960', 1, '');
INSERT INTO `liveuser_perm_users` VALUES (4, '7ddf260b66b9a5c182a91a413f1aa461', 1, '');

# --------------------------------------------------------

#
# Table structure for table `liveuser_right_implied`
#

DROP TABLE IF EXISTS `liveuser_right_implied`;
CREATE TABLE `liveuser_right_implied` (
`right_id` int(11) unsigned NOT NULL default '0',
`implied_right_id` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`implied_right_id`,`right_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_right_implied`
#

INSERT INTO `liveuser_right_implied` VALUES (2, 1);
INSERT INTO `liveuser_right_implied` VALUES (3, 2);

# --------------------------------------------------------

#
# Table structure for table `liveuser_right_scopes`
#

DROP TABLE IF EXISTS `liveuser_right_scopes`;
CREATE TABLE `liveuser_right_scopes` (
`right_id` int(11) unsigned NOT NULL default '0',
`right_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`
#

DROP TABLE IF EXISTS `liveuser_rights`;
CREATE TABLE `liveuser_rights` (
`right_id` int(10) unsigned NOT NULL default '0',
`area_id` int(11) 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 `right_define_name` (`right_define_name`),
KEY `rights_area_id` (`area_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_rights`
#

INSERT INTO `liveuser_rights` VALUES (1, 1, 'NEW', 'N', 'N', 'N');
INSERT INTO `liveuser_rights` VALUES (2, 1, 'CHANGE', 'Y', 'Y', 'N');
INSERT INTO `liveuser_rights` VALUES (3, 1, 'DELETE', 'Y', 'Y', 'N');

# --------------------------------------------------------

#
# Table structure for table `liveuser_translations`
#

DROP TABLE IF EXISTS `liveuser_translations`;
CREATE TABLE `liveuser_translations` (
`section_id` int(16) unsigned NOT NULL default '0',
`section_type` tinyint(3) unsigned NOT NULL default '0',
`language_id` smallint(5) unsigned default NULL,
`name` varchar(50) NOT NULL default '',
`description` varchar(255) default NULL,
PRIMARY KEY (`section_id`,`section_type`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_translations`
#

# --------------------------------------------------------

#
# Table structure for table `liveuser_userrights`
#

DROP TABLE IF EXISTS `liveuser_userrights`;
CREATE TABLE `liveuser_userrights` (
`perm_user_id` int(11) unsigned NOT NULL default '0',
`right_id` int(11) unsigned NOT NULL default '0',
`right_level` tinyint(3) default NULL,
PRIMARY KEY (`right_id`,`perm_user_id`)
) TYPE=MyISAM;

#
# Dumping data for table `liveuser_userrights`
#

INSERT INTO `liveuser_userrights` VALUES (2, 2, 3);

# --------------------------------------------------------

#
# Table structure for table `liveuser_users`
#

DROP TABLE IF EXISTS `liveuser_users`;
CREATE TABLE `liveuser_users` (
`auth_user_id` varchar(32) NOT NULL default '0',
`handle` varchar(16) NOT NULL default '',
`passwd` varchar(32) NOT NULL default '',
`lastlogin` varchar(19) NOT NULL default '',
`is_active` enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (`auth_user_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# Dumping data for table `liveuser_users`
#

INSERT INTO `liveuser_users` VALUES ('c14cbf141ab1b7cd009356f555b607dc', 'admin', '098f6bcd4621d373cade4e832627b4f6', '2003-03-16 23:02:06', 'Y');
INSERT INTO `liveuser_users` VALUES ('185cd5095e899ab43a225e42d7232807', 'userA', '098f6bcd4621d373cade4e832627b4f6', '2003-03-16 23:01:56', 'Y');
INSERT INTO `liveuser_users` VALUES ('11551a03b7de857163fd2e519c16a960', 'userB', '098f6bcd4621d373cade4e832627b4f6', '2003-03-16 23:01:45', 'Y');
INSERT INTO `liveuser_users` VALUES ('7ddf260b66b9a5c182a91a413f1aa461', 'userC', '098f6bcd4621d373cade4e832627b4f6', '2004-04-13 16:11:54', 'Y');

# --------------------------------------------------------

#
# Table structure for table `news`
#

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`news_id` int(11) NOT NULL auto_increment,
`created_at` varchar(19) NOT NULL default '',
`valid_to` varchar(19) NOT NULL default '',
`news` tinytext NOT NULL,
`owner_user_id` int(11) NOT NULL default '0',
`owner_group_id` int(11) NOT NULL default '0',
PRIMARY KEY (`news_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

#
# Dumping data for table `news`
#

INSERT INTO `news` VALUES (1, '2003-03-16 22:17:21', '2003-03-30 23:17:21', 'Just testing my rights.', 3, 2);
INSERT INTO `news` VALUES (2, '2003-03-16 21:53:41', '2003-04-13 22:53:41', 'Another test ;-)', 1, 1);
INSERT INTO `news` VALUES (3, '2003-03-16 22:42:27', '2003-04-06 23:42:27', 'Yeah! I can make some test postings here', 2, 2);
INSERT INTO `news` VALUES (4, '2003-03-16 23:00:29', '2003-03-23 23:00:29', 'LiveUser is really a cool tool :-)', 4, 3);

[2004-04-26 20:26 UTC] sherif at users dot sourgeforge dot net

Just downloading and testing 1.10. Examples are broken as reported.

Demodata.sql in example3 is broken. It tries to add data to several tables ending with _names, like liveuser_area_names and liveuser_group_names.

The db creation scripts do not contain these tables.