diff options
| author | Blue <bluesansdouze@gmail.com> | 2010-01-10 00:28:20 +0100 |
|---|---|---|
| committer | Blue <bluesansdouze@gmail.com> | 2010-01-10 00:28:20 +0100 |
| commit | 4544e23b23fd722aeeeb99f37c7076e09cc037bb (patch) | |
| tree | 4ac8bbb6a27439f9a1ff87dec1a61bd5f01d5452 /src/sql/sqlite/createTables.sql | |
| parent | 9ad132534ada41efd7973f8ef52fe49bee769866 (diff) | |
| parent | 5c5abafd2b0dcbcdeefad625b03732949c56056f (diff) | |
| download | manaserv-4544e23b23fd722aeeeb99f37c7076e09cc037bb.tar.gz manaserv-4544e23b23fd722aeeeb99f37c7076e09cc037bb.tar.bz2 manaserv-4544e23b23fd722aeeeb99f37c7076e09cc037bb.tar.xz manaserv-4544e23b23fd722aeeeb99f37c7076e09cc037bb.zip | |
Merge branch 'master' of ssh://git@gitorious.org/mana/manaserv
Diffstat (limited to 'src/sql/sqlite/createTables.sql')
| -rw-r--r-- | src/sql/sqlite/createTables.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index 26881fd7..e3222da9 100644 --- a/src/sql/sqlite/createTables.sql +++ b/src/sql/sqlite/createTables.sql @@ -97,6 +97,19 @@ CREATE INDEX mana_char_status_char on mana_char_status_effects ( char_id ); ----------------------------------------------------------------------------- +CREATE TABLE mana_char_kill_stats +( + char_id INTEGER NOT NULL, + monster_id INTEGER NOT NULL, + kills INTEGER NOT NULL, + -- + FOREIGN KEY (char_id) REFERENCES mana_characters(id) +); + +CREATE INDEX mana_char_kill_stats_char on mana_char_status_effects ( char_id ); + +----------------------------------------------------------------------------- + CREATE TABLE mana_items ( id INTEGER PRIMARY KEY, |