CreateUserFriendsTable.sql 374 B

1234567891011
  1. SET FOREIGN_KEY_CHECKS=0;
  2. -- ----------------------------
  3. -- Table structure for users
  4. -- ----------------------------
  5. CREATE TABLE `userfriends` (
  6. `ownerID` VARCHAR(37) NOT NULL,
  7. `friendID` VARCHAR(37) NOT NULL,
  8. `friendPerms` INT NOT NULL,
  9. `datetimestamp` INT NOT NULL,
  10. UNIQUE KEY (`ownerID`, `friendID`)
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev.1';