device_system 1.2 KB

1234567891011121314151617
  1. <?php return array (
  2. 'time' => 1449932274,
  3. 'table' => 'device_system',
  4. 'create' => 'DROP TABLE IF EXISTS `device_system`;CREATE TABLE `device_system`(`id` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL COMMENT \'ID\',`model` VARCHAR(52) NOT NULL DEFAULT \'\' COMMENT \'设备型号\',`name` VARCHAR(32) NOT NULL DEFAULT \'\' COMMENT \'设备名称\',`info` VARCHAR(255) NOT NULL DEFAULT \'\' COMMENT \'说明介绍-选填\',`reorder` INT(11) NOT NULL DEFAULT \'1\' COMMENT \'排序-数值越大越靠前\',`type` TINYINT(1) NOT NULL DEFAULT \'1\' COMMENT \'设备类型-该类型并无实际作用,所有设备均需命令码支持.如果选择开关式设备,则会自动生成启动和关闭两个命令码\',`code` TEXT(255) COMMENT \'开关式命令码-根据此命令码,可以生成启动和关闭的命令码,启动和关闭各位一行,发送和接收请用逗号隔开\',`state` TINYINT(1) NOT NULL DEFAULT \'1\' COMMENT \'状态\',`cdate` INT(11) NOT NULL DEFAULT 0 COMMENT \'录入时间\')',
  5. 'struct' =>
  6. array (
  7. 'id' => 0,
  8. 'model' => 1,
  9. 'name' => 2,
  10. 'info' => 3,
  11. 'reorder' => 4,
  12. 'type' => 5,
  13. 'code' => 6,
  14. 'state' => 7,
  15. 'cdate' => 8,
  16. ),
  17. );