[Cobricks-cvscommit] cobricks2/src/org/cobricks/agent/db user_rulesactions.xml user_rules.xml user_rulesconditions.xml tables.txt

[jiang <jia...@us...>]

Update of /cvsroot/cobricks/cobricks2/src/org/cobricks/agent/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv2933/src/org/cobricks/agent/db

Added Files:
	user_rulesactions.xml user_rules.xml user_rulesconditions.xml 
	tables.txt 
Log Message:
Agent Component 

--- NEW FILE: user_rules.xml ---
<tabledescriptor tablename="user_rules">
  <table version="1">
    <tablelayout>

      <column name="ruleID" type="int" primarykey="true"/>
      <column name="userID" type="int" notnull="true"/>
      <index name="rules_userID">
        <colname>userID</colname>
      </index>

    </tablelayout>
  </table>
</tabledescriptor>


--- NEW FILE: tables.txt ---
user_rules
user_rulesactions
user_rulesconditions

--- NEW FILE: user_rulesactions.xml ---
<tabledescriptor tablename="user_rulesactions">
  <table version="1">
    <tablelayout>

      <column name="rule_actionID" type="int" primarykey="true"/>
      <column name="ruleID" type="int" notnull="true"/>
      <column name="rule_action" type="varchar(255)" notnull="true"></column>
      <column name="message" type="CLOB"></column>
	  <index name="rulesactions_ruleID">
        <colname>ruleID</colname>
      </index>
    </tablelayout>
  </table>
</tabledescriptor>


--- NEW FILE: user_rulesconditions.xml ---
<tabledescriptor tablename="user_rulesconditions">
  <table version="1">
    <tablelayout>

      <column name="rule_conditionID" type="int" primarykey="true"/>
      <column name="ruleID" type="int" notnull="true"/>
      <column name="rule_condition" type="varchar(255)" notnull="true"></column>
	  <index name="rulesconditions_ruleID">
        <colname>ruleID</colname>
      </index>
    </tablelayout>
  </table>
</tabledescriptor>