Avatar.migrations 295 B

1234567891011121314151617181920
  1. :VERSION 1
  2. BEGIN;
  3. CREATE TABLE Avatars (
  4. PrincipalID CHAR(36) NOT NULL,
  5. Name VARCHAR(32) NOT NULL,
  6. Value VARCHAR(255) NOT NULL DEFAULT '',
  7. PRIMARY KEY(PrincipalID, Name),
  8. KEY(PrincipalID));
  9. COMMIT;
  10. :VERSION 2
  11. BEGIN;
  12. alter table Avatars change column Value Value text;
  13. COMMIT;