create_sql.sql

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

if exists (select name from master.dbo.sysdatabases where name = N'wapmo')
drop database [wapmo]
go

create database [wapmo]
go

use [wapmo]
go

if exists(select name from sysobjects where name='wapmo_admin' and xtype='U')
drop table wapmo_admin
go

create table wapmo_admin
(
	SeqId int identity(1,1) not null,
	Name varchar(10) primary key 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
)
go

if exists(select name from sysobjects where name='user_db' and xtype='U')
drop table user_db
go

create table user_db
(
	SeqId int identity(1,1) primary key 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 int default 0 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 int default 0 null,
	FirstSearchWord varchar(255) null,
	LastSearchTime int default 0 null,
	LastSearchWord varchar(255) null,
	SearchCount int default 0 not null,
	FirstUserAgent varchar(255) null,
	LastUserAgent varchar(255) null,
)
go

if exists(select name from sysobjects where name='staple' and xtype='U')
drop table staple
go

create table staple
(
	SeqId int identity(1,1) primary key 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,
	--Index Property
	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
)
go

if exists(select name from sysobjects where name='content' and type='U')
drop table content
go

create table content
(
	SeqId int identity(1,1) primary key 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
)
go

if exists(select name from sysobjects where name='forum' and xtype='U')
drop table forum
go

create table forum
(
	SeqId int identity(1,1) primary key 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
)
go

if exists(select name from sysobjects where name='article' and xtype='U')
drop table article
go

create table article
(
	SeqId int identity(1,1) primary key 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
)
go

if exists(select name from sysobjects where name='trade' and xtype='U')
drop table trade
go

create table trade
(
	SeqId int identity(1,1) primary key 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
)
go

if exists(select name from sysobjects where name='remark')
drop table remark
go

create table remark
(
	SeqId int identity(1,1) primary key 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
)
go