Update the ticket table

[jessexu20]

Please update the ticket_table!

    DROP TABLE IF EXISTS `ticket`;
    CREATE TABLE `ticket` (
      `id` int(11) NOT NULL auto_increment,
      `type` varchar(20) default NULL COMMENT 'serverity',
      `student_id` int(11) default NULL,
      `date` datetime default NULL,
      `issue` varchar(255),--location
      `status` varchar(20),
      `comment` varchar(255),--description
      PRIMARY KEY  (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[jessexu20]

@OliviaHY

[jessexu20]

DROP TABLE IF EXISTS parking_lot;
CREATE TABLE parking_lot (
id int(11) NOT NULL auto_increment,
type varchar(20) default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[jessexu20]

DROP TABLE IF EXISTS family_apartment;
CREATE TABLE family_apartment (
id int(11) NOT NULL auto_increment,
name varchar(255) default NULL,
addr varchar(255) default NULL,
tel varchar(20) default NULL,
apt_num int(11) default NULL,
bed_count int(11) default NULL,
month_rate float default NULL,
deposit float default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[jessexu20]

DROP TABLE IF EXISTS room;
CREATE TABLE room (
id int(11) NOT NULL auto_increment,
room_number varchar(50) default NULL,
month_rate float default NULL,
house_id int(11) default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[jessexu20]

DROP TABLE IF EXISTS general_apartment;
CREATE TABLE general_apartment (
id int(11) NOT NULL auto_increment,
name varchar(255) default NULL,
addr varchar(255) default NULL,
tel varchar(255) default NULL,
room_count int(11) default NULL,
bath_count int(11) default NULL,
rent float default NULL,
deposit float default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[jessexu20]

DROP TABLE IF EXISTS residence_hall;
CREATE TABLE residence_hall (
id int(11) NOT NULL auto_increment,
name varchar(255) default NULL,
addr varchar(255),
room_count int(11) default NULL,
tel varchar(20) default NULL,
manager_id int(11) default NULL,
rent float default NULL,
deposit float default NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;