Advertisement
Guest User

[C++]: Phasing System(SQLS), By Tommy/QQrofl

a guest
Apr 1st, 2012
1,330
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.80 KB | None | 0 0
  1. SET FOREIGN_KEY_CHECKS=0;
  2.  
  3. -- ----------------------------
  4. -- Table structure for `phase`
  5. -- ----------------------------
  6. DROP TABLE IF EXISTS `phase`;
  7. CREATE TABLE `phase` (
  8.   `guid` INT(10) UNSIGNED NOT NULL,
  9.   `player_name` VARCHAR(12) NOT NULL,
  10.   `phase` INT(11) NOT NULL,
  11.   `phase_owned` INT(11) NOT NULL,
  12.   `get_phase` INT(10) NOT NULL,
  13.   `has_completed` tinyint(3) NOT NULL,
  14.   PRIMARY KEY  (`guid`)
  15. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  16.  
  17. -- ----------------------------
  18. -- Table structure for `phase_members`
  19. -- ----------------------------
  20. DROP TABLE IF EXISTS `phase_members`;
  21. CREATE TABLE `phase_members` (
  22.   `guid` INT(10) UNSIGNED NOT NULL,
  23.   `player_name` longtext NOT NULL,
  24.   `can_build_in_phase` INT(11) NOT NULL,
  25.   `phase` INT(11) NOT NULL
  26. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement