CREATE TABLE administrator (
   ID int(11) NOT NULL auto_increment,
   UserName varchar(50),
   PassWord varchar(50),
   Valid int(3) DEFAULT '0',
   PRIMARY KEY (ID)
);
# --------------------------------------------------------
#
# Table structure for table 'lodgingapplication'
#
CREATE TABLE lodgingapplication (
   ID int(11) NOT NULL auto_increment,
   ChinaUserName varchar(50),
   EnglishUserName varchar(100),
   province varchar(20),
   city varchar(50),
   Address varchar(200),
   zip varchar(10),
   Phoneborugh varchar(10),
   lodgingPhone varchar(20),
   unitPhone varchar(50),
   Faxborugh varchar(10),
   FaxPhone varchar(20),
   LinkEmail varchar(100),
   Familyleaguertitle1 varchar(50),
   FamilyleaguerName1 varchar(50),
   educationextent1 varchar(100),
   FamilyleaguerAge1 varchar(100),
   Familyleagueroccupation1 varchar(100),
   Familyleaguertitle2 varchar(50),
   FamilyleaguerName2 varchar(50),
   educationextent2 varchar(50),
   FamilyleaguerAge2 varchar(10),
   Familyleagueroccupation2 varchar(50),
   Familyleaguertitle3 varchar(50),
   FamilyleaguerName3 varchar(50),
   educationextent3 varchar(50),
   FamilyleaguerAge3 varchar(10),
   Familyleagueroccupation3 varchar(100),
   Familyleaguertitle4 varchar(50),
   FamilyleaguerName4 varchar(50),
   educationextent4 varchar(50),
   FamilyleaguerAge4 varchar(10),
   Familyleagueroccupation4 varchar(100),
   understandEnglistName varchar(50),
   Englistextent varchar(50),
   houseArea varchar(50),
   houseQuaity varchar(50),
   HouseQuaityoffice varchar(50),
   establishmentTV varchar(10),
   aircondition varchar(10),
   icebox varchar(10),
   Phone1 varchar(10),
   washer varchar(10),
   computer varchar(10),
   Microwave varchar(10),
   Other varchar(100),
   description blob,
   sex varchar(10),
   age1 varchar(10),
   age2 varchar(10),
   lodgingdescription varchar(255),
   FullMonth varchar(10),
   fullDay varchar(10),
   AddTime date,
   Valid int(11) DEFAULT '0',
   PRIMARY KEY (ID)
);
# --------------------------------------------------------
#
# Table structure for table 'onlineapplication'
#
CREATE TABLE onlineapplication (
   ID int(11) NOT NULL auto_increment,
   UserName varchar(100),
   birth_month varchar(10),
   birth_day varchar(10),
   birth_year varchar(10),
   StreetAddress varchar(255),
   city varchar(100),
   state varchar(100),
   zip varchar(50),
   nationality varchar(50),
   phone varchar(50),
   email varchar(100),
   in_china varchar(10),
   visa_status varchar(100),
   china_city varchar(100),
   education_leve varchar(100),
   education_level_alt varchar(50),
   field_of_study varchar(100),
   field_of_study_alt varchar(100),
   teaching_experience varchar(100),
   china_experience varchar(50),
   other_experience varchar(200),
   certificate varchar(50),
   tefl varchar(10),
   tsol varchar(10),
   first_language varchar(100),
   mandarin varchar(50),
   cantonese varchar(50),
   other_language1 varchar(100),
   lang1_level varchar(50),
   other_language2 varchar(50),
   lang2_level varchar(50),
   start_month varchar(10),
   start_day varchar(10),
   start_year varchar(10),
   length varchar(50),
   preferred_location varchar(50),
   preferred_location_alt varchar(100),
   flexible varchar(10),
   school_type  varchar(100),
   physical varchar(255),
   AddTime date,
   Valid int(11) DEFAULT '0',
   PRIMARY KEY (ID)
);
# --------------------------------------------------------
#
# Table structure for table 'teacherdemand'
#
CREATE TABLE teacherdemand (
   ID int(11) NOT NULL auto_increment,
   SchoolChinaName varchar(255),
   SchoolEnglishName varchar(255),
   homeUrl varchar(200),
   HomeProvince varchar(50),
   city varchar(50),
   zip varchar(50),
   Schoolhabitude varchar(255),
   teachObject varchar(255),
   Phonemapquest varchar(10),
   Phone varchar(50),
   extension varchar(10),
   Faxmapquest varchar(20),
   FaxPhone varchar(50),
   LinkMan varchar(50),
   mobile varchar(20),
   Email1 varchar(100),
   zhaopin varchar(10),
   StartSchool varchar(50),
   monthlypay varchar(50),
   If_tax varchar(10),
   If_class varchar(10),
   timelimit varchar(50),
   teachingnum varchar(10),
   LessTeachingnum varchar(10),
   TeachingRmb varchar(10),
   Jobdescription varchar(255),
   if_request_Eng varchar(10),
   mandarin varchar(50),
   if_Eng_experience varchar(50),
   LessMonth varchar(10),
   LessYear varchar(20),
   speciality varchar(100),
   educationextent varchar(255),
   certificate varchar(30),
   if_ESL varchar(30),
   if_TSOL varchar(30),
   Asknationality varchar(255),
   Askcomplexion varchar(255),
   if_contract varchar(10),
   contractlimit varchar(255),
   if_insurance varchar(10),
   insurancecontent varchar(255),
   if_visa varchar(10),
   visatype varchar(255),
   Yearholiday varchar(20),
   if_holiday_pay varchar(20),
   holidayexplain varchar(255),
   if_quarter varchar(10),
   chamber varchar(10),
   room varchar(10),
   fitment varchar(20),
   cookroom varchar(20),
   roomphone varchar(20),
   microwave varchar(20),
   TV varchar(20),
   airconditioning varchar(10),
   computer varchar(10),
   Other varchar(10),
   waterandelectricity varchar(10),
   Phonecost varchar(10),
   heating varchar(10),
   netcost varchar(10),
   Othercost varchar(255),
   verydayfood varchar(10),
   othersay varchar(255),
   quarterdescription varchar(255),
   if_trip_mac varchar(10),
   tripcondition varchar(255),
   ortherweal varchar(255),
   FillMonth varchar(10),
   FillDay varchar(10),
   AddTime date,
   Valid int(11) DEFAULT '0',
   PRIMARY KEY (ID)
);
# --------------------------------------------------------
#
# Table structure for table 'teachingchinese'
#
CREATE TABLE teachingchinese (
   ID int(11) NOT NULL auto_increment,
   ChinaUserName varchar(50),
   EngListUserName varchar(100),
   Sex varchar(10),
   Birth_Year varchar(10),
   Birth_Month varchar(10),
   Birth_Day varchar(10),
   NativePlace varchar(50),
   stature varchar(255),
   avoirdupois varchar(100),
   Address varchar(200),
   EducationalLevel varchar(100),
   Department varchar(100),
   techexperience varchar(10),
   proied varchar(100),
   englishgrade varchar(100),
   Phonemapquest varchar(10),
   Phone varchar(50),
   extension varchar(20),
   Faxmapquest varchar(10),
   FaxPhone varchar(50),
   mobiletelephone varchar(20),
   E-mail varchar(100),
   teachingTime varchar(10),
   Startteaching varchar(100),
   Jobdescription varchar(255),
   if_Come varchar(20),
   explain varchar(255),
   FillMonth varchar(30),
   FillDay varchar(30),
   AddTime date,
   Valid int(11) DEFAULT '0',
   PRIMARY KEY (ID)
);