You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
kamailio/utils/kamctl/postgres/domain-create.sql

9 lines
312 B

INSERT INTO version (table_name, table_version) values ('domain','1');
CREATE TABLE domain (
id SERIAL PRIMARY KEY NOT NULL,
domain VARCHAR(64) DEFAULT '' NOT NULL,
last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '1900-01-01 00:00:01' NOT NULL,
CONSTRAINT domain_domain_idx UNIQUE (domain)
);