search

UniHousing / UnivHousing

A demo for mvc
0 stars 1 forks source link

Update the ticket table #57

Open jessexu20 opened 9 years ago

jessexu20 commented 9 years ago

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 commented 9 years ago

@OliviaHY

jessexu20 commented 9 years ago

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 commented 9 years ago

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 commented 9 years ago

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 commented 9 years ago

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 commented 9 years ago

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;