Server: localhost Database: ccc t_extension Field Type Null Default Comments f_extension_id smallint(6) No f_extension_location tinyint(4) No 0 f_extension_number varchar(32) No f_extension_type smallint(6) No 0 f_extension_label varchar(32) No t_listing Field Type Null Default Comments f_listing_id int(11) No f_listing_number varchar(32) No f_listing_desc varchar(64) No f_listing_user int(11) No 0 f_listing_creation timestamp No CURRENT_TIMESTAMP f_listing_desc2 varchar(64) No t_location Field Type Null Default Comments f_location_id tinyint(4) No f_location_label varchar(32) No t_usage Field Type Null Default Comments f_id smallint(6) No f_creation timestamp No CURRENT_TIMESTAMP f_user_id smallint(6) No 0 f_date datetime No 0000-00-00 00:00:00 f_number varchar(32) No f_extension_id smallint(6) No 0 t_user Field Type Null Default Comments f_user_id int(11) No f_user_name varchar(32) No f_user_password varchar(32) No f_user_permision smallint(6) No 0 test Field Type Null Default Comments f_1 date No 0000-00-00 f_2 datetime No 0000-00-00 00:00:00