· 10 years ago · Aug 23, 2016, 06:58 AM
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'