CREATE TABLE liveuser_users (authUserId CHAR (32) DEFAULT '' NOT NULL, handle CHAR (32) DEFAULT '' NOT NULL, passwd CHAR (32) DEFAULT '' NOT NULL, lastLogin DATETIME DEFAULT NULL, isActive TINYINT(1) DEFAULT NULL, owner_user_id INT DEFAULT NULL, owner_group_id INT DEFAULT NULL)
ALTER TABLE liveuser_users ADD  UNIQUE users_authUserId_idx (authUserId)
ALTER TABLE liveuser_users ADD  UNIQUE users_unique_i_idx (handle)
CREATE TABLE liveuser_users_seq(sequence INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (sequence))
CREATE TABLE liveuser_perm_users (perm_user_id INT DEFAULT 0 NOT NULL, auth_user_id CHAR (32) DEFAULT '' NOT NULL, auth_container_name CHAR (32) DEFAULT '' NOT NULL, perm_type INT DEFAULT NULL)
ALTER TABLE liveuser_perm_users ADD  UNIQUE perm_users_perm_user_id_idx (perm_user_id)
ALTER TABLE liveuser_perm_users ADD  UNIQUE perm_users_auth_id_i_idx (auth_user_id, auth_container_name)
CREATE TABLE liveuser_userrights (perm_user_id INT DEFAULT 0 NOT NULL, right_id INT DEFAULT 0 NOT NULL, right_level INT DEFAULT NULL)
ALTER TABLE liveuser_userrights ADD  UNIQUE userrights_id_i_idx (perm_user_id, right_id)
CREATE TABLE liveuser_rights (right_id INT DEFAULT 0 NOT NULL, area_id INT DEFAULT 0 NOT NULL, right_define_name CHAR (32) DEFAULT '' NOT NULL, has_implied TINYINT(1) DEFAULT NULL)
ALTER TABLE liveuser_rights ADD  UNIQUE rights_right_id_idx (right_id)
ALTER TABLE liveuser_rights ADD  UNIQUE rights_define_name_i_idx (area_id, right_define_name)
CREATE TABLE liveuser_right_implied (right_id INT DEFAULT 0 NOT NULL, implied_right_id INT DEFAULT 0 NOT NULL)
ALTER TABLE liveuser_right_implied ADD  UNIQUE right_implied_id_i_idx (right_id, implied_right_id)
CREATE TABLE liveuser_translations (translation_id INT DEFAULT 0 NOT NULL, section_id INT DEFAULT 0 NOT NULL, section_type INT DEFAULT 0 NOT NULL, language_id CHAR (32) DEFAULT '' NOT NULL, name CHAR (32) DEFAULT NULL, description CHAR (32) DEFAULT NULL)
ALTER TABLE liveuser_translations ADD  UNIQUE translations_translation_id_idx (translation_id)
ALTER TABLE liveuser_translations ADD  UNIQUE translations_translation_i_idx (section_id, section_type, language_id)
CREATE TABLE liveuser_areas (area_id INT DEFAULT 0 NOT NULL, application_id INT DEFAULT 0 NOT NULL, area_define_name CHAR (32) DEFAULT '' NOT NULL)
ALTER TABLE liveuser_areas ADD  UNIQUE areas_area_id_idx (area_id)
ALTER TABLE liveuser_areas ADD  UNIQUE areas_define_name_i_idx (application_id, area_define_name)
CREATE TABLE liveuser_area_admin_areas (area_id INT DEFAULT 0 NOT NULL, perm_user_id INT DEFAULT 0 NOT NULL)
ALTER TABLE liveuser_area_admin_areas ADD  UNIQUE area_admin_areas_id_i_idx (area_id, perm_user_id)
CREATE TABLE liveuser_applications (application_id INT DEFAULT 0 NOT NULL, application_define_name CHAR (32) DEFAULT '' NOT NULL)
ALTER TABLE liveuser_applications ADD  UNIQUE applications_application_id_idx (application_id)
ALTER TABLE liveuser_applications ADD  UNIQUE applications_define_name_i_idx (application_define_name)
CREATE TABLE liveuser_groups (group_id INT DEFAULT 0 NOT NULL, group_type INT DEFAULT NULL, group_define_name CHAR (32) DEFAULT '' NOT NULL)
ALTER TABLE liveuser_groups ADD  UNIQUE groups_group_id_idx (group_id)
ALTER TABLE liveuser_groups ADD  UNIQUE groups_define_name_i_idx (group_define_name)
CREATE TABLE liveuser_groupusers (perm_user_id INT DEFAULT 0 NOT NULL, group_id INT DEFAULT 0 NOT NULL)
ALTER TABLE liveuser_groupusers ADD  UNIQUE groupusers_id_i_idx (perm_user_id, group_id)
CREATE TABLE liveuser_grouprights (group_id INT DEFAULT 0 NOT NULL, right_id INT DEFAULT 0 NOT NULL, right_level INT DEFAULT NULL)
ALTER TABLE liveuser_grouprights ADD  UNIQUE grouprights_id_i_idx (group_id, right_id)
CREATE TABLE liveuser_group_subgroups (group_id INT DEFAULT 0 NOT NULL, subgroup_id INT DEFAULT 0 NOT NULL)
ALTER TABLE liveuser_group_subgroups ADD  UNIQUE group_subgroups_id_i_idx (group_id, subgroup_id)
CREATE TABLE liveuser_perm_users_seq(sequence INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (sequence))
CREATE TABLE liveuser_rights_seq(sequence INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (sequence))
CREATE TABLE liveuser_translations_seq(sequence INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (sequence))
CREATE TABLE liveuser_areas_seq(sequence INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (sequence))
CREATE TABLE liveuser_applications_seq(sequence INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (sequence))
CREATE TABLE liveuser_groups_seq(sequence INT NOT NULL AUTO_INCREMENT, PRIMARY KEY (sequence))
