EG7rU2ZQ

1/*
2SQLyog Enterprise - MySQL GUI v8.12 
3MySQL - 5.0.45-log : Database - motorcycle
4*********************************************************************
5*/
6
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14
15CREATE DATABASE /*!32312 IF NOT EXISTS*/`motorcycle` /*!40100 DEFAULT CHARACTER SET latin1 */;
16
17USE `motorcycle`;
18
19/*Table structure for table `category_preorder_tree_data` */
20
21DROP TABLE IF EXISTS `category_preorder_tree_data`;
22
23CREATE TABLE `category_preorder_tree_data` (
24  `category_id` int(11) unsigned NOT NULL,
25  `left_value` int(10) unsigned NOT NULL,
26  `right_value` int(11) NOT NULL,
27  `category_link_type` varchar(20) NOT NULL,
28  PRIMARY KEY  (`category_id`),
29  UNIQUE KEY `category_id` (`category_id`),
30  KEY `left_valuerightvalue` (`left_value`,`right_value`),
31  KEY `left_value_only` (`left_value`),
32  KEY `right_value_only` (`right_value`),
33  KEY `category_andLeftVal` (`category_id`,`left_value`)
34) ENGINE=MyISAM DEFAULT CHARSET=latin1;
35
36/*Data for the table `category_preorder_tree_data` */
37
38insert  into `category_preorder_tree_data`(`category_id`,`left_value`,`right_value`,`category_link_type`) values (1087,0,937,'root'),(1070,283,713,'classification'),(1013,423,666,'category'),(1079,540,555,'specialization'),(1080,541,554,'specialization'),(1081,542,553,'specialization'),(1082,543,552,'specialization'),(1083,544,551,'category'),(1085,547,548,'specialization'),(1086,545,550,'specialization'),(1088,546,549,'specialization'),(1089,539,556,'specialization'),(1090,538,557,'specialization'),(1073,672,886,'classification'),(1001,859,876,'category'),(1091,866,869,'specialization'),(1092,867,868,'specialization'),(1093,537,558,'specialization'),(1094,536,559,'specialization'),(1095,535,560,'specialization'),(1096,534,561,'specialization'),(1097,533,562,'specialization'),(1098,532,563,'specialization'),(1109,408,409,'specialization'),(1108,401,416,'category'),(1015,367,380,'category'),(1110,407,410,'specialization'),(1111,381,400,'category'),(1112,391,392,'specialization'),(1036,890,919,'classification'),(1077,280,889,'specialization'),(1113,1,170,'classification'),(1114,531,564,'specialization'),(1002,835,858,'category'),(1003,821,834,'category'),(1006,819,820,'category'),(1018,795,818,'category'),(1004,781,794,'category'),(1031,765,780,'category'),(1008,749,764,'category'),(1064,739,748,'category'),(1011,733,738,'category'),(1010,713,732,'category'),(1027,52,53,'category'),(1022,132,169,'category'),(1065,133,134,'category'),(1034,130,131,'category'),(1030,104,129,'category'),(1032,82,103,'category'),(1026,74,81,'category'),(1033,54,73,'category'),(1028,32,51,'category'),(1029,22,31,'category'),(1023,8,21,'category'),(1016,349,366,'category'),(1019,347,348,'category'),(1068,335,346,'category'),(1012,323,334,'category'),(1115,373,374,'specialization'),(1116,530,565,'specialization'),(1117,529,566,'specialization'),(1118,528,567,'specialization'),(1119,527,568,'specialization'),(1120,526,569,'specialization'),(1121,525,570,'specialization'),(1122,524,571,'specialization'),(1123,523,572,'specialization'),(1124,522,573,'specialization'),(1125,521,574,'specialization'),(1126,520,575,'specialization'),(1127,519,576,'specialization'),(1128,518,577,'specialization'),(1129,517,578,'specialization'),(1130,516,579,'specialization'),(1131,515,580,'specialization'),(1132,514,581,'specialization'),(1133,513,582,'specialization'),(1134,512,583,'specialization'),(1135,511,584,'specialization'),(1136,489,564,'specialization'),(1137,509,586,'specialization'),(1138,508,587,'specialization'),(1139,507,588,'specialization'),(1140,506,589,'specialization'),(1141,505,590,'specialization'),(1142,504,591,'specialization'),(1143,503,592,'specialization'),(1144,502,593,'specialization'),(1145,501,594,'specialization'),(1146,500,595,'specialization'),(1147,499,596,'specialization'),(1148,498,597,'specialization'),(1149,497,598,'specialization'),(1150,496,599,'specialization'),(1151,495,600,'specialization'),(1152,494,601,'specialization'),(1153,493,602,'specialization'),(1154,492,603,'specialization'),(1155,491,604,'specialization'),(1156,490,605,'specialization'),(1157,489,606,'specialization'),(1158,488,607,'specialization'),(1159,487,608,'specialization'),(1160,486,609,'specialization'),(1161,485,610,'specialization'),(1162,484,611,'specialization'),(1163,483,612,'specialization'),(1164,482,613,'specialization'),(1165,481,614,'specialization'),(1166,480,615,'specialization'),(1167,479,616,'specialization'),(1168,478,617,'specialization'),(1169,477,618,'specialization'),(1170,476,619,'specialization'),(1171,475,620,'specialization'),(1172,474,621,'specialization'),(1173,473,622,'specialization'),(1174,472,623,'specialization'),(1175,471,624,'specialization'),(1176,470,625,'specialization'),(1177,469,626,'specialization'),(1178,468,627,'specialization'),(1179,467,628,'specialization'),(1180,466,629,'specialization'),(1181,465,630,'specialization'),(1182,464,631,'specialization'),(1183,463,632,'specialization'),(1184,462,633,'specialization'),(1185,461,634,'specialization'),(1186,459,460,'category'),(1187,458,635,'specialization'),(1188,390,393,'specialization'),(1189,389,394,'specialization'),(1190,388,395,'specialization'),(1192,387,396,'specialization'),(1193,305,322,'category'),(1194,313,314,'category'),(1195,312,315,'specialization'),(1196,311,316,'specialization'),(1197,310,317,'specialization'),(1198,309,318,'specialization'),(1199,304,712,'specialization'),(1200,457,636,'specialization'),(1201,456,637,'specialization'),(1202,455,638,'specialization'),(1203,454,639,'specialization'),(1204,453,640,'specialization'),(1205,452,641,'specialization'),(1206,451,642,'specialization'),(1207,450,643,'specialization'),(1208,449,644,'specialization'),(1209,448,645,'specialization'),(1210,447,646,'specialization'),(1211,446,647,'specialization'),(1212,445,648,'specialization'),(1213,444,649,'specialization'),(1214,443,650,'specialization'),(1215,442,651,'specialization'),(1216,441,652,'specialization'),(1217,308,319,'specialization'),(1218,307,320,'specialization'),(1219,440,653,'specialization'),(1220,439,654,'specialization'),(1221,438,655,'specialization'),(1222,437,656,'specialization'),(1223,436,657,'specialization'),(1224,865,870,'specialization'),(1225,846,847,'specialization'),(1226,845,848,'specialization'),(1227,844,849,'specialization'),(1244,370,377,'specialization'),(1229,693,698,'category'),(1240,695,696,'specialization'),(1243,371,376,'specialization'),(1242,372,375,'specialization'),(1241,694,697,'specialization'),(1245,843,850,'specialization'),(1246,842,851,'specialization'),(1247,841,852,'specialization'),(1248,840,853,'specialization'),(1249,839,854,'specialization'),(1250,838,855,'specialization'),(1251,837,856,'specialization'),(1441,289,302,'specialization'),(1253,787,788,'specialization'),(1254,786,789,'specialization'),(1255,785,790,'specialization'),(1256,784,791,'specialization'),(1257,783,792,'specialization'),(1258,756,757,'specialization'),(1259,755,758,'specialization'),(1260,827,828,'specialization'),(1261,826,829,'specialization'),(1262,825,830,'specialization'),(1263,824,831,'specialization'),(1264,823,832,'specialization'),(1265,722,723,'specialization'),(1266,721,724,'specialization'),(1267,720,725,'specialization'),(1268,719,726,'specialization'),(1269,4,7,'category'),(1270,5,6,'specialization'),(1271,718,727,'specialization'),(1272,717,728,'specialization'),(1273,716,729,'specialization'),(1274,715,730,'specialization'),(1275,63,64,'specialization'),(1276,62,65,'specialization'),(1277,61,66,'specialization'),(1278,60,67,'specialization'),(1279,59,68,'specialization'),(1280,58,69,'specialization'),(1281,56,71,'specialization'),(1282,55,72,'specialization'),(1283,116,117,'specialization'),(1284,115,118,'specialization'),(1285,114,119,'specialization'),(1286,113,120,'specialization'),(1287,112,121,'specialization'),(1288,111,122,'specialization'),(1289,110,123,'specialization'),(1290,109,124,'specialization'),(1291,108,125,'specialization'),(1292,107,126,'specialization'),(1293,106,127,'specialization'),(1294,105,128,'specialization'),(1295,2,3,'category'),(1296,685,690,'category'),(1297,687,688,'specialization'),(1298,686,689,'specialization'),(1299,735,736,'specialization'),(1300,734,737,'specialization'),(1301,92,93,'specialization'),(1302,91,94,'specialization'),(1303,90,95,'specialization'),(1304,89,96,'specialization'),(1305,88,97,'specialization'),(1306,87,98,'specialization'),(1307,86,99,'specialization'),(1308,85,100,'specialization'),(1309,84,101,'specialization'),(1310,284,303,'category'),(1311,295,296,'specialization'),(1312,294,297,'specialization'),(1313,293,298,'specialization'),(1314,292,299,'specialization'),(1315,291,300,'specialization'),(1316,369,378,'specialization'),(1317,684,884,'specialization'),(1318,863,872,'specialization'),(1319,862,873,'specialization'),(1320,861,874,'specialization'),(1321,860,875,'specialization'),(1322,806,807,'specialization'),(1323,805,808,'specialization'),(1324,77,78,'specialization'),(1325,76,79,'specialization'),(1326,75,80,'specialization'),(1327,357,358,'specialization'),(1328,356,359,'specialization'),(1329,355,360,'specialization'),(1330,354,361,'specialization'),(1331,353,362,'specialization'),(1332,352,363,'specialization'),(1333,151,152,'specialization'),(1334,150,153,'specialization'),(1335,149,154,'specialization'),(1336,148,155,'specialization'),(1337,147,156,'specialization'),(1338,146,157,'specialization'),(1339,145,158,'specialization'),(1340,144,159,'specialization'),(1341,143,160,'specialization'),(1342,142,161,'specialization'),(1343,141,162,'specialization'),(1344,140,163,'specialization'),(1345,139,164,'specialization'),(1346,138,165,'specialization'),(1347,137,166,'specialization'),(1348,136,167,'specialization'),(1349,135,168,'specialization'),(1350,26,27,'specialization'),(1351,57,70,'specialization'),(1352,25,28,'specialization'),(1353,24,29,'specialization'),(1354,23,30,'specialization'),(1355,804,809,'specialization'),(1356,836,857,'specialization'),(1357,822,833,'specialization'),(1358,803,810,'specialization'),(1359,802,811,'specialization'),(1360,801,812,'specialization'),(1361,800,813,'specialization'),(1362,799,814,'specialization'),(1363,798,815,'specialization'),(1364,797,816,'specialization'),(1365,796,817,'specialization'),(1366,754,759,'specialization'),(1367,753,760,'specialization'),(1368,752,761,'specialization'),(1369,751,762,'specialization'),(1370,750,763,'specialization'),(1371,406,411,'specialization'),(1372,405,412,'specialization'),(1373,404,413,'specialization'),(1374,403,414,'specialization'),(1375,743,744,'specialization'),(1376,742,745,'specialization'),(1377,741,746,'specialization'),(1378,740,747,'specialization'),(1379,673,682,'category'),(1381,677,678,'specialization'),(1382,14,15,'specialization'),(1383,13,16,'specialization'),(1384,12,17,'specialization'),(1385,11,18,'specialization'),(1386,10,19,'specialization'),(1387,9,20,'specialization'),(1388,386,397,'specialization'),(1389,385,398,'specialization'),(1390,402,415,'specialization'),(1391,368,379,'specialization'),(1392,328,329,'specialization'),(1393,306,321,'specialization'),(1394,351,364,'specialization'),(1395,327,330,'specialization'),(1396,326,331,'specialization'),(1397,325,332,'specialization'),(1398,324,333,'specialization'),(1399,435,658,'specialization'),(1400,290,301,'specialization'),(1401,340,341,'specialization'),(1402,339,342,'specialization'),(1403,338,343,'specialization'),(1404,337,344,'specialization'),(1405,336,345,'specialization'),(1406,434,659,'specialization'),(1407,433,660,'specialization'),(1408,773,774,'specialization'),(1409,772,775,'specialization'),(1410,771,776,'specialization'),(1411,770,777,'specialization'),(1412,769,778,'specialization'),(1413,768,779,'specialization'),(1414,676,679,'specialization'),(1415,675,680,'specialization'),(1416,674,681,'specialization'),(1417,41,42,'specialization'),(1418,40,43,'specialization'),(1419,39,44,'specialization'),(1420,38,45,'specialization'),(1421,37,46,'specialization'),(1422,36,47,'specialization'),(1423,83,102,'specialization'),(1424,35,48,'specialization'),(1425,34,49,'specialization'),(1426,33,50,'specialization'),(1427,911,912,'specialization'),(1428,905,918,'category'),(1429,910,913,'specialization'),(1430,909,914,'specialization'),(1431,908,915,'specialization'),(1432,893,904,'category'),(1433,898,899,'specialization'),(1434,907,916,'specialization'),(1435,897,900,'specialization'),(1436,896,901,'specialization'),(1437,895,902,'specialization'),(1438,894,903,'specialization'),(1439,906,917,'specialization'),(1440,891,892,'category'),(1442,287,288,'category'),(1443,350,365,'specialization'),(1444,384,399,'specialization'),(1445,432,661,'specialization'),(1446,766,767,'category'),(1447,782,793,'specialization'),(1448,285,286,'category'),(1449,714,731,'specialization'),(1450,431,662,'specialization'),(1451,430,663,'specialization'),(1452,429,664,'specialization'),(1453,428,665,'specialization'),(1454,382,383,'category'),(1455,426,427,'category'),(1456,424,425,'category');
39
40/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
41/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;