int init() { int ret; /* ret = sqlite3_exec(db, "DROP TABLE IF EXISTS songs", NULL, 0, NULL); if (ret != SQLITE_OK) { fprintf(stderr, "%s\n", sqlite3_errmsg(db)); exit(-1); } */ ret = sqlite3_exec(db, "CREATE TABLE IF NOT EXISTS songs (\ id INTEGER PRIMARY KEY, file TEXT, artist TEXT, album TEXT, title TEXT, year INTEGER, genre TEXT, track TEXT, type TEXT, lastupdate NUMBER, \ UNIQUE (artist, album, title));", NULL, 0, NULL); if (ret != SQLITE_OK) { fprintf(stderr, "%s\n", sqlite3_errmsg(db)); exit(-1); } ret = sqlite3_exec(db, "CREATE VIEW IF NOT EXISTS albums AS\ SELECT artist, album, count(*) songs, year, genre FROM songs GROUP BY album", NULL, 0, NULL); if (ret != SQLITE_OK) { fprintf(stderr, "%s\n", sqlite3_errmsg(db)); exit(-1); } reg_num = pcre_compile("^[0-9]+$", 0, &error, &erroffset, NULL); if (reg_num == NULL) { fprintf(stderr, "%s at %d\n", error, erroffset); return -1; } return 0; }
#if 0 INSERT INTO version (table_name, table_version) values ('uacreg','1'); CREATE TABLE uacreg ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, l_uuid VARCHAR(64) NOT NULL, l_username VARCHAR(64) NOT NULL, l_domain VARCHAR(128) DEFAULT '' NOT NULL, r_username VARCHAR(64) NOT NULL, r_domain VARCHAR(128) NOT NULL, realm VARCHAR(64) NOT NULL, auth_username VARCHAR(64) NOT NULL, auth_password VARCHAR(64) NOT NULL, auth_proxy VARCHAR(128) DEFAULT '' NOT NULL, expires INT(10) UNSIGNED DEFAULT 0 NOT NULL, CONSTRAINT l_uuid_idx UNIQUE (l_uuid) ) ENGINE=MyISAM; #endif extern struct tm_binds uac_tmb; extern pv_spec_t auth_username_spec; extern pv_spec_t auth_realm_spec; extern pv_spec_t auth_password_spec; counter_handle_t regtotal; /* Total number of registrations in memory */ counter_handle_t regactive; /* Active registrations - 200 OK */ counter_handle_t regdisabled; /* Disabled registrations */ /* Init counters */ static void uac_reg_counter_init()
#define NR_KEYS 3 int mt_fetch_rows = 1000; /** database connection */ static db1_con_t *db_con = NULL; static db_func_t mt_dbf; #if 0 INSERT INTO version (table_name, table_version) values ('mtree','1'); CREATE TABLE mtree ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, tprefix VARCHAR(32) NOT NULL, tvalue VARCHAR(128) DEFAULT '' NOT NULL, CONSTRAINT tprefix_idx UNIQUE (tprefix) ) ENGINE=MyISAM; INSERT INTO version (table_name, table_version) values ('mtrees','1'); CREATE TABLE mtrees ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, tname VARCHAR(128) NOT NULL, tprefix VARCHAR(32) NOT NULL, tvalue VARCHAR(128) DEFAULT '' NOT NULL, CONSTRAINT tname_tprefix_idx UNIQUE (tname, tprefix) ) ENGINE=MyISAM; #endif /** parameters */ static str db_url = str_init(DEFAULT_DB_URL); static str db_table = str_init("mtrees"); static str tname_column = str_init("tname");