root/peasantonline/doc/db_data_no_creates.sql

Revision 72, 2.7 kB (checked in by james, 2 years ago)

data package of all current categories and designers off of the site to import after 'rake db:migrate' has done its thing - to help us keep our test data in sync

Line 
1 -- MySQL dump 10.10
2 --
3 -- Host: localhost    Database: peasantonline_development
4 -- ------------------------------------------------------
5 -- Server version       5.0.24-standard
6
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18 --
19 -- Dumping data for table `categories`
20 --
21
22
23 /*!40000 ALTER TABLE `categories` DISABLE KEYS */;
24 LOCK TABLES `categories` WRITE;
25 INSERT INTO `categories` VALUES (1,'Accessories','x','x',''),(2,'Apothecary','x','x',''),(3,'Denim','x','x',''),(4,'Jackets','x','x',''),(5,'Pants','x','x',''),(6,'Shirts','x','x',''),(7,'Tees & Polos','x','x',''),(8,'Shoes','x','x',''),(9,'Shorts','x','x',''),(10,'Outerwear','x','x','');
26 UNLOCK TABLES;
27 /*!40000 ALTER TABLE `categories` ENABLE KEYS */;
28
29 --
30 -- Dumping data for table `designers`
31 --
32
33
34 /*!40000 ALTER TABLE `designers` DISABLE KEYS */;
35 LOCK TABLES `designers` WRITE;
36 INSERT INTO `designers` VALUES (1,'120% lino','x','x',NULL),(2,'belstaff','x','x',NULL),(3,'edun','x','x',NULL),(4,'engineered garments','x','x',NULL),(5,'generra','x','x',NULL),(6,'jack spade','x','x',NULL),(7,'ndc','x','x',NULL),(8,'rogan','x','x',NULL),(9,'rogues gallery','x','x',NULL),(10,'steven alan','x','x',NULL),(11,'troglodyte homunculus','x','x',NULL),(12,'obedient sons','x','x',NULL),(13,'habitual','x','x',NULL),(14,'sharps','x','x',NULL);
37 UNLOCK TABLES;
38 /*!40000 ALTER TABLE `designers` ENABLE KEYS */;
39
40 --
41 -- Dumping data for table `products`
42 --
43
44
45 /*!40000 ALTER TABLE `products` DISABLE KEYS */;
46 LOCK TABLES `products` WRITE;
47 UNLOCK TABLES;
48 /*!40000 ALTER TABLE `products` ENABLE KEYS */;
49
50 --
51 -- Dumping data for table `schema_info`
52 --
53
54
55 /*!40000 ALTER TABLE `schema_info` DISABLE KEYS */;
56 LOCK TABLES `schema_info` WRITE;
57 INSERT INTO `schema_info` VALUES (3);
58 UNLOCK TABLES;
59 /*!40000 ALTER TABLE `schema_info` ENABLE KEYS */;
60 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
61
62 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
63 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
64 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
65 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
66 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
67 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
68 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
69
Note: See TracBrowser for help on using the browser.