www.pudn.com > txl.rar > txl.sql

# SQL Manager 2007 for MySQL 4.1.2.1 
# --------------------------------------- 
# Host     : localhost 
# Port     : 3306 
# Database : txl 
 
 
SET FOREIGN_KEY_CHECKS=0; 
 
CREATE DATABASE `txl` 
    CHARACTER SET 'gbk' 
    COLLATE 'gbk_chinese_ci'; 
 
USE `txl`; 
 
# 
# Structure for the `depart` table :  
# 
 
CREATE TABLE `depart` ( 
  `id` int(11) NOT NULL auto_increment, 
  `unit` varchar(50) NOT NULL, 
  `depart` varchar(20) NOT NULL, 
  PRIMARY KEY  (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=gbk; 
 
# 
# Structure for the `unit` table :  
# 
 
CREATE TABLE `unit` ( 
  `id` int(11) NOT NULL auto_increment, 
  `unit_name` varchar(50) NOT NULL, 
  PRIMARY KEY  (`id`,`unit_name`) 
) ENGINE=MyISAM DEFAULT CHARSET=gbk; 
 
# 
# Data for the `depart` table  (LIMIT 0,500) 
# 
 
INSERT INTO `depart` (`id`, `unit`, `depart`) VALUES  
  (1,'领导\0t','集团公司领导\0?9?%'), 
  (2,'领导\0t','战略决策委员会\0is Emp'), 
  (3,'综合部\0 D','领导\0\0'), 
  (4,'发展战略部\0\0\0\0\0','企业策划 处\0\0\0\0?'); 
 
COMMIT; 
 
# 
# Data for the `unit` table  (LIMIT 0,500) 
# 
 
INSERT INTO `unit` (`id`, `unit_name`) VALUES  
  (1,'领导\0t'), 
  (2,'综合部\0\0\0'), 
  (3,'发展战略部\0\0\0\0\0'); 
 
COMMIT;