company_farm 1.2 KB

1234567891011121314151617181920
  1. <?php return array (
  2. 'time' => 1449933071,
  3. 'table' => 'company_farm',
  4. 'create' => 'DROP TABLE IF EXISTS `company_farm`;CREATE TABLE `company_farm`(`id` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL COMMENT \'农场ID\',`company` INT(11) NOT NULL DEFAULT 0 COMMENT \'所属公司\',`name` VARCHAR(32) NOT NULL DEFAULT \'\' COMMENT \'农场名\',`location` VARCHAR(200) NOT NULL DEFAULT \'\' COMMENT \'地理位置\',`city` VARCHAR(100) NOT NULL DEFAULT \'\' COMMENT \'所在城市\',`weather` VARCHAR(200) NOT NULL DEFAULT \'\' COMMENT \'天气情况-一般不用填写,可从设备中读取出来\',`pic` VARCHAR(150) NOT NULL DEFAULT \'\' COMMENT \'平面图\',`video` VARCHAR(255) NOT NULL DEFAULT \'\' COMMENT \'360°视频-直接填写视频代码即可,大小:1000X560\',`reorder` INT(11) NOT NULL DEFAULT \'1\' 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. 'company' => 1,
  9. 'name' => 2,
  10. 'location' => 3,
  11. 'city' => 4,
  12. 'weather' => 5,
  13. 'pic' => 6,
  14. 'video' => 7,
  15. 'content' => 8,
  16. 'reorder' => 9,
  17. 'state' => 10,
  18. 'cdate' => 11,
  19. ),
  20. );