Stendhal Achievement Development: Difference between revisions
Content deleted Content added
imported>Madmetzger |
imported>Madmetzger |
||
Line 18:
CREATE TABLE achievement IF NOT EXISTS (
id INTEGER AUTO_INCREMENT NOT NULL,
category STRING,▼
title STRING,
▲ category STRING,
timedate TIMESTAMP default CURRENT_TIMESTAMP▼
description STRING,
PRIMARY KEY(id)
)
CREATE TABLE reached_achievement IF NOT EXISTS (
id INTEGER AUTO_INCREMENT NOT NULL,
charname STRING,
▲ timedate TIMESTAMP default CURRENT_TIMESTAMP,
achievement_id INTEGER,
PRIMARY KEY(id)
)
| |||