| author | David Anderson <dvander@alliedmods.net> |
| Sun Jul 06 04:49:55 2008 +0000 (2008-07-06) | |
| branch | refac-jit |
| changeset 2168 | c24a6fa957db |
| permissions | -rw-r--r-- |
| dvander@2168 | 1 |
CREATE TABLE sm_cookies |
| dvander@2168 | 2 |
( |
| dvander@2168 | 3 |
id INTEGER PRIMARY KEY AUTOINCREMENT, |
| dvander@2168 | 4 |
name varchar(30) NOT NULL UNIQUE, |
| dvander@2168 | 5 |
description varchar(255), |
| dvander@2168 | 6 |
access INTEGER |
| dvander@2168 | 7 |
); |
| dvander@2168 | 8 |
|
| dvander@2168 | 9 |
CREATE TABLE sm_cookie_cache |
| dvander@2168 | 10 |
( |
| dvander@2168 | 11 |
player varchar(65) NOT NULL, |
| dvander@2168 | 12 |
cookie_id int(10) NOT NULL, |
| dvander@2168 | 13 |
value varchar(100), |
| dvander@2168 | 14 |
timestamp int, |
| dvander@2168 | 15 |
PRIMARY KEY (player, cookie_id) |
| dvander@2168 | 16 |
); |