LiveUser

PEAR::LiveUser authentication and permission framework

[ AdvancedSearch | AreaMap ]

MySQL Dump of demodata for Example 1

This is the full dump of the database in MySQL?? (mysqldump) format for LiveUserAdminExample1. In other words, if you populated the database according to the demodata.xml file and then dumped it using mysqldump, this is what you would get.

You can load this into your database using:

mysql -p liveuser_test < this_file.txt

-- MySQL dump 10.9
--

--
-- Table structure for table `liveuser_applications`
--
DROP TABLE IF EXISTS `liveuser_applications`;
CREATE TABLE `liveuser_applications` (
  `application_id` int(11) default '0',
  `application_define_name` char(32) default NULL,
  UNIQUE KEY `application_id_idx` (`application_id`),
  UNIQUE KEY `define_name_i_idx` (`application_define_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_applications_seq`
--
DROP TABLE IF EXISTS `liveuser_applications_seq`;
CREATE TABLE `liveuser_applications_seq` (
  `sequence` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) default '0',
  `perm_user_id` int(11) default '0',
  UNIQUE KEY `id_i_idx` (`area_id`,`perm_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_areas`
--
DROP TABLE IF EXISTS `liveuser_areas`;
CREATE TABLE `liveuser_areas` (
  `area_id` int(11) default '0',
  `application_id` int(11) default '0',
  `area_define_name` char(32) default NULL,
  UNIQUE KEY `area_id_idx` (`area_id`),
  UNIQUE KEY `define_name_i_idx` (`application_id`,`area_define_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_areas_seq`
--
DROP TABLE IF EXISTS `liveuser_areas_seq`;
CREATE TABLE `liveuser_areas_seq` (
  `sequence` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_group_subgroups`
--
DROP TABLE IF EXISTS `liveuser_group_subgroups`;
CREATE TABLE `liveuser_group_subgroups` (
  `group_id` int(11) default '0',
  `subgroup_id` int(11) default '0',
  UNIQUE KEY `id_i_idx` (`group_id`,`subgroup_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_grouprights`
--
DROP TABLE IF EXISTS `liveuser_grouprights`;
CREATE TABLE `liveuser_grouprights` (
  `group_id` int(11) default '0',
  `right_id` int(11) default '0',
  `right_level` int(11) default NULL,
  UNIQUE KEY `id_i_idx` (`group_id`,`right_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_groups`
--
DROP TABLE IF EXISTS `liveuser_groups`;
CREATE TABLE `liveuser_groups` (
  `group_id` int(11) default '0',
  `group_type` int(11) default NULL,
  `group_define_name` char(32) default NULL,
  `is_active` char(1) default NULL,
  UNIQUE KEY `group_id_idx` (`group_id`),
  UNIQUE KEY `define_name_i_idx` (`group_define_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_groups_seq`
--
DROP TABLE IF EXISTS `liveuser_groups_seq`;
CREATE TABLE `liveuser_groups_seq` (
  `sequence` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_groupusers`
--
DROP TABLE IF EXISTS `liveuser_groupusers`;
CREATE TABLE `liveuser_groupusers` (
  `perm_user_id` int(11) default '0',
  `group_id` int(11) default '0',
  UNIQUE KEY `id_i_idx` (`perm_user_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_perm_users`
--
DROP TABLE IF EXISTS `liveuser_perm_users`;
CREATE TABLE `liveuser_perm_users` (
  `perm_user_id` int(11) default '0',
  `auth_user_id` char(32) default NULL,
  `auth_container_name` char(32) default NULL,
  `perm_type` int(11) default NULL,
  UNIQUE KEY `perm_user_id_idx` (`perm_user_id`),
  UNIQUE KEY `auth_id_i_idx` (`auth_user_id`,`auth_container_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_perm_users_seq`
--
DROP TABLE IF EXISTS `liveuser_perm_users_seq`;
CREATE TABLE `liveuser_perm_users_seq` (
  `sequence` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_right_implied`
--
DROP TABLE IF EXISTS `liveuser_right_implied`;
CREATE TABLE `liveuser_right_implied` (
  `right_id` int(11) default '0',
  `implied_right_id` int(11) default '0',
  UNIQUE KEY `id_i_idx` (`right_id`,`implied_right_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_rights`
--
DROP TABLE IF EXISTS `liveuser_rights`;
CREATE TABLE `liveuser_rights` (
  `right_id` int(11) default '0',
  `area_id` int(11) default '0',
  `right_define_name` char(32) default NULL,
  `has_implied` char(1) default NULL,
  UNIQUE KEY `right_id_idx` (`right_id`),
  UNIQUE KEY `define_name_i_idx` (`area_id`,`right_define_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_rights_seq`
--
DROP TABLE IF EXISTS `liveuser_rights_seq`;
CREATE TABLE `liveuser_rights_seq` (
  `sequence` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_translations`
--
DROP TABLE IF EXISTS `liveuser_translations`;
CREATE TABLE `liveuser_translations` (
  `translation_id` int(11) default '0',
  `section_id` int(11) default '0',
  `section_type` int(11) default '0',
  `language_id` char(32) default NULL,
  `name` char(32) default NULL,
  `description` char(32) default NULL,
  UNIQUE KEY `translation_id_idx` (`translation_id`),
  UNIQUE KEY `translation_i_idx` (`section_id`,`section_type`,`language_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_translations_seq`
--
DROP TABLE IF EXISTS `liveuser_translations_seq`;
CREATE TABLE `liveuser_translations_seq` (
  `sequence` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_userrights`
--
DROP TABLE IF EXISTS `liveuser_userrights`;
CREATE TABLE `liveuser_userrights` (
  `perm_user_id` int(11) default '0',
  `right_id` int(11) default '0',
  `right_level` int(11) default NULL,
  UNIQUE KEY `id_i_idx` (`perm_user_id`,`right_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_users`
--
DROP TABLE IF EXISTS `liveuser_users`;
CREATE TABLE `liveuser_users` (
  `user_id` char(32) default NULL,
  `handle` char(32) default NULL,
  `passwd` char(32) default NULL,
  `lastlogin` datetime default NULL,
  `isactive` char(1) default NULL,
  `name` char(50) default NULL,
  `email` char(100) default NULL,
  UNIQUE KEY `user_id_idx` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `liveuser_users_seq`
--
DROP TABLE IF EXISTS `liveuser_users_seq`;
CREATE TABLE `liveuser_users_seq` (
  `sequence` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`sequence`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

This site powered by YaWiki 0.22 beta.