· 7 years ago · Dec 13, 2018, 08:48 AM
1-- phpMyAdmin SQL Dump
2-- version 4.8.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dec 13, 2018 at 09:45 AM
7-- Server version: 10.1.34-MariaDB
8-- PHP Version: 7.2.7
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `cdkatalog`
23--
24CREATE DATABASE IF NOT EXISTS `cdkatalog` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `cdkatalog`;
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `cd`
31--
32
33DROP TABLE IF EXISTS `cd`;
34CREATE TABLE `cd` (
35 `id` int(11) NOT NULL,
36 `title` varchar(255) NOT NULL,
37 `artist` varchar(255) NOT NULL,
38 `country` varchar(60) NOT NULL,
39 `company` varchar(128) NOT NULL,
40 `price` decimal(10,0) NOT NULL,
41 `year` int(11) NOT NULL
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43
44--
45-- Dumping data for table `cd`
46--
47
48INSERT INTO `cd` (`id`, `title`, `artist`, `country`, `company`, `price`, `year`) VALUES
49(1, 'Empire Burlesque', 'Bob Dylan', 'USA', 'Columbia', '11', 1985),
50(2, 'Hide your heart', 'Bonnie Tyler', 'UK', 'CBS Records', '10', 1988),
51(3, 'Greatest Hits', 'Dolly Parton', 'USA', 'RCA', '10', 1982),
52(4, 'Still got the blues', 'Gary Moore', 'UK', 'Virgin records', '10', 1990),
53(5, 'Eros', 'Eros Ramazzotti', 'EU', 'BMG', '10', 1997),
54(6, 'One night only', 'Bee Gees', 'UK', 'Polydor', '11', 1998),
55(7, 'Sylvias Mother', 'Dr.Hook', 'UK', 'CBS', '8', 1973),
56(8, 'Maggie May', 'Rod Stewart', 'UK', 'Pickwick', '9', 1990),
57(9, 'Romanza', 'Andrea Bocelli', 'EU', 'Polydor', '11', 1996),
58(10, 'When a man loves a woman', 'Percy Sledge', 'USA', 'Atlantic', '9', 1987),
59(11, 'Black angel', 'Savage Rose', 'EU', 'Mega', '11', 1995),
60(12, '1999 Grammy Nominees', 'Many', 'USA', 'Grammy', '10', 1999),
61(13, 'For the good times', 'Kenny Rogers', 'UK', 'Mucik Master', '9', 1995),
62(14, 'Big Willie style', 'Will Smith', 'USA', 'Columbia', '10', 1997),
63(15, 'Tupelo Honey', 'Van Morrison', 'UK', 'Polydor', '8', 1971),
64(16, 'Soulsville', 'Jorn Hoel', 'Norway', 'WEA', '8', 1996),
65(17, 'The very best of', 'Cat Stevens', 'UK', 'Island', '9', 1990),
66(18, 'Stop', 'Sam Brown', 'UK', 'A and M', '9', 1988),
67(19, 'Private Dancer', 'Tina Turner', 'UK', 'Capitol', '9', 1983),
68(20, 'Midt om natten', 'Kim Larsen', 'EU', 'Medley', '8', 1983),
69(21, 'Pavarotti Gala Concert', 'Luciano Pavarotti', 'UK', 'DECCA', '10', 1991),
70(22, 'The dock of the bay', 'Otis Redding', 'USA', 'Stax Records', '8', 1968),
71(23, 'Picture book', 'Simply Red', 'EU', 'Elektra', '7', 1985),
72(24, 'Red', 'The Communards', 'UK', 'London', '8', 1987),
73(25, 'Unchain my heart', 'Joe Cocker', 'USA', 'EMI', '8', 1987),
74(26, 'Empire Burlesque', 'Bob Dylan', 'USA', 'Columbia', '11', 1985),
75(27, 'Hide your heart', 'Bonnie Tyler', 'UK', 'CBS Records', '10', 1988),
76(28, 'Greatest Hits', 'Dolly Parton', 'USA', 'RCA', '10', 1982),
77(29, 'Still got the blues', 'Gary Moore', 'UK', 'Virgin records', '10', 1990),
78(30, 'Eros', 'Eros Ramazzotti', 'EU', 'BMG', '10', 1997),
79(31, 'One night only', 'Bee Gees', 'UK', 'Polydor', '11', 1998),
80(32, 'Sylvias Mother', 'Dr.Hook', 'UK', 'CBS', '8', 1973),
81(33, 'Maggie May', 'Rod Stewart', 'UK', 'Pickwick', '9', 1990),
82(34, 'Romanza', 'Andrea Bocelli', 'EU', 'Polydor', '11', 1996),
83(35, 'When a man loves a woman', 'Percy Sledge', 'USA', 'Atlantic', '9', 1987),
84(36, 'Black angel', 'Savage Rose', 'EU', 'Mega', '11', 1995),
85(37, '1999 Grammy Nominees', 'Many', 'USA', 'Grammy', '10', 1999),
86(38, 'For the good times', 'Kenny Rogers', 'UK', 'Mucik Master', '9', 1995),
87(39, 'Big Willie style', 'Will Smith', 'USA', 'Columbia', '10', 1997),
88(40, 'Tupelo Honey', 'Van Morrison', 'UK', 'Polydor', '8', 1971),
89(41, 'Soulsville', 'Jorn Hoel', 'Norway', 'WEA', '8', 1996),
90(42, 'The very best of', 'Cat Stevens', 'UK', 'Island', '9', 1990),
91(43, 'Stop', 'Sam Brown', 'UK', 'A and M', '9', 1988),
92(44, 'Private Dancer', 'Tina Turner', 'UK', 'Capitol', '9', 1983),
93(45, 'Midt om natten', 'Kim Larsen', 'EU', 'Medley', '8', 1983),
94(46, 'Pavarotti Gala Concert', 'Luciano Pavarotti', 'UK', 'DECCA', '10', 1991),
95(47, 'The dock of the bay', 'Otis Redding', 'USA', 'Stax Records', '8', 1968),
96(48, 'Picture book', 'Simply Red', 'EU', 'Elektra', '7', 1985),
97(49, 'Red', 'The Communards', 'UK', 'London', '8', 1987),
98(50, 'Unchain my heart', 'Joe Cocker', 'USA', 'EMI', '8', 1987),
99(51, 'Empire Burlesque', 'Bob Dylan', 'USA', 'Columbia', '11', 1985),
100(52, 'Hide your heart', 'Bonnie Tyler', 'UK', 'CBS Records', '10', 1988),
101(53, 'Greatest Hits', 'Dolly Parton', 'USA', 'RCA', '10', 1982),
102(54, 'Still got the blues', 'Gary Moore', 'UK', 'Virgin records', '10', 1990),
103(55, 'Eros', 'Eros Ramazzotti', 'EU', 'BMG', '10', 1997),
104(56, 'One night only', 'Bee Gees', 'UK', 'Polydor', '11', 1998),
105(57, 'Sylvias Mother', 'Dr.Hook', 'UK', 'CBS', '8', 1973),
106(58, 'Maggie May', 'Rod Stewart', 'UK', 'Pickwick', '9', 1990),
107(59, 'Romanza', 'Andrea Bocelli', 'EU', 'Polydor', '11', 1996),
108(60, 'When a man loves a woman', 'Percy Sledge', 'USA', 'Atlantic', '9', 1987),
109(61, 'Black angel', 'Savage Rose', 'EU', 'Mega', '11', 1995),
110(62, '1999 Grammy Nominees', 'Many', 'USA', 'Grammy', '10', 1999),
111(63, 'For the good times', 'Kenny Rogers', 'UK', 'Mucik Master', '9', 1995),
112(64, 'Big Willie style', 'Will Smith', 'USA', 'Columbia', '10', 1997),
113(65, 'Tupelo Honey', 'Van Morrison', 'UK', 'Polydor', '8', 1971),
114(66, 'Soulsville', 'Jorn Hoel', 'Norway', 'WEA', '8', 1996),
115(67, 'The very best of', 'Cat Stevens', 'UK', 'Island', '9', 1990),
116(68, 'Stop', 'Sam Brown', 'UK', 'A and M', '9', 1988),
117(69, 'Private Dancer', 'Tina Turner', 'UK', 'Capitol', '9', 1983),
118(70, 'Midt om natten', 'Kim Larsen', 'EU', 'Medley', '8', 1983),
119(71, 'Pavarotti Gala Concert', 'Luciano Pavarotti', 'UK', 'DECCA', '10', 1991),
120(72, 'The dock of the bay', 'Otis Redding', 'USA', 'Stax Records', '8', 1968),
121(73, 'Picture book', 'Simply Red', 'EU', 'Elektra', '7', 1985),
122(74, 'Red', 'The Communards', 'UK', 'London', '8', 1987),
123(75, 'Unchain my heart', 'Joe Cocker', 'USA', 'EMI', '8', 1987),
124(76, 'Empire Burlesque', 'Bob Dylan', 'USA', 'Columbia', '11', 1985),
125(77, 'Hide your heart', 'Bonnie Tyler', 'UK', 'CBS Records', '10', 1988),
126(78, 'Greatest Hits', 'Dolly Parton', 'USA', 'RCA', '10', 1982),
127(79, 'Still got the blues', 'Gary Moore', 'UK', 'Virgin records', '10', 1990),
128(80, 'Eros', 'Eros Ramazzotti', 'EU', 'BMG', '10', 1997),
129(81, 'One night only', 'Bee Gees', 'UK', 'Polydor', '11', 1998),
130(82, 'Sylvias Mother', 'Dr.Hook', 'UK', 'CBS', '8', 1973),
131(83, 'Maggie May', 'Rod Stewart', 'UK', 'Pickwick', '9', 1990),
132(84, 'Romanza', 'Andrea Bocelli', 'EU', 'Polydor', '11', 1996),
133(85, 'When a man loves a woman', 'Percy Sledge', 'USA', 'Atlantic', '9', 1987),
134(86, 'Black angel', 'Savage Rose', 'EU', 'Mega', '11', 1995),
135(87, '1999 Grammy Nominees', 'Many', 'USA', 'Grammy', '10', 1999),
136(88, 'For the good times', 'Kenny Rogers', 'UK', 'Mucik Master', '9', 1995),
137(89, 'Big Willie style', 'Will Smith', 'USA', 'Columbia', '10', 1997),
138(90, 'Tupelo Honey', 'Van Morrison', 'UK', 'Polydor', '8', 1971),
139(91, 'Soulsville', 'Jorn Hoel', 'Norway', 'WEA', '8', 1996),
140(92, 'The very best of', 'Cat Stevens', 'UK', 'Island', '9', 1990),
141(93, 'Stop', 'Sam Brown', 'UK', 'A and M', '9', 1988),
142(94, 'Private Dancer', 'Tina Turner', 'UK', 'Capitol', '9', 1983),
143(95, 'Midt om natten', 'Kim Larsen', 'EU', 'Medley', '8', 1983),
144(96, 'Pavarotti Gala Concert', 'Luciano Pavarotti', 'UK', 'DECCA', '10', 1991),
145(97, 'The dock of the bay', 'Otis Redding', 'USA', 'Stax Records', '8', 1968),
146(98, 'Picture book', 'Simply Red', 'EU', 'Elektra', '7', 1985),
147(99, 'Red', 'The Communards', 'UK', 'London', '8', 1987),
148(100, 'Unchain my heart', 'Joe Cocker', 'USA', 'EMI', '8', 1987);
149
150--
151-- Indexes for dumped tables
152--
153
154--
155-- Indexes for table `cd`
156--
157ALTER TABLE `cd`
158 ADD PRIMARY KEY (`id`);
159
160--
161-- AUTO_INCREMENT for dumped tables
162--
163
164--
165-- AUTO_INCREMENT for table `cd`
166--
167ALTER TABLE `cd`
168 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;
169COMMIT;
170
171/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
172/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
173/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;