caiwu.sql

一个用jsp做的在线财务管理系统的源码

# 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)	
);