| author | Scott Ehlert <ds@alliedmods.net> |
| Sun Sep 14 03:43:26 2008 -0500 (2008-09-14) | |
| changeset 2290 | f734bfbd3bf5 |
| parent 2048 | 2454ff4d6afb |
| permissions | -rw-r--r-- |
| pred@2009 | 1 |
CREATE TABLE sm_cookies |
| pred@2009 | 2 |
( |
| pred@2009 | 3 |
id INTEGER unsigned NOT NULL auto_increment, |
| pred@2009 | 4 |
name varchar(30) NOT NULL UNIQUE, |
| pred@2009 | 5 |
description varchar(255), |
| pred@2048 | 6 |
access INTEGER, |
| pred@2009 | 7 |
PRIMARY KEY (id) |
| pred@2009 | 8 |
); |
| pred@2009 | 9 |
|
| pred@2009 | 10 |
CREATE TABLE sm_cookie_cache |
| pred@2009 | 11 |
( |
| pred@2009 | 12 |
player varchar(65) NOT NULL, |
| pred@2009 | 13 |
cookie_id int(10) NOT NULL, |
| pred@2009 | 14 |
value varchar(100), |
| pred@2009 | 15 |
timestamp int NOT NULL, |
| pred@2009 | 16 |
PRIMARY KEY (player, cookie_id) |
| pred@2009 | 17 |
); |