Untitled

SQLite format 3@  nJ5n-âºHûöñìçâÝØÓÎÉÄ¿º=Q+indexsqlite_autoindex_mana_characters_1mana_charactersr3'indexmana_accounts_emailmana_accountsCREATE UNIQUE INDEX mana_accounts_email    ON mana_accounts ( email )x9'indexmana_accounts_usernamemana_accountsCREATE UNIQUE INDEX mana_accounts_username ON mana_accounts ( username )ƒT''†gtablemana_accountsmana_accountsCREATE TABLE mana_accounts
(
   id            INTEGER     PRIMARY KEY,
   username      TEXT        NOT NULL UNIQUE,
   password      TEXT        NOT NULL,
   email         TEXT        NOT NULL,
   level         INTEGER     NOT NULL,
   banned        INTEGER     NOT NULL,
   registration  INTEGER     NOT NULL,
   lastlogin     INTEGER     NOT NULL,
   authorization TEXT            NULL,
   expiration    INTEGER        G9B7<38.2+.&(""


×Œ½½=Q+indexsqlite_autoindex=Q+indexsqlite_autoindex_mana_characters_1mana_charactersrƒT''†gtablemana_accountsmana_accountsCREATE TABLE mana_accounts
(
   id            INTEGER     PRIMARY KEY,
   username      TEXT        NOT NULL UNIQUE,
   password      TEXT        NOT NULL,
   email         TEXT        NOT NULL,
   level         INTEGER     NOT NULL,
   banned        INTEGER     NOT NULL,
   registration  INTEGER     NOT NULL,
   lastlogin     INTEGER     NOT NULL,
   authorization TEXT            NULL,
   expiration    INTEGER         NULL
)9M'indexsqlite_autoindex_mana_accounts_1mana_accountsx9'indexmana_accounts_usernamemana_accountsCREATE UNIQUE INDEX mana_accounts_username ON mana_accounts ( username )r3'indexmana_accounts_emailmana_accountsCREATE UNIQUE INDEX mana_accounts_email    ON mana_accounts ( email )
WWÙŠS„++‰5tablemana_charactersmana_charactersCREATE TABLE mana_characters
(
   id           INTEGER     PRIMARY KEY,
   user_id      INTEGER     NOT NULL,
   name         TEXT        NOT NULL UNIQUE,
   gender       INTEGER     NOT NULL,
   hair_style   INTEGER     NOT NULL,
   hair_color   INTEGER     NOT NULL,
   level        INTEGER     NOT NULL,
   char_pts     INTEGER     NOT NULL,
   correct_pts  INTEGER     NOT NULL,
   x            INTEGER     NOT NULL,
   y            INTEGER     NOT NULL,
   map_id       INTEGER     NOT NULL,
   slot         INTEGER     NOT NULL,
   --
   FOREIGN KEY (user_id) REFERENCES mana_accounts(id)
)=Q+indexsqlite_autoindex_mana_characters_1mana_charactersp5+
indexmana_characters_usermana_characters
CREATE INDEX mana_characters_user ON mana_characters ( user_id )t5+indexmana_characters_namemana_charactersCREATE UNIQUE INDEX mana_characters_name ON mana_characters ( name )


øø‡ŠôG‚--ƒ3tablemana_char_skillsmana_char_skillsCREATE TABLE mana_char_skills
(
    char_id     INTEGER     NOT NULL,
    skill_id    INTEGER     NOT NULL,
    skill_exp   I‚	))ƒwtablemana_char_attrmana_char_attrCREATE TABLE mana_char_attr
(
   char_id      INTEGER     NOT NULL,
   attr_id      INTEGER     NOT NULL,
   attr_base    FLOAT       NOT NULL,
   attr_mod     FLOAT       NOT NULL,
   --
   FOREIGN KEY (char_id) REFERENCES mana_characters(id)
)l
3)	indexmana_char_attr_charmana_char_attrCREATE INDEX mana_char_attr_char ON mana_char_attr ( char_id )‚--ƒ3tablemana_char_skillsmana_char_skillsCREATE TABLE mana_char_skills
(
    char_id     INTEGER     NOT NULL,
    skill_id    INTEGER     NOT NULL,
    skill_exp   INTEGER     NOT NULL,
    --
    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
)t7-indexmana_char_skills_charmana_char_skillsCREATE INDEX mana_char_skills_char ON mana_char_skills ( char_id )


ÈÈãjy»»?5!indexmana_char_kill_stats_charmana_‚
==ƒCtablemana_char_status_effectsmana_char_status_effectsCREATE TA‚
==ƒCtablemana_char_status_effectsmana_char_status_effectsCREATE 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 mana_characters(id)
)7=!indexmana_char_status_charmana_char_status_effectsCREATE INDEX mana_char_status_char on mana_char_status_effects ( char_id )‚55ƒ;tablemana_char_kill_statsmana_char_kill_statsCREATE 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)
)?5!indexmana_char_kill_stats_charmana_char_kill_statsCREATE INDEX mana_char_kill_stats_char on mana_char_kill_stats ( char_id )


ŽŽŽÓQ¤Š‚P!!„ktablemana_itemsmana_itemsCRE}11ƒ%tablemana_char_specialsmana_char_specialsCREATE TABLE mana_char_specials
(
    char_id     INTEGER     NOT NULL,
    special_id  INTEGER     NOT NULL,
	PRIMARY KEY (char_id, special_id),
    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
)CW1indexsqlite_autoindex_mana_char_specials_1mana_char_specials|;1indexmana_char_specials_charmana_char_specialsCREATE INDEX mana_char_specials_char on mana_char_specials ( char_id )‚P!!„ktablemana_itemsmana_itemsCREATE TABLE mana_items
(
    id           INTEGER    PRIMARY KEY,
    name         TEXT       NOT NULL,
    description  TEXT       NOT NULL,
    image        TEXT       NOT NULL,
    weight       INTEGER    NOT NULL,
    itemtype     TEXT       NOT NULL,
    effect       TEXT,
    dyestring    TEXT
)Z+!windexmana_items_typemana_itemsCREATE INDEX mana_items_type ON mana_items (itemtype)


££µ;yGC?5!indexmana_item_attributes_itemmana_item_attributes CREATE INDEX mana_item_attribut‚33ƒEtablemana_item_instancesmana_item_instancesCREATE TABLE mana_item_instances
(
    item_id       INTEGER    PRIMARY KEY,
    itemclass_id  INTEGER    NOT NULL,
    amount        INTEGER    NOT NULL,
    --
    FOREIGN KEY (itemclass_id) REFERENCES mana_items(id)
);3%indexmana_item_instances_typmana_item_instancesCREATE INDEX mana_item_instances_typ ON mana_item_instances ( itemclass_id )‚;55„tablemana_item_attributesmana_item_attributesCREATE 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 mana_item_instances(item_id)
)?5!indexmana_item_attributes_itemmana_item_attributes CREATE INDEX mana_item_attributes_item ON mana_item_attributes ( item_id )


bbŸðiÉ'‚:--„'tablemana_char_equipsmana_char_equips!CREATE ‚:--„'tablemana_char_equipsmana_char_equips!CREATE TABLE mana_char_equips
(
    id               INTEGER    PRIMARY KEY,
    owner_id         INTEGER    NOT NULL,
    slot_type        INTEGER    NOT NULL,
    inventory_slot   INTEGER    NOT NULL,
    --
    FOREIGN KEY (owner_id) REFERENCES mana_characters(id)
)‚N--„Otablemana_inventoriesmana_inventories#CREATE TABLE mana_inventories
(
   id           INTEGER     PRIMARY KEY,
   owner_id     INTEGER     NOT NULL,
   slot         INTEGER     NOT NULL,
   class_id     INTEGER     NOT NULL,
   amount       INTEGER     NOT NULL,
   --
   FOREIGN KEY (owner_id) REFERENCES mana_characters(id)
)w9-indexmana_inventories_ownermana_inventories$CREATE INDEX mana_inventories_owner ON mana_inventories ( owner_id )##otablemana_guildsmana_guilds%CREATE TABLE mana_guilds
(
   id           INTEGER     PRIMARY KEY,
   name         TEXT        NOT NULL UNIQUE
)


££Ú“
\\A$U/indexsqlite_autoindex_mana_world_states_1mana_world_states-5I#indexsqlite_autoindex_mana_guilds_1mana_guilds&‚=11„%tablemana_guild_membersmana_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 mana_guilds(id),
   FOREIGN KEY (member_id) REFERENCES mana_characters(id)
)w 51indexmana_guild_members_gmana_guild_members)CREATE INDEX mana_guild_members_g ON mana_guild_members ( guild_id )x!51indexmana_guild_members_mmana_guild_members*CREATE INDEX mana_guild_members_m ON mana_guild_members ( member_id )p"##ƒ'tablemana_questsmana_quests+CREATE TABLE mana_quests
(
   owner_id     INTEGER     NOT NULL,
   name         TEXT        NOT NULL,
   value        TEXT        NOT NULL,
   --
   FOREIGN KEY (owner_id) REFERENCES mana_characters(id)
)


£àÀ£-database_version14M‰737accountserver_versionM‰737accountserver_startupM‰73
·æÌ·-database_version7accountserver_version7accountserver_startup
__Eˆ”c#//‚utablemana_world_statesmana_world_states,CREATE TABLE mana_world_states
(
   state_name   TEXT        PRIMARY KEY,
   map_id       INTEGER     NULL,
   value        TEXT        NULL,
   moddate      INTEGER     NOT NULL
)A$U/indexsqlite_autoindex_mana_world_states_1mana_world_states-„	%''‡Qtablemana_auctionsmana_auctions/CREATE TABLE mana_auctions
(
   auction_id    INTEGER     PRIMARY KEY,
   auction_state INTEGER     NOT NULL,
   char_id       INTEGER     NOT NULL,
   itemclass_id  INTEGER     NOT NULL,
   amount        INTEGER     NOT NULL,
   start_time    INTEGER     NOT NULL,
   end_time      INTEGER     NOT NULL,
   start_price   INTEGER     NOT NULL,
   min_price     INTEGER,
   buyout_price  INTEGER,
   description   TEXT,
   --
   FOREIGN KEY (char_id) REFERENCES mana_characters(id)
)j&3'indexmana_auctions_ownermana_auctions0CREATE INDEX mana_auctions_owner ON mana_auctions ( char_id )


ñaþ‚{p'3'indexmana_auctions_statemana_auctions1CREATE INDEX mana_auctions_state ON mana_auctions ( auction_state )n(1'indexmana_auctions_itemmana_auctions3CREATE INDEX mana_auctions_item  ON mana_auctions ( itemclass_id )ƒ)//…ctablemana_auction_bidsmana_auction_bids4CREATE TABLE mana_auction_bids
(
   bid_id        INTEGER     PRIMARY KEY,
   auction_id    INTEGER     NOT NULL,
   char_id       INTEGER     NOT NULL,
   bid_time      INTEGER     NOT NULL,
   bid_price     INTEGER     NOT NULL,
   --
   FOREIGN KEY (auction_id) REFERENCES mana_auctions(auction_id),
   FOREIGN KEY (char_id)    REFERENCES mana_characters(id)
)*?/!indexmana_auction_bids_auctionmana_auction_bids5CREATE INDEX mana_auction_bids_auction ON mana_auction_bids ( auction_id )|+;/indexmana_auction_bids_ownermana_auction_bids6CREATE INDEX mana_auction_bids_owner   ON mana_auction_bids ( char_id )


bb8šäàd.1indexmana_post_receivermana_post:CREATE INDEX mana_post_receiver ON mana_post ( receiver_id )|+;/indexmana_auctiƒS,†utablemana_postmana_post7CREATE TABLE mana_post
(
   letter_id        INTEGER   PRIMARY KEY,
   sender_id        INTEGER   NOT NULL,
   receiver_id      INTEGER   NOT NULL,
   letter_type      INTEGER   NOT NULL,
   expiration_date  INTEGER   NOT NULL,
   sending_date     INTEGER   NOT NULL,
   letter_text      TEXT          NULL,
   --
   FOREIGN KEY (sender_id)   REFERENCES mana_characters(id),
   FOREIGN KEY (receiver_id) REFERENCES mana_characters(id)
)`--indexmana_post_sendermana_post9CREATE INDEX mana_post_sender   ON mana_post ( sender_id )d.1indexmana_post_receivermana_post:CREATE INDEX mana_post_receiver ON mana_post ( receiver_id )


!!•o‚]/77„Ytablemana_post_attachmentsmana_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 mana_post(letter_id),
   FOREIGN KEY (item_id)   REFERENCES mana_item_instances(item_id)
)0?7'indexmana_post_attachments_ltrmana_post_attachments=CREATE INDEX mana_post_attachments_ltr ON mana_post_attachments ( letter_id )1?7#indexmana_post_attachments_itmmana_post_attachments>CREATE INDEX mana_post_attachments_itm ON mana_post_attachments ( item_id )W299‚Itablemana_transaction_codesmana_transaction_codes?CREATE TABLE mana_transaction_codes
(
   id            INTEGER     PRIMARY KEY,
   description   TEXT        NOT NULL,
   category      TEXT        NOT NULL
)3A9/indexmana_transaction_codes_catmana_transaction_codes@CREATE INDEX mana_transaction_codes_cat    ON mana_transaction_codes ( category )

ûJû‚aC+ýçÑ· ‡mS8ÿåÊ´›„hM1éÇ¥‹rS#/Command INVISIBLECommands"#Command EXPCommands!%Command MUTECommands  3Attribute decreasedCharacter 3Attribute increasedCharacter#Trade itemsActions#Trade moneyActions#Trade endedActions+Trade requestedActions)ACTION ChangedActions+Target attackedActions!Item movedActions%Item droppedActionsItem usedActions)Item picked upActions%Command WARPCommands'Command SPAWNCommands-Command SETGROUPCommands'Command MONEYCommands%Command ITEMCommands%Command DROPCommands#Command BANCommands
'Channel TOPICChat-Channel USERLISTChat%Channel LISTChat
%Channel QUITChat	%Channel MODEChat)Channel kickedChat)Channel joinedChat5Private message sentChat;Public message annoucedChat3Public message sentChat/Character deletedCharacter1Character selectedCharacter/Character createdCharI#
6o	ýñåÙÍÁµ©òäÖ›ÍÄ»²© —Ž…|obUH;.!€sfYL?2%þñä×Ê½°£–‰|oCommands6Commands5Commands4Commands3Commands2Commands1Commands0Commands/Commands.Commands-Commands,Commands+Commands*Commands)Commands(Commands'Commands&Commands%Commands$Commands#Commands"Commands!
Character
CharacterActionsActionsActionsActionsActionsActionsActionsActionsActionsActionsCommandsCommandsCommandsCommandsCommandsCommandsCommandsChat
ChatChatChat
Chat	ChatChatChatChatChat
Character
Character
Character

‹† !ƒ4//…5tablemana_transactionsmana_transactionsACREATE TABLE mana_transactions
(
    id          INTEGER     PRIMARY KEY,
    char_id     INTEGER     NOT NULL,
    action      INTEGER     NOT NULL,
    message     TEXT,
  ƒ4//…5tablemana_transactionsmana_transactionsACREATE TABLE mana_transactions
(
    id          INTEGER     PRIMARY KEY,
    char_id     INTEGER     NOT NULL,
    action      INTEGER     NOT NULL,
    message     TEXT,
    time        INTEGER     NOT NULL,
    --
    FOREIGN KEY (char_id) REFERENCES mana_characters(id),
    FOREIGN KEY (action)  REFERENCES mana_transaction_codes(id)
){59/indexmana_transactions_charmana_transactionsCCREATE INDEX mana_transactions_char    ON mana_transactions ( char_id )|6=/indexmana_transactions_actionmana_transactionsDCREATE INDEX mana_transactions_action  ON mana_transactions ( action )x79/indexmana_transactions_timemana_transactionsECREATE INDEX mana_transactions_time    ON mana_transactions ( time )


……e]8--‚mtablemana_online_listmana_online_listFCREATE TABLE mana_online_list
(
    char_id     INTEGER     PRIMARY KEY,
    login_date  INTEGER     NOT NULL,
    --
    FOREIGN KEY (char_id) REFERENCES mana_characters(id)
)ƒ933…Yviewmana_v_online_charsmana_v_online_charsCREATE 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
ZZ…#:33‰oviewmana_v_transactionsmana_v_transactionsCREATE 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
#Sà¿Ÿ‚aC+ýçÑ· ‡mS8ÿåÊ´›„hM1éÇ¥‹rS#/Command INVISIBLECommands"#Command EXPCommands!%Command MUTECommands  3Attribute decreasedCharacter 3Attribute increasedCharacter#Trade itemsActions#Trade moneyActions#Trade endedActions+Trade requestedActions)ACTION ChangedActions+Target attackedActions!Item movedActions%Item droppedActionsItem usedActions)Item picked upActions%Command WARPCommands'Command SPAWNCommands-Command SETGROUPCommands'Command MONEYCommands%Command ITEMCommands%Command DROPCommands#Command BANCommands
'Channel TOPICChat-Channel USERLISTChat%Channel LISTChat
%Channel QUITChat	%Channel MODEChat)Channel kickedChat)Channel joinedChat5Private message sentChat;Public message annoucedChat3Public message sentChat/Character deletedCharacter1Character selectedCharacter/Character createdCharacter
ÈäÆ¢ˆpW6äÉ©‰fD"âÈ6%Command KICKCommands5/Command ATTRIBUTECommands43Command RESTART_ALLCommands 35Command RESTART_THISCommands 25Command SHUTDOWN_ALLCommands!17Command SHUTDOWN_THISCommands01Command WIPE_LEVELCommands/1Command WIPE_ITEMSCommands.'Command IPBANCommands-)Command GOPREVCommands,)Command GONEXTCommands+%Command GOTOCommands*3Command KILLMONSTERCommands)#Command LOGCommands(!Command FXCommands'%Command KILLCommands"&9Command ANNOUNCE_LOCALCommands%-Command ANNOUNCECommands$)Command COMBATCommands