dvander@2168: CREATE TABLE sm_cookies dvander@2168: ( dvander@2168: id INTEGER PRIMARY KEY AUTOINCREMENT, dvander@2168: name varchar(30) NOT NULL UNIQUE, dvander@2168: description varchar(255), dvander@2168: access INTEGER dvander@2168: ); dvander@2168: dvander@2168: CREATE TABLE sm_cookie_cache dvander@2168: ( dvander@2168: player varchar(65) NOT NULL, dvander@2168: cookie_id int(10) NOT NULL, dvander@2168: value varchar(100), dvander@2168: timestamp int, dvander@2168: PRIMARY KEY (player, cookie_id) dvander@2168: );