table('alarm_report', ['engine' => 'InnoDB', 'comment' => '' ,'id' => 'id','signed' => true ,'primary_key' => ['id']]); $table->addColumn('device_number', 'string', ['limit' => 50,'null' => true,'signed' => true,'comment' => '设备编号',]) ->addColumn('alarm_time', 'datetime', ['null' => true,'signed' => true,'comment' => '告警时间',]) ->addColumn('station_code', 'string', ['limit' => 50,'null' => true,'signed' => true,'comment' => '基站Code',]) ->addColumn('address', 'string', ['limit' => 128,'null' => true,'signed' => true,'comment' => '告警地址',]) ->addColumn('is_read', 'integer', ['limit' => MysqlAdapter::INT_REGULAR,'null' => true,'default' => 0,'signed' => true,'comment' => '是否已读',]) ->addColumn('creator_id', 'integer', ['limit' => MysqlAdapter::INT_REGULAR,'null' => false,'default' => 0,'signed' => false,'comment' => '创建人ID',]) ->addColumn('created_at', 'integer', ['limit' => MysqlAdapter::INT_REGULAR,'null' => false,'default' => 0,'signed' => false,'comment' => '创建时间',]) ->addColumn('updated_at', 'integer', ['limit' => MysqlAdapter::INT_REGULAR,'null' => false,'default' => 0,'signed' => false,'comment' => '更新时间',]) ->addColumn('deleted_at', 'integer', ['limit' => MysqlAdapter::INT_REGULAR,'null' => false,'default' => 0,'signed' => false,'comment' => '软删除',]) ->create(); } }