Stockbase-Connect /
magento2-module
| @@ 106-193 (lines=88) @@ | ||
| 103 | } |
|
| 104 | ||
| 105 | $tableName = $setup->getTable('stockbase_stock_reserve'); |
|
| 106 | if (!$setup->getConnection()->isTableExists($tableName)) { |
|
| 107 | $table = $setup->getConnection() |
|
| 108 | ->newTable($tableName) |
|
| 109 | ->setComment('Stockbase stock reserve') |
|
| 110 | ->addColumn( |
|
| 111 | 'id', |
|
| 112 | Table::TYPE_INTEGER, |
|
| 113 | null, |
|
| 114 | ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true], |
|
| 115 | 'ID' |
|
| 116 | ) |
|
| 117 | ->addColumn( |
|
| 118 | 'ean', |
|
| 119 | Table::TYPE_BIGINT, |
|
| 120 | null, |
|
| 121 | ['unsigned' => true, 'nullable' => false], |
|
| 122 | 'International/European Article Number' |
|
| 123 | ) |
|
| 124 | ->addColumn( |
|
| 125 | 'amount', |
|
| 126 | Table::TYPE_FLOAT, |
|
| 127 | null, |
|
| 128 | ['nullable' => false, 'default' => '0'], |
|
| 129 | 'Reserved amount' |
|
| 130 | ) |
|
| 131 | ->addColumn( |
|
| 132 | 'magento_stock_amount', |
|
| 133 | Table::TYPE_FLOAT, |
|
| 134 | null, |
|
| 135 | ['nullable' => false, 'default' => '0'], |
|
| 136 | 'Amount to subtract from Magento stock' |
|
| 137 | ) |
|
| 138 | ->addColumn( |
|
| 139 | 'quote_item_id', |
|
| 140 | Table::TYPE_INTEGER, |
|
| 141 | null, |
|
| 142 | ['unsigned' => true, 'nullable' => false], |
|
| 143 | 'Quote Item ID' |
|
| 144 | ) |
|
| 145 | ->addColumn( |
|
| 146 | 'product_id', |
|
| 147 | Table::TYPE_INTEGER, |
|
| 148 | null, |
|
| 149 | ['unsigned' => true, 'nullable' => false], |
|
| 150 | 'Product ID' |
|
| 151 | ) |
|
| 152 | ->addColumn( |
|
| 153 | 'order_item_id', |
|
| 154 | Table::TYPE_INTEGER, |
|
| 155 | null, |
|
| 156 | ['unsigned' => true, 'nullable' => true], |
|
| 157 | 'Order Item ID' |
|
| 158 | ) |
|
| 159 | ->addColumn( |
|
| 160 | 'created_at', |
|
| 161 | Table::TYPE_DATETIME, |
|
| 162 | null, |
|
| 163 | ['nullable' => false], |
|
| 164 | 'Created at' |
|
| 165 | ) |
|
| 166 | ->addIndex( |
|
| 167 | $setup->getIdxName($tableName, ['ean']), |
|
| 168 | ['ean'], |
|
| 169 | ['type' => AdapterInterface::INDEX_TYPE_INDEX] |
|
| 170 | ) |
|
| 171 | ->addIndex( |
|
| 172 | $setup->getIdxName($tableName, ['amount']), |
|
| 173 | ['amount'], |
|
| 174 | ['type' => AdapterInterface::INDEX_TYPE_INDEX] |
|
| 175 | ) |
|
| 176 | ->addIndex( |
|
| 177 | $setup->getIdxName($tableName, ['quote_item_id']), |
|
| 178 | ['quote_item_id'], |
|
| 179 | ['type' => AdapterInterface::INDEX_TYPE_UNIQUE] |
|
| 180 | ) |
|
| 181 | ->addIndex( |
|
| 182 | $setup->getIdxName($tableName, ['product_id']), |
|
| 183 | ['product_id'], |
|
| 184 | ['type' => AdapterInterface::INDEX_TYPE_INDEX] |
|
| 185 | ) |
|
| 186 | ->addIndex( |
|
| 187 | $setup->getIdxName($tableName, ['order_item_id']), |
|
| 188 | ['order_item_id'], |
|
| 189 | ['type' => AdapterInterface::INDEX_TYPE_INDEX] |
|
| 190 | ); |
|
| 191 | ||
| 192 | $setup->getConnection()->createTable($table); |
|
| 193 | } |
|
| 194 | ||
| 195 | $tableName = $setup->getTable('stockbase_ordered_item'); |
|
| 196 | if (!$setup->getConnection()->isTableExists($tableName)) { |
|
| @@ 196-283 (lines=88) @@ | ||
| 193 | } |
|
| 194 | ||
| 195 | $tableName = $setup->getTable('stockbase_ordered_item'); |
|
| 196 | if (!$setup->getConnection()->isTableExists($tableName)) { |
|
| 197 | $table = $setup->getConnection() |
|
| 198 | ->newTable($tableName) |
|
| 199 | ->setComment('Stockbase orders') |
|
| 200 | ->addColumn( |
|
| 201 | 'id', |
|
| 202 | Table::TYPE_INTEGER, |
|
| 203 | null, |
|
| 204 | ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true], |
|
| 205 | 'ID' |
|
| 206 | ) |
|
| 207 | ->addColumn( |
|
| 208 | 'order_id', |
|
| 209 | Table::TYPE_INTEGER, |
|
| 210 | null, |
|
| 211 | ['unsigned' => true, 'nullable' => true], |
|
| 212 | 'Order Item ID' |
|
| 213 | ) |
|
| 214 | ->addColumn( |
|
| 215 | 'order_item_id', |
|
| 216 | Table::TYPE_INTEGER, |
|
| 217 | null, |
|
| 218 | ['unsigned' => true, 'nullable' => true], |
|
| 219 | 'Order Item ID' |
|
| 220 | ) |
|
| 221 | ->addColumn( |
|
| 222 | 'product_id', |
|
| 223 | Table::TYPE_INTEGER, |
|
| 224 | null, |
|
| 225 | ['unsigned' => true, 'nullable' => false], |
|
| 226 | 'Product ID' |
|
| 227 | ) |
|
| 228 | ->addColumn( |
|
| 229 | 'ean', |
|
| 230 | Table::TYPE_BIGINT, |
|
| 231 | null, |
|
| 232 | ['unsigned' => true, 'nullable' => false], |
|
| 233 | 'International/European Article Number' |
|
| 234 | ) |
|
| 235 | ->addColumn( |
|
| 236 | 'amount', |
|
| 237 | Table::TYPE_FLOAT, |
|
| 238 | null, |
|
| 239 | ['nullable' => false, 'default' => '0'], |
|
| 240 | 'Reserved amount' |
|
| 241 | ) |
|
| 242 | ->addColumn( |
|
| 243 | 'stockbase_guid', |
|
| 244 | Table::TYPE_TEXT, |
|
| 245 | 36, |
|
| 246 | ['nullable' => true], |
|
| 247 | 'Stockbase GUID' |
|
| 248 | ) |
|
| 249 | ->addColumn( |
|
| 250 | 'created_at', |
|
| 251 | Table::TYPE_DATETIME, |
|
| 252 | null, |
|
| 253 | ['nullable' => false], |
|
| 254 | 'Created at' |
|
| 255 | ) |
|
| 256 | ->addIndex( |
|
| 257 | $setup->getIdxName($tableName, ['order_id']), |
|
| 258 | ['order_id'], |
|
| 259 | ['type' => AdapterInterface::INDEX_TYPE_INDEX] |
|
| 260 | ) |
|
| 261 | ->addIndex( |
|
| 262 | $setup->getIdxName($tableName, ['order_item_id']), |
|
| 263 | ['order_item_id'], |
|
| 264 | ['type' => AdapterInterface::INDEX_TYPE_INDEX] |
|
| 265 | ) |
|
| 266 | ->addIndex( |
|
| 267 | $setup->getIdxName($tableName, ['product_id']), |
|
| 268 | ['product_id'], |
|
| 269 | ['type' => AdapterInterface::INDEX_TYPE_INDEX] |
|
| 270 | ) |
|
| 271 | ->addIndex( |
|
| 272 | $setup->getIdxName($tableName, ['ean']), |
|
| 273 | ['ean'], |
|
| 274 | ['type' => AdapterInterface::INDEX_TYPE_INDEX] |
|
| 275 | ) |
|
| 276 | ->addIndex( |
|
| 277 | $setup->getIdxName($tableName, ['amount']), |
|
| 278 | ['amount'], |
|
| 279 | ['type' => AdapterInterface::INDEX_TYPE_INDEX] |
|
| 280 | ); |
|
| 281 | ||
| 282 | $setup->getConnection()->createTable($table); |
|
| 283 | } |
|
| 284 | ||
| 285 | $setup->endSetup(); |
|
| 286 | } |
|
