· 6 years ago · Jan 12, 2020, 03:22 PM
1-- phpMyAdmin SQL Dump
2-- version 3.3.9
3-- http://www.phpmyadmin.net
4--
5-- Σύστημα: localhost
6-- Χρόνος δημιουργίας: 22 Ιανουαρίου 2012 στις 10:15:19
7-- Έκδοση Διακομιστή: 5.5.16
8-- Έκδοση PHP: 5.3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Βάση: `onlybooks`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Δομή Πίνακα για τον Πίνακα `customers`
26--
27
28DROP TABLE IF EXISTS `customers`;
29CREATE TABLE IF NOT EXISTS `customers` (
30 `id_customer` int(20) NOT NULL AUTO_INCREMENT,
31 `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
32 `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
33 `post_code` int(20) NOT NULL,
34 `city` varchar(50) NOT NULL,
35 `telephone` varchar(50) NOT NULL,
36 `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
37 `number_account` varchar(50) NOT NULL,
38 `number_credit_card` varchar(50) NOT NULL,
39 `name_credit_card` varchar(20) NOT NULL,
40 `number_CVV_credit_card` varchar(20) NOT NULL,
41 `amount` int(20) NOT NULL,
42 PRIMARY KEY (`id_customer`)
43) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=79 ;
44
45--
46-- Άδειασμα δεδομένων του πίνακα `customers`
47--
48
49INSERT INTO `customers` (`id_customer`, `name`, `address`, `post_code`, `city`, `telephone`, `email`, `number_account`, `number_credit_card`, `name_credit_card`, `number_CVV_credit_card`, `amount`) VALUES
50(18, 'papadakis giorgos', 'skaltsouni 6 Heraklion', 0, '', '6974567831', 'papadak@csd.uoc.gr', '', '1111222233334444', '', '0', 12343),
51(19, 'papadopoulos giannis', 'olymbou 6 Heraklion', 0, '', '6975566789', 'papadopoul@hotmail.com', '', '5555666677778888', '', '0', 12343),
52(23, 'makris panagiotis', 'katerinis 7 athens', 0, '', '6945172117', 'makr@hotmail.com', '', '2222333344445555', '', '0', 12343),
53(24, 'georgiou kostas', 'kleisthenous 5 heraklion', 0, '', '6974074831', 'papa@hotmail.com', '', '1111222233334444', '', '0', 12343),
54(25, 'georgiou kostas', 'kleisthenous 5 heraklion', 0, '', '6974074831', 'papa@hotmail.com', '', '1111222233334444', '', '0', 12343),
55(26, 'georgiou kostas', 'kleisthenous 5 heraklion', 0, '', '6974074831', 'papa@hotmail.com', '', '1111222233334444', '', '0', 12343),
56(27, 'georgiou kostas', 'kleisthenous 5 heraklion', 0, '', '6974074831', 'papa@hotmail.com', '', '1111222233334444', '', '0', 12343),
57(28, 'georgiou kostas', 'kleisthenous 5 heraklion', 0, '', '6974074831', 'papa@hotmail.com', '', '1111222233334444', '', '0', 12343),
58(36, 'nikos', 'inis', 0, '', '789', '@com', '', '555555', '', '0', 0),
59(37, 'nikos', 'inis', 0, '', '789', 'nikos@com', '', '555555', '', '0', 0),
60(38, 'nikos', 'inis', 0, '', '789', 'nikos@com', '', '555555', '', '0', 0),
61(39, 'nikossssssssss3', 'nikis 4', 0, '', '333333333', '4jmiodl;@', '', '3232423', '', '0', 0),
62(40, 'nikos', 'nikisame', 0, '', '789', 'nikos@com', '', '555555', '', '0', 0),
63(41, '', '', 0, '', '', '', '', '', '', '0', 0),
64(42, 'nikod', 'ivis8', 0, '', '2810238429', 'gurunick@hotmail,com', '', '1111222233334444', '', '0', 0),
65(43, 'nikod', 'ivis8', 0, '', '2810238429', 'gurunick@hotmail,com', '', '1111222233334444', '', '0', 0),
66(44, 'nikod', 'ivis8', 0, '', '2810238429', 'gurunick@hotmail,com', '', '', '', '0', 0),
67(45, 'nikod', 'ivis8', 0, '', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
68(46, 'niko', 'ivis8', 0, '', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
69(47, 'niko', 'ivis8', 0, '', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
70(48, 'niko', 'ivis8', 0, '', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
71(49, 'niko', 'ivis8', 456, '', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
72(50, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
73(51, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
74(52, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
75(53, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
76(54, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
77(56, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
78(57, 'nikos', 'nikisame', 0, '', '789', 'nikos@com', '', '', '', '', 0),
79(58, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '', '', 0),
80(59, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '0', '', '', 0),
81(60, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '0', '0', '0', 0),
82(61, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '0', '0', 0),
83(62, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '0', '0', 0),
84(63, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '0', '0', 0),
85(64, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '0', '0', 0),
86(65, 'niko', 'ivis8', 456, 'heraklion', '2810238429', 'gurunick@hotmail,com', '', '', '0', '0', 0),
87(66, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', '2810238429', 'gurunick@hotmail,com', '0', '0', '0', '0', 0),
88(67, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', '2810238429', 'gurunick@hotmail,com', '0', '0', '0', '0', 0),
89(68, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', '2810238429', 'gurunick@hotmail,com', '3333', '3849449999', 'nikolaos maridakis', '', 0),
90(69, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', '2810238429', 'gurunick@hotmail,com', '3333', '3849449999', 'nikolaos maridakis', '', 0),
91(70, 'nikos', 'nikisame', 0, '', '789', 'nikos@com', '', '', '', '', 0),
92(71, '', '', 0, '', '', '', '', '', '', '', 0),
93(72, '', '', 0, '', '', '', '', '', '', '', 0),
94(73, 'nikos maridakis', 'ivis 4', 45167, 'heraklion', '2810238429', 'gurunick@hotmail.com', '23', '3323424242', 'nikolaos maridakis', '', 0),
95(74, 'nikos maridakis', 'ivis 4', 45167, 'heraklion', '2810238429', 'gurunick@hotmail.com', '23', '3323424242', 'nikolaos maridakis', '', 0),
96(75, 'nikos maridakis', 'ivis 4', 45167, 'heraklion', '2810238429', 'gurunick@hotmail.com', '23', '3323424242', 'nikolaos maridakis', '', 0),
97(76, 'nikos maridakis', 'ivis 4', 45167, 'heraklion', '2810238429', 'gurunick@hotmail.com', '23', '3323424242', 'nikolaos maridakis', '555', 0),
98(78, 'papadakis georgios', 'benizelou 6', 45123, 'heraklion', '6974075831', 'papad@hotmail.com', '77', '1111222233334444', 'georgios papadakis', '789', 0);
99
100-- --------------------------------------------------------
101
102--
103-- Δομή Πίνακα για τον Πίνακα `dosolipsies_customer`
104--
105
106DROP TABLE IF EXISTS `dosolipsies_customer`;
107CREATE TABLE IF NOT EXISTS `dosolipsies_customer` (
108 `id_dosolipsia` int(20) NOT NULL AUTO_INCREMENT,
109 `id_customer` int(20) NOT NULL,
110 `date` date NOT NULL,
111 `amount` int(20) NOT NULL,
112 PRIMARY KEY (`id_dosolipsia`),
113 KEY `id_customer` (`id_customer`)
114) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Πίνακας δοσοληψιών ' AUTO_INCREMENT=1 ;
115
116--
117-- Άδειασμα δεδομένων του πίνακα `dosolipsies_customer`
118--
119
120
121-- --------------------------------------------------------
122
123--
124-- Δομή Πίνακα για τον Πίνακα `dosolipsies_trader`
125--
126
127DROP TABLE IF EXISTS `dosolipsies_trader`;
128CREATE TABLE IF NOT EXISTS `dosolipsies_trader` (
129 `id_dosolipsia` int(20) NOT NULL,
130 `id_trader` int(20) NOT NULL,
131 `date` date NOT NULL,
132 `amount` int(20) NOT NULL,
133 PRIMARY KEY (`id_dosolipsia`),
134 KEY `id_trader` (`id_trader`)
135) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
136
137--
138-- Άδειασμα δεδομένων του πίνακα `dosolipsies_trader`
139--
140
141
142-- --------------------------------------------------------
143
144--
145-- Δομή Πίνακα για τον Πίνακα `eksoflisi_xreous`
146--
147
148DROP TABLE IF EXISTS `eksoflisi_xreous`;
149CREATE TABLE IF NOT EXISTS `eksoflisi_xreous` (
150 `id_xreos` int(20) NOT NULL AUTO_INCREMENT,
151 `id_trader` int(20) NOT NULL,
152 `payment_amount` double NOT NULL,
153 `new_dept` double NOT NULL,
154 `date` datetime NOT NULL,
155 PRIMARY KEY (`id_xreos`),
156 KEY `id_trader` (`id_trader`)
157) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Πίνακας οφειλών-νέο υπόλοιπο' AUTO_INCREMENT=3 ;
158
159--
160-- Άδειασμα δεδομένων του πίνακα `eksoflisi_xreous`
161--
162
163INSERT INTO `eksoflisi_xreous` (`id_xreos`, `id_trader`, `payment_amount`, `new_dept`, `date`) VALUES
164(1, 23, 10, 10, '0000-00-00 00:00:00'),
165(2, 28, 123, 123, '2012-01-20 10:23:00');
166
167-- --------------------------------------------------------
168
169--
170-- Δομή Πίνακα για τον Πίνακα `interests_customers`
171--
172
173DROP TABLE IF EXISTS `interests_customers`;
174CREATE TABLE IF NOT EXISTS `interests_customers` (
175 `id_interest` int(20) NOT NULL AUTO_INCREMENT,
176 `id_customer` int(20) NOT NULL,
177 `interest` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
178 PRIMARY KEY (`id_interest`),
179 KEY `id_customer` (`id_customer`)
180) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='πίνακας ενδιαφερόντων πελατών' AUTO_INCREMENT=36 ;
181
182--
183-- Άδειασμα δεδομένων του πίνακα `interests_customers`
184--
185
186INSERT INTO `interests_customers` (`id_interest`, `id_customer`, `interest`) VALUES
187(18, 37, ' logotexnia ekpaideutika'),
188(19, 36, ' logotexnia ekpaideutika'),
189(20, 56, ' ekpaideutika iatrika'),
190(27, 58, ' komics ekpaideutika iatrika'),
191(28, 58, ' komics ekpaideutika iatrika'),
192(29, 71, ' iatrika epistimonika'),
193(30, 73, ' iatrika epistimonika'),
194(31, 73, ' iatrika epistimonika'),
195(32, 74, ' logotexnia poiisi'),
196(33, 74, ' logotexnia poiisi'),
197(34, 67, ' komics'),
198(35, 67, ' komics');
199
200-- --------------------------------------------------------
201
202--
203-- Δομή Πίνακα για τον Πίνακα `paragelia`
204--
205
206DROP TABLE IF EXISTS `paragelia`;
207CREATE TABLE IF NOT EXISTS `paragelia` (
208 `id_order` int(20) NOT NULL AUTO_INCREMENT,
209 `id_dosolipsia` int(20) NOT NULL,
210 `id_book` int(20) NOT NULL,
211 `price` double NOT NULL,
212 `quantity` int(20) NOT NULL,
213 PRIMARY KEY (`id_order`),
214 KEY `id_dosolipsia` (`id_dosolipsia`),
215 KEY `id_book` (`id_book`)
216) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Πίνακας παραγγελιών' AUTO_INCREMENT=1 ;
217
218--
219-- Άδειασμα δεδομένων του πίνακα `paragelia`
220--
221
222
223-- --------------------------------------------------------
224
225--
226-- Δομή Πίνακα για τον Πίνακα `sale_books`
227--
228
229DROP TABLE IF EXISTS `sale_books`;
230CREATE TABLE IF NOT EXISTS `sale_books` (
231 `id_book` int(20) NOT NULL AUTO_INCREMENT,
232 `title` varchar(50) NOT NULL,
233 `name_author` varchar(50) NOT NULL,
234 `publisher` varchar(50) NOT NULL,
235 `date_publish` year(4) NOT NULL,
236 `price` double NOT NULL,
237 `quantity` int(20) NOT NULL,
238 PRIMARY KEY (`id_book`)
239) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Πίνακας στοιχείων βιβλίων προς πώληση' AUTO_INCREMENT=12 ;
240
241--
242-- Άδειασμα δεδομένων του πίνακα `sale_books`
243--
244
245INSERT INTO `sale_books` (`id_book`, `title`, `name_author`, `publisher`, `date_publish`, `price`, `quantity`) VALUES
246(1, '', '', '', 2000, 0, 0),
247(2, 'nikos', 'ego', 'ego pali', 2000, 23, 1),
248(3, 'nikos', 'ego', 'ego pali', 2000, 23, 1),
249(4, 'nikos', 'ego', 'ego pali', 2000, 23, 1),
250(5, 'nikos', 'ego', 'ego pali', 2000, 23, 1),
251(6, 'nikos', 'ego', 'ego pali', 2000, 23, 1),
252(7, 'nikos', 'ego', 'ego pali', 2011, 23, 1),
253(8, 'ena paidi metraei ta astra', 'menelaos lountemis', 'kerdos', 1995, 12, 2),
254(9, 'ena paidi metraei ta astra', 'menelaos lountemis', 'kerdos', 0000, 25, 6),
255(10, 'ena paidi metraei ta astra', 'menelaos lountemis', 'kerdos', 1981, 25, 6),
256(11, '', '', '', 0000, 0, 0);
257
258-- --------------------------------------------------------
259
260--
261-- Δομή Πίνακα για τον Πίνακα `traders`
262--
263
264DROP TABLE IF EXISTS `traders`;
265CREATE TABLE IF NOT EXISTS `traders` (
266 `id_trader` int(20) NOT NULL AUTO_INCREMENT,
267 `name` varchar(20) NOT NULL,
268 `address` varchar(20) NOT NULL,
269 `post_code` int(20) NOT NULL,
270 `city` varchar(50) NOT NULL,
271 `telephone` int(20) NOT NULL,
272 `email` varchar(20) NOT NULL,
273 `number_account` int(20) NOT NULL,
274 `amount` int(20) NOT NULL,
275 `ofeiles` double NOT NULL,
276 `discount` int(20) NOT NULL,
277 `name_bank` varchar(50) NOT NULL,
278 `bank_account` int(20) NOT NULL,
279 PRIMARY KEY (`id_trader`)
280) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Πίνακας εμπόρων' AUTO_INCREMENT=33 ;
281
282--
283-- Άδειασμα δεδομένων του πίνακα `traders`
284--
285
286INSERT INTO `traders` (`id_trader`, `name`, `address`, `post_code`, `city`, `telephone`, `email`, `number_account`, `amount`, `ofeiles`, `discount`, `name_bank`, `bank_account`) VALUES
287(1, 'nikos maridakis', 'ivis 4', 45678, 'heraklion', 2147483647, 'gurunick@hotmail,com', 0, 0, 0, 0, '', 0),
288(2, 'nikos maridakis', 'ivis 4', 45678, 'heraklion', 2147483647, 'gurunick@hotmail,com', 0, 0, 0, 0, '', 0),
289(3, 'nikos maridakis', 'ivis 4', 45678, 'heraklion', 2147483647, 'gurunick@hotmail,com', 0, 0, 0, 0, '', 0),
290(4, 'nikos maridakis', 'ivis 4', 45678, 'heraklion', 2147483647, 'gurunick@hotmail,com', 0, 0, 0, 0, '', 0),
291(5, 'nikos maridakis', 'ivis 4', 45678, 'heraklion', 2147483647, 'gurunick@hotmail,com', 0, 0, 0, 0, '', 0),
292(9, 'frgffdgdggd', 'jjjjjjjjjjjk', 0, 'kkkkkkkk', 0, 'ppppppp', 0, 0, 88888888, 8, '88888888', 88888888),
293(10, 'nikos maridakis', 'ivis 4', 45109, 'heraklion', 2147483647, 'gurunick@hotmail,com', 0, 0, 0, 10, 'eurobank', 2147483647),
294(11, 'nikos maridakis', 'ivis 4', 45109, 'heraklion', 2147483647, 'gurunick@hotmail,com', 0, 0, 67, 10, 'eurobank', 2147483647),
295(12, 'nikos maridakis', 'ivis 4', 45109, 'heraklion', 2147483647, 'gurunick@hotmail,com', 0, 0, 67, 10, 'eurobank', 2147483647),
296(14, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2147483647, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 2147483647),
297(15, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2147483647, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 2147483647),
298(17, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2147483647, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 2147483647),
299(18, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2147483647, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 16500000),
300(19, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2147483647, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 16500000),
301(20, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 0, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 16500000),
302(21, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2374844, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 16500000),
303(22, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2374844, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 16500000),
304(23, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2374844, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 16500000),
305(24, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2374844, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 16500000),
306(25, 'nikos maridakis', 'ivis 4', 45709, 'heraklion', 2374844, 'maridak@hotmail.com', 2, 0, 0, 0, 'city bank', 16500000),
307(26, '', '', 0, 'retee', 0, '', 0, 0, 0, 0, '', 0),
308(27, '', '', 0, '', 0, '', 0, 0, 0, 0, '', 0),
309(28, '', '', 0, '', 0, '', 0, 0, 0, 0, '', 0),
310(29, '', '', 0, '', 0, '', 0, 0, 0, 0, '', 0),
311(30, 'maridakis pantelis', 'skaltsouni 6', 45167, 'heraklion', 2147483647, 'maridak@hotmail.com', 999, 0, 100, 5, 'geniki bank', 2147483647),
312(31, '', '', 0, '', 0, '', 0, 0, 0, 0, '', 0),
313(32, 'pantelis papadakis', 'knossou 5', 71409, 'heraklion', 2147483647, 'ppadak@msn.com', 69, 23, 12, 0, 'geniki bank', 123456789);
314
315--
316-- Περιορισμοί για άχρηστους πίνακες
317--
318
319--
320-- Περιορισμοί για πίνακα `dosolipsies_customer`
321--
322ALTER TABLE `dosolipsies_customer`
323 ADD CONSTRAINT `dosolipsies_customer_ibfk_1` FOREIGN KEY (`id_customer`) REFERENCES `customers` (`id_customer`);
324
325--
326-- Περιορισμοί για πίνακα `dosolipsies_trader`
327--
328ALTER TABLE `dosolipsies_trader`
329 ADD CONSTRAINT `dosolipsies_trader_ibfk_1` FOREIGN KEY (`id_trader`) REFERENCES `traders` (`id_trader`);
330
331--
332-- Περιορισμοί για πίνακα `eksoflisi_xreous`
333--
334ALTER TABLE `eksoflisi_xreous`
335 ADD CONSTRAINT `eksoflisi_xreous_ibfk_1` FOREIGN KEY (`id_trader`) REFERENCES `traders` (`id_trader`);
336
337--
338-- Περιορισμοί για πίνακα `interests_customers`
339--
340ALTER TABLE `interests_customers`
341 ADD CONSTRAINT `interests_customers_ibfk_1` FOREIGN KEY (`id_customer`) REFERENCES `customers` (`id_customer`);
342
343--
344-- Περιορισμοί για πίνακα `paragelia`
345--
346ALTER TABLE `paragelia`
347 ADD CONSTRAINT `paragelia_ibfk_1` FOREIGN KEY (`id_dosolipsia`) REFERENCES `dosolipsies_customer` (`id_dosolipsia`),
348 ADD CONSTRAINT `paragelia_ibfk_2` FOREIGN KEY (`id_book`) REFERENCES `sale_books` (`id_book`);