PHP Classes
elePHPant
Icontem

File: hk.sql

Recommend this page to a friend!
  Classes of Mohammad Keramatifar  >  PHP TreeView  >  hk.sql  >  Download  
File: hk.sql
Role: Example script
Content type: text/plain
Description: Mysql sample database
Class: PHP TreeView
Display a collapsible tree from a MySQL query
Author: By
Last change: Example of a hierarchy database
Added a table named RTL with Persian data for RightToLeft Usage
Date: 1 month ago
Size: 3,152 bytes
 

Contents

Class file image Download
/*
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');