company_device_status 1.0 KB

123456789101112131415161718
  1. <?php return array (
  2. 'time' => 1459732367,
  3. 'table' => 'company_device_status',
  4. 'create' => 'DROP TABLE IF EXISTS `company_device_status`;CREATE TABLE `company_device_status`(`id` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL COMMENT \'ID\',`park_id` INT(11) NOT NULL DEFAULT 0 COMMENT \'园区ID\',`device_id` INT(11) NOT NULL DEFAULT 0 COMMENT \'设备ID\',`system_id` INT(11) NOT NULL DEFAULT 0 COMMENT \'系统ID\',`code_id` INT(11) NOT NULL DEFAULT 0 COMMENT \'命令码ID\',`key` INT(11) NOT NULL DEFAULT 0 COMMENT \'命令码索引值\',`send` VARCHAR(255) NOT NULL DEFAULT \'\' COMMENT \'发送的指令\',`receive` VARCHAR(255) NOT NULL DEFAULT \'\' COMMENT \'接收到的指令\',`status` TINYINT(1) NOT NULL DEFAULT \'1\' COMMENT \'运行状态\',`cdate` INT(11) NOT NULL DEFAULT 0 COMMENT \'录入时间\')',
  5. 'struct' =>
  6. array (
  7. 'id' => 0,
  8. 'park_id' => 1,
  9. 'device_id' => 2,
  10. 'system_id' => 3,
  11. 'code_id' => 4,
  12. 'key' => 5,
  13. 'send' => 6,
  14. 'receive' => 7,
  15. 'status' => 8,
  16. 'cdate' => 9,
  17. ),
  18. );