Task #1332

« Previous | 32 of 303 | Next »

schema migration in Rails app for kamailio 4.0 upgrade

Added by lee over 4 years ago. Updated over 4 years ago.

Status:FeedbackStart date:05/21/2013
Priority:HighDue date:
Assignee:lee% Done:

0%

Category:-Spent time:-
Target version:OSTel Operations
Component:

Description

ALTER TABLE domains ADD COLUMN did VARCHAR(64) DEFAULT NULL;

INSERT INTO version (table_name, table_version) values ('domain_attrs','1');
CREATE TABLE domain_attrs (
    id SERIAL PRIMARY KEY NOT NULL,
    did VARCHAR(64) NOT NULL,
    name VARCHAR(32) NOT NULL,
    type INTEGER NOT NULL,
    value VARCHAR(255) NOT NULL,
    last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '1900-01-01 00:00:01' NOT NULL,
    CONSTRAINT domain_attrs_domain_attrs_idx UNIQUE (did, name, value)
);

grant select on domain_attrs to ostel;

History

#1 Updated by lee over 4 years ago

  • Status changed from In Progress to Feedback

waiting to push changes post-merge of master

Also available in: Atom PDF