
CREATE TABLE `student_temp` (
  `studid` int(11) NOT NULL AUTO_INCREMENT,
  `lastname` varchar(40) DEFAULT NULL,
  `firstname` varchar(40) DEFAULT NULL,
  `initial` varchar(40) DEFAULT NULL,
  `alias_lastname` varchar(40) DEFAULT NULL,
  `alias_firstname` varchar(40) DEFAULT NULL,
  `legal_lastname` varchar(40) DEFAULT NULL,
  `legal_firstname` varchar(40) DEFAULT NULL,
  `studnum` int(11) DEFAULT NULL,
  `grade` varchar(8) DEFAULT NULL,
  `homeroom` varchar(8) DEFAULT NULL,
  `sex` char(1) DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `house` varchar(20) DEFAULT NULL,
  `healthid` varchar(12) DEFAULT NULL,
  `ethnic` varchar(20) DEFAULT NULL,
  `treaty` varchar(20) DEFAULT NULL,
  `medical` mediumtext DEFAULT NULL,
  `studrel` varchar(25) DEFAULT NULL,
  `momrel` varchar(25) DEFAULT NULL,
  `dadrel` varchar(25) DEFAULT NULL,
  `relation1` varchar(20) DEFAULT NULL,
  `contact1` varchar(255) DEFAULT NULL,
  `hphone1` varchar(64) DEFAULT NULL,
  `wphone1` varchar(64) DEFAULT NULL,
  `cell1` varchar(64) DEFAULT NULL,
  `par1_house` varchar(64) DEFAULT NULL,
  `address1` varchar(40) DEFAULT NULL,
  `city1` varchar(40) DEFAULT NULL,
  `pcode1` varchar(10) DEFAULT NULL,
  `workplace1` varchar(60) DEFAULT NULL,
  `relation2` varchar(20) DEFAULT NULL,
  `contact2` varchar(255) DEFAULT NULL,
  `hphone2` varchar(64) DEFAULT NULL,
  `wphone2` varchar(64) DEFAULT NULL,
  `cell2` varchar(64) DEFAULT NULL,
  `par2_house` varchar(64) DEFAULT NULL,
  `address2` varchar(40) DEFAULT NULL,
  `city2` varchar(40) DEFAULT NULL,
  `pcode2` varchar(10) DEFAULT NULL,
  `workplace2` varchar(60) DEFAULT NULL,
  `emrelation` varchar(20) DEFAULT NULL,
  `emname` varchar(255) DEFAULT NULL,
  `emhphone` varchar(64) DEFAULT NULL,
  `emwphone` varchar(64) DEFAULT NULL,
  `emcell` varchar(64) DEFAULT NULL,
  `doctor` varchar(70) DEFAULT NULL,
  `docphone` varchar(15) DEFAULT NULL,
  `busroute` varchar(30) DEFAULT NULL,
  `provnum` varchar(12) DEFAULT NULL,
  `band` varchar(64) DEFAULT NULL,
  `bandnum` varchar(32) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `pic` varchar(255) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  `field1` text DEFAULT NULL,
  `field2` text DEFAULT NULL,
  `field3` text DEFAULT NULL,
  `field4` text DEFAULT NULL,
  `field5` text DEFAULT NULL,
  `field6` text DEFAULT NULL,
  `field7` text DEFAULT NULL,
  `field8` text DEFAULT NULL,
  `field9` text DEFAULT NULL,
  `field10` text DEFAULT NULL,
  `field11` text DEFAULT NULL,
  `field12` text DEFAULT NULL,
  `field13` text DEFAULT NULL,
  `field14` text DEFAULT NULL,
  `field15` text DEFAULT NULL,
  `field16` text DEFAULT NULL,
  `prov1` varchar(32) DEFAULT NULL,
  `prov2` varchar(32) DEFAULT NULL,
  `reserveres` varchar(64) DEFAULT NULL,
  `program` varchar(64) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `lunchstatus` varchar(255) DEFAULT NULL,
  `par1_email` varchar(64) DEFAULT NULL,
  `par2_email` varchar(64) DEFAULT NULL,
  `name_prefix` varchar(64) DEFAULT NULL,
  `name_suffix` varchar(64) DEFAULT NULL,
  `billet` varchar(255) DEFAULT NULL,
  `childcare_name` varchar(255) DEFAULT NULL,
  `childcare_address` varchar(255) DEFAULT NULL,
  `childcare_phone1` varchar(255) DEFAULT NULL,
  `childcare_phone2` varchar(255) DEFAULT NULL,
  `internet_type` varchar(255) DEFAULT NULL,
  `par1_firstname` varchar(255) DEFAULT NULL,
  `par1_lastname` varchar(255) DEFAULT NULL,
  `par2_firstname` varchar(255) DEFAULT NULL,
  `par2_lastname` varchar(255) DEFAULT NULL,
  `graddate` date DEFAULT NULL,
  `address_land` varchar(32) DEFAULT NULL,
  `cumfolder` tinyint(4) DEFAULT NULL,
  `address1mailing` varchar(128) DEFAULT NULL,
  `address2mailing` varchar(128) DEFAULT NULL,
  `parent_lockout` varchar(8) DEFAULT NULL,
  `mssid` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`studid`),
  KEY `student_name` (`lastname`,`firstname`),
  KEY `student_grade` (`grade`),
  KEY `student_homeroom` (`homeroom`),
  KEY `student_studnum` (`studnum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
