-- MySQL dump 10.13 Distrib 5.1.61, for debian-linux-gnu (i686)
--
-- Host: babbage Database: n12fraser
-- ------------------------------------------------------
-- Server version 5.1.37-1ubuntu5.5
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `tDays`
--
DROP TABLE IF EXISTS `tDays`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tDays` (
`dayName` char(3) DEFAULT NULL,
`daySort` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tDays`
--
LOCK TABLES `tDays` WRITE;
/*!40000 ALTER TABLE `tDays` DISABLE KEYS */;
INSERT INTO `tDays` VALUES ('Mon',1),('Tue',2),('Wed',3),('Thu',4),('Fri',5),('Sat',6),('Sun',7);
/*!40000 ALTER TABLE `tDays` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tEventClasses`
--
DROP TABLE IF EXISTS `tEventClasses`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tEventClasses` (
`crec_id` int(11) NOT NULL AUTO_INCREMENT,
`crecEvClass` char(36) DEFAULT NULL,
`crecSortOrder` int(11) DEFAULT NULL,
`crecSD` int(11) DEFAULT NULL,
`crecPriceClass` int(11) DEFAULT NULL,
`crecPriceFirst` decimal(6,2) DEFAULT NULL,
`crecPriceSecond` decimal(6,2) DEFAULT NULL,
`crecPriceThird` decimal(6,2) DEFAULT NULL,
`crecPriceLater` decimal(6,2) DEFAULT NULL,
`crecEvClassShortName` char(8) DEFAULT NULL,
`crecSoloPartTeam` int(11) DEFAULT NULL,
`crecKidsBringMusic` int(11) DEFAULT NULL,
`crecDisplayMenuCode` char(24) DEFAULT NULL,
PRIMARY KEY (`crec_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tEventClasses`
--
LOCK TABLES `tEventClasses` WRITE;
/*!40000 ALTER TABLE `tEventClasses` DISABLE KEYS */;
INSERT INTO `tEventClasses` VALUES (1,'FS-IJS',10,0,1,'95.00','40.00',NULL,'40.00','FS',0,1,NULL),(2,'Freeskate',20,0,2,'85.00','35.00',NULL,'35.00','FS',0,1,NULL),(3,'Test Track',30,0,2,'85.00','35.00',NULL,'35.00','TT',0,1,NULL),(4,'Short Program',40,0,1,'95.00','40.00',NULL,'40.00','SP',0,1,NULL),(5,'Compulsory',50,0,2,'85.00','35.00',NULL,'35.00','CM',0,0,NULL),(6,'Jumps',60,0,2,'85.00','35.00',NULL,'35.00','Jumps',0,0,NULL),(7,'Spins',70,0,2,'85.00','35.00',NULL,'35.00','Spins',0,0,NULL),(8,'Showcase',80,0,2,'85.00','35.00',NULL,'35.00','Show',0,1,NULL),(9,'Basic Elements',90,0,3,'50.00','25.00',NULL,'25.00','Elem',0,0,NULL),(10,'Basic ProgMusic',100,0,3,'50.00','25.00',NULL,'25.00','ProgM',0,1,NULL),(11,'FS Compuls',110,0,3,'60.00','25.00',NULL,'25.00','FSCM',0,0,NULL),(12,'FS Prog',120,0,3,'60.00','25.00',NULL,'25.00','FSPr',0,0,NULL);
/*!40000 ALTER TABLE `tEventClasses` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tEventLevels`
--
DROP TABLE IF EXISTS `tEventLevels`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tEventLevels` (
`crel_id` int(11) NOT NULL AUTO_INCREMENT,
`crelEcid` int(11) DEFAULT NULL,
`crelLevName` char(36) DEFAULT NULL,
`crelSortOrder` int(11) DEFAULT NULL,
`crelProgDur` decimal(5,2) DEFAULT NULL,
`crelJudgingTime` decimal(5,2) DEFAULT NULL,
`crelWarmupDur` decimal(5,2) DEFAULT NULL,
`crelPrefMaxFliteSize` int(11) DEFAULT NULL,
`crelPrefMaxWuSize` int(11) DEFAULT NULL,
`crelHorF` char(1) DEFAULT NULL,
`crelAllowedOverage` int(11) DEFAULT NULL,
`crelGenderMixOk` int(11) DEFAULT NULL,
`crelEvCode` char(6) DEFAULT NULL,
PRIMARY KEY (`crel_id`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tEventLevels`
--
LOCK TABLES `tEventLevels` WRITE;
/*!40000 ALTER TABLE `tEventLevels` DISABLE KEYS */;
INSERT INTO `tEventLevels` VALUES (1,1,'Open Juv',10,'2.25','2.00','5.00',18,6,'F',2,0,NULL),(2,1,'Juvenile',20,'2.25','2.00','5.00',18,6,'F',2,0,NULL),(3,1,'Intermediate',30,'2.50','2.00','5.00',18,6,'F',2,0,NULL),(4,1,'Novice',40,'3.00','2.00','5.00',18,6,'F',2,0,NULL),(5,1,'Junior',50,'3.50','2.00','6.00',18,6,'F',2,0,NULL),(6,1,'Senior',60,'4.00','2.00','6.00',18,6,'F',2,0,NULL),(7,2,'NoTest',10,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(8,2,'PrePreliminary',20,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(9,2,'PrePreliminary Ltd',30,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(10,2,'Preliminary',40,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(11,2,'Preliminary Ltd',50,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(12,2,'PreJuvenile',60,'2.00','0.75','4.00',12,99,'F',2,0,NULL),(13,3,'Ltd Beginner TT',10,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(14,3,'Beginner TT',20,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(15,3,'PrePrelim TT',30,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(16,3,'Preliminary TT',40,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(17,3,'PreJuvenile TT',50,'2.00','0.75','4.00',12,99,'F',2,0,NULL),(18,3,'Juvenile TT',60,'2.25','0.75','4.00',12,99,'F',2,0,NULL),(19,3,'Intermediate TT',70,'2.50','0.75','5.00',12,99,'F',2,0,NULL),(20,3,'Novice TT',80,'3.00','0.75','5.00',12,99,'F',2,0,NULL),(21,3,'Junior TT',90,'3.50','0.75','5.00',12,99,'F',2,0,NULL),(22,3,'Senior TT',100,'4.00','0.75','5.00',12,99,'F',2,0,NULL),(23,4,'Open Juvenile',10,'2.00','2.00','5.00',18,6,'F',2,0,NULL),(24,4,'Juvenile',20,'2.00','2.00','5.00',18,6,'F',2,0,NULL),(25,4,'Intermediate',30,'2.00','2.00','5.00',18,6,'F',2,0,NULL),(26,4,'Novice',40,'2.50','2.00','5.00',18,6,'F',2,0,NULL),(27,4,'Junior',50,'2.83','2.00','6.00',18,6,'F',2,0,NULL),(28,4,'Senior',60,'2.83','2.00','6.00',18,6,'F',2,0,NULL),(29,5,'Beginner',10,'1.00','0.75','4.00',8,99,'H',2,0,NULL),(30,5,'High Begin',20,'1.00','0.75','4.00',8,99,'H',2,0,NULL),(31,5,'PrePrelim',30,'1.25','0.75','4.00',8,99,'H',2,0,NULL),(32,5,'Preliminary',40,'1.50','0.75','4.00',8,99,'H',2,1,NULL),(33,5,'PreJuvenile',50,'1.50','0.75','4.00',8,99,'H',2,1,NULL),(34,6,'Beginner',10,'1.50','0.75','4.00',8,99,'H',2,0,NULL),(35,6,'High Beginner',20,'1.50','0.75','4.00',8,99,'H',2,0,NULL),(36,6,'PrePreliminary',30,'1.50','0.75','4.00',8,99,'H',2,0,NULL),(37,6,'Preliminary',40,'1.50','0.75','4.00',8,99,'H',2,0,NULL),(38,6,'PreJuvenile',50,'1.50','0.75','4.00',8,99,'H',2,0,NULL),(39,6,'Juvenile',60,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(40,6,'Intermediate',70,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(41,6,'Novice',80,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(42,7,'PrePreliminary',10,'1.50','0.75','4.00',8,99,'H',2,0,NULL),(43,7,'Preliminary',20,'2.00','0.75','4.00',8,99,'H',2,0,NULL),(44,7,'PreJuv/Juv',30,'2.00','0.75','4.00',8,99,'H',2,0,NULL),(45,7,'Interm/Nov',40,'2.00','0.75','4.00',8,99,'H',2,0,NULL),(46,7,'Junior/Senior',50,'2.00','0.75','4.00',8,99,'H',2,0,NULL),(47,8,'Group I',10,'1.50','0.75','4.00',8,99,'F',2,0,NULL),(48,8,'Group II',20,'1.60','0.75','4.00',8,99,'F',2,0,NULL),(49,8,'Group III',30,'2.25','0.75','4.00',8,99,'F',2,0,NULL),(50,8,'Group IV',40,'2.25','0.75','4.00',8,99,'F',2,0,NULL),(51,9,'Snowplow',10,'1.25','0.75','4.00',6,99,'H',0,0,NULL),(52,9,'Basic 1',20,'1.25','0.75','4.00',6,99,'H',0,0,NULL),(53,9,'Basic 2',30,'1.25','0.75','4.00',6,99,'H',0,0,NULL),(54,9,'Basic 3',40,'1.25','0.75','4.00',6,99,'H',0,0,NULL),(55,9,'Basic 4',50,'1.25','0.75','4.00',6,99,'H',0,0,NULL),(56,9,'Basic 5',60,'1.25','0.75','4.00',6,99,'H',0,0,NULL),(57,9,'Basic 6',70,'1.50','0.75','4.00',6,99,'H',0,0,NULL),(58,9,'Basic 7',80,'1.25','0.75','4.00',6,99,'H',0,0,NULL),(59,9,'Basic 8',90,'1.50','0.75','4.00',6,99,'H',0,0,NULL),(60,10,'Snowplow',10,'1.25','0.75','4.00',6,99,'F',0,0,NULL),(61,10,'Basic 1',20,'1.00','0.75','4.00',6,99,'F',0,0,NULL),(62,10,'Basic 2',30,'1.00','0.75','4.00',6,99,'F',0,0,NULL),(63,10,'Basic 3',40,'1.00','0.75','4.00',6,99,'F',0,0,NULL),(64,10,'Basic 4',50,'1.00','0.75','4.00',6,99,'F',0,0,NULL),(65,10,'Basic 5',60,'1.00','0.75','4.00',6,99,'F',0,0,NULL),(66,10,'Basic 6',70,'1.00','0.75','4.00',6,99,'F',0,0,NULL),(67,10,'Basic 7',80,'1.00','0.75','4.00',6,99,'F',0,0,NULL),(68,10,'Basic 8',90,'1.00','0.75','4.00',6,99,'F',0,0,NULL),(69,11,'Freeskate 1',10,'1.00','0.75','4.00',6,99,'H',0,0,NULL),(70,11,'Freeskate 2',20,'1.00','0.75','4.00',6,99,'H',0,0,NULL),(71,12,'Freeskate 1',10,'1.00','0.75','4.00',6,99,'F',0,0,NULL),(72,12,'Freeskate 2',20,'1.00','0.75','4.00',6,99,'F',0,0,NULL);
/*!40000 ALTER TABLE `tEventLevels` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tEvents`
--
DROP TABLE IF EXISTS `tEvents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tEvents` (
`ev_id` int(11) NOT NULL AUTO_INCREMENT,
`evNum` char(6) DEFAULT NULL,
`evName` char(36) DEFAULT NULL,
`evTime` time DEFAULT NULL,
`evSide` char(2) DEFAULT NULL,
`evDay` char(3) DEFAULT NULL,
`evRink` char(16) DEFAULT NULL,
`evType` int(11) DEFAULT NULL,
`evSoloPartTeam` int(11) DEFAULT NULL,
`evKidsBringMusic` int(11) DEFAULT NULL,
`evCode` char(6) DEFAULT NULL,
`evLevCodeForPI` char(3) DEFAULT NULL,
`evIJS` int(11) DEFAULT NULL,
`evOrdersSet` int(11) DEFAULT '0',
`evResuCalc` int(11) DEFAULT '0',
`evNumMarks` int(11) DEFAULT NULL,
`evMarkPrio` int(11) DEFAULT NULL,
`evStdTypeCode` char(6) DEFAULT NULL,
PRIMARY KEY (`ev_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tEvents`
--
LOCK TABLES `tEvents` WRITE;
/*!40000 ALTER TABLE `tEvents` DISABLE KEYS */;
/*!40000 ALTER TABLE `tEvents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tInfo`
--
DROP TABLE IF EXISTS `tInfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tInfo` (
`inf_id` int(11) NOT NULL AUTO_INCREMENT,
`infCompName` char(48) DEFAULT NULL,
`infDateString` char(48) DEFAULT NULL,
`infDayString` char(21) DEFAULT NULL,
`infEntryDueDate` date DEFAULT NULL,
`infMenuURL` char(100) DEFAULT NULL,
`infRink1` char(18) DEFAULT NULL,
`infRink2` char(18) DEFAULT NULL,
`infRink3` char(18) DEFAULT NULL,
`infRink4` char(18) DEFAULT NULL,
`infShowPI` int(11) DEFAULT NULL,
`infShowPI2` int(11) DEFAULT NULL,
`infShowPI3` int(11) DEFAULT NULL,
`infLabelPI` char(12) DEFAULT NULL,
`infLabelPI2` char(12) DEFAULT NULL,
`infLabelPI3` char(12) DEFAULT NULL,
`infDailyMaxPI` int(11) DEFAULT NULL,
`infDailyMaxPI2` int(11) DEFAULT NULL,
`infDailyMaxPI3` int(11) DEFAULT NULL,
`infPILevelFilt` int(11) DEFAULT NULL,
`infPIPaidFilt` int(11) DEFAULT NULL,
`infShowDanceTests` int(11) DEFAULT NULL,
`infShowBSTests` int(11) DEFAULT NULL,
`infShowBSFSTests` int(11) DEFAULT NULL,
`infShowPairTests` int(11) DEFAULT NULL,
`infRegistrarName` char(48) DEFAULT NULL,
`infRegistrarEmail` char(80) DEFAULT NULL,
`infRegistrar2Name` char(48) DEFAULT NULL,
`infRegistrar2Email` char(80) DEFAULT NULL,
`infPIcontactName` char(48) DEFAULT NULL,
`infPIcontactEmail` char(80) DEFAULT NULL,
`infCostPI` decimal(6,2) DEFAULT NULL,
`infMailTo` char(80) DEFAULT NULL,
`infLateFee` decimal(6,2) DEFAULT NULL,
`infPayableTo` char(48) DEFAULT NULL,
`infPIenablewhen` char(36) DEFAULT NULL,
`infPIdisablewhen` char(36) DEFAULT NULL,
`infMailtoPI` char(48) DEFAULT NULL,
`infShowCoachUsfsa` int(11) DEFAULT NULL,
`infShowCoachPSA` int(11) DEFAULT NULL,
`infShowPostal` int(11) DEFAULT NULL,
`infShowTestDates` int(11) DEFAULT NULL,
`infRoundup` int(11) DEFAULT NULL,
`infAvail` int(11) DEFAULT NULL,
`infDBtype` char(1) DEFAULT NULL,
`infHasCreg` int(11) DEFAULT NULL,
`infLockEventTables` int(11) DEFAULT NULL,
`infDemoMode` int(11) DEFAULT NULL,
`infPIflavor` int(11) DEFAULT NULL,
`infEvtId` int(11) DEFAULT NULL,
`infPayRqdBy` char(36) DEFAULT NULL,
`infLogoLeftFile` char(36) DEFAULT NULL,
`infLogoRightFile` char(36) DEFAULT NULL,
PRIMARY KEY (`inf_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tInfo`
--
LOCK TABLES `tInfo` WRITE;
/*!40000 ALTER TABLE `tInfo` DISABLE KEYS */;
INSERT INTO `tInfo` VALUES (1,'Fraser Summer Classic 2012','Jul 14 2012','','2012-06-01','http://evt.sk8stuff.com/lister_event_detail.asp?id=4456','Main','','','',1,0,0,'','','',99,99,99,0,0,0,0,0,0,'Chris Bisby 586-604-1784','chris_bisby@comcast.net','','','','','15.00','Chris Bisby; 48743 Kings Dr; Shelby Twp MI 48315','25.00','Fraser FSC','(not yet determined)','(not yet determined)','',0,0,1,0,0,2,'3',1,0,0,1,4456,'48 hrs after online registration',NULL,NULL);
/*!40000 ALTER TABLE `tInfo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tJudgeEventsAssigned`
--
DROP TABLE IF EXISTS `tJudgeEventsAssigned`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tJudgeEventsAssigned` (
`jea_id` int(11) NOT NULL AUTO_INCREMENT,
`jeaJid` int(11) DEFAULT NULL,
`jeaEvNum` char(6) DEFAULT NULL,
`jeaRole` char(1) DEFAULT NULL,
PRIMARY KEY (`jea_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tJudgeEventsAssigned`
--
LOCK TABLES `tJudgeEventsAssigned` WRITE;
/*!40000 ALTER TABLE `tJudgeEventsAssigned` DISABLE KEYS */;
/*!40000 ALTER TABLE `tJudgeEventsAssigned` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tJudges`
--
DROP TABLE IF EXISTS `tJudges`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tJudges` (
`j_id` int(11) NOT NULL AUTO_INCREMENT,
`jName` char(36) DEFAULT NULL,
`jAppointed` int(11) DEFAULT NULL,
`jSlotNum` int(11) DEFAULT NULL,
PRIMARY KEY (`j_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tJudges`
--
LOCK TABLES `tJudges` WRITE;
/*!40000 ALTER TABLE `tJudges` DISABLE KEYS */;
/*!40000 ALTER TABLE `tJudges` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tMessages`
--
DROP TABLE IF EXISTS `tMessages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tMessages` (
`msg_id` int(11) NOT NULL AUTO_INCREMENT,
`msgType` int(11) DEFAULT NULL,
`msgText` text,
`msgTitle` char(64) DEFAULT NULL,
`msgWho` char(36) DEFAULT NULL,
`msgAddl1` char(36) DEFAULT NULL,
`msgAddl2` char(36) DEFAULT NULL,
`msgSortOrder` int(11) DEFAULT NULL,
PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tMessages`
--
LOCK TABLES `tMessages` WRITE;
/*!40000 ALTER TABLE `tMessages` DISABLE KEYS */;
INSERT INTO `tMessages` VALUES (1,3,'The information on the entry form is accurate as of June 1 2012. My child is an eligible skater under the rules of the\r\nUSFS and eligible to enter the events as listed on the entry form. I am aware there is a $25.00 fee for any changes made after the deadline.','Certification of Parent/Guardian','Parent / Guardian','','',10),(2,3,'I fully understand that skating involves risks of serious bodily injury. I accept such risks and assume responsibility for any losses, costs or damages incurred as a result of participation in this competition. I hereby release the Fraser Figure Skating Club, its Board of Directors, volunteers, agents and Great Lakes Sports City from all liability, claims, demands, losses or damages on my account.','Waiver of Claims for Injury','Parent / Guardian','','',20),(3,4,'To the best of my knowledge, the information on the entry form is accurate as of Jun 1 2012. The competitor is a current member in good standing of the listed club or a current participant in the figure skating program of the listed facility.','Certification of Club Officer or Basic Skills Director','Officer/Director','','',30),(4,3,'To the best of my knowledge, the information on the entry form\r\nIs accurate as of June 1 2012. The competitor is eligible to\r\nEnter the events as indicated on the form. I am aware that\r\nthere is a $25.00 fee for any changes made after the deadline.','Certification of Coach','Coach','','',40),(5,0,'First IJS event $95 / $40 ea additional; First 6.0 event $85 / $35 ea additional; First Basic event $50 / $25 ea additional; First Basic FS event $60 / $25 ea additional','','','','',100);
/*!40000 ALTER TABLE `tMessages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tPractEvents`
--
DROP TABLE IF EXISTS `tPractEvents`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tPractEvents` (
`pie_id` int(11) NOT NULL AUTO_INCREMENT,
`pieEvNum` char(6) DEFAULT NULL,
`pieMaxKids` int(11) DEFAULT NULL,
`pieEvClass` int(11) DEFAULT NULL,
`pieLevelsOK` char(32) DEFAULT NULL,
PRIMARY KEY (`pie_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tPractEvents`
--
LOCK TABLES `tPractEvents` WRITE;
/*!40000 ALTER TABLE `tPractEvents` DISABLE KEYS */;
/*!40000 ALTER TABLE `tPractEvents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tProInfo`
--
DROP TABLE IF EXISTS `tProInfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tProInfo` (
`pro_id` int(11) NOT NULL AUTO_INCREMENT,
`proSkCode` char(32) DEFAULT NULL,
`proCoachName` char(48) DEFAULT NULL,
`proCoachFname` char(24) DEFAULT NULL,
`proCoachLname` char(24) DEFAULT NULL,
`proCoachUsfsa` char(12) DEFAULT NULL,
`proCoachPSA` char(12) DEFAULT NULL,
`proCoachPhone` char(14) DEFAULT NULL,
`proCoachEmail` char(80) DEFAULT NULL,
`proVerified` int(11) DEFAULT NULL,
`proCode` char(32) DEFAULT NULL,
PRIMARY KEY (`pro_id`)
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tProInfo`
--
LOCK TABLES `tProInfo` WRITE;
/*!40000 ALTER TABLE `tProInfo` DISABLE KEYS */;
INSERT INTO `tProInfo` VALUES (2,'1596267','Berlin, Julie','Julie','Berlin','NONE','','','Coachberlin@yahoo.com',NULL,'berlinjulie'),(4,'6656645','Piscitelli, Donna','Donna','Piscitelli','NONE','','dæI‚0N`U³‹','donna_iceskate@hotmail.com',NULL,'piscitellidonna'),(5,'1304573','Waters, Darlene','Darlene','Waters','none',NULL,'','',0,'watersdarlene'),(6,'6331446','Crighton, Dawn','Dawn','Crighton','NONE','','dÃ~ªK€![FŽ|','sk8rmissdawn@yahoo.com',NULL,'crightondawn'),(7,'1354969','Berlin, Julie','Julie','Berlin','none',NULL,'','',0,'berlinjulie'),(8,'6429809','Berlin, Julie','Julie','Berlin','none',NULL,'','',0,'berlinjulie'),(9,'6292503','Czisny-Roy, Amber','Amber','Czisny-Roy','NONE','','dª%àN…„¬k^Â,Ø','coachrinaroy@yahoo.com',NULL,'czisnyroyamber'),(10,'6292503','Hollander, Dan','Dan','Hollander','0','','{_eð°dÈ–š','danpilsung@gmail.com',NULL,'hollanderdan'),(11,'8720526','LaDue, Claire','Claire','LaDue','NONE','','','claire_ladue@yahoo.com',NULL,'ladueclaire'),(12,'8774801','Murray, Linda','Linda','Murray','NONE','','dÃëöM†‡]1[Êí™','lsmurray@cogeco.ca',NULL,'murraylinda'),(13,'6714199','HAASE, NATASHA','NATASHA','HAASE','none',NULL,'','',0,'haasenatasha'),(14,'6604124','Haase, Natasha','Natasha','Haase','none',NULL,'','',0,'haasenatasha'),(15,'1572417','LaFever, Heather','Heather','LaFever','none',NULL,'','',0,'lafeverheather'),(16,'1199750','Page ODonoghue, Lindsay','Lindsay','Page ODonoghue','NONE','','','',NULL,'pageodonoghuelindsay'),(17,'8772703','LaFever, Heather','Heather','LaFever','none',NULL,'','',0,'lafeverheather'),(18,'6698966','Harris-Koleczko, Carly','Carly','Harris-Koleczko','none',NULL,'','',0,'harriskoleczkocarly'),(19,'FAKE00998','Brooks, Jenny','Jenny','Brooks','none',NULL,'','',0,'brooksjenny'),(20,'FAKE01002','Timm, Jackie','Jackie','Timm','none',NULL,'','',0,'timmjackie'),(21,'6684405','Schrier, Larry','Larry','Schrier','none',NULL,'','',0,'schrierlarry'),(22,'6363564','Haase, Natasha','Natasha','Haase','none',NULL,'','',0,'haasenatasha'),(23,'6497053','LaFever, Heather','Heather','LaFever','none',NULL,'','',0,'lafeverheather'),(24,'6497052','LaFever, Heather','Heather','LaFever','none',NULL,'','',0,'lafeverheather'),(25,'1534355','O\' Donoghue, Lindsay','Lindsay','O\' Donoghue','NONE','','d¹íDAŠ×‰…VÆñÒ/','lepsk8@comcast.net',NULL,'odonoghuelindsay'),(26,'1551221','Chapman, Mel','Mel','Chapman','NONE','','dª%àN…ÅÝ^ÏË¢','mchapman1210@aol.com',NULL,'chapmanmel'),(27,'1533112','O\'Donoghue, Lindsay','Lindsay','O\'Donoghue','NONE','','d¹íDAŠ×‰…VÆñÒ/','lepsk8@comcast.net',NULL,'odonoghuelindsay'),(28,'6313716','Holfelder, Renee','Renee','Holfelder','NONE','','dÃ~ªK€ZIRUÅR Ô','luv2sk8renee@comcast.net',NULL,'holfelderrenee'),(29,'6357326','Rosinski, Michelle','Michelle','Rosinski','NONE','','dÃ~ªK€[¤ÑREen','ShellyRosinski@gmail.com',NULL,'rosinskimichelle'),(30,'6607320','Berlin, Julie','Julie','Berlin','NONE','','','coachberlin@yahoo.com',NULL,'berlinjulie'),(31,'6607320','Tasch, Jodie','Jodie','Tasch','0','','{_ez±žR”u$WO','',NULL,'taschjodie'),(32,'6278209','Felice, Karen','Karen','Felice','NONE','','','',NULL,'felicekaren'),(33,'6489630','Campau, Jennifer','Jennifer','Campau','NONE','','dÂܾ@‹*ôÃ_Uꓪ','jenniferc@taylorsportsplex.com',NULL,'campaujennifer'),(34,'6575694','Murray, Linda','Linda','Murray','NONE','','dÃëöM†‡]1[Êí™','lsmurray@cogeco.ca',NULL,'murraylinda'),(35,'6017527','Felice, Karen','Karen','Felice','NONE','','dª%àN…_°eP¨Ui','',NULL,'felicekaren'),(36,'6716321','Chapman, Mel','Mel','Chapman','NONE','','dª%àN…ÅÝ^ÏË¢','mchapman1210@aol.com',NULL,'chapmanmel'),(37,'66779278','Chapman, Mel','Mel','Chapman','NONE','','dª%àN…ÅÝ^ÏË¢','MChapman1210@aol.com',NULL,'chapmanmel'),(38,'1572022','Holfelder, Renee','Renee','Holfelder','NONE','','dÃ~ªK€ZIRUÅR Ô','luv2sk8renee@comcast.net',NULL,'holfelderrenee'),(39,'1572022','Hayward, Heather','Heather','Hayward','0','','{_ez¥‹f‘pUê','',NULL,'haywardheather'),(40,'6468303','Lingenfelter, Karen','Karen','Lingenfelter','NONE','','dª%àN…ÅPÎREŒt1','lingcoach@aol.com',NULL,'lingenfelterkaren'),(41,'6468300','Lingenfelter, Karen','Karen','Lingenfelter','NONE','','dª%àN…ÅPÎREŒt1','lingcoach@aol.com',NULL,'lingenfelterkaren'),(42,'6345019','Sheikh, Ameena','Ameena','Sheikh','NONE','','d©ÿDÒ¹\"Zà™Û','ameena.r.sheikh@gmail.com',NULL,'sheikhameena'),(43,'6345019','sheikh, sameena','sameena','sheikh','0','','','sfsheikh@oakland.edu',NULL,'sheikhsameena'),(44,'1244164','Berlin, Julie Berlin','Julie Berlin','Berlin','NONE','','','CoachBerlin@yahoo.com',NULL,'berlinjulieberlin'),(45,'1244164','Tasich, Jodie Tasich','Jodie Tasich','Tasich','0','','','',NULL,'tasichjodietasich'),(46,'6274465','Felice, Karen','Karen','Felice','NONE','','dª%àN…_°eP¨Ui','',NULL,'felicekaren'),(47,'1510796','O\'donoghue, Lindsay','lindsay','o\'donoghue','NONE','','d¹íDAŠ×‰…VÆñÒ/','',NULL,'odonoghuelindsay'),(48,'6321951','Chapman, Mel','Mel','Chapman','NONE','','dª%àN…ÅÝ^ÏË¢','',NULL,'chapmanmel'),(49,'6705812','VIGILANTE, LAURIE','LAURIE','VIGILANTE','none',NULL,'','',0,'vigilantelaurie'),(50,'6557862','SMYTH, CLAIRE','CLAIRE','SMYTH','none',NULL,'','',0,'smythclaire'),(51,'1538985','VIGILANTE, LAURIE','LAURIE','VIGILANTE','none',NULL,'','',0,'vigilantelaurie'),(52,'6484607','LAFEVER, HEATHER','HEATHER','LAFEVER','none',NULL,'','',0,'lafeverheather'),(53,'6681874','Odonghue, Lindsay','lindsay','odonghue','NONE','','','',NULL,'odonghuelindsay'),(54,'6681874',', maria muscato','maria muscato','','0','','','',NULL,'mariamuscato'),(55,'8707048','Rosinski, Michelle','Michelle','Rosinski','NONE','','dÃ~ªK€[¤ÑREen','',NULL,'rosinskimichelle'),(56,'6692101','HAASE, NATASHA','NATASHA','HAASE','none',NULL,'','',0,'haasenatasha'),(57,'1555941','HAASE, NATASHA','NATASHA','HAASE','none',NULL,'','',0,'haasenatasha'),(58,'1610985','CRIGHTON, DAWN','DAWN','CRIGHTON','none',NULL,'','',0,'crightondawn'),(59,'6524679','DEYCH, TATIANA','TATIANA','DEYCH','none',NULL,'','',0,'deychtatiana'),(60,'6693239','Deych, Tatyana','Tatyana','Deych','NONE','','','',NULL,'deychtatyana'),(61,'8806868','Kirkendall, Kim','Kim','Kirkendall','NONE','','dæI‚#³ÔW‰BË7','ekirkendall@att.net',NULL,'kirkendallkim'),(62,'FAKE01009','Forrest, Jennifer','Jennifer','Forrest','NONE','','','',NULL,'forrestjennifer'),(63,'6370326','Felice, Karen','Karen','Felice','NONE','','dª%àN…_°eP¨Ui','kfelice@comcast.net',NULL,'felicekaren'),(64,'1557691','Holfelder, Renee','Renee','Holfelder','NONE','','dÃ~ªK€•G‡TCPŽ','',NULL,'holfelderrenee'),(65,'1572890','Murray, Linda','Linda','Murray','NONE','','','',NULL,'murraylinda'),(66,'6297314','Okolski, Colleen','Colleen','Okolski','NONE','','dÂܾ@‹*[„W]\rT4','cmayokolski@gmail.com',NULL,'okolskicolleen'),(67,'6259778','Rosinski, Michelle','Michelle','Rosinski','NONE','','dÃ~ªK€[¤ÑREen','',NULL,'rosinskimichelle'),(68,'6577128','Ladue, Claire','Claire','Ladue','NONE','','','',NULL,'ladueclaire'),(69,'6716323','DALPRA, STEFANY','STEFANY','DALPRA','none',NULL,'','',0,'dalprastefany'),(70,'6451041','Moss, Sandy','Sandy','Moss','NONE','','dÂܾ@‹9Áh]øŽæ','sandymoss18@sbcglobal.net',NULL,'mosssandy');
/*!40000 ALTER TABLE `tProInfo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tResMarks`
--
DROP TABLE IF EXISTS `tResMarks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tResMarks` (
`rsm_id` int(11) NOT NULL AUTO_INCREMENT,
`rsmEvNum` char(6) DEFAULT NULL,
`rsmSkCode` char(12) DEFAULT NULL,
`rsmJudgeSlot` int(11) DEFAULT NULL,
`rsmM1` int(11) DEFAULT NULL,
`rsmM2` int(11) DEFAULT NULL,
`rsmMtot` int(11) DEFAULT NULL,
`rsmOrd` int(11) DEFAULT NULL,
PRIMARY KEY (`rsm_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tResMarks`
--
LOCK TABLES `tResMarks` WRITE;
/*!40000 ALTER TABLE `tResMarks` DISABLE KEYS */;
/*!40000 ALTER TABLE `tResMarks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tResults`
--
DROP TABLE IF EXISTS `tResults`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tResults` (
`rs_id` int(11) NOT NULL AUTO_INCREMENT,
`rsEvNum` char(6) DEFAULT NULL,
`rsSkCode` char(12) DEFAULT NULL,
`rsPlace` int(11) DEFAULT NULL,
`rsNote` char(12) DEFAULT NULL,
PRIMARY KEY (`rs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tResults`
--
LOCK TABLES `tResults` WRITE;
/*!40000 ALTER TABLE `tResults` DISABLE KEYS */;
/*!40000 ALTER TABLE `tResults` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tSideCodes`
--
DROP TABLE IF EXISTS `tSideCodes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tSideCodes` (
`sc_id` int(11) NOT NULL AUTO_INCREMENT,
`scLetter` char(1) DEFAULT NULL,
`scName` char(18) DEFAULT NULL,
PRIMARY KEY (`sc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tSideCodes`
--
LOCK TABLES `tSideCodes` WRITE;
/*!40000 ALTER TABLE `tSideCodes` DISABLE KEYS */;
INSERT INTO `tSideCodes` VALUES (1,'Z','Zamboni'),(2,'L','Lobby'),(3,'F','Flag'),(4,'C','Clock'),(5,'S','Scoreboard'),(6,'O','Other');
/*!40000 ALTER TABLE `tSideCodes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tSkaterEventsAssigned`
--
DROP TABLE IF EXISTS `tSkaterEventsAssigned`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tSkaterEventsAssigned` (
`sea_id` int(11) NOT NULL AUTO_INCREMENT,
`seaEvNum` char(6) DEFAULT NULL,
`seaEvCode` char(6) DEFAULT NULL,
`seaSkCode` char(12) DEFAULT NULL,
`seaTeamIdent` char(12) DEFAULT NULL,
`seaSkateOrder` int(11) DEFAULT '999',
PRIMARY KEY (`sea_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tSkaterEventsAssigned`
--
LOCK TABLES `tSkaterEventsAssigned` WRITE;
/*!40000 ALTER TABLE `tSkaterEventsAssigned` DISABLE KEYS */;
/*!40000 ALTER TABLE `tSkaterEventsAssigned` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tSkaterEventsOrdered`
--
DROP TABLE IF EXISTS `tSkaterEventsOrdered`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tSkaterEventsOrdered` (
`nse_id` int(11) NOT NULL AUTO_INCREMENT,
`nseUsfsa` char(12) DEFAULT NULL,
`nseEvClassId` int(11) DEFAULT NULL,
`nseEvLevId` int(11) DEFAULT NULL,
`nseLevName` char(36) DEFAULT NULL,
`nsePrice` decimal(6,2) DEFAULT NULL,
PRIMARY KEY (`nse_id`)
) ENGINE=MyISAM AUTO_INCREMENT=108 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tSkaterEventsOrdered`
--
LOCK TABLES `tSkaterEventsOrdered` WRITE;
/*!40000 ALTER TABLE `tSkaterEventsOrdered` DISABLE KEYS */;
INSERT INTO `tSkaterEventsOrdered` VALUES (21,'1354969',4,28,'Senior','0.00'),(20,'1354969',1,6,'Senior','0.00'),(19,'6331446',3,15,'PrePrelim TT','85.00'),(18,'1304573',1,5,'Junior','0.00'),(17,'1304573',4,27,'Junior','0.00'),(16,'6656645',3,16,'Preliminary TT','85.00'),(12,'1596267',7,45,'Interm/Nov','85.00'),(11,'1596267',4,24,'Juvenile','40.00'),(10,'1596267',1,2,'Juvenile','95.00'),(22,'6429809',2,8,'PrePreliminary','0.00'),(23,'6429809',5,31,'PrePrelim','0.00'),(24,'6429809',6,36,'PrePreliminary','0.00'),(25,'6429809',7,42,'PrePreliminary','0.00'),(26,'6292503',2,12,'PreJuvenile','85.00'),(27,'6292503',5,33,'PreJuvenile','35.00'),(28,'6292503',6,39,'Juvenile','35.00'),(29,'8720526',3,15,'PrePrelim TT','85.00'),(30,'8774801',12,71,'Freeskate 1','60.00'),(31,'6714199',3,15,'PrePrelim TT','0.00'),(32,'6604124',2,10,'Preliminary','0.00'),(33,'1572417',3,21,'Junior TT','0.00'),(34,'1199750',3,15,'PrePrelim TT','85.00'),(35,'8772703',3,14,'Beginner TT','0.00'),(36,'6698966',3,14,'Beginner TT','0.00'),(37,'FAKE00998',10,65,'Basic 5','0.00'),(38,'FAKE01002',10,66,'Basic 6','0.00'),(39,'6684405',8,47,'Group I','0.00'),(40,'6684405',3,15,'PrePrelim TT','0.00'),(42,'6363564',2,7,'NoTest','0.00'),(43,'6497053',3,16,'Preliminary TT','0.00'),(44,'6497052',3,17,'PreJuvenile TT','0.00'),(45,'1534355',3,20,'Novice TT','85.00'),(46,'1551221',2,11,'Preliminary Ltd','85.00'),(47,'1551221',5,32,'Preliminary','35.00'),(48,'1551221',6,37,'Preliminary','35.00'),(49,'1551221',7,43,'Preliminary','35.00'),(50,'1533112',1,2,'Juvenile','95.00'),(51,'1533112',4,24,'Juvenile','40.00'),(52,'6313716',2,12,'PreJuvenile','85.00'),(53,'6357326',3,17,'PreJuvenile TT','85.00'),(54,'6607320',2,8,'PrePreliminary','85.00'),(55,'6278209',3,16,'Preliminary TT','85.00'),(56,'6489630',2,10,'Preliminary','85.00'),(57,'6575694',3,16,'Preliminary TT','85.00'),(58,'6017527',3,18,'Juvenile TT','85.00'),(59,'6017527',7,44,'PreJuv/Juv','35.00'),(60,'6716321',2,9,'PrePreliminary Ltd','85.00'),(61,'6716321',5,31,'PrePrelim','35.00'),(62,'6716321',6,36,'PrePreliminary','35.00'),(63,'6716321',7,43,'Preliminary','35.00'),(64,'6716321',8,48,'Group II','35.00'),(65,'66779278',2,8,'PrePreliminary','85.00'),(66,'66779278',5,31,'PrePrelim','35.00'),(67,'66779278',6,36,'PrePreliminary','35.00'),(68,'66779278',7,43,'Preliminary','35.00'),(69,'1572022',3,19,'Intermediate TT','85.00'),(70,'6468303',3,16,'Preliminary TT','85.00'),(71,'6468300',3,14,'Beginner TT','85.00'),(72,'6345019',2,10,'Preliminary','85.00'),(73,'6345019',5,32,'Preliminary','35.00'),(74,'6345019',6,37,'Preliminary','35.00'),(75,'6345019',7,43,'Preliminary','35.00'),(76,'6345019',8,48,'Group II','35.00'),(77,'1244164',1,6,'Senior','95.00'),(78,'6274465',3,17,'PreJuvenile TT','85.00'),(79,'1510796',1,3,'Intermediate','95.00'),(80,'1510796',4,25,'Intermediate','40.00'),(81,'6321951',2,9,'PrePreliminary Ltd','85.00'),(82,'6321951',5,31,'PrePrelim','35.00'),(83,'6321951',6,36,'PrePreliminary','35.00'),(84,'6321951',7,42,'PrePreliminary','35.00'),(85,'6705812',2,10,'Preliminary','0.00'),(86,'6557862',3,14,'Beginner TT','0.00'),(87,'1538985',1,1,'Open Juv','0.00'),(88,'6484607',3,18,'Juvenile TT','0.00'),(89,'6681874',4,24,'Juvenile','95.00'),(90,'8707048',3,15,'PrePrelim TT','85.00'),(91,'6692101',9,59,'Basic 8','0.00'),(92,'1555941',2,12,'PreJuvenile','0.00'),(93,'1610985',8,48,'Group II','0.00'),(94,'6524679',3,14,'Beginner TT','0.00'),(95,'6693239',3,13,'Ltd Beginner TT','85.00'),(96,'8806868',9,54,'Basic 3','50.00'),(97,'8806868',10,63,'Basic 3','25.00'),(98,'FAKE01009',12,71,'Freeskate 1','60.00'),(99,'6370326',3,17,'PreJuvenile TT','85.00'),(100,'1557691',6,40,'Intermediate','85.00'),(101,'1557691',7,45,'Interm/Nov','35.00'),(102,'1572890',3,17,'PreJuvenile TT','85.00'),(103,'6297314',2,12,'PreJuvenile','85.00'),(104,'6297314',8,49,'Group III','35.00'),(105,'6259778',3,18,'Juvenile TT','85.00'),(106,'6577128',3,16,'Preliminary TT','85.00'),(107,'6451041',2,7,'NoTest','85.00');
/*!40000 ALTER TABLE `tSkaterEventsOrdered` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tSkaterInfo`
--
DROP TABLE IF EXISTS `tSkaterInfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tSkaterInfo` (
`nsi_id` int(11) NOT NULL AUTO_INCREMENT,
`nsiLname` char(24) DEFAULT NULL,
`nsiFname` char(24) DEFAULT NULL,
`nsiGender` char(1) DEFAULT NULL,
`nsiFlightSort` int(11) DEFAULT NULL,
`nsiBirthdate` date DEFAULT NULL,
`nsiPhone` char(14) DEFAULT NULL,
`nsiCell` char(14) DEFAULT NULL,
`nsiUsfsaNum` char(12) DEFAULT NULL,
`nsiClub` char(48) DEFAULT NULL,
`nsiEmail` char(80) DEFAULT NULL,
`nsiHighestFStest` int(11) DEFAULT NULL,
`nsiHighestMIFtest` int(11) DEFAULT NULL,
`nsiHighestDancetest` int(11) DEFAULT NULL,
`nsiHighestBStest` int(11) DEFAULT NULL,
`nsiHighestBFtest` int(11) DEFAULT NULL,
`nsiHighestPairtest` int(11) DEFAULT NULL,
`nsiPhoneticFname` char(32) DEFAULT NULL,
`nsiPhoneticLname` char(32) DEFAULT NULL,
`nsiNumPI` int(11) DEFAULT NULL,
`nsiNumPI2` int(11) DEFAULT NULL,
`nsiNumPI3` int(11) DEFAULT NULL,
`nsiAgree` char(3) DEFAULT NULL,
`nsiChallenge` int(11) DEFAULT NULL,
`nsiPin` int(11) DEFAULT NULL,
`nsiPinSent` int(11) DEFAULT NULL,
`nsiEmailConf` int(11) DEFAULT NULL,
`nsiEntryAccept` int(11) DEFAULT NULL,
`nsiEnteredDate` date DEFAULT NULL,
`nsiPostal1` char(48) DEFAULT NULL,
`nsiPostal2` char(48) DEFAULT NULL,
`nsiTestDateFS` char(12) DEFAULT NULL,
`nsiTestDateMIF` char(12) DEFAULT NULL,
`nsiTestDateDance` char(12) DEFAULT NULL,
`nsiTestDate` char(12) DEFAULT NULL,
`nsiTestDateBF` char(12) DEFAULT NULL,
`nsiTestDatePair` char(12) DEFAULT NULL,
`nsiNoteSkater` text,
`nsiNoteLOC` text,
`nsiSpecial1` char(32) DEFAULT NULL,
`nsiTestDateBS` char(12) DEFAULT NULL,
PRIMARY KEY (`nsi_id`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tSkaterInfo`
--
LOCK TABLES `tSkaterInfo` WRITE;
/*!40000 ALTER TABLE `tSkaterInfo` DISABLE KEYS */;
INSERT INTO `tSkaterInfo` VALUES (2,'Vassel-beasley','Jolie','F',NULL,'2000-12-27','dª%àN…^S?UÅF|ã','dÃ~ªK€2þ;QÁd\'','1596267','Detroit SC','Agentdawn1@yahoo.com',4,7,-1,-1,-1,-1,'Joe-lee','Vass L BEEZ Lee',0,0,0,'YES',115417,311641,NULL,0,1,'2012-03-09','”´U¥+YÖeñöQèÚ','~ܯm\ZX3÷F3£Ä”²îe','','','',NULL,'','','',NULL,NULL,''),(5,'Su','Flora','F',NULL,'1993-04-18','d]J3±*R Pƒ','','1304573','Champlain Valley FSC','Cliang@uvm.edu',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,470368,270716,0,0,1,'2012-04-15','”ßmƒšeJ°Qü#nÆáN¨°‚','\nm¦#N,LŸ!£±Ó‚G#ÁÄ,ΙÂ',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(4,'Padgett','Renae','F',NULL,'1997-07-02','dæI‚ÂÌ‹X³€Ü•','dæI‚ÂÌ‹X³€Ü•','6656645','Ice Mountain FSC','sueraepadgett@gmail.com',2,2,-1,-1,-1,-1,'Renae','Padgett',1,0,0,'YES',385228,507824,NULL,0,1,'2012-04-15','‰§ˆ[«%PìnÕ:ƒ§‚K','AØÄçã&FâðtíH','','','',NULL,'','','',NULL,NULL,''),(6,'Huber','Hannah','F',NULL,'2002-05-30','dª%àN…ÅËÍQ©Æu¥','dª%àN…^SV\\DÍm','6331446','Rochester Onyx Ice Arena','jenhuber1@yahoo.com',0,2,-1,-1,-1,-1,'','',0,0,0,'YES',207365,530907,NULL,0,1,'2012-05-09','”Y\"÷LwMõ-ZUÐm\\[wâì','”Ïv','','','',NULL,'','','',NULL,NULL,''),(7,'Glastris','Georgia','F',NULL,'1992-08-01','d/1K€2£ËWòÂ,Ø','','1354969','Dupage FSC','giglastris@msn.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,509362,751978,0,0,1,'2012-05-09','Üñpû3Þ!Vy¢óãCÕ×','0ëÉ\n†+)º¾=i£þ%¡è',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(8,'Palinski','Mackenzie','F',NULL,'2003-03-03','dª%àN…T³•x','','6429809','Red River Valley Fsc/detroit SC','piperpalinski@yahoo.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,691423,828391,0,0,1,'2012-05-12','ܨüú—k£3','~ܯm\ZX3÷F3{‰÷;<®s% w½1',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(9,'Fey','Nicolette','F',NULL,'2000-02-23','dÃ~ªK€2°Q©ˆ`7','','6292503','Detroit SC','f_fey@hotmail.com',2,8,-1,-1,-1,-1,'NIK oh let','fay',1,0,0,'YES',977852,874510,NULL,0,1,'2012-05-12','{íô¼IÆŽìÜ8*/3','ÝÁâÁsèP÷àó?5YHIkëZ','~ܯm\ZX3÷F3{‰÷;<®s% w½Þ','','','',NULL,'','','',NULL,NULL,''),(40,'Sheikh','Farah','F',NULL,'1994-12-18','d©ÿDTÂ6\\Í·m‰','','1244164','Detroit SC','asheikh@oakland.edu',8,8,-1,-1,-1,-1,'Fer-ah','shake',0,0,0,'YES',87520,713266,NULL,0,0,'2012-05-30','E!ô>ÁsèP÷àó?5YHIkëZ','~ܯm\ZX3÷F3{‰÷;<®s% w½Þ','','','',NULL,'','','',NULL,NULL,''),(41,'Levy','Hannah','F',NULL,'1994-11-23','dª%àN…7ûVQÁå','dª%àN…7ûVQÁå','6274465','Lakeland Arena','Lnorahs@comcast.net',3,3,-1,-1,-1,-1,'','Leee-vy',0,0,0,'YES',186286,428280,NULL,0,0,'2012-05-30','X>¨Œ*ˆ`y1Ø\\m²: é\Z','Ù\rT:ã¢(ÀÅ•¹ZÊ®·•,‘F+','','','',NULL,'','','',NULL,NULL,''),(42,'Mulligan','Maria','F',NULL,'1998-11-04','dæI‚#³ÔW¼Ó‰','','1510796','St Clair Shores FSC','chaingang08@hughes.net',5,5,-1,-1,-1,-1,'','',2,0,0,'YES',954326,741262,NULL,0,0,'2012-05-30',']_¯#q f~†¹© Ÿ','\n\nK\nIÈ_°ÍGhÈdY.','','','',NULL,'','','',NULL,NULL,''),(43,'Caruso','Nina','F',NULL,'2000-12-27','dÃ~ªK€!ÿÈTC‹c‡','dÃ~ªK€!ÿÈTC‹c‡','6321951','Fraser FSC','nickic12345@aol.com',1,0,-1,-1,-1,-1,'','',2,0,0,'YES',28606,375406,NULL,0,0,'2012-05-30',']Û9\'}ŠÁwê+0Ìf','3*Ÿe\0Ï\'¯¨¸ŒO•','','','',NULL,'','','',NULL,NULL,''),(44,'Wrobel','Brooke','F',NULL,'2001-11-05','dÂܾ@‹*ôY^µŒc','','6705812','Dearborn FSC','twrobel9621@wowway.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,776717,167357,0,0,1,'2012-05-30','{£b«óƒ…Æ/ÚÎO^,9(V‚','0„¹kœ»·÷-¹&5<\\/',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(45,'Iatrou','Emily','F',NULL,'2001-04-02','dª%àN…7¦TSöˆ\Zß','','6557862','Lakeland SC','iatrou@comcast.net',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,779410,134280,0,0,1,'2012-05-30','h—u/£Z m~g8â‰Ïê$\"Ç','0å%ç˜cá&\\åÛ•O˜·˜Åg*ö0Z',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(46,'Johnson','Elizabeth','F',NULL,'1998-06-12','d¹íDAŠÊÅÀ\\ùüß–','','1538985','Dearborn FSC','caroljoh@medd.umich.edu',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,871229,115903,0,0,1,'2012-05-30','”ë‰õto\r´¿RÒ8²A\'&ŽP','ö&Há¼®*üOV',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(47,'Polega','Alex','F',NULL,'2000-01-16','dÃ~ªK€Ýƒ·}üN','','','',NULL,'','','',NULL,NULL,''),(49,'Cleaves','Simone','F',NULL,'2000-03-21','d¹íDAŠ‹£PG›„','','8707048','St Clair Shores FSC','sacleaves@yahoo.com',1,2,-1,-1,-1,-1,'Sa-mone','Cleeves',0,0,0,'YES',298420,795367,NULL,0,0,'2012-05-31','{–»î„Añ:@‰¾lÖ[','ö*3gpÒb!ƒck§è\"¾','','','',NULL,'','','',NULL,NULL,''),(50,'Shi','Ivy','F',NULL,'2005-08-16','dª%àN…Å„œZP†X‹','','6692101','Birmingham FSC','wei.wang300@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,896313,23660,0,0,1,'2012-05-31','”¥dQ¡Wp# qb.¦³–X^}»','?ͧqaŒ#øñËzó',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(51,'Collins','Ellana','F',NULL,'1996-12-02','dÃ~ªK€ÝÌPWƈ×b','','1555941','SC of Novi','pharmarina@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,225335,933823,0,0,1,'2012-05-31','‰0/£è1âPqt–iŒž£‚u','0å%ç˜cá&\\åÛ•O˜·˜Åg*ö0µ',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(52,'Steffens','Lindsey','F',NULL,'1999-12-11','dÃ~ªK€Ý5_H€{','','1610985','Onyx-suburban SA','dsteffens22@gmail.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,194250,246690,0,0,1,'2012-05-31','¤‹X|ˆJd*Ù?¬DÙÛt’)Š¸','\noÛ?H½Æ/êÌ9—»q…ª…Øz7ëY',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(53,'Spears','Katrina','F',NULL,'2004-07-29','dª%àN…^²SWò ','','6524679','Detroit SC','jrspears2002@yahoo.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,NULL,743100,875959,0,0,1,'2012-05-31','‰’¾óM414ÁY£‡¯!!ñf','~ܯm\ZX3÷F3{‰÷;<®s% w½Þ',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL),(54,'Rits','Emily','F',NULL,'2004-11-17','dª%àN…_QT‡Ûn','dª%àN…_QT‡Ûn','6693239','Detroit SC','Alina.rits@gmail.com',0,0,-1,-1,-1,-1,'Emily','Rits',0,0,0,'YES',330732,102580,NULL,0,0,'2012-05-31',']\0+þE^‚•\'»ÈõÐ\069','~ܯm\ZX3÷F3{‰÷;<®s% w½Þ','','','',NULL,'','','',NULL,NULL,''),(55,'Shepherd','Raegan','F',NULL,'2005-05-10','dæI‚—:PGT×','dæI‚ß´ÓPGôVØ','8806868','Port Huron FSC','sledrunners@comcast.net',0,0,-1,-1,-1,-1,'','',0,0,0,'YES',305468,999138,NULL,0,0,'2012-05-31','”YÃ]æ’²crcœ¯\'','³ƒôë”°´$\\','','','',NULL,'','','',NULL,NULL,''),(56,'Amodeo','Mia','F',NULL,'2002-02-14','dXè AŠ8F\\V\\`','','FAKE01009','Lake Effect FSC','reneeamodeo@att.net',0,0,-1,-1,-1,-1,'Mee-ah','Ah-ma-day-oh',1,0,0,'YES',507076,445141,NULL,0,0,'2012-05-31',']•?¦L«HýýG¢9AJÇûÌ','XÞjäAA»\"Ž¡‰Ë|ìJš','','','',NULL,'','','',NULL,NULL,''),(57,'Sullivan','Erin','F',NULL,'1995-10-17','dª%àN…„T¬Ñ,','','6370326','Lakeland SC','hodgesully@comcast.net',3,5,-1,-1,-1,-1,'air in','',1,0,0,'YES',622424,223792,NULL,0,0,'2012-05-31',']•¹!LŠ€Ó-!Ù91','03=-NJÌL´³£—A¥È','','','',NULL,'','','',NULL,NULL,''),(58,'Vazana','Megan','F',NULL,'1997-08-22','dª%àN…ÅËV®Ž„#','dÃ~ªK€[·Vˆ¹q','1557691','Onyx-suburban SA','susan.deeb@llproducts.com',5,7,-1,-1,-1,-1,'','',0,0,0,'YES',704998,457322,NULL,0,0,'2012-06-01',']î>ï¡ê*H ~ýj#€¤»“—','3Ä’Óï ½ºªžHñ','','','',NULL,'','','',NULL,NULL,''),(59,'Lashbrook','Hannah','F',NULL,'1998-01-16','dæI‚#ƒPõÂ','dæI‚ÂÌePÁÛ','1572890','Port Huron FSC','jenniferlashbrook@comcast.net',2,0,-1,-1,-1,-1,'','',0,0,0,'YES',645373,262762,NULL,0,0,'2012-06-01','GmRN{è]M',')çfñ÷4Ü9','','','',NULL,'','','',NULL,NULL,''),(60,'Erskine','Sophia','F',NULL,'1999-06-09','dEê÷L‡5VgR×','dEê÷L‡5VgR×','6297314','Ann Arbor FSC','sk8ersmom@gmail.com',3,3,-1,-1,-1,-1,'Sof-E-a','ER-skin',1,0,0,'YES',302675,801157,NULL,0,0,'2012-06-01','{íÒ^®nbŠÍ‰R\r9ÌæƒV×xž%†´','03ý\"r©y¹