· 9 years ago · Jan 18, 2017, 10:14 PM
1-- phpMyAdmin SQL Dump
2-- version 4.5.2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Creato il: Gen 18, 2017 alle 23:04
7-- Versione del server: 10.1.16-MariaDB
8-- Versione PHP: 5.6.24
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `web_design`
21--
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `web_design` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `web_design`;
25-- --------------------------------------------------------
26--
27-- Struttura della tabella `Books`
28--
29DROP TABLE IF EXISTS `Books`
30CREATE TABLE `Books` (
31 `isbn` bigint(13) UNSIGNED NOT NULL,
32 `title` varchar(255) CHARACTER SET ascii NOT NULL,
33 `author` varchar(255) DEFAULT NULL,
34 `year` year(4) NOT NULL,
35 `format` enum('Book','eBook') NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38--
39-- Dump dei dati per la tabella `Books`
40--
41
42INSERT INTO `Books` (`isbn`, `title`, `author`, `year`, `format`) VALUES
43(9780132126953, 'Computer Networks - Fifth Edition', 'Andrew S. Tanenbaum', 2011, 'eBook'),
44(9788845249570, 'Come trattare gli altri e farseli amici', 'Dale Carnegie', 2001, 'Book'),
45(9788891159342, 'Pronti in sella', 'Antonino Latocca', 2014, 'Book'),
46(9788891172358, 'Pronti in sella', 'Antonino Latocca', 2015, 'eBook'),
47(9788891178695, 'Pronti in sella - Seconda Edizione', 'Antonino Latocca', 2015, 'Book'),
48(9788891180285, 'Pronti in sella - Seconda Edizione', 'Antonino Latocca', 2015, 'eBook'),
49(9788893210683, 'Pronti in sella - Terza Edizione', 'Antonino Latocca', 2015, 'Book'),
50(9788893214339, 'Pronti in sella - Terza Edizione', 'Antonino Latocca', 2015, 'eBook'),
51(9788897436409, 'La nuova stagione', 'Antonino Latocca', 2010, 'Book'),
52(9788897436515, 'Sognistica, dai sogni alle storie', 'Antonino Latocca', 2011, 'eBook');
53
54-- --------------------------------------------------------
55
56--
57-- Struttura della tabella `Reviews`
58--
59DROP TABLE IF EXISTS `Reviews`
60CREATE TABLE `Reviews` (
61 `id` int(10) UNSIGNED NOT NULL,
62 `user` int(11) NOT NULL,
63 `book` bigint(20) NOT NULL,
64 `title` varchar(200) NOT NULL,
65 `date` datetime NOT NULL,
66 `vote` enum('1','2','3','4','5') NOT NULL,
67 `comment` text NOT NULL
68) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69
70--
71-- Dump dei dati per la tabella `Reviews`
72--
73
74INSERT INTO `Reviews` (`id`, `user`, `book`, `title`, `date`, `vote`, `comment`) VALUES
75(1, 1, 9788893210683, 'A complete manual', '2016-11-08 13:33:10', '3', 'This is the best version never published'),
76(2, 1, 9788845249570, 'A life''s manual', '2016-11-15 18:45:16', '5', 'This book is really fantastic because it help to make an good relationship with each other people around us.');
77
78-- --------------------------------------------------------
79
80--
81-- Struttura della tabella `Users`
82--
83DROP TABLE IF EXISTS `Users`
84CREATE TABLE `Users` (
85 `id` int(11) NOT NULL,
86 `username` varchar(50) NOT NULL,
87 `email` varchar(80) NOT NULL,
88 `password` varchar(32) NOT NULL,
89 `genre` enum('M','F') NOT NULL DEFAULT 'M',
90 `birthDate` date NOT NULL,
91 `country` varchar(3) DEFAULT NULL
92) ENGINE=InnoDB DEFAULT CHARSET=latin1;
93
94--
95-- Dump dei dati per la tabella `Users`
96--
97
98INSERT INTO `Users` (`id`, `username`, `email`, `password`, `genre`, `birthDate`, `country`) VALUES
99(1, 'antonino', 'ant.soix@live.it', 'e792cd9665119b1244e8afcf36fb5f48', 'M', '1985-03-11', 'ITA');
100
101--
102-- Indici per le tabelle scaricate
103--
104
105--
106-- Indici per le tabelle `Books`
107--
108ALTER TABLE `Books`
109 ADD PRIMARY KEY (`isbn`),
110 ADD UNIQUE KEY `isbn` (`isbn`);
111
112--
113-- Indici per le tabelle `Reviews`
114--
115ALTER TABLE `Reviews`
116 ADD PRIMARY KEY (`id`),
117 ADD UNIQUE KEY `id` (`id`);
118
119--
120-- Indici per le tabelle `Users`
121--
122ALTER TABLE `Users`
123 ADD PRIMARY KEY (`id`),
124 ADD UNIQUE KEY `username` (`username`),
125 ADD UNIQUE KEY `id` (`id`);
126
127--
128-- AUTO_INCREMENT per le tabelle scaricate
129--
130
131--
132-- AUTO_INCREMENT per la tabella `Reviews`
133--
134ALTER TABLE `Reviews`
135 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
136--
137-- AUTO_INCREMENT per la tabella `Users`
138--
139ALTER TABLE `Users`
140 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
141/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
142/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
143/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;