· 8 years ago · Jan 24, 2018, 05:50 AM
1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version 5.1.58-1ubuntu1
5
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
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17--
18-- Create schema softcotton
19--
20
21CREATE DATABASE IF NOT EXISTS softcotton;
22USE softcotton;
23
24--
25-- Definition of table `softcotton`.`product_cat_connector`
26--
27
28DROP TABLE IF EXISTS `softcotton`.`product_cat_connector`;
29CREATE TABLE `softcotton`.`product_cat_connector` (
30 `product_id` int(10) unsigned NOT NULL,
31 `cat_id` int(10) unsigned NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34--
35-- Dumping data for table `softcotton`.`product_cat_connector`
36--
37
38/*!40000 ALTER TABLE `product_cat_connector` DISABLE KEYS */;
39LOCK TABLES `product_cat_connector` WRITE;
40INSERT INTO `softcotton`.`product_cat_connector` VALUES (6,100009),
41 (6,100011),
42 (6,100014),
43 (7,100009),
44 (7,100011),
45 (7,100014),
46 (8,100008),
47 (8,100011),
48 (8,100014),
49 (9,100008),
50 (9,100011),
51 (9,100014),
52 (10,100008),
53 (10,100011),
54 (10,100014),
55 (11,100008),
56 (11,100011),
57 (11,100014),
58 (12,100008),
59 (12,100012),
60 (12,100014),
61 (13,100008),
62 (13,100012),
63 (13,100014),
64 (14,100008),
65 (14,100012),
66 (14,100014),
67 (15,100008),
68 (15,100009),
69 (16,100008),
70 (16,100009),
71 (17,100008),
72 (17,100009),
73 (17,100011),
74 (18,100008),
75 (18,100009),
76 (19,100008),
77 (19,100009),
78 (19,100011),
79 (20,100008),
80 (20,100009);
81UNLOCK TABLES;
82/*!40000 ALTER TABLE `product_cat_connector` ENABLE KEYS */;
83
84
85--
86-- Definition of table `softcotton`.`products_cats`
87--
88
89DROP TABLE IF EXISTS `softcotton`.`products_cats`;
90CREATE TABLE `softcotton`.`products_cats` (
91 `cat_id` int(10) NOT NULL AUTO_INCREMENT,
92 `cat_type` varchar(50) NOT NULL,
93 `cat_name_key` varchar(45) NOT NULL,
94 `cat_seo` varchar(255) NOT NULL,
95 `parent_cat_id` int(10) NOT NULL,
96 `cat_description_key` text NOT NULL,
97 `cat_discount` float NOT NULL,
98 `cat_order` int(5) NOT NULL,
99 `cat_status` enum('0','1','2') NOT NULL,
100 PRIMARY KEY (`cat_id`)
101) ENGINE=InnoDB AUTO_INCREMENT=100013 DEFAULT CHARSET=utf8;
102
103--
104-- Dumping data for table `softcotton`.`products_cats`
105--
106
107/*!40000 ALTER TABLE `products_cats` DISABLE KEYS */;
108LOCK TABLES `products_cats` WRITE;
109INSERT INTO `softcotton`.`products_cats` VALUES (-1,'shop','7734330394e842b761fe629.35253946','Ana-Kategori',0,'2484428244e842b76213908.36038180',0,8,'1'),
110 (100006,'shop','1187590984e8b6c44c76921.98767622','Bornoz',-1,'9514077814e8b6c458f0f92.08813790',2,12,'1'),
111 (100007,'shop','5849293844e8b6c54cff5d3.21414729','Havlu',-1,'8632963844e8b6c54f3d983.95174663',3,9,'1'),
112 (100008,'shop','1199282354e8b6c6913abe7.36202049','cocukB',100006,'1378525834e8b6c693bcbf9.83445101',0,10,'1'),
113 (100009,'shop','8572880904e8b6c77a2f8c6.86908841','cocukH',100007,'1592934244e8b6c77cead06.33460551',0,11,'1'),
114 (100010,'collection','6549394974e8b6ecf82dd60.76805896','cocukH-111139',-1,'4700067164e8b6ecfbd3d57.05221542',0,14,'1'),
115 (100011,'collection','1916153314e8ed3dd2eb091.80016848','Asdad',100010,'5395898194e8ed3dd518873.21031076',123,13,'1'),
116 (100012,'collection','5804642094e8eda7531ed71.51892760','asdassdasd-ad-asd-asd-asd',100010,'7916063504e8eda75611f72.52807911',213131,15,'1');
117UNLOCK TABLES;
118/*!40000 ALTER TABLE `products_cats` ENABLE KEYS */;
119
120
121--
122-- Definition of table `softcotton`.`products_main`
123--
124
125DROP TABLE IF EXISTS `softcotton`.`products_main`;
126CREATE TABLE `softcotton`.`products_main` (
127 `product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
128 `product_name_key` varchar(45) NOT NULL,
129 `product_detail_key` varchar(45) NOT NULL,
130 `product_seo_key` varchar(255) NOT NULL,
131 `product_order` int(5) unsigned NOT NULL,
132 `product_hit` int(5) unsigned NOT NULL,
133 `product_status` enum('0','1','2') NOT NULL,
134 PRIMARY KEY (`product_id`)
135) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
136
137--
138-- Dumping data for table `softcotton`.`products_main`
139--
140
141/*!40000 ALTER TABLE `products_main` DISABLE KEYS */;
142LOCK TABLES `products_main` WRITE;
143INSERT INTO `softcotton`.`products_main` VALUES (2,'5641110044e8c5fe30709b8.81438694','4850459304e8c5fe32b4040.08451108','asd',1,0,'1'),
144 (3,'2333259544e8cc0260b8691.07988089','4392769564e8cc0264b0499.73194219','a',2,0,'1'),
145 (4,'2942483874e8f2e49f12ff0.23702679','5118166974e8f2e4a2aa654.07438190','Test-urunu',3,0,'1'),
146 (5,'7123857774e8f2e77391628.16043488','3539812004e8f2e77698643.54426270','Test-urunu-110711',4,0,'1'),
147 (6,'6852926684e8f35c461aae5.05200389','5998868944e8f35c488f164.34552686','Test-urunu-110820',5,0,'1'),
148 (7,'2057736394e8f3948e210d5.56633254','7276669534e8f39491f19f9.03578623','Test-urunu-110820-110820',6,0,'1'),
149 (8,'6614956034e8f39b437f5e0.99126764','1196239914e8f39b463c177.60324813','sad',7,0,'1'),
150 (9,'7500717614e8f3dc55d3bb5.20016177','1058375164e8f3dc5896648.48470628','sad-110829',8,0,'1'),
151 (10,'3232978784e8f4346643492.54132570','6155585414e8f43468a14b1.84045727','sad-110958',88,0,'1'),
152 (11,'2073661754e8f43f09b62a3.02338167','6033559714e8f43f0cc62d6.18136210','sad-110948',10,0,'1'),
153 (12,'4715689724e92ab3abe3801.60075957','2959011114e92ab3ae03fd8.39507757','Kasitli-urun',11,0,'1'),
154 (13,'2574448574e92abcd924416.82665094','1858733854e92abcdbb0950.75016209','Kasitli-urun-111145',12,0,'1'),
155 (14,'7457216974e92ac2cdf3d98.15977602','1711555454e92ac2d1c05f4.29568119','Kasitli-urun-111120',13,0,'1'),
156 (15,'9192663744e92ac768d4087.82444549','1559739854e92ac76b795b6.82309966','asda',14,0,'1'),
157 (16,'3479510034e92ac8bf26762.94555586','5774213384e92ac8c2e48e2.28939053','asda-111155',15,0,'1'),
158 (17,'3756270144e93ebf2cc7e32.20482984','1314226084e93ebf30671e6.21013350','TEst',16,0,'1'),
159 (18,'7464991754e941f07b70440.03259613','7760394724e941f07e1c908.13902763','adsad',17,0,'1'),
160 (19,'9123018044e9427bfb86da4.94804989','8787523304e9427c0042a10.88381962','asda-110251',18,0,'1'),
161 (20,'6788228824e9bdbf64cc1f3.64789218','8345631374e9bdbf676f623.29989204','Elbise-Askisi',19,0,'1');
162UNLOCK TABLES;
163/*!40000 ALTER TABLE `products_main` ENABLE KEYS */;
164
165
166
167
168/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
169/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
170/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
171/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
172/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
173/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
174/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;