configs/sql-init-scripts/sqlite/clientprefs-sqlite.sql
author Nicholas Hastings <skamonkey@gmail.com>
Sat Aug 10 12:22:09 2013 -0400 (2013-08-10)
changeset 3981 af3681eade3f
parent 2048 2454ff4d6afb
permissions -rw-r--r--
Debug build fixes.
     1 CREATE TABLE sm_cookies
     2 (
     3 	id INTEGER PRIMARY KEY AUTOINCREMENT,
     4 	name varchar(30) NOT NULL UNIQUE,
     5 	description varchar(255),
     6 	access INTEGER
     7 );
     8 
     9 CREATE TABLE sm_cookie_cache
    10 (
    11 	player varchar(65) NOT NULL,
    12 	cookie_id int(10) NOT NULL,
    13 	value varchar(100),
    14 	timestamp int,
    15 	PRIMARY KEY (player, cookie_id)
    16 );