create_mysql.sql

一个非常好的jsp+wml的例子（包括代码） 源码,对初接触wap编程的爱好者 ...

create database if not exists wapmo;

use wapmo;

drop table if exists wapmo_admin;

create table wapmo_admin
(
	SeqId int AUTO_INCREMENT not null,
	Name varchar(10) not null,
	Passwd char(32) not null,
	Power int default 9 not null,
	Timeval int default 0 not null,
	LoginCount int default 0 not null,
	Intime int default 0 not null,
	Outime int default 0 not null,
	PRIMARY KEY(SeqId)
);

drop table if exists user_db;

create table user_db
(
	SeqId int AUTO_INCREMENT not null,
	Mobile varchar(32) not null,
	Name varchar(32) null,
	Nick varchar(32) null,
	UserId int not null,
	Status int default 0 not null,
	RegisterTime datetime null,
	RegisterIP varchar(16) null,
	FirstUsedTime int default 0 not null,
	FirstUsedIP varchar(16) null,
	LastUsedTime int default 0 not null,
	LastUsedIP varchar(16) null,
	VisitCount int default 1 not null,
	PageCount int default 1 not null,
	LastPage varchar(255) null,
	FirstSearchTime datetime null,
	FirstSearchWord varchar(255) null,
	LastSearchTime datetime null,
	LastSearchWord varchar(255) null,
	SearchCount int default 0 not null,
	FirstUserAgent varchar(255) null,
	LastUserAgent varchar(255) null,
	PRIMARY KEY (SeqId)
);

drop table if exists staple;

create table staple
(
	SeqId int AUTO_INCREMENT not null,
	Title varchar(50) not null,
	Content varchar(255) null,
	List int default 0 null,
	Align int default 0 not null,
	Locked int default 0 not null,
	Page int default 0 not null,
	Trade int default 0 not null,
	Remark int default 0 not null,
	Sort int default 0 not null,
	Follow int default 0 not null,
	Hit int default 0 not null,
	Mapping int default 0 not null,
	Category int default 0 not null,
	Ads int default 0 not null,
	Power int default 999 not null,
	Logo int default 0 not null,
	BBS int default 0 not null,
	Query int default 0 not null,
	Serial int default 0 not null,
	Intime int default 0 not null,
	Outime int default 0 not null,
	PRIMARY KEY(SeqId)
);

drop table if exists content;

create table content
(
	SeqId int AUTO_INCREMENT not null,
	StapleId int default 0 not null,
	Title varchar(255) not null,
	Price varchar(50) null,
	Content varchar(8000) null,
	Attach varchar(100) null,
	Place int default 0 not null,
	Length int default 255 not null,
	Download int default 0 not null,
	DownloadCount int default 0 not null,
	Hit int default 0 not null,
	Category int default 0 not null,
	Intime int default 0 not null,
	Outime int default 0 not null,
	PRIMARY KEY (SeqId)
);

drop table if exists forum;

create table forum
(
	SeqId int AUTO_INCREMENT not null,
	Title varchar(50) not null,
	Content varchar(255) null,
	Page int default 0,
	Follow int default 0 not null,
	Intime int default 0 not null,
	PRIMARY KEY (SeqId)
);

drop table if exists article;

create table article
(
	SeqId int AUTO_INCREMENT not null,
	Name varchar(32) not null,
	UserId int default 0 not null,
	Title varchar(255) not null,
	Content varchar(1024) not null,
	ForumId int default 0 not null,
	Hit int default 0 not null,
	Follow int default 0 not null,
	Intime int default 0 not null,
	Outime int default 0 not null,
	PRIMARY KEY (SeqId)
);

drop table if exists trade;

create table trade
(
	SeqId int AUTO_INCREMENT not null,
	StapleId int not null,
	ContentId int not null,
	UserId int default 0 not null,
	Name varchar(50) not null,
	Phone varchar(50) not null,
	Mobile varchar(32) not null,
	Address varchar(255) null,
	ZipCode varchar(10) null,
	Status int default 0 not null,
	Intime int default 0 not null,
	PRIMARY KEY (SeqId)
);

drop table if exists remark;

create table remark
(
	SeqId int AUTO_INCREMENT not null,
	StapleId int not null,
	ContentId int not null,
	Content varchar(255) not null,
	UserId int default 0 not null,
	Name varchar(32) not null,
	Mobile varchar(32) not null,
	Intime int default 0 not null,
	PRIMARY KEY (SeqId)
);

grant all privileges on *.* to test@192.168.0.1 identified by 'test';