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 |
|
---|