DB_51aspx/salarydb.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
MySQL Data Transfer
Source Host: localhost
Source Database: salarydb
Target Host: localhost
Target Database: salarydb
Date: 2014/3/27 22:26:32
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for cdrecord
-- ----------------------------
DROP TABLE IF EXISTS `cdrecord`;
CREATE TABLE `cdrecord` (
  `id` int(11) NOT NULL auto_increment,
  `uid` varchar(255) default NULL,
  `cdcount` varchar(255) default NULL,
  `month` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for emps
-- ----------------------------
DROP TABLE IF EXISTS `emps`;
CREATE TABLE `emps` (
  `id` int(50) NOT NULL auto_increment,
  `uname` varchar(500) default NULL,
  `upass` varchar(500) default NULL,
  `uno` varchar(500) default NULL,
  `tname` varchar(500) default NULL,
  `sex` varchar(500) default NULL,
  `age` varchar(500) default NULL,
  `tel` varchar(500) default NULL,
  `addr` varchar(500) default NULL,
  `zw` varchar(500) default NULL,
  `cardno` varchar(500) default NULL,
  `rztime` varchar(500) default NULL,
  `gn` varchar(500) default NULL,
  `utype` varchar(255) default NULL,
  `jbsalary` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for salary
-- ----------------------------
DROP TABLE IF EXISTS `salary`;
CREATE TABLE `salary` (
  `id` int(50) NOT NULL auto_increment,
  `uid` varchar(50) default NULL,
  `moth` varchar(50) default NULL,
  `jbgz` varchar(50) default NULL,
  `gwgz` varchar(50) default NULL,
  `cheb` varchar(50) default NULL,
  `canb` varchar(50) default NULL,
  `yj` varchar(50) default NULL,
  `jx` varchar(50) default NULL,
  PRIMARY KEY  (`id`)