| 1 |
# this file determines the layout of the PvPGN SQL database
|
| 2 |
# the server will create the tables with their columns as specified in here
|
| 3 |
# don't forget to create the DB yourself
|
| 4 |
# no empty lines allowed, no whitespaces in front of any entries allowed
|
| 5 |
# file format:
|
| 6 |
# [name_of_a_table]
|
| 7 |
# "column_name with format infos","default value"
|
| 8 |
[BNET]
|
| 9 |
"uid int NOT NULL PRIMARY KEY","'0'"
|
| 10 |
"acct_username varchar(32)","NULL"
|
| 11 |
"acct_userid int","NULL"
|
| 12 |
"acct_passhash1 varchar(128)","NULL"
|
| 13 |
"acct_email varchar(128)","NULL"
|
| 14 |
"auth_admin varchar(16)","'false'"
|
| 15 |
"auth_normallogin varchar(16)","'true'"
|
| 16 |
"auth_changepass varchar(16)","'true'"
|
| 17 |
"auth_changeprofile varchar(16)","'true'"
|
| 18 |
"auth_botlogin varchar(16)","'true'"
|
| 19 |
"auth_operator varchar(16)","'false'"
|
| 20 |
"new_at_team_flag int","'0'"
|
| 21 |
"auth_lockk varchar(16)","'0'"
|
| 22 |
"auth_command_groups varchar(128)","'1'"
|
| 23 |
"acct_lastlogin_time int","'0'"
|
| 24 |
"acct_lastlogin_owner varchar(128)","NULL"
|
| 25 |
"acct_lastlogin_clienttag varchar(128)","NULL"
|
| 26 |
"acct_lastlogin_ip varchar(32)","NULL"
|
| 27 |
[friend]
|
| 28 |
"uid int NOT NULL PRIMARY KEY","'0'"
|
| 29 |
[profile]
|
| 30 |
"uid int NOT NULL PRIMARY KEY","'0'"
|
| 31 |
"sex varchar(16)","NULL"
|
| 32 |
"location varchar(128)","NULL"
|
| 33 |
"description varchar(256)","NULL"
|
| 34 |
"age varchar(16)","NULL"
|
| 35 |
"clanname varchar(48)","NULL"
|
| 36 |
[Record]
|
| 37 |
"uid int NOT NULL PRIMARY KEY","'0'"
|
| 38 |
"WAR3_solo_xp int","'0'"
|
| 39 |
"WAR3_solo_level int","'0'"
|
| 40 |
"WAR3_solo_wins int","'0'"
|
| 41 |
"WAR3_solo_rank int","'0'"
|
| 42 |
"WAR3_solo_losses int","'0'"
|
| 43 |
"WAR3_team_xp int","'0'"
|
| 44 |
"WAR3_team_level int","'0'"
|
| 45 |
"WAR3_team_rank int","'0'"
|
| 46 |
"WAR3_team_wins int","'0'"
|
| 47 |
"WAR3_team_losses int","'0'"
|
| 48 |
"WAR3_ffa_xp int","'0'"
|
| 49 |
"WAR3_ffa_rank int","'0'"
|
| 50 |
"WAR3_ffa_level int","'0'"
|
| 51 |
"WAR3_ffa_wins int","'0'"
|
| 52 |
"WAR3_ffa_losses int","'0'"
|
| 53 |
"WAR3_orcs_wins int","'0'"
|
| 54 |
"WAR3_orcs_losses int","'0'"
|
| 55 |
"WAR3_humans_wins int","'0'"
|
| 56 |
"WAR3_humans_losses int","'0'"
|
| 57 |
"WAR3_undead_wins int","'0'"
|
| 58 |
"WAR3_undead_losses int","'0'"
|
| 59 |
"WAR3_nightelves_wins int","'0'"
|
| 60 |
"WAR3_nightelves_losses int","'0'"
|
| 61 |
"WAR3_random_wins int","'0'"
|
| 62 |
"WAR3_random_losses int","'0'"
|
| 63 |
"WAR3_teamcount int","'0'"
|
| 64 |
"WAR3_userselected_icon varchar(16)","NULL"
|
| 65 |
"W3XP_solo_xp int","'0'"
|
| 66 |
"W3XP_solo_level int","'0'"
|
| 67 |
"W3XP_solo_wins int","'0'"
|
| 68 |
"W3XP_solo_rank int","'0'"
|
| 69 |
"W3XP_solo_losses int","'0'"
|
| 70 |
"W3XP_team_xp int","'0'"
|
| 71 |
"W3XP_team_level int","'0'"
|
| 72 |
"W3XP_team_rank int","'0'"
|
| 73 |
"W3XP_team_wins int","'0'"
|
| 74 |
"W3XP_team_losses int","'0'"
|
| 75 |
"W3XP_ffa_xp int","'0'"
|
| 76 |
"W3XP_ffa_rank int","'0'"
|
| 77 |
"W3XP_ffa_level int","'0'"
|
| 78 |
"W3XP_ffa_wins int","'0'"
|
| 79 |
"W3XP_ffa_losses int","'0'"
|
| 80 |
"W3XP_orcs_wins int","'0'"
|
| 81 |
"W3XP_orcs_losses int","'0'"
|
| 82 |
"W3XP_humans_wins int","'0'"
|
| 83 |
"W3XP_humans_losses int","'0'"
|
| 84 |
"W3XP_undead_wins int","'0'"
|
| 85 |
"W3XP_undead_losses int","'0'"
|
| 86 |
"W3XP_nightelves_wins int","'0'"
|
| 87 |
"W3XP_nightelves_losses int","'0'"
|
| 88 |
"W3XP_random_wins int","'0'"
|
| 89 |
"W3XP_random_losses int","'0'"
|
| 90 |
"W3XP_teamcount int","'0'"
|
| 91 |
"W3XP_userselected_icon varchar(16)","NULL"
|
| 92 |
"STAR_0_wins int","'0'"
|
| 93 |
"STAR_0_losses int","'0'"
|
| 94 |
"STAR_0_disconnects int","'0'"
|
| 95 |
"STAR_1_wins int","'0'"
|
| 96 |
"STAR_1_losses int","'0'"
|
| 97 |
"STAR_1_disconnects int","'0'"
|
| 98 |
"STAR_0_last_game int","'0'"
|
| 99 |
"STAR_0_last_game_result varchar(128)","NULL"
|
| 100 |
"STAR_1_last_game int","'0'"
|
| 101 |
"STAR_1_last_game_result varchar(128)","NULL"
|
| 102 |
"STAR_1_rating int","'0'"
|
| 103 |
"STAR_1_high_rating int","'0'"
|
| 104 |
"STAR_1_rank int","'0'"
|
| 105 |
"STAR_1_high_rank int","'0'"
|
| 106 |
"SEXP_0_wins int","'0'"
|
| 107 |
"SEXP_0_losses int","'0'"
|
| 108 |
"SEXP_0_disconnects int","'0'"
|
| 109 |
"SEXP_1_wins int","'0'"
|
| 110 |
"SEXP_1_losses int","'0'"
|
| 111 |
"SEXP_1_disconnects int","'0'"
|
| 112 |
"SEXP_0_last_game int","'0'"
|
| 113 |
"SEXP_0_last_game_result varchar(128)","NULL"
|
| 114 |
"SEXP_1_last_game int","'0'"
|
| 115 |
"SEXP_1_last_game_result varchar(128)","NULL"
|
| 116 |
"SEXP_1_rating int","'0'"
|
| 117 |
"SEXP_1_high_rating int","'0'"
|
| 118 |
"SEXP_1_rank int","'0'"
|
| 119 |
"SEXP_1_high_rank int","'0'"
|
| 120 |
[Team]
|
| 121 |
"uid int NOT NULL PRIMARY KEY","'0'"
|
| 122 |
[clan]
|
| 123 |
"cid int NOT NULL PRIMARY KEY","'0'"
|
| 124 |
"short int","'0'"
|
| 125 |
"name varchar(30)","NULL"
|
| 126 |
"motd varchar(30)","NULL",
|
| 127 |
"creation_time int","'0'"
|
| 128 |
[clanmember]
|
| 129 |
"uid int NOT NULL PRIMARY KEY","'0'"
|
| 130 |
"cid int","'0'"
|
| 131 |
"status int","'0'"
|
| 132 |
"join_time int","'0'"
|
| 133 |
[arrangedteam]
|
| 134 |
"teamid int NOT NULL PRIMARY KEY","'0'"
|
| 135 |
"size int","0"
|
| 136 |
"clienttag varchar(8)","NULL"
|
| 137 |
"lastgame int","'0'"
|
| 138 |
"member1 int","'0'"
|
| 139 |
"member2 int","'0'"
|
| 140 |
"member3 int","'0'"
|
| 141 |
"member4 int","'0'"
|
| 142 |
"wins int","'0'"
|
| 143 |
"losses int","'0'"
|
| 144 |
"xp int","'0'"
|
| 145 |
"level int","'0'"
|
| 146 |
"rank int","'0'"
|
Parent Directory
| 
Revision Log