Rebranding tmwserv to manaserv

Includes a database update. Use update_6_to_7.sql to update existing
sqlite databases.

5 files changed, 331 insertions, 211 deletions

diff --git a/src/sql/mysql/createDatabase.sql b/src/sql/mysql/createDatabase.sql
index c40aa24..2a8ce6b 100644
--- a/src/sql/mysql/createDatabase.sql
+++ b/src/sql/mysql/createDatabase.sql
@@ -1,5 +1,5 @@
 /*
- *  The Mana World Server
+ *  The Mana Server
  *  Copyright 2008 The Mana World Development Team
  *
  *  This file is part of The Mana World.
@@ -16,19 +16,17 @@
  *  You should  have received a  copy of the  GNU General Public  License along
  *  with The Mana  World; if not, write to the  Free Software Foundation, Inc.,
  *  59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
- *
- *  $Id$
  */
 
-CREATE USER 'tmw'@'%' IDENTIFIED BY 'testtest';
-CREATE USER 'tmw'@'localhost' IDENTIFIED BY 'testtest';
+CREATE USER 'mana'@'%' IDENTIFIED BY 'testtest';
+CREATE USER 'mana'@'localhost' IDENTIFIED BY 'testtest';
 
-GRANT USAGE ON * . * TO 'tmw'@'%' IDENTIFIED BY 'testtest' 
+GRANT USAGE ON * . * TO 'mana'@'%' IDENTIFIED BY 'testtest'
 	WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
-GRANT USAGE ON * . * TO 'tmw'@'localhost' IDENTIFIED BY 'testtest' 
+GRANT USAGE ON * . * TO 'mana'@'localhost' IDENTIFIED BY 'testtest'
 	WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
 
-CREATE DATABASE IF NOT EXISTS `tmw` ;
+CREATE DATABASE IF NOT EXISTS `mana` ;
 
-GRANT ALL PRIVILEGES ON `tmw` . * TO 'tmw'@'%';
-GRANT ALL PRIVILEGES ON `tmw` . * TO 'tmw'@'localhost';
+GRANT ALL PRIVILEGES ON `mana` . * TO 'mana'@'%';
+GRANT ALL PRIVILEGES ON `mana` . * TO 'mana'@'localhost';
diff --git a/src/sql/mysql/createTables.sql b/src/sql/mysql/createTables.sql
index 9d6a738..98fbbcc 100644
--- a/src/sql/mysql/createTables.sql
+++ b/src/sql/mysql/createTables.sql
@@ -1,8 +1,8 @@
 --
--- table: `tmw_accounts`
+-- table: `mana_accounts`
 --
 
-CREATE TABLE IF NOT EXISTS `tmw_accounts` (
+CREATE TABLE IF NOT EXISTS `mana_accounts` (
     `id`           int(10)      unsigned NOT NULL auto_increment,
     `username`     varchar(64)           NOT NULL,
     `password`     varchar(64)           NOT NULL,
@@ -20,13 +20,13 @@ DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_characters`
+-- table: `mana_characters`
 --
 
-CREATE TABLE IF NOT EXISTS `tmw_characters` (
+CREATE TABLE IF NOT EXISTS `mana_characters` (
     `id`           int(10)      unsigned NOT NULL auto_increment,
     `user_id`      int(10)      unsigned NOT NULL,
-	`name`         varchar(32)           NOT NULL,
+    `name`         varchar(32)           NOT NULL,
     --
     `gender`       tinyint(3)   unsigned NOT NULL,
     `hair_style`   tinyint(3)   unsigned NOT NULL,
@@ -51,38 +51,38 @@ CREATE TABLE IF NOT EXISTS `tmw_characters` (
     UNIQUE KEY `name` (`name`),
     KEY `user_id` (`user_id`),
     FOREIGN KEY (`user_id`)
-    	REFERENCES `tmw_accounts` (`id`)
+    	REFERENCES `mana_accounts` (`id`)
     	ON DELETE CASCADE
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_char_skills`
+-- table: `mana_char_skills`
 --
-CREATE TABLE IF NOT EXISTS `tmw_char_skills` (
+CREATE TABLE IF NOT EXISTS `mana_char_skills` (
     `char_id`      int(10)      unsigned NOT NULL,
     `skill_id`     smallint(5)  unsigned NOT NULL,
     `skill_exp`    smallint(5)  unsigned NOT NULL,
     --
     PRIMARY KEY (`char_id`, `skill_id`),
     FOREIGN KEY (`char_id`)
-        REFERENCES `tmw_characters` (`id`)
+        REFERENCES `mana_characters` (`id`)
         ON DELETE CASCADE
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8;
 
 --
--- table: `tmw_char_status_effects`
+-- table: `mana_char_status_effects`
 --
-CREATE TABLE IF NOT EXISTS `tmw_char_status_effects` (
+CREATE TABLE IF NOT EXISTS `mana_char_status_effects` (
     `char_id`       int(10)         unsigned NOT NULL,
     `status_id`     smallint(5)     unsigned NOT NULL,
     `status_time`   int(10)         signed NOT NULL,
     --
     PRIMARY KEY (`char_id`, `status_id`),
     FOREIGN KEY (`char_id`)
-        REFERENCES `tmw_characters` (`id`)
+        REFERENCES `mana_characters` (`id`)
         ON DELETE CASCADE
 ) ENGING=InnoDB
 DEFAULT CHARSET=utf8;
@@ -91,9 +91,9 @@ DEFAULT CHARSET=utf8;
 
 
 --
--- table: `tmw_items`
+-- table: `mana_items`
 --
-CREATE TABLE IF NOT EXISTS `tmw_items` (
+CREATE TABLE IF NOT EXISTS `mana_items` (
     `id`           int(10)      unsigned NOT NULL auto_increment,
     `name`         varchar(100)          NOT NULL,
     `description`  varchar(255)          NOT NULL,
@@ -110,24 +110,24 @@ DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_item_instances`
+-- table: `mana_item_instances`
 --
-CREATE TABLE IF NOT EXISTS `tmw_item_instances` (
+CREATE TABLE IF NOT EXISTS `mana_item_instances` (
     `item_id`      int(10)      unsigned NOT NULL auto_increment,
     `itemclass_id` int(10)      unsigned NOT NULL,
     `amount`       tinyint(3)   unsigned NOT NULL,
     --
     PRIMARY KEY (`item_id`),
     FOREIGN KEY (`itemclass_id`)
-        REFERENCES `tmw_items` (`id`)
+        REFERENCES `mana_items` (`id`)
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_item_attributes`
+-- table: `mana_item_attributes`
 --
-CREATE TABLE IF NOT EXISTS `tmw_item_attributes` (
+CREATE TABLE IF NOT EXISTS `mana_item_attributes` (
     `attribute_id`    int(10)      unsigned NOT NULL auto_increment,
     `item_id`         int(10)      unsigned NOT NULL,
     `attribute_class` tinyint(3)   unsigned NOT NULL,
@@ -135,17 +135,17 @@ CREATE TABLE IF NOT EXISTS `tmw_item_attributes` (
     --
     PRIMARY KEY (`attribute_id`),
     FOREIGN KEY (`item_id`)
-        REFERENCES `tmw_item_instances` (`item_id`)
+        REFERENCES `mana_item_instances` (`item_id`)
         ON DELETE CASCADE
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_inventories`
--- todo: remove class_id and amount and reference on tmw_item_instances
+-- table: `mana_inventories`
+-- todo: remove class_id and amount and reference on mana_item_instances
 --
-CREATE TABLE IF NOT EXISTS `tmw_inventories` (
+CREATE TABLE IF NOT EXISTS `mana_inventories` (
     `id`           int(10)      unsigned NOT NULL auto_increment,
     `owner_id`     int(10)      unsigned NOT NULL,
     `slot`         tinyint(3)   unsigned NOT NULL,
@@ -155,16 +155,16 @@ CREATE TABLE IF NOT EXISTS `tmw_inventories` (
     PRIMARY KEY (`id`),
     UNIQUE KEY `owner_id` (`owner_id`, `slot`),
     FOREIGN KEY (`owner_id`)
-    	REFERENCES `tmw_characters` (`id`)
+    	REFERENCES `mana_characters` (`id`)
     	ON DELETE CASCADE
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_world_states`
+-- table: `mana_world_states`
 --
-CREATE TABLE IF NOT EXISTS `tmw_world_states` (
+CREATE TABLE IF NOT EXISTS `mana_world_states` (
     `state_name`   varchar(100)          NOT NULL,
     `map_id`       int(10)      unsigned default NULL,
     `value`        varchar(255)          default NULL,
@@ -174,14 +174,14 @@ CREATE TABLE IF NOT EXISTS `tmw_world_states` (
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8;
 
-INSERT INTO tmw_world_states VALUES('accountserver_startup',NULL,NULL,UNIX_TIMESTAMP());
-INSERT INTO tmw_world_states VALUES('accountserver_version',NULL,NULL,UNIX_TIMESTAMP());
-INSERT INTO tmw_world_states VALUES('database_version',     NULL,'3', UNIX_TIMESTAMP());
+INSERT INTO mana_world_states VALUES('accountserver_startup',NULL,NULL,UNIX_TIMESTAMP());
+INSERT INTO mana_world_states VALUES('accountserver_version',NULL,NULL,UNIX_TIMESTAMP());
+INSERT INTO mana_world_states VALUES('database_version',     NULL,'3', UNIX_TIMESTAMP());
 
 --
--- table: `tmw_guilds`
+-- table: `mana_guilds`
 --
-CREATE TABLE IF NOT EXISTS `tmw_guilds` (
+CREATE TABLE IF NOT EXISTS `mana_guilds` (
     `id`           int(10)      unsigned NOT NULL auto_increment,
     `name`         varchar(35)           NOT NULL,
     --
@@ -192,44 +192,44 @@ DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_guild_members`
+-- table: `mana_guild_members`
 --
-CREATE TABLE IF NOT EXISTS `tmw_guild_members` (
+CREATE TABLE IF NOT EXISTS `mana_guild_members` (
 	`guild_id`     int(10)      unsigned NOT NULL,
 	`member_id`    int(10)      unsigned NOT NULL,
 	`rights`       int(10)      unsigned NOT NULL,
 	--
 	PRIMARY KEY (`guild_id`, `member_id`),
 	FOREIGN KEY (`guild_id`)
-		REFERENCES `tmw_guilds` (`id`)
+		REFERENCES `mana_guilds` (`id`)
 		ON DELETE CASCADE,
 	FOREIGN KEY (`member_id`)
-		REFERENCES `tmw_characters` (`id`)
+		REFERENCES `mana_characters` (`id`)
 		ON DELETE CASCADE
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8;
 
 --
--- table: `tmw_quests`
+-- table: `mana_quests`
 --
 
-CREATE TABLE IF NOT EXISTS `tmw_quests` (
+CREATE TABLE IF NOT EXISTS `mana_quests` (
 	`owner_id`     int(10)      unsigned NOT NULL,
 	`name`         varchar(100)          NOT NULL,
 	`value`        varchar(200)          NOT NULL,
 	--
 	PRIMARY KEY (`owner_id`, `name`),
 	FOREIGN KEY (`owner_id`)
-		REFERENCES `tmw_characters` (`id`)
+		REFERENCES `mana_characters` (`id`)
 		ON DELETE CASCADE
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8;
 
 --
--- table: `tmw_auctions`
+-- table: `mana_auctions`
 --
 
-CREATE TABLE IF NOT EXISTS `tmw_auctions` (
+CREATE TABLE IF NOT EXISTS `mana_auctions` (
 	`auction_id`    int(10)      unsigned  NOT NULL auto_increment,
 	`auction_state` tinyint(3)   unsigned  NOT NULL,
 	`char_id`       int(10)      unsigned  NOT NULL,
@@ -247,17 +247,17 @@ CREATE TABLE IF NOT EXISTS `tmw_auctions` (
 	KEY (`itemclass_id`),
 	KEY (`char_id`),
 	FOREIGN KEY (`char_id`)
-		REFERENCES `tmw_characters` (`id`)
+		REFERENCES `mana_characters` (`id`)
 		ON DELETE CASCADE
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_auction_bids`
+-- table: `mana_auction_bids`
 --
 
-CREATE TABLE IF NOT EXISTS `tmw_auction_bids` (
+CREATE TABLE IF NOT EXISTS `mana_auction_bids` (
 	`bid_id`        int(10)      unsigned  NOT NULL auto_increment,
 	`auction_id`    int(10)      unsigned  NOT NULL,
 	`char_id`       int(10)      unsigned  NOT NULL,
@@ -268,17 +268,17 @@ CREATE TABLE IF NOT EXISTS `tmw_auction_bids` (
 	KEY (`auction_id`),
 	KEY (`char_id`),
 	FOREIGN KEY (`char_id`)
-		REFERENCES `tmw_characters` (`id`)
+		REFERENCES `mana_characters` (`id`)
 		ON DELETE CASCADE
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_post`
+-- table: `mana_post`
 --
 
-CREATE TABLE IF NOT EXISTS `tmw_post` (
+CREATE TABLE IF NOT EXISTS `mana_post` (
 	`letter_id`        int(10)      unsigned  NOT NULL auto_increment,
 	`sender_id`        int(10)      unsigned  NOT NULL,
 	`receiver_id`      int(10)      unsigned  NOT NULL,
@@ -292,20 +292,20 @@ CREATE TABLE IF NOT EXISTS `tmw_post` (
 	INDEX `fk_letter_receiver` (`receiver_id` ASC) ,
 	--
 	FOREIGN KEY (`sender_id` )
-		REFERENCES `tmw_characters` (`id`)
+		REFERENCES `mana_characters` (`id`)
 		ON DELETE CASCADE,
     FOREIGN KEY (`receiver_id` )
-		REFERENCES `tmw_characters` (`id`)
+		REFERENCES `mana_characters` (`id`)
 		ON DELETE CASCADE
 ) ENGINE = InnoDB
 DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_post_attachements`
+-- table: `mana_post_attachements`
 --
 
-CREATE TABLE IF NOT EXISTS `tmw_post_attachments` (
+CREATE TABLE IF NOT EXISTS `mana_post_attachments` (
 	`attachment_id`    int(10)      unsigned  NOT NULL auto_increment,
 	`letter_id`        int(10)      unsigned  NOT NULL,
 	`item_id`          int(10)      unsigned  NOT NULL,
@@ -315,32 +315,32 @@ CREATE TABLE IF NOT EXISTS `tmw_post_attachments` (
 	INDEX `fk_attachment_item` (`item_id` ASC),
 	--
 	FOREIGN KEY (`letter_id` )
-		REFERENCES `tmw_post` (`letter_id`)
+		REFERENCES `mana_post` (`letter_id`)
 		ON DELETE CASCADE,
 	FOREIGN KEY (`item_id` )
-		REFERENCES `tmw_item_instances` (`item_id`)
+		REFERENCES `mana_item_instances` (`item_id`)
 		ON DELETE RESTRICT
 ) ENGINE = InnoDB
 DEFAULT CHARSET=utf8
 AUTO_INCREMENT=1 ;
 
 --
--- table: `tmw_online_list`
+-- table: `mana_online_list`
 --
 
-CREATE TABLE IF NOT EXISTS `tmw_online_list` (
+CREATE TABLE IF NOT EXISTS `mana_online_list` (
     `char_id`      int(10)      unsigned NOT NULL,
     `login_date`   int(10)      NOT NULL,
     --
     PRIMARY KEY (`char_id`),
-    FOREIGN KEY (`char_id`) 
-    	REFERENCES `tmw_characters` (`id`)
+    FOREIGN KEY (`char_id`)
+    	REFERENCES `mana_characters` (`id`)
     	ON DELETE CASCADE
 ) ENGINE=InnoDB
 DEFAULT CHARSET=utf8 ;
 
 -- create a view to show more details about online users
-CREATE VIEW tmw_v_online_chars
+CREATE VIEW mana_v_online_chars
 AS
    SELECT l.char_id    as char_id,
           l.login_date as login_date,
@@ -349,12 +349,12 @@ AS
           c.gender     as gender,
           c.level      as level,
           c.map_id     as map_id
-     FROM tmw_online_list l
-     JOIN tmw_characters c
+     FROM mana_online_list l
+     JOIN mana_characters c
        ON l.char_id = c.id;
 
- 
-CREATE TABLE IF NOT EXISTS `tmw_transactions` (
+
+CREATE TABLE IF NOT EXISTS `mana_transactions` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `char_id` int(11) NOT NULL,
   `action` int(11) NOT NULL,
diff --git a/src/sql/postgresql/createTables.sql b/src/sql/postgresql/createTables.sql
index 0d95f38..6767fff 100644
--- a/src/sql/postgresql/createTables.sql
+++ b/src/sql/postgresql/createTables.sql
@@ -1,19 +1,19 @@
-CREATE TABLE tmw_accounts 
-( 
-   id           SERIAL      PRIMARY KEY, 
-   username     TEXT        NOT NULL UNIQUE, 
-   password     TEXT        NOT NULL, 
-   email        TEXT        NOT NULL, 
-   level        SMALLINT    NOT NULL, 
-   banned       SMALLINT    NOT NULL, 
-   registration INTEGER     NOT NULL, 
-   lastlogin    INTEGER     NOT NULL  
+CREATE TABLE mana_accounts
+(
+   id           SERIAL      PRIMARY KEY,
+   username     TEXT        NOT NULL UNIQUE,
+   password     TEXT        NOT NULL,
+   email        TEXT        NOT NULL,
+   level        SMALLINT    NOT NULL,
+   banned       SMALLINT    NOT NULL,
+   registration INTEGER     NOT NULL,
+   lastlogin    INTEGER     NOT NULL
 );
 
-CREATE INDEX tmw_accounts_username ON tmw_accounts ( username );
+CREATE INDEX mana_accounts_username ON mana_accounts ( username );
 
 
-CREATE TABLE tmw_characters 
+CREATE TABLE mana_characters
 (
    id           SERIAL      PRIMARY KEY,
    user_id      INTEGER     NOT NULL,
@@ -46,10 +46,10 @@ CREATE TABLE tmw_characters
    axe_exp      INTEGER     NOT NULL,
    thrown_exp   INTEGER     NOT NULL,
    --
-   FOREIGN KEY (user_id) REFERENCES tmw_accounts(id)
+   FOREIGN KEY (user_id) REFERENCES mana_accounts(id)
 );
 
-CREATE TABLE tmw_inventories 
+CREATE TABLE mana_inventories
 (
    id           SERIAL      PRIMARY KEY,
    owner_id     INTEGER     NOT NULL,
@@ -57,46 +57,46 @@ CREATE TABLE tmw_inventories
    class_id     INTEGER     NOT NULL,
    amount       SMALLINT    NOT NULL,
    --
-   FOREIGN KEY (owner_id) REFERENCES tmw_characters(id)
+   FOREIGN KEY (owner_id) REFERENCES mana_characters(id)
 );
 
-CREATE TABLE tmw_guilds 
+CREATE TABLE mana_guilds
 (
    id           SERIAL      PRIMARY KEY,
-   name 		TEXT        NOT NULL UNIQUE
+   name         TEXT        NOT NULL UNIQUE
 );
 
-CREATE TABLE tmw_guild_members 
+CREATE TABLE mana_guild_members
 (
    guild_id     INTEGER     NOT NULL,
    member_id    INTEGER     NOT NULL,
    rights       INTEGER     NOT NULL,
    --
-   FOREIGN KEY (guild_id)  REFERENCES tmw_guilds(id),
-   FOREIGN KEY (member_id) REFERENCES tmw_characters(id)
+   FOREIGN KEY (guild_id)  REFERENCES mana_guilds(id),
+   FOREIGN KEY (member_id) REFERENCES mana_characters(id)
 );
 
-CREATE INDEX tmw_guild_members_g ON tmw_guild_members ( guild_id );
-CREATE INDEX tmw_guild_members_m ON tmw_guild_members ( member_id );
+CREATE INDEX mana_guild_members_g ON mana_guild_members ( guild_id );
+CREATE INDEX mana_guild_members_m ON mana_guild_members ( member_id );
 
-CREATE TABLE tmw_quests 
+CREATE TABLE mana_quests
 (
    owner_id     INTEGER     NOT NULL,
    name         TEXT        NOT NULL,
    value        TEXT        NOT NULL,
    --
-   FOREIGN KEY (owner_id) REFERENCES tmw_characters(id)
+   FOREIGN KEY (owner_id) REFERENCES mana_characters(id)
 );
 
-CREATE TABLE tmw_world_states 
-( 
-   state_name   TEXT        PRIMARY KEY, 
-   map_id       INTEGER     NULL, 
-   value        TEXT        NULL, 
-   moddate      INTEGER     NOT NULL 
+CREATE TABLE mana_world_states
+(
+   state_name   TEXT        PRIMARY KEY,
+   map_id       INTEGER     NULL,
+   value        TEXT        NULL,
+   moddate      INTEGER     NOT NULL
 );
 
-INSERT INTO "tmw_world_states" VALUES('accountserver_startup',NULL,NULL,1221633910);
-INSERT INTO "tmw_world_states" VALUES('accountserver_version',NULL,NULL,1221633910);
+INSERT INTO "mana_world_states" VALUES('accountserver_startup',NULL,NULL,1221633910);
+INSERT INTO "mana_world_states" VALUES('accountserver_version',NULL,NULL,1221633910);
 
 
diff --git a/src/sql/sqlite/createTables.sql b/src/sql/sqlite/createTables.sql
index d71858f..9de3af3 100644
--- a/src/sql/sqlite/createTables.sql
+++ b/src/sql/sqlite/createTables.sql
@@ -1,5 +1,5 @@
 --
--- The Mana World Server
+-- The Mana Server
 -- Copyright 2009 The Mana World Development Team
 --
 -- This file is part of The Mana World.
@@ -22,7 +22,7 @@
 -- Tables
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_accounts
+CREATE TABLE mana_accounts
 (
    id            INTEGER     PRIMARY KEY,
    username      TEXT        NOT NULL UNIQUE,
@@ -36,12 +36,12 @@ CREATE TABLE tmw_accounts
    expiration    INTEGER         NULL
 );
 
-CREATE UNIQUE INDEX tmw_accounts_username ON tmw_accounts ( username );
-CREATE UNIQUE INDEX tmw_accounts_email    ON tmw_accounts ( email );
+CREATE UNIQUE INDEX mana_accounts_username ON mana_accounts ( username );
+CREATE UNIQUE INDEX mana_accounts_email    ON mana_accounts ( email );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_characters
+CREATE TABLE mana_characters
 (
    id           INTEGER     PRIMARY KEY,
    user_id      INTEGER     NOT NULL,
@@ -63,41 +63,41 @@ CREATE TABLE tmw_characters
    int          INTEGER     NOT NULL,
    will         INTEGER     NOT NULL,
    --
-   FOREIGN KEY (user_id) REFERENCES tmw_accounts(id)
+   FOREIGN KEY (user_id) REFERENCES mana_accounts(id)
 );
 
-CREATE INDEX tmw_characters_user ON tmw_characters ( user_id );
-CREATE UNIQUE INDEX tmw_characters_name ON tmw_characters ( name );
+CREATE INDEX mana_characters_user ON mana_characters ( user_id );
+CREATE UNIQUE INDEX mana_characters_name ON mana_characters ( name );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_char_skills
+CREATE TABLE mana_char_skills
 (
     char_id     INTEGER     NOT NULL,
     skill_id    INTEGER     NOT NULL,
     skill_exp   INTEGER     NOT NULL,
     --
-    FOREIGN KEY (char_id) REFERENCES tmw_characters(id)
+    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
 );
 
-CREATE INDEX tmw_char_skills_char ON tmw_char_skills ( char_id );
+CREATE INDEX mana_char_skills_char ON mana_char_skills ( char_id );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_char_status_effects
+CREATE TABLE mana_char_status_effects
 (
     char_id     INTEGER     NOT NULL,
     status_id   INTEGER     NOT NULL,
     status_time INTEGER     NOT NULL,
     --
-    FOREIGN KEY (char_id) REFERENCES tmw_characters(id)
+    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
 );
 
-CREATE INDEX tmw_char_status_char on tmw_char_status_effects ( char_id );
+CREATE INDEX mana_char_status_char on mana_char_status_effects ( char_id );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_items
+CREATE TABLE mana_items
 (
     id           INTEGER    PRIMARY KEY,
     name         TEXT       NOT NULL,
@@ -109,39 +109,39 @@ CREATE TABLE tmw_items
     dyestring    TEXT
 );
 
-CREATE INDEX tmw_items_type ON tmw_items (itemtype);
+CREATE INDEX mana_items_type ON mana_items (itemtype);
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_item_instances
+CREATE TABLE mana_item_instances
 (
     item_id       INTEGER    PRIMARY KEY,
     itemclass_id  INTEGER    NOT NULL,
     amount        INTEGER    NOT NULL,
     --
-    FOREIGN KEY (itemclass_id) REFERENCES tmw_items(id)
+    FOREIGN KEY (itemclass_id) REFERENCES mana_items(id)
 );
 
-CREATE INDEX tmw_item_instances_typ ON tmw_item_instances ( itemclass_id );
+CREATE INDEX mana_item_instances_typ ON mana_item_instances ( itemclass_id );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_item_attributes
+CREATE TABLE mana_item_attributes
 (
     attribute_id    INTEGER    PRIMARY KEY,
     item_id         INTEGER    NOT NULL,
     attribute_class INTEGER    NOT NULL,
     attribute_value TEXT,
     --
-    FOREIGN KEY (item_id) REFERENCES tmw_item_instances(item_id)
+    FOREIGN KEY (item_id) REFERENCES mana_item_instances(item_id)
 );
 
-CREATE INDEX tmw_item_attributes_item ON tmw_item_attributes ( item_id );
+CREATE INDEX mana_item_attributes_item ON mana_item_attributes ( item_id );
 
 -----------------------------------------------------------------------------
 
--- todo: remove class_id and amount and reference on tmw_item_instances
-CREATE TABLE tmw_inventories
+-- todo: remove class_id and amount and reference on mana_item_instances
+CREATE TABLE mana_inventories
 (
    id           INTEGER     PRIMARY KEY,
    owner_id     INTEGER     NOT NULL,
@@ -149,14 +149,14 @@ CREATE TABLE tmw_inventories
    class_id     INTEGER     NOT NULL,
    amount       INTEGER     NOT NULL,
    --
-   FOREIGN KEY (owner_id) REFERENCES tmw_characters(id)
+   FOREIGN KEY (owner_id) REFERENCES mana_characters(id)
 );
 
-CREATE INDEX tmw_inventories_owner ON tmw_inventories ( owner_id );
+CREATE INDEX mana_inventories_owner ON mana_inventories ( owner_id );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_guilds
+CREATE TABLE mana_guilds
 (
    id           INTEGER     PRIMARY KEY,
    name 		TEXT        NOT NULL UNIQUE
@@ -164,33 +164,33 @@ CREATE TABLE tmw_guilds
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_guild_members
+CREATE TABLE mana_guild_members
 (
    guild_id     INTEGER     NOT NULL,
    member_id    INTEGER     NOT NULL,
    rights       INTEGER     NOT NULL,
    --
-   FOREIGN KEY (guild_id)  REFERENCES tmw_guilds(id),
-   FOREIGN KEY (member_id) REFERENCES tmw_characters(id)
+   FOREIGN KEY (guild_id)  REFERENCES mana_guilds(id),
+   FOREIGN KEY (member_id) REFERENCES mana_characters(id)
 );
 
-CREATE INDEX tmw_guild_members_g ON tmw_guild_members ( guild_id );
-CREATE INDEX tmw_guild_members_m ON tmw_guild_members ( member_id );
+CREATE INDEX mana_guild_members_g ON mana_guild_members ( guild_id );
+CREATE INDEX mana_guild_members_m ON mana_guild_members ( member_id );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_quests
+CREATE TABLE mana_quests
 (
    owner_id     INTEGER     NOT NULL,
    name         TEXT        NOT NULL,
    value        TEXT        NOT NULL,
    --
-   FOREIGN KEY (owner_id) REFERENCES tmw_characters(id)
+   FOREIGN KEY (owner_id) REFERENCES mana_characters(id)
 );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_world_states
+CREATE TABLE mana_world_states
 (
    state_name   TEXT        PRIMARY KEY,
    map_id       INTEGER     NULL,
@@ -200,7 +200,7 @@ CREATE TABLE tmw_world_states
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_auctions
+CREATE TABLE mana_auctions
 (
    auction_id    INTEGER     PRIMARY KEY,
    auction_state INTEGER     NOT NULL,
@@ -214,16 +214,16 @@ CREATE TABLE tmw_auctions
    buyout_price  INTEGER,
    description   TEXT,
    --
-   FOREIGN KEY (char_id) REFERENCES tmw_characters(id)
+   FOREIGN KEY (char_id) REFERENCES mana_characters(id)
 );
 
-CREATE INDEX tmw_auctions_owner ON tmw_auctions ( char_id );
-CREATE INDEX tmw_auctions_state ON tmw_auctions ( auction_state );
-CREATE INDEX tmw_auctions_item  ON tmw_auctions ( itemclass_id );
+CREATE INDEX mana_auctions_owner ON mana_auctions ( char_id );
+CREATE INDEX mana_auctions_state ON mana_auctions ( auction_state );
+CREATE INDEX mana_auctions_item  ON mana_auctions ( itemclass_id );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_auction_bids
+CREATE TABLE mana_auction_bids
 (
    bid_id        INTEGER     PRIMARY KEY,
    auction_id    INTEGER     NOT NULL,
@@ -231,16 +231,16 @@ CREATE TABLE tmw_auction_bids
    bid_time      INTEGER     NOT NULL,
    bid_price     INTEGER     NOT NULL,
    --
-   FOREIGN KEY (auction_id) REFERENCES tmw_auctions(auction_id),
-   FOREIGN KEY (char_id)    REFERENCES tmw_characters(id)
+   FOREIGN KEY (auction_id) REFERENCES mana_auctions(auction_id),
+   FOREIGN KEY (char_id)    REFERENCES mana_characters(id)
 );
 
-CREATE INDEX tmw_auction_bids_auction ON tmw_auction_bids ( auction_id );
-CREATE INDEX tmw_auction_bids_owner   ON tmw_auction_bids ( char_id );
+CREATE INDEX mana_auction_bids_auction ON mana_auction_bids ( auction_id );
+CREATE INDEX mana_auction_bids_owner   ON mana_auction_bids ( char_id );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_post
+CREATE TABLE mana_post
 (
    letter_id        INTEGER   PRIMARY KEY,
    sender_id        INTEGER   NOT NULL,
@@ -250,42 +250,42 @@ CREATE TABLE tmw_post
    sending_date     INTEGER   NOT NULL,
    letter_text      TEXT          NULL,
    --
-   FOREIGN KEY (sender_id)   REFERENCES tmw_characters(id),
-   FOREIGN KEY (receiver_id) REFERENCES tmw_characters(id)
+   FOREIGN KEY (sender_id)   REFERENCES mana_characters(id),
+   FOREIGN KEY (receiver_id) REFERENCES mana_characters(id)
 );
 
-CREATE INDEX tmw_post_sender   ON tmw_post ( sender_id );
-CREATE INDEX tmw_post_receiver ON tmw_post ( receiver_id );
+CREATE INDEX mana_post_sender   ON mana_post ( sender_id );
+CREATE INDEX mana_post_receiver ON mana_post ( receiver_id );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_post_attachments
+CREATE TABLE mana_post_attachments
 (
    attachment_id    INTEGER   PRIMARY KEY,
    letter_id        INTEGER   NOT NULL,
    item_id          INTEGER   NOT NULL,
    --
-   FOREIGN KEY (letter_id) REFERENCES tmw_post(letter_id),
-   FOREIGN KEY (item_id)   REFERENCES tmw_item_instances(item_id)
+   FOREIGN KEY (letter_id) REFERENCES mana_post(letter_id),
+   FOREIGN KEY (item_id)   REFERENCES mana_item_instances(item_id)
 );
 
-CREATE INDEX tmw_post_attachments_ltr ON tmw_post_attachments ( letter_id );
-CREATE INDEX tmw_post_attachments_itm ON tmw_post_attachments ( item_id );
+CREATE INDEX mana_post_attachments_ltr ON mana_post_attachments ( letter_id );
+CREATE INDEX mana_post_attachments_itm ON mana_post_attachments ( item_id );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_transaction_codes
+CREATE TABLE mana_transaction_codes
 (
    id            INTEGER     PRIMARY KEY,
    description   TEXT        NOT NULL,
    category      TEXT        NOT NULL
 );
 
-CREATE INDEX tmw_transaction_codes_cat    ON tmw_transaction_codes ( category );
+CREATE INDEX mana_transaction_codes_cat    ON mana_transaction_codes ( category );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_transactions
+CREATE TABLE mana_transactions
 (
     id          INTEGER     PRIMARY KEY,
     char_id     INTEGER     NOT NULL,
@@ -293,22 +293,22 @@ CREATE TABLE tmw_transactions
     message     TEXT,
     time        INTEGER     NOT NULL,
     --
-    FOREIGN KEY (char_id) REFERENCES tmw_characters(id),
-    FOREIGN KEY (action)  REFERENCES tmw_transaction_codes(id)
+    FOREIGN KEY (char_id) REFERENCES mana_characters(id),
+    FOREIGN KEY (action)  REFERENCES mana_transaction_codes(id)
 );
 
-CREATE INDEX tmw_transactions_char    ON tmw_transactions ( char_id );
-CREATE INDEX tmw_transactions_action  ON tmw_transactions ( action );
-CREATE INDEX tmw_transactions_time    ON tmw_transactions ( time );
+CREATE INDEX mana_transactions_char    ON mana_transactions ( char_id );
+CREATE INDEX mana_transactions_action  ON mana_transactions ( action );
+CREATE INDEX mana_transactions_time    ON mana_transactions ( time );
 
 -----------------------------------------------------------------------------
 
-CREATE TABLE tmw_online_list
+CREATE TABLE mana_online_list
 (
     char_id     INTEGER     PRIMARY KEY,
     login_date  INTEGER     NOT NULL,
     --
-    FOREIGN KEY (char_id) REFERENCES tmw_characters(id)
+    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
 );
 
 -----------------------------------------------------------------------------
@@ -317,7 +317,7 @@ CREATE TABLE tmw_online_list
 
 -- List all online users
 
-CREATE VIEW tmw_v_online_chars
+CREATE VIEW mana_v_online_chars
 AS
    SELECT l.char_id    as char_id,
           l.login_date as login_date,
@@ -326,14 +326,14 @@ AS
           c.gender     as gender,
           c.level      as level,
           c.map_id     as map_id
-     FROM tmw_online_list l
-     JOIN tmw_characters c
+     FROM mana_online_list l
+     JOIN mana_characters c
        ON l.char_id = c.id;
 
 
 -- Show all stored transactions
 
-CREATE VIEW tmw_v_transactions
+CREATE VIEW mana_v_transactions
 AS
    SELECT t.id           as transaction_id,
           t.time         as transacition_time,
@@ -345,12 +345,12 @@ AS
           tc.description as action,
           tc.category    as category,
           t.message      as message
-     FROM tmw_transactions t
-     JOIN tmw_characters c
+     FROM mana_transactions t
+     JOIN mana_characters c
        ON t.char_id = c.id
-     JOIN tmw_accounts a
+     JOIN mana_accounts a
        ON c.user_id = a.id
-     JOIN tmw_transaction_codes tc
+     JOIN mana_transaction_codes tc
        ON t.action = tc.id;
 
 -----------------------------------------------------------------------------
@@ -359,41 +359,41 @@ AS
 
 -- initial world states and database version
 
-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,'6',  strftime('%s','now'));
+INSERT INTO mana_world_states VALUES('accountserver_startup',NULL,NULL, strftime('%s','now'));
+INSERT INTO mana_world_states VALUES('accountserver_version',NULL,NULL, strftime('%s','now'));
+INSERT INTO mana_world_states VALUES('database_version',     NULL,'7',  strftime('%s','now'));
 
 -- all known transaction codes
 
-INSERT INTO tmw_transaction_codes VALUES (  1, 'Character created',        'Character' );
-INSERT INTO tmw_transaction_codes VALUES (  2, 'Character selected',       'Character' );
-INSERT INTO tmw_transaction_codes VALUES (  3, 'Character deleted',        'Character' );
-INSERT INTO tmw_transaction_codes VALUES (  4, 'Public message sent',      'Chat' );
-INSERT INTO tmw_transaction_codes VALUES (  5, 'Public message annouced',  'Chat' );
-INSERT INTO tmw_transaction_codes VALUES (  6, 'Private message sent',     'Chat' );
-INSERT INTO tmw_transaction_codes VALUES (  7, 'Channel joined',           'Chat' );
-INSERT INTO tmw_transaction_codes VALUES (  8, 'Channel kicked',           'Chat' );
-INSERT INTO tmw_transaction_codes VALUES (  9, 'Channel MODE',             'Chat' );
-INSERT INTO tmw_transaction_codes VALUES ( 10, 'Channel QUIT',             'Chat' );
-INSERT INTO tmw_transaction_codes VALUES ( 11, 'Channel LIST',             'Chat' );
-INSERT INTO tmw_transaction_codes VALUES ( 12, 'Channel USERLIST',         'Chat' );
-INSERT INTO tmw_transaction_codes VALUES ( 13, 'Channel TOPIC',            'Chat' );
-INSERT INTO tmw_transaction_codes VALUES ( 14, 'Command BAN',              'Commands' );
-INSERT INTO tmw_transaction_codes VALUES ( 15, 'Command DROP',             'Commands' );
-INSERT INTO tmw_transaction_codes VALUES ( 16, 'Command ITEM',             'Commands' );
-INSERT INTO tmw_transaction_codes VALUES ( 17, 'Command MONEY',            'Commands' );
-INSERT INTO tmw_transaction_codes VALUES ( 18, 'Command SETGROUP',         'Commands' );
-INSERT INTO tmw_transaction_codes VALUES ( 19, 'Command SPAWN',            'Commands' );
-INSERT INTO tmw_transaction_codes VALUES ( 20, 'Command WARP',             'Commands' );
-INSERT INTO tmw_transaction_codes VALUES ( 21, 'Item picked up',           'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 22, 'Item used',                'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 23, 'Item dropped',             'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 24, 'Item moved',               'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 25, 'Target attacked',          'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 26, 'ACTION Changed',           'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 27, 'Trade requested',          'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 28, 'Trade ended',              'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 29, 'Trade money',              'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 30, 'Trade items',              'Actions' );
-INSERT INTO tmw_transaction_codes VALUES ( 31, 'Attribute increased',      'Character' );
-INSERT INTO tmw_transaction_codes VALUES ( 32, 'Attribute decreased',      'Character' );
+INSERT INTO mana_transaction_codes VALUES (  1, 'Character created',        'Character' );
+INSERT INTO mana_transaction_codes VALUES (  2, 'Character selected',       'Character' );
+INSERT INTO mana_transaction_codes VALUES (  3, 'Character deleted',        'Character' );
+INSERT INTO mana_transaction_codes VALUES (  4, 'Public message sent',      'Chat' );
+INSERT INTO mana_transaction_codes VALUES (  5, 'Public message annouced',  'Chat' );
+INSERT INTO mana_transaction_codes VALUES (  6, 'Private message sent',     'Chat' );
+INSERT INTO mana_transaction_codes VALUES (  7, 'Channel joined',           'Chat' );
+INSERT INTO mana_transaction_codes VALUES (  8, 'Channel kicked',           'Chat' );
+INSERT INTO mana_transaction_codes VALUES (  9, 'Channel MODE',             'Chat' );
+INSERT INTO mana_transaction_codes VALUES ( 10, 'Channel QUIT',             'Chat' );
+INSERT INTO mana_transaction_codes VALUES ( 11, 'Channel LIST',             'Chat' );
+INSERT INTO mana_transaction_codes VALUES ( 12, 'Channel USERLIST',         'Chat' );
+INSERT INTO mana_transaction_codes VALUES ( 13, 'Channel TOPIC',            'Chat' );
+INSERT INTO mana_transaction_codes VALUES ( 14, 'Command BAN',              'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 15, 'Command DROP',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 16, 'Command ITEM',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 17, 'Command MONEY',            'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 18, 'Command SETGROUP',         'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 19, 'Command SPAWN',            'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 20, 'Command WARP',             'Commands' );
+INSERT INTO mana_transaction_codes VALUES ( 21, 'Item picked up',           'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 22, 'Item used',                'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 23, 'Item dropped',             'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 24, 'Item moved',               'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 25, 'Target attacked',          'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 26, 'ACTION Changed',           'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 27, 'Trade requested',          'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 28, 'Trade ended',              'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 29, 'Trade money',              'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 30, 'Trade items',              'Actions' );
+INSERT INTO mana_transaction_codes VALUES ( 31, 'Attribute increased',      'Character' );
+INSERT INTO mana_transaction_codes VALUES ( 32, 'Attribute decreased',      'Character' );
diff --git a/src/sql/sqlite/updates/update_6_to_7.sql b/src/sql/sqlite/updates/update_6_to_7.sql
new file mode 100644
index 0000000..2a8b90e
--- /dev/null
+++ b/src/sql/sqlite/updates/update_6_to_7.sql
@@ -0,0 +1,122 @@
+
+-- rename tables to new prefix
+
+ALTER TABLE tmw_accounts RENAME TO mana_accounts;
+ALTER TABLE tmw_characters RENAME TO mana_characters;
+ALTER TABLE tmw_char_skills RENAME TO mana_char_skills;
+ALTER TABLE tmw_char_status_effects RENAME TO mana_char_status_effects;
+ALTER TABLE tmw_items RENAME TO mana_items;
+ALTER TABLE tmw_item_instances RENAME TO mana_item_instances;
+ALTER TABLE tmw_item_attributes RENAME TO mana_item_attributes;
+ALTER TABLE tmw_inventories RENAME TO mana_inventories;
+ALTER TABLE tmw_guilds RENAME TO mana_guilds;
+ALTER TABLE tmw_guild_members RENAME TO mana_guild_members;
+ALTER TABLE tmw_quests RENAME TO mana_quests;
+ALTER TABLE tmw_world_states RENAME TO mana_world_states;
+ALTER TABLE tmw_auctions RENAME TO mana_auctions;
+ALTER TABLE tmw_auction_bids RENAME TO mana_auction_bids;
+ALTER TABLE tmw_post RENAME TO mana_post;
+ALTER TABLE tmw_post_attachments RENAME TO mana_post_attachments;
+ALTER TABLE tmw_transaction_codes RENAME TO mana_transaction_codes;
+ALTER TABLE tmw_transactions RENAME TO mana_transactions;
+ALTER TABLE tmw_online_list RENAME TO mana_online_list;
+
+-- rename indexes (apparently have to drop and recreate)
+
+DROP INDEX tmw_accounts_username;
+DROP INDEX tmw_accounts_email;
+DROP INDEX tmw_characters_user;
+DROP INDEX tmw_characters_name;
+DROP INDEX tmw_char_skills_char;
+DROP INDEX tmw_char_status_char;
+DROP INDEX tmw_items_type;
+DROP INDEX tmw_item_instances_typ;
+DROP INDEX tmw_item_attributes_item;
+DROP INDEX tmw_inventories_owner;
+DROP INDEX tmw_guild_members_g;
+DROP INDEX tmw_guild_members_m;
+DROP INDEX tmw_auctions_owner;
+DROP INDEX tmw_auctions_state;
+DROP INDEX tmw_auctions_item;
+DROP INDEX tmw_auction_bids_auction;
+DROP INDEX tmw_auction_bids_owner;
+DROP INDEX tmw_post_sender;
+DROP INDEX tmw_post_receiver;
+DROP INDEX tmw_post_attachments_ltr;
+DROP INDEX tmw_post_attachments_itm;
+DROP INDEX tmw_transaction_codes_cat;
+DROP INDEX tmw_transactions_char;
+DROP INDEX tmw_transactions_action;
+DROP INDEX tmw_transactions_time;
+
+CREATE UNIQUE INDEX mana_accounts_username ON mana_accounts ( username );
+CREATE UNIQUE INDEX mana_accounts_email    ON mana_accounts ( email );
+CREATE INDEX mana_characters_user ON mana_characters ( user_id );
+CREATE UNIQUE INDEX mana_characters_name ON mana_characters ( name );
+CREATE INDEX mana_char_skills_char ON mana_char_skills ( char_id );
+CREATE INDEX mana_char_status_char on mana_char_status_effects ( char_id );
+CREATE INDEX mana_items_type ON mana_items (itemtype);
+CREATE INDEX mana_item_instances_typ ON mana_item_instances ( itemclass_id );
+CREATE INDEX mana_item_attributes_item ON mana_item_attributes ( item_id );
+CREATE INDEX mana_inventories_owner ON mana_inventories ( owner_id );
+CREATE INDEX mana_guild_members_g ON mana_guild_members ( guild_id );
+CREATE INDEX mana_guild_members_m ON mana_guild_members ( member_id );
+CREATE INDEX mana_auctions_owner ON mana_auctions ( char_id );
+CREATE INDEX mana_auctions_state ON mana_auctions ( auction_state );
+CREATE INDEX mana_auctions_item  ON mana_auctions ( itemclass_id );
+CREATE INDEX mana_auction_bids_auction ON mana_auction_bids ( auction_id );
+CREATE INDEX mana_auction_bids_owner   ON mana_auction_bids ( char_id );
+CREATE INDEX mana_post_sender   ON mana_post ( sender_id );
+CREATE INDEX mana_post_receiver ON mana_post ( receiver_id );
+CREATE INDEX mana_post_attachments_ltr ON mana_post_attachments ( letter_id );
+CREATE INDEX mana_post_attachments_itm ON mana_post_attachments ( item_id );
+CREATE INDEX mana_transaction_codes_cat    ON mana_transaction_codes ( category );
+CREATE INDEX mana_transactions_char    ON mana_transactions ( char_id );
+CREATE INDEX mana_transactions_action  ON mana_transactions ( action );
+CREATE INDEX mana_transactions_time    ON mana_transactions ( time );
+
+-- rename views (have to drop and recreate as well)
+
+DROP VIEW tmw_v_online_chars;
+DROP VIEW tmw_v_transactions;
+
+CREATE VIEW mana_v_online_chars
+AS
+   SELECT l.char_id    as char_id,
+          l.login_date as login_date,
+          c.user_id    as user_id,
+          c.name       as name,
+          c.gender     as gender,
+          c.level      as level,
+          c.map_id     as map_id
+     FROM mana_online_list l
+     JOIN mana_characters c
+       ON l.char_id = c.id;
+
+CREATE VIEW mana_v_transactions
+AS
+   SELECT t.id           as transaction_id,
+          t.time         as transacition_time,
+          a.id           as user_id,
+          a.username     as username,
+          c.id           as char_id,
+          c.name         as charname,
+          tc.id          as action_id,
+          tc.description as action,
+          tc.category    as category,
+          t.message      as message
+     FROM mana_transactions t
+     JOIN mana_characters c
+       ON t.char_id = c.id
+     JOIN mana_accounts a
+       ON c.user_id = a.id
+     JOIN mana_transaction_codes tc
+       ON t.action = tc.id;
+
+
+-- update the database version, and set date of update
+UPDATE mana_world_states
+   SET value      = '7',
+       moddate    = strftime('%s','now')
+ WHERE state_name = 'database_version';
+