· 9 years ago · Nov 01, 2016, 10:08 PM
1
2
3CREATE TABLE IF NOT EXISTS `bairro` (
4 `bairro_id` int(11) NOT NULL AUTO_INCREMENT,
5 `bairro_nome` varchar(200) DEFAULT NULL,
6 `bairro_url` varchar(200) DEFAULT NULL,
7 `bairro_cidade` int(11) DEFAULT NULL,
8 PRIMARY KEY (`bairro_id`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=52 ;
10
11--
12-- Extraindo dados da tabela `bairro`
13--
14
15INSERT INTO `bairro` (`bairro_id`, `bairro_nome`, `bairro_url`, `bairro_cidade`) VALUES
16(14, 'Belas Artes', 'belas-artes', 17),
17(17, 'Cibratel II', 'cibratel-ii', 17),
18(18, 'Centro', 'centro', 11),
19(19, 'Vila Atlântica', 'vila-atlantica', 11),
20(20, 'Agenor de Campos', 'agenor-de-campos', 11),
21(24, 'Aviação', 'aviacao', 13),
22(25, 'Guilhermina', 'guilhermina', 13),
23(26, 'Beira Mar', 'beira-mar', 14),
24(28, 'Ilha Porchat', 'ilha-porchat', 14),
25(29, 'Encruzilhada', 'encruzilhada', 15),
26(30, 'Itararé', 'itarare', 15),
27(31, 'Embaré', 'embare', 15),
28(32, 'Gonzaga', 'gonzaga', 15),
29(42, 'Paquetá', 'paqueta', 14),
30(47, 'Pitangueiras', 'pitangueiras', 16),
31(48, 'Parque dos Pássaros', 'parque-dos-passaros', 22),
32(49, 'Parque dos Pássaros', 'parque-dos-passaros', 23),
33(50, 'teste44444', 'teste44444', 25),
34(51, 'Jabaquara', 'jabaquara', 24);
35
36
37
38
39CREATE TABLE IF NOT EXISTS `cidade` (
40 `cidade_id` int(11) NOT NULL AUTO_INCREMENT,
41 `cidade_nome` varchar(200) DEFAULT NULL,
42 `cidade_url` varchar(200) DEFAULT NULL,
43 PRIMARY KEY (`cidade_id`)
44) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
45
46
47
48INSERT INTO `cidade` (`cidade_id`, `cidade_nome`, `cidade_url`) VALUES
49(13, 'Praia Grande', 'praia-grande'),
50(14, 'São Vicente', 'sao-vicente'),
51(15, 'Santos', 'santos'),
52(16, 'Guarujá', 'guaruja'),
53(23, 'Santo André', 'santo-andre'),
54(24, 'São Paulo', 'sao-paulo');
55
56
57
58CREATE TABLE IF NOT EXISTS `config` (
59 `config_id` int(11) NOT NULL AUTO_INCREMENT,
60 `config_nome` varchar(200) DEFAULT NULL,
61 `config_logo` varchar(200) DEFAULT NULL,
62 `config_desc` longtext,
63 `config_horario` varchar(200) DEFAULT NULL,
64 `config_aberto` int(1) DEFAULT '1',
65 `config_entrega` varchar(200) DEFAULT NULL,
66 `config_taxa_entrega` double(10,2) DEFAULT NULL,
67 `config_fone1` varchar(200) DEFAULT NULL,
68 `config_fone2` varchar(200) DEFAULT NULL,
69 `config_fone3` varchar(200) DEFAULT NULL,
70 `config_end` varchar(600) DEFAULT NULL,
71 `config_lat` varchar(200) DEFAULT NULL,
72 `config_lon` varchar(200) DEFAULT NULL,
73 `config_foto` varchar(200) DEFAULT NULL,
74 `config_marca` varchar(200) DEFAULT NULL,
75 `config_titulo` varchar(200) DEFAULT NULL,
76 `config_obs` longtext,
77 `config_color` varchar(200) DEFAULT 'blue',
78 `config_detalhe_recente` int(11) DEFAULT '12',
79 `config_detalhe_vende` int(11) DEFAULT '30',
80 `config_detalhe_aluga` int(11) DEFAULT '12',
81 `config_email` varchar(200) DEFAULT NULL,
82 `config_seo_desc` longtext,
83 `config_seo_keys` longtext,
84 `config_ga` longtext,
85 `config_blog_paginacao` int(11) DEFAULT NULL,
86 `config_seo_cliente` text,
87 `config_foto_left` varchar(20) NOT NULL DEFAULT '0',
88 `config_foto_top` varchar(20) NOT NULL DEFAULT '0',
89 `config_seo_autor` varchar(200) DEFAULT NULL,
90 `config_icon` varchar(200) DEFAULT NULL,
91 `config_key_map` varchar(200) DEFAULT NULL,
92 `config_chat` longtext,
93 PRIMARY KEY (`config_id`)
94) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
95
96--
97-- Extraindo dados da tabela `config`
98--
99
100INSERT INTO `config` (`config_id`, `config_nome`, `config_logo`, `config_desc`, `config_horario`, `config_aberto`, `config_entrega`, `config_taxa_entrega`, `config_fone1`, `config_fone2`, `config_fone3`, `config_end`, `config_lat`, `config_lon`, `config_foto`, `config_marca`, `config_titulo`, `config_obs`, `config_color`, `config_detalhe_recente`, `config_detalhe_vende`, `config_detalhe_aluga`, `config_email`, `config_seo_desc`, `config_seo_keys`, `config_ga`, `config_blog_paginacao`, `config_seo_cliente`, `config_foto_left`, `config_foto_top`, `config_seo_autor`, `config_icon`, `config_key_map`, `config_chat`) VALUES
101(1, 'Imobiliária V4', NULL, 'Olá somos a Imobilária Versão 4 - Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', '19:00 às 03:00 hrs de Segunda a Sábado', 1, '45-60 min', 4.00, '(11) 5555-5555', '(11) 9999-9999', '(11) 8888-8888', 'Av. São Paulo, 1000, Praia Grande, São Paulo-SP', '-24.0044174', '-46.4197163', 'logo-png_1468924856.png', 'logomakr-2-png_1471006544.png', NULL, NULL, 'brown', 4, 30, 12, 'contato@phpstaff.com.br', 'Imobiliária V4 - PHPSTAFF', 'script pronto, suporte gratis,imobiliaria, script gratis,templete,php,script,script barato,comprar script,scripts no brasil', '(function(i,s,o,g,r,a,m){i[''GoogleAnalyticsObject'']=r;i[r]=i[r]||function(){\r\n (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),\r\n m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)\r\n })(window,document,''script'',''https://www.google-analytics.com/analytics.js'',''ga'');\r\n\r\n ga(''create'', ''UA-79256949-1'', ''auto'');\r\n ga(''send'', ''pageview'');', 4, '19489459164-966udcgvpd7lmp2n1n9s4mbc2an8o9v9.apps.googleusercontent.com', '-22', '5', 'PHPSTAFF', '1468640111-folder-image-png_1468611756.png', 'AIzaSyCTZ6H9wX8w9N_n8uN1G3BGkkdiK-TnxdQ', '<!--Start of Zopim Live Chat Script-->\r\n<script type="text/javascript">\r\nwindow.$zopim||(function(d,s){var z=$zopim=function(c){z._.push(c)},$=z.s=\r\nd.createElement(s),e=d.getElementsByTagName(s)[0];z.set=function(o){z.set.\r\n_.push(o)};z._=[];z.set._=[];$.async=!0;$.setAttribute("charset","utf-8");\r\n$.src="//v2.zopim.com/?4AXlwIeKvFnaMzNbtWl6gOd66GU8exk9";z.t=+new Date;$.\r\ntype="text/javascript";e.parentNode.insertBefore($,e)})(document,"script");\r\n</script>\r\n<!--End of Zopim Live Chat Script-->');
102
103-- --------------------------------------------------------
104
105--
106-- Estrutura da tabela `contato`
107--
108
109CREATE TABLE IF NOT EXISTS `contato` (
110 `contato_id` int(11) NOT NULL AUTO_INCREMENT,
111 `contato_nome` varchar(200) DEFAULT NULL,
112 `contato_foto` varchar(200) DEFAULT NULL,
113 `contato_desc` longtext,
114 PRIMARY KEY (`contato_id`)
115) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
116
117--
118-- Extraindo dados da tabela `contato`
119--
120
121INSERT INTO `contato` (`contato_id`, `contato_nome`, `contato_foto`, `contato_desc`) VALUES
122(1, 'Não hesite em contactar-nos.', 'img01-jpg-1462283903-jpg_1468599383.jpg', '<br class="Apple-interchange-newline"><span style="color: rgb(33, 33, 33); font-family: arial, sans-serif; font-size: 16px; line-height: 24px; white-space: pre-wrap;">... Entre em contato, preencha o formulário abaixo .</span><br>');
123
124
125
126CREATE TABLE IF NOT EXISTS `foto` (
127 `foto_id` int(11) NOT NULL AUTO_INCREMENT,
128 `foto_url` varchar(200) DEFAULT NULL,
129 `foto_imovel` int(11) DEFAULT NULL,
130 `foto_pos` int(11) DEFAULT '99',
131 PRIMARY KEY (`foto_id`)
132) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=86 ;
133
134--
135-- Extraindo dados da tabela `foto`
136--
137
138INSERT INTO `foto` (`foto_id`, `foto_url`, `foto_imovel`, `foto_pos`) VALUES
139(13, 'maravilhosa-casa-alphaville-salvador-38-jpg_1465475181.jpg', 4, 27),
140(14, 'santos-jpg_1465475289.jpg', 5, 0),
141(15, 'sam-2082-jpg_1465475291.JPG', 5, 2),
142(16, 'captura-de-tela-2013-03-31-as-03-06-021-png_1465475297.png', 5, 1),
143(17, 'fachadas-de-casa-minimalistas-1-jpg_1465476555.jpg', 6, 22),
144(18, '0-jpg_1465476559.jpg', 6, 21),
145(19, 'kensington-01-1150x836-jpg_1465476579.jpg', 6, 20),
146(20, 'conceito04-1024x777-jpg_1465476728.jpg', 7, 29),
147(21, 'maravilhosa-casa-alphaville-salvador-38-jpg_1465476742.jpg', 7, 30),
148(22, '2-dorms-sala-de-estar-decorado-residencial-hub-home-tecnisa-rearden-imoveis-curitiba-apartamento-jpg_1465477206.jpg', 7, 38),
149(23, 'fachadas-casas-muro-portao-11-jpg_1465477337.jpg', 8, 39),
150(24, '130273822543856988-666x600-living-do-apartamento-decorado-jpg_1465477342.jpg', 8, 36),
151(25, 'quarto-de-casal-jpg_1465477373.jpg', 8, 35),
152(31, 'fachadas-de-casas-bonitas4-jpg_1465478408.jpg', 10, 34),
153(32, 'apartamento-brooklyn-png_1465478423.png', 10, 33),
154(33, 'cod-01-imgem-03-jpg_1465478436.jpg', 10, 32),
155(34, 'fachada-2-dom-batel-apartamento-no-batel-cyrela-imoveis-em-curitiba-jpg_1465478602.jpg', 11, 31),
156(35, 'apartamento-na-praia-da-enseada-eb0034-foto-03-jpg_1465478612.jpg', 11, 19),
157(36, 'adesivo-decorativo-de-parede-quarto-religioso-mos-postas-26-mlb4650855947-072013-f-jpg_1465478617.jpg', 11, 37),
158(37, 'dsc-9766-jpg_1465478630.jpg', 11, 18),
159(38, 'fachadas-de-casas-modernas-pequenas03-jpg_1465478754.jpg', 12, 1),
160(40, 'lancamento-pedra-faria-lima-apartamento-garden-94m2-14-jpg_1465478784.jpg', 12, 24),
161(41, '0-jpg_1465479259.jpg', 13, 8),
162(42, '00-jpg_1465479265.jpg', 13, 0),
163(43, '000-jpg_1465479265.jpg', 13, 13),
164(44, '1-jpg_1465479703.JPG', 14, 6),
165(45, '111-jpg_1465479719.jpg', 14, 7),
166(46, '11-jpg_1465479719.jpg', 14, 12),
167(47, '1111-jpg_1465479719.jpg', 14, 11),
168(48, '111111-jpg_1465479719.jpg', 14, 14),
169(49, 'chacara-jpg_1465481954.jpg', 15, 17),
170(50, 'chacara-pq-valinhos-fernando-3-jpg_1465481954.JPG', 15, 16),
171(51, '222-jpg_1465482308.jpg', 15, 15),
172(52, 'cassaaaaa-jpg_1466418535.JPG', 16, 3),
173(53, 'casasssssasaaa-jpg_1466418542.JPG', 16, 5),
174(54, 'cassdsdssd-jpg_1466418542.JPG', 16, 4),
175(55, 'casssaass-jpg_1466418542.JPG', 16, 9),
176(56, 'cassss-jpg_1466418542.JPG', 16, 2),
177(57, 'casssssss-jpg_1466418542.JPG', 16, 10),
178(58, 'cobertura-jpg_1467897391.jpg', 17, 99),
179(60, '64127579-jpg_1467897543.jpg', 17, 99),
180(61, 'condominio-fechado2-jpg_1467898409.jpg', 18, 99),
181(62, 'condominio-fechado3-jpg_1467898409.jpg', 18, 99),
182(63, 'condominio-fechado-jpg_1467898409.jpg', 18, 99),
183(64, 'salahho-jpg_1467898671.jpg', 19, 99),
184(65, 'salao-jpeg_1467898671.jpeg', 19, 99),
185(66, 'salao-jpg_1467898671.jpg', 19, 99),
186(67, 'today-jpg_1470849545.jpg', 20, 99),
187(68, 'modal-f1304-jpg_1470849545.jpg', 20, 99),
188(69, '130273893384720274-2408x1080-perspectiva-da-praca-de-apoio-ao-salao-de-festas-jpg_1470849545.jpg', 20, 99),
189(70, 'apartamento-santa-catarina-espaco-traco-arquitetura-03-jpg_1470909153.jpg', 21, 99),
190(71, 'apartamento-santa-catarina-espaco-traco-arquitetura-16-jpg_1470909156.jpg', 21, 99),
191(72, 'apartamento-santa-catarina-espaco-traco-arquitetura-04-jpg_1470909156.jpg', 21, 99),
192(73, 'f4332f48-648b-4a76-8d80-d57442948c79-png_1470932941.png', 22, 99),
193(74, '5c8df576-fd80-4455-a037-00c89a57fc41-png_1470932958.png', 22, 99),
194(75, 'a07b2da3-e8ea-4d6d-b8d4-22fc60fd1db7-1-png_1470932959.png', 22, 99),
195(76, '2cf6dac5-ed88-4d30-9532-67ee7acf4b76-1-png_1470932959.png', 22, 99),
196(77, 'foto-06-jpeg_1470933226.jpeg', 23, 99),
197(78, 'foto-05-jpeg_1470933227.jpeg', 23, 99),
198(79, 'foto-04-jpeg_1470933227.jpeg', 23, 99),
199(80, 'foto-03-jpeg_1470933227.jpeg', 23, 99),
200(81, 'foto-02-jpeg_1470933228.jpeg', 23, 99),
201(82, 'foto-01-jpeg_1470933228.jpeg', 23, 99),
202(83, '00-jpg-1465479265-jpg_1472580518.jpg', 5, 99),
203(84, 'sister-png_1472580548.png', 5, 99);
204
205-- --------------------------------------------------------
206
207--
208-- Estrutura da tabela `imovel`
209--
210
211CREATE TABLE IF NOT EXISTS `imovel` (
212 `imovel_id` int(11) NOT NULL AUTO_INCREMENT,
213 `imovel_ref` varchar(45) DEFAULT NULL,
214 `imovel_cidade` int(11) DEFAULT NULL,
215 `imovel_bairro` int(11) DEFAULT NULL,
216 `imovel_slide` int(11) DEFAULT '0',
217 `imovel_vendido` varchar(100) DEFAULT '0',
218 `imovel_area` int(11) DEFAULT '0',
219 `imovel_dormitorio` int(11) DEFAULT '0',
220 `imovel_banheiro` int(11) DEFAULT '1',
221 `imovel_suite` int(11) DEFAULT '0',
222 `imovel_vaga` int(11) DEFAULT '0',
223 `imovel_tipo` int(11) DEFAULT '1',
224 `imovel_destaque` int(11) DEFAULT '0',
225 `imovel_preco` double(10,2) DEFAULT NULL,
226 `imovel_preco_locacao` double(10,2) DEFAULT NULL,
227 `imovel_preco_condominio` double(10,2) DEFAULT '0.00',
228 `imovel_preco_temp` double(10,2) NOT NULL,
229 `imovel_preco_iptu` double(10,2) DEFAULT '0.00',
230 `imovel_endereco` varchar(300) DEFAULT NULL,
231 `imovel_mapa` int(11) DEFAULT '2',
232 `imovel_proprietario` int(11) DEFAULT '0',
233 `imovel_atotal` varchar(45) NOT NULL,
234 `imovel_obs` text NOT NULL,
235 `imovel_negocio` int(11) DEFAULT NULL,
236 `imovel_ativo` int(1) DEFAULT '1',
237 `imovel_opcao` varchar(2000) DEFAULT NULL,
238 `imovel_descricao` longtext,
239 `imovel_pos` int(11) DEFAULT '999',
240 `imovel_lat` varchar(200) DEFAULT NULL,
241 `imovel_lon` varchar(200) DEFAULT NULL,
242 `imovel_views` int(5) DEFAULT '0',
243 PRIMARY KEY (`imovel_id`)
244) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
245
246--
247-- Extraindo dados da tabela `imovel`
248--
249
250INSERT INTO `imovel` (`imovel_id`, `imovel_ref`, `imovel_cidade`, `imovel_bairro`, `imovel_slide`, `imovel_vendido`, `imovel_area`, `imovel_dormitorio`, `imovel_banheiro`, `imovel_suite`, `imovel_vaga`, `imovel_tipo`, `imovel_destaque`, `imovel_preco`, `imovel_preco_locacao`, `imovel_preco_condominio`, `imovel_preco_temp`, `imovel_preco_iptu`, `imovel_endereco`, `imovel_mapa`, `imovel_proprietario`, `imovel_atotal`, `imovel_obs`, `imovel_negocio`, `imovel_ativo`, `imovel_opcao`, `imovel_descricao`, `imovel_pos`, `imovel_lat`, `imovel_lon`) VALUES
251(4, 'CA01234', 13, 25, 0, '0', 340, 3, 2, 1, 3, 8, 1, 600000.00, 0.00, 0.00, 0.00, 0.00, 'Avenida Doutor Roberto de Almeida Vinhas - Guilhermina, Praia Grande-SP', 1, 4, '600', 'reformado recentemente', 7, 1, '33,34,38', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 0, '-24.005974', '-46.4298782'),
252(5, 'APT0585', 15, 32, 0, '0', 75, 2, 1, 0, 1, 15, 1, 400000.00, 0.00, 0.00, 0.00, 0.00, 'Av. Dona Ana Costa, 468 - Gonzaga, Santos - SP', 1, 5, '90', 'reformado recentemente', 7, 1, '33,39,34,35,38,37,36', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 1, '-23.964929', '-46.3329534'),
253(6, 'CA0589', 13, 24, 0, '2', 250, 2, 2, 1, 1, 8, 1, 0.00, 2200.00, 0.00, 0.00, 0.00, 'Av. Dr. Antônio Severiano - Aviação Praia Grande - SP', 1, 5, '300', 'reformado recentemente', 8, 1, '33', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 2, '-24.0088727', '-46.4125034'),
254(7, 'APT5899', 14, 26, 0, '0', 80, 3, 1, 0, 1, 15, 1, 450000.00, 0.00, 0.00, 0.00, 0.00, 'Rua Araraquara', 1, 0, '120', 'reformado recentemente', 7, 1, '33,39,34', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 3, NULL, NULL),
255(8, 'CA4588', 14, 27, 0, '0', 500, 3, 1, 0, 1, 8, 1, 800000.00, 0.00, 0.00, 0.00, 0.00, 'Rua Nove de Novembro', 1, 0, '700', 'reformado recentemente', 7, 1, '39,34,37', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 4, NULL, NULL),
256(10, 'CA06589', 13, 23, 0, '0', 150, 3, 2, 1, 1, 8, 1, 700000.00, 0.00, 0.00, 0.00, 0.00, 'Rua São Sebastião', 1, 4, '200', 'reformado recentemente', 7, 1, '33,39,34,38,36', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 5, NULL, NULL),
257(11, 'APT588', 15, 29, 0, '0', 80, 3, 1, 0, 1, 15, 1, 0.00, 5000.00, 0.00, 0.00, 0.00, 'R. Júlio Conceição - Vila Matias Santos - SP', 1, 5, '110', 'reformado recentemente', 8, 1, '33,39,35,37,36', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 999, '-23.9493872', '-46.3294474'),
258(12, 'CA5888', 14, 27, 0, '0', 200, 3, 2, 0, 1, 8, 1, 2500000.00, 0.00, 0.00, 0.00, 0.00, 'Rua Marina', 1, 0, '240', 'reformado recentemente', 7, 1, NULL, 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 999, NULL, NULL),
259(13, 'APT5589', 15, 32, 0, '0', 100, 3, 2, 1, 1, 15, 1, 0.00, 0.00, 0.00, 1000.00, 0.00, 'Av. Pres. Wilson - José Menino Santos - SP', 1, 6, '160', 'reformado recentemente', 9, 1, '33,34,35', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 999, '-23.9678823', '-46.3288865'),
260(14, 'CS5896', 14, 28, 0, '0', 210, 3, 2, 1, 2, 8, 1, 2000000.00, 0.00, 0.00, 0.00, 0.00, 'Alameda Ari Barroso- Ilha Porchat São Vicente - SP', 1, 6, '250', 'reformado recentemente', 7, 1, '33,35,38,36', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 999, '-23.9802219', '-46.3694189'),
261(15, 'CH0589', 13, 25, 0, '0', 250, 3, 1, 0, 8, 9, 1, 1500000.00, 0.00, 0.00, 0.00, 0.00, 'Avenida Brasil, 963, Guilhermina, Praia Grande - São Paulo', 1, 6, '10000', 'reformado recentemente', 7, 1, '34,38,37,36', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 999, '-24.0121163', '-46.4212922'),
262(16, 'CS0236', 13, 24, 0, '1', 70, 2, 2, 1, 1, 8, 1, 300000.00, 0.00, 0.00, 0.00, 0.00, 'R. Carlos José Borstens - Aviação Praia Grande - SP', 1, 4, '85', 'reformado recentemente', 7, 1, '33,39,34', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.', 999, '-24.0088727', '-46.4125034'),
263(17, 'APT02369', 15, 32, 0, '0', 200, 3, 2, 1, 1, 15, 1, 6000000.00, 0.00, 0.00, 0.00, 0.00, 'R. Dr. Manoel Vitórino - Gonzaga Santos - SP', 1, 6, '280', '<p><br></p>', 7, 1, '33,39,34,38,37,36', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 999, '-23.9673822', '-46.3328146'),
264(18, 'CF59855', 13, 23, 0, '0', 300, 2, 1, 1, 1, 11, 1, 5000000.00, 0.00, 0.00, 0.00, 0.00, 'Rua Florida', 1, 4, '450', '<p><br></p>', 7, 1, '33,39,35,38,37,36', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 999, '-24.3916059', '-53.9326858'),
265(19, '0SL02369', 13, 25, 0, '0', 500, 1, 1, 1, 1, 12, 1, 2000000.00, 0.00, 0.00, 0.00, 0.00, 'Av. Guilhermina, 852 - Guilhermina Praia Grande - SP', 1, 5, '700', '<p><br></p>', 7, 1, '33,37,36', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 999, '-24.0123698', '-46.4203973'),
266(20, 'CA3456', 13, 24, 0, '0', 500, 2, 2, 1, 1, 8, 1, 2000000.00, 0.00, 0.00, 0.00, 0.00, 'R. Gago Coutinho - Aviação Praia Grande - SP', 1, 8, '600', '<p><br></p>', 7, 1, '33,39,34', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 10, '-24.0088727', '-46.4125034'),
267(21, 'APT87678', 23, 49, 0, '0', 75, 2, 1, 0, 0, 15, 1, 2000000.00, 0.00, 0.00, 0.00, 0.00, 'R. Raul Setti - Centro São Bernardo do Campo - SP', 1, 4, '110', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 7, 1, '33,39,34,37,36', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 777, '-23.7176848', '-46.5523631'),
268(22, 'CS45679', 16, 47, 0, '0', 140, 2, 2, 1, 1, 8, 1, 3000000.00, 0.00, 0.00, 0.00, 0.00, 'Av. Mal. Deodoro da Fonseca - Centro Guarujá - SP', 2, 4, '200', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 7, 1, '33,39,35,38', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 88, '-23.9975975', '-46.2577737'),
269(23, 'CAS589', 13, 24, 0, '0', 180, 3, 2, 1, 1, 8, 1, 3500000.00, 0.00, 0.00, 0.00, 0.00, 'Av. Pres. Kennedy, 3387 - Aviação Praia Grande - SP', 2, 8, '220', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 7, 1, '33,34,37', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.<br></p>', 999, '-24.0088727', '-46.4125034');
270
271
272
273CREATE TABLE IF NOT EXISTS `negocio` (
274 `negocio_id` int(11) NOT NULL AUTO_INCREMENT,
275 `negocio_nome` varchar(200) DEFAULT NULL,
276 `negocio_url` varchar(200) DEFAULT NULL,
277 PRIMARY KEY (`negocio_id`)
278) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
279
280
281
282INSERT INTO `negocio` (`negocio_id`, `negocio_nome`, `negocio_url`) VALUES
283(7, 'Venda', 'venda'),
284(8, 'Locação', 'locacao'),
285(9, 'Temporada', 'temporada');
286
287
288
289
290CREATE TABLE IF NOT EXISTS `opcao` (
291 `opcao_id` int(11) NOT NULL AUTO_INCREMENT,
292 `opcao_nome` varchar(200) DEFAULT NULL,
293 PRIMARY KEY (`opcao_id`)
294) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 ;
295
296--
297-- Extraindo dados da tabela `opcao`
298--
299
300INSERT INTO `opcao` (`opcao_id`, `opcao_nome`) VALUES
301(33, 'Churrasqueira'),
302(34, 'PÃscina'),
303(35, 'PÃscina com Cascata'),
304(36, 'Salão de Jogos'),
305(37, 'Salão de Festas'),
306(38, 'Sala de TV'),
307(39, 'Forno a Lenha'),
308(41, 'Sala de Jantar');
309
310
311
312
313CREATE TABLE IF NOT EXISTS `smtp` (
314 `smtp_id` int(11) NOT NULL AUTO_INCREMENT,
315 `smtp_host` varchar(200) DEFAULT NULL,
316 `smtp_email` varchar(200) DEFAULT NULL,
317 `smtp_pass` varchar(200) DEFAULT NULL,
318 `smtp_nome` varchar(200) DEFAULT NULL,
319 `smtp_port` varchar(200) DEFAULT NULL,
320 `smtp_bcc` varchar(200) DEFAULT NULL,
321 PRIMARY KEY (`smtp_id`)
322) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
323
324--
325-- Extraindo dados da tabela `smtp`
326--
327
328INSERT INTO `smtp` (`smtp_id`, `smtp_host`, `smtp_email`, `smtp_pass`, `smtp_nome`, `smtp_port`, `smtp_bcc`) VALUES
329(1, 'mail.seusite.com.br', 'email@clares.com.br', '', 'PHP Staff', '587', 'outro@gmail.com');
330
331
332
333
334CREATE TABLE IF NOT EXISTS `sobre` (
335 `sobre_id` int(11) NOT NULL AUTO_INCREMENT,
336 `sobre_nome` varchar(200) DEFAULT NULL,
337 `sobre_foto` varchar(200) DEFAULT NULL,
338 `sobre_desc` longtext,
339 PRIMARY KEY (`sobre_id`)
340) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
341
342
343
344
345
346CREATE TABLE IF NOT EXISTS `tipo` (
347 `tipo_id` int(11) NOT NULL AUTO_INCREMENT,
348 `tipo_nome` varchar(200) DEFAULT NULL,
349 `tipo_url` varchar(400) DEFAULT NULL,
350 PRIMARY KEY (`tipo_id`)
351) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
352
353--
354-- Extraindo dados da tabela `tipo`
355--
356
357INSERT INTO `tipo` (`tipo_id`, `tipo_nome`, `tipo_url`) VALUES
358(8, 'Casa', 'casa'),
359(9, 'Chácara', 'chacara'),
360(10, 'Cobertura', 'cobertura'),
361(11, 'CondomÃnio Fechado', 'condominio-fechado'),
362(12, 'Salão', 'salao'),
363(13, 'Sobrado', 'sobrado'),
364(14, 'Terreno', 'terreno'),
365(15, 'Apartamento', 'apartamento'),
366(17, 'Fazenda', 'fazenda');
367
368-- --------------------------------------------------------
369
370--
371-- Estrutura da tabela `usuario`
372--