Stendhal Achievement Development: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Blacklads |
imported>Madmetzger |
||
| Line 23: | Line 23: | ||
CREATE TABLE achievement IF NOT EXISTS ( |
CREATE TABLE achievement IF NOT EXISTS ( |
||
id INTEGER AUTO_INCREMENT NOT NULL, |
id INTEGER AUTO_INCREMENT NOT NULL, |
||
identifier |
identifier VARCHAR, |
||
title |
title VARCHAR, |
||
category |
category VARCHAR, |
||
description |
description VARCHAR, |
||
PRIMARY KEY(id) |
PRIMARY KEY(id) |
||
) |
) |
||
CREATE TABLE reached_achievement IF NOT EXISTS ( |
CREATE TABLE reached_achievement IF NOT EXISTS ( |
||
id INTEGER AUTO_INCREMENT NOT NULL, |
id INTEGER AUTO_INCREMENT NOT NULL, |
||
charname |
charname VARCHAR, |
||
timedate TIMESTAMP default CURRENT_TIMESTAMP, |
timedate TIMESTAMP default CURRENT_TIMESTAMP, |
||
achievement_id INTEGER, |
achievement_id INTEGER, |
||