| @@ 97-104 (lines=8) @@ | ||
| 94 | /** |
|
| 95 | * @param Schema $schema |
|
| 96 | */ |
|
| 97 | protected function createCaseStatusTable(Schema $schema) |
|
| 98 | { |
|
| 99 | $table = $schema->createTable('orocrm_case_status'); |
|
| 100 | $table->addColumn('name', 'string', array('length' => 16)); |
|
| 101 | $table->addColumn('`order`', 'integer'); |
|
| 102 | $table->addColumn('label', 'string', array('length' => 255)); |
|
| 103 | $table->setPrimaryKey(array('name')); |
|
| 104 | } |
|
| 105 | ||
| 106 | /** |
|
| 107 | * Generate table orocrm_case_status_trans |
|
| @@ 133-140 (lines=8) @@ | ||
| 130 | /** |
|
| 131 | * @param Schema $schema |
|
| 132 | */ |
|
| 133 | protected function createCasePriorityTable(Schema $schema) |
|
| 134 | { |
|
| 135 | $table = $schema->createTable('orocrm_case_priority'); |
|
| 136 | $table->addColumn('name', 'string', array('length' => 16)); |
|
| 137 | $table->addColumn('`order`', 'integer'); |
|
| 138 | $table->addColumn('label', 'string', array('length' => 255)); |
|
| 139 | $table->setPrimaryKey(array('name')); |
|
| 140 | } |
|
| 141 | ||
| 142 | /** |
|
| 143 | * Generate table orocrm_case_priority_trans |
|
| @@ 244-251 (lines=8) @@ | ||
| 241 | * |
|
| 242 | * @param Schema $schema |
|
| 243 | */ |
|
| 244 | protected function createOrocrmContactMethodTable(Schema $schema) |
|
| 245 | { |
|
| 246 | $table = $schema->createTable('orocrm_contact_method'); |
|
| 247 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 248 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 249 | $table->setPrimaryKey(['name']); |
|
| 250 | $table->addUniqueIndex(['label'], 'UNIQ_B88D41BEA750E8'); |
|
| 251 | } |
|
| 252 | ||
| 253 | /** |
|
| 254 | * Create orocrm_contact_phone table |
|
| @@ 276-283 (lines=8) @@ | ||
| 273 | * |
|
| 274 | * @param Schema $schema |
|
| 275 | */ |
|
| 276 | protected function createOrocrmContactSourceTable(Schema $schema) |
|
| 277 | { |
|
| 278 | $table = $schema->createTable('orocrm_contact_source'); |
|
| 279 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 280 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 281 | $table->setPrimaryKey(['name']); |
|
| 282 | $table->addUniqueIndex(['label'], 'UNIQ_A5B9108EA750E8'); |
|
| 283 | } |
|
| 284 | ||
| 285 | /** |
|
| 286 | * Create orocrm_contact_to_contact_grp table |
|
| @@ 177-186 (lines=10) @@ | ||
| 174 | * |
|
| 175 | * @param Schema $schema |
|
| 176 | */ |
|
| 177 | public static function orocrmContactMethodTable(Schema $schema) |
|
| 178 | { |
|
| 179 | /** Generate table orocrm_contact_method **/ |
|
| 180 | $table = $schema->createTable('orocrm_contact_method'); |
|
| 181 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 182 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 183 | $table->setPrimaryKey(['name']); |
|
| 184 | $table->addUniqueIndex(['label'], 'UNIQ_B88D41BEA750E8'); |
|
| 185 | /** End of generate table orocrm_contact_method **/ |
|
| 186 | } |
|
| 187 | ||
| 188 | /** |
|
| 189 | * Generate table orocrm_contact_phone |
|
| @@ 212-221 (lines=10) @@ | ||
| 209 | * |
|
| 210 | * @param Schema $schema |
|
| 211 | */ |
|
| 212 | public static function orocrmContactSourceTable(Schema $schema) |
|
| 213 | { |
|
| 214 | /** Generate table orocrm_contact_source **/ |
|
| 215 | $table = $schema->createTable('orocrm_contact_source'); |
|
| 216 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 217 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 218 | $table->setPrimaryKey(['name']); |
|
| 219 | $table->addUniqueIndex(['label'], 'UNIQ_A5B9108EA750E8'); |
|
| 220 | /** End of generate table orocrm_contact_source **/ |
|
| 221 | } |
|
| 222 | ||
| 223 | /** |
|
| 224 | * Generate table orocrm_contact_to_contact_group |
|
| @@ 242-251 (lines=10) @@ | ||
| 239 | * |
|
| 240 | * @param Schema $schema |
|
| 241 | */ |
|
| 242 | public static function orocrmMagentoCartStatusTable(Schema $schema) |
|
| 243 | { |
|
| 244 | /** Generate table orocrm_magento_cart_status **/ |
|
| 245 | $table = $schema->createTable('orocrm_magento_cart_status'); |
|
| 246 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 247 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 248 | $table->setPrimaryKey(['name']); |
|
| 249 | $table->addUniqueIndex(['label'], 'UNIQ_26317505EA750E8'); |
|
| 250 | /** End of generate table orocrm_magento_cart_status **/ |
|
| 251 | } |
|
| 252 | ||
| 253 | /** |
|
| 254 | * Generate table orocrm_magento_customer |
|
| @@ 48-55 (lines=8) @@ | ||
| 45 | * |
|
| 46 | * @param Schema $schema |
|
| 47 | */ |
|
| 48 | protected function createOrocrmMarketingListTypeTable(Schema $schema) |
|
| 49 | { |
|
| 50 | $table = $schema->createTable('orocrm_marketing_list_type'); |
|
| 51 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 52 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 53 | $table->addUniqueIndex(['label'], 'uniq_143b81a8ea750e8'); |
|
| 54 | $table->setPrimaryKey(['name']); |
|
| 55 | } |
|
| 56 | ||
| 57 | /** |
|
| 58 | * Create orocrm_marketing_list table |
|
| @@ 35-42 (lines=8) @@ | ||
| 32 | * |
|
| 33 | * @param Schema $schema |
|
| 34 | */ |
|
| 35 | protected function createOrocrmMarketingListTypeTable(Schema $schema) |
|
| 36 | { |
|
| 37 | $table = $schema->createTable('orocrm_marketing_list_type'); |
|
| 38 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 39 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 40 | $table->addUniqueIndex(['label'], 'uniq_143b81a8ea750e8'); |
|
| 41 | $table->setPrimaryKey(['name']); |
|
| 42 | } |
|
| 43 | ||
| 44 | /** |
|
| 45 | * Create orocrm_marketing_list_item table |
|
| @@ 94-103 (lines=10) @@ | ||
| 91 | * |
|
| 92 | * @param Schema $schema |
|
| 93 | */ |
|
| 94 | public static function orocrmSalesLeadStatusTable(Schema $schema) |
|
| 95 | { |
|
| 96 | /** Generate table orocrm_sales_lead_status **/ |
|
| 97 | $table = $schema->createTable('orocrm_sales_lead_status'); |
|
| 98 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 99 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 100 | $table->setPrimaryKey(['name']); |
|
| 101 | $table->addUniqueIndex(['label'], 'UNIQ_4516951BEA750E8'); |
|
| 102 | /** End of generate table orocrm_sales_lead_status **/ |
|
| 103 | } |
|
| 104 | ||
| 105 | /** |
|
| 106 | * Generate table orocrm_sales_lead_status |
|
| @@ 151-160 (lines=10) @@ | ||
| 148 | * @param Schema $schema |
|
| 149 | * @param string $tableName |
|
| 150 | */ |
|
| 151 | public static function orocrmSalesOpportunityCloseReasonTable(Schema $schema, $tableName = null) |
|
| 152 | { |
|
| 153 | /** Generate table orocrm_sales_opportunity_close_reason **/ |
|
| 154 | $table = $schema->createTable($tableName ?: 'orocrm_sales_opportunity_close_reason'); |
|
| 155 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 156 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 157 | $table->setPrimaryKey(['name']); |
|
| 158 | $table->addUniqueIndex(['label'], 'UNIQ_FA526A41EA750E8'); |
|
| 159 | /** End of generate table orocrm_sales_opportunity_close_reason **/ |
|
| 160 | } |
|
| 161 | ||
| 162 | /** |
|
| 163 | * Generate table orocrm_sales_opportunity_status |
|
| @@ 168-177 (lines=10) @@ | ||
| 165 | * @param Schema $schema |
|
| 166 | * @param string $tableName |
|
| 167 | */ |
|
| 168 | public static function orocrmSalesOpportunityStatusTable(Schema $schema, $tableName = null) |
|
| 169 | { |
|
| 170 | /** Generate table orocrm_sales_opportunity_status **/ |
|
| 171 | $table = $schema->createTable($tableName ?: 'orocrm_sales_opportunity_status'); |
|
| 172 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 173 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 174 | $table->setPrimaryKey(['name']); |
|
| 175 | $table->addUniqueIndex(['label'], 'UNIQ_2DB212B5EA750E8'); |
|
| 176 | /** End of generate table orocrm_sales_opportunity_status **/ |
|
| 177 | } |
|
| 178 | ||
| 179 | /** |
|
| 180 | * Generate table orocrm_sales_funnel |
|
| @@ 183-190 (lines=8) @@ | ||
| 180 | * |
|
| 181 | * @param Schema $schema |
|
| 182 | */ |
|
| 183 | protected function createOrocrmCaseStatusTable(Schema $schema) |
|
| 184 | { |
|
| 185 | $table = $schema->createTable('orocrm_case_status'); |
|
| 186 | $table->addColumn('name', 'string', ['length' => 16]); |
|
| 187 | $table->addColumn('`order`', 'integer'); |
|
| 188 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 189 | $table->setPrimaryKey(['name']); |
|
| 190 | } |
|
| 191 | ||
| 192 | /** |
|
| 193 | * Create orocrm_case_status_trans table |
|
| @@ 219-226 (lines=8) @@ | ||
| 216 | * |
|
| 217 | * @param Schema $schema |
|
| 218 | */ |
|
| 219 | protected function createOrocrmCasePriorityTable(Schema $schema) |
|
| 220 | { |
|
| 221 | $table = $schema->createTable('orocrm_case_priority'); |
|
| 222 | $table->addColumn('name', 'string', ['length' => 16]); |
|
| 223 | $table->addColumn('`order`', 'integer'); |
|
| 224 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 225 | $table->setPrimaryKey(['name']); |
|
| 226 | } |
|
| 227 | ||
| 228 | /** |
|
| 229 | * Create orocrm_case_priority_trans table |
|
| @@ 236-243 (lines=8) @@ | ||
| 233 | * |
|
| 234 | * @param Schema $schema |
|
| 235 | */ |
|
| 236 | protected function createOrocrmSalesLeadStatusTable(Schema $schema) |
|
| 237 | { |
|
| 238 | $table = $schema->createTable('orocrm_sales_lead_status'); |
|
| 239 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 240 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 241 | $table->addUniqueIndex(['label'], 'uniq_4516951bea750e8'); |
|
| 242 | $table->setPrimaryKey(['name']); |
|
| 243 | } |
|
| 244 | ||
| 245 | /** |
|
| 246 | * Create orocrm_sales_funnel table |
|
| @@ 274-281 (lines=8) @@ | ||
| 271 | * |
|
| 272 | * @param Schema $schema |
|
| 273 | */ |
|
| 274 | protected function createOrocrmSalesOpportStatusTable(Schema $schema) |
|
| 275 | { |
|
| 276 | $table = $schema->createTable('orocrm_sales_opport_status'); |
|
| 277 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 278 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 279 | $table->addUniqueIndex(['label'], 'uniq_2db212b5ea750e8'); |
|
| 280 | $table->setPrimaryKey(['name']); |
|
| 281 | } |
|
| 282 | ||
| 283 | /** |
|
| 284 | * Create orocrm_sales_opport_close_rsn table |
|
| @@ 288-295 (lines=8) @@ | ||
| 285 | * |
|
| 286 | * @param Schema $schema |
|
| 287 | */ |
|
| 288 | protected function createOrocrmSalesOpportCloseRsnTable(Schema $schema) |
|
| 289 | { |
|
| 290 | $table = $schema->createTable('orocrm_sales_opport_close_rsn'); |
|
| 291 | $table->addColumn('name', 'string', ['length' => 32]); |
|
| 292 | $table->addColumn('label', 'string', ['length' => 255]); |
|
| 293 | $table->addUniqueIndex(['label'], 'uniq_fa526a41ea750e8'); |
|
| 294 | $table->setPrimaryKey(['name']); |
|
| 295 | } |
|
| 296 | ||
| 297 | /** |
|
| 298 | * Create orocrm_sales_lead table |
|