create_oracle.sql

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

create table wapmo_admin
(
	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
);

create table user_db
(
	SeqId int 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,
	PRIMARY KEY (SeqId)
);

create sequence user_db_seq start with 1 increment by 1;

create or replace trigger user_db_t
before insert on user_db
for each row
begin
select user_db_seq.nextval into :new.SEQID from dual;
end;
.
run;

create table staple
(
	SeqId int 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)
);

create sequence staple_seq start with 1 increment by 1;

create or replace trigger staple_t
before insert on staple
for each row
begin
select staple_seq.nextval into :new.SEQID from dual;
end;
.
run;

create table content
(
	SeqId int 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)
);

create sequence content_seq start with 1 increment by 1;

create or replace trigger content_t
before insert on content
for each row
begin
select content_seq.nextval into :new.SEQID from dual;
end;
.
run;

create table forum
(
	SeqId int 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)
);

create sequence forum_seq start with 1 increment by 1;

create or replace trigger forum_t
before insert on forum
for each row
begin
select forum_seq.nextval into :new.SEQID from dual;
end;
.
run;

create table article
(
	SeqId int 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)
);

create sequence article_seq start with 1 increment by 1;

create or replace trigger article_t
before insert on article
for each row
begin
select article_seq.nextval into :new.SEQID from dual;
end;
.
run;

create table trade
(
	SeqId int 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)
);

create sequence trade_seq start with 1 increment by 1;

create or replace trigger trade_t
before insert on trade
for each row
begin
select trade_seq.nextval into :new.SEQID from dual;
end;
.
run;

create table remark
(
	SeqId int 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)
);

create sequence remark_seq start with 1 increment by 1;

create or replace trigger remark_t
before insert on remark
for each row
begin
select remark_seq.nextval into :new.SEQID from dual;
end;
.
run;