# this file determines the layout of the PvPGN SQL database# the server will create the tables with their columns as specified in here# don't forget to create the DB yourself# no empty lines allowed, no whitespaces in front of any entries allowed# file format:# [name_of_a_table]# "column_name with format infos","default value" [&& "sqlcommand to execute on success"] [|| "sqlcommand to execute on failure"]# :"sqlcommand to execute" [&& "sqlcommand to execute on success"] [|| "sqlcommand to execute on failure"]# you might also notice some variables of the form ${variable}. these are # replaced with their meaning when the server starts# ${prefix} is replaced with the configured table prefix from bnetd.conf/storage_path## For the "sql2" SQL layout#[${prefix}BNET]"uid int NOT NULL","'0'""name varchar(128) NOT NULL","''""value varchar(200) NOT NULL","''":"CREATE UNIQUE INDEX ${prefix}user ON ${prefix}BNET (uid,name)":"CREATE INDEX ${prefix}user2 ON ${prefix}BNET (name,value)":"CREATE INDEX ${prefix}user3 ON ${prefix}BNET (uid)":"INSERT INTO ${prefix}BNET (uid, name, value) VALUES ('0', 'auth\normallogin', 'true')":"INSERT INTO ${prefix}BNET (uid, name, value) VALUES ('0', 'auth\changepass', 'true')":"INSERT INTO ${prefix}BNET (uid, name, value) VALUES ('0', 'auth\changeprofile', 'true')":"INSERT INTO ${prefix}BNET (uid, name, value) VALUES ('0', 'auth\botlogin', 'true')":"INSERT INTO ${prefix}BNET (uid, name, value) VALUES ('0', 'auth\command_groups' ,'1')"[${prefix}friend]"uid int NOT NULL","'0'""name varchar(128) NOT NULL","''""value varchar(200) NOT NULL","''":"CREATE UNIQUE INDEX ${prefix}friends ON ${prefix}friend (uid,name)"[${prefix}profile]"uid int NOT NULL","'0'""name varchar(128) NOT NULL","''""value varchar(200) NOT NULL","''":"CREATE UNIQUE INDEX ${prefix}profiles ON ${prefix}profile (uid,name)"[${prefix}Record]"uid int NOT NULL","'0'""name varchar(128) NOT NULL","''""value varchar(200) NOT NULL","''":"CREATE UNIQUE INDEX ${prefix}Records ON ${prefix}Record (uid,name)"[${prefix}clan]"cid int NOT NULL PRIMARY KEY","'0'""short int","'0'""name varchar(30)","NULL""motd varchar(30)","NULL","creation_time int","'0'"[${prefix}clanmember]"uid int NOT NULL PRIMARY KEY","'0'""cid int","'0'""status int","'0'""join_time int","'0'"[${prefix}arrangedteam]"teamid int NOT NULL PRIMARY KEY","'0'""size int","0""clienttag varchar(8)","NULL""lastgame int","'0'""member1 int","'0'""member2 int","'0'""member3 int","'0'""member4 int","'0'""wins int","'0'""losses int","'0'""xp int","'0'""level int","'0'""rank int","'0'"