-- MySQL dump 8.23
--
-- Host: localhost    Database: 
---------------------------------------------------------
-- Server version	3.23.58

--
-- Current Database: arcola
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ arcola;

USE arcola;

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

DROP TABLE IF EXISTS 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;

/*!40000 ALTER TABLE `attend` DISABLE KEYS */;

--
-- Dumping data for table `attend`
--


LOCK TABLES attend WRITE;
INSERT INTO attend VALUES (1,10004,'2004-07-31','Late Excused','','502.00-4',0),(2,10003,'2004-07-31','Late Excused','2','502.00-4',25),(3,10004,'2004-07-31','Late Excused','','502.00-4',0),(4,10004,'2004-07-31','Absent Unexcused','2','',0),(5,10003,'2004-07-31','Absent Moved','1','',0),(6,10003,'2004-07-31','Late Unexcused','2','',0),(7,10004,'2004-07-31','Absent Illness','1','',0);

/*!40000 ALTER TABLE `attend` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS dates;
CREATE TABLE dates (
  id int(11) NOT NULL auto_increment,
  date date default NULL,
  type char(60) default NULL,
  field1 char(60) default NULL,
  field2 char(60) default NULL,
  field3 char(60) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `dates` DISABLE KEYS */;

--
-- Dumping data for table `dates`
--


LOCK TABLES dates WRITE;
INSERT INTO dates VALUES (1,'2003-09-06','Inservice','Attendance','late','absent');

/*!40000 ALTER TABLE `dates` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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,
  repeat text,
  parent varchar(60) default NULL,
  author varchar(60) default NULL,
  private char(1) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `discipline` DISABLE KEYS */;

--
-- Dumping data for table `discipline`
--


LOCK TABLES discipline WRITE;
INSERT INTO discipline VALUES (1,'2004-07-31','10004','Fighting','','strap','suspension','none','Willy, Nojo(11)','');

/*!40000 ALTER TABLE `discipline` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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;

/*!40000 ALTER TABLE `eval` DISABLE KEYS */;

--
-- Dumping data for table `eval`
--


LOCK TABLES eval WRITE;
INSERT INTO eval VALUES (1,'501.00-3','10004','Willy, Nojo (11)',3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

/*!40000 ALTER TABLE `eval` ENABLE KEYS */;
UNLOCK TABLES;

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

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

/*!40000 ALTER TABLE `infraction` DISABLE KEYS */;

--
-- Dumping data for table `infraction`
--


LOCK TABLES infraction WRITE;
INSERT INTO infraction VALUES (1,'Fighting'),(2,'Stealing'),(3,'Swearing');

/*!40000 ALTER TABLE `infraction` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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,
  PRIMARY KEY  (studid)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `prereg` DISABLE KEYS */;

--
-- Dumping data for table `prereg`
--


LOCK TABLES prereg WRITE;

/*!40000 ALTER TABLE `prereg` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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;

/*!40000 ALTER TABLE `preset` DISABLE KEYS */;

--
-- Dumping data for table `preset`
--


LOCK TABLES preset WRITE;

/*!40000 ALTER TABLE `preset` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `preteacher`
--

DROP TABLE IF EXISTS preteacher;
CREATE TABLE preteacher (
  teachid int(11) NOT NULL auto_increment,
  sal char(6) default NULL,
  lname char(60) default NULL,
  fname char(40) default NULL,
  userid char(40) default NULL,
  passwd char(255) default NULL,
  homeroom char(10) default NULL,
  email char(255) default NULL,
  school char(20) default NULL,
  date date default NULL,
  grade char(10) default NULL,
  position char(255) default NULL,
  doatt char(1) default NULL,
  certif char(32) default NULL,
  PRIMARY KEY  (teachid)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `preteacher` DISABLE KEYS */;

--
-- Dumping data for table `preteacher`
--


LOCK TABLES preteacher WRITE;

/*!40000 ALTER TABLE `preteacher` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS schedat;
CREATE TABLE schedat (
  id int(11) NOT NULL auto_increment,
  day char(32) default NULL,
  period char(32) default NULL,
  subjsec char(32) default NULL,
  location char(128) default NULL,
  term tinyint(3) unsigned default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `schedat` DISABLE KEYS */;

--
-- Dumping data for table `schedat`
--


LOCK TABLES schedat WRITE;

/*!40000 ALTER TABLE `schedat` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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,
  PRIMARY KEY  (studid)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `student` DISABLE KEYS */;

--
-- Dumping data for table `student`
--


LOCK TABLES student WRITE;
INSERT INTO student VALUES (1,'Gates','Bill','VRich',10003,'1','23','M','1965-01-01','The Hurricanes','343 43','','Non Native','','','',0.00,'','','','','','','','','','','Foster Parent','Nether Regions','Old Nick','666-666-6666','666-666-6666','','','','','','','','','','','','','','','','','','','','','','','','','2','324434','','','','pgates@pkts.ca','','','','password','','','','','','','1','ALL 8','bgates@pkts.ca');

/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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,
  PRIMARY KEY  (studid)
) TYPE=MRG_MyISAM UNION=(student,studentwd);

/*!40000 ALTER TABLE `studentall` DISABLE KEYS */;

--
-- Dumping data for table `studentall`
--


LOCK TABLES studentall WRITE;
INSERT INTO studentall VALUES (1,'Gates','Bill','VRich',10003,'1','23','M','1965-01-01','The Hurricanes','343 43','','Non Native','','','',0.00,'','','','','','','','','','','Foster Parent','Nether Regions','Old Nick','666-666-6666','666-666-6666','','','','','','','','','','','','','','','','','','','','','','','','','2','324434','','','','pgates@pkts.ca','','','','password','','','','','','','1','ALL 8','bgates@pkts.ca');

/*!40000 ALTER TABLE `studentall` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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,
  PRIMARY KEY  (studid)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `studentwd` DISABLE KEYS */;

--
-- Dumping data for table `studentwd`
--


LOCK TABLES studentwd WRITE;

/*!40000 ALTER TABLE `studentwd` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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(255) 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,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `subject` DISABLE KEYS */;

--
-- Dumping data for table `subject`
--


LOCK TABLES subject WRITE;
INSERT INTO subject VALUES (1,'101.00','Mathematics1','1','Lee, Jennifer (22)','','',1,'1','101.00-1','','','','','','','','','','','','','','','','','','','','',NULL,'Y',3,4,'','Math','Sabah','MA101','Class','School');

/*!40000 ALTER TABLE `subject` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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;

/*!40000 ALTER TABLE `tattend` DISABLE KEYS */;

--
-- Dumping data for table `tattend`
--


LOCK TABLES tattend WRITE;

/*!40000 ALTER TABLE `tattend` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teacher`
--

DROP TABLE IF EXISTS teacher;
CREATE TABLE teacher (
  teachid int(11) NOT NULL auto_increment,
  sal char(6) default NULL,
  lname char(60) default NULL,
  fname char(40) default NULL,
  userid char(40) default NULL,
  passwd char(255) default NULL,
  homeroom char(10) default NULL,
  email char(255) default NULL,
  school char(20) default NULL,
  date date default NULL,
  grade char(10) default NULL,
  position char(255) default NULL,
  doatt char(1) default NULL,
  certif char(32) default NULL,
  PRIMARY KEY  (teachid)
) TYPE=MyISAM;

/*!40000 ALTER TABLE `teacher` DISABLE KEYS */;

--
-- Dumping data for table `teacher`
--


LOCK TABLES teacher WRITE;
INSERT INTO teacher VALUES (1,'Ms.','Willy','Nojo','11','rsdf','33','xxk@pkts.ca','Arcola High School',NULL,'5','Classroom Teacher','Y','2233');

/*!40000 ALTER TABLE `teacher` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS 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;

/*!40000 ALTER TABLE `transfer` DISABLE KEYS */;

--
-- Dumping data for table `transfer`
--


LOCK TABLES transfer WRITE;
INSERT INTO transfer VALUES (1,10003,'2004-07-31','enrol','Initial Enrollment','18',NULL,'','','Y','Gates','Bill','VRich','2065-01-01','324434');

/*!40000 ALTER TABLE `transfer` ENABLE KEYS */;
UNLOCK TABLES;