开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > MySQL数据库 > 查看源码
sql_DB_layout
资源名称：pvpgn-1.6.2.rar　[点击查看]
上传用户：tany51
上传日期：2013-06-12
资源大小：1397k
文件大小：4k
源码类别：

MySQL数据库

开发平台：

Visual C++

sql_DB_layout：源码内容
  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'"