xml/schema/SMS/History.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/SMS</base>
   5   <class>History</class>
   6   <name>civicrm_sms_history</name>
   7   <comment>SMS History can be linked to any object in the application.</comment>
   8   <add>1.4</add>
   9   <drop>2.0</drop>
  10   <field>
  11       <name>id</name>
  12       <type>int unsigned</type>
  13       <required>true</required>
  14       <comment>SMS History ID</comment>
  15        <add>1.4</add>
  16   </field>
  17   <primaryKey>
  18        <name>id</name>
  19        <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22        <name>message</name>
  23        <type>text</type>
  24        <comment>Contents of the SMS.</comment>
  25        <htmlType>textarea</htmlType>
  26        <rows>5</rows>
  27        <cols>80</cols>
  28        <add>1.4</add>
  29   </field>
  30   <field>
  31       <name>contact_id</name>
  32       <type>int unsigned</type>
  33       <required>true</required>
  34       <comment>FK to Contact who is sending this SMS</comment>
  35        <add>1.4</add>
  36   </field>
  37   <foreignKey>
  38        <name>contact_id</name>
  39        <table>civicrm_contact</table>
  40        <key>id</key>
  41        <add>1.4</add>
  42   </foreignKey>
  43   <field>
  44        <name>sent_date</name>
  45        <type>date</type>
  46        <comment>When was this SMS sent</comment>
  47        <add>1.4</add>
  48   </field>
  49 </table>