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';
