kamailio/utils/kamctl/db_sqlite/htable-create.sql
2024-09-06 10:16:50 +02:00

10 lines
352 B
SQL

CREATE TABLE htable (
id INTEGER PRIMARY KEY NOT NULL,
key_name VARCHAR(256) DEFAULT '' NOT NULL,
key_type INTEGER DEFAULT 0 NOT NULL,
value_type INTEGER DEFAULT 0 NOT NULL,
key_value VARCHAR(512) DEFAULT '' NOT NULL,
expires INTEGER DEFAULT 0 NOT NULL
);
INSERT INTO version (table_name, table_version) values ('htable','2');