FriendsStore.migrations 439 B

1234567891011121314
  1. :VERSION 4 # -------------------------
  2. BEGIN;
  3. CREATE TABLE IF NOT EXISTS `Friends` (
  4. `PrincipalID` varchar(255) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  5. `Friend` varchar(255) NOT NULL,
  6. `Flags` varchar(16) NOT NULL DEFAULT '0',
  7. `Offered` varchar(32) NOT NULL DEFAULT '0',
  8. PRIMARY KEY (`PrincipalID`(36),`Friend`(36)),
  9. KEY `PrincipalID` (`PrincipalID`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  11. COMMIT;