www.pudn.com > easyjferp.rar > mysql.sql

# MySQL-Front 3.2  (Build 8.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 */; 
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */; 
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */; 
 
/*!40101 SET NAMES gbk */; 
/*!40103 SET TIME_ZONE='SYSTEM' */; 
 
# Host: localhost    Database: easyerp 
# ------------------------------------------------------ 
# Server version 5.0.15-nt 
 
DROP DATABASE IF EXISTS `easyerp`; 
CREATE DATABASE `easyerp` /*!40100 DEFAULT CHARACTER SET gb2312 */; 
USE `easyerp`; 
 
/*!40101 SET NAMES gb2312 */; 
 
# 
# Table structure for table customer 
# 
 
CREATE TABLE `customer` ( 
  `cid` varchar(16) NOT NULL, 
  `belongDept` varchar(16) NOT NULL, 
  `sn` varchar(16) NOT NULL, 
  `title` varchar(100) NOT NULL, 
  `types` varchar(16) default NULL, 
  `leader` varchar(50) default NULL, 
  `linkMan` varchar(50) default NULL, 
  `tel` varchar(50) default NULL, 
  `address` varchar(50) default NULL, 
  `zip` varchar(20) default NULL, 
  `fax` varchar(50) default NULL, 
  `email` varchar(50) default NULL, 
  `homePage` varchar(50) default NULL, 
  `source` varchar(50) default NULL, 
  `rank` varchar(50) default NULL, 
  `intro` text, 
  `remark` text, 
  `inputUser` varchar(16) default NULL, 
  `inputTime` datetime default NULL, 
  `status` int(11) default NULL, 
  `province` varchar(50) default NULL, 
  `city` varchar(50) default NULL, 
  `town` varchar(50) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table customer 
# 
 
 
 
# 
# Table structure for table customerprice 
# 
 
CREATE TABLE `customerprice` ( 
  `cid` varchar(16) NOT NULL, 
  `belongDept` varchar(16) default NULL, 
  `customerSn` varchar(16) default NULL, 
  `productSn` text, 
  `price` decimal(19,4) default NULL, 
  `unit` varchar(16) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table customerprice 
# 
 
 
 
# 
# Table structure for table material 
# 
 
CREATE TABLE `material` ( 
  `cid` varchar(16) NOT NULL, 
  `belongDept` varchar(16) NOT NULL, 
  `title` varchar(50) default NULL, 
  `types` varchar(16) default NULL, 
  `source` varchar(50) default NULL, 
  `provider` varchar(50) default NULL, 
  `price` decimal(19,4) default NULL, 
  `unit` varchar(16) default NULL, 
  `intro` text, 
  `remark` text, 
  `inputUser` varchar(16) default NULL, 
  `inputTime` datetime default NULL, 
  `status` int(11) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table material 
# 
 
 
 
# 
# Table structure for table orderinfo 
# 
 
CREATE TABLE `orderinfo` ( 
  `cid` varchar(16) NOT NULL, 
  `belongDept` varchar(16) NOT NULL, 
  `sn` varchar(16) NOT NULL, 
  `customerSn` varchar(16) default NULL, 
  `vdate` datetime default NULL, 
  `requireDate` datetime default NULL, 
  `payType` varchar(16) default NULL, 
  `linkMan` varchar(50) default NULL, 
  `tel` varchar(50) default NULL, 
  `address` varchar(50) default NULL, 
  `requirement` text, 
  `remark` text, 
  `amount` decimal(19,4) default NULL, 
  `handPerson` varchar(16) default NULL, 
  `inputUser` varchar(16) default NULL, 
  `inputTime` datetime default NULL, 
  `opUser` varchar(16) default NULL, 
  `opIntro` text, 
  `opTime` datetime default NULL, 
  `status` int(11) default NULL, 
  `payment` int(11) default NULL, 
  `delivery` int(11) default NULL, 
  `deliveryDept` varchar(16) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table orderinfo 
# 
 
 
 
# 
# Table structure for table orderlist 
# 
 
CREATE TABLE `orderlist` ( 
  `cid` varchar(16) NOT NULL, 
  `orderSn` varchar(16) default NULL, 
  `productSn` varchar(16) default NULL, 
  `title` varchar(50) default NULL, 
  `types` varchar(16) default NULL, 
  `num` double default NULL, 
  `price` decimal(19,4) default NULL, 
  `amount` decimal(19,4) default NULL, 
  `unit` varchar(16) default NULL, 
  `status` int(11) default NULL, 
  `sequence` int(11) default NULL, 
  `width` double default NULL, 
  `height` double default NULL, 
  `unitType` int(11) default NULL, 
  `cou` int(11) default NULL, 
  `vdate` datetime default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table orderlist 
# 
 
 
 
# 
# Table structure for table product 
# 
 
CREATE TABLE `product` ( 
  `cid` varchar(16) NOT NULL, 
  `belongDept` varchar(16) default NULL, 
  `sn` varchar(16) default NULL, 
  `title` varchar(50) default NULL, 
  `types` varchar(16) default NULL, 
  `dir` varchar(16) default NULL, 
  `unit` varchar(16) default NULL, 
  `buyPrice` decimal(19,4) default NULL, 
  `salePrice` decimal(19,4) default NULL, 
  `pic` varchar(50) default NULL, 
  `intro` text, 
  `remark` text, 
  `inputUser` varchar(16) default NULL, 
  `inputTime` datetime default NULL, 
  `status` int(11) default NULL, 
  `initNum` int(11) default NULL, 
  `planNum` int(11) default NULL, 
  `factNum` int(11) default NULL, 
  `amount` decimal(19,4) default NULL, 
  `qkDate` datetime default NULL, 
  `pdDate` datetime default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table product 
# 
 
 
 
# 
# Table structure for table ration 
# 
 
CREATE TABLE `ration` ( 
  `cid` varchar(16) NOT NULL, 
  `belongDept` varchar(16) default NULL, 
  `productSn` varchar(16) default NULL, 
  `materialSn` varchar(16) default NULL, 
  `rate` double default NULL, 
  `unit` varchar(16) default NULL, 
  `remark` text, 
  `inputUser` varchar(16) default NULL, 
  `inputTime` datetime default NULL, 
  `status` int(11) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table ration 
# 
 
 
 
# 
# Table structure for table systembasicdata 
# 
 
CREATE TABLE `systembasicdata` ( 
  `cid` varchar(16) NOT NULL, 
  `belongDept` varchar(16) default NULL, 
  `sn` varchar(16) default NULL, 
  `title` varchar(100) default NULL, 
  `intro` text, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table systembasicdata 
# 
 
 
 
# 
# Table structure for table systembasicdatadetail 
# 
 
CREATE TABLE `systembasicdatadetail` ( 
  `cid` varchar(16) NOT NULL, 
  `parentSn` varchar(16) default NULL, 
  `title` varchar(50) default NULL, 
  `tvalue` varchar(50) default NULL, 
  `sequence` int(11) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table systembasicdatadetail 
# 
 
 
 
# 
# Table structure for table systemdept 
# 
 
CREATE TABLE `systemdept` ( 
  `cid` varchar(16) NOT NULL, 
  `sn` varchar(16) default NULL, 
  `title` varchar(100) default NULL, 
  `address` varchar(100) default NULL, 
  `tel` varchar(50) default NULL, 
  `email` varchar(50) default NULL, 
  `linkMan` varchar(16) default NULL, 
  `manager` varchar(16) default NULL, 
  `types` varchar(16) default NULL, 
  `intro` text, 
  `remark` text, 
  `inputUser` varchar(16) default NULL, 
  `inputTime` datetime default NULL, 
  `lastLoginTime` datetime default NULL, 
  `loginTimes` int(11) default NULL, 
  `status` int(11) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table systemdept 
# 
 
 
 
# 
# Table structure for table systemloginfo 
# 
 
CREATE TABLE `systemloginfo` ( 
  `cid` varchar(16) NOT NULL, 
  `belongDept` varchar(16) default NULL, 
  `opType` varchar(16) default NULL, 
  `intro` text, 
  `vdate` datetime default NULL, 
  `userName` varchar(16) default NULL, 
  `ip` varchar(50) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table systemloginfo 
# 
 
 
 
# 
# Table structure for table systemregion 
# 
 
CREATE TABLE `systemregion` ( 
  `title` varchar(64) default NULL, 
  `sequence` int(11) default NULL, 
  `parentSn` varchar(64) default NULL, 
  `lev` int(11) default NULL, 
  `inputTime` datetime default NULL, 
  `inputUser` varchar(20) default NULL, 
  `sn` varchar(64) NOT NULL, 
  `cid` varchar(16) NOT NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table systemregion 
# 
 
 
 
# 
# Table structure for table systemrole 
# 
 
CREATE TABLE `systemrole` ( 
  `cid` varchar(16) NOT NULL, 
  `sn` varchar(16) NOT NULL, 
  `title` varchar(50) default NULL, 
  `intro` text, 
  `roleValue` varchar(50) default NULL, 
  `status` int(11) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table systemrole 
# 
 
 
 
# 
# Table structure for table systemuser 
# 
 
CREATE TABLE `systemuser` ( 
  `cid` varchar(16) NOT NULL, 
  `belongDept` varchar(16) default NULL, 
  `userName` varchar(16) default NULL, 
  `password` varchar(16) default NULL, 
  `email` varchar(50) default NULL, 
  `trueName` varchar(50) default NULL, 
  `tel` varchar(50) default NULL, 
  `role` varchar(16) default NULL, 
  `lastLoginTime` datetime default NULL, 
  `lastLoginIP` varchar(50) default NULL, 
  `loginTimes` int(11) default NULL, 
  `inputUser` varchar(16) default NULL, 
  `inputTime` datetime default NULL, 
  `status` int(11) default NULL, 
  PRIMARY KEY  (`cid`) 
) ENGINE=InnoDB DEFAULT CHARSET=gb2312; 
 
# 
# Dumping data for table systemuser 
# 
 
INSERT INTO `systemuser` VALUES ('113613333703233','easyjf','admin','123',NULL,'³¬¼¶¹ÜÀíÔ±',NULL,'administrator',NULL,'127.0.0.1',9,NULL,'2006-01-01 23:24:26',0); 
 
/*!40101 SET NAMES gbk */; 
 
/*!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 */; 
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;