ccme-mgmt.sql

CREATE TABLE "dirnums" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE  DEFAULT 1, "dirnum_id" INTEGER NOT NULL  UNIQUE , "type" TEXT NOT NULL  DEFAULT "dual-line", "dirnum" INTEGER NOT NULL  UNIQUE , "label" TEXT, "name" TEXT, "pickupgroup" INTEGER DEFAULT 1, "corlist_in" TEXT DEFAULT StandardUser, "corlist_out" TEXT, "transfer_mode" TEXT DEFAULT consult, "ephone_dn_template" INTEGER DEFAULT 1, "last_edit_by" TEXT, "last_edit_date" DATETIME NOT NULL  DEFAULT CURRENT_TIMESTAMP, "raw_cfg_pickle" BLOB);
CREATE TABLE "handset_speeddials" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "handset_id" INTEGER NOT NULL , "sd_num" INTEGER NOT NULL , "sd_label" TEXT NOT NULL , "sd_number" TEXT NOT NULL , "sd_type" TEXT);
CREATE TABLE "handsets" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "ephone_id" INTEGER NOT NULL  UNIQUE , "desc" TEXT, "mac-address" TEXT NOT NULL  UNIQUE , "ephone-template" INTEGER DEFAULT 1, "type" INTEGER NOT NULL , "button" TEXT, "cred_user" TEXT, "cred_pass" TEXT, "raw_cfg_pickle" BLOB);