tree.sql

来自「tree控件 tree控件 tree控件 tree控件 tree控件」· SQL 代码 · 共 52 行

# MySQL-Front 3.2  (Build 7.2)
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES 'gb2312' */;


# Host: localhost    Database: demo
# ------------------------------------------------------
# Server version 4.1.18-nt

DROP DATABASE IF EXISTS `demo`;
CREATE DATABASE `demo` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `demo`;


/*!40101 SET NAMES latin1 */;

#
# Table structure for table tree
#

CREATE TABLE `tree` (
  `id` int(11) NOT NULL auto_increment,
  `pid` int(11) default NULL,
  `name` varchar(100) default NULL,
  `url` varchar(100) default NULL,
  `target` varchar(10) character set utf8 default '_blank',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

#
# Dumping data for table tree
#

/*!40101 SET NAMES gb2312 */;
INSERT INTO `tree` VALUES (1,0,'中国易成网','http://www.easydone.cn/','_blank');
INSERT INTO `tree` VALUES (2,1,'文化生活','http://easydone.cn/012/index.htm','_blank');
INSERT INTO `tree` VALUES (3,2,'天气预报','http://easydone.cn/weather/index.htm','_blank');
INSERT INTO `tree` VALUES (4,3,'北京','http://easydone.cn/weather/beijing.htm','_blank');
INSERT INTO `tree` VALUES (5,1,'网络编程','http://easydone.cn/014/index.htm','_blank');
INSERT INTO `tree` VALUES (6,0,'zaza 游戏','http://www.easydone.cn','_blank');

/*!40101 SET NAMES latin1 */;

/*!40101 SET NAMES gb2312 */;


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;