Sophie

Sophie

distrib > Mandriva > 2010.0 > i586 > media > contrib-release > by-pkgid > 0922ca59ee465a47057b809379b5ba34 > files > 18

php-pear-LiveUser_Admin-0.3.9-5mdv2010.0.noarch.rpm

<?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>