| author | Matt Woodrow <pred@alliedmods.net> |
| Mon May 12 08:06:47 2008 +0000 (2008-05-12) | |
| changeset 2048 | 2454ff4d6afb |
| parent 2009 | 1a1236dfdbb1 |
| 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@2048 | 5 |
description varchar(255), |
| pred@2048 | 6 |
access INTEGER |
| pred@2009 | 7 |
); |
| pred@2009 | 8 |
|
| pred@2009 | 9 |
CREATE TABLE sm_cookie_cache |
| pred@2009 | 10 |
( |
| pred@2009 | 11 |
player varchar(65) NOT NULL, |
| pred@2009 | 12 |
cookie_id int(10) NOT NULL, |
| pred@2009 | 13 |
value varchar(100), |
| pred@2009 | 14 |
timestamp int, |
| pred@2009 | 15 |
PRIMARY KEY (player, cookie_id) |
| pred@2009 | 16 |
); |