· 10 years ago · Sep 17, 2016, 12:58 PM
1-- phpMyAdmin SQL Dump
2-- version 4.6.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost
6-- Generation Time: Sep 17, 2016 at 02:56 PM
7-- Server version: 5.6.28
8-- PHP Version: 7.0.10
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `Lego`
15--
16CREATE DATABASE IF NOT EXISTS `Lego` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
17USE `Lego`;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `Part`
23--
24
25CREATE TABLE `Part` (
26 `ID` varchar(10) NOT NULL DEFAULT '',
27 `Description` varchar(200) DEFAULT NULL,
28 `Width` float NOT NULL,
29 `Length` float NOT NULL,
30 `Height` float NOT NULL DEFAULT '1'
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32
33--
34-- Dumping data for table `Part`
35--
36
37INSERT INTO `Part` (`ID`, `Description`, `Width`, `Length`, `Height`) VALUES
38('2343', 'Minifig, Utensil, Goblet', 1, 1, 1),
39('2349', 'Hinge, Roof, Sunroof, Frame', 4, 4, 1),
40('2570', 'Minifig, Weapon, Crossbow', 1, 1, 1),
41('298c01', 'Lever, Small, Base', 1, 1, 1),
42('3024', 'Plate', 1, 1, 1),
43('307bp02', 'Plate, Patter, Number 2', 1, 1, 1),
44('3794', 'Plate, One stud center', 3, 1, 1),
45('3846px9', 'Minifig, Shield, Triangular, Black Falcn and Blue Border', 1, 1, 1),
46('3847', 'Minifig, Weapon, Sword, Shortsword', 1, 1, 1),
47('3848', 'Minifig, Weapon, Halberd', 1, 1, 1),
48('3937', 'Plate, Brick, Base', 1, 2, 1),
49('3938', 'Plate, Brick, Top', 1, 2, 1),
50('3957', 'Antenna', 1, 4, 1),
51('3960', 'Dish, Round, Inverted', 4, 4, 1),
52('4315', 'Hinge, Roof, Holder', 1, 4, 1),
53('4318', 'Special, Boat, Mast', 2, 2, 9.66),
54('4495', 'Flag, Waving', 4, 1, 1),
55('4497', 'Minifig, Weapon, Spear, Pike', 1, 0, 1),
56('4498', 'Minifig, Weapon, Quiver', 1, 1, 1),
57('4524', 'Minifig, Cape', 1, 1, 1),
58('4589', 'Cone', 1, 1, 1),
59('4733', 'Brick, Studs on all sides', 1, 1, 1),
60('770p4c', 'Minifig, Shield, Ovid, Dragon Blue And Red Pattern', 1, 1, 1),
61('9070c09', 'Minifig, Legs', 1, 1, 1),
62('973p0bc01', 'Minifig, Torso', 0, 0, 1),
63('Sailbb19', 'Special, Sail, Red Flying Dragon Pattern', 12, 10, 1),
64('x46', 'Minifig, Plume, Dragon, Left', 1, 1, 1),
65('x47', 'Minifig, Plume, Dragon', 1, 1, 1),
66('x48', 'Minifig, Plume, Dragon, Right', 1, 1, 1);
67
68--
69-- Indexes for dumped tables
70--
71
72--
73-- Indexes for table `Part`
74--
75ALTER TABLE `Part`
76 ADD PRIMARY KEY (`ID`),
77 ADD UNIQUE KEY `ID` (`ID`);