/*
 
Navicat MySQL Data Transfer
 
 
Source Server         : mysqllocal
 
Source Server Version : 50505
 
Source Host           : localhost:3306
 
Source Database       : hk
 
 
Target Server Type    : MYSQL
 
Target Server Version : 50505
 
File Encoding         : 65001
 
 
Date: 2016-05-18 23:25:10
 
*/
 
 
SET FOREIGN_KEY_CHECKS=0;
 
 
-- ----------------------------
 
-- Table structure for hk
 
-- ----------------------------
 
DROP TABLE IF EXISTS `hk`;
 
CREATE TABLE `hk` (
 
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
  `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_persian_ci NOT NULL,
 
  `parent_id` int(11) DEFAULT NULL,
 
  PRIMARY KEY (`id`)
 
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
 
 
-- ----------------------------
 
-- Records of hk
 
-- ----------------------------
 
INSERT INTO `hk` VALUES ('1', 'Software', '0');
 
INSERT INTO `hk` VALUES ('2', 'Programming', '1');
 
INSERT INTO `hk` VALUES ('3', 'Web', '2');
 
INSERT INTO `hk` VALUES ('4', 'Windows', '2');
 
INSERT INTO `hk` VALUES ('5', 'Graphic', '1');
 
INSERT INTO `hk` VALUES ('6', 'Photoshop', '5');
 
INSERT INTO `hk` VALUES ('7', 'Freehand', '5');
 
INSERT INTO `hk` VALUES ('8', 'PHP', '3');
 
INSERT INTO `hk` VALUES ('9', 'ASP.NET', '3');
 
INSERT INTO `hk` VALUES ('10', 'Hardware', '0');
 
INSERT INTO `hk` VALUES ('11', 'Network', '0');
 
INSERT INTO `hk` VALUES ('12', 'Monitor', '10');
 
INSERT INTO `hk` VALUES ('13', 'LCD', '12');
 
INSERT INTO `hk` VALUES ('14', 'CRT', '12');
 
 
-- ----------------------------
 
-- Table structure for rtl
 
-- ----------------------------
 
DROP TABLE IF EXISTS `rtl`;
 
CREATE TABLE `rtl` (
 
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
  `title` varchar(100) CHARACTER SET utf8 NOT NULL,
 
  `parent_id` int(11) DEFAULT NULL,
 
  PRIMARY KEY (`id`)
 
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf32 COLLATE=utf32_unicode_ci;
 
 
-- ----------------------------
 
-- Records of rtl
 
-- ----------------------------
 
INSERT INTO `rtl` VALUES ('1', 'نرم افزار', '0');
 
INSERT INTO `rtl` VALUES ('2', 'برنامه نویسی', '1');
 
INSERT INTO `rtl` VALUES ('3', 'وب', '2');
 
INSERT INTO `rtl` VALUES ('4', 'ویندوز', '2');
 
INSERT INTO `rtl` VALUES ('5', 'گرافیک', '1');
 
INSERT INTO `rtl` VALUES ('6', 'فتوشاپ', '5');
 
INSERT INTO `rtl` VALUES ('7', 'فری هند', '5');
 
INSERT INTO `rtl` VALUES ('8', 'پی اچ پی', '3');
 
INSERT INTO `rtl` VALUES ('9', 'دات نت', '3');
 
INSERT INTO `rtl` VALUES ('10', 'سخت افزار', '0');
 
INSERT INTO `rtl` VALUES ('11', 'شبکه', '0');
 
INSERT INTO `rtl` VALUES ('12', 'مانیتور', '10');
 
INSERT INTO `rtl` VALUES ('13', 'ال سی دی', '12');
 
INSERT INTO `rtl` VALUES ('14', 'ال ای دی', '12');
 
 
 |