Advertisement
S4T3K

s_admin

Apr 2nd, 2014
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.77 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS Banlist (
  2.     id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  3.     pseudo_banni VARCHAR(30) NOT NULL,
  4.     date_heure DATETIME NOT NULL,
  5.     pseudo_admin VARCHAR(30) NOT NULL,
  6.     raison TEXT NOT NULL,
  7.     PRIMARY KEY(id)
  8.     )
  9. ENGINE=INNODB;
  10.  
  11. CREATE TABLE IF NOT EXISTS Kicklog (
  12.     id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  13.     pseudo_joueur VARCHAR(30) NOT NULL,
  14.     pseudo_admin VARCHAR(30) NOT NULL,
  15.     raison TEXT NOT NULL,
  16.     date_heure DATETIME NOT NULL,
  17.     PRIMARY KEY(id)
  18.     )
  19. ENGINE=INNODB;
  20.  
  21. CREATE TABLE IF NOT EXISTS Jaillog (
  22.     id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  23.     pseudo_joueur VARCHAR(30) NOT NULL,
  24.     pseudo_admin VARCHAR(30) NOT NULL,
  25.     temps_jail INT NOT NULL,
  26.     raison TEXT NOT NULL,
  27.     date_heure DATETIME NOT NULL,
  28.     PRIMARY KEY(id)
  29.     )
  30. ENGINE=INNODB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement