ipc1vSLK

1-- MySQL dump 10.11
2--
3-- Host: mysql.lastyearsgamers.com    Database: convection_dev
4-- ------------------------------------------------------
5-- Server version	5.1.39-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `Event`
20--
21
22DROP TABLE IF EXISTS `Event`;
23SET @saved_cs_client     = @@character_set_client;
24SET character_set_client = utf8;
25CREATE TABLE `Event` (
26  `EventID` int(11) NOT NULL AUTO_INCREMENT,
27  `Name` varchar(45) NOT NULL,
28  `PreferredDayToTeach` datetime DEFAULT NULL,
29  `StartTime` datetime NOT NULL,
30  `EndTime` datetime NOT NULL,
31  `IsSpecial` bit(1) NOT NULL,
32  `IsActive` bit(1) NOT NULL,
33  `LocationID` int(11) DEFAULT NULL,
34  `Description` blob,
35  PRIMARY KEY (`EventID`),
36  UNIQUE KEY `id_UNIQUE` (`EventID`),
37  KEY `fk_event_location1` (`LocationID`),
38  CONSTRAINT `fk_event_location1` FOREIGN KEY (`LocationID`) REFERENCES `Location` (`LocationID`) ON DELETE NO ACTION ON UPDATE NO ACTION
39) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;
40SET character_set_client = @saved_cs_client;
41
42--
43-- Dumping data for table `Event`
44--
45
46LOCK TABLES `Event` WRITE;
47/*!40000 ALTER TABLE `Event` DISABLE KEYS */;
48INSERT INTO `Event` VALUES (1,'Advanced Spotter Training','2012-06-08 00:00:00','2012-06-08 18:00:00','2012-06-08 19:00:00','\0','
',3,'We\'ll start by talking about spotter-performer communication, then the duties of a spotter.  After, we\'ll have live tool extinguishing and even learn how to chase down a live, burning victim.  Bring a duvy!'),(2,'Advanced Fire Breathing','2012-06-09 00:00:00','2012-06-09 18:00:00','2012-06-09 19:00:00','\0','
',1,'Assumes breather already knows how to breathe and can sustain flames without source.  Will cover advanced flame motion, corona control, multi-person breathing, etc.'),(3,'Beginning Poi','2012-06-09 00:00:00','2012-06-09 11:00:00','2012-06-09 12:00:00','\0','
',1,'This class will cover the fundamental movements for spinning poi, helping you find and unlock the basics of movement and work out gaps in your basic understanding of poi.\r\n\r\n\r\n'),(4,'Fire Tool Care 101','2012-06-08 00:00:00','2012-06-08 17:00:00','2012-06-08 18:00:00','\0','
',1,'So much focus on the art of spinning, how about some focus time on the tools we spin?  This class is devoted to care and feeding of your fire tools.  Get a passing grade at your next regional from a Fire Official, save that favorite staff from extinction, toss those poi or give them haircut?\r\n\r\nBring your battered, your worn, your overly used tools and lets see what we can learn together!'),(5,'(Poi) Advanced Atomics/Insides','2012-06-09 00:00:00','2012-06-09 12:00:00','2012-06-09 13:30:00','\0','
',1,'This class will be all about Atomics and Inside geekery, It will be fast paced as I will be trying to cover alot of ideas and concepts in a short amount of time. This will be an advanced class, but all skill levels are encouraged!'),(6,'Intermediate/Advanced Rope Dart: Compound Wra','2012-06-08 00:00:00','2012-06-08 16:30:00','2012-06-08 18:00:00','\0','
',2,'We will go over many different wraps from basic to advanced. We will go over some theory and overall basics of enhancing that never-ending knot you\'re twisting yourself up in.'),(7,'Staff Juggling','2012-06-09 00:00:00','2012-06-09 13:30:00','2012-06-09 15:00:00','\0','
',1,'Learn the basics of staff juggling starting with basic tosses and escalating to 3 staffs. Must have your own staffs. '),(8,'Partner Poi Dance Improvisation','2012-06-09 00:00:00','2012-06-09 11:00:00','2012-06-09 12:30:00','\0','
',2,'To dance with a partner is to listen intently to them. Listen to their patterns, their habits, their comforts, and curiosities. By practicing moving with and around our partners we become aware of a subtle exchange of cues, such as shifts in weight and momentum that tell us what our partner can do in the next moments. Becoming aware of these nuances allows for spontaneous and harmonious movement. '),(9,'Staff off the Feet','2012-06-08 00:00:00','2012-06-08 16:30:00','2012-06-08 18:00:00','\0','
',3,'A staff already a lot of momentum all on it\'s own. By using that inherent inertial movement we can let the staff propel us to cover more space and larger distances in our dance. Through applying principles of levels, speed, and momentum this class will guide students off their feet and on to their hands, rolling on the ground, and leaping into the air. This class is appropriate for people of any or no experience with staff and dance. Some specific movements that we will work with are rolls, cartwheels, and various ways of leaping. '),(10,'Single and Double Staff Tosses','2012-06-09 00:00:00','2012-06-09 11:00:00','2012-06-09 12:30:00','\0','
',3,'This class will explore tosses / throws obtained from the samoan knife, baton twirling, and martial art traditions. All single staff tosses will have a double staff equivalent. This class will cover beginningtosses as well as the more advanced variations, so it is open to all levels.'),(11,'Speaking in Drums','2012-06-09 00:00:00','2012-06-09 17:00:00','2012-06-09 18:30:00','\0','
',3,'Speaking in Drums is designed for any age or skill level of drumming, even if you\'ve never touched a drum before. It\'s meant to bring comfort and clarity to the act of drumming, instead of wondering if you can or what to do with a drum. The objective is to create a connection with breath, soul, mind and language. Participants will learn to utilize the drum as another tool for speaking. Cultivating other means of communication and expression that every person can access and experience, using a simple West African harvest rhythm to align with ancient and natural processes in which we intentionally gather and communicate shared rhythms, melodies and cycles using drums. Speaking in Drums is a beginning to only one end, right now, to be aware and engaged in the present. Speaking and seeking to communicate through an instrument can be very powerful when it\'s done with clear intention. And while this workshop promotes speaking with words, thoughts and feelings, it\'s true purpose is to help us be in the space where there is a direct connection with our actions, what is in our vision and what is in our hearts.'),(12,'Beginner Fleshing and Fire Eating','2012-06-09 00:00:00','2012-06-09 18:00:00','2012-06-09 19:00:00','\0','
',2,'HUNGRY? This class will teach you how to safely Eat Fire!\r\n\r\nCOLD? Come learn how to safely trail fire all over you by Fleshing! '),(13,'Fire Safety: Clothing','2012-06-09 00:00:00','2012-06-09 12:30:00','2012-06-09 14:00:00','\0','
',2,'With all of the poly-blend clothes in the market today which ones are fire safe? This class entails what types of clothes are fire safe, and how to test clothing or fabric for it\'s fire resistance.'),(14,'Dancing with Hoops','2012-06-08 00:00:00','2012-06-08 16:00:00','2012-06-08 17:00:00','\0','
',1,'This workshop is designed to give a person who is familiar with at least the basics of hooping, techniques for improving the fluidity, presentation and rhythm of their dance. Understanding that all hoop movement stems from body movement, we warm up our bodies without hoops, getting ourselves ready to dance with comfort and confidence.  While hooping we work on taking the focus away from \'tricks\' to concentrate more on the body\'s motion that is unrelated to the hoop\'s movement. We will also work closely with different types of music to improve our rhythm.'),(15,'Dancing with Poi','2012-06-09 00:00:00','2012-06-09 15:00:00','2012-06-09 16:00:00','\0','
',1,'This workshop is designed to give a person who is familiar with at least the basics of poi movement, techniques for improving the fluidity, presentation and rhythm of their dance. Understanding that all poi movement stems from body movement, we warm up our bodies without poi, getting ourselves ready to dance with comfort and confidence.  While spinning we work on taking the focus away from \'tricks\' to concentrate more on the body\'s motion that is, at first glance, unrelated to the poi movement such as the legs or head.\r\n\r\nWe will also work closely with different types of music to improve our rhythm. We will cover techniques of matching the beat of the poi to the rhythm of the music. Play with matching the music in tempo and mood to improve performance presence.\r\n\r\nA considerable amount of the workshop will be dedicated to how to add variation in their dance to make it more dynamic. We work with opposite motions, like fast and slow, high and low, big and small, long and short.\r\n\r\nOne of the essential concepts of this workshop is that \'less is more\'. A performer with a few really graceful and elegant moves will be more attractive than another with many messy moves. We choose one trick that we feel familiar with, and play only with it and variations of it. We do this not only to clean up the movement, but to force us to get creative and develop our own variations.\r\n\r\nAll of these exercises are designed to give a spinner techniques they can use in the future for developing their own dance, performance and expression through poi.'),(16,'Beginners Staff','2012-06-09 00:00:00','2012-06-09 14:00:00','2012-06-09 15:00:00','\0','
',2,'Teaching the basics for learning to spin the staff I will try to bring any extras I have, but you should bring yours theres nothing like getting to know your staff.'),(17,'Acrobatics with Staff','2012-06-08 00:00:00','2012-06-08 15:00:00','2012-06-08 16:00:00','\0','
',1,'Creating a whole new way to take you and your staff to the next level, I will provide you with the secrets to successfully do a cartwheel with your staff and other manipulation moves. Basics in gymnastics will help but not required. '),(18,'Convection Opens',NULL,'2012-06-08 12:00:00','2012-06-08 12:00:00','
','\0',NULL,NULL),(19,'Sunset',NULL,'2012-06-08 19:42:00','2012-06-08 19:42:00','
','\0',NULL,NULL),(20,'Sunrise',NULL,'2012-06-09 08:05:00','2012-06-09 08:05:00','
','\0',NULL,NULL),(21,'Sunset',NULL,'2012-06-09 19:42:00','2012-06-09 19:42:00','
','\0',NULL,NULL),(22,'Sunrise',NULL,'2012-06-10 08:05:00','2012-06-10 08:05:00','
','\0',NULL,NULL),(23,'Convection Closes',NULL,'2012-06-10 12:00:00','2012-06-10 12:00:00','
','\0',NULL,NULL),(24,'Test Class','2012-06-08 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','\0','\0',NULL,'Test Test'),(25,'Advanced Butt-tuttuing','2012-06-09 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','\0','\0',NULL,'Just testing the whole system, not a real class.'),(26,'Site cleanup','2012-06-10 00:00:00','2012-06-10 11:30:00','2012-06-10 12:00:00','\0','\0',1,'We\'d like everyone present to help us clean up the site.'),(27,'Free Spin with Amplified Sound','2012-06-08 00:00:00','2012-06-08 19:00:00','2012-06-09 02:00:00','\0','
',2,'Fire spin jam with DJs and Amplified Sound'),(28,'Free spin with Amplified Sound','2012-06-09 00:00:00','2012-06-09 19:00:00','2012-06-10 02:00:00','\0','
',2,'Fire spin jam with DJs and Amplified Sound'),(29,'Fire spin unplugged','2012-06-08 00:00:00','2012-06-10 02:00:00','2012-06-10 06:00:00','\0','
',2,'No Amplified Sound'),(30,'Fire spin unplugged','2012-06-09 00:00:00','2012-06-09 02:00:00','2012-06-09 06:00:00','\0','
',2,'No Amplified Sound'),(31,'Site cleanup','2012-06-10 00:00:00','2012-06-10 11:00:00','2012-06-10 12:00:00','\0','
',2,'Please enter a description for your class'),(32,'Site cleanup','2012-06-10 00:00:00','2012-06-10 11:00:00','2012-06-10 12:00:00','\0','
',3,''),(33,'Site cleanup','2012-06-10 00:00:00','2012-06-10 11:00:00','2012-06-10 12:00:00','\0','
',1,'Please enter a description for your class'),(34,'How To Make Your Practice More Awesome','2012-06-09 00:00:00','2012-06-09 12:30:00','2012-06-09 14:00:00','\0','
',3,'Teafaerie talks about how you can improve your flow practice and apply its lessons to awesome up your daily life.');
49/*!40000 ALTER TABLE `Event` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `Hosting`
54--
55
56DROP TABLE IF EXISTS `Hosting`;
57SET @saved_cs_client     = @@character_set_client;
58SET character_set_client = utf8;
59CREATE TABLE `Hosting` (
60  `HostingID` int(11) NOT NULL AUTO_INCREMENT,
61  `EventID` int(11) NOT NULL,
62  `UserID` int(11) NOT NULL,
63  PRIMARY KEY (`HostingID`),
64  UNIQUE KEY `id_UNIQUE` (`HostingID`),
65  UNIQUE KEY `event_id_UNIQUE` (`EventID`),
66  KEY `fk_hosting_event` (`EventID`),
67  KEY `fk_hosting_user` (`UserID`),
68  CONSTRAINT `fk_hosting_event` FOREIGN KEY (`EventID`) REFERENCES `Event` (`EventID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
69  CONSTRAINT `fk_hosting_user` FOREIGN KEY (`UserID`) REFERENCES `User` (`UserID`) ON DELETE NO ACTION ON UPDATE NO ACTION
70) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
71SET character_set_client = @saved_cs_client;
72
73--
74-- Dumping data for table `Hosting`
75--
76
77LOCK TABLES `Hosting` WRITE;
78/*!40000 ALTER TABLE `Hosting` DISABLE KEYS */;
79INSERT INTO `Hosting` VALUES (1,1,2),(2,2,2),(3,3,3),(4,4,3),(5,5,4),(6,6,5),(7,7,5),(8,8,6),(9,9,6),(10,10,7),(11,11,8),(12,12,9),(13,13,10),(14,14,11),(15,15,11),(16,16,12),(17,17,12),(18,24,13),(19,25,15),(20,26,2),(21,27,16),(22,28,16),(23,29,16),(24,30,16),(25,31,16),(26,32,16),(27,33,16),(28,34,18);
80/*!40000 ALTER TABLE `Hosting` ENABLE KEYS */;
81UNLOCK TABLES;
82
83--
84-- Table structure for table `Location`
85--
86
87DROP TABLE IF EXISTS `Location`;
88SET @saved_cs_client     = @@character_set_client;
89SET character_set_client = utf8;
90CREATE TABLE `Location` (
91  `LocationID` int(11) NOT NULL AUTO_INCREMENT,
92  `Name` varchar(45) NOT NULL,
93  `Description` blob NOT NULL,
94  PRIMARY KEY (`LocationID`),
95  UNIQUE KEY `id_UNIQUE` (`LocationID`)
96) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
97SET character_set_client = @saved_cs_client;
98
99--
100-- Dumping data for table `Location`
101--
102
103LOCK TABLES `Location` WRITE;
104/*!40000 ALTER TABLE `Location` DISABLE KEYS */;
105INSERT INTO `Location` VALUES (1,'Kitchen','A place to eat, drink and be merry.'),(2,'The Pit','Noxious fumes and rebar traps! The PIT is the most metal location ever!!'),(3,'The Stage','DJs, announcements, and general awesomeness.'),(4,'Campgrounds','Tents, showers, etc.');
106/*!40000 ALTER TABLE `Location` ENABLE KEYS */;
107UNLOCK TABLES;
108
109--
110-- Table structure for table `User`
111--
112
113DROP TABLE IF EXISTS `User`;
114SET @saved_cs_client     = @@character_set_client;
115SET character_set_client = utf8;
116CREATE TABLE `User` (
117  `UserID` int(11) NOT NULL AUTO_INCREMENT,
118  `Name` varchar(45) NOT NULL,
119  `Email` varchar(45) NOT NULL,
120  `Password` varchar(45) NOT NULL,
121  `Phone` varchar(45) NOT NULL,
122  `ArrivalTime` datetime DEFAULT NULL,
123  `DepartureTime` datetime DEFAULT NULL,
124  `Bio` blob,
125  `ReceiveNewsletter` bit(1) NOT NULL DEFAULT b'0',
126  `IsAdmin` bit(1) NOT NULL DEFAULT b'0',
127  `ReferralCode` varchar(45) DEFAULT NULL,
128  PRIMARY KEY (`UserID`),
129  UNIQUE KEY `id_UNIQUE` (`UserID`),
130  UNIQUE KEY `Email_UNIQUE` (`Email`)
131) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
132SET character_set_client = @saved_cs_client;
133
134--
135-- Dumping data for table `User`
136--
137
138LOCK TABLES `User` WRITE;
139/*!40000 ALTER TABLE `User` DISABLE KEYS */;
140INSERT INTO `User` VALUES (1,'Scott McCoy','scotthmccoy@gmail.com','password','805-231-5549','2012-06-08 12:00:00','2012-06-10 12:00:00','Scott is pretty much the coolest guy ever.','
','
',NULL),(2,'Tedward','ted@nafaa.org','noodle','310-621-6423','2012-06-08 12:00:00','2012-06-10 12:00:00','Guinness Fire breather, NAFAA organizer, Bearclaw toolmaker, and ladies... he\'s still single!\r\n','
','
',''),(3,'Sean Driskel','celebrin@gmail.com','nothing1','714-612-4932','2012-06-08 12:00:00','2012-06-10 12:00:00','NAFAA Council person, Co-Host, and general ADOS Cat In a Hat.','
','
',''),(4,'Erich Dibisch','Auzureis@gmail.com','password','714-944-5577','2012-06-08 12:00:00','2012-06-10 12:00:00','','
','\0','erich'),(5,'Brendon Hebert','bhebertfire@gmail.com','password','480-430-4303','2012-06-08 12:00:00','2012-06-10 12:00:00','','
','\0','Brendon'),(6,'dyami','dyami@afirebrush.com','password','831-227-5396','2012-06-08 12:00:00','2012-06-10 12:00:00','','
','\0','Dyami'),(7,'Tricia Moore','trishnamurti@gmail.com','password','480-233-6706','2012-06-08 12:00:00','2012-06-10 12:00:00','','
','\0','Tricia'),(8,'Matthew Downey','shaduki@gmail.com','password','716-907-1698','2012-06-08 12:00:00','2012-06-10 12:00:00','','
','\0','drums'),(9,'Aviva Yehezkel','Ayehezkel@yahoo.com','password','661-733-7565','2012-06-08 12:00:00','2012-06-10 12:00:00','','
','\0','Aviva'),(10,'Sara Parra','saragparra@gmail.com','password','305-609-8339','2012-06-08 12:00:00','2012-06-10 12:00:00','','
','\0','Sara'),(11,'wryly','wryly@afirebrush.com','password','650-279-3631','2012-06-08 12:00:00','2012-06-10 12:00:00','','
','\0','wryly'),(12,'Tyler Walstrom','Firelinksart@hotmail.com','password','310-918-9890','2012-06-08 12:00:00','2012-06-10 12:00:00','','
','\0','Tyler'),(13,'Bradley','oiadict@msn.com','free2b','','2012-06-08 12:00:00','2012-06-10 12:00:00','Bradley is a god of fire','
','
',NULL),(14,'Zaphod Beeblebrox','zaphod@gmail.com','password','805-231-5549','2012-06-08 12:00:00','2012-06-08 12:00:00','','\0','\0',NULL),(15,'Just testin','test@bearclawfire.com','pass','321-555-1211','2012-06-08 17:00:00','2012-06-08 12:00:00','Blah bla blah blah bla blahdy blah blah','\0','\0','just'),(16,'Convection Crew','info@convectionflow.com','noodle','310-621-6423','2012-06-08 12:00:00','2012-06-10 12:00:00','','\0','\0',NULL),(17,'Jesse Grimes','jessedgrimes@hotmail.com','1beaniford.','949-291-1898','2012-06-08 17:00:00','2012-06-10 12:00:00','','\0','\0',NULL),(18,'Teafaerie','Ruespieler@gmail.com','excelsior','310-804-1494','2012-06-08 12:00:00','2012-06-10 12:00:00','','\0','\0','Teafaerie');
141/*!40000 ALTER TABLE `User` ENABLE KEYS */;
142UNLOCK TABLES;
143/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
144
145/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
146/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
147/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
148/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
149/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
150/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
151/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
152
153-- Dump completed on 2012-05-07 22:44:45