| author | Matt Woodrow <pred@alliedmods.net> |
| Thu Apr 17 04:58:09 2008 +0000 (2008-04-17) | |
| changeset 2009 | 1a1236dfdbb1 |
| child 2048 | 2454ff4d6afb |
| permissions | -rw-r--r-- |
| pred@2009 | 1 |
CREATE TABLE sm_cookies |
| pred@2009 | 2 |
( |
| pred@2009 | 3 |
id INTEGER PRIMARY KEY AUTOINCREMENT, |
| pred@2009 | 4 |
name varchar(30) NOT NULL UNIQUE, |
| pred@2009 | 5 |
description varchar(255) |
| pred@2009 | 6 |
); |
| pred@2009 | 7 |
|
| pred@2009 | 8 |
CREATE TABLE sm_cookie_cache |
| pred@2009 | 9 |
( |
| pred@2009 | 10 |
player varchar(65) NOT NULL, |
| pred@2009 | 11 |
cookie_id int(10) NOT NULL, |
| pred@2009 | 12 |
value varchar(100), |
| pred@2009 | 13 |
timestamp int, |
| pred@2009 | 14 |
PRIMARY KEY (player, cookie_id) |
| pred@2009 | 15 |
); |