Create table JF_GuestBook(
ID Counter PRIMARY KEY,
username varchar(50) null,
xingbie varchar(50) null,
userurl varchar(50) null,
usermail varchar(50) null,
userqq varchar(50) null,
usertime DateTime,
usertitle varchar(50) null,
usercontent memo null,
topPost long,
reply long,
retime DateTime,
recontent memo null,
ip varchar(50) null,
checked long,
userface long,
whisper long,
replycode varchar(50) null
)
[JF:SQLSeparator]
ALTER TABLE JF_Setup ADD 
GAdminName varchar(50) null,
GAdminPass varchar(50) null,
GNotice memo null,
GStat long,
IsAuditing bit,
IsGbState bit,
GSkinFolder varchar(50) null,
GImagesFolder varchar(50) null,
GEmotFolder varchar(50) null,
GUserfacesFolder varchar(50) null,
GbClick long
[JF:SQLSeparator]
update JF_Setup set 
GbClick='0',
GAdminName='admin',
GAdminPass='a1d2m3i4n',
GSkinFolder='skins/default',
GImagesFolder='skins/default/images',
GEmotFolder='skins/default/emot',
GUserfacesFolder='skins/default/userfaces'
[JF:SQLSeparator]
Create table JF_CustomTag(
ID Counter PRIMARY KEY,
Name varchar(50) null,
Depict varchar(255) null,
Content memo null,
DateAndTime DateTime
)