AgentPrefs.migrations 583 B

123456789101112131415161718
  1. :VERSION 1 # -------------------------
  2. BEGIN;
  3. CREATE TABLE `AgentPrefs` (
  4. `PrincipalID` CHAR(36) NOT NULL,
  5. `AccessPrefs` CHAR(2) NOT NULL DEFAULT 'M',
  6. `HoverHeight` DOUBLE(30, 27) NOT NULL DEFAULT 0,
  7. `Language` CHAR(5) NOT NULL DEFAULT 'en-us',
  8. `LanguageIsPublic` BOOLEAN NOT NULL DEFAULT 1,
  9. `PermEveryone` INT(6) NOT NULL DEFAULT 0,
  10. `PermGroup` INT(6) NOT NULL DEFAULT 0,
  11. `PermNextOwner` INT(6) NOT NULL DEFAULT 532480,
  12. UNIQUE KEY `PrincipalID` (`PrincipalID`),
  13. PRIMARY KEY(`PrincipalID`)
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  15. COMMIT;