mserver.sql 2.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. # phpMyAdmin MySQL-Dump
  2. # http://phpwizard.net/phpMyAdmin/
  3. #
  4. # Serveur: localhost Base de données: finale
  5. # --------------------------------------------------------
  6. #
  7. # Structure de la table 'Bitmaps'
  8. #
  9. DROP TABLE IF EXISTS Bitmaps;
  10. CREATE TABLE Bitmaps (
  11. id int(11) DEFAULT '0' NOT NULL,
  12. login varchar(8) NOT NULL,
  13. nom varchar(80) NOT NULL,
  14. prenom varchar(80) NOT NULL,
  15. pseudo varchar(80) NOT NULL,
  16. machine varchar(80) NOT NULL,
  17. statut int(11) DEFAULT '0' NOT NULL,
  18. staff tinyint(4) DEFAULT '0' NOT NULL,
  19. PRIMARY KEY (id),
  20. UNIQUE pseudo (pseudo),
  21. UNIQUE login (login)
  22. );
  23. # --------------------------------------------------------
  24. #
  25. # Structure de la table 'Champions'
  26. #
  27. DROP TABLE IF EXISTS Champions;
  28. CREATE TABLE Champions (
  29. id int(11) NOT NULL auto_increment,
  30. nom varchar(80) NOT NULL,
  31. auteur int(11) DEFAULT '0' NOT NULL,
  32. fichier varchar(255) NOT NULL,
  33. actif tinyint(4) DEFAULT '1' NOT NULL,
  34. public tinyint(4) DEFAULT '1' NOT NULL,
  35. score float DEFAULT '0' NOT NULL,
  36. best float DEFAULT '0' NOT NULL,
  37. nbmap int(11) DEFAULT '0' NOT NULL,
  38. total int(11) DEFAULT '0' NOT NULL,
  39. tourn tinyint(3) unsigned DEFAULT '0' NOT NULL,
  40. PRIMARY KEY (id),
  41. UNIQUE nom (nom),
  42. KEY bitmap (auteur)
  43. );
  44. # --------------------------------------------------------
  45. #
  46. # Structure de la table 'Maps'
  47. #
  48. DROP TABLE IF EXISTS Maps;
  49. CREATE TABLE Maps (
  50. id int(11) NOT NULL auto_increment,
  51. nom varchar(80) NOT NULL,
  52. descr varchar(255) NOT NULL,
  53. fichier varchar(255) NOT NULL,
  54. joueurs tinyint(4) DEFAULT '0' NOT NULL,
  55. auteur int(11) DEFAULT '0' NOT NULL,
  56. taille varchar(80) NOT NULL,
  57. public tinyint(4) DEFAULT '1' NOT NULL,
  58. actif tinyint(4) DEFAULT '1' NOT NULL,
  59. PRIMARY KEY (id),
  60. UNIQUE nom (nom),
  61. KEY fichier (fichier)
  62. );
  63. # --------------------------------------------------------
  64. #
  65. # Structure de la table 'Matchs'
  66. #
  67. DROP TABLE IF EXISTS Matchs;
  68. CREATE TABLE Matchs (
  69. id int(11) NOT NULL auto_increment,
  70. map int(11) DEFAULT '0' NOT NULL,
  71. host varchar(80) NOT NULL,
  72. port smallint(6) DEFAULT '0' NOT NULL,
  73. statut smallint(4) DEFAULT '1' NOT NULL,
  74. joueurs smallint(4) DEFAULT '0' NOT NULL,
  75. auteur int(11) DEFAULT '0' NOT NULL,
  76. public tinyint(4) DEFAULT '1' NOT NULL,
  77. PRIMARY KEY (id),
  78. KEY map (map)
  79. );
  80. # --------------------------------------------------------
  81. #
  82. # Structure de la table 'Msg'
  83. #
  84. DROP TABLE IF EXISTS Msg;
  85. CREATE TABLE Msg (
  86. id tinyint(4) DEFAULT '0' NOT NULL,
  87. msg char(3) NOT NULL,
  88. PRIMARY KEY (id)
  89. );
  90. #
  91. # Contenu de la table 'Msg'
  92. #
  93. INSERT INTO Msg VALUES ( '0', 'Non');
  94. INSERT INTO Msg VALUES ( '1', 'Oui');
  95. # --------------------------------------------------------
  96. #
  97. # Structure de la table 'Scores'
  98. #
  99. DROP TABLE IF EXISTS Scores;
  100. CREATE TABLE Scores (
  101. id int(11) NOT NULL auto_increment,
  102. match_id int(11) DEFAULT '0' NOT NULL,
  103. champion int(11) DEFAULT '0' NOT NULL,
  104. score float DEFAULT '-1' NOT NULL,
  105. PRIMARY KEY (id)
  106. );