API tools faq
paste
Guest User

Untitled

a guest
Oct 22nd, 2016
97
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 23.44 KB | None | 0 0
raw download clone embed print report
  1. -- Adminer 4.2.3 MySQL dump
  2.  
  3. SET NAMES utf8;
  4. SET time_zone = '+00:00';
  5. SET foreign_key_checks = 0;
  6. SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  7.  
  8. DROP DATABASE IF EXISTS `tcgcollector`;
  9. CREATE DATABASE `tcgcollector` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
  10. USE `tcgcollector`;
  11.  
  12. DROP TABLE IF EXISTS `expansion`;
  13. CREATE TABLE `expansion` (
  14.   `id` int(11) NOT NULL AUTO_INCREMENT,
  15.   `name` varchar(100) COLLATE utf8_bin NOT NULL,
  16.   `expansion_series_id` int(11) NOT NULL,
  17.   `card_number` varchar(5) COLLATE utf8_bin DEFAULT NULL,
  18.   `card_count` int(11) NOT NULL,
  19.   `logo_file_path` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  20.   `symbol_file_path` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  21.   `release_period_begin` datetime NOT NULL,
  22.   `release_period_end` datetime DEFAULT NULL,
  23.   PRIMARY KEY (`id`),
  24.   UNIQUE KEY `expansion_UNIQUE` (`name`,`symbol_file_path`),
  25.   KEY `fk_expansion_expansion_series1_idx` (`expansion_series_id`),
  26.   CONSTRAINT `fk_expansion_expansion_series1` FOREIGN KEY (`expansion_series_id`) REFERENCES `expansion_series` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  27. ) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  28.  
  29. INSERT INTO `expansion` (`id`, `name`, `expansion_series_id`, `card_number`, `card_count`, `logo_file_path`, `symbol_file_path`, `release_period_begin`, `release_period_end`) VALUES
  30. (1, 'Base Set', 1,  '102',  102,    NULL,   NULL,   '1999-01-09 00:00:00',  '1999-01-09 00:00:00'),
  31. (2, 'Jungle',   1,  '64',   64, 'img/expansions/en/logos/jungle.png',   'img/expansions/en/symbols/jungle.png', '1999-06-16 00:00:00',  '1999-06-16 00:00:00'),
  32. (3, 'Fossil',   1,  '62',   62, 'img/expansions/en/logos/fossil.png',   'img/expansions/en/symbols/fossil.png', '1999-10-10 00:00:00',  '1999-10-10 00:00:00'),
  33. (4, 'Base Set 2',   1,  '130',  130,    'img/expansions/en/logos/base-set-2.png',   'img/expansions/en/symbols/base-set-2.png', '2000-02-24 00:00:00',  '2000-02-24 00:00:00'),
  34. (5, 'Team Rocket',  1,  '82',   83, 'img/expansions/en/logos/team-rocket.png',  'img/expansions/en/symbols/team-rocket.png',    '2000-04-24 00:00:00',  '2000-04-24 00:00:00'),
  35. (6, 'Gym Heroes',   1,  '132',  132,    'img/expansions/en/logos/gym-heroes.png',   'img/expansions/en/symbols/gym-heroes.png', '2000-08-14 00:00:00',  '2000-08-14 00:00:00'),
  36. (7, 'Gym Challenge',    1,  '132',  132,    'img/expansions/en/logos/gym-challenge.png',    'img/expansions/en/symbols/gym-challenge.png',  '2000-10-16 00:00:00',  '2000-10-16 00:00:00'),
  37. (8, 'Neo Genesis',  2,  '111',  111,    'img/expansions/en/logos/neo-genesis.png',  'img/expansions/en/symbols/neo-genesis.png',    '2000-12-16 00:00:00',  '2000-12-16 00:00:00'),
  38. (9, 'Neo Discovery',    2,  '75',   75, 'img/expansions/en/logos/neo-discovery.png',    'img/expansions/en/symbols/neo-discovery.png',  '2001-06-01 00:00:00',  '2001-06-01 00:00:00'),
  39. (10,    'Neo Revelation',   2,  '64',   66, 'img/expansions/en/logos/neo-revelation.png',   'img/expansions/en/symbols/neo-revelation.png', '2001-09-21 00:00:00',  '2001-09-21 00:00:00'),
  40. (11,    'Neo Destiny',  2,  '105',  113,    'img/expansions/en/logos/neo-destiny.png',  'img/expansions/en/symbols/neo-destiny.png',    '2002-02-28 00:00:00',  '2002-02-28 00:00:00'),
  41. (12,    'Legendary Collection', 3,  '110',  110,    'img/expansions/en/logos/legendary-collection.png', 'img/expansions/en/symbols/legendary-collection.png',   '2002-05-24 00:00:00',  '2002-05-24 00:00:00'),
  42. (13,    'Expedition Base Set',  4,  '165',  165,    'img/expansions/en/logos/expedition-base-set.png',  'img/expansions/en/symbols/expedition-base-set.png',    '2002-09-15 00:00:00',  '2002-09-15 00:00:00'),
  43. (14,    'Aquapolis',    4,  '147',  186,    'img/expansions/en/logos/aquapolis.png',    'img/expansions/en/symbols/aquapolis.png',  '2003-01-15 00:00:00',  '2003-01-15 00:00:00'),
  44. (15,    'Skyridge', 4,  '144',  182,    'img/expansions/en/logos/skyridge.png', 'img/expansions/en/symbols/skyridge.png',   '2003-05-12 00:00:00',  '2003-05-12 00:00:00'),
  45. (16,    'EX Ruby & Sapphire',   5,  '109',  109,    'img/expansions/en/logos/ex-ruby-and-sapphire.png', 'img/expansions/en/symbols/ex-ruby-and-sapphire.png',   '2003-06-18 00:00:00',  '2003-06-18 00:00:00'),
  46. (17,    'EX Sandstorm', 5,  '100',  100,    'img/expansions/en/logos/ex-sandstorm.png', 'img/expansions/en/symbols/ex-sandstorm.png',   '2003-09-17 00:00:00',  '2003-09-17 00:00:00'),
  47. (18,    'EX Dragon',    5,  '97',   100,    'img/expansions/en/logos/ex-dragon.png',    'img/expansions/en/symbols/ex-dragon.png',  '2003-11-24 00:00:00',  '2003-11-24 00:00:00'),
  48. (19,    'EX Team Magma vs Team Aqua',   5,  '95',   97, 'img/expansions/en/logos/ex-team-magma-vs-team-aqua.png',   'img/expansions/en/symbols/ex-team-magma-vs-team-aqua.png', '2004-03-15 00:00:00',  '2004-03-15 00:00:00'),
  49. (20,    'EX Hidden Legends',    5,  '101',  102,    'img/expansions/en/logos/ex-hidden-legends.png',    'img/expansions/en/symbols/ex-hidden-legends.png',  '2004-06-14 00:00:00',  '2004-06-14 00:00:00'),
  50. (21,    'EX FireRed & LeafGreen',   5,  '112',  116,    'img/expansions/en/logos/ex-firered-and-leafgreen.png', 'img/expansions/en/symbols/ex-firered-and-leafgreen.png',   '2004-08-30 00:00:00',  '2004-08-30 00:00:00'),
  51. (22,    'EX Team Rocket Returns',   5,  '109',  111,    'img/expansions/en/logos/ex-team-rocket-returns.png',   'img/expansions/en/symbols/ex-team-rocket-returns.png', '2004-11-08 00:00:00',  '2004-11-08 00:00:00'),
  52. (23,    'EX Deoxys',    5,  '107',  108,    'img/expansions/en/logos/ex-deoxys.png',    'img/expansions/en/symbols/ex-deoxys.png',  '2005-02-14 00:00:00',  '2005-02-14 00:00:00'),
  53. (24,    'EX Emerald',   5,  '106',  107,    'img/expansions/en/logos/ex-emerald.png',   'img/expansions/en/symbols/ex-emerald.png', '2005-05-09 00:00:00',  '2005-05-09 00:00:00'),
  54. (25,    'EX Unseen Forces', 5,  '115',  145,    'img/expansions/en/logos/ex-unseen-forces.png', 'img/expansions/en/symbols/ex-unseen-forces.png',   '2005-08-22 00:00:00',  '2005-08-22 00:00:00'),
  55. (26,    'EX Delta Species', 5,  '113',  114,    'img/expansions/en/logos/ex-delta-species.png', 'img/expansions/en/symbols/ex-delta-species.png',   '2005-10-31 00:00:00',  '2005-10-31 00:00:00'),
  56. (27,    'EX Legend Maker',  5,  '92',   93, 'img/expansions/en/logos/ex-legend-maker.png',  'img/expansions/en/symbols/ex-legend-maker.png',    '2006-02-13 00:00:00',  '2006-02-13 00:00:00'),
  57. (28,    'EX Holon Phantoms',    5,  '110',  111,    'img/expansions/en/logos/ex-holon-phantoms.png',    'img/expansions/en/symbols/ex-holon-phantoms.png',  '2006-05-03 00:00:00',  '2006-05-03 00:00:00'),
  58. (29,    'EX Crystal Guardians', 5,  '100',  100,    'img/expansions/en/logos/ex-crystal-guardians.png', 'img/expansions/en/symbols/ex-crystal-guardians.png',   '2006-08-30 00:00:00',  '2006-08-30 00:00:00'),
  59. (30,    'EX Dragon Frontiers',  5,  '101',  101,    'img/expansions/en/logos/ex-dragon-frontiers.png',  'img/expansions/en/symbols/ex-dragon-frontiers.png',    '2006-11-08 00:00:00',  '2006-11-08 00:00:00'),
  60. (31,    'EX Power Keepers', 5,  '108',  108,    'img/expansions/en/logos/ex-power-keepers.png', 'img/expansions/en/symbols/ex-power-keepers.png',   '2007-02-14 00:00:00',  '2007-02-14 00:00:00'),
  61. (32,    'Diamond & Pearl',  6,  '130',  130,    'img/expansions/en/logos/diamond-and-pearl.png',    'img/expansions/en/symbols/diamond-and-pearl.png',  '2007-05-23 00:00:00',  '2007-05-23 00:00:00'),
  62. (33,    'Mysterious Treasures', 6,  '123',  124,    'img/expansions/en/logos/mysterious-treasures.png', 'img/expansions/en/symbols/mysterious-treasures.png',   '2007-08-22 00:00:00',  '2007-08-22 00:00:00'),
  63. (34,    'Secret Wonders',   6,  '132',  132,    'img/expansions/en/logos/secret-wonders.png',   'img/expansions/en/symbols/secret-wonders.png', '2007-11-07 00:00:00',  '2007-11-07 00:00:00'),
  64. (35,    'Great Encounters', 6,  '106',  106,    'img/expansions/en/logos/great-encounters.png', 'img/expansions/en/symbols/great-encounters.png',   '2008-02-13 00:00:00',  '2008-02-13 00:00:00'),
  65. (36,    'Majestic Dawn',    6,  '100',  100,    'img/expansions/en/logos/majestic-dawn.png',    'img/expansions/en/symbols/majestic-dawn.png',  '2008-05-21 00:00:00',  '2008-05-21 00:00:00'),
  66. (37,    'Legends Awakened', 6,  '146',  146,    'img/expansions/en/logos/legends-awakened.png', 'img/expansions/en/symbols/legends-awakened.png',   '2008-08-20 00:00:00',  '2008-08-20 00:00:00'),
  67. (38,    'Stormfront',   6,  '100',  106,    'img/expansions/en/logos/stormfront.png',   'img/expansions/en/symbols/stormfront.png', '2008-11-05 00:00:00',  '2008-11-05 00:00:00'),
  68. (39,    'Platinum', 7,  '127',  133,    'img/expansions/en/logos/platinum.png', 'img/expansions/en/symbols/platinum.png',   '2009-02-11 00:00:00',  '2009-02-11 00:00:00'),
  69. (40,    'Rising Rivals',    7,  '111',  120,    'img/expansions/en/logos/rising-rivals.png',    'img/expansions/en/symbols/rising-rivals.png',  '2009-05-20 00:00:00',  '2009-05-20 00:00:00'),
  70. (41,    'Supreme Victors',  7,  '147',  153,    'img/expansions/en/logos/supreme-victors.png',  'img/expansions/en/symbols/supreme-victors.png',    '2009-08-19 00:00:00',  '2009-08-19 00:00:00'),
  71. (42,    'Arceus',   7,  '99',   111,    'img/expansions/en/logos/arceus.png',   'img/expansions/en/symbols/arceus.png', '2009-11-04 00:00:00',  '2009-11-04 00:00:00'),
  72. (43,    'HeartGold & SoulSilver',   8,  '123',  124,    'img/expansions/en/logos/heartgold-and-soulsilver.png', 'img/expansions/en/symbols/heartgold-and-soulsilver.png',   '2010-02-10 00:00:00',  '2010-02-10 00:00:00'),
  73. (44,    'Unleashed',    8,  '95',   96, 'img/expansions/en/logos/unleashed.png',    'img/expansions/en/symbols/unleashed.png',  '2010-05-12 00:00:00',  '2010-05-12 00:00:00'),
  74. (45,    'Undaunted',    8,  '90',   91, 'img/expansions/en/logos/undaunted.png',    'img/expansions/en/symbols/undaunted.png',  '2010-08-18 00:00:00',  '2010-08-18 00:00:00'),
  75. (46,    'Triumphant',   8,  '102',  103,    'img/expansions/en/logos/triumphant.png',   'img/expansions/en/symbols/triumphant.png', '2010-11-02 00:00:00',  '2010-11-02 00:00:00'),
  76. (47,    'Call of Legends',  9,  '106',  106,    'img/expansions/en/logos/call-of-legends.png',  'img/expansions/en/symbols/call-of-legends.png',    '2011-02-09 00:00:00',  '2011-02-09 00:00:00'),
  77. (48,    'Black & White',    10, '114',  115,    'img/expansions/en/logos/black-and-white.png',  'img/expansions/en/symbols/black-and-white.png',    '2011-04-25 00:00:00',  '2011-04-25 00:00:00'),
  78. (49,    'Emerging Powers',  10, '98',   98, 'img/expansions/en/logos/emerging-powers.png',  'img/expansions/en/symbols/emerging-powers.png',    '2011-08-31 00:00:00',  '2011-08-31 00:00:00'),
  79. (50,    'Noble Victories',  10, '101',  102,    'img/expansions/en/logos/noble-victories.png',  'img/expansions/en/symbols/noble-victories.png',    '2011-11-16 00:00:00',  '2011-11-16 00:00:00'),
  80. (51,    'Next Destinies',   10, '99',   103,    'img/expansions/en/logos/next-destinies.png',   'img/expansions/en/symbols/next-destinies.png', '2012-02-08 00:00:00',  '2012-02-08 00:00:00'),
  81. (52,    'Dark Explorers',   10, '108',  111,    'img/expansions/en/logos/dark-explorers.png',   'img/expansions/en/symbols/dark-explorers.png', '2012-05-09 00:00:00',  '2012-05-09 00:00:00'),
  82. (53,    'Dragons Exalted',  10, '124',  128,    'img/expansions/en/logos/dragons-exalted.png',  'img/expansions/en/symbols/dragons-exalted.png',    '2012-08-15 00:00:00',  '2012-08-15 00:00:00'),
  83. (54,    'Boundaries Crossed',   10, '149',  153,    'img/expansions/en/logos/boundaries-crossed.png',   'img/expansions/en/symbols/boundaries-crossed.png', '2012-11-07 00:00:00',  '2012-11-07 00:00:00'),
  84. (55,    'Plasma Storm', 10, '135',  138,    'img/expansions/en/logos/plasma-storm.png', 'img/expansions/en/symbols/plasma-storm.png',   '2013-02-06 00:00:00',  '2013-02-06 00:00:00'),
  85. (56,    'Plasma Freeze',    10, '116',  122,    'img/expansions/en/logos/plasma-freeze.png',    'img/expansions/en/symbols/plasma-freeze.png',  '2013-05-08 00:00:00',  '2013-05-08 00:00:00'),
  86. (57,    'Plasma Blast', 10, '101',  105,    'img/expansions/en/logos/plasma-blast.png', 'img/expansions/en/symbols/plasma-blast.png',   '2013-08-14 00:00:00',  '2013-08-14 00:00:00'),
  87. (58,    'Legendary Treasures',  10, '113',  140,    'img/expansions/en/logos/legendary-treasures.png',  'img/expansions/en/symbols/legendary-treasures.png',    '2013-11-08 00:00:00',  '2013-11-08 00:00:00'),
  88. (59,    'XY',   11, '146',  146,    'img/expansions/en/logos/xy.png',   'img/expansions/en/symbols/xy.png', '2014-02-05 00:00:00',  '2014-02-05 00:00:00'),
  89. (60,    'Flashfire',    11, '106',  109,    'img/expansions/en/logos/flashfire.png',    'img/expansions/en/symbols/flashfire.png',  '2014-05-07 00:00:00',  '2014-05-07 00:00:00'),
  90. (61,    'Furious Fists',    11, '111',  113,    'img/expansions/en/logos/furious-fists.png',    'img/expansions/en/symbols/furious-fists.png',  '2014-08-13 00:00:00',  '2014-08-13 00:00:00'),
  91. (62,    'Phantom Forces',   11, '119',  122,    'img/expansions/en/logos/phantom-forces.png',   'img/expansions/en/symbols/phantom-forces.png', '2014-11-05 00:00:00',  '2014-11-05 00:00:00'),
  92. (63,    'Primal Clash', 11, '160',  164,    'img/expansions/en/logos/primal-clash.png', 'img/expansions/en/symbols/primal-clash.png',   '2015-02-04 00:00:00',  '2015-02-04 00:00:00'),
  93. (64,    'Double Crisis',    11, '34',   34, 'img/expansions/en/logos/double-crisis.png',    'img/expansions/en/symbols/double-crisis.png',  '2015-03-25 00:00:00',  '2015-03-25 00:00:00'),
  94. (65,    'Roaring Skies',    11, '108',  110,    'img/expansions/en/logos/roaring-skies.png',    'img/expansions/en/symbols/roaring-skies.png',  '2015-05-06 00:00:00',  '2015-05-06 00:00:00'),
  95. (66,    'Ancient Origins',  11, '98',   100,    'img/expansions/en/logos/ancient-origins.png',  'img/expansions/en/symbols/ancient-origins.png',    '2015-08-12 00:00:00',  '2015-08-12 00:00:00'),
  96. (67,    'BREAKthrough', 11, '162',  164,    'img/expansions/en/logos/breakthrough.png', 'img/expansions/en/symbols/breakthrough.png',   '2015-11-04 00:00:00',  '2015-11-04 00:00:00'),
  97. (68,    'BREAKpoint',   11, '122',  123,    'img/expansions/en/logos/breakpoint.png',   'img/expansions/en/symbols/breakpoint.png', '2016-02-03 00:00:00',  '2016-02-03 00:00:00'),
  98. (69,    'Generations',  11, '83',   115,    'img/expansions/en/logos/generations.png',  'img/expansions/en/symbols/generations.png',    '2016-02-22 00:00:00',  '2016-02-22 00:00:00'),
  99. (70,    'Fates Collide',    11, '124',  125,    'img/expansions/en/logos/fates-collide.png',    'img/expansions/en/symbols/fates-collide.png',  '2016-05-02 00:00:00',  '2016-05-02 00:00:00'),
  100. (71,    'Steam Siege',  11, '114',  116,    'img/expansions/en/logos/steam-siege.png',  'img/expansions/en/symbols/steam-siege.png',    '2016-08-03 00:00:00',  '2016-08-03 00:00:00'),
  101. (72,    'Wizards Black Star Promos',    101,    NULL,   53, NULL,   'img/expansions/en/symbols/black-star-promo.png',   '1999-07-00 00:00:00',  '2003-03-00 00:00:00'),
  102. (73,    'Nintendo Black Star Promos',   101,    NULL,   40, NULL,   'img/expansions/en/symbols/black-star-promo.png',   '2003-10-00 00:00:00',  '2006-09-00 00:00:00'),
  103. (74,    'DP Black Star Promos', 101,    NULL,   56, NULL,   'img/expansions/en/symbols/black-star-promo.png',   '2007-05-00 00:00:00',  '2009-12-00 00:00:00'),
  104. (75,    'HGSS Black Star Promos',   101,    NULL,   25, NULL,   'img/expansions/en/symbols/black-star-promo.png',   '2010-02-00 00:00:00',  '2011-02-00 00:00:00'),
  105. (76,    'BW Black Star Promos', 101,    NULL,   101,    NULL,   'img/expansions/en/symbols/black-star-promo.png',   '2011-03-00 00:00:00',  '2013-12-00 00:00:00'),
  106. (77,    'XY Black Star Promos', 101,    NULL,   152,    NULL,   'img/expansions/en/symbols/black-star-promo.png',   '2013-10-00 00:00:00',  NULL),
  107. (78,    'POP Series 1', 102,    '17',   17, NULL,   'img/expansions/en/symbols/pop-series-1.png',   '2004-09-00 00:00:00',  '2005-08-00 00:00:00'),
  108. (79,    'POP Series 2', 102,    '17',   17, NULL,   'img/expansions/en/symbols/pop-series-2.png',   '2005-08-00 00:00:00',  '2006-04-00 00:00:00'),
  109. (80,    'POP Series 3', 102,    '17',   17, NULL,   'img/expansions/en/symbols/pop-series-3.png',   '2006-04-00 00:00:00',  '2006-08-00 00:00:00'),
  110. (81,    'POP Series 4', 102,    '17',   17, NULL,   'img/expansions/en/symbols/pop-series-4.png',   '2006-08-00 00:00:00',  '2007-03-00 00:00:00'),
  111. (82,    'POP Series 5', 102,    '17',   17, NULL,   'img/expansions/en/symbols/pop-series-5.png',   '2007-03-00 00:00:00',  '2007-09-00 00:00:00'),
  112. (83,    'POP Series 6', 102,    '17',   17, NULL,   'img/expansions/en/symbols/pop-series-6.png',   '2007-09-00 00:00:00',  '2008-03-00 00:00:00'),
  113. (84,    'POP Series 7', 102,    '17',   17, NULL,   'img/expansions/en/symbols/pop-series-7.png',   '2008-03-00 00:00:00',  '2008-09-00 00:00:00'),
  114. (85,    'POP Series 8', 102,    '17',   17, NULL,   'img/expansions/en/symbols/pop-series-8.png',   '2008-09-00 00:00:00',  '2009-03-00 00:00:00'),
  115. (86,    'POP Series 9', 102,    '17',   17, NULL,   'img/expansions/en/symbols/pop-series-9.png',   '2009-03-00 00:00:00',  '2009-09-00 00:00:00'),
  116. (87,    'McDonald\'s Collection 2011',  103,    '12',   12, NULL,   'img/expansions/en/symbols/mcdonalds-collection-2011.png',  '2011-06-17 00:00:00',  '2011-07-07 00:00:00'),
  117. (88,    'McDonald\'s Collection 2012',  103,    '12',   12, NULL,   'img/expansions/en/symbols/mcdonalds-collection-2012.png',  '2012-06-15 00:00:00',  '2012-07-05 00:00:00'),
  118. (89,    'McDonald\'s Collection 2013',  103,    '12',   12, NULL,   'img/expansions/en/symbols/mcdonalds-collection-2013.png',  '2013-10-13 00:00:00',  '2013-11-26 00:00:00'),
  119. (90,    'McDonald\'s Collection 2014',  103,    '12',   12, NULL,   'img/expansions/en/symbols/mcdonalds-collection-2014.png',  '2014-05-23 00:00:00',  '2014-06-12 00:00:00'),
  120. (91,    'McDonald\'s Collection 2015',  103,    '12',   12, NULL,   'img/expansions/en/symbols/mcdonalds-collection-2015.png',  '2015-10-14 00:00:00',  NULL),
  121. (92,    'EX Trainer Kit (Latias)',  104,    '10',   10, NULL,   'img/expansions/en/symbols/ex-trainer-kit-latias.png',  '2004-06-00 00:00:00',  '2004-06-00 00:00:00'),
  122. (93,    'EX Trainer Kit (Latios)',  104,    '10',   10, NULL,   'img/expansions/en/symbols/ex-trainer-kit-latios.png',  '2004-06-00 00:00:00',  '2004-06-00 00:00:00'),
  123. (94,    'EX Trainer Kit 2 (Plusle)',    104,    '12',   12, NULL,   'img/expansions/en/symbols/ex-trainer-kit-2-plusle.png',    '2005-03-15 00:00:00',  '2005-03-15 00:00:00'),
  124. (95,    'EX Trainer Kit 2 (Minun)', 104,    '12',   12, NULL,   'img/expansions/en/symbols/ex-trainer-kit-2-minun.png', '2005-03-15 00:00:00',  '2005-03-15 00:00:00'),
  125. (96,    'DP Trainer Kit (Manaphy)', 104,    '12',   12, NULL,   'img/expansions/en/symbols/dp-trainer-kit-manaphy.png', '2007-09-00 00:00:00',  '2007-09-00 00:00:00'),
  126. (97,    'DP Trainer Kit (Lucario)', 104,    '11',   11, NULL,   'img/expansions/en/symbols/dp-trainer-kit-lucario.png', '2007-09-00 00:00:00',  '2007-09-00 00:00:00'),
  127. (98,    'HGSS Trainer Kit (Gyarados)',  104,    '30',   30, NULL,   'img/expansions/en/symbols/hgss-trainer-kit-gyarados.png',  '2010-05-00 00:00:00',  '2010-05-00 00:00:00'),
  128. (99,    'HGSS Trainer Kit (Raichu)',    104,    '30',   30, NULL,   'img/expansions/en/symbols/hgss-trainer-kit-raichu.png',    '2010-05-00 00:00:00',  '2010-05-00 00:00:00'),
  129. (100,   'BW Trainer Kit (Excadrill)',   104,    '30',   30, NULL,   'img/expansions/en/symbols/bw-trainer-kit-excadrill.png',   '2011-09-00 00:00:00',  '2011-09-00 00:00:00'),
  130. (101,   'BW Trainer Kit (Zoroark)', 104,    '30',   30, NULL,   'img/expansions/en/symbols/bw-trainer-kit-zoroark.png', '2011-09-00 00:00:00',  '2011-09-00 00:00:00'),
  131. (102,   'XY Trainer Kit (Sylveon)', 104,    '30',   30, NULL,   'img/expansions/en/symbols/xy-trainer-kit-sylveon.png', '2014-03-12 00:00:00',  '2014-03-12 00:00:00'),
  132. (103,   'XY Trainer Kit (Noivern)', 104,    '30',   30, NULL,   'img/expansions/en/symbols/xy-trainer-kit-noivern.png', '2014-03-12 00:00:00',  '2014-03-12 00:00:00'),
  133. (104,   'XY Trainer Kit (Bisharp)', 104,    '30',   30, NULL,   'img/expansions/en/symbols/xy-trainer-kit-bisharp.png', '2014-11-00 00:00:00',  '2014-11-00 00:00:00'),
  134. (105,   'XY Trainer Kit (Wigglytuff)',  104,    '30',   30, NULL,   'img/expansions/en/symbols/xy-trainer-kit-wigglytuff.png',  '2014-11-00 00:00:00',  '2014-11-00 00:00:00'),
  135. (106,   'XY Trainer Kit (Latias)',  104,    '30',   30, NULL,   'img/expansions/en/symbols/xy-trainer-kit-latias.png',  '2015-04-29 00:00:00',  '2015-04-29 00:00:00'),
  136. (107,   'XY Trainer Kit (Latios)',  104,    '30',   30, NULL,   'img/expansions/en/symbols/xy-trainer-kit-latios.png',  '2015-04-29 00:00:00',  '2015-04-29 00:00:00'),
  137. (108,   'Southern Islands', 105,    '18',   18, 'img/expansions/en/logos/southern-islands.png', 'img/expansions/en/symbols/southern-islands.png',   '2001-07-31 00:00:00',  '2001-07-31 00:00:00'),
  138. (109,   'Best of Game', 105,    '9',    9,  NULL,   'img/expansions/en/symbols/best-of-game.png',   '2002-12-00 00:00:00',  '2003-07-00 00:00:00'),
  139. (110,   'Poké Card Creator Pack',   105,    '5',    5,  NULL,   'img/expansions/en/symbols/poke-card-creator-pack.png', '2004-07-00 00:00:00',  '2004-07-00 00:00:00'),
  140. (111,   'Rumble',   105,    '16',   16, 'img/expansions/en/logos/rumble.png',   'img/expansions/en/symbols/rumble.png', '2009-12-02 00:00:00',  '2009-12-02 00:00:00'),
  141. (112,   'Dragon Vault', 105,    '20',   21, 'img/expansions/en/logos/dragon-vault.png', 'img/expansions/en/symbols/dragon-vault.png',   '2012-10-05 00:00:00',  '2012-10-05 00:00:00'),
  142. (113,   'Kalos Starter Set',    105,    '39',   39, 'img/expansions/en/logos/kalos-starter-set.png',    'img/expansions/en/symbols/kalos-starter-set.png',  '2013-11-08 00:00:00',  '2013-11-08 00:00:00');
  143.  
  144. DROP TABLE IF EXISTS `expansion_series`;
  145. CREATE TABLE `expansion_series` (
  146.   `id` int(11) NOT NULL AUTO_INCREMENT,
  147.   `name` varchar(150) COLLATE utf8_bin NOT NULL,
  148.   `language_id` int(11) NOT NULL,
  149.   `main_series` tinyint(4) NOT NULL,
  150.   `release_period_begin` datetime DEFAULT NULL,
  151.   `release_period_end` datetime DEFAULT NULL,
  152.   PRIMARY KEY (`id`),
  153.   UNIQUE KEY `expansion_series_UNIQUE` (`name`,`language_id`),
  154.   KEY `fk_expansion_series_language1_idx` (`language_id`),
  155.   KEY `main_series1_idx` (`main_series`),
  156.   CONSTRAINT `fk_expansion_series_language1` FOREIGN KEY (`language_id`) REFERENCES `language` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  157. ) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  158.  
  159. INSERT INTO `expansion_series` (`id`, `name`, `language_id`, `main_series`, `release_period_begin`, `release_period_end`) VALUES
  160. (1, 'Original Series',  1,  1,  '1999-01-09 00:00:00',  '2000-10-16 00:00:00'),
  161. (2, 'Neo Series',   1,  1,  '2000-12-16 00:00:00',  '2002-02-28 00:00:00'),
  162. (3, 'Legendary Collection Series',  1,  1,  '2002-05-24 00:00:00',  '2002-05-24 00:00:00'),
  163. (4, 'e-Card Series',    1,  1,  '2002-09-15 00:00:00',  '2003-05-12 00:00:00'),
  164. (5, 'EX Series',    1,  1,  '2003-06-18 00:00:00',  '2007-02-14 00:00:00'),
  165. (6, 'Diamond & Pearl Series',   1,  1,  '2007-05-23 00:00:00',  '2008-11-05 00:00:00'),
  166. (7, 'Platinum Series',  1,  1,  '2009-02-11 00:00:00',  '2009-11-04 00:00:00'),
  167. (8, 'HeartGold & SoulSilver Series',    1,  1,  '2010-02-10 00:00:00',  '2010-11-02 00:00:00'),
  168. (9, 'Call of Legends Series',   1,  1,  '2011-02-09 00:00:00',  '2011-02-09 00:00:00'),
  169. (10,    'Black & White Series', 1,  1,  '2011-04-25 00:00:00',  '2013-11-08 00:00:00'),
  170. (11,    'XY Series',    1,  1,  '2014-02-05 00:00:00',  NULL),
  171. (101,   'Black Star Promos',    1,  0,  '1999-07-00 00:00:00',  NULL),
  172. (102,   'POP Series',   1,  0,  '2004-09-00 00:00:00',  NULL),
  173. (103,   'McDonald\'s Collection Series',    1,  0,  '2011-06-17 00:00:00',  NULL),
  174. (104,   'Trainer Kits', 1,  0,  NULL,   NULL),
  175. (105,   'Other',    1,  0,  NULL,   NULL);
  176.  
  177. -- 2016-10-22 22:10:29
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!