# Dump for Database caiwu
CREATE DATABASE caiwu;
# Dumping Table class
#
CREATE TABLE class (
id int(4) NOT NULL auto_increment,
name varchar(20) NOT NULL ,
PRIMARY KEY (id),
KEY name (name)
);
# Dumping Data - 1 rows
INSERT INTO class VALUES(1,"财务处");
# Dumping Table master
#
CREATE TABLE master (
id int(4) NOT NULL auto_increment,
name varchar(20) NOT NULL ,
truename varchar(20) NOT NULL ,
pass varchar(20) NOT NULL ,
joindate varchar(10) NOT NULL ,
classid int(4) NOT NULL ,
loginnum int(10) NOT NULL ,
ipaddress varchar(20) NOT NULL ,
PRIMARY KEY (id)
);
# Dumping Data - 1 rows
INSERT INTO master VALUES(1,"admin","总管理员","admin","2003-03-08",0,143,"172.18.88.218");
# Dumping Table pay
#
CREATE TABLE pay (
id int(11) NOT NULL auto_increment,
classid int(11) ,
payerid int(11) NOT NULL ,
paytypeid int(11) NOT NULL ,
money int(40) NOT NULL ,
project varchar(40) ,
message varchar(40) ,
addtime date NOT NULL ,
inout int(1) NOT NULL ,
PRIMARY KEY (id)
);
# Dumping Data - 0 rows
# Dumping Table payer
#
CREATE TABLE payer (
id int(11) NOT NULL auto_increment,
name varchar(20) NOT NULL ,
PRIMARY KEY (id),
KEY name (name)
);
# Dumping Data - 0 rows
# Dumping Table paytype
#
CREATE TABLE paytype (
id int(10) NOT NULL auto_increment,
name varchar(20) NOT NULL ,
inout int(1) NOT NULL ,
PRIMARY KEY (id),
KEY name (name)
);
# Dumping Data - 0 rows
# Dumping Table userlog
#
CREATE TABLE userlog (
id int(11) NOT NULL auto_increment,
user varchar(20) NOT NULL ,
logindate datetime NOT NULL ,
logoutdate datetime NOT NULL ,
ip varchar(20) NOT NULL ,
PRIMARY KEY (id)
);