1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/configs/sql-init-scripts/sqlite/clientprefs-sqlite.sql	Thu Apr 17 04:58:09 2008 +0000
     1.3 @@ -0,0 +1,15 @@
     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 +);
    1.10 +
    1.11 +CREATE TABLE sm_cookie_cache
    1.12 +(
    1.13 +	player varchar(65) NOT NULL,
    1.14 +	cookie_id int(10) NOT NULL,
    1.15 +	value varchar(100),
    1.16 +	timestamp int,
    1.17 +	PRIMARY KEY (player, cookie_id)
    1.18 +);
    1.19 \ No newline at end of file