@@ 75-92 (lines=18) @@ | ||
72 | * |
|
73 | * @param Schema $schema |
|
74 | */ |
|
75 | public static function createCaseSourceTranslationTable(Schema $schema) |
|
76 | { |
|
77 | /** Generate table orocrm_case_source_trans **/ |
|
78 | $table = $schema->createTable('orocrm_case_source_trans'); |
|
79 | $table->addColumn('id', 'integer', array('autoincrement' => true)); |
|
80 | $table->addColumn('foreign_key', 'string', array('length' => 16)); |
|
81 | $table->addColumn('content', 'string', array('length' => 255)); |
|
82 | $table->addColumn('locale', 'string', array('length' => 8)); |
|
83 | $table->addColumn('object_class', 'string', array('length' => 255)); |
|
84 | $table->addColumn('field', 'string', array('length' => 32)); |
|
85 | $table->setPrimaryKey(array('id')); |
|
86 | $table->addIndex( |
|
87 | array('locale', 'object_class', 'field', 'foreign_key'), |
|
88 | 'case_source_translation_idx', |
|
89 | array() |
|
90 | ); |
|
91 | /** End of generate table orocrm_case_source_trans **/ |
|
92 | } |
|
93 | ||
94 | /** |
|
95 | * @param Schema $schema |
|
@@ 111-128 (lines=18) @@ | ||
108 | * |
|
109 | * @param Schema $schema |
|
110 | */ |
|
111 | public static function createCaseStatusTranslationTable(Schema $schema) |
|
112 | { |
|
113 | /** Generate table orocrm_case_status_trans **/ |
|
114 | $table = $schema->createTable('orocrm_case_status_trans'); |
|
115 | $table->addColumn('id', 'integer', array('autoincrement' => true)); |
|
116 | $table->addColumn('foreign_key', 'string', array('length' => 16)); |
|
117 | $table->addColumn('content', 'string', array('length' => 255)); |
|
118 | $table->addColumn('locale', 'string', array('length' => 8)); |
|
119 | $table->addColumn('object_class', 'string', array('length' => 255)); |
|
120 | $table->addColumn('field', 'string', array('length' => 32)); |
|
121 | $table->setPrimaryKey(array('id')); |
|
122 | $table->addIndex( |
|
123 | array('locale', 'object_class', 'field', 'foreign_key'), |
|
124 | 'case_status_translation_idx', |
|
125 | array() |
|
126 | ); |
|
127 | /** End of generate table orocrm_case_status_trans **/ |
|
128 | } |
|
129 | ||
130 | /** |
|
131 | * @param Schema $schema |
|
@@ 147-164 (lines=18) @@ | ||
144 | * |
|
145 | * @param Schema $schema |
|
146 | */ |
|
147 | public static function createCasePriorityTranslationTable(Schema $schema) |
|
148 | { |
|
149 | /** Generate table orocrm_case_priority_trans **/ |
|
150 | $table = $schema->createTable('orocrm_case_priority_trans'); |
|
151 | $table->addColumn('id', 'integer', array('autoincrement' => true)); |
|
152 | $table->addColumn('foreign_key', 'string', array('length' => 16)); |
|
153 | $table->addColumn('content', 'string', array('length' => 255)); |
|
154 | $table->addColumn('locale', 'string', array('length' => 8)); |
|
155 | $table->addColumn('object_class', 'string', array('length' => 255)); |
|
156 | $table->addColumn('field', 'string', array('length' => 32)); |
|
157 | $table->setPrimaryKey(array('id')); |
|
158 | $table->addIndex( |
|
159 | array('locale', 'object_class', 'field', 'foreign_key'), |
|
160 | 'case_priority_translation_idx', |
|
161 | array() |
|
162 | ); |
|
163 | /** End of generate table orocrm_case_priority_trans **/ |
|
164 | } |
|
165 | ||
166 | /** |
|
167 | * @param Schema $schema |
@@ 161-176 (lines=16) @@ | ||
158 | * |
|
159 | * @param Schema $schema |
|
160 | */ |
|
161 | public static function createOrocrmCaseSourceTranslationTable(Schema $schema) |
|
162 | { |
|
163 | $table = $schema->createTable('orocrm_case_source_trans'); |
|
164 | $table->addColumn('id', 'integer', ['autoincrement' => true]); |
|
165 | $table->addColumn('foreign_key', 'string', ['length' => 16]); |
|
166 | $table->addColumn('content', 'string', ['length' => 255]); |
|
167 | $table->addColumn('locale', 'string', ['length' => 8]); |
|
168 | $table->addColumn('object_class', 'string', ['length' => 255]); |
|
169 | $table->addColumn('field', 'string', ['length' => 32]); |
|
170 | $table->setPrimaryKey(['id']); |
|
171 | $table->addIndex( |
|
172 | ['locale', 'object_class', 'field', 'foreign_key'], |
|
173 | 'case_source_translation_idx', |
|
174 | [] |
|
175 | ); |
|
176 | } |
|
177 | ||
178 | /** |
|
179 | * Create orocrm_case_status table |
|
@@ 197-212 (lines=16) @@ | ||
194 | * |
|
195 | * @param Schema $schema |
|
196 | */ |
|
197 | public static function createOrocrmCaseStatusTranslationTable(Schema $schema) |
|
198 | { |
|
199 | $table = $schema->createTable('orocrm_case_status_trans'); |
|
200 | $table->addColumn('id', 'integer', ['autoincrement' => true]); |
|
201 | $table->addColumn('foreign_key', 'string', ['length' => 16]); |
|
202 | $table->addColumn('content', 'string', ['length' => 255]); |
|
203 | $table->addColumn('locale', 'string', ['length' => 8]); |
|
204 | $table->addColumn('object_class', 'string', ['length' => 255]); |
|
205 | $table->addColumn('field', 'string', ['length' => 32]); |
|
206 | $table->setPrimaryKey(['id']); |
|
207 | $table->addIndex( |
|
208 | ['locale', 'object_class', 'field', 'foreign_key'], |
|
209 | 'case_status_translation_idx', |
|
210 | [] |
|
211 | ); |
|
212 | } |
|
213 | ||
214 | /** |
|
215 | * Create orocrm_case_priority table |
|
@@ 233-248 (lines=16) @@ | ||
230 | * |
|
231 | * @param Schema $schema |
|
232 | */ |
|
233 | public static function createOrocrmCasePriorityTranslationTable(Schema $schema) |
|
234 | { |
|
235 | $table = $schema->createTable('orocrm_case_priority_trans'); |
|
236 | $table->addColumn('id', 'integer', ['autoincrement' => true]); |
|
237 | $table->addColumn('foreign_key', 'string', ['length' => 16]); |
|
238 | $table->addColumn('content', 'string', ['length' => 255]); |
|
239 | $table->addColumn('locale', 'string', ['length' => 8]); |
|
240 | $table->addColumn('object_class', 'string', ['length' => 255]); |
|
241 | $table->addColumn('field', 'string', ['length' => 32]); |
|
242 | $table->setPrimaryKey(['id']); |
|
243 | $table->addIndex( |
|
244 | ['locale', 'object_class', 'field', 'foreign_key'], |
|
245 | 'case_priority_translation_idx', |
|
246 | [] |
|
247 | ); |
|
248 | } |
|
249 | ||
250 | /** |
|
251 | * Create orocrm_case_comment table |