vg_strnull( &q, buf, 512 );
vg_strcat( &q, "CREATE TABLE IF NOT EXISTS \n \"" );
vg_strcat( &q, table );
- vg_strcat( &q, "\"\n (steamid BIGINT PRIMARY KEY, time INT);" );
+ vg_strcat( &q, "\"\n (steamid BIGINT UNIQUE, time INT);" );
if( !vg_strgood(&q) ) return 0;
vg_str str;
sqlite3_stmt *stmt = db_stmt(
"CREATE TABLE IF NOT EXISTS \n"
- " users(steamid BIGINT PRIMARY KEY, name VARCHAR(128), type INT);" );
+ " users(steamid BIGINT UNIQUE, name VARCHAR(128), type INT);" );
if( stmt ){
int fc = sqlite3_step( stmt );
}
static db_request *db_alloc_request( u32 size ){
- u32 total = sizeof(db_request) + vg_align8(size);
+ u32 total = sizeof(db_request) + size;
pthread_mutex_lock( &database.mux );
- vg_queue_frame *frame = vg_queue_alloc( &database.queue, size );
+ vg_queue_frame *frame = vg_queue_alloc( &database.queue, total );
if( frame ){
db_request *req = (db_request *)frame->data;