verdnatura-mirror
/
loopback-connector-mysql
mirror of https://github.com/loopbackio/loopback-connector-mysql.git
0
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
loopback-connector-mysql/example/table.sql

174 lines
22 KiB
MySQL
Raw Permalink Normal View History

Fix discovery of exported keys
2013-10-08 20:44:37 +00:00
CREATE DATABASE IF NOT EXISTS `strongloop` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `strongloop`;
-- MySQL dump 10.13 Distrib 5.5.24, for osx10.5 (i386)
--
-- Host: 192.237.213.245 Database: strongloop
-- ------------------------------------------------------
-- Server version 5.1.67
/*!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 `customer`
--
DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`militaryAgency` varchar(255) DEFAULT NULL,
`realm` varchar(255) DEFAULT NULL,
`username` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`emailVerified` tinyint(1) DEFAULT NULL,
`verificationToken` varchar(255) DEFAULT NULL,
`credentials` varchar(255) DEFAULT NULL,
`challenges` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`created` datetime DEFAULT NULL,
`lastUpdated` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `customer`
--
LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES (1,NULL,NULL,NULL,'foo','$2a$10$sQ6/CEKSQpEc3hVrY8kb8ug/Spy80rlUYJ3fQ/33w3.kpq5SD4zqG','foo@bar.com',NULL,NULL,'[]','[]',NULL,NULL,NULL),(2,NULL,NULL,NULL,'bar','$2a$10$IdlCSes8/BsNbZAaV2xhwOtRp5722Uexbdo1VpITidk8VFBaaw2sW','bar@bar.com',NULL,NULL,'[]','[]',NULL,NULL,NULL),(3,NULL,NULL,NULL,'bat','$2a$10$PEOrqotDnWRhYYU9ungKM.gTuAvvRTT70y0Be8/Wm4VdCCecm38tW','bat@bar.com',NULL,NULL,'[]','[]',NULL,NULL,NULL),(4,NULL,NULL,NULL,'baz','$2a$10$MWchndR.QMPEIvyBpIJT3.2CRKNpSmPkhWfTIDiSpBnAn2iN/lH42','baz@bar.com',NULL,NULL,'[]','[]',NULL,NULL,NULL);
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `inventory`
--
DROP TABLE IF EXISTS `inventory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `inventory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`productId` varchar(255) DEFAULT NULL,
`locationId` varchar(255) DEFAULT NULL,
`available` int(11) DEFAULT NULL,
`total` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=518 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `inventory`
--
LOCK TABLES `inventory` WRITE;
/*!40000 ALTER TABLE `inventory` DISABLE KEYS */;
INSERT INTO `inventory` VALUES (1,'1','5',43,56),(2,'2','5',43,56),(3,'3','5',27,85),(4,'4','5',18,30),(5,'5','5',3,38),(6,'6','5',10,21),(7,'7','5',43,58),(8,'8','5',6,12),(9,'9','5',0,3),(10,'10','5',0,31),(11,'11','5',73,93),(12,'12','5',22,25),(13,'13','5',44,70),(14,'14','5',26,50),(15,'15','5',36,83),(16,'16','5',20,59),(17,'17','5',28,44),(18,'18','5',5,50),(19,'19','5',2,29),(20,'20','5',38,54),(21,'21','5',4,29),(22,'22','5',1,59),(23,'23','5',20,36),(24,'24','5',10,10),(25,'25','5',58,60),(26,'26','5',0,18),(27,'27','5',29,50),(28,'28','5',24,34),(29,'29','5',36,43),(30,'30','5',43,64),(31,'31','5',79,90),(32,'32','5',13,13),(33,'33','5',9,60),(34,'34','5',7,13),(35,'35','5',43,54),(36,'36','5',67,69),(37,'37','5',1,15),(38,'38','5',36,44),(39,'39','5',1,17),(40,'40','5',13,16),(41,'41','5',24,64),(42,'42','5',87,99),(43,'43','5',27,99),(44,'44','5',71,71),(45,'45','5',9,20),(46,'46','5',9,67),(47,'47','5',19,21),(48,'48','5',5,5),(49,'49','5',82,91),(50,'50','5',27,42),(51,'51','5',51,60),(52,'52','5',8,72),(53,'53','5',5,13),(54,'54','5',3,71),(55,'55','5',55,56),(56,'56','5',9,90),(57,'57','5',3,18),(58,'58','5',2,14),(59,'59','5',54,95),(60,'60','5',62,70),(61,'61','5',18,50),(62,'62','5',60,78),(63,'63','5',23,59),(64,'64','5',14,23),(65,'65','5',2,97),(66,'66','5',49,50),(67,'67','5',47,93),(68,'68','5',34,42),(69,'69','5',3,18),(70,'70','5',37,84),(71,'71','5',22,40),(72,'72','5',8,61),(73,'73','5',2,3),(74,'74','5',10,16),(75,'75','5',53,89),(76,'76','5',35,60),(77,'77','5',57,80),(78,'78','5',53,81),(79,'79','5',32,54),(80,'80','5',1,4),(81,'81','5',78,86),(82,'82','5',11,21),(83,'83','5',28,81),(84,'84','5',2,57),(85,'85','5',30,37),(86,'86','5',17,80),(87,'5','5',1,9),(88,'2','88',10,10),(89,'3','88',1,1),(90,'4','88',8,27),(91,'5','88',3,38),(92,'6','88',28,76),(93,'7','88',40,83),(94,'8','88',1,4),(95,'9','88',87,95),(96,'10','88',29,35),(97,'11','88',10,69),(98,'12','88',32,86),(99,'13','88',27,28),(100,'14','88',59,66),(101,'15','88',59,70),(102,'16','88',43,70),(103,'17','88',50,63),(104,'18','88',8,20),(105,'19','88',20,29),(106,'20','88',36,50),(107,'21','88',40,63),(108,'22','88',4,96),(109,'23','88',70,98),(110,'24','88',1,1),(111,'25','88',17,45),(112,'26','88',52,97),(113,'27','88',0,0),(114,'28','88',97,98),(115,'29','88',26,80),(116,'30','88',11,33),(117,'31','88',10,21),(118,'32','88',14,36),(119,'33','88',71,86),(120,'34','88',85,100),(121,'35','88',3,45),(122,'36','88',0,3),(123,'37','88',17,71),(124,'38','88',41,75),(125,'39','88',37,41),(126,'40','88',37,49),(127,'41','88',1,2),(128,'42','88',49,72),(129,'43','88',24,38),(130,'44','88',6,66),(131,'45','88',31,49),(132,'46','88',9,10),(133,'47','88',57,72),(134,'48','88',17,24),(135,'49','88',41,61),(136,'50','88',33,87),(137,'51','88',11,25),(138,'52','88',1,8),(139,'53','88',14,64),(140,'54','88',50,89),(141,'55','88',16,66),(142,'56','88',0,6),(143,'57','88',18,32),(144,'58','88',6,6),(145,'59','88',68,84),(146,'60','88',50,74),(147,'61','88',7,18),(148,'62','88',14,49),(149,'63','88',3,3),(150,'64','88',21,83),(151,'65','88',48,90),(152,'66','88',11,65),(153,'67','88',29,90),(154,'68','88',44,45),(155,'69','88',23,30),(156,'70','88',53,71),(157,'71','88',50,76),(158,'72','88',13,20),(159,'73','88',6,8),(160,'74','88',7,11),(161,'75','88',0,3),(162,'76','88',49,51),(163,'77','88',37,61),(164,'78','88',4,78),(165,'79','88',1,5),(166,'80','88',23,29),(167,'81','88',3,52),(168,'82','88',1,2),(169,'83','88',65,67),(170,'84','88',41,87),(171,'85','88',20,21),(172,'86','88',46,94),(173,'5','88',64,68),(174,'2','89',5,78),(175,'3','89',29,41),(176,'4','89',2,39),(177,'5','89',57,67),(178,'6','89',1,2),(179,'7','89',68,80),(180,'8','89',22,81),(181,'9','89',9,52),(182,'10','89',26,42),(183,'11','89',42,91),(184,'12','89',23,35),(185,'13','89',38,59),(186,'14','89',43,51),(187,'15','89',19,29),(188,'16','89',21,29),(189,'17','89',18,47),(190,'18','89',26,52),(191,'19','89',18,61),(192,'20','89',33,97),(193,'21','89',1,35),(194,'22','89',41,65),(195,'23','89',16,41),(196,'24','89',26,32),(197,'25','89',0,11),(198,'26','89',30,52),(199,'27'
/*!40000 ALTER TABLE `inventory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `location`
--
DROP TABLE IF EXISTS `location`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `location` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`street` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`zipcode` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`geo` point DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `location`
--
LOCK TABLES `location` WRITE;
/*!40000 ALTER TABLE `location` DISABLE KEYS */;
INSERT INTO `location` VALUES (2,'390 Lang Road','Burlingame',94010,'Bay Area Firearms','\0\0\0\0\0\0\0\"rU41<34>B@M6y%<25><>^<5E>'),(1,'7153 East Thomas Road','Scottsdale',85251,'Phoenix Equipment Rentals','\0\0\0\0\0\0\0Իx?n<>@@<40><>0 X<>[<5B>'),(4,'Tolstraat 200','Amsterdam',1074,'Munitions Shopmore','\0\0\0\0\0\0\0d3<64>11-J@\\<5C><>AA<41>@'),(5,'2799 Broadway','New York',10025,'Cascabel Armory','\0\0\0\0\0\0\0<><30>R<12>fD@ <09>L<EFBFBD><4C>}R<>'),(3,'1850 El Camino Real','Menlo Park',94027,'Military Weaponry','\0\0\0\0\0\0\0<>X<17>ѺB@<40><>\"<22>n<EFBFBD>^<5E>'),(6,'32/66-70 Marine Parade','Coolangatta',4225,'Marine Parade','\0\0\0\0\0\0\0<01>س<EFBFBD>*<<3C><>[<5B><>.1c@');
/*!40000 ALTER TABLE `location` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `session`
--
DROP TABLE IF EXISTS `session`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `session` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` varchar(255) DEFAULT NULL,
`ttl` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `session`
--
LOCK TABLES `session` WRITE;
/*!40000 ALTER TABLE `session` DISABLE KEYS */;
/*!40000 ALTER TABLE `session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `weapon`
--
DROP TABLE IF EXISTS `weapon`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `weapon` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`audibleRange` int(11) DEFAULT NULL,
`effectiveRange` int(11) DEFAULT NULL,
`rounds` int(11) DEFAULT NULL,
`extras` varchar(255) DEFAULT NULL,
`fireModes` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=87 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `weapon`
--
LOCK TABLES `weapon` WRITE;
/*!40000 ALTER TABLE `weapon` DISABLE KEYS */;
INSERT INTO `weapon` VALUES (1,'G17',53,75,15,'Flashlight','Single'),(2,'M1911',53,50,7,NULL,'Single'),(3,'M9',53,75,15,NULL,'Single'),(4,'M9 SD',0,75,15,'Silenced','Single'),(5,'Makarov SD',0,50,8,NULL,'Single'),(6,'PDW',53,75,30,NULL,'[\"Single\",\"Full auto\"]'),(7,'Makarov PM',53,50,8,NULL,'Single'),(9,'Saiga 12K',90,250,8,NULL,'Single'),(11,'Revolver',53,100,6,NULL,'Single'),(12,'Winchester 1866',125,150,15,NULL,'Single'),(13,'Bizon PP-19 SD',0,100,64,'Silenced','[\"Single\",\"Full auto\"]'),(14,'MP5SD6',0,100,30,'Silenced','[\"Single\",\"Burst\",\"Full auto\"]'),(15,'MP5A5',53,100,30,NULL,'[\"Single\",\"Burst\",\"Full auto\"]'),(16,'AK-107',80,400,30,'Kobra sight','[\"Single\",\"Burst\",\"Full auto\"]'),(18,'AK-107 GL PSO',80,400,30,'[\"Scope\",\"GP-25 launcher\"]','[\"Single\",\"Burst\",\"Full auto\"]'),(19,'AK-107 PSO',80,600,30,'Scope','[\"Single\",\"Burst\",\"Full auto\"]'),(20,'AK-74',80,300,30,NULL,'[\"Single\",\"Full auto\"]'),(21,'AKM',149,400,30,NULL,'[\"Single\",\"Full auto\"]'),(22,'AKS',149,200,30,NULL,'[\"Single\",\"Full auto\"]'),(23,'AKS (gold)',149,200,30,NULL,'[\"Single\",\"Full auto\"]'),(25,'AKS-74 Kobra',80,300,30,'Kobra sight','[\"Single\",\"Full auto\"]'),(26,'AKS-74 PSO',80,400,30,'Scope','[\"Single\",\"Full auto\"]'),(27,'AKS-74U',80,200,30,NULL,'[\"Single\",\"Full auto\"]'),(28,'AKS-74UN Kobra',0,300,30,'[\"Kobra sight\",\"Silenced\"]','[\"Single\",\"Full auto\"]'),(29,'AK-74 GP-25',80,300,30,'GP-25 launcher','[\"Single\",\"Full auto\"]'),(30,'FN FAL AN/PVS-4',180,400,20,'NV scope','[\"Single\",\"Burst\"]'),(31,'G36',80,400,30,'[\"Scope\",\"Aimpoint sight\"]','[\"Single\",\"Burst\",\"Full auto\"]'),(32,'FN FAL',180,400,20,NULL,'[\"Single\",\"Burst\"]'),(33,'G36 C',80,300,30,NULL,'[\"Single\",\"Burst\",\"Full auto\"]'),(34,'G36-C SD (camo)',0,300,30,'[\"Aimpoint sight\",\"Silenced\"]','[\"Single\",\"Burst\",\"Full auto\"]'),(35,'G36A (camo)',80,400,30,'[\"Scope\",\"Aimpoint sight\"]','[\"Single\",\"Burst\",\"Full auto\"]'),(36,'G36C (camo)',80,300,30,NULL,'[\"Single\",\"Burst\",\"Full auto\"]'),(37,'G36 K',80,400,30,'[\"Scope\",\"Aimpoint sight\"]','[\"Single\",\"Burst\",\"Full auto\"]'),(38,'G36C-SD',0,300,30,'Aimpoint sight','[\"Single\",\"Burst\",\"Full auto\"]'),(39,'G36K (camo)',80,400,30,'[\"Scope\",\"Aimpoint sight\"]','[\"Single\",\"Burst\",\"Full auto\"]'),(40,'L85A2 ACOG GL',80,600,30,'[\"ACOG scope\",\"M203 launcher\"]','[\"Single\",\"Full auto\"]'),(41,'L85A2 SUSAT',80,300,30,'SUSAT optical scope','[\"Single\",\"Full auto\"]'),(42,'M16A2',80,400,30,NULL,'[\"Single\",\"Burst\"]'),(43,'L85A2 AWS',80,300,30,'[\"Thermal scope\",\"NV scope\",\"Laser sight\",\"Variable zoom\"]','[\"Single\",\"Full auto\"]'),(44,'L85A2 Holo',80,300,30,'Holographic sight','[\"Single\",\"Full auto\"]'),(45,'Lee Enfield',162,400,10,NULL,'Single'),(46,'M16A4 ACOG',80,600,30,'ACOG scope','[\"Single\",\"Burst\"]'),(47,'M4A1',80,300,30,NULL,'[\"Single\",\"Full auto\"]'),(48,'M16A2 M203',80,400,30,'M203 launcher','[\"Single\",\"Burst\"]'),(49,'M4A1 Holo',80,300,30,'[\"Holographic sight\",\"M203 launcher\"]','[\"Single\",\"Full auto\"]'),(50,'M4A1 CCO',80,300,30,'Aimpoint sight','[\"Single\",\"Full auto\"]'),(51,'M4A1 CCO SD',0,200,30,'[\"Aimpoint sight\",\"Silenced\"]','[\"Single\",\"Full auto\"]'),(52,'M4A1 M203 RCO',80,600,30,'[\"ACOG sight\",\"M203 launcher\"]','[\"Single\",\"Full auto\"]'),(53,'M4A3 CCO',80,300,30,'[\"Aimpoint sight\",\"Flashlight\"]','[\"Single\",\"Full auto\"]'),(54,'RPK',80,400,30,NULL,'[\"Single\",\"Full auto\"]'),(55,'Sa-58 CCO',149,300,30,'Aimpoint sight','[\"Single\",\"Full auto\"]'),(56,'Sa-58P',149,400,30,NULL,'[\"Single\",\"Full auto\"]'),(57,'Sa-58V',149,200,30,NULL,'[\"Single\",\"Full auto\"]'),(58,'Sa-58V ACOG',149,400,30,'ACOG sight','[\"Single\",\"Full auto\"]'),(59,'ER7 RFW',180,2000,25,'[\"Scope\",\"Aimpoint sight\"]','Single'),(60,'AS50',455,1600,5,'Scope','Single'),(61,'KSVK',455,800,5,'Scope','Single'),(62,'CZ550',180,800,5,'Scope','Single'),(63,'DMR',180,800,20,'Scope','Single'),(64,'M107',455,1200,10,'Scope','Single'),(65,'M24',180,800,5,'Scope','Single'),(66,'M40A3',
/*!40000 ALTER TABLE `weapon` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2013-10-08 10:51:21