kamailio/utils/kamctl/db_sqlite/uid_gflags-create.sql
Daniel-Constantin Mierla 784f73b880 kamctl: db sql files updated after xsl changes
- insert statement for version is after creation of the table
2015-12-04 21:59:11 +01:00

11 lines
355 B
SQL

CREATE TABLE uid_global_attrs (
id INTEGER PRIMARY KEY NOT NULL,
name VARCHAR(32) NOT NULL,
type INTEGER DEFAULT 0 NOT NULL,
value VARCHAR(128),
flags INTEGER DEFAULT 0 NOT NULL,
CONSTRAINT uid_global_attrs_global_attrs_idx UNIQUE (name, value)
);
INSERT INTO version (table_name, table_version) values ('uid_global_attrs','1');