· 6 years ago · Jun 02, 2019, 02:52 AM
1██████╗ ███████╗███╗ ███╗ ██████╗ ███╗ ██╗███████╗ █████╗ ██████╗
2██╔══██╗██╔════╝████╗ ████║██╔═══██╗████╗ ██║██╔════╝██╔══██╗██╔══██╗
3██║ ██║█████╗ ██╔████╔██║██║ ██║██╔██╗ ██║███████╗███████║██║ ██║
4██║ ██║██╔══╝ ██║╚██╔╝██║██║ ██║██║╚██╗██║╚════██║██╔══██║██║ ██║
5██████╔╝███████╗██║ ╚═╝ ██║╚██████╔╝██║ ╚████║███████║██║ ██║██████╔╝
6╚═════╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═══╝╚══════╝╚═╝ ╚═╝╚═════╝
7
8FAUSER HACKED BY : DEMONSAD
9
10Greetings : Tiosan , Angel Cracking , HaxStroke, Kami
11
12"BYE BYE ADMINS"
13---------------------------------------------------------------------------------------
14--
15-- Table structure for table `Auto`
16--
17
18CREATE TABLE IF NOT EXISTS `Auto` (
19 `ida` int(10) NOT NULL AUTO_INCREMENT,
20 `marca` varchar(60) NOT NULL,
21 `modello` varchar(20) NOT NULL,
22 `prezzo` int(8) NOT NULL,
23 `km` varchar(200) NOT NULL,
24 `annoimm` year(4) NOT NULL,
25 `dataannuncio` date NOT NULL,
26 `foto` varchar(200) NOT NULL,
27 `id_conc` int(100) NOT NULL,
28 PRIMARY KEY (`ida`),
29 KEY `id_conc` (`id_conc`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
31
32--
33-- Dumping data for table `Auto`
34--
35
36INSERT INTO `Auto` (`ida`, `marca`, `modello`, `prezzo`, `km`, `annoimm`, `dataannuncio`, `foto`, `id_conc`) VALUES
37(9, 'Honda', 'Jazz', 8000, '100000', 2001, '2015-03-10', '2.jpg', 1),
38(10, 'Audi', 'A8', 50000, '10000', 2011, '2015-02-17', '3.jpg', 2),
39(11, 'Ford', 'Fiesta', 1000, '200000', 1995, '2015-03-20', '3.jpg', 1);
40
41-- --------------------------------------------------------
42
43--
44-- Table structure for table `Concessionaria`
45--
46
47CREATE TABLE IF NOT EXISTS `Concessionaria` (
48 `id` int(100) NOT NULL AUTO_INCREMENT,
49 `nome` varchar(60) NOT NULL,
50 `via` varchar(100) NOT NULL,
51 `citta` varchar(60) NOT NULL,
52 PRIMARY KEY (`id`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
54
55--
56-- Dumping data for table `Concessionaria`
57--
58
59INSERT INTO `Concessionaria` (`id`, `nome`, `via`, `citta`) VALUES
60(1, 'Conc1', 'Via dei Mille', 'Novara'),
61(2, 'Conc2', 'Via Frua', 'Milano');
62
63-- --------------------------------------------------------
64
65--
66-- Table structure for table `Possiede`
67--
68
69CREATE TABLE IF NOT EXISTS `Possiede` (
70 `codprop` varchar(20) NOT NULL,
71 `codauto` int(10) NOT NULL,
72 PRIMARY KEY (`codprop`,`codauto`),
73 KEY `Codauto` (`codauto`)
74) ENGINE=InnoDB DEFAULT CHARSET=latin1;
75
76--
77-- Dumping data for table `Possiede`
78--
79
80INSERT INTO `Possiede` (`codprop`, `codauto`) VALUES
81('GHI789', 9),
82('ABC123', 10),
83('DEF456', 10),
84('HKL246', 11);
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `Proprietario`
90--
91
92CREATE TABLE IF NOT EXISTS `Proprietario` (
93 `CF` varchar(20) NOT NULL,
94 `nome` varchar(25) NOT NULL,
95 `cognome` varchar(25) NOT NULL,
96 `telefono` varchar(15) DEFAULT NULL,
97 `email` varchar(25) DEFAULT NULL,
98 PRIMARY KEY (`CF`)
99) ENGINE=InnoDB DEFAULT CHARSET=latin1;
100
101--
102-- Dumping data for table `Proprietario`
103--
104
105INSERT INTO `Proprietario` (`CF`, `nome`, `cognome`, `telefono`, `email`) VALUES
106('ABC123', 'Mario', 'Rossi', '123', '123@persona.it'),
107('DEF456', 'Maria', 'Bianchi', '456', '456@persona.it'),
108('GHI789', 'Pinco', 'Pallino', '789', '789@persona.it'),
109('HKL246', 'Ludmilla', 'Bella', NULL, NULL),
110('LMN901', 'Tizio', 'Caio', NULL, NULL),
111('XYZ135', 'Agenore', 'Brutto', NULL, NULL);
112
113-- --------------------------------------------------------
114
115--
116-- Table structure for table `Utenti`
117--
118
119CREATE TABLE IF NOT EXISTS `Utenti` (
120 `user` varchar(20) NOT NULL,
121 `password` varchar(100) NOT NULL,
122 `id_c` int(100) NOT NULL,
123 PRIMARY KEY (`user`),
124 KEY `id_c` (`id_c`)
125) ENGINE=InnoDB DEFAULT CHARSET=utf8;
126
127--
128-- Dumping data for table `Utenti`
129--
130
131INSERT INTO `Utenti` (`user`, `password`, `id_c`) VALUES
132('utente1', 'utente1', 1),
133('utente2', 'utente2', 2);
134
135--
136-- Constraints for dumped tables
137--
138
139--
140-- Constraints for table `Auto`
141--
142ALTER TABLE `Auto`
143 ADD CONSTRAINT `Auto_ibfk_1` FOREIGN KEY (`id_conc`) REFERENCES `Concessionaria` (`id`);
144
145--
146-- Constraints for table `Possiede`
147--
148ALTER TABLE `Possiede`
149 ADD CONSTRAINT `Possiede_ibfk_1` FOREIGN KEY (`codprop`) REFERENCES `Proprietario` (`CF`),
150 ADD CONSTRAINT `Possiede_ibfk_2` FOREIGN KEY (`codauto`) REFERENCES `Auto` (`ida`);
151
152--
153-- Constraints for table `Utenti`
154--
155ALTER TABLE `Utenti`
156 ADD CONSTRAINT `Utenti_ibfk_1` FOREIGN KEY (`id_c`) REFERENCES `Concessionaria` (`id`);