= array(
'upc' => array('type'=>'VARCHAR(13)'),
'class' => array('type'=>'VARCHAR(255)'),
'first_name' => array('type'=>'VARCHAR(30)'),
'last_name' => array('type'=>'VARCHAR(30)'),
'first_opt_name' => array('type'=>'VARCHAR(30)'),
'last_opt_name' => array('type'=>'VARCHAR(30)'),
'phone' => array('type'=>'VARCHAR(30)'),
'opt_phone' => array('type'=>'VARCHAR(30)'),
'card_no' => array('type'=>'INT(11)'),
'payment' => array('type'=>'VARCHAR(30)'),
'refunded' => array('type'=>'INT(1)'),
'modified' => array('type'=>'DATETIME'),
'store_id' => array('type'=>'SMALLINT(6)'),
'start_time' => array('type'=>'TIME'),
'date_paid' => array('type'=>'DATETIME'),
'seat' => array('type'=>'INT(50)'),
'seatType' => array('type'=>'INT(5)'),
'details' => array('type'=>'TEXT'),
'id' => array('type'=>'INT(6)','primary_key'=>TRUE),
'refund' => array('type'=>'VARCHAR(30)'),
)