| 1 | DROP TABLE IF EXISTS `events`;
|
|---|
| 2 | CREATE TABLE `events` (
|
|---|
| 3 | `event_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 4 | `event_name` varchar(127) NOT NULL,
|
|---|
| 5 | `start_date` datetime NOT NULL,
|
|---|
| 6 | `end_date` datetime NOT NULL,
|
|---|
| 7 | `details` text NOT NULL,
|
|---|
| 8 | PRIMARY KEY (`event_id`)
|
|---|
| 9 | ) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;
|
|---|
| 10 |
|
|---|
| 11 | --
|
|---|
| 12 | -- Dumping data for table `events`
|
|---|
| 13 | --
|
|---|
| 14 |
|
|---|
| 15 |
|
|---|
| 16 |
|
|---|
| 17 | INSERT INTO `events` VALUES (2,'French Open','2009-05-24 00:00:00','2009-06-08 00:00:00','Philippe-Chatrier Court \nParis, FRA'),(3,'Aegon Championship','2009-06-10 00:00:00','2009-06-13 00:00:00','The Queens Club \nLondon, ENG'),(4,'Wimbledon','2009-06-21 00:00:00','2009-07-05 00:00:00','Wimbledon\nJune 21, 2009 - July 5, 2009'),(5,'Indianapolis Tennis Championships','2009-07-18 00:00:00','2009-07-27 00:00:00','Indianapolis Tennis Center \nIndianapolis, IN'),(8,'Countrywide Classic Tennis','2009-07-27 00:00:00','2009-08-02 00:00:00','Los Angeles Tennis Center. Los Angeles, CA '),(7,'ATP Master Tennis','2009-05-11 00:00:00','2009-05-18 00:00:00','La Caja Magica.\nMadrid, Spain'),(9,'Legg Mason Tennis Classic','2009-08-01 00:00:00','2009-08-11 00:00:00','Fitzgerald Tennis Center\nWashington D.C.'),(10,'Western & Southern Financial Group Women\\\'s Open','2009-08-07 00:00:00','2009-08-17 00:00:00','Lindner Family Tennis Center\nMason, OH'),(11,'Rogers Cup Women\\\'s Tennis','2009-08-15 00:00:00','2009-08-24 00:00:00','Rexall Centre\nToronto, ON'),(12,'US Open Tennis Championship','2009-08-29 00:00:00','2009-09-14 00:00:00','Arthur Ashe Stadium\nFlushing, NY'),(13,'Barclays ATP World Tour Finals','2009-11-22 00:00:00','2009-11-28 00:00:00','O2 Dome\nLondon, ENG\n'),(14,'Western & Southern Financial Group Masters Tennis','2009-08-17 00:00:00','2009-08-24 00:00:00','Lindner Family Tennis Center\nMason, OH'),(15,' Parc Izvor ','2009-05-16 15:00:00','2009-05-16 18:00:00',' Bucharest, Romania '),(16,' Arena Zagreb ','2009-05-21 14:00:00','2009-05-21 17:00:00',' Zagreb, Croatia '),(17,' Gwardia Stadium ','2009-05-23 11:00:00','2009-05-23 14:00:00',' Warsaw, Poland '),(18,' Skonto Stadium - Riga ','2009-05-25 19:00:00','2009-05-25 22:00:00',' Riga, Latvia '),(19,' Zalgirio Stadionas ','2009-05-27 15:00:00','2009-05-27 18:00:00',' Vilnius, Lithuania '),(20,' O2 Dome ','2009-05-30 17:00:00','2009-05-30 20:00:00',' London, ENG '),(21,' Evenemententerrein Megaland ','2009-05-31 16:00:00','2009-05-31 19:00:00',' Landgraaf, NL '),(22,' HSH Nordbank Arena (formerly AOL Arena) ','2009-06-02 10:00:00','2009-06-02 13:00:00',' Hamburg, GER '),(23,' LTU Arena ','2009-06-04 11:00:00','2009-06-04 14:00:00',' Dusseldorf, GER '),(24,' LTU Arena ','2009-06-05 12:00:00','2009-06-05 15:00:00',' Dusseldorf, GER '),(25,' Zentralstadion - Leipzig ','2009-06-07 20:00:00','2009-06-07 23:00:00',' Leipzig, GER '),(26,' Zentralstadion - Leipzig ','2009-06-08 17:00:00','2009-06-08 20:00:00',' Leipzig, GER '),(27,' Olympiastadion - Berlin ','2009-06-10 14:00:00','2009-06-10 17:00:00',' Berlin, GER '),(28,' Commerz Bank Arena ','2009-06-12 14:00:00','2009-06-12 17:00:00',' Frankfurt, GER '),(29,' Olympic Stadium - Munich ','2009-06-13 11:00:00','2009-06-13 14:00:00',' Munich, GER '),(30,' Stadio Olimpico ','2009-06-16 19:00:00','2009-06-16 22:00:00',' Rome, Italy '),(31,' Comunale Giuseppe Meazza - San Siro ','2009-06-18 20:00:00','2009-06-18 23:00:00',' Milan, Italy '),(32,' Inter Stadion Slovakia ','2009-06-22 19:00:00','2009-06-22 22:00:00',' Bratislava, Slovakia '),(33,' Puskas Ferenc Stadium ','2009-06-23 14:00:00','2009-06-23 17:00:00',' Budapest, Hungary '),(34,' Slavia Stadion ','2009-06-25 10:00:00','2009-06-25 13:00:00',' Prague, Czech Republic '),(35,' Stade de France - Paris ','2009-06-27 19:00:00','2009-06-27 22:00:00',' Paris, FRA '),(36,' Parken Stadium ','2009-06-30 18:00:00','2009-06-30 21:00:00',' Copenhagen, DK '),(37,' Koengen ','2009-07-02 18:00:00','2009-07-02 21:00:00',' Bergen, Norway '),(38,' Folkets Park ','2009-07-03 11:00:00','2009-07-03 14:00:00',' Malmo, SE '),(39,' Estadio Jose Zorila ','2009-07-08 18:00:00','2009-07-08 21:00:00',' Valladolid, Spain '),(40,' Bessa Stadium ','2009-07-11 10:00:00','2009-07-11 13:00:00',' Porto, Portugal '),(41,' Estadio Olimpico - Seville ','2009-07-12 14:00:00','2009-07-12 17:00:00',' Seville, Spain '),(42,' Molson Amphitheatre ','2009-07-24 16:00:00','2009-07-24 19:00:00',' Toronto, ON '),(43,' Bell Centre ','2009-07-25 18:00:00','2009-07-25 21:00:00',' Montreal, QC '),(44,' Nissan Pavilion ','2009-07-28 17:00:00','2009-07-28 20:00:00',' Bristow, VA '),(45,' Comcast Center - MA (formerly Tweeter Center) ','2009-07-31 12:00:00','2009-07-31 15:00:00',' Mansfield, MA '),(46,' Borgata Hotel Casino & Spa ','2009-08-01 15:00:00','2009-08-01 18:00:00',' Atlantic City, NJ '),(47,' Madison Square Garden ','2009-08-03 14:00:00','2009-08-03 17:00:00',' New York, NY '),(48,' Madison Square Garden ','2009-08-04 15:00:00','2009-08-04 18:00:00',' New York, NY '),(49,' Key Arena ','2009-08-10 16:00:00','2009-08-10 19:00:00',' Seattle, WA '),(50,' Shoreline Amphitheatre ','2009-08-12 11:00:00','2009-08-12 14:00:00',' Mountain View, CA '),(51,' Cricket Wireless Amphitheatre ','2009-08-14 19:00:00','2009-08-14 22:00:00',' Chula Vista, CA '),(52,' Hollywood Bowl ','2009-08-16 17:00:00','2009-08-16 20:00:00',' Los Angeles, CA '),(53,' Hollywood Bowl ','2009-08-17 13:00:00','2009-08-17 16:00:00',' Los Angeles, CA '),(54,' Honda Center ','2009-08-19 17:00:00','2009-08-19 20:00:00',' Anaheim, CA '),(55,' Santa Barbara Bowl ','2009-08-20 16:00:00','2009-08-20 19:00:00',' Santa Barbara, CA '),(56,' Palms Casino-the Pearl ','2009-08-22 10:00:00','2009-08-22 13:00:00',' Las Vegas, NV '),(57,' US Airways Center ','2009-08-23 18:00:00','2009-08-23 21:00:00',' Phoenix, AZ '),(58,' E Center ','2009-08-25 15:00:00','2009-08-25 18:00:00',' West Valley City, UT '),(59,' Red Rocks Amphitheatre ','2009-08-27 18:00:00','2009-08-27 21:00:00',' Morrison, CO '),(60,' Superpages.com Center ','2009-08-29 17:00:00','2009-08-29 20:00:00',' Dallas, TX '),(61,' Cynthia Woods Mitchell Pavilion ','2009-08-30 18:00:00','2009-08-30 21:00:00',' Houston, TX '),(62,' Lakewood Amphitheatre ','2009-09-01 15:00:00','2009-09-01 18:00:00',' Atlanta, GA '),(63,' Ford Amphitheatre at the Florida State Fairgrounds ','2009-09-04 10:00:00','2009-09-04 13:00:00',' Tampa Bay, FL '),(64,' BankAtlantic Center ','2009-09-05 13:00:00','2009-09-05 16:00:00',' Sunrise, FL '),(65,' Konig Pilsener Arena ','2009-10-31 17:00:00','2009-10-31 20:00:00',' Oberhausen, GER '),(66,' Awd Dome ','2009-11-01 13:00:00','2009-11-01 16:00:00',' Bremen, GER '),(67,' TUI Arena (formerly Preussag Arena) ','2009-11-03 14:00:00','2009-11-03 17:00:00',' Hanover, GER '),(68,' SAP Arena ','2009-11-07 13:00:00','2009-11-07 16:00:00',' Mannheim, GER '),(69,' Schleyerhalle ','2009-11-08 12:00:00','2009-11-08 15:00:00',' Stuttgart, GER '),(70,' Stade De Geneve ','2009-11-10 17:00:00','2009-11-10 20:00:00',' Geneva, CH '),(71,' Recinto Ferial - Valencia ','2009-11-12 15:00:00','2009-11-12 18:00:00',' Valencia, Spain '),(72,' Palau Sant Jordi ','2009-11-20 12:00:00','2009-11-20 15:00:00',' Barcelona, Spain '),(73,' Halle Tony Garnier ','2009-11-23 20:00:00','2009-11-23 23:00:00',' Lyon, FRA '),(74,' Arena Nurnberg ','2009-12-01 13:00:00','2009-12-01 16:00:00',' Nuremberg, GER '),(75,' Stadthalle ','2009-12-03 14:00:00','2009-12-03 17:00:00',' Vienna, Austria '),(76,' Stadthalle Graz ','2009-12-04 13:00:00','2009-12-04 16:00:00',' Graz, AT '),(77,' Hallenstadion ','2009-12-06 16:00:00','2009-12-06 19:00:00',' Zurich, CH '),(78,' Hallenstadion ','2009-12-07 10:00:00','2009-12-07 13:00:00',' Zurich, CH '),(79,' The O2 - Dublin ','2009-12-10 17:00:00','2009-12-10 20:00:00',' Dublin, IE '),(80,' Scottish Exhibition & Conference Center ','2009-12-12 14:00:00','2009-12-12 17:00:00',' Glasgow, Scotland '),(81,' LG Arena ','2009-12-13 15:00:00','2009-12-13 18:00:00',' Birmingham, ENG '),(82,' O2 Dome ','2009-12-15 13:00:00','2009-12-15 16:00:00',' London, ENG '),(83,' O2 Dome ','2009-12-16 15:00:00','2009-12-16 18:00:00',' London, ENG '),(84,' MEN Arena Manchester ','2009-12-18 16:00:00','2009-12-18 19:00:00',' Manchester, ENG ');
|
|---|
| 18 |
|
|---|
| 19 |
|
|---|
| 20 | DROP TABLE IF EXISTS `types`;
|
|---|
| 21 | CREATE TABLE IF NOT EXISTS `types` (
|
|---|
| 22 | `typeid` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 23 | `name` varchar(255) NOT NULL,
|
|---|
| 24 | PRIMARY KEY (`typeid`)
|
|---|
| 25 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
|
|---|
| 26 |
|
|---|
| 27 |
|
|---|
| 28 | INSERT INTO `types` (`typeid`, `name`) VALUES
|
|---|
| 29 | (1, 'Simple'),
|
|---|
| 30 | (2, 'Complex'),
|
|---|
| 31 | (3, 'Unknown');
|
|---|
| 32 |
|
|---|
| 33 |
|
|---|
| 34 | DROP TABLE IF EXISTS `tevents`;
|
|---|
| 35 | CREATE TABLE IF NOT EXISTS `tevents` (
|
|---|
| 36 | `event_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 37 | `event_name` varchar(127) NOT NULL,
|
|---|
| 38 | `start_date` datetime NOT NULL,
|
|---|
| 39 | `end_date` datetime NOT NULL,
|
|---|
| 40 | `type` int(11) NOT NULL,
|
|---|
| 41 | PRIMARY KEY (`event_id`)
|
|---|
| 42 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
|
|---|
| 43 |
|
|---|
| 44 |
|
|---|
| 45 | INSERT INTO `tevents` (`event_id`, `event_name`, `start_date`, `end_date`, `type`) VALUES
|
|---|
| 46 | (1, 'dblclick me!', '2010-03-02 00:00:00', '2010-03-04 00:00:00', 1),
|
|---|
| 47 | (2, 'and me!', '2010-03-09 00:00:00', '2010-03-11 00:00:00', 2),
|
|---|
| 48 | (3, 'and me too!', '2010-03-16 00:00:00', '2010-03-18 00:00:00', 3),
|
|---|
| 49 | (4, 'Type 2 event', '2010-03-02 08:00:00', '2010-03-02 14:10:00', 2);
|
|---|
| 50 |
|
|---|
| 51 |
|
|---|
| 52 |
|
|---|
| 53 |
|
|---|
| 54 |
|
|---|
| 55 | DROP TABLE IF EXISTS `events_rec`;
|
|---|
| 56 | CREATE TABLE `events_rec` (
|
|---|
| 57 | `event_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 58 | `start_date` datetime NOT NULL,
|
|---|
| 59 | `end_date` datetime NOT NULL,
|
|---|
| 60 | `text` varchar(255) NOT NULL,
|
|---|
| 61 | `rec_type` varchar(64) NOT NULL,
|
|---|
| 62 | `event_pid` int(11) NOT NULL,
|
|---|
| 63 | `event_length` int(11) NOT NULL,
|
|---|
| 64 | PRIMARY KEY (`event_id`)
|
|---|
| 65 | ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
|
|---|
| 66 |
|
|---|
| 67 | --
|
|---|
| 68 | -- Dumping data for table `events_rec`
|
|---|
| 69 | --
|
|---|
| 70 |
|
|---|
| 71 |
|
|---|
| 72 | /*!40000 ALTER TABLE `events_rec` DISABLE KEYS */;
|
|---|
| 73 | INSERT INTO `events_rec` VALUES (1,'2009-07-01 00:00:00','9999-02-01 00:00:00','Second Friday','month_1_5_2_#no',0,86400),(2,'2009-06-29 10:00:00','9999-02-01 00:00:00','Test build','week_1___1,3,5#no',0,3600),(3,'2009-07-22 10:00:00','2009-07-22 11:00:00','','none',2,1248246000),(4,'2009-07-21 00:00:00','2009-08-30 00:00:00','Each 8 days, 5 times','day_8___#5',0,172800),(5,'2009-07-16 10:00:00','2009-07-16 11:00:00','Test build','',2,1247814000),(6,'2009-06-29 10:00:00','2009-06-29 11:00:00','','none',2,1246258800),(15,'2009-07-06 00:00:00','2009-07-19 23:59:00','2 Wed','week_1___0#2',0,300),(17,'2009-07-01 00:00:00','2009-08-04 23:59:00','New event','month_1_2_2_#2',0,300),(19,'2009-07-01 00:00:00','9999-02-01 00:00:00','2nd monday','month_1_2_1_#no',0,300),(20,'2009-01-01 00:00:00','9999-02-01 00:00:00','New event','year_1_1_2_#no',0,300),(21,'2010-01-31 00:00:00','9999-02-01 00:00:00','New event','month_1___#no',0,86400);
|
|---|
| 74 |
|
|---|
| 75 |
|
|---|
| 76 |
|
|---|
| 77 | DROP TABLE IF EXISTS `events_shared`;
|
|---|
| 78 | CREATE TABLE IF NOT EXISTS `events_shared` (
|
|---|
| 79 | `event_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 80 | `start_date` datetime NOT NULL,
|
|---|
| 81 | `end_date` datetime NOT NULL,
|
|---|
| 82 | `text` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
|
|---|
| 83 | `event_type` int(11) NOT NULL DEFAULT '0',
|
|---|
| 84 | `userId` int(11) NOT NULL,
|
|---|
| 85 | PRIMARY KEY (`event_id`)
|
|---|
| 86 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
|
|---|
| 87 |
|
|---|
| 88 | --
|
|---|
| 89 | -- Dumping data for table `events_shared`
|
|---|
| 90 | --
|
|---|
| 91 |
|
|---|
| 92 | INSERT INTO `events_shared` (`event_id`, `start_date`, `end_date`, `text`, `event_type`, `userId`) VALUES
|
|---|
| 93 | (4, '2009-06-17 09:05:00', '2009-06-17 16:55:00', 'New event', 1, 1),
|
|---|
| 94 | (2, '2009-06-03 00:00:00', '2009-06-06 00:00:00', 'New event', 0, 1),
|
|---|
| 95 | (3, '2009-06-09 00:00:00', '2009-06-12 00:00:00', 'New event', 0, 1),
|
|---|
| 96 | (5, '2009-06-03 00:00:00', '2009-06-05 00:00:00', 'USer 2 event', 1, 2),
|
|---|
| 97 | (6, '2009-06-02 00:00:00', '2009-06-06 00:00:00', 'user 2', 1, 2),
|
|---|
| 98 | (7, '2009-06-03 00:00:00', '2009-06-06 00:00:00', 'New event', 1, 2),
|
|---|
| 99 | (8, '2009-06-10 00:00:00', '2009-06-12 00:00:00', '234', 0, 2),
|
|---|
| 100 | (9, '2009-06-18 21:15:00', '2009-06-18 22:55:00', 'Some event', 1, 2),
|
|---|
| 101 | (10, '2009-06-05 00:00:00', '2009-06-07 00:00:00', 'asd adf', 1, 1),
|
|---|
| 102 | (11, '2009-06-09 00:00:00', '2009-06-10 16:55:00', 'Some event', 0, 1);
|
|---|
| 103 |
|
|---|
| 104 |
|
|---|
| 105 |
|
|---|
| 106 | DROP TABLE IF EXISTS `events_tt`;
|
|---|
| 107 | CREATE TABLE `events_tt` (
|
|---|
| 108 | `event_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 109 | `event_name` varchar(127) NOT NULL,
|
|---|
| 110 | `start_date` datetime NOT NULL,
|
|---|
| 111 | `end_date` datetime NOT NULL,
|
|---|
| 112 | `details` text NOT NULL,
|
|---|
| 113 | `section_id` int(11) NOT NULL,
|
|---|
| 114 | `section2_id` int(11) NOT NULL,
|
|---|
| 115 | PRIMARY KEY (`event_id`)
|
|---|
| 116 | ) ENGINE=MyISAM AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;
|
|---|
| 117 |
|
|---|
| 118 |
|
|---|
| 119 | --
|
|---|
| 120 | -- Dumping data for table `events`
|
|---|
| 121 | --
|
|---|
| 122 |
|
|---|
| 123 |
|
|---|
| 124 |
|
|---|
| 125 | INSERT INTO `events_tt` VALUES (93,'David-David','2009-06-30 08:00:00','2009-06-30 09:00:00','',50,5),(92,'Web Testing - Linda Brown','2009-06-30 11:00:00','2009-06-30 11:30:00','',10,6),(91,'George -> George, 5 minutes','2009-06-30 13:00:00','2009-06-30 13:05:00','',70,7),(90,'Kate-Dian 30 jun - 1 september','2009-06-30 11:30:00','2009-09-01 11:30:00','',80,9),(89,'david- david 9-9.30','2009-06-30 09:00:00','2009-06-30 09:30:00','',50,5),(88,'Managers -> Kate Moss, 09 09.30','2009-06-30 09:00:00','2009-06-30 09:30:00','',30,8),(87,'2009.06.08-09 David Miller -> Eliz Taylor','2009-06-30 08:00:00','2009-06-30 09:00:00','',50,2),(86,'30-01 Linda Brown - Dian Fossey','2009-06-30 00:00:00','2009-07-01 00:00:00','',60,9),(85,'New event','2009-06-30 00:00:00','2009-07-01 00:00:00','',20,2);
|
|---|
| 126 |
|
|---|
| 127 |
|
|---|
| 128 |
|
|---|
| 129 | DROP TABLE IF EXISTS `events_map`;
|
|---|
| 130 |
|
|---|
| 131 |
|
|---|
| 132 | CREATE TABLE `events_map` (
|
|---|
| 133 | `event_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 134 | `event_name` varchar(127) NOT NULL,
|
|---|
| 135 | `start_date` datetime NOT NULL,
|
|---|
| 136 | `end_date` datetime NOT NULL,
|
|---|
| 137 | `details` text NOT NULL,
|
|---|
| 138 | `event_location` varchar(255) DEFAULT NULL,
|
|---|
| 139 | `lat` float(10,6) DEFAULT NULL,
|
|---|
| 140 | `lng` float(10,6) DEFAULT NULL,
|
|---|
| 141 | PRIMARY KEY (`event_id`)
|
|---|
| 142 | ) ENGINE=MyISAM AUTO_INCREMENT=287 DEFAULT CHARSET=latin1;
|
|---|
| 143 |
|
|---|
| 144 |
|
|---|
| 145 | --
|
|---|
| 146 | -- Dumping data for table `events`
|
|---|
| 147 | --
|
|---|
| 148 |
|
|---|
| 149 |
|
|---|
| 150 |
|
|---|
| 151 | INSERT INTO `events_map` VALUES (278,'Sudan','2011-07-22 12:10:00','2011-07-22 12:15:00','','Janub Kurdufan, Sudan',11.199019,29.417933),(285,'Ships','2010-09-01 02:40:00','2010-09-01 15:05:00','','Australia',-25.274399,133.775131),(286,'Argentina','2011-09-15 00:00:00','2011-09-15 00:05:00','','Argentina',-38.416096,-63.616673),(90,'Berlin','2011-09-16 00:00:00','2011-09-16 00:05:00','','Berlin',52.523403,13.411400),(268,'India','2012-07-22 11:35:00','2012-07-22 11:40:00','','Brazil',-14.235004,-51.925282);
|
|---|
| 152 |
|
|---|
| 153 |
|
|---|
| 154 |
|
|---|
| 155 | DROP TABLE IF EXISTS `event_fruit`;
|
|---|
| 156 |
|
|---|
| 157 |
|
|---|
| 158 | CREATE TABLE `event_fruit` (
|
|---|
| 159 | `event_fruit_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 160 | `event_id` int(11) NOT NULL,
|
|---|
| 161 | `fruit_id` int(11) NOT NULL,
|
|---|
| 162 | PRIMARY KEY (`event_fruit_id`)
|
|---|
| 163 | ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
|
|---|
| 164 |
|
|---|
| 165 |
|
|---|
| 166 | --
|
|---|
| 167 | -- Dumping data for table `event_fruit`
|
|---|
| 168 | --
|
|---|
| 169 |
|
|---|
| 170 | LOCK TABLES `event_fruit` WRITE;
|
|---|
| 171 | /*!40000 ALTER TABLE `event_fruit` DISABLE KEYS */;
|
|---|
| 172 | INSERT INTO `event_fruit` VALUES (27,107,5),(26,107,4),(25,107,1),(28,108,0);
|
|---|
| 173 | /*!40000 ALTER TABLE `event_fruit` ENABLE KEYS */;
|
|---|
| 174 | UNLOCK TABLES;
|
|---|
| 175 |
|
|---|
| 176 | --
|
|---|
| 177 | -- Table structure for table `event_user`
|
|---|
| 178 | --
|
|---|
| 179 |
|
|---|
| 180 | DROP TABLE IF EXISTS `event_user`;
|
|---|
| 181 |
|
|---|
| 182 |
|
|---|
| 183 | CREATE TABLE `event_user` (
|
|---|
| 184 | `event_user_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 185 | `event_id` int(11) NOT NULL,
|
|---|
| 186 | `user_id` int(11) NOT NULL,
|
|---|
| 187 | PRIMARY KEY (`event_user_id`)
|
|---|
| 188 | ) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1;
|
|---|
| 189 |
|
|---|
| 190 |
|
|---|
| 191 | --
|
|---|
| 192 | -- Dumping data for table `event_user`
|
|---|
| 193 | --
|
|---|
| 194 |
|
|---|
| 195 |
|
|---|
| 196 | INSERT INTO `event_user` VALUES (91,108,2),(90,107,3),(89,107,1);
|
|---|
| 197 |
|
|---|
| 198 | --
|
|---|
| 199 | -- Table structure for table `events`
|
|---|
| 200 | --
|
|---|
| 201 |
|
|---|
| 202 | DROP TABLE IF EXISTS `events_ms`;
|
|---|
| 203 | CREATE TABLE `events_ms` (
|
|---|
| 204 | `event_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 205 | `event_name` varchar(127) NOT NULL,
|
|---|
| 206 | `start_date` datetime NOT NULL,
|
|---|
| 207 | `end_date` datetime NOT NULL,
|
|---|
| 208 | `details` text NOT NULL,
|
|---|
| 209 | PRIMARY KEY (`event_id`)
|
|---|
| 210 | ) ENGINE=MyISAM AUTO_INCREMENT=109 DEFAULT CHARSET=latin1;
|
|---|
| 211 |
|
|---|
| 212 |
|
|---|
| 213 | --
|
|---|
| 214 | -- Dumping data for table `events`
|
|---|
| 215 | --
|
|---|
| 216 |
|
|---|
| 217 |
|
|---|
| 218 |
|
|---|
| 219 | INSERT INTO `events_ms` VALUES (108,'User: Nataly, Fruits: Madarin, Pineapple','2009-11-05 10:15:00','2009-11-05 13:35:00','Tokyo'),(107,'Users: George, Diana; Fruits: Orange, Kiwi, Plum','2009-11-03 14:05:00','2009-11-03 16:15:00','Belgium');
|
|---|
| 220 |
|
|---|
| 221 |
|
|---|
| 222 |
|
|---|
| 223 | --
|
|---|
| 224 | -- Table structure for table `fruit`
|
|---|
| 225 | --
|
|---|
| 226 |
|
|---|
| 227 | DROP TABLE IF EXISTS `fruit`;
|
|---|
| 228 | CREATE TABLE `fruit` (
|
|---|
| 229 | `fruit_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 230 | `fruit_name` varchar(64) NOT NULL,
|
|---|
| 231 | PRIMARY KEY (`fruit_id`)
|
|---|
| 232 | ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
|
|---|
| 233 |
|
|---|
| 234 | --
|
|---|
| 235 | -- Dumping data for table `fruit`
|
|---|
| 236 | --
|
|---|
| 237 |
|
|---|
| 238 | INSERT INTO `fruit` VALUES (1,'Orange'),(2,'Banana'),(3,'Peach'),(4,'Kiwi'),(5,'Plum'),(6,'Grapefruit'),(7,'Lime'),(8,'Lemon'),(9,'Mandarin'),(10,'Pineapple');
|
|---|
| 239 |
|
|---|
| 240 | --
|
|---|
| 241 | -- Table structure for table `user`
|
|---|
| 242 | --
|
|---|
| 243 |
|
|---|
| 244 | DROP TABLE IF EXISTS `user`;
|
|---|
| 245 |
|
|---|
| 246 | CREATE TABLE `user` (
|
|---|
| 247 | `user_id` int(11) NOT NULL AUTO_INCREMENT,
|
|---|
| 248 | `username` varchar(255) NOT NULL,
|
|---|
| 249 | PRIMARY KEY (`user_id`)
|
|---|
| 250 | ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
|
|---|
| 251 |
|
|---|
| 252 | --
|
|---|
| 253 | -- Dumping data for table `user`
|
|---|
| 254 | --
|
|---|
| 255 |
|
|---|
| 256 | /*!40000 ALTER TABLE `user` DISABLE KEYS */;
|
|---|
| 257 | INSERT INTO `user` VALUES (1,'George'),(2,'Nataly'),(3,'Diana'),(5,'Adam');
|
|---|
| 258 | /*!40000 ALTER TABLE `user` ENABLE KEYS */;
|
|---|
| 259 |
|
|---|
