-- MySQL dump 10.13  Distrib 5.5.29, for Linux (i686)
--
-- Host: localhost    Database: grimaldismobile
-- ------------------------------------------------------
-- Server version	5.5.29

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `employees`
--

DROP TABLE IF EXISTS `employees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` int(11) NOT NULL DEFAULT '0',
  `fname` varchar(255) DEFAULT NULL,
  `lname` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `position_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employees`
--

LOCK TABLES `employees` WRITE;
/*!40000 ALTER TABLE `employees` DISABLE KEYS */;
INSERT INTO `employees` VALUES (1,1,'Chris','White','480-213-3256',NULL),(2,1,'Erica','Davis','602-361-4640',NULL),(3,1,'Ryan','Crisp','602-463-2103',NULL),(4,1,'Jennifer','Gaston','602-391-6167',NULL),(5,2,'Dustin','Drago','480-273-7350',NULL),(6,2,'Amie','Smith','480-330-1533',NULL),(7,2,'Joe','Holmes','480-239-0147',NULL),(8,3,'Jeff','Spear','520-784-1768',NULL),(9,3,'Isabel','Maya','520-668-8264',NULL),(10,3,'Sean','Cummingham','520-331-1342',NULL),(11,4,'Tania','Fieramosca','480-768-7723',NULL),(12,4,'Robert','Loskey','205-223-8900',NULL),(13,4,'Jennifer','Stober','480-294-0275',NULL),(14,5,'Rich','Seidner','480-326-1791',NULL),(15,5,'Jason','Novack','520-661-0823',NULL),(16,6,'John','Borzone','480-255-0675',NULL),(17,6,'Melissa','Lambert','702-544-4296',NULL),(18,6,'David','Simon','520-904-5445',NULL),(19,7,'Joseph','Stubbs','702-845-6370',NULL),(20,7,'Vincent','Diorio','718-812-2009',NULL),(21,7,'Anthony','Garcia','702-769-6878',NULL),(22,8,'Rodney','Condell','916-402-8522',NULL),(23,8,'Vic','DeNigris','775-354-8332',NULL),(24,8,'Kevin','Roseberry','775-671-1977',NULL),(25,9,'Ryan','Messley','949-929-2052',NULL),(26,9,'Gino','Bongiorno','702-250-2803',NULL),(27,9,'Robert','Merlo','917-669-1480',NULL),(28,9,'Greg','Giummarra','702-445-4218',NULL),(29,10,'Barry','Fisher','832-752-7102',NULL),(30,10,'Frank','Zorechak','713-443-7061',NULL),(31,10,'Paul','Gibson','832-266-8088',NULL),(32,11,'Fernando','Ruiz','214-392-5012',NULL),(33,11,'Jeremy','Stogsdill','214-564-0738',NULL),(34,11,'Alejandro','Valdez','972-795-0455',NULL),(35,11,'Phillip','Lawson','863-899-4177',NULL),(36,12,'Richard','Leggett','469-867-4130',NULL),(37,12,'Mike','Price','304-826-6739',NULL),(38,12,'Michael','Allen','214-779-3418',NULL),(39,13,'Dionne','Schulte','714-323-8013',NULL),(40,13,'Trent','Banks','248-860-3786',NULL),(41,13,'Andrew','Mota','210-771-5135',NULL),(42,14,'Mario','Buitron','832-729-1314',NULL),(43,14,'Ronald','Higgins','504-957-8476',NULL),(44,14,'Jeremy','Smith','757-358-5352',NULL),(45,15,'Brooks','Flory','361-356-9795',NULL),(46,15,'Henry','Garza','210-394-5392',NULL),(47,15,'Jennifer','Hajek','361-446-9149',NULL);
/*!40000 ALTER TABLE `employees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `locations`
--

DROP TABLE IF EXISTS `locations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `address1` varchar(255) DEFAULT NULL,
  `address2` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(10) DEFAULT NULL,
  `state_full` varchar(255) DEFAULT NULL,
  `zip` varchar(5) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `foursquare_id` varchar(255) DEFAULT NULL,
  `lat` float DEFAULT NULL,
  `lng` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `locations`
--

LOCK TABLES `locations` WRITE;
/*!40000 ALTER TABLE `locations` DISABLE KEYS */;
INSERT INTO `locations` VALUES (1,'Old Town Scottsdale','4000 N Scottsdale Rd','Ste 105,107,203','Scottsdale','AZ','Arizona','85251','480-994-1100','480-994-0066','1 block south of Indian School on Scottsdale Rd',1,'63830',33.4938,-111.926),(2,'DC Ranch','20715 N Pima Rd','Ste F115','Scottsdale','AZ','Arizona','85255','480-515-5588','480-515-9668','Pima/Princess &amp; Thompson Peak Pkwy',1,'421793',33.6744,-111.889),(3,'La Colonial','446 N Campbell Ave','Ste # 100','Tucson','AZ','Arizona','85719','520-882-6100','520-882-8882','SE corner of 6th &amp; Campbell',1,'348380',32.2275,-110.943),(4,'Ocotillo','1035 W Queen Creek Rd','Ste #103','Chandler','AZ','Arizona','85248','480-812-2100','480-899-8162','SW corner of Alma School &amp; Queen Creek',1,'362953',33.261,-111.86),(5,'Park West','9788 W Northern Ave','Ste #1440','Peoria','AZ','Arizona','85345','623-486-4455','623-486-4464','Northern &amp; 101',1,'128146',33.5514,-112.273),(6,'San Tan','2168 E Williams Field Rd','Ste # 502','Gilbert','AZ','Arizona','85295','480-814-7722','480-814-7733','Williams Field Rd &amp; 202',1,'4140304',33.3068,-111.753),(7,'Green Valley','9595 S Eastern Ave','Ste #100','Las Vegas','NV','Nevada','89123','702-657-9400','702-646-9403','SW corner Richmar Ave &amp; Eastern',1,'4874343',36.0153,-115.119),(8,'Sparks','1180 Scheels Drive','Ste B-117','Sparks','NV','Nevada','89434','775-356-7373','775-356-7376',NULL,1,'1871245',39.5315,-119.72),(9,'Boca Fashion Village','750 S Rampart Blvd','Ste # 7','Las Vegas','NV','Nevada','89145','702-479-1351','702-479-1350',NULL,1,'1721668',36.1608,-115.292),(10,'First Colony','16535 Southwest Freeway','#2500','Sugar Land','TX','Texas','77479','281-265-2280','281-265-2286','Hwy 59 &amp; Hwy 6 Off of Town Center Blvd',1,'255856',29.5931,-95.6235),(11,'Watters Creek','836 Market Street','C-200','Allen','TX','Texas','75013','214-383-9703','214-383-9761','Hwy 75 (Central) &amp; Bethany Rd',1,'1528713',33.1008,-96.6904),(12,'West Village','3636 McKinney Ave','Ste #190','Dallas','TX','Texas','75201','214-559-4611','214-559-0522','Corner of Noble &amp; Cityplace West',1,'72724',32.807,-96.7963),(13,'La Cantera','15900 La Cantera Parkway','Suite 25180','San Antonio','TX','Texas','78215','210-690-4949','210-690-4955',NULL,1,'246630',29.5929,-98.6181),(14,'Town Center','20 Waterway Avenue','# 100','The Woodlands','TX','Texas','77380','281-465-3500','281-465-8150',NULL,1,'255856',30.158,-95.4894),(15,'La Palmera','5488 S. Padre Island','# 1202','Corpus Christi','TX','Texas','78411','361-980-8600','361-980-8601',NULL,1,'4331031',27.7128,-97.3745),(16,'Bell Tower','13499 S Cleveland Ave','Ste. 201','Fort Myers','FL','Florida','33907','239-432-9767','239-432-9946',NULL,1,'11394408',26.549,-81.8694),(17,'SQ','15147 N Scottsdale Road','Ste H-135','Scottsdale','AZ','Arizona','85254','480-596-4070','480-596-3559',NULL,1,'14043406',33.6235,-111.926),(18,'The Quarry','330 E Basse Rd','Ste 1','San Antonio','TX','Texas','78209','210-832-8288',NULL,'',1,'26741664',29.4954,-98.4793),(19,'Park Lane','8060 Parklane','Ste 105','Dallas','TX','Texas','75231','214-987-1173',NULL,'',1,'26743014',32.871,-96.7677),(20,'Casa Paloma','7131 W Ray Rd','Ste 23','Chandler','AZ','Arizona','85226','480-785-1600','480-785-1608',NULL,1,'25597135',33.3179,-111.964),(21,'South Rainbow','7155 South Rainbow Blvd.','Ste # 125','Las Vegas','NV','Nevada','89118','702-207-6757','702-207-6760',NULL,1,'17618220',36.0581,-115.243),(22,'DATG','11701 Lake Victoria Gardens Ave','Ste. 3101','Palm Beach Gardens','FL','Florida','33410','561-625-4665','561-625-4669',NULL,1,'23810185',26.8511,-80.0838),(23,'Clematis','1 N Clematis St','Ste. 110','West Palm Beach','FL','Florida','33401','561-833-8787',NULL,NULL,1,'4e404da6922e920e6c513245',26.714,-80.0497),(24,'Under the Brooklyn Bridge','19 Old Fulton Street',NULL,'Brooklyn','NY','New York','11201','718-858-4300',NULL,NULL,1,'4ee0f5970aafbb3dbb28a166',40.7027,-73.9936),(25,'Long Island','980 Franklin Avenue',NULL,'Garden City','NY','New York','11530','516-294-6565',NULL,NULL,1,'4a961871f964a520012620e3',40.7291,-73.6356),(26,'Douglaston','242-02 61st Avenue',NULL,'Douglaston','NY','New York','11362','718-819-2133',NULL,NULL,1,'4b54cdfbf964a52049cd27e3',40.7547,-73.7389),(27,'Limelight Marketplace','656 6th Avenue',NULL,'Manhattan','NY','New York','10011','212-359-5523',NULL,NULL,1,'4c6bf600d68a9c741978646b',40.7413,-73.9938),(28,'Clinton Street','133 Clinton Street',NULL,'Hoboken','NJ','New Jersey','07030','201-792-0800',NULL,NULL,1,'49dffac1f964a52032611fe3',40.7395,-74.035),(29,'Washington Street','411 Washington Street',NULL,'Hoboken','NJ','New Jersey','07030','201-792-0010',NULL,NULL,1,'4ca50f407334236a60ef1258',40.7417,-74.0296),(30,'Highlands','123 Bay Avenue',NULL,'Highlands','NJ','New Jersey','07732','732-291-1711',NULL,NULL,1,'4e276bc7fa762797e593734e',40.4002,-73.9854),(31,'New Paltz','119 Main Street',NULL,'New Paltz','NY','New York','12561','845-255-3800',NULL,NULL,1,'4c61a7d6e1621b8dc7942153',41.7482,-74.0838),(32,'Countryside','27001 US Highway 19 N.','Ste 1140','Clearwater','FL','Florida','33761','727-725-1200','727-725-4476',NULL,1,'4eed33a3e5faa560f0f1f602',28.0176,-82.7365),(33,'Fashion Show','Fashion Show Space #1540','3200 Las Vegas Blvd. South','Las Vegas','NV','Nevada','89109','702-778-8777',NULL,NULL,1,'4eb05ff2754a67f6629d2658',36.1274,-115.171),(34,'Palazzo','The Shoppes at the Palazzo Ste. 2710','3327 Las Vegas Blvd. South','Las Vegas','NV','Nevada','89109','',NULL,NULL,1,'4f1ee8a30039067871843eab',36.1243,-115.168),(35,'Mount Pleasant','1600 Palmetto Grande Drive',NULL,'Mount Pleasant','SC','South Carolina','29464',NULL,NULL,NULL,1,'4f1eefd00039067871851ccf',32.8288,-79.8304),(36,'Grapevine','1401 William D. Tate Ave.','Ste. 100','Grapevine','TX','Texas','76051',NULL,NULL,NULL,1,'4f1eea490039067871847184',32.9258,-97.0874),(37,'Cinco Ranch','23501 Cinco Ranch Blvd.','Suite C390','Katy','TX','Texas','77494',NULL,NULL,NULL,1,NULL,29.7431,-95.7757),(39,'Continental Park','2121 Rosecrans Ave.','Suite 1399','El Segundo','CA','California','90245',NULL,NULL,NULL,1,NULL,33.9019,-118.388),(40,'Denver Pavillions','500 16th Street','Unit 128','Denver','CO','Colorado','80202',NULL,NULL,NULL,1,NULL,39.7438,-104.991),(41,'Westshore Mall','218 Westshore Plaza','#B1B','Tampa','FL','Florida','33609','813-287-2500',NULL,NULL,1,'50b4fcf6e0e237f2210d62d7',27.9453,-82.5273);
/*!40000 ALTER TABLE `locations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menu_cats`
--

DROP TABLE IF EXISTS `menu_cats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu_cats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `parent` int(11) NOT NULL DEFAULT '0',
  `sort_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menu_cats`
--

LOCK TABLES `menu_cats` WRITE;
/*!40000 ALTER TABLE `menu_cats` DISABLE KEYS */;
INSERT INTO `menu_cats` VALUES (1,'Pizza',1,0,1),(2,'Calzone',1,0,2),(3,'Toppings',1,1,0),(4,'Starters',1,0,3),(5,'Extras',1,4,0),(6,'Beverages',1,0,4);
/*!40000 ALTER TABLE `menu_cats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menu_items`
--

DROP TABLE IF EXISTS `menu_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `cat_id` int(11) NOT NULL DEFAULT '0',
  `price` decimal(10,2) DEFAULT NULL,
  `description` text,
  `multiple_sizes` tinyint(1) NOT NULL DEFAULT '0',
  `sort_order` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menu_items`
--

LOCK TABLES `menu_items` WRITE;
/*!40000 ALTER TABLE `menu_items` DISABLE KEYS */;
INSERT INTO `menu_items` VALUES (1,'Personal Pizza (12 in.)',1,9.00,NULL,0,1,1),(2,'Small Pizza (16 in.)',1,14.00,NULL,0,2,1),(3,'Large Pizza (18 in.)',1,16.00,NULL,0,3,1),(4,'Personal White Garlic',1,10.00,NULL,0,4,1),(5,'Small White with Garlic',1,16.00,NULL,0,5,1),(6,'Large White with Garlic',1,18.00,NULL,0,6,1),(7,'Personal Pesto',1,10.00,NULL,0,7,1),(8,'Small Pesto',1,16.00,NULL,0,8,1),(9,'Large Pesto',1,18.00,NULL,0,9,1),(10,'Personal (12 in.)',2,10.00,NULL,0,10,1),(11,'Small (16 in.)',2,16.00,NULL,0,11,1),(12,'Large (16 in.)',2,18.00,NULL,0,12,1),(13,'Artichoke Hearts',3,4.00,NULL,0,1,1),(14,'Jalapenos',3,2.00,NULL,0,2,1),(15,'Oven Roasted Sweet Red Peppers',3,4.00,NULL,0,3,1),(16,'Ricotta Cheese',3,2.00,NULL,0,4,1),(17,'Pepperoni',3,2.00,NULL,0,5,1),(18,'Sun Dried Tomatoes',3,4.00,NULL,0,6,1),(19,'Onions',3,2.00,NULL,0,7,1),(20,'Fresh Garlic',3,2.00,NULL,0,8,1),(21,'Fresh Sliced Tomatoes',3,2.00,NULL,0,9,1),(22,'Kalamata Olives',3,2.00,NULL,0,10,1),(23,'Anchovies',3,2.00,NULL,0,11,1),(24,'Meatballs',3,2.00,NULL,0,12,1),(25,'Italian Sausage',3,2.00,NULL,0,13,1),(26,'Mushrooms',3,2.00,NULL,0,14,1),(27,'Ham',3,2.00,NULL,0,15,1),(28,'Grilled Chicken',3,5.00,NULL,0,16,1),(29,'Pesto',3,2.00,NULL,0,17,1),(30,'Extra Mozzarella Cheese',3,2.00,NULL,0,18,1),(31,'Extra Grimaldi\'s Famous Sauce',3,2.00,NULL,0,19,1),(32,'Extra Basil',3,2.00,NULL,0,20,1),(33,'Antipasto',4,9.00,'Fresh Mozzarella, Oven Roasted Sweet Red Peppers, Genoa Salami, Olives and Fresh Baked Break',1,1,1),(34,'Mediterranean Salad',4,8.00,'Romain Lettuce, Cucumbers, Tomatoes, Kalamata Olives, Feta Cheese, Red Onion, Vinagrette Dressing',1,2,1),(35,'Caprese Salad',4,8.00,'Slices of Fresh Mozzarella, Tomatoes and Fresh Basil Drizzled with Extra Virgin Olive Oil	',0,3,1),(36,'Caesar Salad',4,7.00,'Romaine Lettuce, Imported Parmesan Cheese, Coal Oven Baked Croutons, Traditional Caesar Dressing',1,4,1),(37,'Grimaldi\'s House Salad',4,6.00,'Romaine Lettuce, Red Onion, Cherry Tomatoes, Oven Roasted Sweet Red Peppers, Mushrooms, Sicilian Green Olives, Vinaigrette Dressing',1,5,1),(38,'Genoa Salami',5,2.00,NULL,0,1,1),(39,'Fresh Mozzarella',5,2.00,NULL,0,2,1),(40,'Grilled Chicken',5,4.00,NULL,0,3,1),(41,'Pepsi',6,2.50,NULL,0,1,1),(42,'Diet Pepsi',6,2.50,NULL,0,2,1),(43,'Sierra Mist',6,2.50,NULL,0,3,1),(44,'Dr. Pepper',6,2.50,NULL,0,4,1),(45,'Mug Root Beer',6,2.50,NULL,0,5,1),(46,'Mountain Dew',6,2.50,NULL,0,6,1),(47,'Tropicana Lemonade',6,2.50,NULL,0,7,1),(48,'Traditional Iced Tea',6,2.50,NULL,0,8,1),(49,'Passion Fruit Iced Tea',6,2.50,NULL,0,9,1),(50,'Apple Juice',6,2.50,NULL,0,10,1),(51,'Panna (Still Water)',6,4.00,NULL,1,11,1),(52,'Pellegrino (Sparkling Water)',6,4.00,NULL,1,12,1);
/*!40000 ALTER TABLE `menu_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menu_sizes`
--

DROP TABLE IF EXISTS `menu_sizes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu_sizes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT '0',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menu_sizes`
--

LOCK TABLES `menu_sizes` WRITE;
/*!40000 ALTER TABLE `menu_sizes` DISABLE KEYS */;
INSERT INTO `menu_sizes` VALUES (1,33,'Small',8.00,1,1),(2,33,'Large',12.00,2,1),(3,34,'Small',7.00,1,1),(4,34,'Large',10.00,2,1),(5,36,'Small',6.00,1,1),(6,36,'Large',9.00,2,1),(7,37,'Small',5.00,1,1),(8,37,'Large',8.00,2,1),(9,51,'500 ml',4.00,1,1),(10,51,'1000 ml',6.00,2,1),(11,52,'500 ml',4.00,1,1),(12,52,'1000 ml',6.00,2,1);
/*!40000 ALTER TABLE `menu_sizes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `positions`
--

DROP TABLE IF EXISTS `positions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `positions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `positions`
--

LOCK TABLES `positions` WRITE;
/*!40000 ALTER TABLE `positions` DISABLE KEYS */;
INSERT INTO `positions` VALUES (1,'Manager'),(2,'Area Manager');
/*!40000 ALTER TABLE `positions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vip`
--

DROP TABLE IF EXISTS `vip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vip`
--

LOCK TABLES `vip` WRITE;
/*!40000 ALTER TABLE `vip` DISABLE KEYS */;
/*!40000 ALTER TABLE `vip` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'grimaldismobile'
--

--
-- Dumping routines for database 'grimaldismobile'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-07-18  2:27:48
