UserAccount.migrations 824 B

12345678910111213141516171819202122232425262728293031
  1. :VERSION 5 # -------------------------
  2. BEGIN;
  3. CREATE TABLE IF NOT EXISTS `UserAccounts` (
  4. `PrincipalID` char(36) NOT NULL,
  5. `ScopeID` char(36) NOT NULL,
  6. `FirstName` varchar(64) NOT NULL,
  7. `LastName` varchar(64) NOT NULL,
  8. `Email` varchar(64) DEFAULT NULL,
  9. `ServiceURLs` text,
  10. `Created` int(11) DEFAULT NULL,
  11. `UserLevel` int(11) NOT NULL DEFAULT '0',
  12. `UserFlags` int(11) NOT NULL DEFAULT '0',
  13. `UserTitle` varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  14. UNIQUE KEY `PrincipalID` (`PrincipalID`),
  15. KEY `Email` (`Email`),
  16. KEY `FirstName` (`FirstName`),
  17. KEY `LastName` (`LastName`),
  18. KEY `Name` (`FirstName`,`LastName`)
  19. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  20. COMMIT;
  21. :VERSION 6 # -------------------------
  22. BEGIN;
  23. ALTER TABLE `UserAccounts` ADD `active` INT NOT NULL DEFAULT '1';
  24. COMMIT;