search

AdaHeads / call-flow-control

Call-information flow server.
Other
6 stars 8 forks source link

Create a table for storing dial-plans in our database schema #70

Closed sparre closed 11 years ago

sparre commented 11 years ago

SQLite:

CREATE TABLE Dial_Plans (Phone_Number TEXT NOT NULL PRIMARY KEY,
                         Dial_Plan    TEXT NOT NULL);

PostgreSQL:

CREATE TABLE Dial_Plans (Phone_Number character varying (120) NOT NULL PRIMARY KEY,
                         Dial_Plan    XML NOT NULL);
ALTER TABLE public.Dial_Plans OWNER TO alice;