diff options
| author | David Athay <ko2fan@gmail.com> | 2009-03-30 10:56:47 +0100 |
|---|---|---|
| committer | David Athay <ko2fan@gmail.com> | 2009-03-30 10:56:47 +0100 |
| commit | 67cc90165693e445c6b45b4e381148516237c09c (patch) | |
| tree | 684264c576e4812e36c6a3a6987d4b1167fc3c1c /src/sql | |
| parent | 59cdf04f88eb515fa349404992652ed004e9bb3e (diff) | |
| parent | 3a54fb903f9cc2cc47a852dab6569848d19c6dad (diff) | |
| download | manaserv-67cc90165693e445c6b45b4e381148516237c09c.tar.gz manaserv-67cc90165693e445c6b45b4e381148516237c09c.tar.bz2 manaserv-67cc90165693e445c6b45b4e381148516237c09c.tar.xz manaserv-67cc90165693e445c6b45b4e381148516237c09c.zip | |
Merge branch 'master' of git@gitorious.org:tmwserv/mainline
Diffstat (limited to 'src/sql')
| -rw-r--r-- | src/sql/sqlite/createTables.sql | 4 | ||||
| -rw-r--r-- | src/sql/sqlite/updates/update_2_to_3.sql | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql index 11478d9b..1831c45a 100644 --- a/src/sql/sqlite/createTables.sql +++ b/src/sql/sqlite/createTables.sql @@ -142,7 +142,7 @@ CREATE TABLE tmw_world_states INSERT INTO tmw_world_states VALUES('accountserver_startup',NULL,NULL, strftime('%s','now')); INSERT INTO tmw_world_states VALUES('accountserver_version',NULL,NULL, strftime('%s','now')); -INSERT INTO tmw_world_states VALUES('database_version', NULL,'2', strftime('%s','now')); +INSERT INTO tmw_world_states VALUES('database_version', NULL,'3', strftime('%s','now')); CREATE TABLE tmw_auctions ( @@ -218,7 +218,7 @@ CREATE TABLE tmw_transactions char_id INTEGER NOT NULL, action INTEGER NOT NULL, message TEXT, - time INTEGER NOT NULL, + time INTEGER NOT NULL ); CREATE TABLE tmw_online_list diff --git a/src/sql/sqlite/updates/update_2_to_3.sql b/src/sql/sqlite/updates/update_2_to_3.sql index f8fdfc91..55441eb5 100644 --- a/src/sql/sqlite/updates/update_2_to_3.sql +++ b/src/sql/sqlite/updates/update_2_to_3.sql @@ -6,7 +6,7 @@ CREATE TABLE tmw_transactions char_id INTEGER NOT NULL, action INTEGER NOT NULL, message TEXT, - time INTEGER NOT NULL, + time INTEGER NOT NULL ); -- update the database version, and set date of update |