12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455 |
- BEGIN TRANSACTION;
- CREATE TABLE alembic_version (
- version_num VARCHAR(32) NOT NULL,
- CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
- );
- GO
- -- Running upgrade -> a2e9769475e
- CREATE TABLE voicemail_messages (
- dir VARCHAR(255) NOT NULL,
- msgnum INTEGER NOT NULL,
- context VARCHAR(80) NULL,
- macrocontext VARCHAR(80) NULL,
- callerid VARCHAR(80) NULL,
- origtime INTEGER NULL,
- duration INTEGER NULL,
- recording IMAGE NULL,
- flag VARCHAR(30) NULL,
- category VARCHAR(30) NULL,
- mailboxuser VARCHAR(30) NULL,
- mailboxcontext VARCHAR(30) NULL,
- msg_id VARCHAR(40) NULL
- );
- GO
- ALTER TABLE voicemail_messages ADD CONSTRAINT voicemail_messages_dir_msgnum PRIMARY KEY (dir, msgnum);
- GO
- CREATE INDEX voicemail_messages_dir ON voicemail_messages (dir);
- GO
- INSERT INTO alembic_version (version_num) VALUES ('a2e9769475e');
- GO
- -- Running upgrade a2e9769475e -> 39428242f7f5
- ALTER TABLE voicemail_messages ALTER COLUMN recording IMAGE;
- GO
- UPDATE alembic_version SET version_num='39428242f7f5' WHERE alembic_version.version_num = 'a2e9769475e';
- GO
- COMMIT;
- GO
|