1234567891011121314151617181920 |
- :VERSION 1
- BEGIN;
- CREATE TABLE Avatars (
- PrincipalID CHAR(36) NOT NULL,
- Name VARCHAR(32) NOT NULL,
- Value VARCHAR(255) NOT NULL DEFAULT '',
- PRIMARY KEY(PrincipalID, Name),
- KEY(PrincipalID));
- COMMIT;
- :VERSION 2
- BEGIN;
- alter table Avatars change column Value Value text;
- COMMIT;
|