· 6 years ago · Jul 22, 2019, 08:34 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Nov 11, 2013 at 04:38 PM
7-- Server version: 5.6.13
8-- PHP Version: 5.4.17
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 utf8 */;
18
19--
20-- Database: `store_locator`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `cities`
27--
28
29CREATE TABLE IF NOT EXISTS `cities` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `name` varchar(255) NOT NULL,
32 `state` int(11) NOT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
35
36--
37-- Dumping data for table `cities`
38--
39
40INSERT INTO `cities` (`id`, `name`, `state`) VALUES
41(1, 'Guadalajara', 1),
42(2, 'Zapopan', 1),
43(3, 'Tlaquepaque', 1),
44(4, 'Aguascalientes', 2),
45(5, 'Mazatlán', 3),
46(6, 'León', 4),
47(7, 'Chihuahua', 5),
48(8, 'Culiacán', 3),
49(9, 'Monterrey', 7),
50(10, 'San Luis Potosí', 8),
51(11, 'Torreón', 9);
52
53-- --------------------------------------------------------
54
55--
56-- Table structure for table `locations`
57--
58
59CREATE TABLE IF NOT EXISTS `locations` (
60 `id` int(11) NOT NULL AUTO_INCREMENT,
61 `lat` varchar(255) NOT NULL,
62 `lng` varchar(255) NOT NULL,
63 `store` int(11) NOT NULL,
64 PRIMARY KEY (`id`)
65) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
66
67--
68-- Dumping data for table `locations`
69--
70
71INSERT INTO `locations` (`id`, `lat`, `lng`, `store`) VALUES
72(1, '-103.3499184', '20.6765735', 1),
73(2, '-103.401428', '20.649939', 2),
74(3, '-103.35135', '20.674447', 3),
75(4, '-103.3539652', '20.6647874', 4),
76(5, '-103.347659', '20.675421', 5),
77(6, '-103.3472874', '20.67813611', 6),
78(7, '-103.3684884', '20.6734905', 7),
79(8, '-103.4040991', '20.64855152', 8),
80(9, '-103.3783276', '20.71264586', 9),
81(10, '-103.3997181', '20.67944679', 10),
82(11, '-103.4137998', '20.69137534', 11),
83(12, '-103.4056467', '20.67452558', 12),
84(13, '-103.3049815', '20.64674113', 13),
85(14, '-103.3907316', '20.59664154', 14),
86(15, '-102.2936165', '21.89020003', 15),
87(16, '-106.4383672', '23.23888689', 16),
88(17, '-101.6509596', '21.11860168', 17),
89(18, '-101.6949254', '21.15777218', 18),
90(19, '-106.1152971', '28.6224644', 19),
91(20, '-107.3957476', '24.81660583', 20),
92(21, '-103.4115899', '20.71040695', 21),
93(22, '-103.4552263', '20.73448244', 22),
94(23, '-100.3510581', '25.67966286', 23),
95(24, '-100.9815512', '22.15127218', 24),
96(25, '-103.4332396', '25.56021591', 25);
97
98-- --------------------------------------------------------
99
100--
101-- Table structure for table `states`
102--
103
104CREATE TABLE IF NOT EXISTS `states` (
105 `id` int(11) NOT NULL AUTO_INCREMENT,
106 `name` varchar(255) NOT NULL,
107 PRIMARY KEY (`id`)
108) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
109
110--
111-- Dumping data for table `states`
112--
113
114INSERT INTO `states` (`id`, `name`) VALUES
115(1, 'Jalisco'),
116(2, 'Aguascalientes'),
117(3, 'Sinaloa'),
118(4, 'Guanajuato'),
119(5, 'Chihuahua'),
120(6, 'Sinaloa'),
121(7, 'Nuevo León'),
122(8, 'San Luis Potosí'),
123(9, 'Coahuila');
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `stores`
129--
130
131CREATE TABLE IF NOT EXISTS `stores` (
132 `id` int(11) NOT NULL AUTO_INCREMENT,
133 `name` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
134 `address` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
135 `city` int(11) NOT NULL,
136 `telephone` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
137 `email` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
138 `schedule` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
139 `notes` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
140 PRIMARY KEY (`id`)
141) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=26 ;
142
143--
144-- Dumping data for table `stores`
145--
146
147INSERT INTO `stores` (`id`, `name`, `address`, `city`, `telephone`, `email`, `schedule`, `notes`) VALUES
148(1, 'Sucursal Morelos', 'Morelos # 530.', 1, '(33) 3613-2614, 3613-5100, 3658-2884 ', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m.', 'Domingo Cerrado'),
149(2, 'Sucursal Plaza del Sol 1', 'Local 4 Zona F.', 2, '(33) 3122-8697, 3122-0899, 3647-4737', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m.', 'Domingos 11:00 a.m. a 8:00 p.m.'),
150(3, 'Sucursal López Cotilla', 'López Cotilla # 501.', 1, '(33) 3613-0123, 3658-0041 ', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m. ', 'Domingo Cerrado'),
151(4, 'Centro de Distribución Nacional', '8 de Julio # 825 Col. Moderna.', 1, '(33) 3837-2300</br><b>Fax:</b>(33)3837-2309', 'librosbooks@gonvill.com.mx', 'Lunes a Viernes 8:00 a.m. a 7:00 p.m. Sábado 8:00 a.m. a 2:30 p.m.', 'Domingo Cerrado'),
152(5, 'Sucursal Juárez', 'Av. Juárez # 305.', 1, '(33) 3614-2856, 3614-9785', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 9:00 a.m. a 8:30 p.m. ', 'Domingos 10:00 a.m. a 7:00 p.m.'),
153(6, 'Sucursal Independencia ', 'Independencia # 352.', 1, '(33) 3613-2553, 3658-1063', '', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m. ', 'Domingos 10:00 a.m. a 6:00 p.m.'),
154(7, 'Sucursal Chapultepec ', 'Av. Chapultepec Sur # 150.', 1, '(33) 3616-3060, 3616-3068, 3616-3069 ', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m. ', 'Domingos 10:00 a.m. a 3:00 p.m.'),
155(8, 'Sucursal Plaza del Sol 2', 'Local 7 Zona G.', 2, '(33) 3647-4486, 3647-5090', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m.', 'Domingos 11:00 a.m. a 8:00 p.m.'),
156(9, 'Sucursal Plaza Patria', 'Locales 13 y 19 Zona B.', 2, '(33) 3642-8157, 3642-8107', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m. ', 'Domingos 11:00 a.m. a 8:00 p.m.'),
157(10, 'Sucursal Plaza México ', 'Local 24 Zona A.', 1, '(33) 3813-0296, 3813-3428', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 11:00 a.m. a 8:00 p.m. ', 'Domingos 11:00 a.m. a 8:00 p.m.'),
158(11, 'Sucursal Plaza Universidad', 'Locales 5 al 9 Zona B.', 2, '(33) 3610-0887, 3610-0888', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m. ', 'Domingo Cerrado'),
159(12, 'Sucursal La Gran Plaza', 'Local 20 Zona C.', 1, '(33) 3647-7719, 3647-7727', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m. ', 'Domingos 11:00 a.m. a 8:00 p.m.'),
160(13, 'Sucursal Plaza Revolución', 'Locales 12, 13 y 21 Zona A.', 3, '(33) 3635-7221, 3639-5985', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 9:00 a.m. a 8:30 p.m. ', 'Domingos 11:00 a.m. a 8:00 p.m.'),
161(14, 'Sucursal Centro Sur', 'Local 17 Zona B.', 3, '(33) 3693-6100, 3693-6144', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 11:00 a.m. a 8:30 p.m. ', 'Domingos 10:00 a.m. a 8:00 p.m.'),
162(15, 'Centro Comercial Altaria', 'Planta Baja Locales 1032 y 1033. Blvd. A Zacatecas Nte. # 851.', 4, '(449) 912-1523 Â </br><b>Fax:</b> 912-1521', 'ags@gonvill.com.mx', 'Lunes a Jueves 11:00 a.m. a 8:30 p.m. Viernes y Sábado 11:00 a.m. a 9:00 p.m. ', 'Domingos 11:00 a.m. a 8:00 p.m.'),
163(16, 'Centro Comercial Gran Plaza', 'Av.Rreforma s/n, Col. Alameda C.P. 83123. Local 1, Isla S.', 5, '(669) 9900-386, 9837-732', 'mzt@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 9:00 p.m. ', 'Domingos 11:00 a.m. a 8:00 p.m.'),
164(17, 'Sucursal Francisco Villa', 'Blvd. Francisco Villa # 802 Nte. Col. Bugambilias C.P. 37270.', 6, '(477) 771-4708, 771-4709 711-5363.</br><b> Fax:</b> 771-4710', 'leon@gonvill.com.mx', 'Lunes a Viernes 9:00 a.m. a 7:00 p.m. Sábado 9:00 a.m. a 3:00 p.m. ', 'Domingo Cerrado'),
165(18, 'Sucursal Plaza Mayor', 'Av. Las Torres # 2002 Local 1030 y 32. Col. Valle del Campestre C.P. 37150.', 6, '(477) 718-2187.</br><b>Fax:</b> 773-5283', 'leon@gonvill.com.mx', 'Lunes a Jueves 10:00 a.m. a 8:30 p.m. Viernes y Sábado 10:00 a.m. a 9:00 p.m. ', 'Domingos 11:00 a.m. a 8:30 p.m.'),
166(19, 'Fashion Mall Chihuahua', 'Planta Alta Locales 219-220 Periférico de la Juventud # 3501.', 7, '(614) 430-0256</br><b>Fax:</b> 430-0195', 'chih@gonvill.com.mx', 'Lunes a Domingo 11:00 a.m. a 8:30 p.m. ', ''),
167(20, 'Gonvill Culiacán', 'Av. Álvaro Obregón 1686 norte.', 8, '(667) 712-3109, Â 712-3128 </br><b>Fax:</b> 712-29-97', 'cln@gonvill.com.mx', 'Lunes a Sábado 9:00 a.m. a 8:00 p.m. ', 'Domingo Cerrado'),
168(21, 'Sucursal Plaza Andares', 'Local UP66-114.', 2, '(33) 3611-3434, 3611-1889', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 11:00 a.m. a 9:00 p.m. ', 'Domingos 11:00 a.m. a 9:00 p.m.'),
169(22, 'Sucursal ITESM Campus GDL', 'Av. General Ramon Corona 2514.', 2, '(33) 1561-0411', 'librosbooks@gonvill.com.mx', 'Lunes a Sábado 8:00 a.m. a 7:00 p.m. ', 'Domingo Cerrado'),
170(23, 'HEB Plaza Real', 'Planta Baja, Local B-10. Av.Gonalitos #315.', 9, '(81) 8333-7034, 8123-1018</br> <b>Fax:</b> 8333-6972', 'mty@gonvill.com.mx', 'Lunes a Sábado 11:00 a.m. a 8:30 p.m. ', 'Domingos 11:00 a.m. a 7:00 p.m.'),
171(24, 'Gonvill San Luis', 'Av. Venustiano Carranza # 500.', 10, '(444) 812-6913, 812-6935 </br> <b>Fax:</b> 812-7399', 'slp@gonvill.com.mx', 'Lunes a Sábado 10:00 a.m. a 8:30 p.m. ', 'Domingo Cerrado.'),
172(25, 'Centro Com. Pza. Cuatro Caminos', 'Blvd. Independencia Ote. # 1300, Col. Navarro C.P. 27010. Planta Baja, Local 124.', 11, '(871) 722-6077</br><b>Fax:</b> 718-3336', 'torreon@gonvill.com.mx', 'Lunes a Domingo 11:00 a.m. a 9:00 p.m. ', NULL);
173
174/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
175/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
176/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;