Changeset 396 for veekun/trunk

Timestamp:

12/30/07 21:52:52 (11 months ago)

Author:

eevee

Message:

Argh, new table; need to change dump script! (#228)

Location:

veekun/trunk/script

Files:

• dump_sql.pl (modified) (1 diff)
• pokedex.sql (modified) (1 diff)

veekun/trunk/script/dump_sql.pl

@@ -13 +13 @@
     base    => [qw/ edits errorlog forums grouppermissions groups messages posts sessions shoutbox threads thread_views usergroups userpermissions users /],
     gallery => [qw/ creators gallery gallerykeywords itemkeywords /],
-    pokedex => [qw/ abilities berries contestmoves evchains flavortext items locations location_encounters machines moves move_effects pokemon pokemon_abilities pokemon_breeds pokemon_items pokemoves types /],
+    pokedex => [qw/ abilities berries contestmoves evchains flavortext items locations location_sections location_encounters machines moves move_effects pokemon pokemon_abilities pokemon_breeds pokemon_items pokemoves types /],
 );
 

veekun/trunk/script/pokedex.sql

@@ -4686 +4686 @@
 (80,0,4,'Flower Paradise','197 2 8 8');
 /*!40000 ALTER TABLE locations ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `location_sections`
+--
+
+DROP TABLE IF EXISTS location_sections;
+CREATE TABLE location_sections (
+  id int(10) unsigned NOT NULL auto_increment,
+  location_id int(10) unsigned NOT NULL,
+  `name` varchar(128) NOT NULL,
+  PRIMARY KEY  (id)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `location_sections`
+--
+
+LOCK TABLES location_sections WRITE;
+/*!40000 ALTER TABLE location_sections DISABLE KEYS */;
+INSERT INTO location_sections VALUES (1,1,'1F'),
+(2,1,'2F'),
+(3,1,'B1F a'),
+(4,1,'B1F b'),
+(5,1,'B1F c'),
+(6,1,'B2F a'),
+(7,1,'B2F b'),
+(8,1,'B2F c'),
+(9,1,'B3F a'),
+(10,1,'B3F b'),
+(11,1,'B3F c'),
+(12,1,'B3F d'),
+(13,1,'B3F e'),
+(14,1,'B4F a'),
+(15,1,'B4F b'),
+(16,1,'B4F c'),
+(17,1,'B4F d'),
+(18,1,'B5F'),
+(19,2,''),
+(20,3,''),
+(21,4,''),
+(22,5,''),
+(23,5,'entrance'),
+(24,5,'inside'),
+(25,6,''),
+(26,7,'1F'),
+(27,7,'B1F'),
+(28,7,'B2F'),
+(29,7,'B3F'),
+(30,7,'B4F'),
+(31,7,'B5F'),
+(32,8,'1F'),
+(33,8,'B1F'),
+(34,9,'1F'),
+(35,9,'B1F'),
+(36,10,'1F'),
+(37,10,'B1F'),
+(38,11,'1F'),
+(39,11,'2F'),
+(40,11,'3F'),
+(41,11,'4F'),
+(42,11,'5F'),
+(43,12,''),
+(44,13,''),
+(45,14,''),
+(46,15,''),
+(47,16,''),
+(48,17,'High-level (rooms 16-21)'),
+(49,17,'Low-level (rooms 4-9)'),
+(50,17,'Mid-level (most rooms)'),
+(51,18,''),
+(52,19,''),
+(53,20,''),
+(54,21,'Floaroma City side'),
+(55,21,'Jubilife City side'),
+(56,22,'Eterna City side'),
+(57,22,'Floaroma City side'),
+(58,23,''),
+(59,24,''),
+(60,25,''),
+(61,26,''),
+(62,27,'Celestic City side'),
+(63,27,'Solaceon City side'),
+(64,28,'Celestic City side'),
+(65,28,'Eterna City side'),
+(66,29,'Hearthome City side'),
+(67,29,'Pastoria City side'),
+(68,30,''),
+(69,31,''),
+(70,32,''),
+(71,33,''),
+(72,34,''),
+(73,35,''),
+(74,36,''),
+(75,37,''),
+(76,38,''),
+(77,39,''),
+(78,40,''),
+(79,41,''),
+(80,42,''),
+(81,43,''),
+(82,44,'Area 1'),
+(83,44,'Area 2'),
+(84,44,'Area 3'),
+(85,44,'Area 4'),
+(86,44,'Area 5'),
+(87,44,'Area 6'),
+(88,45,''),
+(89,46,''),
+(90,47,''),
+(91,48,''),
+(92,49,''),
+(93,50,'2F'),
+(94,50,'3F'),
+(95,50,'4F'),
+(96,50,'5F'),
+(97,50,'6F'),
+(98,50,'7F'),
+(99,50,'B1F'),
+(100,50,'blizzard'),
+(101,50,'cave'),
+(102,50,'Route 207'),
+(103,50,'Route 211'),
+(104,50,'Route 216'),
+(105,50,'snowfall'),
+(106,51,'1F'),
+(107,51,'2F'),
+(108,51,'B1F'),
+(109,51,'inside'),
+(110,51,'inside B1F'),
+(111,51,'inside exit'),
+(112,52,''),
+(113,53,''),
+(114,54,''),
+(115,54,'expansion'),
+(116,55,''),
+(117,55,'1F'),
+(118,55,'B1F left'),
+(119,55,'B1F right'),
+(120,55,'B2F left'),
+(121,55,'B2F right'),
+(122,55,'B3F'),
+(123,56,''),
+(124,57,'2F'),
+(125,57,'2F left room'),
+(126,57,'2F leftmost room'),
+(127,57,'2F middle room'),
+(128,57,'2F private room'),
+(129,57,'2F right room'),
+(130,57,'2F rightmost room'),
+(131,57,'dining room'),
+(132,57,'entrance'),
+(133,58,''),
+(134,59,''),
+(135,60,''),
+(136,61,''),
+(137,62,''),
+(138,63,'after'),
+(139,63,'before'),
+(140,78,'');
+/*!40000 ALTER TABLE location_sections ENABLE KEYS */;
 UNLOCK TABLES;