-- MySQL dump 9.11
--
-- Host: localhost    Database: bcen
-- ------------------------------------------------------
-- Server version	4.0.20

--
-- Table structure for table `attend`
--

CREATE TABLE attend (
  attid int(11) NOT NULL auto_increment,
  studentid int(11) default NULL,
  absdate date default NULL,
  reason char(60) default NULL,
  period char(6) default NULL,
  subjsec char(32) default NULL,
  late smallint(5) unsigned default NULL,
  PRIMARY KEY  (attid)
) TYPE=MyISAM;

--
-- Table structure for table `attend_lunch`
--

CREATE TABLE attend_lunch (
  id int(11) NOT NULL auto_increment,
  studnum int(11) default NULL,
  attdate date default NULL,
  fee_type varchar(32) default NULL,
  meal_type varchar(32) default NULL,
  amount varchar(255) default NULL,
  paid char(1) default NULL,
  posted char(1) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `choices`
--

CREATE TABLE choices (
  id int(11) NOT NULL auto_increment,
  studnum int(11) default NULL,
  cdate date default NULL,
  category varchar(255) default NULL,
  ccode varchar(255) default NULL,
  points int(11) default NULL,
  comment text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `dates`
--

CREATE TABLE dates (
  id int(11) NOT NULL auto_increment,
  date date default NULL,
  type varchar(60) default NULL,
  desc1 varchar(60) default NULL,
  desc2 varchar(60) default NULL,
  dayincycle char(1) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `dbkdata`
--

CREATE TABLE dbkdata (
  id int(11) NOT NULL auto_increment,
  userid varchar(40) default NULL,
  date date default NULL,
  subjsec varchar(32) default NULL,
  period smallint(6) default NULL,
  topic varchar(255) default NULL,
  notes text,
  homework varchar(255) default NULL,
  hwdate date default NULL,
  category varchar(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `discipline`
--

CREATE TABLE discipline (
  id int(11) NOT NULL auto_increment,
  date date default NULL,
  userid varchar(60) default NULL,
  infraction varchar(255) default NULL,
  description text,
  action text,
  ifrepeat text,
  parent varchar(60) default NULL,
  author varchar(60) default NULL,
  private char(1) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `eval`
--

CREATE TABLE eval (
  id int(11) NOT NULL auto_increment,
  subjcode varchar(32) default NULL,
  studnum varchar(32) default NULL,
  teacher varchar(32) default NULL,
  term int(11) default NULL,
  program varchar(255) default NULL,
  comment text,
  a1 varchar(12) default NULL,
  a2 varchar(12) default NULL,
  a3 varchar(12) default NULL,
  a4 varchar(12) default NULL,
  a5 varchar(12) default NULL,
  a6 varchar(12) default NULL,
  a7 varchar(12) default NULL,
  a8 varchar(12) default NULL,
  a9 varchar(12) default NULL,
  a10 varchar(12) default NULL,
  a11 varchar(12) default NULL,
  a12 varchar(12) default NULL,
  a13 varchar(12) default NULL,
  a14 varchar(12) default NULL,
  a15 varchar(12) default NULL,
  a16 varchar(12) default NULL,
  a17 varchar(12) default NULL,
  a18 varchar(12) default NULL,
  a19 varchar(12) default NULL,
  a20 varchar(12) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `evaljrl`
--

CREATE TABLE evaljrl (
  id int(11) NOT NULL auto_increment,
  subjsec varchar(32) default NULL,
  studnum int(11) default NULL,
  tdate date default NULL,
  type varchar(10) default NULL,
  utag char(1) default NULL,
  lastname varchar(40) default NULL,
  firstname varchar(40) default NULL,
  middlename varchar(40) default NULL,
  birthdate date default NULL,
  identnum varchar(32) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `gbscore`
--

CREATE TABLE gbscore (
  id int(10) unsigned NOT NULL auto_increment,
  studnum mediumint(8) unsigned default NULL,
  testid int(10) unsigned default NULL,
  score varchar(16) default NULL,
  comment varchar(255) default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY studtestidx (studnum,testid)
) TYPE=MyISAM;

--
-- Table structure for table `gbtest`
--

CREATE TABLE gbtest (
  id int(10) unsigned NOT NULL auto_increment,
  subjsec varchar(32) default NULL,
  name varchar(32) default NULL,
  description varchar(255) default NULL,
  tdate date default NULL,
  score varchar(8) default NULL,
  scheme varchar(8) default NULL,
  weight mediumint(8) unsigned default NULL,
  grp varchar(32) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `infraction`
--

CREATE TABLE infraction (
  id int(11) NOT NULL auto_increment,
  name char(60) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `meta`
--

CREATE TABLE meta (
  id int(11) NOT NULL auto_increment,
  dbaseid varchar(64) default NULL,
  tableid varchar(64) default NULL,
  fieldid varchar(64) default NULL,
  datatype varchar(16) default NULL,
  arrayidx smallint(5) unsigned default NULL,
  size smallint(5) unsigned default NULL,
  fieldname varchar(255) default NULL,
  defaultvalue text,
  formtype varchar(255) default NULL,
  viewsize varchar(255) default NULL,
  required char(1) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `prereg`
--

CREATE TABLE prereg (
  studid int(11) NOT NULL auto_increment,
  lastname varchar(40) default NULL,
  firstname varchar(40) default NULL,
  initial 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,
  entry varchar(255) default NULL,
  ethnic varchar(20) default NULL,
  single char(1) default NULL,
  internet char(1) default NULL,
  youngest char(1) default NULL,
  owing decimal(9,2) default NULL,
  treaty varchar(20) default NULL,
  medical text,
  studrel varchar(25) default NULL,
  momrel varchar(25) default NULL,
  dadrel varchar(25) default NULL,
  parish varchar(255) default NULL,
  commun char(1) default NULL,
  recon char(1) default NULL,
  confirm char(1) default NULL,
  maiden varchar(40) default NULL,
  relation1 varchar(20) default NULL,
  contact1 varchar(255) default NULL,
  name1 varchar(255) default NULL,
  hphone1 varchar(64) default NULL,
  wphone1 varchar(64) default NULL,
  cell1 varchar(64) default NULL,
  fax1 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,
  name2 varchar(255) default NULL,
  hphone2 varchar(64) default NULL,
  wphone2 varchar(64) default NULL,
  cell2 varchar(64) default NULL,
  fax2 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,
  baptism char(1) default NULL,
  contact varchar(255) default NULL,
  family varchar(32) default NULL,
  alias varchar(16) default NULL,
  pic varchar(255) default NULL,
  password varchar(32) default NULL,
  field1 varchar(255) default NULL,
  field2 varchar(255) default NULL,
  field3 varchar(255) default NULL,
  prov1 varchar(32) default NULL,
  prov2 varchar(32) default NULL,
  reserveres varchar(64) default NULL,
  program varchar(64) default NULL,
  utag varchar(255) default NULL,
  email varchar(255) default NULL,
  trans_type varchar(255) default NULL,
  trans_name varchar(255) default NULL,
  trans_am_route varchar(64) default NULL,
  trans_pickup_time varchar(16) default NULL,
  trans_pm_route varchar(64) default NULL,
  trans_dropoff_time varchar(16) default NULL,
  trans_bus_stop_location varchar(64) default NULL,
  group_after_school_prog char(1) default NULL,
  PRIMARY KEY  (studid)
) TYPE=MyISAM;

--
-- Table structure for table `prereg_staff`
--

CREATE TABLE prereg_staff (
  id int(11) NOT NULL auto_increment,
  sal varchar(6) default NULL,
  lastname varchar(60) default NULL,
  firstname varchar(40) default NULL,
  middlename varchar(40) default NULL,
  userid varchar(40) default NULL,
  passwd varchar(255) default NULL,
  homeroom varchar(10) default NULL,
  email varchar(255) default NULL,
  tdate date default NULL,
  grade varchar(10) default NULL,
  position varchar(255) default NULL,
  doatt char(1) default NULL,
  certification1 varchar(255) default NULL,
  home_phone varchar(64) default NULL,
  cell_phone varchar(64) default NULL,
  street varchar(64) default NULL,
  city varchar(32) default NULL,
  prov varchar(32) default NULL,
  pcode varchar(32) default NULL,
  emergency_contact_name varchar(255) default NULL,
  emergency_contact_phone varchar(255) default NULL,
  driver_license varchar(64) default NULL,
  driver_class varchar(64) default NULL,
  vehicle_reg varchar(64) default NULL,
  vehicle_plate varchar(64) default NULL,
  citizenship varchar(64) default NULL,
  passport varchar(64) default NULL,
  alt_street varchar(64) default NULL,
  alt_city varchar(32) default NULL,
  alt_prov varchar(32) default NULL,
  alt_country varchar(64) default NULL,
  alt_pcode varchar(32) default NULL,
  alt_phone varchar(64) default NULL,
  alt_email varchar(64) default NULL,
  certification2 varchar(255) default NULL,
  certification3 varchar(255) default NULL,
  certification4 varchar(255) default NULL,
  certification5 varchar(255) default NULL,
  certification6 varchar(255) default NULL,
  certification7 varchar(255) default NULL,
  certification8 varchar(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `prereg_waitlist`
--

CREATE TABLE prereg_waitlist (
  id int(11) NOT NULL auto_increment,
  studnum int(11) default NULL,
  enroldate date default NULL,
  waitnumber int(11) default NULL,
  description text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `preset`
--

CREATE TABLE preset (
  id int(11) NOT NULL auto_increment,
  lastname char(40) default NULL,
  firstname char(40) default NULL,
  initial char(2) default NULL,
  studnum int(11) default NULL,
  grade char(2) default NULL,
  homeroom char(4) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `schedat`
--

CREATE TABLE schedat (
  id int(11) NOT NULL auto_increment,
  day varchar(32) default NULL,
  period varchar(32) default NULL,
  subjsec varchar(32) default NULL,
  grade varchar(32) default NULL,
  term tinyint(3) unsigned default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `sessions`
--

CREATE TABLE sessions (
  id varchar(32) NOT NULL default '',
  a_session text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `staff`
--

CREATE TABLE staff (
  id int(11) NOT NULL auto_increment,
  sal varchar(6) default NULL,
  lastname varchar(60) default NULL,
  firstname varchar(40) default NULL,
  middlename varchar(40) default NULL,
  userid varchar(40) default NULL,
  passwd varchar(255) default NULL,
  homeroom varchar(10) default NULL,
  email varchar(255) default NULL,
  tdate date default NULL,
  grade varchar(10) default NULL,
  position varchar(255) default NULL,
  doatt char(1) default NULL,
  certification1 varchar(255) default NULL,
  home_phone varchar(64) default NULL,
  cell_phone varchar(64) default NULL,
  street varchar(64) default NULL,
  city varchar(32) default NULL,
  prov varchar(32) default NULL,
  pcode varchar(32) default NULL,
  emergency_contact_name varchar(255) default NULL,
  emergency_contact_phone varchar(255) default NULL,
  driver_license varchar(64) default NULL,
  driver_class varchar(64) default NULL,
  vehicle_reg varchar(64) default NULL,
  vehicle_plate varchar(64) default NULL,
  citizenship varchar(64) default NULL,
  passport varchar(64) default NULL,
  alt_street varchar(64) default NULL,
  alt_city varchar(32) default NULL,
  alt_prov varchar(32) default NULL,
  alt_country varchar(64) default NULL,
  alt_pcode varchar(32) default NULL,
  alt_phone varchar(64) default NULL,
  alt_email varchar(64) default NULL,
  certification2 varchar(255) default NULL,
  certification3 varchar(255) default NULL,
  certification4 varchar(255) default NULL,
  certification5 varchar(255) default NULL,
  certification6 varchar(255) default NULL,
  certification7 varchar(255) default NULL,
  certification8 varchar(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `student`
--

CREATE TABLE student (
  studid int(11) NOT NULL auto_increment,
  lastname varchar(40) default NULL,
  firstname varchar(40) default NULL,
  initial 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,
  entry varchar(255) default NULL,
  ethnic varchar(20) default NULL,
  single char(1) default NULL,
  internet char(1) default NULL,
  youngest char(1) default NULL,
  owing decimal(9,2) default NULL,
  treaty varchar(20) default NULL,
  medical text,
  studrel varchar(25) default NULL,
  momrel varchar(25) default NULL,
  dadrel varchar(25) default NULL,
  parish varchar(255) default NULL,
  commun char(1) default NULL,
  recon char(1) default NULL,
  confirm char(1) default NULL,
  maiden varchar(40) default NULL,
  relation1 varchar(20) default NULL,
  contact1 varchar(255) default NULL,
  name1 varchar(255) default NULL,
  hphone1 varchar(64) default NULL,
  wphone1 varchar(64) default NULL,
  cell1 varchar(64) default NULL,
  fax1 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,
  name2 varchar(255) default NULL,
  hphone2 varchar(64) default NULL,
  wphone2 varchar(64) default NULL,
  cell2 varchar(64) default NULL,
  fax2 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,
  baptism char(1) default NULL,
  contact varchar(255) default NULL,
  family varchar(32) default NULL,
  alias varchar(16) default NULL,
  pic varchar(255) default NULL,
  password varchar(32) default NULL,
  field1 varchar(255) default NULL,
  field2 varchar(255) default NULL,
  field3 varchar(255) default NULL,
  prov1 varchar(32) default NULL,
  prov2 varchar(32) default NULL,
  reserveres varchar(64) default NULL,
  program varchar(64) default NULL,
  utag varchar(255) default NULL,
  email varchar(255) default NULL,
  trans_type varchar(255) default NULL,
  trans_name varchar(255) default NULL,
  trans_am_route varchar(64) default NULL,
  trans_pickup_time varchar(16) default NULL,
  trans_pm_route varchar(64) default NULL,
  trans_dropoff_time varchar(16) default NULL,
  trans_bus_stop_location varchar(64) default NULL,
  group_after_school_prog char(1) default NULL,
  PRIMARY KEY  (studid)
) TYPE=MyISAM;


--
-- Table structure for table `studentwd`
--

CREATE TABLE studentwd (
  studid int(11) NOT NULL auto_increment,
  lastname varchar(40) default NULL,
  firstname varchar(40) default NULL,
  initial 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,
  entry varchar(255) default NULL,
  ethnic varchar(20) default NULL,
  single char(1) default NULL,
  internet char(1) default NULL,
  youngest char(1) default NULL,
  owing decimal(9,2) default NULL,
  treaty varchar(20) default NULL,
  medical text,
  studrel varchar(25) default NULL,
  momrel varchar(25) default NULL,
  dadrel varchar(25) default NULL,
  parish varchar(255) default NULL,
  commun char(1) default NULL,
  recon char(1) default NULL,
  confirm char(1) default NULL,
  maiden varchar(40) default NULL,
  relation1 varchar(20) default NULL,
  contact1 varchar(255) default NULL,
  name1 varchar(255) default NULL,
  hphone1 varchar(64) default NULL,
  wphone1 varchar(64) default NULL,
  cell1 varchar(64) default NULL,
  fax1 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,
  name2 varchar(255) default NULL,
  hphone2 varchar(64) default NULL,
  wphone2 varchar(64) default NULL,
  cell2 varchar(64) default NULL,
  fax2 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,
  baptism char(1) default NULL,
  contact varchar(255) default NULL,
  family varchar(32) default NULL,
  alias varchar(16) default NULL,
  pic varchar(255) default NULL,
  password varchar(32) default NULL,
  field1 varchar(255) default NULL,
  field2 varchar(255) default NULL,
  field3 varchar(255) default NULL,
  prov1 varchar(32) default NULL,
  prov2 varchar(32) default NULL,
  reserveres varchar(64) default NULL,
  program varchar(64) default NULL,
  utag varchar(255) default NULL,
  email varchar(255) default NULL,
  trans_type varchar(255) default NULL,
  trans_name varchar(255) default NULL,
  trans_am_route varchar(64) default NULL,
  trans_pickup_time varchar(16) default NULL,
  trans_pm_route varchar(64) default NULL,
  trans_dropoff_time varchar(16) default NULL,
  trans_bus_stop_location varchar(64) default NULL,
  group_after_school_prog char(1) default NULL,
  PRIMARY KEY  (studid)
) TYPE=MyISAM;

--
-- Table structure for table `subject`
--

CREATE TABLE subject (
  id int(11) NOT NULL auto_increment,
  subjcode varchar(32) default NULL,
  description varchar(255) default NULL,
  grade varchar(8) default NULL,
  teacher varchar(127) default NULL,
  modules varchar(255) default NULL,
  type varchar(10) default NULL,
  sequence int(11) default NULL,
  section varchar(32) default NULL,
  subjsec varchar(32) default NULL,
  q1 varchar(255) default NULL,
  q2 varchar(255) default NULL,
  q3 varchar(255) default NULL,
  q4 varchar(255) default NULL,
  q5 varchar(255) default NULL,
  q6 varchar(255) default NULL,
  q7 varchar(255) default NULL,
  q8 varchar(255) default NULL,
  q9 varchar(255) default NULL,
  q10 varchar(255) default NULL,
  q11 varchar(255) default NULL,
  q12 varchar(255) default NULL,
  q13 varchar(255) default NULL,
  q14 varchar(255) default NULL,
  q15 varchar(255) default NULL,
  q16 varchar(255) default NULL,
  q17 varchar(255) default NULL,
  q18 varchar(255) default NULL,
  q19 varchar(255) default NULL,
  q20 varchar(255) default NULL,
  alias varchar(16) default NULL,
  visible char(1) default NULL,
  startrptperiod tinyint(3) unsigned default NULL,
  endrptperiod tinyint(3) unsigned default NULL,
  markscheme text,
  faculty varchar(255) default NULL,
  location varchar(255) default NULL,
  smdesc varchar(8) default NULL,
  instmode varchar(64) default NULL,
  exammix varchar(64) default NULL,
  active char(1) default NULL,
  schedppc1 int(11) default NULL,
  schedppc2 int(11) default NULL,
  schedppc3 int(11) default NULL,
  schedppc4 int(11) default NULL,
  backwith varchar(16) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `tattend`
--

CREATE TABLE tattend (
  attid int(11) NOT NULL auto_increment,
  techid char(20) default NULL,
  date datetime default NULL,
  PRIMARY KEY  (attid)
) TYPE=MyISAM;

--
-- Table structure for table `transfer`
--

CREATE TABLE transfer (
  id int(11) NOT NULL auto_increment,
  studnum int(11) default NULL,
  date date default NULL,
  type varchar(10) default NULL,
  description varchar(255) default NULL,
  entrytype varchar(8) default NULL,
  exittype varchar(8) default NULL,
  prov varchar(8) default NULL,
  country varchar(8) default NULL,
  utag char(1) default NULL,
  lastname varchar(40) default NULL,
  firstname varchar(40) default NULL,
  middlename varchar(40) default NULL,
  birthdate date default NULL,
  provnum varchar(12) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `tscriptdata`
--

CREATE TABLE tscriptdata (
  id int(11) NOT NULL auto_increment,
  studnum int(11) default NULL,
  subjectcode char(32) default NULL,
  subjecttext char(255) default NULL,
  mark char(32) default NULL,
  schoolyear char(16) default NULL,
  crdate date default NULL,
  credit char(16) default NULL,
  credithours char(16) default NULL,
  term int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `tscriptident`
--

CREATE TABLE tscriptident (
  id int(11) NOT NULL auto_increment,
  studnum int(11) default NULL,
  lastname char(40) default NULL,
  firstname char(40) default NULL,
  middlename char(40) default NULL,
  birthdate date default NULL,
  studentid char(32) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;


--
-- Table structure for table `studentall`
--

CREATE TABLE studentall (
  studid int(11) NOT NULL auto_increment,
  lastname varchar(40) default NULL,
  firstname varchar(40) default NULL,
  initial 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,
  entry varchar(255) default NULL,
  ethnic varchar(20) default NULL,
  single char(1) default NULL,
  internet char(1) default NULL,
  youngest char(1) default NULL,
  owing decimal(9,2) default NULL,
  treaty varchar(20) default NULL,
  medical text,
  studrel varchar(25) default NULL,
  momrel varchar(25) default NULL,
  dadrel varchar(25) default NULL,
  parish varchar(255) default NULL,
  commun char(1) default NULL,
  recon char(1) default NULL,
  confirm char(1) default NULL,
  maiden varchar(40) default NULL,
  relation1 varchar(20) default NULL,
  contact1 varchar(255) default NULL,
  name1 varchar(255) default NULL,
  hphone1 varchar(64) default NULL,
  wphone1 varchar(64) default NULL,
  cell1 varchar(64) default NULL,
  fax1 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,
  name2 varchar(255) default NULL,
  hphone2 varchar(64) default NULL,
  wphone2 varchar(64) default NULL,
  cell2 varchar(64) default NULL,
  fax2 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,
  baptism char(1) default NULL,
  contact varchar(255) default NULL,
  family varchar(32) default NULL,
  alias varchar(16) default NULL,
  pic varchar(255) default NULL,
  password varchar(32) default NULL,
  field1 varchar(255) default NULL,
  field2 varchar(255) default NULL,
  field3 varchar(255) default NULL,
  prov1 varchar(32) default NULL,
  prov2 varchar(32) default NULL,
  reserveres varchar(64) default NULL,
  program varchar(64) default NULL,
  utag varchar(255) default NULL,
  email varchar(255) default NULL,
  trans_type varchar(255) default NULL,
  trans_name varchar(255) default NULL,
  trans_am_route varchar(64) default NULL,
  trans_pickup_time varchar(16) default NULL,
  trans_pm_route varchar(64) default NULL,
  trans_dropoff_time varchar(16) default NULL,
  trans_bus_stop_location varchar(64) default NULL,
  group_after_school_prog char(1) default NULL,
  PRIMARY KEY  (studid)
) TYPE=MRG_MyISAM UNION=(student,studentwd);