kamailio/utils/kamctl/db_sqlite/standard-create.sql
2020-03-14 18:34:10 +01:00

9 lines
278 B
SQL

CREATE TABLE version (
id INTEGER PRIMARY KEY NOT NULL,
table_name VARCHAR(32) NOT NULL,
table_version INTEGER DEFAULT 0 NOT NULL,
CONSTRAINT version_table_name_idx UNIQUE (table_name)
);
INSERT INTO version (table_name, table_version) values ('version','1');