CREATE TABLE `inspections` (
  `seq` int(7) NOT NULL AUTO_INCREMENT,
  `inspection_date` date NOT NULL DEFAULT '0000-00-00',
  `inspection_id` varchar(18) NOT NULL DEFAULT '',
  `formname` varchar(10) NOT NULL DEFAULT '',
  `field_num` int(3) NOT NULL DEFAULT '0',
  `field_type` varchar(20) NOT NULL DEFAULT '',
  `pos_field_values` varchar(100) NOT NULL DEFAULT '',
  `label` varchar(60) NOT NULL DEFAULT '',
  `mandatory` enum('0','1') NOT NULL DEFAULT '0',
  `field_value` text NOT NULL,
  `superseded` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`seq`),
  KEY `label` (`label`)
) ENGINE=MyISAM AUTO_INCREMENT=373760 DEFAULT CHARSET=latin1


 show table status like 'inspections'\G
*************************** 1. row ***************************
           Name: inspections
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 371960
 Avg_row_length: 112
    Data_length: 41798952
Max_data_length: 281474976710655
   Index_length: 6761472
      Data_free: 0
 Auto_increment: 373760
    Create_time: 2018-12-11 14:37:22
    Update_time: 2018-12-11 14:37:23
     Check_time: 2018-12-11 14:37:25
      Collation: latin1_swedish_ci
       Checksum: NULL
 Create_options:
        Comment:
1 row in set (0.00 sec)
