Changeset 55 for trunk/config

Show
Ignore:
Timestamp:
12/20/05 11:44:03 (3 years ago)
Author:
fabien
Message:

day 20 modifications

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/config/schema.xml

    r44 r55  
    1212     <column name="html_body" type="longvarchar" /> 
    1313     <column name="interested_users" type="integer" default="0" /> 
     14     <column name="reports" type="integer" default="0" /> 
    1415     <column name="created_at" type="timestamp" /> 
    1516     <column name="updated_at" type="timestamp" /> 
    …… 
    1920     <column name="id" type="integer" required="true" primaryKey="true" autoincrement="true" /> 
    2021     <column name="question_id" type="integer" /> 
    21      <foreign-key foreignTable="ask_question"> 
     22     <foreign-key foreignTable="ask_question" onDelete="cascade"> 
    2223       <reference local="question_id" foreign="id"/> 
    2324     </foreign-key> 
    …… 
    3031     <column name="relevancy_up" type="integer" default="0" /> 
    3132     <column name="relevancy_down" type="integer" default="0" /> 
     33     <column name="reports" type="integer" default="0" /> 
    3234     <column name="created_at" type="timestamp" /> 
    3335   </table> 
    …… 
    4244     <column name="salt" type="varchar" size="32" /> 
    4345     <column name="has_paypal" type="boolean" default="0" /> 
     46     <column name="want_to_be_moderator" type="boolean" default="0" /> 
     47     <column name="is_moderator" type="boolean" default="0" /> 
     48     <column name="is_administrator" type="boolean" default="0" /> 
     49     <column name="deletions" type="integer" default="0" /> 
    4450     <column name="created_at" type="timestamp" /> 
    4551   </table> 
    …… 
    4753   <table name="ask_interest" phpName="Interest"> 
    4854     <column name="question_id" type="integer" primaryKey="true" /> 
    49      <foreign-key foreignTable="ask_question"> 
     55     <foreign-key foreignTable="ask_question" onDelete="cascade"> 
    5056       <reference local="question_id" foreign="id"/> 
    5157     </foreign-key> 
    …… 
    5965   <table name="ask_relevancy" phpName="Relevancy"> 
    6066     <column name="answer_id" type="integer" primaryKey="true" /> 
    61      <foreign-key foreignTable="ask_answer"> 
     67     <foreign-key foreignTable="ask_answer" onDelete="cascade"> 
    6268       <reference local="answer_id" foreign="id"/> 
    6369     </foreign-key> 
    …… 
    7177 
    7278   <table name="ask_question_tag" phpName="QuestionTag"> 
    73      <column name="question_id" type="integer" /> 
    74      <foreign-key foreignTable="ask_question"> 
     79     <column name="question_id" type="integer" primaryKey="true" /> 
     80     <foreign-key foreignTable="ask_question" onDelete="cascade"> 
    7581       <reference local="question_id" foreign="id" /> 
    7682     </foreign-key> 
    77      <column name="user_id" type="integer" /> 
     83     <column name="user_id" type="integer" primaryKey="true" /> 
    7884     <foreign-key foreignTable="ask_user"> 
    7985       <reference local="user_id" foreign="id" /> 
    …… 
    8187     <column name="created_at" type="timestamp" /> 
    8288     <column name="tag" type="varchar" size="100" /> 
    83      <column name="normalized_tag" type="varchar" size="100" /> 
     89     <column name="normalized_tag" type="varchar" size="100" primaryKey="true" /> 
    8490     <index name="normalized_tag_index"> 
    8591       <index-column name="normalized_tag" /> 
    8692     </index> 
    87      <unique name="pk"> 
    88        <unique-column name="question_id" /> 
    89        <unique-column name="user_id" /> 
    90        <unique-column name="normalized_tag" /> 
    91      </unique> 
     93   </table> 
     94 
     95   <table name="ask_report_question" phpName="ReportQuestion"> 
     96     <column name="question_id" type="integer" primaryKey="true" /> 
     97     <foreign-key foreignTable="ask_question" onDelete="cascade"> 
     98       <reference local="question_id" foreign="id" /> 
     99     </foreign-key> 
     100     <column name="user_id" type="integer" primaryKey="true" /> 
     101     <foreign-key foreignTable="ask_user"> 
     102       <reference local="user_id" foreign="id" /> 
     103     </foreign-key> 
     104     <column name="created_at" type="timestamp" /> 
     105   </table> 
     106 
     107   <table name="ask_report_answer" phpName="ReportAnswer"> 
     108     <column name="answer_id" type="integer" primaryKey="true" /> 
     109     <foreign-key foreignTable="ask_answer" onDelete="cascade"> 
     110       <reference local="answer_id" foreign="id" /> 
     111     </foreign-key> 
     112     <column name="user_id" type="integer" primaryKey="true" /> 
     113     <foreign-key foreignTable="ask_user"> 
     114       <reference local="user_id" foreign="id" /> 
     115     </foreign-key> 
     116     <column name="created_at" type="timestamp" /> 
    92117   </table> 
    93118