<?xml version="1.0" encoding="ISO-8859-1" ?> <database> <name><variable>database</variable></name> <create><variable>create</variable></create> <table> <name>liveuser_applications</name> <declaration> <field> <name>application_id</name> <type>integer</type> <default>0</default> </field> <field> <name>application_define_name</name> <type>text</type> <length>32</length> </field> <index> <name>application_id</name> <unique>1</unique> <field> <name>application_id</name> <sorting>ascending</sorting> </field> </index> <index> <name>define_name_i</name> <unique>1</unique> <field> <name>application_define_name</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_area_admin_areas</name> <declaration> <field> <name>area_id</name> <type>integer</type> <default>0</default> </field> <field> <name>perm_user_id</name> <type>integer</type> <default>0</default> </field> <index> <name>id_i</name> <unique>1</unique> <field> <name>area_id</name> <sorting>ascending</sorting> </field> <field> <name>perm_user_id</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_areas</name> <declaration> <field> <name>area_id</name> <type>integer</type> <default>0</default> </field> <field> <name>application_id</name> <type>integer</type> <default>0</default> </field> <field> <name>area_define_name</name> <type>text</type> <length>32</length> </field> <index> <name>area_id</name> <unique>1</unique> <field> <name>area_id</name> <sorting>ascending</sorting> </field> </index> <index> <name>define_name_i</name> <unique>1</unique> <field> <name>application_id</name> <sorting>ascending</sorting> </field> <field> <name>area_define_name</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_group_subgroups</name> <declaration> <field> <name>group_id</name> <type>integer</type> <default>0</default> </field> <field> <name>subgroup_id</name> <type>integer</type> <default>0</default> </field> <index> <name>id_i</name> <unique>1</unique> <field> <name>group_id</name> <sorting>ascending</sorting> </field> <field> <name>subgroup_id</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_grouprights</name> <declaration> <field> <name>group_id</name> <type>integer</type> <default>0</default> </field> <field> <name>right_id</name> <type>integer</type> <default>0</default> </field> <field> <name>right_level</name> <type>integer</type> </field> <index> <name>id_i</name> <unique>1</unique> <field> <name>group_id</name> <sorting>ascending</sorting> </field> <field> <name>right_id</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_groups</name> <declaration> <field> <name>group_id</name> <type>integer</type> <default>0</default> </field> <field> <name>group_type</name> <type>integer</type> </field> <field> <name>group_define_name</name> <type>text</type> <length>32</length> </field> <field> <name>is_active</name> <type>boolean</type> </field> <index> <name>group_id</name> <unique>1</unique> <field> <name>group_id</name> <sorting>ascending</sorting> </field> </index> <index> <name>define_name_i</name> <unique>1</unique> <field> <name>group_define_name</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_groupusers</name> <declaration> <field> <name>perm_user_id</name> <type>integer</type> <default>0</default> </field> <field> <name>group_id</name> <type>integer</type> <default>0</default> </field> <index> <name>id_i</name> <unique>1</unique> <field> <name>perm_user_id</name> <sorting>ascending</sorting> </field> <field> <name>group_id</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_perm_users</name> <declaration> <field> <name>perm_user_id</name> <type>integer</type> <default>0</default> </field> <field> <name>auth_user_id</name> <type>text</type> <length>32</length> </field> <field> <name>auth_container_name</name> <type>text</type> <length>32</length> </field> <field> <name>perm_type</name> <type>integer</type> </field> <index> <name>perm_user_id</name> <unique>1</unique> <field> <name>perm_user_id</name> <sorting>ascending</sorting> </field> </index> <index> <name>auth_id_i</name> <unique>1</unique> <field> <name>auth_user_id</name> <sorting>ascending</sorting> </field> <field> <name>auth_container_name</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_right_implied</name> <declaration> <field> <name>right_id</name> <type>integer</type> <default>0</default> </field> <field> <name>implied_right_id</name> <type>integer</type> <default>0</default> </field> <index> <name>id_i</name> <unique>1</unique> <field> <name>right_id</name> <sorting>ascending</sorting> </field> <field> <name>implied_right_id</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_rights</name> <declaration> <field> <name>right_id</name> <type>integer</type> <default>0</default> </field> <field> <name>area_id</name> <type>integer</type> <default>0</default> </field> <field> <name>right_define_name</name> <type>text</type> <length>32</length> </field> <field> <name>has_implied</name> <type>boolean</type> </field> <index> <name>right_id</name> <unique>1</unique> <field> <name>right_id</name> <sorting>ascending</sorting> </field> </index> <index> <name>define_name_i</name> <unique>1</unique> <field> <name>area_id</name> <sorting>ascending</sorting> </field> <field> <name>right_define_name</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_translations</name> <declaration> <field> <name>translation_id</name> <type>integer</type> <default>0</default> </field> <field> <name>section_id</name> <type>integer</type> <default>0</default> </field> <field> <name>section_type</name> <type>integer</type> <default>0</default> </field> <field> <name>language_id</name> <type>text</type> <length>32</length> </field> <field> <name>name</name> <type>text</type> <length>200</length> </field> <field> <name>description</name> <type>text</type> <length>200</length> </field> <index> <name>translation_id</name> <unique>1</unique> <field> <name>translation_id</name> <sorting>ascending</sorting> </field> </index> <index> <name>translation_i</name> <unique>1</unique> <field> <name>section_id</name> <sorting>ascending</sorting> </field> <field> <name>section_type</name> <sorting>ascending</sorting> </field> <field> <name>language_id</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_userrights</name> <declaration> <field> <name>perm_user_id</name> <type>integer</type> <default>0</default> </field> <field> <name>right_id</name> <type>integer</type> <default>0</default> </field> <field> <name>right_level</name> <type>integer</type> </field> <index> <name>id_i</name> <unique>1</unique> <field> <name>perm_user_id</name> <sorting>ascending</sorting> </field> <field> <name>right_id</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <table> <name>liveuser_users</name> <declaration> <field> <name>user_id</name> <type>text</type> <length>32</length> </field> <field> <name>handle</name> <type>text</type> <length>32</length> </field> <field> <name>passwd</name> <type>text</type> <length>32</length> </field> <field> <name>lastlogin</name> <type>timestamp</type> </field> <field> <name>isactive</name> <type>boolean</type> </field> <field> <name>name</name> <type>text</type> <length>50</length> </field> <field> <name>email</name> <type>text</type> <length>100</length> </field> <index> <name>user_id</name> <unique>1</unique> <field> <name>user_id</name> <sorting>ascending</sorting> </field> </index> </declaration> </table> <sequence> <name>liveuser_applications</name> </sequence> <sequence> <name>liveuser_areas</name> </sequence> <sequence> <name>liveuser_groups</name> </sequence> <sequence> <name>liveuser_perm_users</name> </sequence> <sequence> <name>liveuser_rights</name> </sequence> <sequence> <name>liveuser_translations</name> </sequence> <sequence> <name>liveuser_users</name> </sequence> </database>