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