1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/configs/sql-init-scripts/sqlite/clientprefs-sqlite.sql	Sun Jul 06 04:49:55 2008 +0000
     1.3 @@ -0,0 +1,16 @@
     1.4 +CREATE TABLE sm_cookies
     1.5 +(
     1.6 +	id INTEGER PRIMARY KEY AUTOINCREMENT,
     1.7 +	name varchar(30) NOT NULL UNIQUE,
     1.8 +	description varchar(255),
     1.9 +	access INTEGER
    1.10 +);
    1.11 +
    1.12 +CREATE TABLE sm_cookie_cache
    1.13 +(
    1.14 +	player varchar(65) NOT NULL,
    1.15 +	cookie_id int(10) NOT NULL,
    1.16 +	value varchar(100),
    1.17 +	timestamp int,
    1.18 +	PRIMARY KEY (player, cookie_id)
    1.19 +);
    1.20 \ No newline at end of file