Stendhal Achievement Development: Difference between revisions
Jump to navigation
Jump to search
Content deleted Content added
imported>Madmetzger |
imported>Madmetzger |
||
| Line 18: | Line 18: | ||
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 STRING, |
|||
| ⚫ | |||
title STRING, |
title STRING, |
||
| ⚫ | |||
| ⚫ | |||
description STRING, |
|||
PRIMARY KEY(id) |
|||
) |
|||
CREATE TABLE reached_achievement IF NOT EXISTS ( |
|||
id INTEGER AUTO_INCREMENT NOT NULL, |
|||
charname STRING, |
|||
| ⚫ | |||
achievement_id INTEGER, |
|||
PRIMARY KEY(id) |
PRIMARY KEY(id) |
||
) |
) |
||