Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | <?xml version="1.0" encoding="iso-8859-1" ?> |
2 | ||
3 | <table> | |
4 | <base>CRM/SMS</base> | |
5 | <class>Provider</class> | |
6 | <name>civicrm_sms_provider</name> | |
7 | <comment>Table to add different sms providers </comment> | |
8 | <add>4.2</add> | |
9 | <field> | |
5435b737 | 10 | <name>id</name> |
b3c176f1 | 11 | <title>SMS Provider ID</title> |
5435b737 EM |
12 | <type>int unsigned</type> |
13 | <required>true</required> | |
14 | <comment>SMS Provider ID</comment> | |
0481e12c A |
15 | <html> |
16 | <type>Number</type> | |
17 | </html> | |
5435b737 | 18 | <add>4.2</add> |
6a488035 TO |
19 | </field> |
20 | <primaryKey> | |
5435b737 EM |
21 | <name>id</name> |
22 | <autoincrement>true</autoincrement> | |
6a488035 TO |
23 | </primaryKey> |
24 | <field> | |
5435b737 | 25 | <name>name</name> |
b3c176f1 | 26 | <title>SMS Provider Name</title> |
5435b737 EM |
27 | <type>varchar</type> |
28 | <length>64</length> | |
29 | <comment>Provider internal name points to option_value of option_group sms_provider_name</comment> | |
30 | <add>4.2</add> | |
6a488035 TO |
31 | </field> |
32 | <field> | |
5435b737 | 33 | <name>title</name> |
b3c176f1 | 34 | <title>SMS Provider Title</title> |
5435b737 EM |
35 | <type>varchar</type> |
36 | <length>64</length> | |
37 | <comment>Provider name visible to user</comment> | |
38 | <html> | |
39 | <type>Text</type> | |
40 | </html> | |
41 | <add>4.2</add> | |
6a488035 TO |
42 | </field> |
43 | <field> | |
5435b737 | 44 | <name>username</name> |
b3c176f1 | 45 | <title>SMS Provider Username</title> |
5435b737 EM |
46 | <type>varchar</type> |
47 | <length>255</length> | |
48 | <html> | |
49 | <type>Text</type> | |
50 | </html> | |
51 | <add>4.2</add> | |
6a488035 TO |
52 | </field> |
53 | <field> | |
5435b737 | 54 | <name>password</name> |
b3c176f1 | 55 | <title>SMS Provider Password</title> |
5435b737 EM |
56 | <type>varchar</type> |
57 | <length>255</length> | |
58 | <html> | |
59 | <type>Text</type> | |
60 | </html> | |
61 | <add>4.2</add> | |
6a488035 TO |
62 | </field> |
63 | <field> | |
5435b737 | 64 | <name>api_type</name> |
b3c176f1 | 65 | <title>SMS Provider API</title> |
5435b737 EM |
66 | <type>int unsigned</type> |
67 | <required>true</required> | |
68 | <comment>points to value in civicrm_option_value for group sms_api_type</comment> | |
2d129ae5 PN |
69 | <pseudoconstant> |
70 | <optionGroupName>sms_api_type</optionGroupName> | |
71 | </pseudoconstant> | |
5435b737 EM |
72 | <html> |
73 | <type>Select</type> | |
74 | </html> | |
75 | <add>4.2</add> | |
6a488035 TO |
76 | </field> |
77 | <field> | |
5435b737 | 78 | <name>api_url</name> |
b3c176f1 | 79 | <title>SMS Provider API URL</title> |
5435b737 EM |
80 | <type>varchar</type> |
81 | <length>128</length> | |
82 | <html> | |
83 | <type>Text</type> | |
84 | </html> | |
85 | <add>4.2</add> | |
6a488035 TO |
86 | </field> |
87 | <field> | |
5435b737 | 88 | <name>api_params</name> |
b3c176f1 | 89 | <title>SMS Provider API Params</title> |
5435b737 EM |
90 | <type>text</type> |
91 | <comment>the api params in xml, http or smtp format</comment> | |
92 | <html> | |
93 | <type>Text</type> | |
94 | </html> | |
95 | <add>4.2</add> | |
6a488035 | 96 | </field> |
5435b737 EM |
97 | <field> |
98 | <name>is_default</name> | |
b3c176f1 | 99 | <title>SMS Provider is Default?</title> |
5435b737 EM |
100 | <type>boolean</type> |
101 | <default>0</default> | |
102 | <add>4.2</add> | |
103 | <html> | |
104 | <type>CheckBox</type> | |
105 | </html> | |
6a488035 | 106 | </field> |
5435b737 EM |
107 | <field> |
108 | <name>is_active</name> | |
b3c176f1 | 109 | <title>SMS Provider is Active?</title> |
5435b737 EM |
110 | <type>boolean</type> |
111 | <default>0</default> | |
112 | <add>4.2</add> | |
113 | <html> | |
114 | <type>CheckBox</type> | |
115 | </html> | |
6a488035 | 116 | </field> |
4eae8dda SL |
117 | <field> |
118 | <name>domain_id</name> | |
047c5009 | 119 | <title>Domain ID</title> |
4eae8dda SL |
120 | <type>int unsigned</type> |
121 | <pseudoconstant> | |
122 | <table>civicrm_domain</table> | |
123 | <keyColumn>id</keyColumn> | |
124 | <labelColumn>name</labelColumn> | |
125 | </pseudoconstant> | |
126 | <comment>Which Domain is this sms provider for</comment> | |
57e94608 | 127 | <html> |
047c5009 | 128 | <label>Domain</label> |
57e94608 | 129 | </html> |
4eae8dda SL |
130 | <add>4.7</add> |
131 | </field> | |
132 | <foreignKey> | |
133 | <name>domain_id</name> | |
134 | <table>civicrm_domain</table> | |
135 | <key>id</key> | |
136 | <add>4.7</add> | |
137 | <onDelete>SET NULL</onDelete> | |
138 | </foreignKey> | |
6a488035 | 139 | </table> |