· 8 years ago · Jul 04, 2018, 04:08 AM
1CREATE DATABASE IF NOT EXISTS `sex_shop` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `sex_shop`;
3-- MySQL dump 10.13 Distrib 5.5.16, for Win32 (x86)
4--
5-- Host: 127.0.0.1 Database: sex_shop
6-- ------------------------------------------------------
7-- Server version 5.5.21
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `faturacao`
22--
23
24DROP TABLE IF EXISTS `faturacao`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `faturacao` (
28 `IDFATURACAO` int(11) NOT NULL AUTO_INCREMENT,
29 `IDCLIENTES` int(11) NOT NULL,
30 `DATA` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
31 `IDPAGAMENTOS` int(11) NOT NULL,
32 `IDEMPRESAS` int(11) NOT NULL,
33 `ESTADO` bit(1) NOT NULL DEFAULT b'1',
34 PRIMARY KEY (`IDFATURACAO`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `faturacao`
40--
41
42LOCK TABLES `faturacao` WRITE;
43/*!40000 ALTER TABLE `faturacao` DISABLE KEYS */;
44/*!40000 ALTER TABLE `faturacao` ENABLE KEYS */;
45UNLOCK TABLES;
46
47--
48-- Table structure for table `paises`
49--
50
51DROP TABLE IF EXISTS `paises`;
52/*!40101 SET @saved_cs_client = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `paises` (
55 `IDPAIS` int(11) NOT NULL,
56 `NOME` varchar(50) NOT NULL,
57 PRIMARY KEY (`IDPAIS`)
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59/*!40101 SET character_set_client = @saved_cs_client */;
60
61--
62-- Dumping data for table `paises`
63--
64
65LOCK TABLES `paises` WRITE;
66/*!40000 ALTER TABLE `paises` DISABLE KEYS */;
67/*!40000 ALTER TABLE `paises` ENABLE KEYS */;
68UNLOCK TABLES;
69
70--
71-- Table structure for table `encomendas`
72--
73
74DROP TABLE IF EXISTS `encomendas`;
75/*!40101 SET @saved_cs_client = @@character_set_client */;
76/*!40101 SET character_set_client = utf8 */;
77CREATE TABLE `encomendas` (
78 `IDENCOMENDAS` int(11) NOT NULL AUTO_INCREMENT,
79 `IDCLIENTES` int(11) NOT NULL,
80 `OCORRENCIA` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
81 `GUIA_TRANSPORTADORA` varchar(45) DEFAULT NULL,
82 `IDTRANSPORTADORA` int(11) DEFAULT NULL,
83 PRIMARY KEY (`IDENCOMENDAS`),
84 UNIQUE KEY `GUIA_TRANSPORTADORA_UNIQUE` (`GUIA_TRANSPORTADORA`)
85) ENGINE=InnoDB DEFAULT CHARSET=utf8;
86/*!40101 SET character_set_client = @saved_cs_client */;
87
88--
89-- Dumping data for table `encomendas`
90--
91
92LOCK TABLES `encomendas` WRITE;
93/*!40000 ALTER TABLE `encomendas` DISABLE KEYS */;
94/*!40000 ALTER TABLE `encomendas` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `taxas_iva`
99--
100
101DROP TABLE IF EXISTS `taxas_iva`;
102/*!40101 SET @saved_cs_client = @@character_set_client */;
103/*!40101 SET character_set_client = utf8 */;
104CREATE TABLE `taxas_iva` (
105 `IDTAXAS_IVA` int(11) NOT NULL AUTO_INCREMENT,
106 `TAXA` decimal(5,2) NOT NULL,
107 PRIMARY KEY (`IDTAXAS_IVA`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8;
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Dumping data for table `taxas_iva`
113--
114
115LOCK TABLES `taxas_iva` WRITE;
116/*!40000 ALTER TABLE `taxas_iva` DISABLE KEYS */;
117/*!40000 ALTER TABLE `taxas_iva` ENABLE KEYS */;
118UNLOCK TABLES;
119
120--
121-- Table structure for table `faturacao_itens`
122--
123
124DROP TABLE IF EXISTS `faturacao_itens`;
125/*!40101 SET @saved_cs_client = @@character_set_client */;
126/*!40101 SET character_set_client = utf8 */;
127CREATE TABLE `faturacao_itens` (
128 `IDFATURACAO_ITENS` int(11) NOT NULL AUTO_INCREMENT,
129 `IDENCOMENDAS_ITENS` int(11) NOT NULL,
130 `QTD` smallint(6) NOT NULL DEFAULT '1',
131 PRIMARY KEY (`IDFATURACAO_ITENS`)
132) ENGINE=InnoDB DEFAULT CHARSET=utf8;
133/*!40101 SET character_set_client = @saved_cs_client */;
134
135--
136-- Dumping data for table `faturacao_itens`
137--
138
139LOCK TABLES `faturacao_itens` WRITE;
140/*!40000 ALTER TABLE `faturacao_itens` DISABLE KEYS */;
141/*!40000 ALTER TABLE `faturacao_itens` ENABLE KEYS */;
142UNLOCK TABLES;
143
144--
145-- Table structure for table `marcas`
146--
147
148DROP TABLE IF EXISTS `marcas`;
149/*!40101 SET @saved_cs_client = @@character_set_client */;
150/*!40101 SET character_set_client = utf8 */;
151CREATE TABLE `marcas` (
152 `IDMARCAS` int(11) NOT NULL AUTO_INCREMENT,
153 `NOME` varchar(45) NOT NULL,
154 PRIMARY KEY (`IDMARCAS`)
155) ENGINE=InnoDB DEFAULT CHARSET=utf8;
156/*!40101 SET character_set_client = @saved_cs_client */;
157
158--
159-- Dumping data for table `marcas`
160--
161
162LOCK TABLES `marcas` WRITE;
163/*!40000 ALTER TABLE `marcas` DISABLE KEYS */;
164/*!40000 ALTER TABLE `marcas` ENABLE KEYS */;
165UNLOCK TABLES;
166
167--
168-- Table structure for table `transportadoras`
169--
170
171DROP TABLE IF EXISTS `transportadoras`;
172/*!40101 SET @saved_cs_client = @@character_set_client */;
173/*!40101 SET character_set_client = utf8 */;
174CREATE TABLE `transportadoras` (
175 `IDTRANSPORTADORAS` int(11) NOT NULL AUTO_INCREMENT,
176 `NOME` varchar(45) NOT NULL,
177 PRIMARY KEY (`IDTRANSPORTADORAS`)
178) ENGINE=InnoDB DEFAULT CHARSET=utf8;
179/*!40101 SET character_set_client = @saved_cs_client */;
180
181--
182-- Dumping data for table `transportadoras`
183--
184
185LOCK TABLES `transportadoras` WRITE;
186/*!40000 ALTER TABLE `transportadoras` DISABLE KEYS */;
187/*!40000 ALTER TABLE `transportadoras` ENABLE KEYS */;
188UNLOCK TABLES;
189
190--
191-- Table structure for table `empresas`
192--
193
194DROP TABLE IF EXISTS `empresas`;
195/*!40101 SET @saved_cs_client = @@character_set_client */;
196/*!40101 SET character_set_client = utf8 */;
197CREATE TABLE `empresas` (
198 `IDEMPRESAS` int(11) NOT NULL AUTO_INCREMENT,
199 `NOME` varchar(150) NOT NULL,
200 `MORADA` varchar(100) NOT NULL,
201 `CP` varchar(12) DEFAULT NULL,
202 `LOCALIDADE` varchar(50) NOT NULL,
203 `IDPAIS` int(11) NOT NULL,
204 `NIF` varchar(15) NOT NULL,
205 `COM_IMAGEM` bit(1) NOT NULL DEFAULT b'0',
206 `EMAIL` varchar(45) DEFAULT NULL,
207 `TELEFONE` varchar(15) DEFAULT NULL,
208 `CAPITAL_SOCIAL` int(11) DEFAULT NULL,
209 `CONSERVATORIA` varchar(75) DEFAULT NULL,
210 `SITIO` varchar(45) DEFAULT NULL,
211 `IDMOEDA` int(11) NOT NULL DEFAULT '1',
212 PRIMARY KEY (`IDEMPRESAS`)
213) ENGINE=InnoDB DEFAULT CHARSET=utf8;
214/*!40101 SET character_set_client = @saved_cs_client */;
215
216--
217-- Dumping data for table `empresas`
218--
219
220LOCK TABLES `empresas` WRITE;
221/*!40000 ALTER TABLE `empresas` DISABLE KEYS */;
222/*!40000 ALTER TABLE `empresas` ENABLE KEYS */;
223UNLOCK TABLES;
224
225--
226-- Table structure for table `clientes`
227--
228
229DROP TABLE IF EXISTS `clientes`;
230/*!40101 SET @saved_cs_client = @@character_set_client */;
231/*!40101 SET character_set_client = utf8 */;
232CREATE TABLE `clientes` (
233 `IDCLIENTES` int(11) NOT NULL AUTO_INCREMENT,
234 `NOME` varchar(150) NOT NULL,
235 `MORADA` varchar(150) NOT NULL,
236 `CP` varchar(12) DEFAULT NULL,
237 `LOCALIDADE` varchar(25) NOT NULL,
238 `IDPAIS` int(11) NOT NULL DEFAULT '351',
239 `EMAIL` varchar(45) NOT NULL,
240 `SEXO` bit(1) NOT NULL DEFAULT b'0',
241 `NIF` varchar(20) DEFAULT NULL,
242 `ANTIGUIDADE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
243 `PALAVRA_CHAVE` varchar(15) NOT NULL,
244 PRIMARY KEY (`IDCLIENTES`),
245 UNIQUE KEY `EMAIL_UNIQUE` (`EMAIL`),
246 UNIQUE KEY `NIF_UNIQUE` (`NIF`)
247) ENGINE=InnoDB DEFAULT CHARSET=utf8;
248/*!40101 SET character_set_client = @saved_cs_client */;
249
250--
251-- Dumping data for table `clientes`
252--
253
254LOCK TABLES `clientes` WRITE;
255/*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
256/*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
257UNLOCK TABLES;
258
259--
260-- Table structure for table `produtos`
261--
262
263DROP TABLE IF EXISTS `produtos`;
264/*!40101 SET @saved_cs_client = @@character_set_client */;
265/*!40101 SET character_set_client = utf8 */;
266CREATE TABLE `produtos` (
267 `IDPRODUTOS` int(11) NOT NULL AUTO_INCREMENT,
268 `CODIGO` varchar(100) DEFAULT NULL,
269 `DESCRICAO` blob NOT NULL,
270 `PVP` decimal(10,2) NOT NULL,
271 `IDMARCA` int(11) NOT NULL,
272 `COM_FOTO` bit(1) NOT NULL DEFAULT b'0',
273 `ESTADO` bit(1) NOT NULL DEFAULT b'1',
274 `IDIVA` int(11) NOT NULL,
275 `PESO` int(11) DEFAULT NULL,
276 `SERVICO` bit(1) DEFAULT b'0',
277 PRIMARY KEY (`IDPRODUTOS`)
278) ENGINE=InnoDB DEFAULT CHARSET=utf8;
279/*!40101 SET character_set_client = @saved_cs_client */;
280
281--
282-- Dumping data for table `produtos`
283--
284
285LOCK TABLES `produtos` WRITE;
286/*!40000 ALTER TABLE `produtos` DISABLE KEYS */;
287/*!40000 ALTER TABLE `produtos` ENABLE KEYS */;
288UNLOCK TABLES;
289
290--
291-- Table structure for table `numeros_serie`
292--
293
294DROP TABLE IF EXISTS `numeros_serie`;
295/*!40101 SET @saved_cs_client = @@character_set_client */;
296/*!40101 SET character_set_client = utf8 */;
297CREATE TABLE `numeros_serie` (
298 `IDNUMEROS_SERIE` int(11) NOT NULL AUTO_INCREMENT,
299 `IDPRODUTOS` int(11) NOT NULL,
300 `NUMERO_SERIE` varchar(75) NOT NULL,
301 `IDFATURACAO_ITENS` int(11) NOT NULL,
302 PRIMARY KEY (`IDNUMEROS_SERIE`)
303) ENGINE=InnoDB DEFAULT CHARSET=utf8;
304/*!40101 SET character_set_client = @saved_cs_client */;
305
306--
307-- Dumping data for table `numeros_serie`
308--
309
310LOCK TABLES `numeros_serie` WRITE;
311/*!40000 ALTER TABLE `numeros_serie` DISABLE KEYS */;
312/*!40000 ALTER TABLE `numeros_serie` ENABLE KEYS */;
313UNLOCK TABLES;
314
315--
316-- Table structure for table `moedas`
317--
318
319DROP TABLE IF EXISTS `moedas`;
320/*!40101 SET @saved_cs_client = @@character_set_client */;
321/*!40101 SET character_set_client = utf8 */;
322CREATE TABLE `moedas` (
323 `IDMOEDAS` int(11) NOT NULL,
324 `NOME` varchar(3) NOT NULL,
325 PRIMARY KEY (`IDMOEDAS`)
326) ENGINE=InnoDB DEFAULT CHARSET=utf8;
327/*!40101 SET character_set_client = @saved_cs_client */;
328
329--
330-- Dumping data for table `moedas`
331--
332
333LOCK TABLES `moedas` WRITE;
334/*!40000 ALTER TABLE `moedas` DISABLE KEYS */;
335/*!40000 ALTER TABLE `moedas` ENABLE KEYS */;
336UNLOCK TABLES;
337
338--
339-- Table structure for table `encomendas_itens`
340--
341
342DROP TABLE IF EXISTS `encomendas_itens`;
343/*!40101 SET @saved_cs_client = @@character_set_client */;
344/*!40101 SET character_set_client = utf8 */;
345CREATE TABLE `encomendas_itens` (
346 `IDENCOMENDAS_ITENS` bigint(20) NOT NULL AUTO_INCREMENT,
347 `IDPRODUTOS` int(11) NOT NULL,
348 `IDENCOMENDAS` int(11) NOT NULL,
349 `QTD` smallint(6) NOT NULL DEFAULT '1',
350 `IDDESCONTO` int(11) DEFAULT NULL,
351 PRIMARY KEY (`IDENCOMENDAS_ITENS`)
352) ENGINE=InnoDB DEFAULT CHARSET=utf8;
353/*!40101 SET character_set_client = @saved_cs_client */;
354
355--
356-- Dumping data for table `encomendas_itens`
357--
358
359LOCK TABLES `encomendas_itens` WRITE;
360/*!40000 ALTER TABLE `encomendas_itens` DISABLE KEYS */;
361/*!40000 ALTER TABLE `encomendas_itens` ENABLE KEYS */;
362UNLOCK TABLES;
363/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
364
365/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
366/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
367/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
368/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
369/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
370/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
371/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
372
373-- Dump completed on 2012-03-09 12:20:39