· 6 years ago · Mar 10, 2019, 02:06 PM
1CREATE TABLE IF NOT EXISTS `tgs_queue` (
2`id` int(10) unsigned NOT NULL COMMENT 'ID',
3`entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
4`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
5`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
6 )
7
8->addColumn(
9 'created_at',
10 MagentoFrameworkDBDdlTable::TYPE_TIMESTAMP,
11 null,
12 [ 'nullable' => false, 'default' => MagentoFrameworkDBDdlTable::TIMESTAMP_INIT, ],
13 'Created At'
14 )
15 ->addColumn(
16 'updated_at',
17 MagentoFrameworkDBDdlTable::TYPE_TIMESTAMP,
18 null,
19 [ 'nullable' => false, 'default' => MagentoFrameworkDBDdlTable::TIMESTAMP_INIT_UPDATE, ],
20 'Updated At'
21
22->addColumn(
23 'updated_at',
24 MagentoFrameworkDBDdlTable::TYPE_TIMESTAMP,
25 null,
26 ['nullable' => false, 'default' => MagentoFrameworkDBDdlTable::TIMESTAMP_INIT_UPDATE],
27 'Updated At'