sanguo.sql

ssh分页的一个例子内含数据库文件 在src文件夹下自己找

# MySQL-Front 3.2  (Build 14.3)

/*!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 gbk */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost    Database: sanguo
# ------------------------------------------------------
# Server version 5.0.22-community-nt

DROP DATABASE IF EXISTS `sanguo`;
CREATE DATABASE `sanguo` /*!40100 DEFAULT CHARACTER SET gbk */;
USE `sanguo`;

#
# Table structure for table department
#

CREATE TABLE `department` (
  `id` int(11) NOT NULL auto_increment,
  `deptName` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table department
#

INSERT INTO `department` VALUES (1,'蜀国');
INSERT INTO `department` VALUES (2,'魏国');
INSERT INTO `department` VALUES (3,'吴国');
INSERT INTO `department` VALUES (4,'其他');

#
# Table structure for table person
#

CREATE TABLE `person` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `age` int(11) default NULL,
  `address` varchar(50) default NULL,
  `dept_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `dept_id` (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table person
#

INSERT INTO `person` VALUES (1,'张飞(翼德)',23,'河北西乡(幽州涿郡)',1);
INSERT INTO `person` VALUES (2,'关羽(云长)',24,'山西运城(并州河东解县)',1);
INSERT INTO `person` VALUES (3,'刘备(玄德)',25,'河北涿州(幽州涿郡涿县)',1);
INSERT INTO `person` VALUES (4,'曹操(孟德)',26,'安徽亳州(兖州沛国谯县)',2);
INSERT INTO `person` VALUES (5,'赵云(子龙)',18,'河北正定(冀州常山真定)',1);
INSERT INTO `person` VALUES (6,'黄忠(汉升)',45,'河南南阳(荆州南阳)',1);
INSERT INTO `person` VALUES (7,'魏延(文长)',20,'河南桐柏(荆州益阳郡)',1);
INSERT INTO `person` VALUES (8,'貂蝉(无)',18,'不详',4);
INSERT INTO `person` VALUES (9,'黄盖(公覆)',36,'湖南零陵(荆州零陵泉陵)',3);
INSERT INTO `person` VALUES (10,'孙权(仲谋)',21,'浙江富阳(扬州吴郡富春)',3);
INSERT INTO `person` VALUES (11,'诸葛亮(孔明)',17,'山东沂南县南(徐州琅邪都)',1);
INSERT INTO `person` VALUES (12,'大乔(无)',18,'安徽潜山(扬州庐江皖县)',3);
INSERT INTO `person` VALUES (13,'马超(孟起)',19,'陕西兴平(司州扶风茂陵)',1);
INSERT INTO `person` VALUES (14,'张辽(文远)',28,'雁门马邑 (山西朔县)',2);
INSERT INTO `person` VALUES (15,'吕布(奉先)',27,'内蒙古包头(并州五原郡九原)',4);
INSERT INTO `person` VALUES (16,'董卓(仲颖)',30,'甘肃临洮(凉州陇西临洮)',4);
INSERT INTO `person` VALUES (17,'贾诩(文和)',29,'甘肃武威(凉州武威姑臧)',2);
INSERT INTO `person` VALUES (18,'小乔(无)',17,'安徽潜山(扬州庐江皖县)',3);
INSERT INTO `person` VALUES (19,'袁绍(本初)',32,'河南汝阳(豫州汝南汝阳)',4);
INSERT INTO `person` VALUES (20,'太史慈(子义)',38,'东莱黄县 (今山东龙口)',3);
INSERT INTO `person` VALUES (21,'司马懿(仲达)',28,'河南温县(司州河内温县)',2);
INSERT INTO `person` VALUES (22,'甘宁(兴霸)',16,'重庆忠县(益州巴郡临江)',3);
INSERT INTO `person` VALUES (23,'张郃(俊乂)',24,'河北任丘北(冀州河间鄚县)',2);
INSERT INTO `person` VALUES (24,'庞德(令明)',20,'甘肃陇西东南(雍州南安狄道)',2);
INSERT INTO `person` VALUES (25,'周泰(幼平)',21,'安徽凤台(扬州九江下蔡)',3);
INSERT INTO `person` VALUES (26,'法正(孝直)',20,'陕西眉县(雍州扶风郿县)',1);
INSERT INTO `person` VALUES (27,'许褚(仲康)',21,'安徽毫州(豫州谯国谯县)',2);
INSERT INTO `person` VALUES (28,'陆逊(伯言)',18,'上海松江(扬州吴郡吴县华亭)',3);
INSERT INTO `person` VALUES (29,'徐庶(元直)',22,'河南许昌一带(豫州颍川郡)',2);
INSERT INTO `person` VALUES (30,'孔融(文举)',24,'山东曲阜(鲁国)',2);
INSERT INTO `person` VALUES (31,'郭嘉(奉孝)',31,'河南禹州(豫州颖川阳翟)',2);
INSERT INTO `person` VALUES (32,'乐进(文谦)',37,'阳平卫国(河南清丰)',2);
INSERT INTO `person` VALUES (33,'夏侯渊(妙才)',32,'安徽亳州(兖州沛国谯县)',2);
INSERT INTO `person` VALUES (34,'夏侯惇(元让)',34,'安徽亳州(兖州沛国谯县)',2);

#
#  Foreign keys for table person
#

ALTER TABLE `person`
  ADD FOREIGN KEY (`dept_id`) REFERENCES `department` (`id`);


/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!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 */;