open-source-projects-demo.sql

--
-- Data for table `Package`
--

INSERT INTO `Package` (`id`, `name`, `description`) VALUES
(1, 'doctrine/annotations', NULL),
(2, 'doctrine/cache', NULL),
(3, 'doctrine/collections', NULL),
(4, 'doctrine/common', NULL),
(5, 'doctrine/dbal', NULL),
(6, 'doctrine/inflector', NULL),
(7, 'doctrine/lexer', NULL),
(8, 'fzaninotto/faker', NULL),
(9, 'psr/log', NULL),
(10, 'symfony/console', NULL),
(11, 'symfony/debug', NULL),
(12, 'symfony/polyfill-mbstring', NULL),
(13, 'paragonie/random_compat', NULL),
(14, 'psr/cache', NULL),
(15, 'symfony/polyfill-intl-icu', NULL),
(16, 'symfony/polyfill-php56', NULL),
(17, 'symfony/polyfill-php70', NULL),
(18, 'symfony/polyfill-util', NULL),
(19, 'symfony/symfony', NULL),
(20, 'twig/twig', NULL),
(21, 'doctrine/orm', NULL),
(22, 'analog/analog', NULL),
(23, 'composer/ca-bundle', NULL),
(24, 'doctrine/doctrine-bundle', NULL),
(25, 'doctrine/doctrine-cache-bundle', NULL),
(26, 'greenlion/php-sql-parser', NULL),
(27, 'incenteev/composer-parameter-handler', NULL),
(28, 'jdorn/sql-formatter', NULL),
(29, 'monolog/monolog', NULL),
(30, 'ocramius/proxy-manager', NULL),
(31, 'roave/security-advisories', NULL),
(32, 'sensio/distribution-bundle', NULL),
(33, 'sensiolabs/security-checker', NULL),
(34, 'symfony/cache', NULL),
(35, 'symfony/class-loader', NULL),
(36, 'symfony/config', NULL),
(37, 'symfony/debug-bundle', NULL),
(38, 'symfony/dependency-injection', NULL),
(39, 'symfony/doctrine-bridge', NULL),
(40, 'symfony/event-dispatcher', NULL),
(41, 'symfony/filesystem', NULL),
(42, 'symfony/finder', NULL),
(43, 'symfony/framework-bundle', NULL),
(44, 'symfony/http-foundation', NULL),
(45, 'symfony/http-kernel', NULL),
(46, 'symfony/inflector', NULL),
(47, 'symfony/intl', NULL),
(48, 'symfony/monolog-bridge', NULL),
(49, 'symfony/monolog-bundle', NULL),
(50, 'symfony/process', NULL),
(51, 'symfony/property-access', NULL),
(52, 'symfony/proxy-manager-bridge', NULL),
(53, 'symfony/routing', NULL),
(54, 'symfony/stopwatch', NULL),
(55, 'symfony/translation', NULL),
(56, 'symfony/twig-bridge', NULL),
(57, 'symfony/var-dumper', NULL),
(58, 'symfony/yaml', NULL),
(59, 'zendframework/zend-code', NULL),
(60, 'zendframework/zend-eventmanager', NULL),
(61, 'braintree/braintree_php', NULL),
(62, 'colinmollenhour/credis', NULL),
(63, 'colinmollenhour/php-redis-session-abstract', NULL),
(64, 'composer/composer', NULL),
(65, 'composer/semver', NULL),
(66, 'composer/spdx-licenses', NULL),
(67, 'justinrainbow/json-schema', NULL),
(68, 'magento/composer', NULL),
(69, 'magento/magento-composer-installer', NULL),
(70, 'magento/zendframework1', NULL),
(71, 'oyejorge/less.php', NULL),
(72, 'pelago/emogrifier', NULL),
(73, 'phpseclib/phpseclib', NULL),
(74, 'seld/cli-prompt', NULL),
(75, 'seld/jsonlint', NULL),
(76, 'seld/phar-utils', NULL),
(77, 'tedivm/jshrink', NULL),
(78, 'tubalmartin/cssmin', NULL),
(79, 'zendframework/zend-config', NULL),
(80, 'zendframework/zend-console', NULL),
(81, 'zendframework/zend-crypt', NULL),
(82, 'zendframework/zend-di', NULL),
(83, 'zendframework/zend-escaper', NULL),
(84, 'zendframework/zend-filter', NULL),
(85, 'zendframework/zend-form', NULL),
(86, 'zendframework/zend-http', NULL),
(87, 'zendframework/zend-i18n', NULL),
(88, 'zendframework/zend-inputfilter', NULL),
(89, 'zendframework/zend-json', NULL),
(90, 'zendframework/zend-loader', NULL),
(91, 'zendframework/zend-log', NULL),
(92, 'zendframework/zend-math', NULL),
(93, 'zendframework/zend-modulemanager', NULL),
(94, 'zendframework/zend-mvc', NULL),
(95, 'zendframework/zend-serializer', NULL),
(96, 'zendframework/zend-server', NULL),
(97, 'zendframework/zend-servicemanager', NULL),
(98, 'zendframework/zend-soap', NULL),
(99, 'zendframework/zend-stdlib', NULL),
(100, 'zendframework/zend-text', NULL),
(101, 'zendframework/zend-uri', NULL),
(102, 'zendframework/zend-validator', NULL),
(103, 'zendframework/zend-view', NULL),
(104, 'composer/xdebug-handler', NULL),
(105, 'doctrine/instantiator', NULL),
(106, 'ocramius/package-versions', NULL);

--
-- Data for table `PackageVersion`
--

INSERT INTO `PackageVersion` (`id`, `package_id`, `prettyVersion`) VALUES
(24, 1, 'v1.2.0'),
(1, 1, 'v1.2.7'),
(142, 1, 'v1.6.0'),
(25, 2, 'v1.3.0'),
(13, 2, 'v1.6.0'),
(2, 2, 'v1.6.2'),
(143, 2, 'v1.7.1'),
(26, 3, 'v1.2'),
(3, 3, 'v1.3.0'),
(144, 3, 'v1.5.0'),
(27, 4, 'v2.4.2'),
(14, 4, 'v2.6.1'),
(4, 4, 'v2.6.2'),
(145, 4, 'v2.8.1'),
(146, 5, 'dev-develop'),
(28, 5, 'v2.4.2'),
(5, 5, 'v2.5.13'),
(29, 6, 'v1.0'),
(6, 6, 'v1.1.0'),
(147, 6, 'v1.3.0'),
(30, 7, 'v1.0'),
(7, 7, 'v1.0.1'),
(8, 8, 'v1.7.1'),
(9, 9, '1.0.0'),
(44, 9, '1.0.2'),
(32, 10, 'v2.5.4'),
(100, 10, 'v2.6.13'),
(137, 10, 'v2.8.37'),
(51, 10, 'v3.2.13'),
(10, 10, 'v3.4.4'),
(151, 10, 'v4.0.6'),
(138, 11, 'v2.8.38'),
(52, 11, 'v3.2.13'),
(11, 11, 'v3.4.4'),
(18, 12, 'v1.2.0'),
(67, 12, 'v1.6.0'),
(12, 12, 'v1.7.0'),
(42, 13, 'v2.0.11'),
(15, 13, 'v2.0.2'),
(16, 14, '1.0.0'),
(43, 14, '1.0.1'),
(17, 15, 'v1.2.0'),
(66, 15, 'v1.6.0'),
(19, 16, 'v1.2.0'),
(68, 16, 'v1.6.0'),
(20, 17, 'v1.2.0'),
(69, 17, 'v1.6.0'),
(21, 18, 'v1.2.0'),
(70, 18, 'v1.6.0'),
(22, 19, 'v3.1.2'),
(23, 20, 'v1.24.1'),
(80, 20, 'v1.35.0'),
(31, 21, 'v2.4.4'),
(33, 22, '1.0.10-stable'),
(34, 23, '1.0.8'),
(134, 23, '1.1.1'),
(35, 24, '1.6.13'),
(36, 25, '1.3.2'),
(37, 26, 'v4.1.2'),
(38, 27, 'v2.1.2'),
(39, 28, 'v1.2.17'),
(93, 29, '1.16.0'),
(40, 29, '1.23.0'),
(41, 30, '1.0.2'),
(150, 30, '2.2.0'),
(45, 31, 'dev-master'),
(46, 32, 'v5.0.21'),
(47, 33, 'v4.1.5'),
(48, 34, 'v3.2.13'),
(49, 35, 'v3.3.10'),
(50, 36, 'v3.2.13'),
(53, 37, 'v3.2.13'),
(54, 38, 'v3.2.13'),
(55, 39, 'v3.2.13'),
(101, 40, 'v2.8.34'),
(56, 40, 'v3.2.13'),
(102, 41, 'v2.8.34'),
(139, 41, 'v2.8.38'),
(57, 41, 'v3.2.13'),
(140, 42, 'v2.8.38'),
(58, 42, 'v3.2.13'),
(103, 42, 'v3.4.4'),
(59, 43, 'v3.2.13'),
(60, 44, 'v3.3.10'),
(61, 45, 'v3.2.13'),
(62, 46, 'v3.3.10'),
(63, 47, 'v3.3.10'),
(64, 48, 'v3.2.13'),
(65, 49, 'v3.1.1'),
(104, 50, 'v2.8.34'),
(141, 50, 'v2.8.38'),
(71, 50, 'v3.2.13'),
(72, 51, 'v3.2.13'),
(73, 52, 'v3.2.13'),
(74, 53, 'v3.2.13'),
(75, 54, 'v3.2.13'),
(76, 55, 'v3.2.13'),
(77, 56, 'v3.3.10'),
(78, 57, 'v3.2.13'),
(79, 58, 'v3.2.13'),
(107, 59, '2.4.13'),
(81, 59, '2.6.3'),
(152, 59, '3.3.0'),
(113, 60, '2.4.13'),
(82, 60, '3.0.1'),
(153, 60, '3.2.0'),
(83, 61, '2.39.0'),
(84, 62, '1.6'),
(85, 63, 'v1.2'),
(86, 64, '1.0.0-beta1'),
(87, 65, '1.4.2'),
(88, 66, '1.3.0'),
(89, 67, '1.6.1'),
(136, 67, '5.2.7'),
(90, 68, '1.0.3'),
(91, 69, '0.1.13'),
(92, 70, '1.12.16-patch3'),
(94, 71, 'v1.7.0.3'),
(95, 72, 'v0.1.1'),
(96, 73, '0.3.10'),
(97, 74, '1.0.3'),
(98, 75, '1.7.1'),
(99, 76, '1.0.1'),
(105, 77, 'v1.0.1'),
(106, 78, 'v2.4.8-p4'),
(108, 79, '2.4.13'),
(109, 80, '2.4.13'),
(110, 81, '2.4.13'),
(111, 82, '2.4.13'),
(112, 83, '2.4.13'),
(114, 84, '2.4.13'),
(115, 85, '2.4.13'),
(116, 86, '2.4.13'),
(117, 87, '2.4.13'),
(118, 88, '2.4.13'),
(119, 89, '2.4.13'),
(120, 90, '2.4.13'),
(121, 91, '2.4.13'),
(122, 92, '2.4.13'),
(123, 93, '2.4.13'),
(124, 94, '2.4.13'),
(125, 95, '2.4.13'),
(126, 96, '2.4.13'),
(127, 97, '2.4.13'),
(128, 98, '2.4.13'),
(129, 99, '2.4.13'),
(130, 100, '2.4.13'),
(131, 101, '2.4.13'),
(132, 102, '2.4.13'),
(133, 103, '2.4.13'),
(135, 104, '1.1.0'),
(148, 105, '1.1.0'),
(149, 106, '1.3.0');

--
-- Data for table `Project`
--

INSERT INTO `Project` (`id`, `name`, `vcsUrl`, `description`) VALUES
(7, 'slimdump', 'https://github.com/webfactory/slimdump', NULL),
(8, 'slug-validation-bundle', 'https://github.com/webfactory/slug-validation-bundle', NULL),
(9, 'doctrine-orm-test-infrastructure', 'https://github.com/webfactory/doctrine-orm-test-infrastructure', NULL),
(10, 'zauberlehrling', 'https://github.com/webfactory/zauberlehrling', NULL),
(11, 'magento2', 'https://github.com/magento/magento2', NULL),
(12, 'composer', 'https://github.com/composer/composer', NULL),
(13, 'doctrine2', 'https://github.com/doctrine/doctrine2', NULL);

--
-- Data for table `packageversion_project`
--

INSERT INTO `packageversion_project` (`packageversion_id`, `project_id`) VALUES
(1, 7),
(1, 8),
(1, 10),
(2, 7),
(2, 10),
(3, 7),
(3, 8),
(3, 10),
(4, 7),
(4, 10),
(5, 7),
(5, 10),
(6, 7),
(6, 8),
(6, 10),
(7, 7),
(7, 8),
(7, 10),
(7, 13),
(8, 7),
(9, 7),
(9, 8),
(10, 7),
(11, 7),
(12, 7),
(12, 12),
(12, 13),
(13, 8),
(14, 8),
(15, 8),
(16, 8),
(17, 8),
(18, 8),
(19, 8),
(20, 8),
(21, 8),
(22, 8),
(23, 8),
(24, 9),
(25, 9),
(26, 9),
(27, 9),
(28, 9),
(29, 9),
(30, 9),
(31, 9),
(32, 9),
(33, 10),
(34, 10),
(35, 10),
(36, 10),
(37, 10),
(38, 10),
(39, 10),
(40, 10),
(41, 10),
(42, 10),
(43, 10),
(44, 10),
(44, 11),
(44, 12),
(45, 10),
(46, 10),
(47, 10),
(48, 10),
(49, 10),
(50, 10),
(51, 10),
(52, 10),
(53, 10),
(54, 10),
(55, 10),
(56, 10),
(57, 10),
(58, 10),
(59, 10),
(60, 10),
(61, 10),
(62, 10),
(63, 10),
(64, 10),
(65, 10),
(66, 10),
(67, 10),
(68, 10),
(69, 10),
(70, 10),
(71, 10),
(72, 10),
(73, 10),
(74, 10),
(75, 10),
(76, 10),
(77, 10),
(78, 10),
(79, 10),
(80, 10),
(81, 10),
(82, 10),
(83, 11),
(84, 11),
(85, 11),
(86, 11),
(87, 11),
(87, 12),
(88, 11),
(88, 12),
(89, 11),
(90, 11),
(91, 11),
(92, 11),
(93, 11),
(94, 11),
(95, 11),
(96, 11),
(97, 11),
(97, 12),
(98, 11),
(98, 12),
(99, 11),
(99, 12),
(100, 11),
(101, 11),
(102, 11),
(103, 11),
(104, 11),
(105, 11),
(106, 11),
(107, 11),
(108, 11),
(109, 11),
(110, 11),
(111, 11),
(112, 11),
(113, 11),
(114, 11),
(115, 11),
(116, 11),
(117, 11),
(118, 11),
(119, 11),
(120, 11),
(121, 11),
(122, 11),
(123, 11),
(124, 11),
(125, 11),
(126, 11),
(127, 11),
(128, 11),
(129, 11),
(130, 11),
(131, 11),
(132, 11),
(133, 11),
(134, 12),
(135, 12),
(136, 12),
(137, 12),
(138, 12),
(139, 12),
(140, 12),
(141, 12),
(142, 13),
(143, 13),
(144, 13),
(145, 13),
(146, 13),
(147, 13),
(148, 13),
(149, 13),
(150, 13),
(151, 13),
(152, 13),
(153, 13);