|
Full text of demodata.xml for Example1
This is the full text of demodata.xml for LiveUserAdminExample1
<?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>32</length>
</field>
<field>
<name>description</name>
<type>text</type>
<length>32</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>
LiveUser:FullTextOfDemodataForExample1 (211.30.65.216)
Sat, 21 Jan 2006, 09:33
|
[ Links | Source | History | RSS ]
|
This site powered by YaWiki 0.22 beta.
|
|