blaxxun configration file

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: ID M
DataFile member
Keys 9
KeyID ID
KeyLength 8
KeyFile memberID.idx
KeyID EML
KeyLength 64
KeyFile memberEML.idx
KeyID NNM
KeyLength 16
KeyFile memberNNM.idx
KeyID NNK
KeyLength 16
KeyFile memberNNK.idx
KeyID IMD
KeyLength 14
KeyDup 1
KeyFile memberIMD.idx
KeyID LAD
KeyLength 14
KeyDup 1
KeyFile memberLAD.idx
KeyID MON
KeyLength 8
KeyDup 1
KeyFile memberMON.idx
KeyID EXP
KeyLength 8
KeyDup 1
KeyFile memberEXP.idx
KeyID LNM
KeyLength 32
KeyDup 1
KeyFile memberLNM.idx

ID CC
DataFile ccenter
Keys 5
KeyID ID
KeyLength 8
KeyFile ccenterID.idx
KeyID STT
KeyLength 1
KeyDup 1
KeyFile ccenterSTT.idx
KeyID TOP
KeyLength 64
KeyDup 1
KeyFile ccenterTOP.idx
KeyID CON
KeyLength 16
KeyDup 1
KeyFile ccenterCON.idx
KeyID CDA
KeyLength 14
KeyDup 1
KeyFile ccenterCDA.idx

ID VI
DataFile visitor
Keys 4
KeyID ID
KeyLength 8
KeyFile visitorID.idx
KeyID NNM
KeyLength 16
KeyFile visitorNNM.idx
KeyID NNK
KeyLength 16
KeyFile visitorNNK.idx
KeyID LAD
KeyLength 14
KeyDup 1
KeyFile visitorLAD.idx

ID R
DataFile role
Keys 3
KeyID ID
KeyLength 2
KeyFile roleID.idx
KeyID NAM
KeyLength 32
KeyFile roleNAM.idx
KeyID EXP
KeyLength 8
KeyDup 1
KeyFile roleEXP.idx

ID RM
DataFile rolemember
Keys 2
KeyID ID
KeyLength 36
KeyFile rolememberID.idx
KeyID NNK
KeyLength 16
KeyDup 1
KeyFile rolememberNNK.idx

ID T
DataFile ticket
Keys 3
KeyID ID
KeyLength 16
KeyFile ticketID.idx
KeyID OWN
KeyLength 8
KeyDup 1
KeyFile ticketOWN.idx
KeyID CDA
KeyLength 14
KeyDup 1
KeyFile ticketCDA.idx

ID O
DataFile object
Keys 1
KeyID ID
KeyLength 32
KeyFile objectID.idx

ID H
DataFile home
Keys 1
KeyID ID
KeyLength 32
KeyFile homeID.idx

ID I
DataFile info
Keys 3
KeyID ID
KeyLength 32
KeyFile infoID.idx
KeyID OWN
KeyLength 8
KeyDup 1
KeyFile infoOWN.idx
KeyID NAM
KeyLength 32
KeyDup 1
KeyFile infoNAM.idx

ID V
DataFile vote
Keys 3
KeyID ID
KeyLength 34
KeyFile voteID.idx
KeyID PLC
KeyLength 17
KeyDup 1
KeyFile votePLC.idx
KeyID RID
KeyLength 17
KeyDup 1
KeyFile voteRID.idx

ID SO
DataFile sobjects
Keys 5
KeyID ID
KeyLength 32
KeyFile sobjID.idx
KeyID ZON
KeyLength 32
KeyDup 1
KeyFile sobjZON.idx
KeyID NAM
KeyLength 32
KeyDup 1
KeyFile sobjNAM.idx
KeyID CAT
KeyLength 32
KeyDup 1
KeyFile sobjCAT.idx
KeyID OWN
KeyLength 9
KeyDup 1
KeyFile sobjOWN.idx

ID CL
DataFile clubs
Keys 10
KeyID ID
KeyLength 16
KeyFile clubsID.idx
KeyID NAK
KeyLength 16
KeyFile clubsNAK.idx
KeyID KK1
KeyLength 32
KeyDup 1
KeyFile clubsKK1.idx
KeyID KK2
KeyLength 32
KeyDup 1
KeyFile clubsKK2.idx
KeyID KK3
KeyLength 32
KeyDup 1
KeyFile clubsKK3.idx
KeyID CDA
KeyLength 14
KeyDup 1
KeyFile clubsCDA.idx
KeyID ACT
KeyLength 8
KeyDup 1
KeyFile clubsACT.idx
KeyID PID
KeyLength 16
KeyDup 1
KeyFile clubsPID.idx
KeyID CNT
KeyLength 8
KeyDup 1
KeyFile clubsCNT.idx
KeyID CLW
KeyLength 8
KeyDup 1
KeyFile clubsCLW.idx

ID CM
DataFile clubmem
Keys 4
KeyID ID
KeyLength 26
KeyFile clubmemID.idx
KeyID STT
KeyLength 1
KeyDup 1
KeyFile clubmemSTT.idx
KeyID LVD
KeyLength 14
KeyDup 1
KeyFile clubmemLVD.idx
KeyID NNM
KeyLength 16
KeyDup 1
KeyFile clubmemNNM.idx

ID G
DataFile groups
Keys 2
KeyID ID
KeyLength 8
KeyFile groupsID.idx
KeyID NNK
KeyLength 16
KeyFile groupsNNK.idx

ID GM
DataFile groupmem
Keys 1
KeyID ID
KeyLength 17
KeyFile groupmemID.idx

ID MD
DataFile memdata
Keys 2
KeyID ID
KeyLength 8
KeyFile memdataID.idx
KeyID BAS
KeyLength 32
KeyDup 1
KeyFile memdataBAS.idx

ID A
DataFile avatar
Keys 2
KeyID ID
KeyLength 8
KeyFile avatarID.idx
KeyID ORD
KeyLength 16
KeyDup 1
KeyFile avatarORD.idx

ID MO
DataFile memberonline
Keys 4
KeyID ID
KeyLength 8
KeyFile memberonlineID.idx
KeyID NNM
KeyLength 16
KeyFile memberonlineNNM.idx
KeyID PLC
KeyLength 34
KeyDup 1
KeyFile memberonlinePLC.idx
KeyID LAD
KeyLength 14
KeyDup 1
KeyFile memberonlineLAD.idx

ID PO
DataFile placeonline
Keys 2
KeyID ID
KeyLength 32
KeyFile placeonlineID.idx
KeyID CNT
KeyLength 8
KeyDup 1
KeyFile placeonlineCNT.idx

ID MB
DataFile msb
Keys 10
KeyID ID
KeyLength 25
KeyFile msbID.idx
KeyID IDLAD
KeyLength 32
KeyDup 1
KeyFile msbIDLAD.idx
KeyID BIDLAD
KeyLength 24
KeyDup 1
KeyFile msbBIDLAD.idx
KeyID BIDONN
KeyLength 26
KeyDup 1
KeyFile msbBIDONN.idx
KeyID IDSIZ
KeyLength 26
KeyDup 1
KeyFile msbIDSIZ.idx
KeyID IDONN
KeyLength 34
KeyDup 1
KeyFile msbIDONN.idx
KeyID IDRCT
KeyLength 26
KeyDup 1
KeyFile msbIDRCT.idx
KeyID PIDCDA
KeyLength 40
KeyDup 1
KeyFile msbPIDCDA.idx
KeyID IDCDA
KeyLength 32
KeyDup 1
KeyFile msbIDCDA.idx
KeyID IDSUB
KeyLength 50
KeyDup 1
KeyFile msbIDSUB.idx

community.cfg

ID M
DataFile member
Keys 9
KeyID ID
KeyLength 8
KeyFile memberID.idx
KeyID EML
KeyLength 64
KeyFile memberEML.idx
KeyID NNM
KeyLength 16
KeyFile memberNNM.idx
KeyID NNK
KeyLength 16
KeyFile memberNNK.idx
KeyID IMD
KeyLength 14
KeyDup 1
KeyFile memberIMD.idx
KeyID LAD
KeyLength 14
KeyDup 1
KeyFile memberLAD.idx
KeyID MON
KeyLength 8
KeyDup 1
KeyFile memberMON.idx
KeyID EXP
KeyLength 8
KeyDup 1
KeyFile memberEXP.idx
KeyID LNM
KeyLength 32
KeyDup 1
KeyFile memberLNM.idx

ID R
DataFile role
Keys 3
KeyID ID
KeyLength 2
KeyFile roleID.idx
KeyID NAM
KeyLength 32
KeyFile roleNAM.idx
KeyID EXP
KeyLength 8
KeyDup 1
KeyFile roleEXP.idx

ID RM
DataFile rolemember
Keys 2
KeyID ID
KeyLength 36
KeyFile rolememberID.idx
KeyID NNK
KeyLength 16
KeyDup 1
KeyFile rolememberNNK.idx

ID S
DataFile status
Keys 3
KeyID ID
KeyLength 2
KeyFile statusID.idx
KeyID NAM
KeyLength 32
KeyFile statusNAM.idx
KeyID EXP
KeyLength 8
KeyDup 1
KeyFile statusEXP.idx

ID SM
DataFile statusmember
Keys 1
KeyID ID
KeyLength 36
KeyFile statusmemberID.idx

ID T
DataFile ticket
Keys 3
KeyID ID
KeyLength 16
KeyFile ticketID.idx
KeyID OWN
KeyLength 8
KeyDup 1
KeyFile ticketOWN.idx
KeyID CDA
KeyLength 14
KeyDup 1
KeyFile ticketCDA.idx

ID O
DataFile object
Keys 1
KeyID ID
KeyLength 32
KeyFile objectID.idx

ID C
DataFile community
Keys 1
KeyID ID
KeyLength 32
KeyFile communityID.idx

ID N
DataFile neighbor
Keys 1
KeyID ID
KeyLength 32
KeyFile neighborID.idx

ID B
DataFile block
Keys 1
KeyID ID
KeyLength 32
KeyFile blockID.idx

ID P
DataFile property
Keys 1
KeyID ID
KeyLength 32
KeyFile propertyID.idx

ID I
DataFile info
Keys 3
KeyID ID
KeyLength 32
KeyFile infoID.idx
KeyID OWN
KeyLength 8
KeyDup 1
KeyFile infoOWN.idx
KeyID NAM
KeyLength 32
KeyDup 1
KeyFile infoNAM.idx

ID U
DataFile media
Keys 3
KeyID ID
KeyLength 32
KeyFile mediaID.idx
KeyID OWN
KeyLength 8
KeyDup 1
KeyFile mediaOWN.idx
KeyID NAM
KeyLength 32
KeyDup 1
KeyFile mediaNAM.idx

ID V
DataFile vote
Keys 3
KeyID ID
KeyLength 32
KeyFile voteID.idx
KeyID PLC
KeyLength 17
KeyDup 1
KeyFile votePLC.idx
KeyID RID
KeyLength 17
KeyDup 1
KeyFile voteRID.idx

ID SO
DataFile sobjects
Keys 5
KeyID ID
KeyLength 32
KeyFile sobjID.idx
KeyID ZON
KeyLength 32
KeyDup 1
KeyFile sobjZON.idx
KeyID NAM
KeyLength 32
KeyDup 1
KeyFile sobjNAM.idx
KeyID CAT
KeyLength 32
KeyDup 1
KeyFile sobjCAT.idx
KeyID OWN
KeyLength 9
KeyDup 1
KeyFile sobjOWN.idx

ID CL
DataFile clubs
Keys 9
KeyID ID
KeyLength 16
KeyFile clubsID.idx
KeyID NAK
KeyLength 16
KeyFile clubsNAK.idx
KeyID KK1
KeyLength 32
KeyDup 1
KeyFile clubsKK1.idx
KeyID KK2
KeyLength 32
KeyDup 1
KeyFile clubsKK2.idx
KeyID KK3
KeyLength 32
KeyDup 1
KeyFile clubsKK3.idx
KeyID CDA
KeyLength 14
KeyDup 1
KeyFile clubsCDA.idx
KeyID ACT
KeyLength 8
KeyDup 1
KeyFile clubsACT.idx
KeyID PID
KeyLength 16
KeyDup 1
KeyFile clubsPID.idx
KeyID CNT
KeyLength 8
KeyDup 1
KeyFile clubsCNT.idx

ID CM
DataFile clubmem
Keys 3
KeyID ID
KeyLength 26
KeyFile clubmemID.idx
KeyID STT
KeyLength 1
KeyDup 1
KeyFile clubmemSTT.idx
KeyID LVD
KeyLength 14
KeyDup 1
KeyFile clubmemLVD.idx

ID G
DataFile groups
Keys 2
KeyID ID
KeyLength 8
KeyFile groupsID.idx
KeyID NNK
KeyLength 16
KeyFile groupsNNK.idx

ID GM
DataFile groupmem
Keys 1
KeyID ID
KeyLength 17
KeyFile groupmemID.idx

ID MD
DataFile memdata
Keys 2
KeyID ID
KeyLength 8
KeyFile memdataID.idx
KeyID BAS
KeyLength 32
KeyDup 1
KeyFile memdataBAS.idx

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: create table Member
(
ID CHAR(8) NOT NULL,
Email1 CHAR(64) NOT NULL,
Email2 CHAR(64) NULL,
Email3 CHAR(64) NULL,
Nickname CHAR(16) NULL,
Nickname_To_Lower CHAR(16) NOT NULL,
Immigration_Date CHAR(14) NULL,
Last_Access_Date CHAR(14) NULL,
Money CHAR(8) NULL,
Experience CHAR(8) NULL,
Last_Name CHAR(32) NULL,
First_Name CHAR(20) NULL,
Password CHAR(16) NULL,
Immigration_Key CHAR(5) NULL,
Immigration_Info CHAR(64) NULL,
Exclusion_Date CHAR(14) NULL,
Role CHAR(32) NULL,
Home_Property CHAR(16) NULL,
Referenced_Member CHAR(16) NULL,
Home_Page CHAR(128) NULL,
Chat_Type CHAR(1) NULL,
Cookie CHAR(1) NULL,
Last_Access_Exp CHAR(14) NULL,
Last_Access_Money CHAR(14) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
primary key (ID)
)
create unique index M_EML ON Member (Email1)
create unique index M_NNM ON Member (Nickname)
create unique index M_NNK ON Member (Nickname_To_Lower)
create index M_IMD ON Member (Immigration_Date)
create index M_LAD ON Member (Last_Access_Date)
create index M_MON ON Member (Money)
create index M_EXP ON Member (Experience)
create index M_LNM ON Member (Last_Name)

create table Member_Data
(
ID CHAR(8) NOT NULL,
Exclusion_Reason CHAR(128) NULL,
Excluding_Member CHAR(16) NULL,
Description1 TEXT NULL,
Instant_Message_Status CHAR(1) NULL,
Newsletter CHAR(1) NULL,
Language CHAR(2) NULL,
Blaxxun_Avatar_Studio CHAR(32) NULL,
Buddy_Name_0 CHAR(16) NULL,
Buddy_Name_1 CHAR(16) NULL,
Buddy_Name_2 CHAR(16) NULL,
Buddy_Name_3 CHAR(16) NULL,
Buddy_Name_4 CHAR(16) NULL,
Buddy_Name_5 CHAR(16) NULL,
Buddy_Name_6 CHAR(16) NULL,
Buddy_Name_7 CHAR(16) NULL,
Buddy_Name_8 CHAR(16) NULL,
Buddy_Name_9 CHAR(16) NULL,
Buddy_Name_10 CHAR(16) NULL,
Buddy_Name_11 CHAR(16) NULL,
Buddy_Name_12 CHAR(16) NULL,
Buddy_Name_13 CHAR(16) NULL,
Buddy_Name_14 CHAR(16) NULL,
Buddy_Name_15 CHAR(16) NULL,
My_Role CHAR(2) NULL,
Interests CHAR(64) NULL,
Avatar_Image CHAR(64) NULL,
Avatar_Url CHAR(64) NULL,
Avatar_Checked CHAR(16) NULL,
Avatar_Desc0 CHAR(64) NULL,
Avatar_Desc1 CHAR(64) NULL,
Avatar_Desc2 CHAR(64) NULL,
Avatar_Desc3 CHAR(64) NULL,
Avatar_Desc4 CHAR(64) NULL,
primary key (ID)
)
create index M_BAS ON Member_Data (Blaxxun_Avatar_Studio)

create table Role
(
ID CHAR(2) NOT NULL,
Name CHAR(32) NOT NULL,
Email1 CHAR(32) NULL,
Experience CHAR(8) NULL,
Type CHAR(1) NULL,
Income_Money CHAR(8) NULL,
Income_Experience CHAR(8) NULL,
Symbol TEXT NULL,
primary key (ID)
)
create unique index R_NAM ON Role(Name)
create unique index R_EML ON Role(Email1)
create index R_EXP ON Role(Experience)

create table Role_Member
(
ID CHAR(32) NOT NULL,
Nickname_To_Lower CHAR(16) NULL,
Nickname CHAR(16) NULL,
primary key (ID)
)
create index RM_NNK ON Role_Member(Nickname_To_Lower)

create table Exp_Level
(
ID CHAR(2) NOT NULL,
Name CHAR(32) NOT NULL,
Experience CHAR(8) NULL,
Symbol TEXT NULL,
primary key (ID)
)
create unique index S_NAM ON Exp_Level(Name)
create index S_EXP ON Exp_Level(Experience)

create table Object
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Name CHAR(32) NULL,
Price CHAR(8) NULL,
Cost CHAR(8) NULL,
Money CHAR(8) NULL,
Maximum_Children CHAR(8) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
Description1 TEXT NULL,
Description2 TEXT NULL,
Advertising_Url TEXT NULL,
Advertising_Image CHAR(16) NULL,
Background_Image CHAR(16) NULL,
Background_Color CHAR(7) NULL,
ALink_Color CHAR(7) NULL,
VLink_Color CHAR(7) NULL,
Link_Color CHAR(7) NULL,
Text_Color CHAR(7) NULL,
Font_Face CHAR(32) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
CTN CHAR(16) NULL,
CNM CHAR(16) NULL,
ENM CHAR(16) NULL,
BNM CHAR(16) NULL,
PNM CHAR(16) NULL,
CCA CHAR(8) NULL,
CCB CHAR(8) NULL,
CCC CHAR(8) NULL,
CCD CHAR(8) NULL,
CCE CHAR(8) NULL,
CCF CHAR(8) NULL,
CCG CHAR(8) NULL,
CCH CHAR(8) NULL,
CCI CHAR(8) NULL,
CCJ CHAR(8) NULL,
CCK CHAR(8) NULL,
CCL CHAR(8) NULL,
CCM CHAR(8) NULL,
CCN CHAR(8) NULL,
CCO CHAR(8) NULL,
CCP CHAR(8) NULL,
CCQ CHAR(8) NULL,
CCR CHAR(8) NULL,
CCS CHAR(8) NULL,
CCT CHAR(8) NULL,
CCU CHAR(8) NULL,
CCV CHAR(8) NULL,
CCW CHAR(8) NULL,
CCX CHAR(8) NULL,
CCY CHAR(8) NULL,
CCZ CHAR(8) NULL,
CC0 CHAR(8) NULL,
CC1 CHAR(8) NULL,
CC2 CHAR(8) NULL,
CC3 CHAR(8) NULL,
CC4 CHAR(8) NULL,
CC5 CHAR(8) NULL,
CC6 CHAR(8) NULL,
CC7 CHAR(8) NULL,
CC8 CHAR(8) NULL,
CC9 CHAR(8) NULL,
NewsTickerNumber CHAR(8) NULL,
NewsTickerText0 CHAR(32) NULL,
NewsTickerURL0 TEXT NULL,
NewsTickerTarget0 CHAR(16) NULL,
NewsTickerText1 CHAR(32) NULL,
NewsTickerURL1 TEXT NULL,
NewsTickerTarget1 CHAR(16) NULL,
NewsTickerText2 CHAR(32) NULL,
NewsTickerURL2 TEXT NULL,
NewsTickerTarget2 CHAR(16) NULL,
NewsTickerText3 CHAR(32) NULL,
NewsTickerURL3 TEXT NULL,
NewsTickerTarget3 CHAR(16) NULL,
NewsTickerText4 CHAR(32) NULL,
NewsTickerURL4 TEXT NULL,
NewsTickerTarget4 CHAR(16) NULL,
NewsTickerText5 CHAR(32) NULL,
NewsTickerURL5 TEXT NULL,
NewsTickerTarget5 CHAR(16) NULL,
NewsTickerText6 CHAR(32) NULL,
NewsTickerURL6 TEXT NULL,
NewsTickerTarget6 CHAR(16) NULL,
NewsTickerText7 CHAR(32) NULL,
NewsTickerURL7 TEXT NULL,
NewsTickerTarget7 CHAR(16) NULL,
NewsTickerText8 CHAR(32) NULL,
NewsTickerURL8 TEXT NULL,
NewsTickerTarget8 CHAR(16) NULL,
NewsTickerText9 CHAR(32) NULL,
NewsTickerURL9 TEXT NULL,
NewsTickerTarget9 CHAR(16) NULL,
primary key (ID)
)

create table Club
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Name CHAR(16) NULL,
Name_To_Lower CHAR(16) NULL,
Keyword_1 CHAR(32) NULL,
Keyword_2 CHAR(32) NULL,
Keyword_3 CHAR(32) NULL,
Keyword_1_To_Lower CHAR(32) NULL,
Keyword_2_To_Lower CHAR(32) NULL,
Keyword_3_To_Lower CHAR(32) NULL,
Creation_Date CHAR(14) NULL,
Activity CHAR(8) NULL,
Description TEXT NULL,
Rules CHAR(128) NULL,
Kind CHAR(1) NULL,
Member_Count CHAR(8) NULL,
Member_Count_Last_Week CHAR(8) NULL,
Money CHAR(8) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
Related_Place CHAR(16) NULL,
Group_ID CHAR(8) NULL,
Wall_Color CHAR(17) NULL,
Ceiling CHAR(17) NULL,
Floor_Color CHAR(17) NULL,
Status_Club_Image CHAR(1) NULL,
Status_Gallery_Picture_1 CHAR(1) NULL,
Status_Gallery_Picture_2 CHAR(1) NULL,
Status_Gallery_Picture_3 CHAR(1) NULL,
Status_Meeting_Room_Picture CHAR(1) NULL,
Status_Assembly_Room_Picture CHAR(1) NULL,
Club_Image CHAR(42) NULL,
Gallery_Picture_1 CHAR(42) NULL,
Gallery_Picture_2 CHAR(42) NULL,
Gallery_Picture_3 CHAR(42) NULL,
Meeting_Room_Picture CHAR(42) NULL,
Assembly_Room_Picture CHAR(42) NULL,
Club_Image_Filename CHAR(64) NULL,
Gallery_Filename_1 CHAR(64) NULL,
Gallery_Filename_2 CHAR(64) NULL,
Gallery_Filename_3 CHAR(64) NULL,
Meeting_Room_Filename CHAR(64) NULL,
Assembly_Room_Filename CHAR(64) NULL,
Total_Club_Count CHAR(8) NULL,
Statistc_Update_Date CHAR(14) NULL,
Link0 TEXT NULL,
Link1 TEXT NULL,
Link2 TEXT NULL,
Link3 TEXT NULL,
Link4 TEXT NULL,
Link5 TEXT NULL,
Link0_Description TEXT NULL,
Link1_Description TEXT NULL,
Link2_Description TEXT NULL,
Link3_Description TEXT NULL,
Link4_Description TEXT NULL,
Link5_Description TEXT NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
Background_Color CHAR(7) NULL,
ALink_Color CHAR(7) NULL,
VLink_Color CHAR(7) NULL,
Link_Color CHAR(7) NULL,
Text_Color CHAR(7) NULL,
primary key (ID)
)
create unique index C_NAK ON Club(Name_To_Lower)
create index C_KK1 ON Club(Keyword_1_To_Lower)
create index C_KK2 ON Club(Keyword_2_To_Lower)
create index C_KK3 ON Club(Keyword_3_To_Lower)
create index C_CDA ON Club(Creation_Date)
create index C_ACT ON Club(Activity)
create index C_CNT ON Club(Member_Count)
create index C_PID ON Club(Related_Place)

create table Club_Member
(
ID CHAR(26) NOT NULL,
Status CHAR(1) NULL,
Last_Visit_Date CHAR(14) NULL,
Join_Date CHAR(14) NULL,
primary key (ID)
)
create index C_STT ON Club_Member(Status)
create index C_LVD ON Club_Member(Last_Visit_Date)

create table Community
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Name CHAR(32) NULL,
Price CHAR(8) NULL,
Cost CHAR(8) NULL,
Money CHAR(8) NULL,
Maximum_Children CHAR(8) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
Description1 TEXT NULL,
Description2 TEXT NULL,
Advertising_Url TEXT NULL,
Advertising_Image CHAR(16) NULL,
Background_Image CHAR(16) NULL,
Background_Color CHAR(7) NULL,
ALink_Color CHAR(7) NULL,
VLink_Color CHAR(7) NULL,
Link_Color CHAR(7) NULL,
Text_Color CHAR(7) NULL,
Font_Face CHAR(32) NULL,
PU2 CHAR(1) NULL,
Index_2D_Icon CHAR(3) NULL,
Index_Image CHAR(3) NULL,
Index_3D_Icon CHAR(3) NULL,
Index_World CHAR(3) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
Free_Homes CHAR(8) NULL,
primary key (ID)
)

create table Neighborhood
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Name CHAR(32) NULL,
Price CHAR(8) NULL,
Cost CHAR(8) NULL,
Money CHAR(8) NULL,
Maximum_Children CHAR(8) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
Description1 TEXT NULL,
Description2 TEXT NULL,
Advertising_Url TEXT NULL,
Advertising_Image CHAR(16) NULL,
Background_Image CHAR(16) NULL,
Background_Color CHAR(7) NULL,
ALink_Color CHAR(7) NULL,
VLink_Color CHAR(7) NULL,
Link_Color CHAR(7) NULL,
Text_Color CHAR(7) NULL,
Font_Face CHAR(32) NULL,
PU2 CHAR(1) NULL,
Index_2D_Icon CHAR(3) NULL,
Index_Image CHAR(3) NULL,
Index_3D_Icon CHAR(3) NULL,
Index_World CHAR(3) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
Free_Homes CHAR(8) NULL,
primary key (ID)
)

create table Block
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Name CHAR(32) NULL,
Price CHAR(8) NULL,
Cost CHAR(8) NULL,
Money CHAR(8) NULL,
Maximum_Children CHAR(8) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
Description1 TEXT NULL,
Description2 TEXT NULL,
Advertising_Url TEXT NULL,
Advertising_Image CHAR(16) NULL,
Background_Image CHAR(16) NULL,
Background_Color CHAR(7) NULL,
ALink_Color CHAR(7) NULL,
VLink_Color CHAR(7) NULL,
Link_Color CHAR(7) NULL,
Text_Color CHAR(7) NULL,
Font_Face CHAR(32) NULL,
PU2 CHAR(1) NULL,
Index_2D_Icon CHAR(3) NULL,
Index_Image CHAR(3) NULL,
Index_3D_Icon CHAR(3) NULL,
Index_World CHAR(3) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
Free_Homes CHAR(8) NULL,
primary key (ID)
)

create table Property
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Name CHAR(32) NULL,
Price CHAR(8) NULL,
Cost CHAR(8) NULL,
Money CHAR(8) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
Description1 TEXT NULL,
Description2 TEXT NULL,
Advertising_Url TEXT NULL,
Advertising_Image CHAR(16) NULL,
Background_Image CHAR(16) NULL,
Background_Color CHAR(7) NULL,
ALink_Color CHAR(7) NULL,
VLink_Color CHAR(7) NULL,
Link_Color CHAR(7) NULL,
Text_Color CHAR(7) NULL,
Font_Face CHAR(32) NULL,
Link0 TEXT NULL,
Link0_Description TEXT NULL,
Link1 TEXT NULL,
Link1_Description TEXT NULL,
Link2 TEXT NULL,
Link2_Description TEXT NULL,
Link3 TEXT NULL,
Link3_Description TEXT NULL,
Link4 TEXT NULL,
Link4_Description TEXT NULL,
PU2 CHAR(1) NULL,
Index_2D_Icon CHAR(3) NULL,
Index_Image CHAR(3) NULL,
Index_3D_Icon CHAR(3) NULL,
Index_World CHAR(3) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
)

create table Information
(
ID CHAR(64) NOT NULL,
Owner CHAR(8) NULL,
Nickname CHAR(16) NULL,
Name CHAR(32) NULL,
Description1 TEXT NULL,
Html_Allowed CHAR(3) NULL,
Last_Access_Date CHAR(14) NULL,
URL CHAR(64) NULL,
Location_Id CHAR(16) NULL,
Location_Datatype CHAR(2) NULL,
Place CHAR(64) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
)

create table Multimedia
(
ID CHAR(32) NOT NULL,
Data TEXT NULL,
Owner CHAR(8) NULL,
Name CHAR(32) NULL,
Nickname CHAR(16) NULL,
Price CHAR(8) NULL,
Cost CHAR(8) NULL,
Type CHAR(32) NULL,
Filename CHAR(64) NULL,
Status CHAR(1) NULL,
X2IN CHAR(3) NULL,
X2IF CHAR(3) NULL,
X2IP CHAR(96) NULL,
X2IL CHAR(96) NULL,
X2IC CHAR(96) NULL,
X2DP CHAR(96) NULL,
X2DL CHAR(96) NULL,
X2DC CHAR(96) NULL,
X3IP CHAR(96) NULL,
X3IL CHAR(96) NULL,
X3IC CHAR(96) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
Description1 TEXT NULL,
primary key (ID)
)

create table Voting
(
ID CHAR(32) NOT NULL,
Place CHAR(17) NULL,
RID CHAR(8) NULL,
Topic CHAR(128) NULL,
Choice CHAR(16) NULL,
Nickname CHAR(16) NULL,
Type CHAR(1) NULL,
Iniator_ID CHAR(8) NULL,
Start_Date CHAR(8) NULL,
End_Date CHAR(8) NULL,
Deletion_Date CHAR(8) NULL,
Member_Count CHAR(8) NULL,
Secret CHAR(1) NULL,
Weighted_Vote CHAR(1) NULL,
Description1 TEXT NULL,
primary key (ID)
)
create index V_PLC ON Voting(Place)
create index V_RID ON Voting(RID)

create table Group_Rights
(
ID CHAR(8) NOT NULL,
Nickname CHAR(16) NULL,
Nickname_To_Lower CHAR(16) NOT NULL,
primary key (ID)
)
create unique index G_NNK ON Group_Rights(Nickname_To_Lower)

create table Group_Member
(
ID CHAR(26) NOT NULL,
primary key (ID)
)

create table Shared_Object
(
ID CHAR(32) NOT NULL,
Category CHAR(9) NULL,
Zone CHAR(17) NULL,
Name CHAR(32) NULL,
Owner CHAR(16) NULL,
Buyer CHAR(16) NULL,
Member_Count CHAR(8) NULL,
Action_Count CHAR(8) NULL,
Class CHAR(1) NULL,
Creator CHAR(16) NULL,
Hidden CHAR(1) NULL,
Image CHAR(64) NULL,
Position CHAR(64) NULL,
Trade_Price CHAR(8) NULL,
Texture_File CHAR(64) NULL,
VRML_File CHAR(64) NULL,
Action_Buy CHAR(32) NULL,
Action_Delete CHAR(32) NULL,
Action_Display CHAR(32) NULL,
Action_Drop CHAR(32) NULL,
Action_Move CHAR(32) NULL,
Action_Take CHAR(32) NULL,
Action_000 CHAR(32) NULL,
Action_001 CHAR(32) NULL,
Action_002 CHAR(32) NULL,
Action_003 CHAR(32) NULL,
Action_004 CHAR(32) NULL,
Action_005 CHAR(32) NULL,
Action_006 CHAR(32) NULL,
Action_007 CHAR(32) NULL,
Action_008 CHAR(32) NULL,
Action_009 CHAR(32) NULL,
Action_3D0 CHAR(32) NULL,
Action_3D1 CHAR(32) NULL,
Action_3D2 CHAR(32) NULL,
Action_3D3 CHAR(32) NULL,
Action_3D4 CHAR(32) NULL,
Description1 TEXT NULL,
primary key (ID)
)
create index SO_CAT ON Shared_Object (Category)
create index SO_ZON ON Shared_Object (Zone)
create index SO_NAM ON Shared_Object (Name)
create index SO_OWN ON Shared_Object (Owner)

create table Ticket
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Creation_Date CHAR(14) NULL,
primary key (ID)
)
create index T_CDA ON Ticket (Creation_Date)
create index T_OWN ON Ticket (Owner)

create table Virtual_Pets
(
ID CHAR(16) NOT NULL,
VP_Nickname CHAR(16) NULL,
VP_Avatar_Url CHAR(64) NULL,

VP_Action_0 CHAR(1) NULL,
VP_Beam_To_0 CHAR(1) NULL,
VP_Direct_Mode_0 CHAR(1) NULL,
VP_Match_Mode_0 CHAR(8) NULL,
VP_Pattern_0 TEXT NULL,
VP_Text_0 TEXT NULL,

VP_Action_1 CHAR(1) NULL,
VP_Beam_To_1 CHAR(1) NULL,
VP_Direct_Mode_1 CHAR(1) NULL,
VP_Match_Mode_1 CHAR(8) NULL,
VP_Pattern_1 TEXT NULL,
VP_Text_1 TEXT NULL,

VP_Action_2 CHAR(1) NULL,
VP_Beam_To_2 CHAR(1) NULL,
VP_Direct_Mode_2 CHAR(1) NULL,
VP_Match_Mode_2 CHAR(8) NULL,
VP_Pattern_2 TEXT NULL,
VP_Text_2 TEXT NULL,

VP_Action_3 CHAR(1) NULL,
VP_Beam_To_3 CHAR(1) NULL,
VP_Direct_Mode_3 CHAR(1) NULL,
VP_Match_Mode_3 CHAR(8) NULL,
VP_Pattern_3 TEXT NULL,
VP_Text_3 TEXT NULL,

VP_Action_4 CHAR(1) NULL,
VP_Beam_To_4 CHAR(1) NULL,
VP_Direct_Mode_4 CHAR(1) NULL,
VP_Match_Mode_4 CHAR(8) NULL,
VP_Pattern_4 TEXT NULL,
VP_Text_4 TEXT NULL,

VP_Action_5 CHAR(1) NULL,
VP_Beam_To_5 CHAR(1) NULL,
VP_Direct_Mode_5 CHAR(1) NULL,
VP_Match_Mode_5 CHAR(8) NULL,
VP_Pattern_5 TEXT NULL,
VP_Text_5 TEXT NULL,

VP_Action_6 CHAR(1) NULL,
VP_Beam_To_6 CHAR(1) NULL,
VP_Direct_Mode_6 CHAR(1) NULL,
VP_Match_Mode_6 CHAR(8) NULL,
VP_Pattern_6 TEXT NULL,
VP_Text_6 TEXT NULL,

VP_Action_7 CHAR(1) NULL,
VP_Beam_To_7 CHAR(1) NULL,
VP_Direct_Mode_7 CHAR(1) NULL,
VP_Match_Mode_7 CHAR(8) NULL,
VP_Pattern_7 TEXT NULL,
VP_Text_7 TEXT NULL,

VP_Action_8 CHAR(1) NULL,
VP_Beam_To_8 CHAR(1) NULL,
VP_Direct_Mode_8 CHAR(1) NULL,
VP_Match_Mode_8 CHAR(8) NULL,
VP_Pattern_8 TEXT NULL,
VP_Text_8 TEXT NULL,

VP_Action_9 CHAR(1) NULL,
VP_Beam_To_9 CHAR(1) NULL,
VP_Direct_Mode_9 CHAR(1) NULL,
VP_Match_Mode_9 CHAR(8) NULL,
VP_Pattern_9 TEXT NULL,
VP_Text_9 TEXT NULL,

primary key (ID)
)

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: create table Member
(
ID CHAR(8) NOT NULL,
Email1 CHAR(64) NOT NULL,
Email2 CHAR(64) NULL,
Email3 CHAR(64) NULL,
Nickname CHAR(16) NULL,
Nickname_To_Lower CHAR(16) NOT NULL,
Immigration_Date CHAR(14) NULL,
Last_Access_Date CHAR(14) NULL,
Money CHAR(8) NULL,
Experience CHAR(8) NULL,
Last_Name CHAR(32) NULL,
First_Name CHAR(20) NULL,
Password CHAR(16) NULL,
Immigration_Key CHAR(5) NULL,
Immigration_Info CHAR(64) NULL,
Exclusion_Date CHAR(14) NULL,
Role CHAR(32) NULL,
Home_Property CHAR(16) NULL,
Referenced_Member CHAR(16) NULL,
Home_Page CHAR(128) NULL,
Chat_Type CHAR(1) NULL,
Cookie CHAR(1) NULL,
Last_Access_Exp CHAR(14) NULL,
Last_Access_Money CHAR(14) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
primary key (ID)
);
create unique index M_EML ON Member (Email1);
create unique index M_NNM ON Member (Nickname);
create unique index M_NNK ON Member (Nickname_To_Lower);
create index M_IMD ON Member (Immigration_Date);
create index M_LAD ON Member (Last_Access_Date);
create index M_MON ON Member (Money);
create index M_EXP ON Member (Experience);
create index M_LNM ON Member (Last_Name);

create table Visitor
(
ID CHAR(8) NOT NULL,
Nickname CHAR(16) NULL,
Nickname_To_Lower CHAR(16) NOT NULL,
Immigration_Date CHAR(14) NULL,
Last_Access_Date CHAR(14) NULL,
Password CHAR(16) NULL,
Exclusion_Date CHAR(14) NULL,
Language CHAR(2) NULL,
Last_Used_IP CHAR(16) NULL,
Plugin CHAR(1) NULL,
primary key (ID)
);
create unique index VI_NNM ON Visitor (Nickname);
create unique index VI_NNK ON Visitor (Nickname_To_Lower);
create index VI_IMD ON Visitor (Immigration_Date);
create index VI_LAD ON Visitor (Last_Access_Date);

create table Member_Data
(
ID CHAR(8) NOT NULL,
Exclusion_Reason CHAR(128) NULL,
Exclusion_Counter CHAR(8) NULL,
Excluding_Member CHAR(16) NULL,
Description1 TEXT NULL,
Instant_Message_Status CHAR(1) NULL,
Newsletter CHAR(1) NULL,
Help CHAR(1) NULL,
Language CHAR(2) NULL,
Stage_Password CHAR(16) NULL,
Blaxxun_Avatar_Studio CHAR(32) NULL,
Buddy_Name_0 CHAR(16) NULL,
Buddy_Name_1 CHAR(16) NULL,
Buddy_Name_2 CHAR(16) NULL,
Buddy_Name_3 CHAR(16) NULL,
Buddy_Name_4 CHAR(16) NULL,
Buddy_Name_5 CHAR(16) NULL,
Buddy_Name_6 CHAR(16) NULL,
Buddy_Name_7 CHAR(16) NULL,
Buddy_Name_8 CHAR(16) NULL,
Buddy_Name_9 CHAR(16) NULL,
Buddy_Name_10 CHAR(16) NULL,
Buddy_Name_11 CHAR(16) NULL,
Buddy_Name_12 CHAR(16) NULL,
Buddy_Name_13 CHAR(16) NULL,
Buddy_Name_14 CHAR(16) NULL,
Buddy_Name_15 CHAR(16) NULL,
My_Role CHAR(2) NULL,
Interests CHAR(64) NULL,
Avatar_Image CHAR(128) NULL,
Avatar_Url CHAR(128) NULL,
Avatar_Checked CHAR(16) NULL,
Avatar_Desc0 CHAR(64) NULL,
Avatar_Desc1 CHAR(64) NULL,
Avatar_Desc2 CHAR(64) NULL,
Avatar_Desc3 CHAR(64) NULL,
Avatar_Desc4 CHAR(64) NULL,
Instant_Message_Auto_Popup CHAR(1) NULL,
Forgot_Pwd_Question CHAR(64) NULL,
Forgot_Pwd_Answer CHAR(32) NULL,
Last_Used_IP CHAR(16) NULL,
Age CHAR(8) NULL,
Profile_1 CHAR(32) NULL,
Profile_2 CHAR(32) NULL,
Cache_Root CHAR(64) NULL,
Cache_Version CHAR(8) NULL,
Plugin CHAR(1) NULL,
primary key (ID)
);
create index M_BAS ON Member_Data (Blaxxun_Avatar_Studio)

create table Role
(
ID CHAR(2) NOT NULL,
Name CHAR(32) NOT NULL,
Email1 CHAR(32) NULL,
Experience CHAR(8) NULL,
Type CHAR(1) NULL,
Income_Money CHAR(8) NULL,
Income_Experience CHAR(8) NULL,
Symbol TEXT NULL,
Owner CHAR(8) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
);
create unique index R_NAM ON Role(Name);
create index R_EXP ON Role(Experience);

create table Role_Member
(
ID CHAR(36) NOT NULL,
Nickname_To_Lower CHAR(16) NULL,
Nickname CHAR(16) NULL,
primary key (ID)
);
create index RM_NNK ON Role_Member(Nickname_To_Lower);

create table Object
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Name CHAR(32) NULL,
Price CHAR(8) NULL,
Cost CHAR(8) NULL,
Money CHAR(8) NULL,
Maximum_Children CHAR(8) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
Description1 TEXT NULL,
Description2 TEXT NULL,
Place CHAR(32) NULL,
Stage_Password CHAR(16) NULL,
Advertising_Url TEXT NULL,
Advertising_Image CHAR(16) NULL,
Background_Image CHAR(16) NULL,
Background_Color CHAR(7) NULL,
ALink_Color CHAR(7) NULL,
VLink_Color CHAR(7) NULL,
Link_Color CHAR(7) NULL,
Text_Color CHAR(7) NULL,
Font_Face CHAR(32) NULL,
VRML_File CHAR(128) NULL,
Chat_Type CHAR(16) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
CTN CHAR(16) NULL,
CNM CHAR(16) NULL,
ENM CHAR(16) NULL,
BNM CHAR(16) NULL,
PNM CHAR(16) NULL,
CCA CHAR(8) NULL,
CCB CHAR(8) NULL,
CCC CHAR(8) NULL,
CCD CHAR(8) NULL,
CCE CHAR(8) NULL,
CCF CHAR(8) NULL,
CCG CHAR(8) NULL,
CCH CHAR(8) NULL,
CCI CHAR(8) NULL,
CCJ CHAR(8) NULL,
CCK CHAR(8) NULL,
CCL CHAR(8) NULL,
CCM CHAR(8) NULL,
CCN CHAR(8) NULL,
CCO CHAR(8) NULL,
CCP CHAR(8) NULL,
CCQ CHAR(8) NULL,
CCR CHAR(8) NULL,
CCS CHAR(8) NULL,
CCT CHAR(8) NULL,
CCU CHAR(8) NULL,
CCV CHAR(8) NULL,
CCW CHAR(8) NULL,
CCX CHAR(8) NULL,
CCY CHAR(8) NULL,
CCZ CHAR(8) NULL,
CC0 CHAR(8) NULL,
CC1 CHAR(8) NULL,
CC2 CHAR(8) NULL,
CC3 CHAR(8) NULL,
CC4 CHAR(8) NULL,
CC5 CHAR(8) NULL,
CC6 CHAR(8) NULL,
CC7 CHAR(8) NULL,
CC8 CHAR(8) NULL,
CC9 CHAR(8) NULL,
primary key (ID)
);

create table Club
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Name CHAR(16) NULL,
Name_To_Lower CHAR(16) NULL,
Keyword_1 CHAR(32) NULL,
Keyword_2 CHAR(32) NULL,
Keyword_3 CHAR(32) NULL,
Keyword_1_To_Lower CHAR(32) NULL,
Keyword_2_To_Lower CHAR(32) NULL,
Keyword_3_To_Lower CHAR(32) NULL,
Creation_Date CHAR(14) NULL,
Activity CHAR(8) NULL,
Description TEXT NULL,
Rules CHAR(1024) NULL,
Kind CHAR(1) NULL,
Member_Count CHAR(8) NULL,
Member_Count_Last_Week CHAR(8) NULL,
Money CHAR(8) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
Maximum_Children CHAR(8) NULL,
Chat_Type CHAR(16) NULL,
Related_Place CHAR(16) NULL,
Group_ID CHAR(8) NULL,
Wall_Color CHAR(17) NULL,
Ceiling CHAR(17) NULL,
Floor_Color CHAR(17) NULL,
Status_Club_Image CHAR(1) NULL,
Status_Gallery_Picture_1 CHAR(1) NULL,
Status_Gallery_Picture_2 CHAR(1) NULL,
Status_Gallery_Picture_3 CHAR(1) NULL,
Status_Gallery_Picture_4 CHAR(1) NULL,
Status_Gallery_Picture_5 CHAR(1) NULL,
Status_Gallery_Picture_6 CHAR(1) NULL,
Status_Gallery_Picture_7 CHAR(1) NULL,
Status_Gallery_Picture_8 CHAR(1) NULL,
Status_Meeting_Room_Picture CHAR(1) NULL,
Status_Assembly_Room_Picture CHAR(1) NULL,
Club_Image CHAR(64) NULL,
Gallery_Picture_1 CHAR(64) NULL,
Gallery_Picture_2 CHAR(64) NULL,
Gallery_Picture_3 CHAR(64) NULL,
Picture_1 CHAR(64) NULL,
Picture_2 CHAR(64) NULL,
Picture_3 CHAR(64) NULL,
Picture_4 CHAR(64) NULL,
Picture_5 CHAR(64) NULL,
Picture_6 CHAR(64) NULL,
Picture_7 CHAR(64) NULL,
Picture_8 CHAR(64) NULL,
Meeting_Room_Picture CHAR(64) NULL,
Assembly_Room_Picture CHAR(64) NULL,
Club_Image_Filename CHAR(64) NULL,
Gallery_Filename_1 CHAR(64) NULL,
Gallery_Filename_2 CHAR(64) NULL,
Gallery_Filename_3 CHAR(64) NULL,
Meeting_Room_Filename CHAR(64) NULL,
Assembly_Room_Filename CHAR(64) NULL,
Total_Club_Count CHAR(8) NULL,
Statistc_Update_Date CHAR(14) NULL,
Link0 TEXT NULL,
Link1 TEXT NULL,
Link2 TEXT NULL,
Link3 TEXT NULL,
Link4 TEXT NULL,
Link5 TEXT NULL,
Link0_Description TEXT NULL,
Link1_Description TEXT NULL,
Link2_Description TEXT NULL,
Link3_Description TEXT NULL,
Link4_Description TEXT NULL,
Link5_Description TEXT NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
Background_Color CHAR(7) NULL,
ALink_Color CHAR(7) NULL,
VLink_Color CHAR(7) NULL,
Link_Color CHAR(7) NULL,
Text_Color CHAR(7) NULL,
Fog CHAR(8) NULL,
VRML_File CHAR(128) NULL,
primary key (ID)
);
create unique index C_NAK ON Club(Name_To_Lower);
create index C_KK1 ON Club(Keyword_1_To_Lower);
create index C_KK2 ON Club(Keyword_2_To_Lower);
create index C_KK3 ON Club(Keyword_3_To_Lower);
create index C_CDA ON Club(Creation_Date);
create index C_ACT ON Club(Activity);
create index C_CNT ON Club(Member_Count);
create index C_PID ON Club(Related_Place);
create index C_CLW ON Club(Member_Count_Last_Week);

create table Club_Member
(
ID CHAR(26) NOT NULL,
Status CHAR(1) NULL,
Nickname CHAR(16) NULL,
Last_Visit_Date CHAR(14) NULL,
Join_Date CHAR(14) NULL,
primary key (ID)
);
create index C_STT ON Club_Member(Status);
create index C_LVD ON Club_Member(Last_Visit_Date);
create index C_NNM ON Club_Member(Nickname);

create table Information
(
ID CHAR(64) NOT NULL,
Owner CHAR(8) NULL,
Nickname CHAR(16) NULL,
Name CHAR(32) NULL,
Description1 TEXT NULL,
Html_Allowed CHAR(3) NULL,
Last_Access_Date CHAR(14) NULL,
Start_Date CHAR(14) NULL,
End_Date CHAR(14) NULL,
URL CHAR(64) NULL,
Location_Id CHAR(16) NULL,
Location_Datatype CHAR(2) NULL,
Place CHAR(64) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
);

create table Voting
(
ID CHAR(34) NOT NULL,
Place CHAR(17) NULL,
RID CHAR(8) NULL,
Topic CHAR(128) NULL,
Choice CHAR(16) NULL,
Nickname CHAR(16) NULL,
Type CHAR(1) NULL,
Iniator_ID CHAR(8) NULL,
Start_Date CHAR(8) NULL,
End_Date CHAR(8) NULL,
Deletion_Date CHAR(8) NULL,
Member_Count CHAR(8) NULL,
Rate_Count CHAR(8) NULL,
Secret CHAR(1) NULL,
Weighted_Vote CHAR(1) NULL,
Description1 TEXT NULL,
primary key (ID)
);
create index V_PLC ON Voting(Place);
create index V_RID ON Voting(RID);

create table Group_Rights
(
ID CHAR(8) NOT NULL,
Nickname CHAR(16) NULL,
Nickname_To_Lower CHAR(16) NOT NULL,
primary key (ID)
);
create unique index G_NNK ON Group_Rights(Nickname_To_Lower);

create table Group_Member
(
ID CHAR(26) NOT NULL,
primary key (ID)
);

create table Shared_Object
(
ID CHAR(32) NOT NULL,
Category CHAR(9) NULL,
Zone CHAR(17) NULL,
Name CHAR(32) NULL,
Owner CHAR(16) NULL,
Buyer CHAR(16) NULL,
Member_Count CHAR(8) NULL,
Action_Count CHAR(8) NULL,
Class CHAR(1) NULL,
Creator CHAR(16) NULL,
Hidden CHAR(1) NULL,
Image CHAR(128) NULL,
Position CHAR(64) NULL,
Trade_Price CHAR(8) NULL,
Texture_File CHAR(128) NULL,
VRML_File CHAR(128) NULL,
Action_Buy CHAR(32) NULL,
Action_Delete CHAR(32) NULL,
Action_Display CHAR(32) NULL,
Action_Drop CHAR(32) NULL,
Action_Move CHAR(32) NULL,
Action_Take CHAR(32) NULL,
Action_000 CHAR(32) NULL,
Action_001 CHAR(32) NULL,
Action_002 CHAR(32) NULL,
Action_003 CHAR(32) NULL,
Action_004 CHAR(32) NULL,
Action_005 CHAR(32) NULL,
Action_006 CHAR(32) NULL,
Action_007 CHAR(32) NULL,
Action_008 CHAR(32) NULL,
Action_009 CHAR(32) NULL,
Action_3D0 CHAR(32) NULL,
Action_3D1 CHAR(32) NULL,
Action_3D2 CHAR(32) NULL,
Action_3D3 CHAR(32) NULL,
Action_3D4 CHAR(32) NULL,
Description1 TEXT NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
);
create index SO_CAT ON Shared_Object (Category);
create index SO_ZON ON Shared_Object (Zone);
create index SO_NAM ON Shared_Object (Name);
create index SO_OWN ON Shared_Object (Owner);

create table Ticket
(
ID CHAR(16) NOT NULL,
Owner CHAR(8) NULL,
Creation_Date CHAR(14) NULL,
Cookie CHAR(256) NULL,
primary key (ID)
);
create index T_CDA ON Ticket (Creation_Date);
create index T_OWN ON Ticket (Owner);

create table Members_Online
(
ID CHAR(8) NOT NULL,
Nickname CHAR(16) NULL,
Place CHAR(16) NULL,
Name CHAR(32) NULL,
Last_Access_Date CHAR(14) NULL,
DataType CHAR(6) NULL,
Hidden CHAR(1) NULL,
Owner CHAR(8) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
);
create index MO_NNM ON Members_Online(Nickname);
create index MO_PLC ON Members_Online(Place);
create index MO_LAD ON Members_Online(Last_Access_Date);

create table Place_Online
(
ID CHAR(32) NOT NULL,
Member_Count CHAR(8) NULL,
Total_Online_Count CHAR(8) NULL,
DataType CHAR(6) NULL,
Name CHAR(32) NULL,
Owner CHAR(8) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
);
create index PO_CNT ON Place_Online(Member_Count);

create table Home
(
ID CHAR(32) NOT NULL,
Owner CHAR(8) NULL,
Name CHAR(32) NULL,
Object_Number CHAR(8) NULL,
Maximum_Objects CHAR(8) NULL,
Maximum_Children CHAR(8) NULL,
Email1 CHAR(1) NULL,
Chat_Type CHAR(16) NULL,
Description1 TEXT NULL,
Advertising_Url TEXT NULL,
Advertising_Image CHAR(16) NULL,
Link0 TEXT NULL,
Link0_Description TEXT NULL,
Link1 TEXT NULL,
Link1_Description TEXT NULL,
Link2 TEXT NULL,
Link2_Description TEXT NULL,
Link3 TEXT NULL,
Link3_Description TEXT NULL,
Link4 TEXT NULL,
Link4_Description TEXT NULL,
Image CHAR(64) NULL,
Home_Property CHAR(20) NULL,
Status CHAR(1) NULL,
VRML_File CHAR(64) NULL,
Avatar_Image CHAR(64) NULL,
Maximum_Homes CHAR(4) NULL,
Position CHAR(64) NULL,
Price CHAR(8) NULL,
Cost CHAR(8) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
);

create table Call_Center
(
ID CHAR(8) NOT NULL,
Topic CHAR(64) NULL,
Description1 TEXT NULL,
Status CHAR(1) NULL,
Locked CHAR(1) NULL,
Priority CHAR(8) NULL,
Consultant CHAR(16) NULL,
Description TEXT NULL,
Creation_Date CHAR(14) NULL,
Start_Date CHAR(14) NULL,
End_Date CHAR(14) NULL,
Customer_ID CHAR(8) NULL,
Customer_Nickname CHAR(16) NULL,
Place CHAR(256) NULL,
Location_Datatype CHAR(2) NULL,
Location_Id CHAR(32) NULL,
Adress TEXT NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
);
create index CC_TOP ON Call_Center (Topic);
create index CC_STT ON Call_Center (Status);
create index CC_CON ON Call_Center (Consultant);
create index CC_CDA ON Call_Center (Creation_Date);

create table Avatar
(
ID CHAR(8) NOT NULL,
Sortorder CHAR(16) NULL,
Name CHAR(32) NULL,
Avatar_Image CHAR(128) NULL,
Avatar_Url CHAR(128) NULL,
Description1 TEXT NULL,
Owner CHAR(8) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(16) NULL,
primary key (ID)
);
create index A_ORD ON Avatar (Sortorder);

create table MessageBoard
(
ID CHAR(25) NOT NULL,
Key_Last_Access_Date CHAR(32) NULL,
Board_Last_Access_Date CHAR(24) NULL,
Key_Owner_Nickname CHAR(34) NULL,
Board_Owner_Nickname CHAR(26) NULL,
Key_Size CHAR(26) NULL,
Key_Rate_Count CHAR(26) NULL,
Key_Parent_Creation_Date CHAR(40) NULL,
Key_Creation_Date CHAR(32) NULL,
Key_Subject CHAR(50) NULL,
Creation_Date CHAR(14) NULL,
Last_Access_Date CHAR(14) NULL,
Size_Info CHAR(8) NULL,
Owner_Nickname CHAR(16) NULL,
Rate_Count CHAR(8) NULL,
Member_Count CHAR(8) NULL,
Subject CHAR(255) NULL,
Url CHAR(128) NULL,
Description1 TEXT NULL,
Depth CHAR(8) NULL,
Keep_Messages_Selector CHAR(1) NULL,
Keep_Messages_Count CHAR(8) NULL,
Owner CHAR(8) NULL,
Owner_Role CHAR(2) NULL,
Assist_Role CHAR(2) NULL,
Owner_Roles CHAR(32) NULL,
Assistant_ID1 CHAR(8) NULL,
Assistant_ID2 CHAR(8) NULL,
Assistant_ID3 CHAR(8) NULL,
Assistant_ID4 CHAR(8) NULL,
Assistant_ID5 CHAR(8) NULL,
Assistant_ID6 CHAR(8) NULL,
Assistant_ID7 CHAR(8) NULL,
Assistant_ID8 CHAR(8) NULL,
Read_Roles CHAR(32) NULL,
Read_ID1 CHAR(8) NULL,
Read_ID2 CHAR(8) NULL,
Read_ID3 CHAR(8) NULL,
Read_ID4 CHAR(8) NULL,
Read_ID5 CHAR(8) NULL,
Read_ID6 CHAR(8) NULL,
Read_ID7 CHAR(8) NULL,
Read_ID8 CHAR(8) NULL,
Write_Roles CHAR(32) NULL,
Write_ID1 CHAR(8) NULL,
Write_ID2 CHAR(8) NULL,
Write_ID3 CHAR(8) NULL,
Write_ID4 CHAR(8) NULL,
Write_ID5 CHAR(8) NULL,
Write_ID6 CHAR(8) NULL,
Write_ID7 CHAR(8) NULL,
Write_ID8 CHAR(8) NULL,
Change_Roles CHAR(32) NULL,
Change_Rights_ID1 CHAR(8) NULL,
Change_Rights_ID2 CHAR(8) NULL,
Change_Rights_ID3 CHAR(8) NULL,
Change_Rights_ID4 CHAR(8) NULL,
Change_Rights_ID5 CHAR(8) NULL,
Change_Rights_ID6 CHAR(8) NULL,
Change_Rights_ID7 CHAR(8) NULL,
Change_Rights_ID8 CHAR(8) NULL,
Parent_Table CHAR(2) NULL,
Parent_Keytype CHAR(3) NULL,
Parent_Key CHAR(25) NULL,
primary key (ID)
);
create index ID_LAD ON MessageBoard (Key_Last_Access_Date);
create index BID_LAD ON MessageBoard (Board_Last_Access_Date);
create index ID_ONN ON MessageBoard (Key_Owner_Nickname);
create index BID_ONN ON MessageBoard (Board_Owner_Nickname);
create index ID_SIZ ON MessageBoard (Key_Size);
create index ID_RCT ON MessageBoard (Key_Rate_Count);
create index PID_CDA ON MessageBoard (Key_Parent_Creation_Date);
create index ID_CDA ON MessageBoard (Key_Creation_Date);
create index ID_SUB ON MessageBoard (Key_Subject);

sqserver.sql

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: B Block
C Community
CL Club
CM Club_Member
G Group_Rights
GM Group_Member
I Information
M Member
MD Member_Data
N Neighborhood
O Object
P Property
R Role
RM Role_Member
S Exp_Level
SM Exp_Level_Member
SO Shared_Object
T Ticket
U Multimedia
V Voting
VP Virtual_Pets

ACT Activity
ADU Advertising_Url
ADI Advertising_Image
ARF Assembly_Room_Filename
ARP Assembly_Room_Picture
ASR Assist_Role
AS1 Assistant_ID1
AS2 Assistant_ID2
AS3 Assistant_ID3
AS4 Assistant_ID4
AS5 Assistant_ID5
AS6 Assistant_ID6
AS7 Assistant_ID7
AS8 Assistant_ID8
AVI Avatar_Image
AVU Avatar_Url
AVC Avatar_Checked
AV0 Avatar_Desc0
AV1 Avatar_Desc1
AV2 Avatar_Desc2
AV3 Avatar_Desc3
AV4 Avatar_Desc4
aBUY Action_Buy
aDEL Action_Delete
aDIS Action_Display
aDRO Action_Drop
aMOV Action_Move
aTAK Action_Take
a000 Action_000
a001 Action_001
a002 Action_002
a003 Action_003
a004 Action_004
a005 Action_005
a006 Action_006
a007 Action_007
a008 Action_008
a009 Action_009
a3D0 Action_3D0
a3D1 Action_3D1
a3D2 Action_3D2
a3D3 Action_3D3
a3D4 Action_3D4

BAS Blaxxun_Avatar_Studio
BGI Background_Image
BNL Newsletter
BUY Buyer
BU0 Buddy_Name_0
BU1 Buddy_Name_1
BU2 Buddy_Name_2
BU3 Buddy_Name_3
BU4 Buddy_Name_4
BU5 Buddy_Name_5
BU6 Buddy_Name_6
BU7 Buddy_Name_7
BU8 Buddy_Name_8
BU9 Buddy_Name_9
BU10 Buddy_Name_10
BU11 Buddy_Name_11
BU12 Buddy_Name_12
BU13 Buddy_Name_13
BU14 Buddy_Name_14
BU15 Buddy_Name_15

CAT Category
CDA Creation_Date
CEC Ceiling
CHO Choice
CHT Chat_Type
CI1 Change_Rights_ID1
CI2 Change_Rights_ID2
CI3 Change_Rights_ID3
CI4 Change_Rights_ID4
CI5 Change_Rights_ID5
CI6 Change_Rights_ID6
CI7 Change_Rights_ID7
CI8 Change_Rights_ID8
CKI Kind
CK1 Keyword_1
CK2 Keyword_2
CK3 Keyword_3
CLA ALink_Color
CLB Background_Color
CLF Club_Image_Filename
CLL Link_Color
CLP Club_Image
CLS Class
CLT Text_Color
CLV VLink_Color
CLW Member_Count_Last_Week
CMX Maximum_Children
CNT Member_Count
COO Cookie
CRE Creator
CRO Change_Roles
CST Cost

DAT Data
DDA Deletion_Date
DES Description

EDA End_Date
EMI Email3
EML Email1
EMK Email2
EXD Exclusion_Date
EXP Experience
EXT Exclusion_Reason
EXM Excluding_Member

FACE Font_Face
FIL Filename
FLC Floor_Color
FNM First_Name
FRE Free_Homes

GID Group_ID
GF1 Gallery_Filename_1
GF2 Gallery_Filename_1
GF3 Gallery_Filename_3
GP1 Gallery_Picture_1
GP2 Gallery_Picture_2
GP3 Gallery_Picture_3

HID Hidden
HOM Home_Property
HPG Home_Page
HTM Html_Allowed

IC2 Index_2D_Icon
IC3 Index_3D_Icon
IEP Income_Experience
IID Iniator_ID
IMD Immigration_Date
IMG Image
IMS Instant_Message_Status
IM1 Immigration_Info
IM2 Index_Image
INC Income_Money
INT Interests

JND Join_Date

KK1 Keyword_1_To_Lower
KK2 Keyword_2_To_Lower
KK3 Keyword_3_To_Lower

LAD Last_Access_Date
LAE Last_Access_Exp
LAM Last_Access_Money
LDT Location_Datatype
LD0 Link0_Description
LD1 Link1_Description
LD2 Link2_Description
LD3 Link3_Description
LD4 Link4_Description
LD5 Link5_Description
LID Location_Id
LL0 Link0
LL1 Link1
LL2 Link2
LL3 Link3
LL4 Link4
LL5 Link5
LNG Language
LNM Last_Name
LVD Last_Visit_Date

MAD MemberAdmin
MOB Maximum_Objects
MRF Meeting_Room_Filename
MRP Meeting_Room_Picture
MYR My_Role

NAC Action_Count
NAM Name
NAK Name_To_Lower
NG0 NewsTickerTarget0
NG1 NewsTickerTarget1
NG2 NewsTickerTarget2
NG3 NewsTickerTarget3
NG4 NewsTickerTarget4
NG5 NewsTickerTarget5
NG6 NewsTickerTarget6
NG7 NewsTickerTarget7
NG8 NewsTickerTarget8
NG9 NewsTickerTarget9
NNK Nickname_To_Lower
NNM Nickname
NNO NewsTickerNumber
NOB Object_Number
MON Money
NT0 NewsTickerText0
NU0 NewsTickerURL0
NT1 NewsTickerText1
NU1 NewsTickerURL1
NT2 NewsTickerText2
NU2 NewsTickerURL2
NT3 NewsTickerText3
NU3 NewsTickerURL3
NT4 NewsTickerText4
NU4 NewsTickerURL4
NT5 NewsTickerText5
NU5 NewsTickerURL5
NT6 NewsTickerText6
NU6 NewsTickerURL6
NT7 NewsTickerText7
NU7 NewsTickerURL7
NT8 NewsTickerText8
NU8 NewsTickerURL8
NT9 NewsTickerText9
NU9 NewsTickerURL9
NOB Object_Number

ORO Owner_Roles
OWN Owner
OWR Owner_Role

PDT Parent_Table
PKT Parent_Keytype
PKE Parent_Key
PID Related_Place
PLC Place
plc Place
POS Position
PRC Price
PU2 PU2
PWD Password

REF Referenced_Member
RGK Immigration_Key
ROL Role
RRO Read_Roles
RID RID
RI1 Read_ID1
RI2 Read_ID2
RI3 Read_ID3
RI4 Read_ID4
RI5 Read_ID5
RI6 Read_ID6
RI7 Read_ID7
RI8 Read_ID8
RUL Rules

SDA Start_Date
SEC Secret
STA Status_Assembly_Room_Picture
STC Status_Club_Image
STM Status_Meeting_Room_Picture
STT Status
ST1 Status_Gallery_Picture_1
ST2 Status_Gallery_Picture_2
ST3 Status_Gallery_Picture_3
SYM Symbol

TCN Total_Club_Count
TOP Topic
TPR Trade_Price
TXF Texture_File
TXT Description1
TX2 Description2
TYP Type

UDD Statistc_Update_Date

VWW Weighted_Vote

VNN VP_Nickname
VUR VP_Avatar_Url
VA0 VP_Action_0
VB0 VP_Beam_To_0
VD0 VP_Direct_Mode_0
VM0 VP_Match_Mode_0
VP0 VP_Pattern_0
VT0 VP_Text_0
VA1 VP_Action_1
VB1 VP_Beam_To_1
VD1 VP_Direct_Mode_1
VM1 VP_Match_Mode_1
VP1 VP_Pattern_1
VT1 VP_Text_1
VA2 VP_Action_2
VB2 VP_Beam_To_2
VD2 VP_Direct_Mode_2
VM2 VP_Match_Mode_2
VP2 VP_Pattern_2
VT2 VP_Text_2
VA3 VP_Action_3
VB3 VP_Beam_To_3
VD3 VP_Direct_Mode_3
VM3 VP_Match_Mode_3
VP3 VP_Pattern_3
VT3 VP_Text_3
VA4 VP_Action_4
VB4 VP_Beam_To_4
VD4 VP_Direct_Mode_4
VM4 VP_Match_Mode_4
VP4 VP_Pattern_4
VT4 VP_Text_4
VA5 VP_Action_5
VB5 VP_Beam_To_5
VD5 VP_Direct_Mode_5
VM5 VP_Match_Mode_5
VP5 VP_Pattern_5
VT5 VP_Text_5
VA6 VP_Action_6
VB6 VP_Beam_To_6
VD6 VP_Direct_Mode_6
VM6 VP_Match_Mode_6
VP6 VP_Pattern_6
VT6 VP_Text_6
VA7 VP_Action_7
VB7 VP_Beam_To_7
VD7 VP_Direct_Mode_7
VM7 VP_Match_Mode_7
VP7 VP_Pattern_7
VT7 VP_Text_7
VA8 VP_Action_8
VB8 VP_Beam_To_8
VD8 VP_Direct_Mode_8
VM8 VP_Match_Mode_8
VP8 VP_Pattern_8
VT8 VP_Text_8
VA9 VP_Action_9
VB9 VP_Beam_To_9
VD9 VP_Direct_Mode_9
VM9 VP_Match_Mode_9
VP9 VP_Pattern_9
VT9 VP_Text_9

WAC Wall_Color
WI1 Write_ID1
WI2 Write_ID2
WI3 Write_ID3
WI4 Write_ID4
WI5 Write_ID5
WI6 Write_ID6
WI7 Write_ID7
WI8 Write_ID8
WRL VRML_File
WRO Write_Roles
WR3 Index_World

ZON Zone

2IN X2IN
2IF X2IF
2IP X2IP
2IL X2IL
2IC X2IC
2DP X2DP
2DL X2DL
2DC X2DC
3IP X3IP
3IL X3IL
3IC X3IC

sqserver.cfg

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: A Avatar
B Block
C Community
CL Club
CC Call_Center
CM Club_Member
G Group_Rights
GM Group_Member
H Home
I Information
M Member
MB MessageBoard
MD Member_Data
MO Members_Online
N Neighborhood
O Object
P Property
PO Place_Online
R Role
RM Role_Member
S Exp_Level
SM Exp_Level_Member
SO Shared_Object
T Ticket
U Multimedia
V Voting
VI Visitor

ACT Activity
ADU Advertising_Url
ADI Advertising_Image
ADR Adress
AGE Age
AIM Instant_Message_Auto_Popup
ARF Assembly_Room_Filename
ARP Assembly_Room_Picture
ASR Assist_Role
AS1 Assistant_ID1
AS2 Assistant_ID2
AS3 Assistant_ID3
AS4 Assistant_ID4
AS5 Assistant_ID5
AS6 Assistant_ID6
AS7 Assistant_ID7
AS8 Assistant_ID8
AVI Avatar_Image
AVU Avatar_Url
AVC Avatar_Checked
AV0 Avatar_Desc0
AV1 Avatar_Desc1
AV2 Avatar_Desc2
AV3 Avatar_Desc3
AV4 Avatar_Desc4
aBUY Action_Buy
aDEL Action_Delete
aDIS Action_Display
aDRO Action_Drop
aMOV Action_Move
aTAK Action_Take
a000 Action_000
a001 Action_001
a002 Action_002
a003 Action_003
a004 Action_004
a005 Action_005
a006 Action_006
a007 Action_007
a008 Action_008
a009 Action_009
a3D0 Action_3D0
a3D1 Action_3D1
a3D2 Action_3D2
a3D3 Action_3D3
a3D4 Action_3D4

BAS Blaxxun_Avatar_Studio
BGI Background_Image
BIDLAD Board_Last_Access_Date
BIDONN Board_Owner_Nickname
BNL Newsletter
BUY Buyer
BU0 Buddy_Name_0
BU1 Buddy_Name_1
BU2 Buddy_Name_2
BU3 Buddy_Name_3
BU4 Buddy_Name_4
BU5 Buddy_Name_5
BU6 Buddy_Name_6
BU7 Buddy_Name_7
BU8 Buddy_Name_8
BU9 Buddy_Name_9
BU10 Buddy_Name_10
BU11 Buddy_Name_11
BU12 Buddy_Name_12
BU13 Buddy_Name_13
BU14 Buddy_Name_14
BU15 Buddy_Name_15

CAC Cache_Root
CVE Cache_Version
CAT Category
CDA Creation_Date
CEC Ceiling
CHO Choice
CHT Chat_Type
CI1 Change_Rights_ID1
CI2 Change_Rights_ID2
CI3 Change_Rights_ID3
CI4 Change_Rights_ID4
CI5 Change_Rights_ID5
CI6 Change_Rights_ID6
CI7 Change_Rights_ID7
CI8 Change_Rights_ID8
CID Customer_ID
CKI Kind
CK1 Keyword_1
CK2 Keyword_2
CK3 Keyword_3
CLA ALink_Color
CLB Background_Color
CLF Club_Image_Filename
CLL Link_Color
CLP Club_Image
CLS Class
CLT Text_Color
CLV VLink_Color
CLW Member_Count_Last_Week
CMX Maximum_Children
CNK Customer_Nickname
CNT Member_Count
CON Consultant
COO Cookie
CRE Creator
CRO Change_Roles
CST Cost

DAT Data
DDA Deletion_Date
DEP Depth
DES Description
DTY DataType

ECT Exclusion_Counter
EDA End_Date
EMI Email3
EML Email1
EMK Email2
EXD Exclusion_Date
EXP Experience
EXT Exclusion_Reason
EXM Excluding_Member

FACE Font_Face
FIL Filename
FLC Floor_Color
FNM First_Name
FOG Fog
FPA Forgot_Pwd_Answer
FPQ Forgot_Pwd_Question
FRE Free_Homes

GID Group_ID
GF1 Gallery_Filename_1
GF2 Gallery_Filename_1
GF3 Gallery_Filename_3
GP1 Gallery_Picture_1
GP2 Gallery_Picture_2
GP3 Gallery_Picture_3

HID Hidden
HLP Help
HOM Home_Property
HPG Home_Page
HTM Html_Allowed

IC2 Index_2D_Icon
IC3 Index_3D_Icon
IDCDA Key_Creation_Date
IDLAD Key_Last_Access_Date
IDONN Key_Owner_Nickname
IDRCT Key_Rate_Count
IDSIZ Key_Size
IDSUB Key_Subject
IEP Income_Experience
IID Iniator_ID
IMD Immigration_Date
IMG Image
IMS Instant_Message_Status
IM1 Immigration_Info
IM2 Index_Image
INC Income_Money
INT Interests

JND Join_Date

KK1 Keyword_1_To_Lower
KK2 Keyword_2_To_Lower
KK3 Keyword_3_To_Lower
KMS Keep_Messages_Selector
KMC Keep_Messages_Count

LAD Last_Access_Date
LAE Last_Access_Exp
LAM Last_Access_Money
LDT Location_Datatype
LD0 Link0_Description
LD1 Link1_Description
LD2 Link2_Description
LD3 Link3_Description
LD4 Link4_Description
LD5 Link5_Description
LID Location_Id
LIP Last_Used_IP
LL0 Link0
LL1 Link1
LL2 Link2
LL3 Link3
LL4 Link4
LL5 Link5
LNG Language
LNM Last_Name
LOC Locked
LVD Last_Visit_Date

MAD MemberAdmin
MHO Maximum_Homes
MOB Maximum_Objects
MRF Meeting_Room_Filename
MRP Meeting_Room_Picture
MYR My_Role

NAC Action_Count
NAM Name
NAK Name_To_Lower
NG0 NewsTickerTarget0
NG1 NewsTickerTarget1
NG2 NewsTickerTarget2
NG3 NewsTickerTarget3
NG4 NewsTickerTarget4
NG5 NewsTickerTarget5
NG6 NewsTickerTarget6
NG7 NewsTickerTarget7
NG8 NewsTickerTarget8
NG9 NewsTickerTarget9
NNK Nickname_To_Lower
NNM Nickname
NNO NewsTickerNumber
NOB Object_Number
MON Money
NT0 NewsTickerText0
NU0 NewsTickerURL0
NT1 NewsTickerText1
NU1 NewsTickerURL1
NT2 NewsTickerText2
NU2 NewsTickerURL2
NT3 NewsTickerText3
NU3 NewsTickerURL3
NT4 NewsTickerText4
NU4 NewsTickerURL4
NT5 NewsTickerText5
NU5 NewsTickerURL5
NT6 NewsTickerText6
NU6 NewsTickerURL6
NT7 NewsTickerText7
NU7 NewsTickerURL7
NT8 NewsTickerText8
NU8 NewsTickerURL8
NT9 NewsTickerText9
NU9 NewsTickerURL9
NOB Object_Number

ONN Owner_Nickname
ORD Sortorder
ORO Owner_Roles
OWN Owner
OWR Owner_Role

PDT Parent_Table
PKT Parent_Keytype
PKE Parent_Key
PI1 Picture_1
PI2 Picture_2
PI3 Picture_3
PI4 Picture_4
PI5 Picture_5
PI6 Picture_6
PI7 Picture_7
PI8 Picture_8
PID Related_Place
PIDCDA Key_Parent_Creation_Date
PLC Place
plc Place
PLG Plugin
POS Position
PRC Price
PR1 Profile_1
PR2 Profile_2
PRI Priority
PU2 PU2
PWD Password

RCT Rate_Count
REF Referenced_Member
RGK Immigration_Key
ROL Role
RRO Read_Roles
RID RID
RI1 Read_ID1
RI2 Read_ID2
RI3 Read_ID3
RI4 Read_ID4
RI5 Read_ID5
RI6 Read_ID6
RI7 Read_ID7
RI8 Read_ID8
RUL Rules

SDA Start_Date
SEC Secret
SIZ Size_Info
SPW Stage_Password
STA Status_Assembly_Room_Picture
STC Status_Club_Image
STM Status_Meeting_Room_Picture
STT Status
ST1 Status_Gallery_Picture_1
ST2 Status_Gallery_Picture_2
ST3 Status_Gallery_Picture_3
ST4 Status_Gallery_Picture_4
ST5 Status_Gallery_Picture_5
ST6 Status_Gallery_Picture_6
ST7 Status_Gallery_Picture_7
ST8 Status_Gallery_Picture_8
SUB Subject
SYM Symbol

TCN Total_Club_Count
TOC Total_Online_Count
TOP Topic
TPR Trade_Price
TXF Texture_File
TXT Description1
TX2 Description2
TYP Type

UDD Statistc_Update_Date
URL Url

VWW Weighted_Vote

WAC Wall_Color
WI1 Write_ID1
WI2 Write_ID2
WI3 Write_ID3
WI4 Write_ID4
WI5 Write_ID5
WI6 Write_ID6
WI7 Write_ID7
WI8 Write_ID8
WRL VRML_File
WRO Write_Roles
WR3 Index_World

ZON Zone

2IN X2IN
2IF X2IF
2IP X2IP
2IL X2IL
2IC X2IC
2DP X2DP
2DL X2DL
2DC X2DC
3IP X3IP
3IL X3IL
3IC X3IC

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: create table Member
(
ID VARCHAR2(8) NOT NULL,
Email1 VARCHAR2(64) NOT NULL,
Email2 VARCHAR2(64) NULL,
Email3 VARCHAR2(64) NULL,
Nickname VARCHAR2(16) NULL,
Nickname_To_Lower VARCHAR2(16) NOT NULL,
Immigration_Date VARCHAR2(14) NULL,
Last_Access_Date VARCHAR2(14) NULL,
Money VARCHAR2(8) NULL,
Experience VARCHAR2(8) NULL,
Last_Name VARCHAR2(32) NULL,
First_Name VARCHAR2(20) NULL,
Password VARCHAR2(16) NULL,
Immigration_Key VARCHAR2(5) NULL,
Immigration_Info VARCHAR2(64) NULL,
Exclusion_Date VARCHAR2(14) NULL,
Role VARCHAR2(32) NULL,
Home_Property VARCHAR2(16) NULL,
Referenced_Member VARCHAR2(16) NULL,
Home_Page VARCHAR2(128) NULL,
Chat_Type VARCHAR2(1) NULL,
Cookie VARCHAR2(1) NULL,
Last_Access_Exp VARCHAR2(14) NULL,
Last_Access_Money VARCHAR2(14) NULL,
Object_Number VARCHAR2(8) NULL,
Maximum_Objects VARCHAR2(8) NULL,
primary key (ID)
);
create unique index M_EML ON Member (Email1);
create unique index M_NNM ON Member (Nickname);
create unique index M_NNK ON Member (Nickname_To_Lower);
create index M_IMD ON Member (Immigration_Date);
create index M_LAD ON Member (Last_Access_Date);
create index M_MON ON Member (Money);
create index M_EXP ON Member (Experience);
create index M_LNM ON Member (Last_Name);

create table Visitor
(
ID VARCHAR2(8) NOT NULL,
Nickname VARCHAR2(16) NULL,
Nickname_To_Lower VARCHAR2(16) NOT NULL,
Immigration_Date VARCHAR2(14) NULL,
Last_Access_Date VARCHAR2(14) NULL,
Password VARCHAR2(16) NULL,
Exclusion_Date VARCHAR2(14) NULL,
Language VARCHAR2(2) NULL,
Last_Used_IP VARCHAR2(16) NULL,
Plugin VARCHAR2(1) NULL,
primary key (ID)
);
create unique index VI_NNM ON Visitor (Nickname);
create unique index VI_NNK ON Visitor (Nickname_To_Lower);
create index VI_IMD ON Visitor (Immigration_Date);
create index VI_LAD ON Visitor (Last_Access_Date);

create table Member_Data
(
ID VARCHAR2(8) NOT NULL,
Exclusion_Reason VARCHAR2(128) NULL,
Exclusion_Counter VARCHAR2(8) NULL,
Excluding_Member VARCHAR2(16) NULL,
Description1 VARCHAR2(1536) NULL,
Instant_Message_Status VARCHAR2(1) NULL,
Newsletter VARCHAR2(1) NULL,
Language VARCHAR2(2) NULL,
Stage_Password VARCHAR(16) NULL,
Help VARCHAR2(1) NULL,
Blaxxun_Avatar_Studio VARCHAR2(32) NULL,
Buddy_Name_0 VARCHAR2(16) NULL,
Buddy_Name_1 VARCHAR2(16) NULL,
Buddy_Name_2 VARCHAR2(16) NULL,
Buddy_Name_3 VARCHAR2(16) NULL,
Buddy_Name_4 VARCHAR2(16) NULL,
Buddy_Name_5 VARCHAR2(16) NULL,
Buddy_Name_6 VARCHAR2(16) NULL,
Buddy_Name_7 VARCHAR2(16) NULL,
Buddy_Name_8 VARCHAR2(16) NULL,
Buddy_Name_9 VARCHAR2(16) NULL,
Buddy_Name_10 VARCHAR2(16) NULL,
Buddy_Name_11 VARCHAR2(16) NULL,
Buddy_Name_12 VARCHAR2(16) NULL,
Buddy_Name_13 VARCHAR2(16) NULL,
Buddy_Name_14 VARCHAR2(16) NULL,
Buddy_Name_15 VARCHAR2(16) NULL,
My_Role VARCHAR2(2) NULL,
Interests VARCHAR2(64) NULL,
Avatar_Image VARCHAR2(128) NULL,
Avatar_Url VARCHAR2(128) NULL,
Avatar_Checked VARCHAR2(16) NULL,
Avatar_Desc0 VARCHAR2(64) NULL,
Avatar_Desc1 VARCHAR2(64) NULL,
Avatar_Desc2 VARCHAR2(64) NULL,
Avatar_Desc3 VARCHAR2(64) NULL,
Avatar_Desc4 VARCHAR2(64) NULL,
Instant_Message_Auto_Popup VARCHAR2(1) NULL,
Forgot_Pwd_Question VARCHAR2(64) NULL,
Forgot_Pwd_Answer VARCHAR2(32) NULL,
Last_Used_IP VARCHAR2(16) NULL,
Age VARCHAR2(8) NULL,
Profile_1 VARCHAR2(32) NULL,
Profile_2 VARCHAR2(32) NULL,
Cache_Root VARCHAR2(64) NULL,
Cache_Version VARCHAR2(8) NULL,
Plugin VARCHAR2(1) NULL,
primary key (ID)
);
create index M_BAS ON Member_Data (Blaxxun_Avatar_Studio)

create table Role
(
ID VARCHAR2(2) NOT NULL,
Name VARCHAR2(32) NOT NULL,
Email1 VARCHAR2(32) NULL,
Experience VARCHAR2(8) NULL,
Type VARCHAR2(1) NULL,
Income_Money VARCHAR2(8) NULL,
Income_Experience VARCHAR2(8) NULL,
Symbol VARCHAR2(1536) NULL,
Owner VARCHAR2(8) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(16) NULL,
primary key (ID)
);
create unique index R_NAM ON Role(Name);
create index R_EXP ON Role(Experience);

create table Role_Member
(
ID VARCHAR2(32) NOT NULL,
Nickname_To_Lower VARCHAR2(16) NULL,
Nickname VARCHAR2(16) NULL,
primary key (ID)
);
create index RM_NNK ON Role_Member(Nickname_To_Lower);

create table Object
(
ID VARCHAR2(16) NOT NULL,
Owner VARCHAR2(8) NULL,
Name VARCHAR2(32) NULL,
Price VARCHAR2(8) NULL,
Cost VARCHAR2(8) NULL,
Money VARCHAR2(8) NULL,
Maximum_Children VARCHAR2(8) NULL,
Object_Number VARCHAR2(8) NULL,
Maximum_Objects VARCHAR2(8) NULL,
Description1 VARCHAR2(1536) NULL,
Description2 VARCHAR2(1536) NULL,
Place VARCHAR2(32) NULL,
Stage_Password VARCHAR(16) NULL,
Advertising_Url VARCHAR2(256) NULL,
Advertising_Image VARCHAR2(16) NULL,
Background_Image VARCHAR2(16) NULL,
Background_Color VARCHAR2(7) NULL,
ALink_Color VARCHAR2(7) NULL,
VLink_Color VARCHAR2(7) NULL,
Link_Color VARCHAR2(7) NULL,
Text_Color VARCHAR2(7) NULL,
Font_Face VARCHAR2(32) NULL,
VRML_File VARCHAR2(128) NULL,
Chat_Type VARCHAR2(16) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(16) NULL,
CTN VARCHAR2(16) NULL,
CNM VARCHAR2(16) NULL,
ENM VARCHAR2(16) NULL,
BNM VARCHAR2(16) NULL,
PNM VARCHAR2(16) NULL,
CCA VARCHAR2(8) NULL,
CCB VARCHAR2(8) NULL,
CCC VARCHAR2(8) NULL,
CCD VARCHAR2(8) NULL,
CCE VARCHAR2(8) NULL,
CCF VARCHAR2(8) NULL,
CCG VARCHAR2(8) NULL,
CCH VARCHAR2(8) NULL,
CCI VARCHAR2(8) NULL,
CCJ VARCHAR2(8) NULL,
CCK VARCHAR2(8) NULL,
CCL VARCHAR2(8) NULL,
CCM VARCHAR2(8) NULL,
CCN VARCHAR2(8) NULL,
CCO VARCHAR2(8) NULL,
CCP VARCHAR2(8) NULL,
CCQ VARCHAR2(8) NULL,
CCR VARCHAR2(8) NULL,
CCS VARCHAR2(8) NULL,
CCT VARCHAR2(8) NULL,
CCU VARCHAR2(8) NULL,
CCV VARCHAR2(8) NULL,
CCW VARCHAR2(8) NULL,
CCX VARCHAR2(8) NULL,
CCY VARCHAR2(8) NULL,
CCZ VARCHAR2(8) NULL,
CC0 VARCHAR2(8) NULL,
CC1 VARCHAR2(8) NULL,
CC2 VARCHAR2(8) NULL,
CC3 VARCHAR2(8) NULL,
CC4 VARCHAR2(8) NULL,
CC5 VARCHAR2(8) NULL,
CC6 VARCHAR2(8) NULL,
CC7 VARCHAR2(8) NULL,
CC8 VARCHAR2(8) NULL,
CC9 VARCHAR2(8) NULL,
primary key (ID)
);

create table Club
(
ID VARCHAR2(16) NOT NULL,
Owner VARCHAR2(8) NULL,
Name VARCHAR2(16) NULL,
Name_To_Lower VARCHAR2(16) NULL,
Keyword_1 VARCHAR2(32) NULL,
Keyword_2 VARCHAR2(32) NULL,
Keyword_3 VARCHAR2(32) NULL,
Keyword_1_To_Lower VARCHAR2(32) NULL,
Keyword_2_To_Lower VARCHAR2(32) NULL,
Keyword_3_To_Lower VARCHAR2(32) NULL,
Creation_Date VARCHAR2(14) NULL,
Activity VARCHAR2(8) NULL,
Description VARCHAR2(1536) NULL,
Rules VARCHAR2(1024) NULL,
Kind VARCHAR2(1) NULL,
Member_Count VARCHAR2(8) NULL,
Member_Count_Last_Week VARCHAR2(8) NULL,
Money VARCHAR2(8) NULL,
Object_Number VARCHAR2(8) NULL,
Maximum_Objects VARCHAR2(8) NULL,
Maximum_Children VARCHAR2(8) NULL,
Chat_Type VARCHAR(16) NULL,
Related_Place VARCHAR2(16) NULL,
Group_ID VARCHAR2(8) NULL,
Wall_Color VARCHAR2(17) NULL,
Ceiling VARCHAR2(17) NULL,
Floor_Color VARCHAR2(17) NULL,
Status_Club_Image VARCHAR2(1) NULL,
Status_Gallery_Picture_1 VARCHAR2(1) NULL,
Status_Gallery_Picture_2 VARCHAR2(1) NULL,
Status_Gallery_Picture_3 VARCHAR2(1) NULL,
Status_Gallery_Picture_4 VARCHAR2(1) NULL,
Status_Gallery_Picture_5 VARCHAR2(1) NULL,
Status_Gallery_Picture_6 VARCHAR2(1) NULL,
Status_Gallery_Picture_7 VARCHAR2(1) NULL,
Status_Gallery_Picture_8 VARCHAR2(1) NULL,
Status_Meeting_Room_Picture VARCHAR2(1) NULL,
Status_Assembly_Room_Picture VARCHAR2(1) NULL,
Club_Image VARCHAR2(64) NULL,
Gallery_Picture_1 VARCHAR2(64) NULL,
Gallery_Picture_2 VARCHAR2(64) NULL,
Gallery_Picture_3 VARCHAR2(64) NULL,
Meeting_Room_Picture VARCHAR2(64) NULL,
Assembly_Room_Picture VARCHAR2(64) NULL,
Club_Image_Filename VARCHAR2(64) NULL,
Gallery_Filename_1 VARCHAR2(64) NULL,
Gallery_Filename_2 VARCHAR2(64) NULL,
Gallery_Filename_3 VARCHAR2(64) NULL,
Picture_1 VARCHAR2(64) NULL,
Picture_2 VARCHAR2(64) NULL,
Picture_3 VARCHAR2(64) NULL,
Picture_4 VARCHAR2(64) NULL,
Picture_5 VARCHAR2(64) NULL,
Picture_6 VARCHAR2(64) NULL,
Picture_7 VARCHAR2(64) NULL,
Picture_8 VARCHAR2(64) NULL,
Meeting_Room_Filename VARCHAR2(64) NULL,
Assembly_Room_Filename VARCHAR2(64) NULL,
Total_Club_Count VARCHAR2(8) NULL,
Statistc_Update_Date VARCHAR2(14) NULL,
Link0 VARCHAR2(256) NULL,
Link1 VARCHAR2(256) NULL,
Link2 VARCHAR2(256) NULL,
Link3 VARCHAR2(256) NULL,
Link4 VARCHAR2(256) NULL,
Link5 VARCHAR2(256) NULL,
Link0_Description VARCHAR2(256) NULL,
Link1_Description VARCHAR2(256) NULL,
Link2_Description VARCHAR2(256) NULL,
Link3_Description VARCHAR2(256) NULL,
Link4_Description VARCHAR2(256) NULL,
Link5_Description VARCHAR2(256) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(16) NULL,
Background_Color VARCHAR2(7) NULL,
ALink_Color VARCHAR2(7) NULL,
VLink_Color VARCHAR2(7) NULL,
Link_Color VARCHAR2(7) NULL,
Text_Color VARCHAR2(7) NULL,
Fog VARCHAR2(8) NULL,
VRML_File VARCHAR2(128) NULL,
primary key (ID)
);
create unique index C_NAK ON Club(Name_To_Lower);
create index C_KK1 ON Club(Keyword_1_To_Lower);
create index C_KK2 ON Club(Keyword_2_To_Lower);
create index C_KK3 ON Club(Keyword_3_To_Lower);
create index C_CDA ON Club(Creation_Date);
create index C_ACT ON Club(Activity);
create index C_CNT ON Club(Member_Count);
create index C_PID ON Club(Related_Place);
create index C_CLW ON Club(Member_Count_Last_Week);

create table Club_Member
(
ID VARCHAR2(26) NOT NULL,
Status VARCHAR2(1) NULL,
Nickname VARCHAR2(16) NULL,
Last_Visit_Date VARCHAR2(14) NULL,
Join_Date VARCHAR2(14) NULL,
primary key (ID)
);
create index C_STT ON Club_Member(Status);
create index C_NNM ON Club_Member(Nickname);
create index C_LVD ON Club_Member(Last_Visit_Date);

create table Information
(
ID VARCHAR2(64) NOT NULL,
Owner VARCHAR2(8) NULL,
Nickname VARCHAR2(16) NULL,
Name VARCHAR2(32) NULL,
Description1 VARCHAR2(1536) NULL,
Html_Allowed VARCHAR2(3) NULL,
Last_Access_Date VARCHAR2(14) NULL,
Start_Date VARCHAR2(14) NULL,
End_Date VARCHAR2(14) NULL,
URL VARCHAR2(64) NULL,
Location_Id VARCHAR2(16) NULL,
Location_Datatype VARCHAR2(2) NULL,
Place VARCHAR2(64) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(16) NULL,
primary key (ID)
);

create table Voting
(
ID VARCHAR2(34) NOT NULL,
Place VARCHAR2(17) NULL,
RID VARCHAR2(8) NULL,
Topic VARCHAR2(128) NULL,
Choice VARCHAR2(16) NULL,
Nickname VARCHAR2(16) NULL,
Type VARCHAR2(1) NULL,
Iniator_ID VARCHAR2(8) NULL,
Start_Date VARCHAR2(8) NULL,
End_Date VARCHAR2(8) NULL,
Deletion_Date VARCHAR2(8) NULL,
Member_Count VARCHAR2(8) NULL,
Rate_Count VARCHAR2(8) NULL,
Secret VARCHAR2(1) NULL,
Weighted_Vote VARCHAR2(1) NULL,
Description1 VARCHAR2(1536) NULL,
primary key (ID)
);
create index V_PLC ON Voting(Place);
create index V_RID ON Voting(RID);

create table Group_Rights
(
ID VARCHAR2(8) NOT NULL,
Nickname VARCHAR2(16) NULL,
Nickname_To_Lower VARCHAR2(16) NOT NULL,
primary key (ID)
);
create unique index G_NNK ON Group_Rights(Nickname_To_Lower);

create table Group_Member
(
ID VARCHAR2(26) NOT NULL,
primary key (ID)
);

create table Shared_Object
(
ID VARCHAR2(32) NOT NULL,
Category VARCHAR2(9) NULL,
Zone VARCHAR2(17) NULL,
Name VARCHAR2(32) NULL,
Owner VARCHAR2(16) NULL,
Buyer VARCHAR2(16) NULL,
Member_Count VARCHAR2(8) NULL,
Action_Count VARCHAR2(8) NULL,
Class VARCHAR2(1) NULL,
Creator VARCHAR2(16) NULL,
Hidden VARCHAR2(1) NULL,
Image VARCHAR2(128) NULL,
Position VARCHAR2(64) NULL,
Trade_Price VARCHAR2(8) NULL,
Texture_File VARCHAR2(128) NULL,
VRML_File VARCHAR2(128) NULL,
Action_Buy VARCHAR2(32) NULL,
Action_Delete VARCHAR2(32) NULL,
Action_Display VARCHAR2(32) NULL,
Action_Drop VARCHAR2(32) NULL,
Action_Move VARCHAR2(32) NULL,
Action_Take VARCHAR2(32) NULL,
Action_000 VARCHAR2(32) NULL,
Action_001 VARCHAR2(32) NULL,
Action_002 VARCHAR2(32) NULL,
Action_003 VARCHAR2(32) NULL,
Action_004 VARCHAR2(32) NULL,
Action_005 VARCHAR2(32) NULL,
Action_006 VARCHAR2(32) NULL,
Action_007 VARCHAR2(32) NULL,
Action_008 VARCHAR2(32) NULL,
Action_009 VARCHAR2(32) NULL,
Action_3D0 VARCHAR2(32) NULL,
Action_3D1 VARCHAR2(32) NULL,
Action_3D2 VARCHAR2(32) NULL,
Action_3D3 VARCHAR2(32) NULL,
Action_3D4 VARCHAR2(32) NULL,
Description1 VARCHAR2(1536) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(16) NULL,
primary key (ID)
);
create index SO_CAT ON Shared_Object (Category);
create index SO_ZON ON Shared_Object (Zone);
create index SO_NAM ON Shared_Object (Name);
create index SO_OWN ON Shared_Object (Owner);

create table Ticket
(
ID VARCHAR2(16) NOT NULL,
Owner VARCHAR2(8) NULL,
Creation_Date VARCHAR2(14) NULL,
Cookie VARCHAR2(256) NULL,
primary key (ID)
);
create index T_CDA ON Ticket (Creation_Date);
create index T_OWN ON Ticket (Owner);

create table Members_Online
(
ID VARCHAR2(8) NOT NULL,
Nickname VARCHAR2(16) NULL,
Place VARCHAR2(16) NULL,
Name VARCHAR2(32) NULL,
Last_Access_Date VARCHAR2(14) NULL,
DataType VARCHAR2(6) NULL,
Hidden VARCHAR2(1) NULL,
Owner VARCHAR2(8) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(16) NULL,
primary key (ID)
);
create index MO_NNM ON Members_Online(Nickname);
create index MO_PLC ON Members_Online(Place);
create index MO_LAD ON Members_Online(Last_Access_Date);

create table Place_Online
(
ID VARCHAR(32) NOT NULL,
Member_Count VARCHAR(8) NULL,
Total_Online_Count VARCHAR(8) NULL,
DataType VARCHAR(6) NULL,
Name VARCHAR(32) NULL,
Owner VARCHAR(8) NULL,
Owner_Role VARCHAR(2) NULL,
Assist_Role VARCHAR(2) NULL,
Owner_Roles VARCHAR(32) NULL,
Assistant_ID1 VARCHAR(8) NULL,
Assistant_ID2 VARCHAR(8) NULL,
Assistant_ID3 VARCHAR(8) NULL,
Assistant_ID4 VARCHAR(8) NULL,
Assistant_ID5 VARCHAR(8) NULL,
Assistant_ID6 VARCHAR(8) NULL,
Assistant_ID7 VARCHAR(8) NULL,
Assistant_ID8 VARCHAR(8) NULL,
Read_Roles VARCHAR(32) NULL,
Read_ID1 VARCHAR(8) NULL,
Read_ID2 VARCHAR(8) NULL,
Read_ID3 VARCHAR(8) NULL,
Read_ID4 VARCHAR(8) NULL,
Read_ID5 VARCHAR(8) NULL,
Read_ID6 VARCHAR(8) NULL,
Read_ID7 VARCHAR(8) NULL,
Read_ID8 VARCHAR(8) NULL,
Write_Roles VARCHAR(32) NULL,
Write_ID1 VARCHAR(8) NULL,
Write_ID2 VARCHAR(8) NULL,
Write_ID3 VARCHAR(8) NULL,
Write_ID4 VARCHAR(8) NULL,
Write_ID5 VARCHAR(8) NULL,
Write_ID6 VARCHAR(8) NULL,
Write_ID7 VARCHAR(8) NULL,
Write_ID8 VARCHAR(8) NULL,
Change_Roles VARCHAR(32) NULL,
Change_Rights_ID1 VARCHAR(8) NULL,
Change_Rights_ID2 VARCHAR(8) NULL,
Change_Rights_ID3 VARCHAR(8) NULL,
Change_Rights_ID4 VARCHAR(8) NULL,
Change_Rights_ID5 VARCHAR(8) NULL,
Change_Rights_ID6 VARCHAR(8) NULL,
Change_Rights_ID7 VARCHAR(8) NULL,
Change_Rights_ID8 VARCHAR(8) NULL,
Parent_Table VARCHAR(2) NULL,
Parent_Keytype VARCHAR(3) NULL,
Parent_Key VARCHAR(16) NULL,
primary key (ID)
);
create index PO_CNT ON Place_Online(Member_Count);

create table Home
(
ID VARCHAR2(32) NOT NULL,
Owner VARCHAR2(8) NULL,
Name VARCHAR2(32) NULL,
Object_Number VARCHAR2(8) NULL,
Maximum_Objects VARCHAR2(8) NULL,
Maximum_Children VARCHAR2(8) NULL,
Email1 VARCHAR(1) NULL,
Chat_Type VARCHAR(16) NULL,
Description1 VARCHAR2(1536) NULL,
Advertising_Url VARCHAR2(1536) NULL,
Advertising_Image VARCHAR2(16) NULL,
Link0 VARCHAR2(256) NULL,
Link0_Description VARCHAR2(256) NULL,
Link1 VARCHAR2(256) NULL,
Link1_Description VARCHAR2(256) NULL,
Link2 VARCHAR2(256) NULL,
Link2_Description VARCHAR2(256) NULL,
Link3 VARCHAR2(256) NULL,
Link3_Description VARCHAR2(256) NULL,
Link4 VARCHAR2(256) NULL,
Link4_Description VARCHAR2(256) NULL,
Image VARCHAR2(64) NULL,
Home_Property VARCHAR2(20) NULL,
Status VARCHAR2(1) NULL,
VRML_File VARCHAR2(64) NULL,
Avatar_Image VARCHAR2(64) NULL,
Maximum_Homes VARCHAR2(4) NULL,
Position VARCHAR2(64) NULL,
Price VARCHAR2(8) NULL,
Cost VARCHAR2(8) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(16) NULL,
primary key (ID)
);

create table Call_Center
(
ID VARCHAR2(8) NOT NULL,
Topic VARCHAR2(64) NULL,
Description1 VARCHAR2(1536) NULL,
Status VARCHAR2(1) NULL,
Locked VARCHAR2(1) NULL,
Priority VARCHAR2(8) NULL,
Consultant VARCHAR2(16) NULL,
Description VARCHAR2(1536) NULL,
Creation_Date VARCHAR2(14) NULL,
Start_Date VARCHAR2(14) NULL,
End_Date VARCHAR2(14) NULL,
Customer_ID VARCHAR2(8) NULL,
Customer_Nickname VARCHAR2(16) NULL,
Place VARCHAR2(256) NULL,
Location_Datatype VARCHAR2(2) NULL,
Location_Id VARCHAR2(32) NULL,
Adress VARCHAR2(1536) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(16) NULL,
primary key (ID)
);
create index CC_TOP ON Call_Center (Topic);
create index CC_STT ON Call_Center (Status);
create index CC_CON ON Call_Center (Consultant);
create index CC_CDA ON Call_Center (Creation_Date);

create table Avatar
(
ID VARCHAR2(8) NOT NULL,
Sortorder VARCHAR2(16) NULL,
Name VARCHAR2(32) NULL,
Avatar_Image VARCHAR2(128) NULL,
Avatar_Url VARCHAR2(128) NULL,
Description1 VARCHAR2(1536) NULL,
Owner VARCHAR2(8) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(16) NULL,
primary key (ID)
);
create index A_ORD ON Avatar (Sortorder);

create table MessageBoard
(
ID VARCHAR(25) NOT NULL,
Key_Last_Access_Date VARCHAR(32) NULL,
Board_Last_Access_Date VARCHAR(24) NULL,
Key_Owner_Nickname VARCHAR(34) NULL,
Board_Owner_Nickname VARCHAR(26) NULL,
Key_Size VARCHAR(26) NULL,
Key_Rate_Count VARCHAR(26) NULL,
Key_Parent_Creation_Date VARCHAR(40) NULL,
Key_Creation_Date VARCHAR(32) NULL,
Key_Subject VARCHAR(50) NULL,
Creation_Date VARCHAR(14) NULL,
Last_Access_Date VARCHAR(14) NULL,
Size_Info VARCHAR(8) NULL,
Owner_Nickname VARCHAR(16) NULL,
Rate_Count VARCHAR(8) NULL,
Member_Count VARCHAR(8) NULL,
Subject VARCHAR(255) NULL,
Url VARCHAR(128) NULL,
Description1 VARCHAR2(1536) NULL,
Depth VARCHAR(8) NULL,
Keep_Messages_Selector VARCHAR(1) NULL,
Keep_Messages_Count VARCHAR(8) NULL,
Owner VARCHAR2(8) NULL,
Owner_Role VARCHAR2(2) NULL,
Assist_Role VARCHAR2(2) NULL,
Owner_Roles VARCHAR2(32) NULL,
Assistant_ID1 VARCHAR2(8) NULL,
Assistant_ID2 VARCHAR2(8) NULL,
Assistant_ID3 VARCHAR2(8) NULL,
Assistant_ID4 VARCHAR2(8) NULL,
Assistant_ID5 VARCHAR2(8) NULL,
Assistant_ID6 VARCHAR2(8) NULL,
Assistant_ID7 VARCHAR2(8) NULL,
Assistant_ID8 VARCHAR2(8) NULL,
Read_Roles VARCHAR2(32) NULL,
Read_ID1 VARCHAR2(8) NULL,
Read_ID2 VARCHAR2(8) NULL,
Read_ID3 VARCHAR2(8) NULL,
Read_ID4 VARCHAR2(8) NULL,
Read_ID5 VARCHAR2(8) NULL,
Read_ID6 VARCHAR2(8) NULL,
Read_ID7 VARCHAR2(8) NULL,
Read_ID8 VARCHAR2(8) NULL,
Write_Roles VARCHAR2(32) NULL,
Write_ID1 VARCHAR2(8) NULL,
Write_ID2 VARCHAR2(8) NULL,
Write_ID3 VARCHAR2(8) NULL,
Write_ID4 VARCHAR2(8) NULL,
Write_ID5 VARCHAR2(8) NULL,
Write_ID6 VARCHAR2(8) NULL,
Write_ID7 VARCHAR2(8) NULL,
Write_ID8 VARCHAR2(8) NULL,
Change_Roles VARCHAR2(32) NULL,
Change_Rights_ID1 VARCHAR2(8) NULL,
Change_Rights_ID2 VARCHAR2(8) NULL,
Change_Rights_ID3 VARCHAR2(8) NULL,
Change_Rights_ID4 VARCHAR2(8) NULL,
Change_Rights_ID5 VARCHAR2(8) NULL,
Change_Rights_ID6 VARCHAR2(8) NULL,
Change_Rights_ID7 VARCHAR2(8) NULL,
Change_Rights_ID8 VARCHAR2(8) NULL,
Parent_Table VARCHAR2(2) NULL,
Parent_Keytype VARCHAR2(3) NULL,
Parent_Key VARCHAR2(25) NULL,
primary key (ID)
);
create index ID_LAD ON MessageBoard (Key_Last_Access_Date);
create index BID_LAD ON MessageBoard (Board_Last_Access_Date);
create index ID_ONN ON MessageBoard (Key_Owner_Nickname);
create index BID_ONN ON MessageBoard (Board_Owner_Nickname);
create index ID_SIZ ON MessageBoard (Key_Size);
create index ID_RCT ON MessageBoard (Key_Rate_Count);
create index PID_CDA ON MessageBoard (Key_Parent_Creation_Date);
create index ID_CDA ON MessageBoard (Key_Creation_Date);
create index ID_SUB ON MessageBoard (Key_Subject);

orserver.sql

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: A Avatar
B Block
C Community
CL Club
CC Call_Center
CM Club_Member
G Group_Rights
GM Group_Member
H Home
I Information
M Member
MB MessageBoard
MD Member_Data
MO Members_Online
N Neighborhood
O Object
P Property
PO Place_Online
R Role
RM Role_Member
S Exp_Level
SM Exp_Level_Member
SO Shared_Object
T Ticket
U Multimedia
V Voting
VI Visitor

ACT Activity
ADU Advertising_Url
ADI Advertising_Image
ADR Adress
AGE Age
AIM Instant_Message_Auto_Popup
ARF Assembly_Room_Filename
ARP Assembly_Room_Picture
ASR Assist_Role
AS1 Assistant_ID1
AS2 Assistant_ID2
AS3 Assistant_ID3
AS4 Assistant_ID4
AS5 Assistant_ID5
AS6 Assistant_ID6
AS7 Assistant_ID7
AS8 Assistant_ID8
AVI Avatar_Image
AVU Avatar_Url
AVC Avatar_Checked
AV0 Avatar_Desc0
AV1 Avatar_Desc1
AV2 Avatar_Desc2
AV3 Avatar_Desc3
AV4 Avatar_Desc4
aBUY Action_Buy
aDEL Action_Delete
aDIS Action_Display
aDRO Action_Drop
aMOV Action_Move
aTAK Action_Take
a000 Action_000
a001 Action_001
a002 Action_002
a003 Action_003
a004 Action_004
a005 Action_005
a006 Action_006
a007 Action_007
a008 Action_008
a009 Action_009
a3D0 Action_3D0
a3D1 Action_3D1
a3D2 Action_3D2
a3D3 Action_3D3
a3D4 Action_3D4

BAS Blaxxun_Avatar_Studio
BGI Background_Image
BIDLAD Board_Last_Access_Date
BIDONN Board_Owner_Nickname
BNL Newsletter
BUY Buyer
BU0 Buddy_Name_0
BU1 Buddy_Name_1
BU2 Buddy_Name_2
BU3 Buddy_Name_3
BU4 Buddy_Name_4
BU5 Buddy_Name_5
BU6 Buddy_Name_6
BU7 Buddy_Name_7
BU8 Buddy_Name_8
BU9 Buddy_Name_9
BU10 Buddy_Name_10
BU11 Buddy_Name_11
BU12 Buddy_Name_12
BU13 Buddy_Name_13
BU14 Buddy_Name_14
BU15 Buddy_Name_15

CAC Cache_Root
CVE Cache_Version
CAT Category
CDA Creation_Date
CEC Ceiling
CHO Choice
CHT Chat_Type
CI1 Change_Rights_ID1
CI2 Change_Rights_ID2
CI3 Change_Rights_ID3
CI4 Change_Rights_ID4
CI5 Change_Rights_ID5
CI6 Change_Rights_ID6
CI7 Change_Rights_ID7
CI8 Change_Rights_ID8
CID Customer_ID
CKI Kind
CK1 Keyword_1
CK2 Keyword_2
CK3 Keyword_3
CLA ALink_Color
CLB Background_Color
CLF Club_Image_Filename
CLL Link_Color
CLP Club_Image
CLS Class
CLT Text_Color
CLV VLink_Color
CLW Member_Count_Last_Week
CMX Maximum_Children
CNK Customer_Nickname
CNT Member_Count
CON Consultant
COO Cookie
CRE Creator
CRO Change_Roles
CST Cost

DAT Data
DDA Deletion_Date
DEP Depth
DES Description
DTY DataType

ECT Exclusion_Counter
EDA End_Date
EMI Email3
EML Email1
EMK Email2
EXD Exclusion_Date
EXP Experience
EXT Exclusion_Reason
EXM Excluding_Member

FACE Font_Face
FIL Filename
FLC Floor_Color
FNM First_Name
FOG Fog
FPA Forgot_Pwd_Answer
FPQ Forgot_Pwd_Question
FRE Free_Homes

GID Group_ID
GF1 Gallery_Filename_1
GF2 Gallery_Filename_1
GF3 Gallery_Filename_3
GP1 Gallery_Picture_1
GP2 Gallery_Picture_2
GP3 Gallery_Picture_3

HID Hidden
HLP Help
HOM Home_Property
HPG Home_Page
HTM Html_Allowed

IC2 Index_2D_Icon
IC3 Index_3D_Icon
IDCDA Key_Creation_Date
IDLAD Key_Last_Access_Date
IDONN Key_Owner_Nickname
IDRCT Key_Rate_Count
IDSIZ Key_Size
IDSUB Key_Subject
IEP Income_Experience
IID Iniator_ID
IMD Immigration_Date
IMG Image
IMS Instant_Message_Status
IM1 Immigration_Info
IM2 Index_Image
INC Income_Money
INT Interests

JND Join_Date

KK1 Keyword_1_To_Lower
KK2 Keyword_2_To_Lower
KK3 Keyword_3_To_Lower
KMS Keep_Messages_Selector
KMC Keep_Messages_Count

LAD Last_Access_Date
LAE Last_Access_Exp
LAM Last_Access_Money
LDT Location_Datatype
LD0 Link0_Description
LD1 Link1_Description
LD2 Link2_Description
LD3 Link3_Description
LD4 Link4_Description
LD5 Link5_Description
LID Location_Id
LIP Last_Used_IP
LL0 Link0
LL1 Link1
LL2 Link2
LL3 Link3
LL4 Link4
LL5 Link5
LNG Language
LNM Last_Name
LOC Locked
LVD Last_Visit_Date

MAD MemberAdmin
MHO Maximum_Homes
MOB Maximum_Objects
MRF Meeting_Room_Filename
MRP Meeting_Room_Picture
MYR My_Role

NAC Action_Count
NAM Name
NAK Name_To_Lower
NG0 NewsTickerTarget0
NG1 NewsTickerTarget1
NG2 NewsTickerTarget2
NG3 NewsTickerTarget3
NG4 NewsTickerTarget4
NG5 NewsTickerTarget5
NG6 NewsTickerTarget6
NG7 NewsTickerTarget7
NG8 NewsTickerTarget8
NG9 NewsTickerTarget9
NNK Nickname_To_Lower
NNM Nickname
NNO NewsTickerNumber
NOB Object_Number
MON Money
NT0 NewsTickerText0
NU0 NewsTickerURL0
NT1 NewsTickerText1
NU1 NewsTickerURL1
NT2 NewsTickerText2
NU2 NewsTickerURL2
NT3 NewsTickerText3
NU3 NewsTickerURL3
NT4 NewsTickerText4
NU4 NewsTickerURL4
NT5 NewsTickerText5
NU5 NewsTickerURL5
NT6 NewsTickerText6
NU6 NewsTickerURL6
NT7 NewsTickerText7
NU7 NewsTickerURL7
NT8 NewsTickerText8
NU8 NewsTickerURL8
NT9 NewsTickerText9
NU9 NewsTickerURL9
NOB Object_Number

ONN Owner_Nickname
ORD Sortorder
ORO Owner_Roles
OWN Owner
OWR Owner_Role

PDT Parent_Table
PKT Parent_Keytype
PKE Parent_Key
PI1 Picture_1
PI2 Picture_2
PI3 Picture_3
PI4 Picture_4
PI5 Picture_5
PI6 Picture_6
PI7 Picture_7
PI8 Picture_8
PID Related_Place
PIDCDA Key_Parent_Creation_Date
PLC Place
plc Place
PLG Plugin
POS Position
PRC Price
PR1 Profile_1
PR2 Profile_2
PRI Priority
PU2 PU2
PWD Password

RCT Rate_Count
REF Referenced_Member
RGK Immigration_Key
ROL Role
RRO Read_Roles
RID RID
RI1 Read_ID1
RI2 Read_ID2
RI3 Read_ID3
RI4 Read_ID4
RI5 Read_ID5
RI6 Read_ID6
RI7 Read_ID7
RI8 Read_ID8
RUL Rules

SDA Start_Date
SEC Secret
SIZ Size_Info
SPW Stage_Password
STA Status_Assembly_Room_Picture
STC Status_Club_Image
STM Status_Meeting_Room_Picture
STT Status
ST1 Status_Gallery_Picture_1
ST2 Status_Gallery_Picture_2
ST3 Status_Gallery_Picture_3
ST4 Status_Gallery_Picture_4
ST5 Status_Gallery_Picture_5
ST6 Status_Gallery_Picture_6
ST7 Status_Gallery_Picture_7
ST8 Status_Gallery_Picture_8
SUB Subject
SYM Symbol

TCN Total_Club_Count
TOC Total_Online_Count
TOP Topic
TPR Trade_Price
TXF Texture_File
TXT Description1
TX2 Description2
TYP Type

UDD Statistc_Update_Date
URL Url

VWW Weighted_Vote

WAC Wall_Color
WI1 Write_ID1
WI2 Write_ID2
WI3 Write_ID3
WI4 Write_ID4
WI5 Write_ID5
WI6 Write_ID6
WI7 Write_ID7
WI8 Write_ID8
WRL VRML_File
WRO Write_Roles
WR3 Index_World

ZON Zone

2IN X2IN
2IF X2IF
2IP X2IP
2IL X2IL
2IC X2IC
2DP X2DP
2DL X2DL
2DC X2DC
3IP X3IP
3IL X3IL
3IC X3IC

orserver.cfg

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: # DB U X ID ###-Member-###
DB I M ID 00000000 NNM admin NNK admin EMK admin[@]YourCompany.com EML admin[@]yourcompany.com PWD admin IMD 19990101120000 LAD 19990101120000 HOM 0101040601030204 CHT "" MON 00000500 EXP 00000050 ROL c0000000000002000000000000000000
DB I M ID 00000001 NNM Mayor NNK mayor EMK mayor[@]YourCompany.com EML mayor[@]yourcompany.com PWD aa IMD 19990501120000 LAD 19990501120000 HOM 0101040601030303 CHT "" MON 00000500 EXP 00000050 ROL e0000000000000000000000000000000
DB I M ID 00000002 NNM CL NNK cl EMK colonyleader[@]YourCompany.com EML colonyleader[@]yourcompany.com PWD aa IMD 19990501110000 LAD 19990501110000 HOM 0101040601030505 CHT "" MON 00000300 EXP 00000030 ROL c0000800000000000000000000000000
DB I M ID 00000003 NNM NL NNK nl EMK nleader[@]YourCompany.com EML nleader[@]yourcompany.com PWD aa IMD 19990501110000 LAD 19990501110000 HOM 0101040601030207 CHT "" MON 00000300 EXP 00000030 ROL c0000800000000000000000000000000
DB I M ID 00000004 NNM BL NNK bl EMK blockleader[@]YourCompany.com EML blockleader[@]yourcompany.com PWD aa IMD 19990501110000 LAD 19990501110000 HOM 0101040601030403 CHT "" MON 00000300 EXP 00000030 ROL c0000800000000000000000000000000
DB I M ID 00000005 NNM citizen NNK citizen EMK citizen[@]YourCompany.com EML citizen[@]yourcompany.com PWD aa IMD 19990501100000 LAD 19990501100000 HOM "" CHT "s" MON 00000100 EXP 00000010 ROL c0000000000000000000000000000000
# DB U X ID ###-RoleMember-###
DB I RM ID 020000000000000000Omayor NNM Mayor NNK mayor
DB I RM ID 100101000000000000Ccl NNM CL NNK cl
DB I RM ID 120101040300000000Nnl NNM NL NNK nl
DB I RM ID 120101040600000000Nnl NNM NL NNK nl
DB I RM ID 120101050800000000Nnl NNM NL NNK nl
DB I RM ID 140101040601030000Bbl NNM BL NNK bl
DB I RM ID 140101040603040000Bnl NNM NL NNK nl
DB I RM ID 140101040604070000Bnl NNM NL NNK nl
DB I RM ID 360000000000000006Oadmin NNM admin NNK admin
# DB U X ID ###-Roles-###
DB I R ID 00 NAM "Visitor" EML "" INC 00000000 IEP 00000000
DB I R ID 01 NAM "Member" EML "Member" INC 00000000 IEP 00000000
DB I R ID 02 NAM "City Mayor" EML "CityMayor" INC 000000e6 IEP 00000017 TYP 1
DB I R ID 03 NAM "City Council" EML "CityCouncil" INC 000000e6 IEP 00000017 TYP 1
DB I R ID 04 NAM "City Security Chief" EML "CitySecurityChief" INC 000000c8 IEP 00000014 TYP 1
DB I R ID 05 NAM "City Security Deputy" EML "CitySecurityDeputy" INC 000000c8 IEP 00000014 TYP 1
DB I R ID 06 NAM "City Planning Chief" EML "CityPlanningChief" INC 000000c8 IEP 00000014 TYP 1
DB I R ID 07 NAM "City Architect" EML "CityArchitect" INC 000000c8 IEP 00000014 TYP 1
DB I R ID 08 NAM "City Artist" EML "CityArtist" INC 000000c8 IEP 00000014 TYP 1
DB I R ID 09 NAM "Magazine Editor" EML "MagazineEditor" INC 000000c8 IEP 00000014 TYP 1
DB I R ID 0a NAM "Senior City Guide" EML "SeniorCityGuide" INC 000000c8 IEP 00000014 TYP 1
DB I R ID 0c NAM "Chief of Clubs" EML "ChiefOfClubs" INC 000000c8 IEP 00000014
DB I R ID 10 NAM "District Leader" EML "DistrictLeader" INC 000000e6 IEP 00000017
DB I R ID 11 NAM "District Deputy" EML "DistrictDeputy" INC 00000064 IEP 0000000a
DB I R ID 12 NAM "Neighborhood Leader" EML "NeighborhoodLeader" INC 000000c8 IEP 00000014
DB I R ID 13 NAM "Neighborhood Deputy" EML "NeighborhoodDeputy" INC 00000064 IEP 0000000a
DB I R ID 14 NAM "Block Leader" EML "BlockLeader" INC 000000c8 IEP 00000014
DB I R ID 15 NAM "Block Deputy" EML "BlockDeputy" INC 00000064 IEP 0000000a
DB I R ID 1c NAM "Deputy of Clubs" EML "DeputyClubs" INC 00000064 IEP 0000000a
DB I R ID 21 NAM "City Security" EML "CitySecurity" INC 000000c8 IEP 00000014 TYP 1
DB I R ID 22 NAM "City Guide" EML "CityGuide" INC 000000c8 IEP 00000014 TYP 1
DB I R ID 23 NAM "World Builder" EML "WorldBuilder" INC 00000064 IEP 0000000a TYP 1
DB I R ID 24 NAM "Magazine Writer" EML "MagazineWriter" INC 00000064 IEP 0000000a TYP 1
DB I R ID 30 NAM "Chief News" EML "ChiefNews" INC 000000c8 IEP 00000014
DB I R ID 31 NAM "Deputy News" EML "DeputyNews" INC 00000064 IEP 0000000a
DB I R ID 32 NAM "Chief Citizen" EML "ChiefCitizen" INC 000000c8 IEP 00000014
DB I R ID 33 NAM "Deputy Citizen" EML "DeputyCitizen" INC 00000064 IEP 0000000a
DB I R ID 34 NAM "Chief Employment" EML "ChiefEmployment" INC 000000c8 IEP 00000014
DB I R ID 35 NAM "Deputy Employment" EML "DeputyEmployments" INC 00000064 IEP 0000000a
DB I R ID 36 NAM "Mall Manager" EML "MallManager" INC 000000c8 IEP 00000014
DB I R ID 37 NAM "Mall Deputy" EML "MallDeputy" INC 00000064 IEP 0000000a
# DB U X ID ###-Status-###
DB I S ID 00 NAM "Neophyte" EXP 00000000
DB I S ID 01 NAM "Citizen" EXP 00000064
DB I S ID 02 NAM "Elder" EXP 000000c8
DB I S ID 10 NAM "Leader" EXP 000001f4
DB I S ID 18 NAM "Expert" EXP 000003e8
DB I S ID 20 NAM "Master" EXP 000007d0
DB I S ID 28 NAM "Wise" EXP 00001388
# DB U X ID ###-Communal Places-###
DB I O ID 0000000000000000 NAM "MyVirtualCity" CTN "City" CNM "District" ENM "Neighborhood" BNM "Block" PNM "House" MON 000186a0 OWN 00000000 CCA 1 CCB 1 CCC 2 CCM 1 CCN 1
DB I O ID 0000000000000001 NAM "City Plaza" MON 00002710 OWR 02 ASR 03 CRO 30000000000000000000000000000000 NNO 0
DB I O ID 0000000000000002 NAM "News Center" MON 00002710 OWR 30 ASR 31 CRO 30000000000000000000000000000000 NNO 0
DB I O ID 0000000000000003 NAM "Citizens Directory" MON 00002710 OWR 32 ASR 33 CRO 30000000000000000000000000000000 NNO 0
DB I O ID 0000000000000004 NAM "City Employment Office" MON 00002710 OWR 34 ASR 35 CRO 30000000000000000000000000000000 NNO 0
DB I O ID 0000000000010004 NAM "City Employment - Offers" CRO 30000000000000000000000000000000
DB I O ID 0000000000020004 NAM "City Employment - Requests" CRO 30000000000000000000000000000000
DB I O ID 0000000000000005 NAM "Club Directory" MON 00002710 OWR 0c ASR 1c CRO 30000000000000000000000000000000 NNO 0
DB I O ID 0000000000000006 NAM "Shopping Mall" MON 00002710 OWR 36 ASR 37 CRO 30000000000000000000000000000000 NNO 0 OWN 00000000
# DB U X ID ###-Communal Places-Information###
DB U O ID 0000000000000001 TXT "<H3 align=center>Welcome to the City Plaza.</H3><p>The City Plaza is the heart of the Community, from here you can visit our other places, wander around the Plaza and chat with others. The Plaza is open for visitors and residents of the City. From here, those who have immigrated can also access the various colonies in the City and choose a personal home there.</p>"
DB U O ID 0000000000000002 TXT "<H3 align=center>Welcome to the News Center.</H3><p>What is happening in town, what is the future planning, what are the current activities. From here you can also access the magazine for hot tips on how you can participate in the creation of virtual worlds, objects and more.</p>"
DB U O ID 0000000000000003 TXT "<H3 align=center>Welcome to the Citizens Directory.</H3>"
DB U O ID 0000000000000004 TXT "<H3 align=center>Welcome to the City Employment Office.</H3><p>Looking for a job? - Offering a job?<br>Come on - here you find everything you need to know ...</p>" TX2 "<div align=center><font color=yellow><h3>Job Statistics</h3><ul><li>Job <b>Offers</b>: 130<li>Job <b>Requests</b>: 215</ul><br><small>Last change: 16.12.98</small></font></div>"
DB U O ID 0000000000000005 TXT "<H3 align=center>Welcome to the Club Directory.</H3> <p>Create your own club or join your favorite club!</p> Anyone can join a club but you must have >500 experience points in order to create one. An owner can only create 3 clubs.</p> Please read messages on the Message Board as it is our link to club members. It is updated daily and we notify club owners and assistants of problems etc on this board. </p> Also the Clubs Homepage has help information, links to club homepages etc so check that out as it is updated regularly."
DB U O ID 0000000000000006 TXT "<H3 align=center>Welcome to the Shopping Mall.</H3> <p>Buy and sell furniture, plants and more..."
# DB U X ID ###-Communal Places-Information###
DB I I ID m0000000000000001 NAM "Feedback"
DB I I ID c0000000000000001 NAM "City Calendar"
DB I I ID h0000000000000001 NAM "City Plaza Chat"
DB I I ID i0000000000000002 NAM "News Center Inbox"
DB I I ID m0000000000000002 NAM "News Center Messages"
DB I I ID h0000000000000002 NAM "News Center Chat"
DB I I ID n0000000000000002 NAM "News Magazine"
DB I I ID l0000000000000002 NAM "News Links"
DB I I ID i0000000000000004 NAM "Employment Office Inbox"
DB I I ID m0000000000000004 NAM "Employment Office Messages"
DB I I ID h0000000000000004 NAM "Employment Office Chat"
DB I I ID m0000000000010004 NAM "Job Offers" ORO 00000000300000000000000000000000
DB I I ID m0000000000020004 NAM "Job Requests" ORO 00000000300000000000000000000000
DB I I ID i000000000002000c NAM "Job Requests" ORO 00000000300000000000000000000000 RRO 40000000000000000000000000000000 WRO 40000000000000000000000000000000
DB I I ID i0000000000000005 NAM "Club Directory Inbox"
DB I I ID m0000000000000005 NAM "Club Directory Messages"
DB I I ID h0000000000000005 NAM "Club Directory Chat"
DB I I ID i0000000000000006 NAM "Shopping Mall Inbox"
DB I I ID m0000000000000006 NAM "Shopping Mall Messages"
DB I I ID h0000000000000006 NAM "Shopping Mall Chat"
# Shared Objects: Stores
DB I O ID 0000000000000601
DB U O ID 0000000000000601 NAM "Store"
DB U O ID 0000000000000601 PDT O PKT ID PKE 0000000000000006
DB I O ID 00000000000006ff
DB U O ID 00000000000006ff NAM "Storage Hall"
DB U O ID 00000000000006ff PDT O PKT ID PKE 0000000000000006 MOB 000000ff
# Shared Objects: Categories
DB I SO ID c00000001
DB U SO ID c00000001 NAM Palm
DB U SO ID c00000001 WRL /commserv/community/objects/pflanzen/palme.wrl
DB U SO ID c00000001 IMG /commserv/community/objects/thumbnails/pflanzen/palme1s.jpg
DB U SO ID c00000001 aDEL Destroy aBUY Buy aTAK Take
DB U SO ID c00000001 aDRO Drop aMOV Move aDIS Display
DB I SO ID c00000002
DB U SO ID c00000002 NAM "Candle Lights"
DB U SO ID c00000002 WRL /commserv/community/objects/leuchten/kandi.wrl
DB U SO ID c00000002 IMG /commserv/community/objects/thumbnails/leuchten/kandi.jpg
DB U SO ID c00000002 aDEL Destroy aBUY Buy aTAK Take
DB U SO ID c00000002 aDRO Drop aMOV Move aDIS Display
DB I SO ID c00000003
DB U SO ID c00000003 NAM "Couch"
DB U SO ID c00000003 WRL /commserv/community/objects/sitzmoebel/couch1.wrl
DB U SO ID c00000003 IMG /commserv/community/objects/thumbnails/sitzmoebel/couch1.jpg
DB U SO ID c00000003 aDEL Destroy aBUY Buy aTAK Take
DB U SO ID c00000003 aDRO Drop aMOV Move aDIS Display
# Shared Objects: Objects
DB I SO ID o00000001
DB U SO ID o00000001 ZON p0000000000000601 POS -3.31,1.7,-2.515,,1,,0 CNT 500 TPR 20
DB U SO ID o00000001 CAT c00000001
DB I SO ID o00000002
DB U SO ID o00000002 ZON p0000000000000601 POS 0,1.75,-6,,1,,0 CNT 100 TPR 115
DB U SO ID o00000002 CAT c00000002
DB I SO ID o00000003
DB U SO ID o00000003 ZON p0000000000000601 POS -6.93,1.75,4,,1,,2.09 CNT 10 TPR 450
DB U SO ID o00000003 CAT c00000003
# DB U X ID ###-Clubs-###
DB I CL ID CL00000000000000
# DB U X ID ###-0101-Community-###
DB I C ID 0101000000000000 OWN 00000002 NAM "Science Fiction" MON 000003e8 CLB #000000 CLL #FFFF80 CLT #FFFF80 CLA #000000 BGI back.gif ADU "htt[p://w]ww.XXX.com" ADI "ad.gif" PU2 P OWR 10 ASR 11 CRO 30000000000000000000000000000000 TXT "<p>In this place you could have an encounter with your own kind but again, who knows who may be popping into those neighborhoods? E.T., Darth Vader? If you feel like living in the twilight zone and aren't worried about who you neighbor might be, this is the place to settle. Enjoy meeting friends with the same interests that you have or have discussions about your latest favorite episode!</p>"
DB I I ID m0101000000000000 NAM "Messages"
DB I I ID h0101000000000000 NAM "Chat"
# DB U X ID ###-0101-Neighborhood-###
DB I N ID 0101040300000000 OWN 00000003 NAM "UFOs" TXT "Welcome to 'UFOs'!" PU2 P IM2 001 OWR 12 ASR 13 CRO 30000000000000000000000000000000
DB I I ID m0101040300000000 NAM "Messages"
DB I I ID h0101040300000000 NAM "Chat"
DB I N ID 0101040600000000 OWN 00000003 NAM "Fantasy" TXT "Welcome to 'Fantasy'!" PU2 P IM2 000 OWR 12 ASR 13 CRO 30000000000000000000000000000000
DB I I ID m0101040600000000 NAM "Messages"
DB I I ID h0101040600000000 NAM "Chat"
DB I N ID 0101050800000000 OWN 00000003 NAM "Aliens" TXT "Welcome to 'Aliens'!" PU2 P IM2 002 OWR 12 ASR 13 CRO 30000000000000000000000000000000
DB I I ID m0101050800000000 NAM "Messages"
DB I I ID h0101050800000000 NAM "Chat"
# DB U X ID ###-0101-Block-###
DB I B ID 0101040601030000 OWN 00000004 NAM "Starwars" TXT "Welcome to 'Starwars'!" PU2 P IM2 000 IC2 000 OWR 14 ASR 15 CRO 30000000000000000000000000000000
DB I I ID m0101040601030000 NAM "Messages"
DB I I ID h0101040601030000 NAM "Chat"
DB I B ID 0101040603040000 OWN 00000003 NAM "E.T." TXT "Welcome to 'E.T.'!" PU2 P IM2 002 IC2 000 OWR 14 ASR 15 CRO 30000000000000000000000000000000
DB I I ID m0101040603040000 NAM "Messages"
DB I I ID h0101040603040000 NAM "Chat"
DB I B ID 0101040604070000 OWN 00000003 NAM "Shannara" TXT "Welcome to 'Shannara'!" PU2 P IM2 003 IC2 000 OWR 14 ASR 15 CRO 30000000000000000000000000000000
DB I I ID m0101040604070000 NAM "Messages"
DB I I ID h0101040604070000 NAM "Chat"
# DB U X ID ###-0101-Property-###
DB I P ID 0101040601030204 OWN 00000000 NAM "My Planet" TXT "Welcome to 'My Planet'!" PU2 P IM2 000 IC2 000 IC3 000 WR3 000 CRO 30000000000000000000000000000000
DB I I ID m0101040601030204 NAM "My Messages"
DB I I ID i0101040601030204 NAM "My Inbox"
DB I I ID h0101040601030204 NAM "My Chat"
# Mayor's Home
DB I P ID 0101040601030303 OWN 00000001 NAM "Mayor Office" TXT "Welcome to 'My Office'!" PU2 P IM2 000 IC2 002 IC3 001 WR3 001 CRO 30000000000000000000000000000000
DB I I ID m0101040601030303 NAM "My Messages"
DB I I ID i0101040601030303 NAM "My Inbox"
DB I I ID h0101040601030303 NAM "My Chat"
# CL's Home
DB I P ID 0101040601030505 OWN 00000002 NAM "CL's Home" TXT "Welcome to my Home!" PU2 P IM2 000 IC2 004 IC3 002 WR3 002 CRO 30000000000000000000000000000000
DB I I ID m0101040601030505 NAM "My Messages"
DB I I ID i0101040601030505 NAM "My Inbox"
DB I I ID h0101040601030505 NAM "My Chat"
# NL's Home
DB I P ID 0101040601030207 OWN 00000003 NAM "NL's Home" TXT "Welcome to my Home!" PU2 P IM2 000 IC2 003 IC3 002 WR3 002 CRO 30000000000000000000000000000000
DB I I ID m0101040601030207 NAM "My Messages"
DB I I ID i0101040601030207 NAM "My Inbox"
DB I I ID h0101040601030207 NAM "My Chat"
# BL's Home
DB I P ID 0101040601030403 OWN 00000004 NAM "BL's Home" TXT "Welcome to my Home!" PU2 P IM2 000 IC2 002 IC3 002 WR3 002 CRO 30000000000000000000000000000000
DB I I ID m0101040601030403 NAM "My Messages"
DB I I ID i0101040601030403 NAM "My Inbox"
DB I I ID h0101040601030403 NAM "My Chat"
# Free Homes
DB I P ID 0101040601030103 OWN 00000004 PU2 F CRO 30000000000000000000000000000000
DB I P ID 0101040601030104 OWN 00000004 PU2 F CRO 30000000000000000000000000000000
DB I P ID 0101040601030401 OWN 00000004 PU2 F CRO 30000000000000000000000000000000
# DB U X ID ###-0101-Multimedia-Neighborhood-###
DB I U ID I0101000000000000N 2IN 000 2IP 000001002 2DP 000001002
DB I U ID I0101000000000000N2IN000 NAM "2D Icon, No Access"
DB I U ID I0101000000000000N2IP000 NAM "2D Icon, Place, Default"
DB I U ID I0101000000000000N2IP001 NAM "2D Icon, Place"
DB I U ID I0101000000000000N2IP002 NAM "2D Icon, Place"
DB I U ID I0101000000000000N2DP000 NAM "2D Image, Place, Default"
DB I U ID I0101000000000000N2DP001 NAM "2D Image, Place"
DB I U ID I0101000000000000N2DP002 NAM "2D Image, Place"
# DB U X ID ###-0101-Multimedia-Block-###
DB I U ID I0101000000000000B 2IN 000 2IF 000 2IP 000001002003004005006 3IP 000001002 2DP 000001002003004
DB I U ID I0101000000000000B2IN000 NAM "2D Icon, No Access"
DB I U ID I0101000000000000B2IF000 NAM "2D Icon, Free"
DB I U ID I0101000000000000B2IP000 NAM "2D Icon, Place, Default" PRC 00000000 CST 00000014
DB I U ID I0101000000000000B2IP001 NAM "2D Icon, Place" PRC 00000000 CST 00000014
DB I U ID I0101000000000000B2IP002 NAM "2D Icon, Place" PRC 00000000 CST 00000014
DB I U ID I0101000000000000B2IP003 NAM "2D Icon, Place" PRC 00000000 CST 00000014
DB I U ID I0101000000000000B2IP004 NAM "2D Icon, Place" PRC 00000000 CST 00000014
DB I U ID I0101000000000000B2IP005 NAM "2D Icon, Place" PRC 00000000 CST 00000014
DB I U ID I0101000000000000B2IP006 NAM "2D Icon, Place" PRC 00000000 CST 00000014
DB I U ID I0101000000000000B3IP000 NAM "3D Icon, Place, Default" PRC 000000c8 CST 00000028
DB I U ID I0101000000000000B3IP001 NAM "3D Icon, Place" PRC 000000c8 CST 00000028
DB I U ID I0101000000000000B3IP002 NAM "3D Icon, Place" PRC 000000c8 CST 00000028
DB I U ID I0101000000000000B2DP000 NAM "2D Image, Place, Default"
DB I U ID I0101000000000000B2DP001 NAM "2D Image, Place"
DB I U ID I0101000000000000B2DP002 NAM "2D Image, Place"
DB I U ID I0101000000000000B2DP003 NAM "2D Image, Place"
DB I U ID I0101000000000000B2DP004 NAM "2D Image, Place"

initialize.dat

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: # DB U X ID ###-Member-###
DB I M ID 00000000 NNM Admin NNK admin EMK admin[@]YourCompany.com EML admin[@]yourcompany.com PWD admin FNM John LNM Admin IMD 20000101120000 LAD 20001001120000 HOM 0001000100010001 CHT "s"
DB U M ID 00000000 MON 00000500 EXP 00000050 ROL 44400000000000000000000000000000
DB I M ID 00000001 NNM Mayor NNK mayor EMK mayor[@]YourCompany.com EML mayor[@]yourcompany.com PWD mayor FNM Hank LNM Mayor IMD 20000501120000 LAD 20001001120000 HOM 0001000100010002 CHT "p"
DB U M ID 00000001 MON 00000500 EXP 00000050 ROL 50000000000000000000000000000000
DB I M ID 00000002 NNM DL NNK dl EMK districtleader[@]YourCompany.com EML districtleader[@]yourcompany.com PWD dl FNM Meg LNM DL IMD 20000501110000 LAD 20001001120000 HOM 0001000100010003 CHT "s"
DB U M ID 00000002 MON 00000300 EXP 00000030 ROL 40008000000000000000000000000000
DB I M ID 00000003 NNM NL NNK nl EMK nleader[@]YourCompany.com EML nleader[@]yourcompany.com PWD nl FNM Michelle LNM NL IMD 20000501110000 LAD 20001001120000 HOM 0001000100010004 CHT "s"
DB U M ID 00000003 MON 00000300 EXP 00000030 ROL 40000000800000000000000000000000
DB I M ID 00000004 NNM BL NNK bl EMK blockleader[@]YourCompany.com EML blockleader[@]yourcompany.com PWD bl FNM Amanda LNM BL IMD 20000501110000 LAD 20001001120000 HOM 0001000100010005 CHT "s"
DB U M ID 00000004 MON 00000300 EXP 00000030 ROL 40000000000080000000000000000000
DB I M ID 00000005 NNM Test NNK test EMK citizen[@]YourCompany.com EML citizen[@]yourcompany.com PWD test FNM Julia LNM Citizen IMD 20000501100000 LAD 20001001120000 HOM "" CHT "s"
DB U M ID 00000005 MON 00000100 EXP 00000010 ROL 40000000000000000000000000000000
DB I M ID 00000006 NNM Consultant NNK consultant EMK consultant[@]YourCompany.com EML consultant[@]yourcompany.com PWD consultant FNM Karl LNM Consultant IMD 20000501100000 LAD 20001001120000 HOM "" CHT "s"
DB U M ID 00000006 MON 00000100 EXP 00000010 ROL 40000000000000800000000000000000
DB I M ID 00000007 NNM Clubmaster NNK clubmaster EMK clubmaster[@]YourCompany.com EML clubmaster[@]yourcompany.com PWD clubmaster FNM Samanta LNM Clubmaster IMD 20000501100000 LAD 20001001120000 HOM "" CHT "s"
DB U M ID 00000007 MON 00000100 EXP 00000010 ROL 40002000000000000000000000000000

# DB U X ID ###-MemberData-###
DB I MD ID 00000000 AVI /commserv/community/dbavatars/A/a0/00/00/06/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/06/av.wrl AV0 "Admin's Special" INT "Community Administrations"
DB I MD ID 00000001 INT "administrative jobs, biking"
DB I MD ID 00000002 INT "Santana, Stephen King "
DB I MD ID 00000003 INT "Soccer, Swimming"
DB I MD ID 00000004 INT "Collecting everything"
DB I MD ID 00000005 INT "Dali, Socrates"
DB I MD ID 00000006 INT "Trading, Biking"
DB I MD ID 00000007 INT "Travel, Meeting People"

# DB U X ID ###-RoleMember-###
DB I RM ID 030000000000000000Omayor NNM Mayor NNK mayor
DB I RM ID 100001000000000000Hdl NNM DL NNK dl
DB I RM ID 200001000100000000Hnl NNM NL NNK nl
DB I RM ID 200001000200000000Hnl NNM NL NNK nl
DB I RM ID 200001000300000000Hnl NNM NL NNK nl
DB I RM ID 300001000100010000Hbl NNM BL NNK bl
DB I RM ID 050000000000000000Oadmin NNM Admin NNK admin
DB I RM ID 090000000000000000Oadmin NNM Admin NNK admin
DB I RM ID 120000000000000000Oclubmaster NNM Clubmaster NNK clubmaster
DB I RM ID 3bCL00000000000001CLmayor NNM Mayor NNK mayor
DB I RM ID 380000000000000000Oconsultant NNM Consultant NNK consultant

# DB U X ID ###-Roles-###
DB I R ID 00 NAM "Visitor" INC 00000000 IEP 00000000 TYP 1
DB I R ID 01 NAM "Member" INC 00000000 IEP 00000000 TYP 1
DB I R ID 02 NAM "Owners Only" TYP 1
# R ID 03 => ROL 10000000000000000000000000000000
DB I R ID 03 NAM "Community Mayor" INC 000000e6 IEP 00000017 TYP 1 PDT O PKT ID PKE R030000000000000
DB I O ID R030000000000000 OWN 00000000
# R ID 05 => ROL 040000000000000000000000000000000
DB I R ID 05 NAM "Security Chief" INC 000000c8 IEP 00000014 TYP 1 PDT O PKT ID PKE R050000000000000
DB I O ID R050000000000000 OWN 00000000
# R ID 16 => ROL 00000200000000000000000000000000
DB I R ID 16 NAM "Security Deputy" INC 000000c8 IEP 00000014 TYP 1 PDT O PKT ID PKE R160000000000000
DB I O ID R160000000000000 OWN 00000000
# R ID 09 => ROL 00400000000000000000000000000000
DB I R ID 09 NAM "Mall Manager" INC 000000c8 IEP 00000014 TYP 1 PDT O PKT ID PKE R090000000000000
DB I O ID R090000000000000 OWN 00000000
# R ID 12 => ROL 00004000000000000000000000000000
DB I R ID 12 NAM "Chief of Clubs" INC 000000c8 IEP 00000014 TYP 1 PDT O PKT ID PKE R120000000000000
DB I O ID R120000000000000 OWN 00000000
# R ID 10 => ROL 00008000000000000000000000000000
DB I R ID 10 NAM "District Leader" INC 000000e6 IEP 00000017
# R ID 40 => ROL 00000000000000008000000000000000
DB I R ID 40 NAM "District Deputy" INC 00000064 IEP 0000000a
# R ID 20 => ROL 00000000800000000000000000000000
DB I R ID 20 NAM "Neighborhood Leader" INC 000000c8 IEP 00000014
# R ID 41 => ROL 00000000000000004000000000000000
DB I R ID 41 NAM "Neighborhood Deputy" INC 00000064 IEP 0000000a
# R ID 30 => ROL 00000000000080000000000000000000
DB I R ID 30 NAM "Block Leader" INC 000000c8 IEP 00000014
# R ID 42 => ROL 10000000000000002000000000000000
DB I R ID 42 NAM "Block Deputy" INC 00000064 IEP 0000000a
# R ID 25 => ROL 00000000040000000000000000000000
DB I R ID 25 NAM "Community Guide" INC 000000c8 IEP 00000014 TYP 1 PDT O PKT ID PKE R250000000000000
DB I O ID R250000000000000 OWN 00000000
# R ID 38 => ROL 00000000000000800000000000000000
DB I R ID 38 NAM "Consultant" INC 000000c8 IEP 00000014 TYP 1 PDT O PKT ID PKE R380000000000000
DB I O ID R380000000000000 OWN 00000000
# R ID 3b => ROL 00000000000000200000000000000000
DB I R ID 3b NAM "Club Manager" INC 000000c8 IEP 00000014
# R ID 4c => ROL 00000000000000000001000000000000
DB I R ID 4c NAM "Club Deputy" INC 00000064 IEP 0000000a
###-Communal Places-###
DB I O ID 0000000000000000 NAM "The Community" CTN "Community" CNM "District" ENM "Neighborhood" BNM "Block" PNM "Home" OWN 00000000 CCA 1 CCB 1 CCC 1 CCM 1 CCN 1 CCT 1
DB I O ID 0000000000000003 NAM "Member Directory" OWN 00000000 ORO 14000200000000000000000000000000 NOB 0 MOB 0
DB U O ID 0000000000000003 PLC memberdir
DB I O ID 0000000000000004 NAM "Storage Hall" OWN 00000000 ORO 00400000000000000000000000000000 NOB 0 MOB 1000
DB U O ID 0000000000000004 PLC storage
DB I O ID 0000000000000005 NAM "Club Directory" OWN 00000007 ORO 00004000000000000000000000000000 CRO 10004000000000000000000000000000 NOB 0 MOB 0
DB U O ID 0000000000000005 PLC clubdir RRO 20002000000000000000000000000000 WRO 20002000000000000000000000000000
DB I O ID 0000000000000006 NAM "E-Commerce Calendar" OWN 00000000 NOB 0 MOB 0 PLC eccal RRO c0000000000000000000000000000000 WRO 20000000000000000000000000000000
DB I O ID 0000000000000007 NAM "E-Commerce Message Board" OWN 00000000 NOB 0 MOB 0 PLC ecmsb RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I O ID 0000000000000008 NAM "E-Commerce Vote" OWN 00000000 NOB 0 MOB 0 PLC ecvot RRO 40000000000000000000000000000000 WRO 40000000000000000000000000000000
DB I O ID 0000000000000009 NAM "E-Commerce Call Center" OWN 00000000 NOB 0 MOB 0 PLC eccac RRO 40000000000000000000000000000000 WRO 40000000000000000000000000000000
DB I O ID 0000000000000010 NAM "Main Plaza" NOB 0 MOB 0 OWN 00000000
DB U O ID 0000000000000010 PLC enter CHT _pnhslx
DB I O ID 0000000000000011 NAM "City Hall" NOB 0 MOB 0 OWN 00000000
DB U O ID 0000000000000011 PLC hall CHT _snhpl
DB I O ID 0000000000000012 NAM "Community Center" NOB 0 MOB 0 OWN 00000001
DB U O ID 0000000000000012 PLC commcenter CHT _snhpl
DB I O ID 0000000000000013 NAM "Shopping Mall" ORO 00400000000000000000000000000000 CRO 10400000000000000000000000000000 NOB 0 OWN 00000000
DB U O ID 0000000000000013 PLC shop CHT _snhpl
DB I O ID 0000000000000015 NAM "Fleamarket" ORO 00400000000000000000000000000000 CRO 10400000000000000000000000000000 NOB 0 OWN 00000000
DB U O ID 0000000000000015 PLC fleamarket CHT _snhpl
DB I O ID 0000000000000016 NAM "Employment Office" NOB 0 MOB 0 OWN 00000001
DB U O ID 0000000000000016 PLC employment CHT _snhpl
DB I O ID 0000000000000017 NAM "Mayor Office" NOB 0 MOB 0 OWN 00000001
DB U O ID 0000000000000017 PLC mayor CHT _snhpl
# drop access for shared objects in fleamarket (id 15)
DB I SO ID p0000000000000015 WRO 40000000000000000000000000000000
###-Communal Places-Information###
DB U O ID 0000000000000010 TXT "<H3 align=center>Welcome to the Main Plaza.</H3><p>The City Plaza is the heart of the Community, from here you can visit our other places, wander around the Plaza and chat with others. The Plaza is open for visitors and residents of the Community. From here, those who have registered can also access the various districts in the Community and choose a personal home there.</p>"
DB U O ID 0000000000000011 TXT "<H3 align=center>Welcome to the City Hall.</H3><p>What is happening in town, what is the future planning, what are the current activities. All the important meetings will take place here.</p>"
DB U O ID 0000000000000016 TXT "<H3 align=center>Welcome to the Employment Office.</H3><p>Looking for a job? - Offering a job?<br>Come on - here you find everything you need to know ...</p>" TX2 "<div align=center><font color=yellow><h3>Job Statistics</h3><ul><li>Job <b>Offers</b>: 130<li>Job <b>Requests</b>: 215</ul><br></font></div>"
DB U O ID 0000000000000013 TXT "<H3 align=center>Welcome to the Shopping Mall.</H3> <p>Buy and sell furniture, plants and more..."
# DB U X ID ###-Communal Places-Information###
DB I I ID c0000000000000006 NAM "E-Commerce Calendar" PDT O PKT ID PKE 0000000000000006 RRO 20000000000000000000000000000000 WRO 20000000000000000000000000000000 HTM "yes"
DB I I ID c0000000000000010 NAM "Event Calendar"
DB I I ID h0000000000000010 NAM "Main Plaza Chat"
DB I I ID h0000000000000011 NAM "City Hall Chat"
DB I I ID h0000000000000012 NAM "Community Center Chat"
DB I I ID h0000000000000013 NAM "Shopping Mall Chat"
DB I I ID h0000000000000015 NAM "Fleamarket Chat"
DB I I ID h0000000000000016 NAM "Employment Office Chat"
DB I I ID h0000000000000017 NAM "Mayors Office Chat"

# Shared Objects: Categories
DB I SO ID c00000001 NAM Palm WRL /commserv/community/objects/plants/palm.wrl IMG /commserv/community/objects/thumbnails/plants/palm.jpg
DB U SO ID c00000001 aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display
DB U SO ID c00000001 a3D0 "Water the plant" a000 a00000001
DB I SO ID c00000002 NAM "Candle Lights" WRL /commserv/community/objects/lights/kandi.wrl IMG /commserv/community/objects/thumbnails/lights/kandi.jpg
DB U SO ID c00000002 aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display
DB I SO ID c00000003 NAM "Tableset" WRL /commserv/community/objects/tableset/atableset.wrl IMG /commserv/community/objects/thumbnails/tableset/tableset.jpg
DB U SO ID c00000003 aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display
DB I SO ID c00000004 NAM "Cards" WRL /commserv/community/objects/cards/cards.wrl IMG /commserv/community/objects/thumbnails/cards/cards.jpg
DB U SO ID c00000004 aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display
DB I SO ID c00000005 NAM "Carpet" WRL /commserv/community/objects/carpet/carpet.wrl IMG /commserv/community/objects/thumbnails/carpet/carpet.jpg
DB U SO ID c00000005 aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display
DB I SO ID c00000006 NAM "Designer Chair" WRL /commserv/community/objects/designerchair/designerchair.wrl IMG /commserv/community/objects/thumbnails/designerchair/designerchair.jpg
DB U SO ID c00000006 aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display
DB I SO ID c00000007 NAM "Fireplace" WRL /commserv/community/objects/fireplace/fireplace.wrl IMG /commserv/community/objects/thumbnails/fireplace/fireplace.jpg
DB U SO ID c00000007 aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display
DB I SO ID c00000008 NAM "Laptop" WRL /commserv/community/objects/laptop/alaptop.wrl IMG /commserv/community/objects/thumbnails/laptop/laptop.jpg
DB U SO ID c00000008 aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display
DB I SO ID c00000009 NAM "Lavalamp" WRL /commserv/community/objects/lavalamp/lavalamp.wrl IMG /commserv/community/objects/thumbnails/lavalamp/lavalamp.jpg
DB U SO ID c00000009 aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display
DB I SO ID c0000000a NAM "Couch" WRL /commserv/community/objects/couch/couch1.wrl IMG /commserv/community/objects/thumbnails/couch/couch1.jpg
DB U SO ID c0000000a aDEL Destroy aBUY Buy aTAK Take aDRO Drop aMOV Move aDIS Display

# Shared Objects: Actions
DB I SO ID a00000001 CNT 10 TXF "<$NNM> likes flowers" NAM "Like Flowers"

# Shared Objects: Objects
DB I SO ID o00000001 CAT c00000001
DB U SO ID o00000001 ZON p0000000000000013 POS 19,1.95,2,,1,,0 CNT 500 TPR 20
DB I SO ID o00000002 CAT c00000002
DB U SO ID o00000002 ZON p0000000000000013 POS 11,1.95,20,,1,,0 CNT 100 TPR 115
DB I SO ID o00000003 CAT c00000003
DB U SO ID o00000003 ZON p0000000000000013 POS 9,1.95,24,,1,,0 CNT 30 TPR 550
DB I SO ID o00000004 ZON m00000000 OWN 00000000 CAT c00000001
DB I SO ID o00000005 CAT c00000004
DB U SO ID o00000005 ZON p0000000000000013 POS 26,1.95,0,,1,,0 CNT 40 TPR 300
DB I SO ID o00000006 CAT c00000005
DB U SO ID o00000006 ZON p0000000000000013 POS 20,2,23,,1,,0 CNT 50 TPR 199
DB I SO ID o00000007 CAT c00000006
DB U SO ID o00000007 ZON p0000000000000013 POS 25,1.95,24,,1,,4.3 CNT 30 TPR 100
DB I SO ID o00000008 CAT c00000007
DB U SO ID o00000008 ZON p0000000000000013 POS 24,1.95,18,,1,,4.7 CNT 20 TPR 400
DB I SO ID o00000009 CAT c00000008
DB U SO ID o00000009 ZON p0000000000000013 POS 24,3.45,4,,1,,3.14 CNT 40 TPR 150
DB I SO ID o0000000a CAT c00000009
DB U SO ID o0000000a ZON p0000000000000013 POS 27,1.95,-5,,1,,0 CNT 50 TPR 250
DB I SO ID o0000000b CAT c0000000a
DB U SO ID o0000000b ZON p0000000000000013 POS 18,1.95,15,,1,,0 CNT 10 TPR 450

###-Clubs Categories-###
DB I CL ID CT00000000000000 CDA 20010117102256 CNT 00000000 NAK CT00000000000000 NAM "Clubs" CK2 CL00000000000001 ORO 00000000000000000000000000000000 OWN 00000007 PDT O PKE 0000000000000005 PKT ID RRO c0000000000000000000000000000000 UDD 19700106005955 WRO 20000000000000000000000000000000
DB I CL ID CT01000000000000 CDA 20010117102256 CNT 00000001 NAK CT01000000000000 NAM "Community Help" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 20010117115805 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT01000100000000 CDA 20010117103508 CNT 00000001 NAK CT01000100000000 NAM "Assistance" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 20010117115805 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT01000200000000 CDA 20010117103528 CNT 00000000 NAK CT01000200000000 NAM "Tips" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT02000000000000 CDA 20010117103032 CNT 00000000 NAK CT02000000000000 NAM "Health & Fitness" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT02000100000000 CDA 20010117103629 CNT 00000000 NAK CT02000100000000 NAM "Fitness" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT02000200000000 CDA 20010117103639 CNT 00000000 NAK CT02000200000000 NAM "Health Care" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT03000000000000 CDA 20010117103042 CNT 00000000 NAK CT03000000000000 NAM "News & Politics" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT03000100000000 CDA 20010117103733 CNT 00000000 NAK CT03000100000000 NAM "Business" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT03000200000000 CDA 20010117103800 CNT 00000000 NAK CT03000200000000 NAM "Entertainment" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT03000300000000 CDA 20010117103816 CNT 00000000 NAK CT03000300000000 NAM "Technology" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT03000400000000 CDA 20010117103832 CNT 00000000 NAK CT03000400000000 NAM "Weather" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT04000000000000 CDA 20010117103055 CNT 00000000 NAK CT04000000000000 NAM "Sport" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT04000100000000 CDA 20010117103943 CNT 00000000 NAK CT04000100000000 NAM "Basketball" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT04000200000000 CDA 20010117103958 CNT 00000000 NAK CT04000200000000 NAM "Football" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT04000300000000 CDA 20010117104035 CNT 00000000 NAK CT04000300000000 NAM "Motor Sports" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT04000400000000 CDA 20010117104118 CNT 00000000 NAK CT04000400000000 NAM "Soccer" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000000000000 CDA 20010117103432 CNT 00000000 NAK CT05000000000000 NAM "Travel & Leisure" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000100000000 CDA 20010117111343 CNT 00000000 NAK CT05000100000000 NAM "Regional" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000100010000 CDA 20010117104228 CNT 00000000 NAK CT05000100010000 NAM "Africa" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000100020000 CDA 20010117104244 CNT 00000000 NAK CT05000100020000 NAM "Asia "OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000100030000 CDA 20010117104253 CNT 00000000 NAK CT05000100030000 NAM "Australia" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000100040000 CDA 20010117104313 CNT 00000000 NAK CT05000100040000 NAM "Europe" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000100050000 CDA 20010117104937 CNT 00000000 NAK CT05000100050000 NAM "Latin America" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000100060000 CDA 20010117104947 CNT 00000000 NAK CT05000100060000 NAM "USA and Canada" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000200000000 CDA 20010117113451 CNT 00000000 NAK CT05000200000000 NAM "Outdoors Travel" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000300000000 CDA 20010117113505 CNT 00000000 NAK CT05000300000000 NAM "Adventure Travel" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT05000400000000 CDA 20010117113525 CNT 00000000 NAK CT05000400000000 NAM "Cruises" OWN 00000007 PDT O PKE 0000000000000005 PKT ID UDD 19700106005955 RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000
DB I CL ID CT06000000000000 PID CT05000100000000 NAK CT06000000000000 NAM "Regional" OWN 00000007 PDT O PKE 0000000000000005 PKT ID RRO c0000000000000000000000000000000 WRO c0000000000000000000000000000000

###-Club-###
DB I CL ID CL00000000000000 TCN 00000001 UDD 20010116170649 NAK CL00000000000000
DB I CL ID CL00000000000001 NAM "Pod Racer" NAK "pod racer" KK1 CT01000100000000 CK1 "Assistance" CKI O CDA 20010117115805 ACT 00000064 CNT 00000001 CLW 00000001 OWR 3b ASR 4c
DB U CL ID CL00000000000001 GID G0000001 OWN 00000001 RI1 G0000001 WI1 G0000001 WRO 20000000000000000000000000000000 RRO c0000000000000000000000000000000 PDT O PKE 0000000000000005 PKT ID
DB U CL ID CL00000000000001 CLP "/dbimages/CL/CL/00/00/00/00/00/00/01/clubimage.jpg" STC 0 ST1 0 ST2 0 ST3 0 ST4 0 ST5 0 ST6 0 ST7 0 ST8 0
DB U CL ID CL00000000000001 DES "This club is for all fans of the Star Wars episodes." RUL "No light sabers inside the club." FOG 40 MON 00000000 NOB 0 MOB 0

###-Club Members-###
DB I CM ID CL00000000000001cm00000001 STT 1 LVD 20010117134955 NNM Mayor JND 20010117115805

###-Groups-###
DB I G ID G0000001 NNK "pod racer" NNM "Pod Racer"
DB I GM ID G0000001m00000001

DB I I ID hCL00000000000001 OWN 00000001

###-0001-District-###
DB I H ID 0001000000000000 OWN 00000002 NAM "Science Fiction" ADU "ht]tp://ww]w.XXX.com" ADI "ad.gif" OWR 10 ASR 40 CRO 30000000000000000000000000000000 TXT "<p>In this place you could have an encounter with your own kind but again, who knows who may be popping into those neighborhoods? E.T., Darth Vader? If you feel like living in the twilight zone and aren't worried about who you neighbor might be, this is the place to settle. Enjoy meeting friends with the same interests that you have or have discussions about your latest favorite episode!</p>"
DB I I ID h0001000000000000 NAM "Chat"
DB I H ID D0001
###-0001-Neighborhoods-###
DB I H ID 0001000100000000 OWN 00000003 NAM "UFOs" TXT "Welcome to 'UFOs'!" OWR 20 ASR 41 CRO 30000000000000000000000000000000
DB U H ID 0001000100000000 IMG /home/images/defaultnh1.gif
DB I I ID h0001000100000000 NAM "Chat"
DB I H ID N00010001
DB I H ID 0001000200000000 OWN 00000003 NAM "Fantasy" TXT "Welcome to 'Fantasy'!"OWR 20 ASR 41 CRO 30000000000000000000000000000000
DB U H ID 0001000200000000 IMG /home/images/defaultnh1.gif STT 1
DB I I ID h0001000200000000 NAM "Chat"
DB I H ID N00010002
DB I H ID 0001000300000000 OWN 00000003 NAM "Aliens" TXT "Welcome to 'Aliens'!" OWR 20 ASR 41 CRO 30000000000000000000000000000000
DB I I ID h0001000300000000 NAM "Chat"
DB I H ID N00010003
###-00010001-Blocks-###
DB I H ID 0001000100010000 OWN 00000004 NAM "Starwars" TXT "Welcome to 'Starwars'!" OWR 30 ASR 42
DB U H ID 0001000100010000 IMG /home/images/defaultbl1.gif
DB I I ID h0001000100010000 NAM "Chat"
DB I H ID B000100010001
DB I H ID 0001000100020000 OWN 00000003 NAM "E.T." TXT "Welcome to 'E.T.'!"OWR 30 ASR 42
DB U H ID 0001000100010000 IMG /home/images/defaultbl2.gif
DB I I ID h0001000100020000 NAM "Chat"
DB I H ID B000100010002
DB I H ID 0001000100030000 OWN 00000003 NAM "Shannara" TXT "Welcome to 'Shannara'!"OWR 30 ASR 42
DB U H ID 0001000100030000 IMG /home/images/defaultbl3.gif
DB I I ID h0001000100030000 NAM "Chat"
DB I H ID B000100010003
###-000100010001-Homes-###
DB I H ID 0001000000000000h001 IMG /home/vrml/home/001/home.gif WRL /home/vrml/home/001/home.wrl PRC 00000064 CST 0000000A
DB I H ID 0001000000000000h002 IMG /home/vrml/home/002/home.gif WRL /home/vrml/home/002/home.wrl PRC 00000064 CST 0000000A
DB I H ID 0001000000000000h003 IMG /home/vrml/home/003/home.gif PRC 00000000
DB I H ID 0001000100010001 OWN 00000000 NAM "My Planet" TXT "Welcome to 'My Planet'!" IMG /dbimages/H/00/01/00/01/00/01/00/01/home.gif STT "" AVI /home/vrml/home/001/home.gif WRL /home/vrml/home/001/home.wrl HOM 0001000000000000h001
DB I I ID h0001000100010001 NAM "My Chat"
# Mayor's Home
DB I H ID 0001000100010002 OWN 00000001 NAM "Mayor's Home" TXT "Welcome to 'My Home'!" AVI /home/vrml/home/002/home.gif WRL /home/vrml/home/002/home.wrl HOM 0001000000000000h002
DB I I ID h0001000100010002 NAM "My Chat"
# DL's Home
DB I H ID 0001000100010003 OWN 00000002 NAM "DL's Home" TXT "Welcome to my Home!" AVI /home/vrml/home/003/home.gif HOM 0001000000000000h003
DB I I ID h0001000100010003 NAM "My Chat"
# NL's Home
DB I H ID 0001000100010004 OWN 00000003 NAM "NL's Home" TXT "Welcome to my Home!" AVI /home/vrml/home/004/home.gif HOM 0001000000000000h003
DB I I ID h0001000100010004 NAM "My Chat"
# BL's Home
DB I H ID 0001000100010005 OWN 00000004 NAM "BL's Home" TXT "Welcome to my Home!" AVI /home/vrml/home/005/home.gif HOM 0001000000000000h003
DB I I ID h0001000100010005 NAM "My Chat"
###- Avatar Library###
DB I A ID c0000000 NAM "Male Avatars" ORD "c2" TXT "Male avatars" AVI /commserv/community/dbavatars/A/c0/00/00/00/avi.gif
DB I A ID c0000001 NAM "Female Avatars" ORD "c1" TXT "Female avatars" AVI /commserv/community/dbavatars/A/c0/00/00/01/avi.gif
DB I A ID a0000000 NAM "Monique" ORD "ac00000011" AVI /commserv/community/dbavatars/A/a0/00/00/00/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/00/av.wrl
DB I A ID a0000001 NAM "Noa" ORD "ac00000012" AVI /commserv/community/dbavatars/A/a0/00/00/01/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/01/av.wrl
DB I A ID a0000002 NAM "Anna" ORD "ac00000013" AVI /commserv/community/dbavatars/A/a0/00/00/02/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/02/av.wrl
DB I A ID a0000003 NAM "Petra" ORD "ac00000014" AVI /commserv/community/dbavatars/A/a0/00/00/03/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/03/av.wrl
DB I A ID a0000004 NAM "Kate" ORD "ac00000015" AVI /commserv/community/dbavatars/A/a0/00/00/04/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/04/av.wrl
DB I A ID a0000005 NAM "Yong" ORD "ac00000016" AVI /commserv/community/dbavatars/A/a0/00/00/05/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/05/av.wrl
DB I A ID a0000006 NAM "Wang" ORD "ac00000001" AVI /commserv/community/dbavatars/A/a0/00/00/06/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/06/av.wrl
DB I A ID a0000007 NAM "James" ORD "ac00000002" AVI /commserv/community/dbavatars/A/a0/00/00/07/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/07/av.wrl
DB I A ID a0000008 NAM "Jean-Pierre" ORD "ac00000003" AVI /commserv/community/dbavatars/A/a0/00/00/08/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/08/av.wrl
DB I A ID a0000009 NAM "Don" ORD "ac00000005" AVI /commserv/community/dbavatars/A/a0/00/00/09/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/09/av.wrl
DB I A ID a000000a NAM "Rico" ORD "ac00000006" AVI /commserv/community/dbavatars/A/a0/00/00/0a/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/0a/av.wrl
DB I A ID a000000b NAM "Jay Jay" ORD "ac00000008" AVI /commserv/community/dbavatars/A/a0/00/00/0b/avi.gif AVU /commserv/community/dbavatars/A/a0/00/00/0b/av.wrl

###- Examples for Voting -###
DB I V ID 00000001 PLC r0000000000000012 DDA 0 EDA 0 IID 00000000 SEC 0 TOP "House Rating" TYP 0 VWW 0
DB I V ID 00000001c0 CNT 0 TOP "0 Points"
DB I V ID 00000001c1 CNT 0 TOP "1 Point"
DB I V ID 00000001c2 CNT 0 TOP "2 Points"
DB I V ID 00000001c3 CNT 0 TOP "3 Points"
DB I V ID 00000001c4 CNT 0 TOP "4 Points"
DB I V ID 00000001c5 CNT 0 TOP "5 Points"

DB I V ID 00000002 PLC e0000000000000012 DDA 0 EDA 0 IID 00000000 SEC 1 TOP "Elect Mayor" TYP 1 VWW 0
DB I V ID 00000002c0 CNT 0 TOP "Mickey Mouse"
DB I V ID 00000002c1 CNT 0 TOP "Goofy"
DB I V ID 00000002c2 CNT 0 TOP "Donald Duck"
DB I V ID 00000002c3 CNT 0 TOP "Dagobert Duck"

DB I V ID 00000003 PLC e0000000000000000 DDA 0 EDA 0 IID 00000000 SEC 1 TOP "Which is the best film Monty Python made?" TYP 1 VWW 0
DB I V ID 00000003c0 CNT 0 TOP "And Now For Something Completely Different..."
DB I V ID 00000003c1 CNT 0 TOP "Holy Grail"
DB I V ID 00000003c2 CNT 0 TOP "Life of Brian"
DB I V ID 00000003c3 CNT 0 TOP "Meaning of Life"

###- Default for E-Commerce Product Rating -###
DB I V ID 00000004 PLC r0000000000000008 DDA 0 EDA 0 IID 00000000 SEC 0 TOP "E-Commerce Product Rating" TYP 0 VWW 0
DB I V ID 00000004c0 CNT 0 TOP "0 Points"
DB I V ID 00000004c1 CNT 0 TOP "1 Point"
DB I V ID 00000004c2 CNT 0 TOP "2 Points"
DB I V ID 00000004c3 CNT 0 TOP "3 Points"

###- Message Boards -###
# Special Message Boards
DB I MB ID b00000001
DB U MB ID b00000001 IDONN b_mayor ONN Mayor OWN 00000001
DB U MB ID b00000001 PIDCDA 0000000000000016_20001001120000 PKE 0000000000000016 PDT O PKT ID
DB U MB ID b00000001 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000001 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000001 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000001 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000001 IDSUB "b_Job Offers" SUB "Job Offers"

DB I MB ID b00000002
DB U MB ID b00000002 IDONN b_mayor ONN Mayor OWN 00000001
DB U MB ID b00000002 PIDCDA 0000000000000016_20001001120000 PKE 0000000000000016 PDT O PKT ID
DB U MB ID b00000002 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000002 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000002 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000002 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000002 IDSUB "b_Job Requests" SUB "Job Requests"

# Place Message Boards
DB I MB ID b00000010
DB U MB ID b00000010 IDONN b_admin ONN Admin OWN 00000000
DB U MB ID b00000010 PIDCDA 0000000000000010_20001001120000 PKE 0000000000000010 PDT O PKT ID
DB U MB ID b00000010 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000010 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000010 IDSIZ b_0000002c SIZ 0000002c
DB U MB ID b00000010 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000010 IDSUB "b_Feedback" SUB "Feedback"
DB U MB ID b00000010 TXT "Please tell us what you think about this community."
DB U MB ID b00000010 CNT 00000003
DB U MB ID b00000010 KMS A

##########

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: # Thread 1
##########
DB I MB ID m0000001000000001
DB U MB ID m0000001000000001 IDONN b00000010_bl ONN BL OWN 00000004
DB U MB ID m0000001000000001 PIDCDA b00000010_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m0000001000000001 IDCDA b00000010_20001001120000 CDA 20001001120000
DB U MB ID m0000001000000001 IDLAD b00000010_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m0000001000000001 IDSIZ b00000010_00000003 SIZ 00000003
DB U MB ID m0000001000000001 IDRCT b00000010_00000000 RCT 00000000
DB U MB ID m0000001000000001 IDSUB "b00000010_How do I become a me" SUB "How do I become a member?"
DB U MB ID m0000001000000001 CNT 00000002 DEP 00000000
DB U MB ID b00000010 TXT ""

DB I MB ID m000000100000000100000001
DB U MB ID m000000100000000100000001 IDONN m0000001000000001_mayor ONN Mayor OWN 00000001
DB U MB ID m000000100000000100000001 PIDCDA m0000001000000001_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000100000001 IDCDA m0000001000000001_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000100000001 IDLAD m0000001000000001_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000100000001 IDSIZ m0000001000000001_00000000 SIZ 00000000
DB U MB ID m000000100000000100000001 IDRCT m0000001000000001_00000180 RCT 00000180
DB U MB ID m000000100000000100000001 IDSUB "m0000001000000001_How do I become a me" SUB "How do I become a member?"
DB U MB ID m000000100000000100000001 CNT 00000000 DEP 00000001
DB U MB ID m000000100000000100000001 TXT "Click the profile button above and follow the link to the registration page. You will have to fill out and submit a short form. A few moments later you should receive an email with your immigration code. Come back and login using the nickname and password you have chosen. You'll be asked to enter the Immigration Code. Once you do that you will enter as an official citizen. Welcome!"

DB I MB ID m000000100000000100000002
DB U MB ID m000000100000000100000002 IDONN m0000001000000001_bl ONN BL OWN 00000004
DB U MB ID m000000100000000100000002 PIDCDA m000000100000000100000001_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000100000002 IDCDA m0000001000000001_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000100000002 IDLAD m0000001000000001_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000100000002 IDSIZ m0000001000000001_00000000 SIZ 00000000
DB U MB ID m000000100000000100000002 IDRCT m0000001000000001_0000002a RCT 0000002a
DB U MB ID m000000100000000100000002 IDSUB "m0000001000000001_How do I become a me" SUB "How do I become a member?"
DB U MB ID m000000100000000100000002 CNT 00000000 DEP 00000002
DB U MB ID m000000100000000100000002 TXT "Do you charge any price for the membership"

DB I MB ID m000000100000000100000003
DB U MB ID m000000100000000100000003 IDONN m0000001000000001_mayor ONN Mayor OWN 00000001
DB U MB ID m000000100000000100000003 PIDCDA m000000100000000100000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000100000003 IDCDA m0000001000000001_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000100000003 IDLAD m0000001000000001_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000100000003 IDSIZ m0000001000000001_00000000 SIZ 00000000
DB U MB ID m000000100000000100000003 IDRCT m0000001000000001_00000021 RCT 00000021
DB U MB ID m000000100000000100000003 IDSUB "m0000001000000001_How do I become a me" SUB "How do I become a member?"
DB U MB ID m000000100000000100000003 CNT 00000000 DEP 00000003
DB U MB ID m000000100000000100000003 TXT "No the the membership is for free"

##########
# Thread 2
##########
DB I MB ID m0000001000000002
DB U MB ID m0000001000000002 IDONN b00000010_mayor ONN Mayor OWN 00000001
DB U MB ID m0000001000000002 PIDCDA b00000010_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m0000001000000002 IDCDA b00000010_20001001120000 CDA 20001001120000
DB U MB ID m0000001000000002 IDLAD b00000010_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m0000001000000002 IDSIZ b00000010_00000011 SIZ 00000011
DB U MB ID m0000001000000002 IDRCT b00000010_00000000 RCT 00000000
DB U MB ID m0000001000000002 IDSUB "b00000010_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m0000001000000002 CNT 00000009 DEP 00000000
DB U MB ID b00000010 TXT ""

DB I MB ID m000000100000000200000001
DB U MB ID m000000100000000200000001 IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000200000001 PIDCDA m0000001000000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000001 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000001 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000001 IDSIZ m0000001000000002_00000028 SIZ 00000028
DB U MB ID m000000100000000200000001 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000001 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000001 TXT "The homesteading is completely reworked."
DB U MB ID m000000100000000200000001 CNT 00000001 DEP 00000001

DB I MB ID m000000100000000200000002
DB U MB ID m000000100000000200000002 IDONN m0000001000000002_mayor ONN Mayor OWN 00000001
DB U MB ID m000000100000000200000002 PIDCDA m000000100000000200000001_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000002 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000002 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000002 IDSIZ m0000001000000002_00000019 SIZ 00000019
DB U MB ID m000000100000000200000002 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000002 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000002 TXT "[i]Can you give any details?[/i]"
DB U MB ID m000000100000000200000002 CNT 00000002 DEP 00000002

DB I MB ID m000000100000000200000003
DB U MB ID m000000100000000200000003 IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000200000003 PIDCDA m000000100000000200000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000003 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000003 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000003 IDSIZ m0000001000000002_00000074 SIZ 00000074
DB U MB ID m000000100000000200000003 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000003 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000003 TXT "The data model is different. Instead of four tables only one table is used."
DB U MB ID m000000100000000200000003 CNT 00000000 DEP 00000003

DB I MB ID m000000100000000200000004
DB U MB ID m000000100000000200000004 IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000200000004 PIDCDA m000000100000000200000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000004 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000004 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000004 IDSIZ m0000001000000002_0000004a SIZ 0000004a
DB U MB ID m000000100000000200000004 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000004 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000004 TXT "Substructures (homes in a block) are always displayed as a list."
DB U MB ID m000000100000000200000004 CNT 00000000 DEP 00000003

DB I MB ID m000000100000000200000005
DB U MB ID m000000100000000200000005 IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000200000005 PIDCDA m0000001000000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000005 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000005 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000005 IDSIZ m0000001000000002_00000033 SIZ 00000033
DB U MB ID m000000100000000200000005 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000005 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000005 TXT "A new java client is distributed with the platform."
DB U MB ID m000000100000000200000005 CNT 00000000 DEP 00000001

DB I MB ID m000000100000000200000006
DB U MB ID m000000100000000200000006 IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000200000006 PIDCDA m0000001000000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000006 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000006 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000006 IDSIZ m0000001000000002_0000003a SIZ 0000003a
DB U MB ID m000000100000000200000006 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000006 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000006 TXT "Some lists of the client interface are now html documents."
DB U MB ID m000000100000000200000006 CNT 00000001 DEP 00000001

DB I MB ID m000000100000000200000007
DB U MB ID m000000100000000200000007 IDONN m0000001000000002_mayor ONN Mayor OWN 00000001
DB U MB ID m000000100000000200000007 PIDCDA m000000100000000200000006_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000007 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000007 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000007 IDSIZ m0000001000000002_00000011 SIZ 00000011
DB U MB ID m000000100000000200000007 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000007 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000007 TXT "[i]Which list?[/i]"
DB U MB ID m000000100000000200000007 CNT 00000002 DEP 00000002

DB I MB ID m000000100000000200000008
DB U MB ID m000000100000000200000008 IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000200000008 PIDCDA m000000100000000200000007_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000008 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000008 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000008 IDSIZ m0000001000000002_00000018 SIZ 00000018
DB U MB ID m000000100000000200000008 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000008 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000008 TXT "The shared object lists."
DB U MB ID m000000100000000200000008 CNT 00000000 DEP 00000003

DB I MB ID m000000100000000200000009
DB U MB ID m000000100000000200000009 IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000200000009 PIDCDA m000000100000000200000007_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000009 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000009 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000009 IDSIZ m0000001000000002_00000013 SIZ 00000013
DB U MB ID m000000100000000200000009 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000009 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000009 TXT " The chatters list."
DB U MB ID m000000100000000200000009 CNT 00000000 DEP 00000003

DB I MB ID m00000010000000020000000a
DB U MB ID m00000010000000020000000a IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000020000000a PIDCDA m0000001000000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000020000000a IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m00000010000000020000000a IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m00000010000000020000000a IDSIZ m0000001000000002_00000028 SIZ 00000028
DB U MB ID m00000010000000020000000a IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m00000010000000020000000a IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m00000010000000020000000a TXT "The calendar user interface is improved."
DB U MB ID m00000010000000020000000a CNT 00000000 DEP 00000001

DB I MB ID m00000010000000020000000b
DB U MB ID m00000010000000020000000b IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000020000000b PIDCDA m0000001000000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000020000000b IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m00000010000000020000000b IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m00000010000000020000000b IDSIZ m0000001000000002_0000002d SIZ 0000002d
DB U MB ID m00000010000000020000000b IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m00000010000000020000000b IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m00000010000000020000000b TXT "The message board user interface is improved."
DB U MB ID m00000010000000020000000b CNT 00000000 DEP 00000001

DB I MB ID m00000010000000020000000c
DB U MB ID m00000010000000020000000c IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000020000000c PIDCDA m0000001000000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000020000000c IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m00000010000000020000000c IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m00000010000000020000000c IDSIZ m0000001000000002_00000018 SIZ 00000018
DB U MB ID m00000010000000020000000c IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m00000010000000020000000c IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m00000010000000020000000c TXT "Visitors are now unique."
DB U MB ID m00000010000000020000000c CNT 00000001 DEP 00000001

DB I MB ID m00000010000000020000000d
DB U MB ID m00000010000000020000000d IDONN m0000001000000002_mayor ONN Mayor OWN 00000001
DB U MB ID m00000010000000020000000d PIDCDA m00000010000000020000000c_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000020000000d IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m00000010000000020000000d IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m00000010000000020000000d IDSIZ m0000001000000002_00000014 SIZ 00000014
DB U MB ID m00000010000000020000000d IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m00000010000000020000000d IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m00000010000000020000000d TXT "[i]What does this mean?[/i]"
DB U MB ID m00000010000000020000000d CNT 00000001 DEP 00000002

DB I MB ID m00000010000000020000000e
DB U MB ID m00000010000000020000000e IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000020000000e PIDCDA m00000010000000020000000d_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000020000000e IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m00000010000000020000000e IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m00000010000000020000000e IDSIZ m0000001000000002_00000025 SIZ 00000250
DB U MB ID m00000010000000020000000e IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m00000010000000020000000e IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m00000010000000020000000e TXT "A number is added to the visitor name.
DB U MB ID m00000010000000020000000e CNT 00000000 DEP 00000003

DB I MB ID m00000010000000020000000f
DB U MB ID m00000010000000020000000f IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000020000000f PIDCDA m0000001000000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000020000000f IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m00000010000000020000000f IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m00000010000000020000000f IDSIZ m0000001000000002_0000002f SIZ 0000002f
DB U MB ID m00000010000000020000000f IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m00000010000000020000000f IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m00000010000000020000000f TXT "The html chat is integrated into the community."
DB U MB ID m00000010000000020000000f CNT 00000000 DEP 00000001

DB I MB ID m000000100000000200000010
DB U MB ID m000000100000000200000010 IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000200000010 PIDCDA m0000001000000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000010 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000010 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000010 IDSIZ m0000001000000002_0000002e SIZ 0000002e
DB U MB ID m000000100000000200000010 IDRCT m0000001000000002_00000000 RCT 00000000
DB U MB ID m000000100000000200000010 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000010 TXT "The moderation client and server are reworked."
DB U MB ID m000000100000000200000010 CNT 00000000 DEP 00000001

DB I MB ID m000000100000000200000011
DB U MB ID m000000100000000200000011 IDONN m0000001000000002_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000200000011 PIDCDA m0000001000000002_20001001120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000200000011 IDCDA m0000001000000002_20001001120000 CDA 20001001120000
DB U MB ID m000000100000000200000011 IDLAD m0000001000000002_20001001120000 BIDLAD b00000010_20001001120000 LAD 20001001120000
DB U MB ID m000000100000000200000011 IDSIZ m0000001000000002_0000004a SIZ 0000004a
DB U MB ID m000000100000000200000011 IDRCT m0000001000000002_00000100 RCT 00000000
DB U MB ID m000000100000000200000011 IDSUB "m0000001000000002_What are the new fea" SUB "What are the new features of Platform 5.0"
DB U MB ID m000000100000000200000011 TXT "An avatar library allows the member to choose a community specific avatar."
DB U MB ID m000000100000000200000011 CNT 00000000 DEP 00000001

##########
# Thread 3
##########
DB I MB ID m0000001000000003
DB U MB ID m0000001000000003 IDONN b00000010_mayor ONN Mayor OWN 00000001
DB U MB ID m0000001000000003 PIDCDA b00000010_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m0000001000000003 IDCDA b00000010_20010301120000 CDA 20010301120000
DB U MB ID m0000001000000003 IDLAD b00000010_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m0000001000000003 IDSIZ b00000010_00000015 SIZ 00000015
DB U MB ID m0000001000000003 IDRCT b00000010_00000000 RCT 00000000
DB U MB ID m0000001000000003 IDSUB "b00000010_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m0000001000000003 CNT 00000000 DEP 00000000
DB U MB ID m0000001000000003 TXT ""

DB I MB ID m000000100000000300000001
DB U MB ID m000000100000000300000001 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000001 PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000001 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000001 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000001 IDSIZ m0000001000000003_0000003f SIZ 0000003f
DB U MB ID m000000100000000300000001 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000001 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000001 TXT "1. Contact LE (multi-user enabled blaxxun3D) integrated."
DB U MB ID m000000100000000300000001 CNT 00000000 DEP 00000001

DB I MB ID m000000100000000300000002
DB U MB ID m000000100000000300000002 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000002 PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000002 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000002 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000002 IDSIZ m0000001000000003_00000024 SIZ 00000024
DB U MB ID m000000100000000300000002 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000002 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000002 TXT "Automatic scene splitting."
DB U MB ID m000000100000000300000002 CNT 00000000 DEP 00000001

DB I MB ID m000000100000000300000003
DB U MB ID m000000100000000300000003 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000003 PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000003 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000003 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000003 IDSIZ m0000001000000003_00000028 SIZ 00000028
DB U MB ID m000000100000000300000003 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000003 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000003 TXT "Auditorium - stage scenes are supported."
DB U MB ID m000000100000000300000003 CNT 00000001 DEP 00000001

DB I MB ID m000000100000000300000004
DB U MB ID m000000100000000300000004 IDONN m0000001000000003_mayor ONN Mayor OWN 00000001
DB U MB ID m000000100000000300000004 PIDCDA m000000100000000300000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000004 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000004 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000004 IDSIZ m0000001000000003_00000028 SIZ 00000028
DB U MB ID m000000100000000300000004 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000004 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000004 TXT "[i]What does this mean?[/i]"
DB U MB ID m000000100000000300000004 CNT 00000001 DEP 00000002

DB I MB ID m000000100000000300000005
DB U MB ID m000000100000000300000005 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000005 PIDCDA m000000100000000300000004_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000005 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000005 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000005 IDSIZ m0000001000000003_0000024b SIZ 0000024b
DB U MB ID m000000100000000300000005 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000005 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000005 TXT "For interview events where [b]thousands[/b] of members should be able to follow the interview the default scene splitting is not useful. On the other hand is not possible to handle more than about 100 chatter in one group. The auditorium - stage scenes can help. A star and a couple of preselected members enter the stage. All other members are automatically distributes to different auditoriums. The different auditoriums are separated but all auditoriums are connected to the stage which means a member in an auditorium can only see the members of his auditorium and the members in the stage."
DB U MB ID m000000100000000300000005 CNT 00000000 DEP 00000003

DB I MB ID m000000100000000300000006
DB U MB ID m000000100000000300000006 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000006 PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000006 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000006 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000006 IDSIZ m0000001000000003_0000004c SIZ 0000004c
DB U MB ID m000000100000000300000006 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000006 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000006 TXT "The moderation server supports a moderation of a stage with all auditoriums."
DB U MB ID m000000100000000300000006 CNT 00000001 DEP 00000001

DB I MB ID m000000100000000300000007
DB U MB ID m000000100000000300000007 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000007 PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000007 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000007 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000007 IDSIZ m0000001000000003_0000002b SIZ 0000002b
DB U MB ID m000000100000000300000007 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000007 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000007 TXT "A bad word chat filter is added."
DB U MB ID m000000100000000300000007 CNT 00000000 DEP 00000001

DB I MB ID m000000100000000300000008
DB U MB ID m000000100000000300000008 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000008 PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000008 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000008 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000008 IDSIZ m0000001000000003_00000027 SIZ 00000027
DB U MB ID m000000100000000300000008 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000008 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000008 TXT "New customizing features are available."
DB U MB ID m000000100000000300000008 CNT 00000001 DEP 00000001

DB I MB ID m000000100000000300000009
DB U MB ID m000000100000000300000009 IDONN m0000001000000003_mayor ONN Mayor OWN 00000001
DB U MB ID m000000100000000300000009 PIDCDA m000000100000000300000008_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000009 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000009 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000009 IDSIZ m0000001000000003_0000001b SIZ 0000001b
DB U MB ID m000000100000000300000009 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000009 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000009 TXT "[i]Can you give some examples?[/i]"
DB U MB ID m000000100000000300000009 CNT 00000002 DEP 00000002

DB I MB ID m00000010000000030000000a
DB U MB ID m00000010000000030000000a IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000030000000a PIDCDA m000000100000000300000009_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000030000000a IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m00000010000000030000000a IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m00000010000000030000000a IDSIZ m0000001000000003_000000b9 SIZ 000000b9
DB U MB ID m00000010000000030000000a IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m00000010000000030000000a IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m00000010000000030000000a TXT "With the new script include tag for the templates it is possible to call other programs. This is very seful if you want to provide content form different modules (message board and calendar) on one page."
DB U MB ID m00000010000000030000000a CNT 00000000 DEP 00000003

DB I MB ID m00000010000000030000000b
DB U MB ID m00000010000000030000000b IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000030000000b PIDCDA m000000100000000300000009_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000030000000b IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m00000010000000030000000b IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m00000010000000030000000b IDSIZ m0000001000000003_00000072 SIZ 00000072
DB U MB ID m00000010000000030000000b IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m00000010000000030000000b IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m00000010000000030000000b TXT "With the new *LIST directive for the configuration file it is possible to define complex database list operations."
DB U MB ID m00000010000000030000000b CNT 00000000 DEP 00000003

DB I MB ID m00000010000000030000000c
DB U MB ID m00000010000000030000000c IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000030000000c PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000030000000c IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m00000010000000030000000c IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m00000010000000030000000c IDSIZ m0000001000000003_00000025 SIZ 00000025
DB U MB ID m00000010000000030000000c IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m00000010000000030000000c IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m00000010000000030000000c TXT "Organization of clubs via categories."
DB U MB ID m00000010000000030000000c CNT 00000000 DEP 00000001

DB I MB ID m00000010000000030000000d
DB U MB ID m00000010000000030000000d IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000030000000d PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000030000000d IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m00000010000000030000000d IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m00000010000000030000000d IDSIZ m0000001000000003_00000018 SIZ 00000018
DB U MB ID m00000010000000030000000d IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m00000010000000030000000d IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m00000010000000030000000d TXT "Notification via e-mail."
DB U MB ID m00000010000000030000000d CNT 00000000 DEP 00000001

DB I MB ID m00000010000000030000000e
DB U MB ID m00000010000000030000000e IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m00000010000000030000000e PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000030000000e IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m00000010000000030000000e IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m00000010000000030000000e IDSIZ m0000001000000003_00000025 SIZ 00000025
DB U MB ID m00000010000000030000000e IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m00000010000000030000000e IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m00000010000000030000000e TXT "Message board with new functionality."
DB U MB ID m00000010000000030000000e CNT 00000001 DEP 00000001

DB I MB ID m00000010000000030000000f
DB U MB ID m00000010000000030000000f IDONN m0000001000000003_mayor ONN Mayor OWN 00000001
DB U MB ID m00000010000000030000000f PIDCDA m00000010000000030000000e_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m00000010000000030000000f IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m00000010000000030000000f IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m00000010000000030000000f IDSIZ m0000001000000003_00000020 SIZ 00000020
DB U MB ID m00000010000000030000000f IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m00000010000000030000000f IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m00000010000000030000000f TXT "[i]What are the main new functions?[/i]"
DB U MB ID m00000010000000030000000f CNT 00000003 DEP 00000002

DB I MB ID m000000100000000300000010
DB U MB ID m000000100000000300000010 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000010 PIDCDA m00000010000000030000000f_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000010 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000010 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000010 IDSIZ m0000001000000003_00000026 SIZ 00000026
DB U MB ID m000000100000000300000010 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000010 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000010 TXT "Different sort criteria are available."
DB U MB ID m000000100000000300000010 CNT 00000000 DEP 00000003

DB I MB ID m000000100000000300000011
DB U MB ID m000000100000000300000011 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000011 PIDCDA m00000010000000030000000f_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000011 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000011 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000011 IDSIZ m0000001000000003_00000020 SIZ 00000020
DB U MB ID m000000100000000300000011 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000011 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000011 TXT "Replies to replies are possible."
DB U MB ID m000000100000000300000011 CNT 00000000 DEP 00000003

DB I MB ID m000000100000000300000012
DB U MB ID m000000100000000300000012 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000012 PIDCDA m00000010000000030000000f_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000012 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000012 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000012 IDSIZ m0000001000000003_00000035 SIZ 00000035
DB U MB ID m000000100000000300000012 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000012 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000012 TXT "More information are inherited to the parent objects:"
DB U MB ID m000000100000000300000012 CNT 00000002 DEP 00000003

DB I MB ID m000000100000000300000013
DB U MB ID m000000100000000300000013 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000013 PIDCDA m000000100000000300000012_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000013 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000013 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000013 IDSIZ m0000001000000003_00000012 SIZ 00000012
DB U MB ID m000000100000000300000013 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000013 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000013 TXT "Number of replies."
DB U MB ID m000000100000000300000013 CNT 00000000 DEP 00000004

DB I MB ID m000000100000000300000014
DB U MB ID m000000100000000300000014 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000014 PIDCDA m000000100000000300000012_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000014 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000014 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000014 IDSIZ m0000001000000003_0000000f SIZ 0000000f
DB U MB ID m000000100000000300000014 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000014 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000014 TXT "Number of hits."
DB U MB ID m000000100000000300000014 CNT 00000000 DEP 00000004

DB I MB ID m000000100000000300000015
DB U MB ID m000000100000000300000015 IDONN m0000001000000003_admin ONN Admin OWN 00000000
DB U MB ID m000000100000000300000015 PIDCDA m0000001000000003_20010301120000 PKE b00000010 PDT MB PKT ID
DB U MB ID m000000100000000300000015 IDCDA m0000001000000003_20010301120000 CDA 20010301120000
DB U MB ID m000000100000000300000015 IDLAD m0000001000000003_20010301120000 BIDLAD b00000010_20001001120000 LAD 20010301120000
DB U MB ID m000000100000000300000015 IDSIZ m0000001000000003_00000053 SIZ 00000053
DB U MB ID m000000100000000300000015 IDRCT m0000001000000003_00000000 RCT 00000000
DB U MB ID m000000100000000300000015 IDSUB "m0000001000000003_What are the new fea" SUB "What are the new features of Platform 5.1"
DB U MB ID m000000100000000300000015 TXT "A new Agent module for AIML (artificial markup language) chatter bots is available (see [URL]htt[p://b]ots.internet.com[/URL])."
DB U MB ID m000000100000000300000015 CNT 00000000 DEP 00000001

DB I MB ID b00000011
DB U MB ID b00000011 IDONN b_admin ONN Admin OWN 00000000
DB U MB ID b00000011 PIDCDA 0000000000000015_20001001120000 PKE 0000000000000015 PDT O PKT ID
DB U MB ID b00000011 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000011 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000011 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000011 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000011 IDSUB "b_Fleamarket Messages" SUB "Fleamarket Messages"

DB I MB ID b00000012
DB U MB ID b00000012 IDONN b_mayor ONN Mayor OWN 00000001
DB U MB ID b00000012 PIDCDA 0000000000000017_20001001120000 PKE 0000000000000017 PDT O PKT ID
DB U MB ID b00000012 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000012 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000012 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000012 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000012 IDSUB "b_Mayors Office Messag" SUB "Mayors Office Messages"

DB I MB ID b00000013
DB U MB ID b00000013 IDONN b_admin ONN Admin OWN 00000000
DB U MB ID b00000013 PIDCDA 0000000000000011_20001001120000 PKE 0000000000000011 PDT O PKT ID
DB U MB ID b00000013 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000013 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000013 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000013 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000013 IDSUB "b_City Hall Messages" SUB "City Hall Messages"

DB I MB ID b00000014
DB U MB ID b00000014 IDONN b_mayor ONN Mayor OWN 00000001
DB U MB ID b00000014 PIDCDA 0000000000000012_20001001120000 PKE 0000000000000012 PDT O PKT ID
DB U MB ID b00000014 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000014 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000014 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000014 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000014 IDSUB "b_Community Center Mes" SUB "Community Center Messages"

DB I MB ID b00000015
DB U MB ID b00000015 IDONN b_admin ONN Admin OWN 00000000
DB U MB ID b00000015 PIDCDA 0000000000000013_20001001120000 PKE 0000000000000013 PDT O PKT ID
DB U MB ID b00000015 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000015 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000015 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000015 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000015 IDSUB "b_Shopping Mall Messag" SUB "Shopping Mall Messages"

# Home Message Boards
DB I MB ID b00000020
DB U MB ID b00000020 IDONN b_admin ONN Admin OWN 00000000
DB U MB ID b00000020 PIDCDA 0001000100010001_20001001120000 PKE 0001000100010001 PDT H PKT ID
DB U MB ID b00000020 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000020 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000020 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000020 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000020 IDSUB "b_My Messages" SUB "My Messages"

DB I MB ID b00000021
DB U MB ID b00000021 IDONN b_mayor ONN Mayor OWN 00000001
DB U MB ID b00000021 PIDCDA 0001000100010002_20001001120000 PKE 0001000100010002 PDT H PKT ID
DB U MB ID b00000021 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000021 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000021 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000021 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000021 IDSUB "b_My Messages" SUB "My Messages"

DB I MB ID b00000022
DB U MB ID b00000022 IDONN b_dl ONN DL OWN 00000002
DB U MB ID b00000022 PIDCDA 0001000100010003_20001001120000 PKE 0001000100010003 PDT H PKT ID
DB U MB ID b00000022 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000022 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000022 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000022 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000022 IDSUB "b_My Messages" SUB "My Messages"

DB I MB ID b00000023
DB U MB ID b00000023 IDONN b_nl ONN NL OWN 00000003
DB U MB ID b00000023 PIDCDA 0001000100010004_20001001120000 PKE 0001000100010004 PDT H PKT ID
DB U MB ID b00000023 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000023 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000023 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000023 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000023 IDSUB "b_My Messages" SUB "My Messages"

DB I MB ID b00000024
DB U MB ID b00000024 IDONN b_bl ONN BL OWN 00000004
DB U MB ID b00000024 PIDCDA 0001000100010005_20001001120000 PKE 0001000100010005 PDT H PKT ID
DB U MB ID b00000024 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000024 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000024 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000024 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000024 IDSUB "b_My Messages" SUB "My Messages"

DB I MB ID b00000025
DB U MB ID b00000025 IDONN b_bl ONN BL OWN 00000004
DB U MB ID b00000025 PIDCDA 0001000100010001_20001001120000 PKE 0001000100010001 PDT H PKT ID
DB U MB ID b00000025 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000025 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000025 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000025 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000025 IDSUB "b_My Messages" SUB "My Messages"

# Block Message Boards
DB I MB ID b00000030
DB U MB ID b00000030 IDONN b_bl ONN BL OWN 00000004
DB U MB ID b00000030 PIDCDA 0001000100010000_20001001120000 PKE 0001000100010000 PDT H PKT ID
DB U MB ID b00000030 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000030 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000030 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000030 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000030 IDSUB "b_Starwars Messages" SUB "Starwars Messages"

DB I MB ID b00000031
DB U MB ID b00000031 IDONN b_nl ONN NL OWN 00000003
DB U MB ID b00000031 PIDCDA 0001000100020000_20001001120000 PKE 0001000100020000 PDT H PKT ID
DB U MB ID b00000031 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000031 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000031 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000031 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000031 IDSUB "b_E.T. Messages" SUB "E.T. Messages"

DB I MB ID b00000032
DB U MB ID b00000032 IDONN b_nl ONN NL OWN 00000003
DB U MB ID b00000032 PIDCDA 0001000100030000_20001001120000 PKE 0001000100030000 PDT H PKT ID
DB U MB ID b00000032 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000032 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000032 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000032 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000032 IDSUB "b_Shannara Messages" SUB "Shannara Messages"

# Neighborhood Message Boards
DB I MB ID b00000038
DB U MB ID b00000038 IDONN b_nl ONN NL OWN 00000003
DB U MB ID b00000038 PIDCDA 0001000100000000_20001001120000 PKE 0001000100000000 PDT H PKT ID
DB U MB ID b00000038 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000038 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000038 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000038 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000038 IDSUB "b_UFO Messages" SUB "UFO Messages"

DB I MB ID b00000039
DB U MB ID b00000039 IDONN b_nl ONN NL OWN 00000003
DB U MB ID b00000039 PIDCDA 0001000200000000_20001001120000 PKE 0001000200000000 PDT H PKT ID
DB U MB ID b00000039 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000039 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000039 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000039 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000039 IDSUB "b_Fantasy Messages" SUB "Fantasy Messages"

DB I MB ID b0000003a
DB U MB ID b0000003a IDONN b_nl ONN NL OWN 00000003
DB U MB ID b0000003a PIDCDA 0001000300000000_20001001120000 PKE 0001000300000000 PDT H PKT ID
DB U MB ID b0000003a IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b0000003a IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b0000003a IDSIZ b_00000000 SIZ 00000000
DB U MB ID b0000003a IDRCT b_00000000 RCT 00000000
DB U MB ID b0000003a IDSUB "b_Aliens Messages" SUB "Aliens Messages"

# District Message Boards
DB I MB ID b0000003f
DB U MB ID b0000003f IDONN b_dl ONN DL OWN 00000002
DB U MB ID b0000003f PIDCDA 0001000000000000_20001001120000 PKE 0001000000000000 PDT H PKT ID
DB U MB ID b0000003f IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b0000003f IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b0000003f IDSIZ b_00000000 SIZ 00000000
DB U MB ID b0000003f IDRCT b_00000000 RCT 00000000
DB U MB ID b0000003f IDSUB "b_Science Fiction Mess" SUB "Science Fiction Messages"

# Clubs Message Boards
DB I MB ID b00000040
DB U MB ID b00000040 IDONN b_mayor ONN Mayor OWN 00000001
DB U MB ID b00000040 PIDCDA CL00000000000001_20001001120000 PKE CL00000000000001 PDT CL PKT ID
DB U MB ID b00000040 IDCDA b_20001001120000 CDA 20001001120000
DB U MB ID b00000040 IDLAD b_20001001120000 LAD 20001001120000
DB U MB ID b00000040 IDSIZ b_00000000 SIZ 00000000
DB U MB ID b00000040 IDRCT b_00000000 RCT 00000000
DB U MB ID b00000040 IDSUB "b_Club Messages" SUB "Club Messages"

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: # global.cfg
#
# Config file for the cgi programs
#

#
# template customization
# body colors
g_body BGCOLOR="#000000" LINK="#FFFF00" VLINK="#FFFF00" ALINK="#FFFFFF" TEXT="#80FF00"
g_font <FONT face="Arial, Helvetica, sans-serif">

# end of template customizing
#

#
# memberregistration
#
# SMTP host for sending emails
g_MailServer
#
# The machine you want to receive mail on, e.g. help@g_PopServer
g_PopServer 127.0.0.1
#
# send registration code by email, default 1
# g_regCode 0
# send welcome email, default 1
# g_regWelcome 0
# default chat type for members, default s (Java chat)
# set p for 3d chat, n for none
# g_chatType p

# end of memberregistration
#

# use extension .html insteadof .tmpl for tenplates
g_extTemplate .html

# The machine running the Community Server, idserver
#
g_CServer 127.0.0.1
g_CSPort 2000
#
# The machine running the database server, fcserver
#
g_DbServer 127.0.0.1
g_DbPort 2004
#
# The machine running the virtual pet server, vpserver
#
g_VpServer 127.0.0.1
g_VpPort VPPORT
#
# shop server for avatar studio
g_bASReferer htt[p:/]/leo.blaxxun.de
#
# The machine running the authorisation server, auserver
#
g_AuServer 127.0.0.1
g_AuPort 2005
#
# The HTTP server used
#
g_HttpServer htt[p:/]/127.0.0.1
g_CookieDomain 127.0.0.1
g_CookiePath /
#
# directories of the HTTP server
#
g_HTMLRoot /commserv/community
g_cgiRoot /csbin/community
g_Templates ./templates/
#
# Message server (instant messages)
#
g_MessageServer htt[p:/]/127.0.0.1:2009
g_MsRefresh 30
g_MsTimeout 120
#
# Shared Objects Server
# (path for objects to upload: see objects.cfg!)
#
g_SoServer 127.0.0.1
g_SoPort 2010
#
# Images to upload
#
g_Htdocs d:/PROGRA~1/BLAXXU~2/commserv
g_DBImages /dbimages
g_homeImageSize 15000
#
# Members that are treated as Administrators and have all rights
#
g_Admins /admin/
#
# Used to set the City Time
#
g_TimeZone +0
#
# Password needed for moderation
#
g_modPwd default
#
# URL of avatar select page
#
g_avatarPath ht[tp:/]/w]ww.blaxxun.com/vrml/avatars
#
# .exe extension of programs, should be empty on UNIX
#
g_exe .exe
#
# Title for HTML templates
#
g_title blaxxun Community
#
# Names of Communal Places
#
g_CityDefName the Community
g_enterDefName City Plaza
g_newsDefName Newspaper
g_citizenDefName Citizen
g_employmentDefName Employment Office
g_clubdirDefName Club Directory
g_shoppingDefName Shopping Mall
#
# and their ids in the database
#
g_cityID 0000000000000000
g_enterID 0000000000000001
g_newsID 0000000000000002
g_citizenID 0000000000000003
g_employmentID 0000000000000004
g_clubdirID 0000000000000005
g_shoppingID 0000000000000006
#
# Names of Communal Places in place urls
#
g_plc0000000000000000 city
g_plc0000000000000001 enter
g_plc0000000000000002 news
g_plc0000000000000003 citizen
g_plc0000000000000004 employment
g_plc0000000000000005 clubdir
g_plc0000000000000006 shopping
#
# Names for Information features
#
g_InboxName Inbox
g_MsgBoardName Message Board
g_CalendarName Calendar
g_ChatName Chat
g_LinkListName Links
g_NewsMagName News Magazine
#
# This flag ensures that tickets are checked
# Comment it out if you do not want that.
#
g_useTickets 1

#
# Global variables for the upload of avatars from
# the blaxxun avatar studio.
#

# allow only upload of avatars from the blaxxun avatar studio
g_bASOnly 0

# number of avatar per member
g_AvtNumber 3

# perform license check for blaxxun avatar studio
g_bASLicCheck 1

10/20 Number of posts : 12 Registration date : 2017-02-11

Code:: # global.cfg
#
# Configuration for community scripts
#
# common
g_title Virtual Worlds Platform 5.1
g_visitor Visitor
g_noCookie 0
#g_SessionID &SID=<$SID>

g_bgcolor1 bgcolor=103C63
g_bgcolor2 bgcolor=787778
g_bgcolor3 bgcolor=AAA9AA
g_bgcolor4 bgcolor=6A736E
g_bgcolor5 bgcolor=8BA093
g_bgcolor6 bgcolor=4A554A
g_bgcolor7 bgcolor=B2CCBD
g_bgcolor8 bgcolor=3F6485
g_body <$g_bgcolor1> text=#000000 link=#CCFFCC vlink=#80CC80 alink=#80CC80>
g_body1 <$g_bgcolor1> text=#ffffff link=#CCFFCC vlink=#E60000 alink=#E60000>
g_font <FONT size=1 color=CCCCCC face="Verdana, Arial, Helvetica, sans-serif">
g_font1 <FONT size=1 color=black face="Verdana, Arial, Helvetica, sans-serif">
g_errorfont <FONT size=2 color=black face="Verdana, Arial, Helvetica, sans-serif">
g_usr1 your text here
g_usr2
g_usr3
g_usr4
g_usr5
g_usr6
g_usr7
g_usr8
# end common

# server configuration
g_CServer 1.27.0.0.1
g_CSPort 2000
g_DbServer 1.27.0.0.1
g_DbPort 2004
g_HaServer 1.27.0.0.1
g_HaPort 2006
g_MdServer 1.27.0.0.1
g_MdPort 2003
g_AsServer 1.27.0.0.1
g_AsPort 2011
g_MailServer
g_PopServer 1.27.0.0.1
g_HttpServer ht[tp:/[/1.27.0.0.1
g_CookieDomain 1.27.0.0.1
g_MsServer 1.27.0.0.1
g_MsPort 2009
g_SoServer 1.27.0.0.1
g_SoPort 2010
g_FtServer 1.27.0.0.1
g_FtPort 2012
# end server configuration

# folder configuration
g_CookiePath /
g_HTMLRoot /commserv/community
g_cgiRoot /csbin/community
g_Templates templates/
g_CSRoot d:/PROGRA~1/BLAXXU~2/VIRTUA~1
g_csadmin /csadmin
g_csadmbin /csadmbin
g_DBAvatars /dbavatars
g_Htdocs d:/PROGRA~1/BLAXXU~2/VIRTUA~1
g_AvtTempDir d:/PROGRA~1/BLAXXU~2/VIRTUA~1/tmp/
g_DBImages /dbimages
# end folder configuration

# security
g_Admins /Admin/
g_useTickets 1
g_passwordQuestion 1
g_logDty /M/MD/H/SO/CL/O/
g_logAttr /EXD/PWD/ZON/EXP/MON/ROL/OWR/ASR/EMK/
g_logInsert 1
# end security

# registration
g_regWelcome 1
g_regCode 1
g_chatType p
# end registration

# message board
g_Tag_URL <[a h/ref="%s" TARGET=_blank>%s</a>
g_Tag_IMG <im/g src="%s">
g_Tag_MAIL <[a hr/ef="mailto:%s">%s</]a>
g_Tag_B <b>%s</b>
g_Tag_I <i>%s</i>
g_Tag_U <u>%s</u>
g_Tag_BR <br>
g_ListCount 16
g_MBIndent  
g_messageKeep D
g_messageKeepCount 90
g_messageToAllId 20380101010100
g_messageToAllTxt These are messages posted to all.
g_messageHomeMail *
g_messageFromMail Messages[@]1.27.0.0.1
# end message board

# calendar
g_calKeepPast M
# end calendar

# instant message configuration
g_MsRefresh 30
g_MsTimeout 120
g_MsIMRecvUrl htt[p:/]/1]27.0.0.1/csbin/community/message.exe?TPL=message/openrcv&TIM=<$TIME>&SID=<$SID> refresh
g_MsIMNotifyUrl ht[tp:/]/1.27.0.0.1/csbin/community/message.exe?TPL=message/notify&TIM=<$TIME>&SID=<$SID> refresh
g_SecurityRole 04000200000000000000000000000000
g_Excluded excluded
g_Excluded_Perm 04000200000000000000000000000000
g_VisitorIMPostMessages yes
g_VisitorIMGetMessages yes
g_VisitorIMMemberOnlineList yes
g_Messages 16
g_ClubOnlineList yes
g_BlockOnlineList no

# currently not used and not needed by Platform 5.1.
g_VisitorIMListUsers yes
g_VisitorIMIgnoreUser yes
g_VisitorIMGetUserScene yes
# end instant message configuration

# homesteading
g_homeTable H
g_maxHomes 50
g_maxBlocks 50
g_maxNeighbor 50
g_homeImageSize 15000
g_NeighborLeaderJob 20
g_NeighborDeputyJob 41
g_BlockLeaderJob 30
g_BlockDeputyJob 42
# end homesteading

# avatars
g_bASLicCheck 0
g_AvtNumber 4
g_bASOnly 0
g_AvtFileSize 60000
# end avatars

# others
g_uniq_visitor 1
g_extTemplate .html
g_TimeZone +0
g_HTMLRefresh 30
g_exe .exe
g_OChats _snhp
g_CLChats _snhp
g_HChats nnhs
g_SceneInstanceMaxUsers 50
g_AgentControlScene _controlAgent_
# g_CacheVersion
# g_CacheRoot will be set automatically to g_HTMLRoot or to the local cache
# g_useLanguage 0
# g_defLanguage en
# end others

# place ids in the database
g_cityID 0000000000000000
g_citizenID 0000000000000003
g_storageID 0000000000000004
g_clubdirID 0000000000000005

g_ec_calID 0000000000000006
g_ec_msbID 0000000000000007
g_ec_votID 0000000000000008
g_ec_cacID 0000000000000009

g_enterID 0000000000000010
g_hallID 0000000000000011
g_commcenterID 0000000000000012
g_shopID 0000000000000013
g_fleamarketID 0000000000000015
g_employmentID 0000000000000016
g_mayorID 0000000000000017
# end of places

# e-commerce
g_ecommercePlatform ECPLATFORM
g_ScriptDir ../../etc/scripts/
g_ScriptDirAbs d:/PROGRA~1/BLAXXU~2/VIRTUA~1/etc/scripts/
g_vpserverScenePattern _bvs_
g_bx3Dlicense BX3DLICENSE
g_shopPlaza Chatroom
g_storefront ht[tp:/]/1]27.0.0.1/is-bin/INTERSHOP.enfinity/eCS/ECSTORENAME/-/-/-/Storefront-Start
g_ECLoginReferer htt[p:/]/12[7.0.0.1/is-bin/INTERSHOP.enfinity
g_ECRoot ECROOT/share
g_botRoot /public/eCS/ECSTORENAME/ECLANG/bvs
g_botScriptExt .bot
g_imgDir /images
g_imgNameFilter MS_
g_imgIconFilter ICON_MS_
g_ECHTMLRoot /intershoproot/eCS/ECSTORENAME/ECLANG
g_ECStorename ECSTORENAME/
g_ECLanguage ECLANG/
# end e-commerce

» lol some1 bought the blaxxun.de blaxxun.com
» convert wrl file in meshlab problem
» blaxxun CCstandard
» alain dont know enter caching file of bs contact
» Blaxxun 2017