Ir para conteúdo
  • 0

ERRO ao importar meu database no MYSQL


BorgesRicardo

Pergunta

Quando vou importar meu database (ja estou usando ele no sqlite, o server ja está funcionando e não queria resetar) na página phpMyAdmin da o seguinte erro:

 

 

Erro

 

Talvez tenha encontrado um bug no analizador (parser) do SQL. Analise a sua Consulta SQL com atenção, e verifique se as aspas estão corretas e não estão desencontradas. Outra possibilidade de falha é o fato de estar tentando subir um arquivo com saída binária de uma área de texto citada. Pode também experimentar a sua consulta SQL no prompt de comandos do MySQL. A saída de erro do MySQL, isto se existir alguma, também poderá ajudar a diagnosticar o problema. Se continuar a ter problemas ou se o analisador (parser) falhar onde a interface da linha de comandos tiver sucesso, reduza por favor a entrada da consulta SQL até aquele que causou o problema, e envie o relatório de bug com os dados do chunk da seção CORTE abaixo:

----INICIO CORTE----

eNrtnX1sG+Udx+/u8UviRul7TVtaLmpHm7UJcdJQmmqCJDhpaF5aJ+kLHYSLfU2PnH3u3TlNutHR

vLWwAYOBkCa0Df5AmzppaNImNmlj2kB7+aMggSaEQCCQBtvQBJsEaEhoz3MXpz7Hie2QZmnu+5Hy

Oz/289ydn3uex5d7fP6EI5GuSIPYHBKba8X2cGeDGKoXQzeLoT2h+rqaQHcPfZELBLqP0Fe2t8Ua

ROO0mpR0Q9arVaW/OnkqKYbqQqG9Ym1Nzb6qUKiKFa9rqK9pqKu9U1Tl+D5xe6BjpPtwe4NYXx2q

3hMK9HZHxK7u3WJja7izZ7d4JEw3cVRJiN2NLY2RNpqrprq+bm/gUEdjg1hXXVu9J3DowCGWbXdX

N1tJXXVIPNrW2dkTaG/sbG0Qk2a/XpUyT1bdErA2Q4NiyuJJTY9LpljHeTie524TRY4f/IKz8LxM

QynHCbvpkueukPl4Trz073piskdbyefkE/Ix+ZC8T94lb5HXyavkMvkzeZG8QH5NfkGeI5fIs+Rp

8hR5kjxGHiIXyRg5R0aswgAsE7xbjtBwfS8Nm7tp2HSIho2dNFx3kIZgGw0bWmlYH6ZhXTMNaxtp

WHPjgLmfLlc30LByLw3le+jqmupoYC+F6HIv66e1O2mo3kZDpchek+LJ/Vvog4pNNGzdQMN162hY

vZKGQCnr4L4AjQJ5hyMf0QAAWFaUC6SClxNRfSRpKlqCK+dpOtbfNyTrBk0H7f7/Lkc/nd9FbQGw

7EYAxwAglDv6P8/6fxlPP/9fp2fhjxCF3Hg6pZn7hTeEJ4S7hH3COv4jHicG13oTKPPw/JYVXJMW

F+/VBjT7GK+gT4YDXJMcF4eUREwTJU1sVbV+SRWbtXhSipratgDN01qamUcMDylqt3bSFLtM+i8u

bUf22krZ2krmXNvNJTRP3O/M06EMi0c1XY2JVWLTCEtaK68Q0zsrVjT7vTx/3uvjuuV7JbE/s3RT

pEUbFmurxYg8pKmp99/TRPoy2y8lpumyIcZksUfpV6SKFp9X4M+X8jcIM9cyvQ8FrCfsZTtT6uW+

3Gq2e2hdtHlmWctxLaVrplFxA6G5biU5ck3lsE7xBZqpQ+COympUi8uiqYnmKVls0fQBzTTlhNht

HaYKKy/P8vKZeXty5bWGBfJDjnxG/zH4gLxDh4dXyJ/I78jzdJj4MX0BAPD/osQj8Dwdynx+2p35

FVyZtQxwK6xlKRewliVcqbX0cyXW0sf5raWX81pLD+exloQj1lLgBGvJc9ZpgZf8kSOfkn+St8mr

9CEA4Noi4KX92ePh2hsefCbAzjg8hGv/6pN7Auy8wiNwB8+99KsAO33w8NzB+86W+9npAbvCb/f/

33PkE/J38iZ5mT4EAFwzlHlZr7a7vtdO2H3fYyfszk/shN37hVIvb3d/6/Of86AWAXDliQP989F/

IPgS/mf8P4TnhPfJS26sh/PbeX9wxw5+1G9K/apsX/Dqi2qJk8qAIyE0R8KNPWGxp7GpPSzal8Qc

GeynxJ2BUvuR49kjjZHmA42RnXX1lWJnV4/Y2dveLt4ebmnsbe8Rd+zYnS40JKkpeapMW2dPuDUc

mc5PM/V2th3uDYs7Z26hMlC5T/AFO3bwnJKIycPGaVUx5T4pZWpWus+xr30hR5Kcbyb+4LZt/GhH

Zi3ENTOW8dAzew2wl7PfvxKb/X3Yr5xhl9L6Zs03XT810yVMedicyt0TPtYzS1U6aym9/t1irq3S

eqv3+IJt2/LUG3uH07XGEt7zJ7x2y0ll1pkuRzU95kj4Zq83O0N2zTmeXcjaU+KyYUrxZKENLHNH

cldf+tmsVbPW6CugNdobmK5XO+lnYxPhjnLcUf5T8vKCdfWxLX5/sLKSn8g6YElNNw1nqmSuQ2bl

yNvaD0XaOhojx8WD4eNf4pAlVWmEbrSoIpoxXFTukaJyn1249pajiF27+bt4OrcUM/KuPFA51lvi

D27Zwk/eZx15KRrVUgnTSC9X5Dja6deKOc4z+2hCistZnwC19RkfAVcqVjKMM1c6fZ7MuhyPSSNG

4dWqSoZJSxReQI5LijrXzuQ6HIPySHaRmlwlaq4U6Ve16KCcfttNXV3t4cbOuXbsjKQnlMRAEe99

QNdSyQJ6UGjG8Hfl6NHx7KZSX7B5y2zjWbq59IXSj8rY1yMJ+ZiNPC321yNx1gnAcibcScPt7Lub

zZsEdpmF/Is9fcBeAACWLa0BcgMvqye1hEzPOW5hn//ryZM0Cvumbo94znGDxFPkMnmWXMq4TeJp

KzsA4OrhvekeGiN7aTh2gobuG1Xr7osq+y4Mrp3dQnH0CA1HDtPQe5CGHnbDhvX9qtvog9A++tRh

9jF/qJqGrp30OZHdldG5lYaOjTQcZLdg3FFGQ5vfPhP4iG37TnsBAFhGiJs9e3n+dtkw9ZRC08dX

eII8f4dspAyOjhjcqoKvR0znm7qQUEBOVR6S1UIub0zNMWhRiX1TvPBLKKdkSTVP5d1CTXaJuDRc

TCF5OCnripyIykVc2dK0wX4tNpJ/O44iJ2XZLLIIfUuxIouocv4LVVlFzJFk3ncfqrvZUUaKxbRE

EVfE4tJAQU0ms0RCKuZIsvxFHnxWxEjKCbPwvTK0VBHvwdTOJAroTEvn8nlUS8QU1lHTh7apvatp

5g5HpSKurxvycHFXjVVtQEkUVYQNh6ZSzD5JQ3K+C8BXRi9jMKUWcdSt7Gwioog5CCkxWEBDGUgp

aiyhRAeLvUw+Va1aqoimzuarjOKue/dLqlTUUMqmapQC+nl9qLaGMV0wpuhytJBPlNqMYcsw+gof

7zMHCqtosQOSVcgYVFTVKLoY7YempCRkvfiiiinHiyrFpnbkRBGzfVpCpbuWnjBr6zxOy8w9kuu6

Ig0U0SySuhbXijtfiMmqbBYzqxOTjaiuJDO2UkBvmm2yJj0n7diLSlqgpSsSbmvttKbqduY+yaoU

I+GWcCTc2RzunmUm0DkPWBmotL5Kw93Pcffz9h04vcJPhA/IHxbz/PPRYMAf3LyZf8ZrzXDa08bG

1CKQY35z6qVFmt4sdOKbvpOVVSt8wcbNs020Te13X2jqQfno4TJ/cNcufvx45txu35CSVBU6ojmT

a2af6U1nya6Rwk/DF352f0Yjz96Z3WLOFV21xp57vdlbn7narNY2owt9LeALHt6VZ3I1fYSm51jT

T6w9f6zc+mbH6KDVBgasuxL7DFPT6UjnTK3L0QKcObIbwJVZ7QU88pnf88oz1NXMHOumd2nW7zTt

X+kLdlXOVqHON9wXcqbXe63rVf9l48rX7QUAwBWceOSIfb36Pyx1t70AACxv7mI/3iBsFfgE7g0C

wL2g/wPgXuz//z9nD++xFwAAd9DnsSY0yA848iF5m1wmvyGXaAIAsAQo82zk+aNSwpRjnGe1ZxvP

sx/4i8hSUtYNzrvKU8HzHYphiM2qEh3kfNYTTZLeL+mKlDA4wVpB4xlpUE5w/FrPDppQVelUSmwc

lGgmjli/DcRVcVwV/wD/S+FVUj7H7oweX+UPbtzITwTsuRf2rQjDjhtyzbVYryzS3bMFz09qZxKy

nn+GL6rL1jfnYpIp5cubcUv8AsxlZ03w5J6Hc7yLeczC7VrtC966cdZJI+vI9YXsZXB00xrr9vcx

48px71MSQ7SQ4UhsnK0VpDNkN4YCZkUdayl49jRrxbvFXKu5SnOcudeatemZK3V2lxlHbN/auW6y

d9Ty1IFLJzed19ZZP/kw9pWM48e++mRkPNw867GzXp5XN85/1IrsvHN9l/HqVDsukACAC6QAAHf2

/zXCa8yp8ha5TF4gl8hT5CEyQu4lJ0gruYVUkvXEJ3wqvEczAXAttOk1Xo7fyPs65Hi/rPNrVtPk

Nt53RInKVe2yFJN1IbDKzmInSWCllfSmS5RbJbyOEgE7S7pEmZX0pEussEp4HCXsHOkCpVaSpAuU

WAWIo4DfzpIu4bOSQrqE1yohOEp47CzpEsRK8ukSglWCd5Tg7SxTJdj8yB7hMqu1JxziwzfJX8kr

5C/kRfJb8jz5OfkpeZb8iHyfPE4eJhfJKPkmGSJJOkjEyN3kGImQdtJCbiMNZA+pJjunxCzkerKB

rKJ75RG+ED4T/i18KPxNeEd4Q3jN3iIAV4XHL/bS+L2L9t3w3GMX2Q3tj15kn3XfvXCaxkcuHKPx

4Qu30vjQBetWB/roOxdYjm9PMpXng5PsfvoHJptovDhZSeOFydU0Tk6yDUxMaDSOT9xN49jEAXbt

cKKGxvMTQRrvHz9H47fGB2g8N862dN94G43fHG+g8Rvju2g8O76WxpGxszQOj0VpPDPGfnFnaIzl

SY2l98kcY1s1Rlk+fVSi8fRoB43J0f0QowKw2ECMCgBYTCBGBcDVIwDEqK5vAhCjQowKMSoAywOI

UQEA+YAYFQBXAjEqAGCeJw4cxKgMiFEhRoUYFWJUiFEhRoUYFWJUiFEBAPMDYlQAXArEqAAsfSBG

BQAsJBCjQowKMSrEqBCjQowKMSrEqBCjQoy6mOefEKNCjAoxKsSoEKMCAOYPxKgAuBCIUQEA+N1/

ANwMxKgAuBWIUQFYukCMCjEqxKgQo0KMCjEqAAAXSAEAi9r/IUYFy6pNQ4wKMSpwLxCj2vUAMSoA

CwvEqACAxQRiVABcPQJAjOr6JgAxKsSoEKMCsDyAGBUAkA+IUQFwJRCjAgDmeeLAQYzKgBgVYlSI

USFGhRgVYlSIUSFGhRgVADA/IEYFwKVAjArA0gdiVADAQgIxKsSoEKNCjAoxKsSoEKNCjAoxKsSo

i3n+CTEqxKgQo0KMCjEqAGD+QIwKgAuBGBUAgN/9B8DNQIwKgFuBGBWApQvEqBCjQowKMSrEqBCj

AgBwgRQAsKj9H2JUsKzaNMSoEKMC9wIxql0PEKMCsLBAjAoAWEwgRgXA1SMAxKiubwIQo0KMCjEq

AMsDiFEBAPmAGBUAVwIxKgBgnicOHMSoDIhRIUaFGBViVIhRIUaFGBViVIhRAQDzA2JUAFwKxKgA

LH0gRgUALCQQo0KMCjEqxKgQo0KMCjEqxKgQo0KMupjnnxCjQowKMSrEqBCjAgDmD8SoALgQiFEB

APjdfwDcDMSoALgViFEBWLpAjAoxKsSoEKNCjAoxKgAAF0gBAIva/yFGBcuqTUOMCjEqcC8Qo9r1

ADEqAAsLxKgAgMUEYlQAXD0CQIzq+iYAMSrEqBCjArA8gBgVAJAPiFEBcCUQowIA5nniwEGMyoAY

FWJUiFEhRoUYFWJUiFEhRoUYFQAwPyBGBcClQIwKwNIHYlQAwEICMSrEqBCjQowKMSrEqBCjQowK

MSrEqIt5/gkxKsSoEKNCjAoxKgBg/kCMCoALgRgVAIDf/QfAzUCMCoBbgRgVgKULxKgQo0KMCjEq

xKgQowIAcIEUALCo/R9iVLCs2jTEqBCjAvfiDjHq/wDXV/sJ

----FIM CORTE----

----INICIO CRU----

 

ERROR: C1 C2 LEN: 15 16 141530

STR:

 

SVN: $Id: sqlparser.lib.php 13117 2009-11-15 13:50:32Z lem9 $

MySQL: 5.1.41

USR OS, AGENT, VER: Win SAFARI 5.0.537

PMA: 3.2.4

PHP VER,OS: 5.3.1 WINNT

LANG: ptbr-utf-8

SQL: SQLite format 3@ k ,t~ytVUSPNKIGECA>:74B3>17,2(.#) &!

!encryption!db_version

!encryption!db_version

i"]9Bom jogo"E

Bem vindo ao Global Compacto#

G Bem vindo a EvilSoft Otserver" EBem vindo ao Global Compacto6mBem vindo ao Mix World - By MixSoft ! Bom jogo !CSeja bem vindo ao BRFox 2. Revoluo em servidores de Tibia!F Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!E Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!$ISeja bem vindo ao Mix Yourots!?Seja bem vindo ao Yourots&MWelcome to the Forgotten Server!&MWelcome to The Forgotten Server!

L:

L*4

K~Ź

K}z

L:L*4K~ŹK}z

$''tableserver_configserver_configCREATE TABLE "server_config" (

"config" VARCHAR(35) NOT NULL DEFAULT '',

"value" INTEGER NOT NULL,

UNIQUE ("config")

)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (

"id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"text" TEXT NOT NULL DEFAULT '',

UNIQUE ("id", "world_id")

)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (

"record" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL,

UNIQUE ("record", "world_id", "timestamp")

)9M'indexsqlite_autoindex_server_record_1server_record

WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL DEFAULT 0,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL DEFAULT 0,

"report" TEXT NOT NULL DEFAULT '',

"reads" INTEGER NOT NULL DEFAULT 0

)U}tableaccountsaccountsCREATE TABLE "accounts" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"password" VARCHAR(255) NOT NULL,

"premdays" INTEGER NOT NULL DEFAULT 0,

"lastday" INTEGER NOT NULL DEFAULT 0,

"email" VARCHAR(255) NOT NULL DEFAULT '',

"key" VARCHAR(20) NOT NULL DEFAULT '0',

"blocked" BOOLEAN NOT NULL DEFAULT 0,

"warnings" INTEGER NOT NULL DEFAULT 0,

"group_id" INTEGER NOT NULL DEFAULT 1,

UNIQUE ("name")

)/ Cindexsqlite_autoindex_accounts_1accountsFEND4CHG

elfonegro89/`R7X[s<->LWVVQUKTE&@19Q4P.O( #NMKJIZ 7DestruiYJesus@0,

"group_id" INTEGER NOT NULL,

"account_id" INTEGER NOT NULL,

"level" INTEGER NOT NULL DEFAULT 1,

"vocation" INTEGER NOT NULL DEFAULT 0,

"health" INTEGER NOT NULL DEFAULT 100,

"healthmax" INTEGER NOT NULL DEFAULT 100,

"experience" INTEGER NOT NULL DEFAULT 0,

"lookbody" INTEGER NOT NULL DEFAULT 10,

"lookfeet" INTEGER NOT NULL DEFAULT 10,

"lookhead" INTEGER NOT NULL DEFAULT 10,

"looklegs" INTEGER NOT NULL DEFAULT 10,

"looktype" INTEGER NOT NULL DEFAULT 136,

"lookaddons" INTEGER NOT NULL DEFAULT 0,

"maglevel" INTEGER NOT NULL DEFAULT 0,

"mana" INTEGER NOT NULL DEFAULT 100,

"manamax" INTEGER NOT NULL DEFAULT 100,

"manaspent" INTEGER NOT NULL DEFAULT 0,

"soul" INTEGER NOT NULL DEFAULT 0,

"town_id" INTEGER NOT NULL,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"conditions" BLOB NOT NULL,

"cap" INTEGER NOT NULL DEFAULT 0,

"sex" INTEGER NOT NULL DEFAULT 0,

"lastlogin" INTEGER NOT NULL DEFAULT 0,

"lastip" INTEGER NOT NULL DEFAULT 0,

"save" BOOLEAN NOT NULL DEFAULT 1,

"skull" INTEGER NOT NULL DEFAULT 0,

"skulltime" INTEGER NOT NULL DEFAULT 0,

"rank_id" INTEGER NOT NULL,

"guildnick" VARCHAR(255) NOT NULL DEFAULT '',

"lastlogout" INTEGER NOT NULL DEFAULT 0,

"blessings" INTEGER NOT NULL DEFAULT 0,

"balance" INTEGER NOT NULL DEFAULT 0,

"stamina" INTEGER NOT NULL DEFAULT 151200000,

"direction" INTEGER NOT NULL DEFAULT 2,

"loss_experience" INTEGER NOT NULL DEFAULT 100,

"loss_mana" INTEGER NOT NULL DEFAULT 100,

"loss_skills" INTEGER NOT NULL DEFAULT 100,

"loss_containers" INTEGER NOT NULL DEFAULT 100,

"loss_items" INTEGER NOT NULL DEFAULT 100,

"premend" INTEGER NOT NULL DEFAULT 0,

"online" TINYINT NOT NULL DEFAULT 0,

"marriage" INTEGER NOT NULL DEFAULT 0,

"promotion" INTEGER NOT NULL DEFAULT 0,

"deleted" BOOLEAN NOT NULL DEFAULT 0,

"description" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "deleted"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")

)

&U

tableplayersplayers

CREATE TABLE "players" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (

"account_id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL,

UNIQUE ("account_id", "player_id"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id")

)=

Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (

"key" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"value" VARCHAR(255) NOT NULL DEFAULT '0',

UNIQUE ("key", "world_id")

);O)indexsqlite_autoindex_global_storage_1global_storage\[V^]n

`_

Wanted#The Reapers!Miss Click!BarbariansAwaken'Allahu Akabar

--Y

tableguildsguildsCREATE TABLE "guilds" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"name" VARCHAR(255) NOT NULL,

"ownerid" INTEGER NOT NULL,

"creationdata" INTEGER NOT NULL,

"motd" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "world_id"),

FOREIGN KEY ("ownerid") REFERENCES "players" ("id")

)+?indexsqlite_autoindex_guilds_1guilds''stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (

"player_id" INTEGER NOT NULL,

"guild_id" INTEGER NOT NULL,

UNIQUE ("player_id", "guild_id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id"),

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)9M'indexsqlite_autoindex_guild_invites_1guild_inviteso##%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (

"id" INTEGER PRIMARY KEY,

"guild_id" INTEGER NOT NULL,

"name" VARCHAR(255) NOT NULL,

"level" INTEGER NOT NULL,

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)

yj[G8)

Member#Vice-Leader

Leader

Member#Vice-Leader

 

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader4|vpjd^XRLF@:4.("

U<#

qX?&

t[B)o^H0~g~X}I|:{+zyzxcwNv:u&tszraqMp;SQLite format 3@ k ,t~ytVUSPNKIGECA>:74B3>17,2(.#) &!

!encryption!db_version

!encryption!db_version

i"]9Bom jogo"E

Bem vindo ao Global Compacto#

G Bem vindo a EvilSoft Otserver" EBem vindo ao Global Compacto6mBem vindo ao Mix World - By MixSoft ! Bom jogo !CSeja bem vindo ao BRFox 2. Revoluo em servidores de Tibia!F Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!E Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!$ISeja bem vindo ao Mix Yourots!?Seja bem vindo ao Yourots&MWelcome to the Forgotten Server!&MWelcome to The Forgotten Server!

L:

L*4

K~Ź

K}z

L:L*4K~ŹK}z

$''tableserver_configserver_configCREATE TABLE "server_config" (

"config" VARCHAR(35) NOT NULL DEFAULT '',

"value" INTEGER NOT NULL,

UNIQUE ("config")

)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (

"id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"text" TEXT NOT NULL DEFAULT '',

UNIQUE ("id", "world_id")

)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (

"record" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL,

UNIQUE ("record", "world_id", "timestamp")

)9M'indexsqlite_autoindex_server_record_1server_record

WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL DEFAULT 0,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL DEFAULT 0,

"report" TEXT NOT NULL DEFAULT '',

"reads" INTEGER NOT NULL DEFAULT 0

)U}tableaccountsaccountsCREATE TABLE "accounts" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"password" VARCHAR(255) NOT NULL,

"premdays" INTEGER NOT NULL DEFAULT 0,

"lastday" INTEGER NOT NULL DEFAULT 0,

"email" VARCHAR(255) NOT NULL DEFAULT '',

"key" VARCHAR(20) NOT NULL DEFAULT '0',

"blocked" BOOLEAN NOT NULL DEFAULT 0,

"warnings" INTEGER NOT NULL DEFAULT 0,

"group_id" INTEGER NOT NULL DEFAULT 1,

UNIQUE ("name")

)/ Cindexsqlite_autoindex_accounts_1accountsFEND4CHG

elfonegro89/`R7X[s<->LWVVQUKTE&@19Q4P.O( #NMKJIZ 7DestruiYJesus@0,

"group_id" INTEGER NOT NULL,

"account_id" INTEGER NOT NULL,

"level" INTEGER NOT NULL DEFAULT 1,

"vocation" INTEGER NOT NULL DEFAULT 0,

"health" INTEGER NOT NULL DEFAULT 100,

"healthmax" INTEGER NOT NULL DEFAULT 100,

"experience" INTEGER NOT NULL DEFAULT 0,

"lookbody" INTEGER NOT NULL DEFAULT 10,

"lookfeet" INTEGER NOT NULL DEFAULT 10,

"lookhead" INTEGER NOT NULL DEFAULT 10,

"looklegs" INTEGER NOT NULL DEFAULT 10,

"looktype" INTEGER NOT NULL DEFAULT 136,

"lookaddons" INTEGER NOT NULL DEFAULT 0,

"maglevel" INTEGER NOT NULL DEFAULT 0,

"mana" INTEGER NOT NULL DEFAULT 100,

"manamax" INTEGER NOT NULL DEFAULT 100,

"manaspent" INTEGER NOT NULL DEFAULT 0,

"soul" INTEGER NOT NULL DEFAULT 0,

"town_id" INTEGER NOT NULL,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"conditions" BLOB NOT NULL,

"cap" INTEGER NOT NULL DEFAULT 0,

"sex" INTEGER NOT NULL DEFAULT 0,

"lastlogin" INTEGER NOT NULL DEFAULT 0,

"lastip" INTEGER NOT NULL DEFAULT 0,

"save" BOOLEAN NOT NULL DEFAULT 1,

"skull" INTEGER NOT NULL DEFAULT 0,

"skulltime" INTEGER NOT NULL DEFAULT 0,

"rank_id" INTEGER NOT NULL,

"guildnick" VARCHAR(255) NOT NULL DEFAULT '',

"lastlogout" INTEGER NOT NULL DEFAULT 0,

"blessings" INTEGER NOT NULL DEFAULT 0,

"balance" INTEGER NOT NULL DEFAULT 0,

"stamina" INTEGER NOT NULL DEFAULT 151200000,

"direction" INTEGER NOT NULL DEFAULT 2,

"loss_experience" INTEGER NOT NULL DEFAULT 100,

"loss_mana" INTEGER NOT NULL DEFAULT 100,

"loss_skills" INTEGER NOT NULL DEFAULT 100,

"loss_containers" INTEGER NOT NULL DEFAULT 100,

"loss_items" INTEGER NOT NULL DEFAULT 100,

"premend" INTEGER NOT NULL DEFAULT 0,

"online" TINYINT NOT NULL DEFAULT 0,

"marriage" INTEGER NOT NULL DEFAULT 0,

"promotion" INTEGER NOT NULL DEFAULT 0,

"deleted" BOOLEAN NOT NULL DEFAULT 0,

"description" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "deleted"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")

)

&U

tableplayersplayers

CREATE TABLE "players" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (

"account_id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL,

UNIQUE ("account_id", "player_id"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id")

)=

Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (

"key" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"value" VARCHAR(255) NOT NULL DEFAULT '0',

UNIQUE ("key", "world_id")

);O)indexsqlite_autoindex_global_storage_1global_storage\[V^]n

`_

Wanted#The Reapers!Miss Click!BarbariansAwaken'Allahu Akabar

--Y

tableguildsguildsCREATE TABLE "guilds" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"name" VARCHAR(255) NOT NULL,

"ownerid" INTEGER NOT NULL,

"creationdata" INTEGER NOT NULL,

"motd" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "world_id"),

FOREIGN KEY ("ownerid") REFERENCES "players" ("id")

)+?indexsqlite_autoindex_guilds_1guilds''stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (

"player_id" INTEGER NOT NULL,

"guild_id" INTEGER NOT NULL,

UNIQUE ("player_id", "guild_id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id"),

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)9M'indexsqlite_autoindex_guild_invites_1guild_inviteso##%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (

"id" INTEGER PRIMARY KEY,

"guild_id" INTEGER NOT NULL,

"name" VARCHAR(255) NOT NULL,

"level" INTEGER NOT NULL,

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)

yj[G8)

Member#Vice-Leader

Leader

Member#Vice-Leader

 

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader4|vpjd^XRLF@:4.("

U<#

qX?&

t[B)o^H0~g~X}I|:{+zyzxcwNv:u&tszraqMp;SQLite format 3@ k ,t~ytVUSPNKIGECA>:74B3>17,2(.#) &!

!encryption!db_version

!encryption!db_version

i"]9Bom jogo"E

Bem vindo ao Global Compacto#

G Bem vindo a EvilSoft Otserver" EBem vindo ao Global Compacto6mBem vindo ao Mix World - By MixSoft ! Bom jogo !CSeja bem vindo ao BRFox 2. Revoluo em servidores de Tibia!F Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!E Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!$ISeja bem vindo ao Mix Yourots!?Seja bem vindo ao Yourots&MWelcome to the Forgotten Server!&MWelcome to The Forgotten Server!

L:

L*4

K~Ź

K}z

L:L*4K~ŹK}z

$''tableserver_configserver_configCREATE TABLE "server_config" (

"config" VARCHAR(35) NOT NULL DEFAULT '',

"value" INTEGER NOT NULL,

UNIQUE ("config")

)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (

"id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"text" TEXT NOT NULL DEFAULT '',

UNIQUE ("id", "world_id")

)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (

"record" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL,

UNIQUE ("record", "world_id", "timestamp")

)9M'indexsqlite_autoindex_server_record_1server_record

WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL DEFAULT 0,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL DEFAULT 0,

"report" TEXT NOT NULL DEFAULT '',

"reads" INTEGER NOT NULL DEFAULT 0

)U}tableaccountsaccountsCREATE TABLE "accounts" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"password" VARCHAR(255) NOT NULL,

"premdays" INTEGER NOT NULL DEFAULT 0,

"lastday" INTEGER NOT NULL DEFAULT 0,

"email" VARCHAR(255) NOT NULL DEFAULT '',

"key" VARCHAR(20) NOT NULL DEFAULT '0',

"blocked" BOOLEAN NOT NULL DEFAULT 0,

"warnings" INTEGER NOT NULL DEFAULT 0,

"group_id" INTEGER NOT NULL DEFAULT 1,

UNIQUE ("name")

)/ Cindexsqlite_autoindex_accounts_1accountsFEND4CHG

elfonegro89/`R7X[s<->LWVVQUKTE&@19Q4P.O( #NMKJIZ 7DestruiYJesus@0,

"group_id" INTEGER NOT NULL,

"account_id" INTEGER NOT NULL,

"level" INTEGER NOT NULL DEFAULT 1,

"vocation" INTEGER NOT NULL DEFAULT 0,

"health" INTEGER NOT NULL DEFAULT 100,

"healthmax" INTEGER NOT NULL DEFAULT 100,

"experience" INTEGER NOT NULL DEFAULT 0,

"lookbody" INTEGER NOT NULL DEFAULT 10,

"lookfeet" INTEGER NOT NULL DEFAULT 10,

"lookhead" INTEGER NOT NULL DEFAULT 10,

"looklegs" INTEGER NOT NULL DEFAULT 10,

"looktype" INTEGER NOT NULL DEFAULT 136,

"lookaddons" INTEGER NOT NULL DEFAULT 0,

"maglevel" INTEGER NOT NULL DEFAULT 0,

"mana" INTEGER NOT NULL DEFAULT 100,

"manamax" INTEGER NOT NULL DEFAULT 100,

"manaspent" INTEGER NOT NULL DEFAULT 0,

"soul" INTEGER NOT NULL DEFAULT 0,

"town_id" INTEGER NOT NULL,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"conditions" BLOB NOT NULL,

"cap" INTEGER NOT NULL DEFAULT 0,

"sex" INTEGER NOT NULL DEFAULT 0,

"lastlogin" INTEGER NOT NULL DEFAULT 0,

"lastip" INTEGER NOT NULL DEFAULT 0,

"save" BOOLEAN NOT NULL DEFAULT 1,

"skull" INTEGER NOT NULL DEFAULT 0,

"skulltime" INTEGER NOT NULL DEFAULT 0,

"rank_id" INTEGER NOT NULL,

"guildnick" VARCHAR(255) NOT NULL DEFAULT '',

"lastlogout" INTEGER NOT NULL DEFAULT 0,

"blessings" INTEGER NOT NULL DEFAULT 0,

"balance" INTEGER NOT NULL DEFAULT 0,

"stamina" INTEGER NOT NULL DEFAULT 151200000,

"direction" INTEGER NOT NULL DEFAULT 2,

"loss_experience" INTEGER NOT NULL DEFAULT 100,

"loss_mana" INTEGER NOT NULL DEFAULT 100,

"loss_skills" INTEGER NOT NULL DEFAULT 100,

"loss_containers" INTEGER NOT NULL DEFAULT 100,

"loss_items" INTEGER NOT NULL DEFAULT 100,

"premend" INTEGER NOT NULL DEFAULT 0,

"online" TINYINT NOT NULL DEFAULT 0,

"marriage" INTEGER NOT NULL DEFAULT 0,

"promotion" INTEGER NOT NULL DEFAULT 0,

"deleted" BOOLEAN NOT NULL DEFAULT 0,

"description" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "deleted"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")

)

&U

tableplayersplayers

CREATE TABLE "players" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (

"account_id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL,

UNIQUE ("account_id", "player_id"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id")

)=

Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (

"key" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"value" VARCHAR(255) NOT NULL DEFAULT '0',

UNIQUE ("key", "world_id")

);O)indexsqlite_autoindex_global_storage_1global_storage\[V^]n

`_

Wanted#The Reapers!Miss Click!BarbariansAwaken'Allahu Akabar

--Y

tableguildsguildsCREATE TABLE "guilds" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"name" VARCHAR(255) NOT NULL,

"ownerid" INTEGER NOT NULL,

"creationdata" INTEGER NOT NULL,

"motd" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "world_id"),

FOREIGN KEY ("ownerid") REFERENCES "players" ("id")

)+?indexsqlite_autoindex_guilds_1guilds''stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (

"player_id" INTEGER NOT NULL,

"guild_id" INTEGER NOT NULL,

UNIQUE ("player_id", "guild_id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id"),

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)9M'indexsqlite_autoindex_guild_invites_1guild_inviteso##%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (

"id" INTEGER PRIMARY KEY,

"guild_id" INTEGER NOT NULL,

"name" VARCHAR(255) NOT NULL,

"level" INTEGER NOT NULL,

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)

yj[G8)

Member#Vice-Leader

Leader

Member#Vice-Leader

 

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader4|vpjd^XRLF@:4.("

U<#

qX?&

t[B)o^H0~g~X}I|:{+zyzxcwNv:u&tszraqMp;SQLite format 3@ k ,t~ytVUSPNKIGECA>:74B3>17,2(.#) &!

!encryption!db_version

!encryption!db_version

i"]9Bom jogo"E

Bem vindo ao Global Compacto#

G Bem vindo a EvilSoft Otserver" EBem vindo ao Global Compacto6mBem vindo ao Mix World - By MixSoft ! Bom jogo !CSeja bem vindo ao BRFox 2. Revoluo em servidores de Tibia!F Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!E Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!$ISeja bem vindo ao Mix Yourots!?Seja bem vindo ao Yourots&MWelcome to the Forgotten Server!&MWelcome to The Forgotten Server!

L:

L*4

K~Ź

K}z

L:L*4K~ŹK}z

$''tableserver_configserver_configCREATE TABLE "server_config" (

"config" VARCHAR(35) NOT NULL DEFAULT '',

"value" INTEGER NOT NULL,

UNIQUE ("config")

)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (

"id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"text" TEXT NOT NULL DEFAULT '',

UNIQUE ("id", "world_id")

)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (

"record" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL,

UNIQUE ("record", "world_id", "timestamp")

)9M'indexsqlite_autoindex_server_record_1server_record

WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL DEFAULT 0,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL DEFAULT 0,

"report" TEXT NOT NULL DEFAULT '',

"reads" INTEGER NOT NULL DEFAULT 0

)U}tableaccountsaccountsCREATE TABLE "accounts" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"password" VARCHAR(255) NOT NULL,

"premdays" INTEGER NOT NULL DEFAULT 0,

"lastday" INTEGER NOT NULL DEFAULT 0,

"email" VARCHAR(255) NOT NULL DEFAULT '',

"key" VARCHAR(20) NOT NULL DEFAULT '0',

"blocked" BOOLEAN NOT NULL DEFAULT 0,

"warnings" INTEGER NOT NULL DEFAULT 0,

"group_id" INTEGER NOT NULL DEFAULT 1,

UNIQUE ("name")

)/ Cindexsqlite_autoindex_accounts_1accountsFEND4CHG

elfonegro89/`R7X[s<->LWVVQUKTE&@19Q4P.O( #NMKJIZ 7DestruiYJesus@0,

"group_id" INTEGER NOT NULL,

"account_id" INTEGER NOT NULL,

"level" INTEGER NOT NULL DEFAULT 1,

"vocation" INTEGER NOT NULL DEFAULT 0,

"health" INTEGER NOT NULL DEFAULT 100,

"healthmax" INTEGER NOT NULL DEFAULT 100,

"experience" INTEGER NOT NULL DEFAULT 0,

"lookbody" INTEGER NOT NULL DEFAULT 10,

"lookfeet" INTEGER NOT NULL DEFAULT 10,

"lookhead" INTEGER NOT NULL DEFAULT 10,

"looklegs" INTEGER NOT NULL DEFAULT 10,

"looktype" INTEGER NOT NULL DEFAULT 136,

"lookaddons" INTEGER NOT NULL DEFAULT 0,

"maglevel" INTEGER NOT NULL DEFAULT 0,

"mana" INTEGER NOT NULL DEFAULT 100,

"manamax" INTEGER NOT NULL DEFAULT 100,

"manaspent" INTEGER NOT NULL DEFAULT 0,

"soul" INTEGER NOT NULL DEFAULT 0,

"town_id" INTEGER NOT NULL,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"conditions" BLOB NOT NULL,

"cap" INTEGER NOT NULL DEFAULT 0,

"sex" INTEGER NOT NULL DEFAULT 0,

"lastlogin" INTEGER NOT NULL DEFAULT 0,

"lastip" INTEGER NOT NULL DEFAULT 0,

"save" BOOLEAN NOT NULL DEFAULT 1,

"skull" INTEGER NOT NULL DEFAULT 0,

"skulltime" INTEGER NOT NULL DEFAULT 0,

"rank_id" INTEGER NOT NULL,

"guildnick" VARCHAR(255) NOT NULL DEFAULT '',

"lastlogout" INTEGER NOT NULL DEFAULT 0,

"blessings" INTEGER NOT NULL DEFAULT 0,

"balance" INTEGER NOT NULL DEFAULT 0,

"stamina" INTEGER NOT NULL DEFAULT 151200000,

"direction" INTEGER NOT NULL DEFAULT 2,

"loss_experience" INTEGER NOT NULL DEFAULT 100,

"loss_mana" INTEGER NOT NULL DEFAULT 100,

"loss_skills" INTEGER NOT NULL DEFAULT 100,

"loss_containers" INTEGER NOT NULL DEFAULT 100,

"loss_items" INTEGER NOT NULL DEFAULT 100,

"premend" INTEGER NOT NULL DEFAULT 0,

"online" TINYINT NOT NULL DEFAULT 0,

"marriage" INTEGER NOT NULL DEFAULT 0,

"promotion" INTEGER NOT NULL DEFAULT 0,

"deleted" BOOLEAN NOT NULL DEFAULT 0,

"description" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "deleted"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")

)

&U

tableplayersplayers

CREATE TABLE "players" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (

"account_id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL,

UNIQUE ("account_id", "player_id"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id")

)=

Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (

"key" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"value" VARCHAR(255) NOT NULL DEFAULT '0',

UNIQUE ("key", "world_id")

);O)indexsqlite_autoindex_global_storage_1global_storage\[V^]n

`_

Wanted#The Reapers!Miss Click!BarbariansAwaken'Allahu Akabar

--Y

tableguildsguildsCREATE TABLE "guilds" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"name" VARCHAR(255) NOT NULL,

"ownerid" INTEGER NOT NULL,

"creationdata" INTEGER NOT NULL,

"motd" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "world_id"),

FOREIGN KEY ("ownerid") REFERENCES "players" ("id")

)+?indexsqlite_autoindex_guilds_1guilds''stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (

"player_id" INTEGER NOT NULL,

"guild_id" INTEGER NOT NULL,

UNIQUE ("player_id", "guild_id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id"),

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)9M'indexsqlite_autoindex_guild_invites_1guild_inviteso##%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (

"id" INTEGER PRIMARY KEY,

"guild_id" INTEGER NOT NULL,

"name" VARCHAR(255) NOT NULL,

"level" INTEGER NOT NULL,

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)

yj[G8)

Member#Vice-Leader

Leader

Member#Vice-Leader

 

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader4|vpjd^XRLF@:4.("

U<#

qX?&

t[B)o^H0~g~X}I|:{+zyzxcwNv:u&tszraqMp;SQLite format 3@ k ,t~ytVUSPNKIGECA>:74B3>17,2(.#) &!

!encryption!db_version

!encryption!db_version

i"]9Bom jogo"E

Bem vindo ao Global Compacto#

G Bem vindo a EvilSoft Otserver" EBem vindo ao Global Compacto6mBem vindo ao Mix World - By MixSoft ! Bom jogo !CSeja bem vindo ao BRFox 2. Revoluo em servidores de Tibia!F Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!E Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!$ISeja bem vindo ao Mix Yourots!?Seja bem vindo ao Yourots&MWelcome to the Forgotten Server!&MWelcome to The Forgotten Server!

L:

L*4

K~Ź

K}z

L:L*4K~ŹK}z

$''tableserver_configserver_configCREATE TABLE "server_config" (

"config" VARCHAR(35) NOT NULL DEFAULT '',

"value" INTEGER NOT NULL,

UNIQUE ("config")

)9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" (

"id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"text" TEXT NOT NULL DEFAULT '',

UNIQUE ("id", "world_id")

)5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" (

"record" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL,

UNIQUE ("record", "world_id", "timestamp")

)9M'indexsqlite_autoindex_server_record_1server_record

WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL DEFAULT 0,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"timestamp" INTEGER NOT NULL DEFAULT 0,

"report" TEXT NOT NULL DEFAULT '',

"reads" INTEGER NOT NULL DEFAULT 0

)U}tableaccountsaccountsCREATE TABLE "accounts" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"password" VARCHAR(255) NOT NULL,

"premdays" INTEGER NOT NULL DEFAULT 0,

"lastday" INTEGER NOT NULL DEFAULT 0,

"email" VARCHAR(255) NOT NULL DEFAULT '',

"key" VARCHAR(20) NOT NULL DEFAULT '0',

"blocked" BOOLEAN NOT NULL DEFAULT 0,

"warnings" INTEGER NOT NULL DEFAULT 0,

"group_id" INTEGER NOT NULL DEFAULT 1,

UNIQUE ("name")

)/ Cindexsqlite_autoindex_accounts_1accountsFEND4CHG

elfonegro89/`R7X[s<->LWVVQUKTE&@19Q4P.O( #NMKJIZ 7DestruiYJesus@0,

"group_id" INTEGER NOT NULL,

"account_id" INTEGER NOT NULL,

"level" INTEGER NOT NULL DEFAULT 1,

"vocation" INTEGER NOT NULL DEFAULT 0,

"health" INTEGER NOT NULL DEFAULT 100,

"healthmax" INTEGER NOT NULL DEFAULT 100,

"experience" INTEGER NOT NULL DEFAULT 0,

"lookbody" INTEGER NOT NULL DEFAULT 10,

"lookfeet" INTEGER NOT NULL DEFAULT 10,

"lookhead" INTEGER NOT NULL DEFAULT 10,

"looklegs" INTEGER NOT NULL DEFAULT 10,

"looktype" INTEGER NOT NULL DEFAULT 136,

"lookaddons" INTEGER NOT NULL DEFAULT 0,

"maglevel" INTEGER NOT NULL DEFAULT 0,

"mana" INTEGER NOT NULL DEFAULT 100,

"manamax" INTEGER NOT NULL DEFAULT 100,

"manaspent" INTEGER NOT NULL DEFAULT 0,

"soul" INTEGER NOT NULL DEFAULT 0,

"town_id" INTEGER NOT NULL,

"posx" INTEGER NOT NULL DEFAULT 0,

"posy" INTEGER NOT NULL DEFAULT 0,

"posz" INTEGER NOT NULL DEFAULT 0,

"conditions" BLOB NOT NULL,

"cap" INTEGER NOT NULL DEFAULT 0,

"sex" INTEGER NOT NULL DEFAULT 0,

"lastlogin" INTEGER NOT NULL DEFAULT 0,

"lastip" INTEGER NOT NULL DEFAULT 0,

"save" BOOLEAN NOT NULL DEFAULT 1,

"skull" INTEGER NOT NULL DEFAULT 0,

"skulltime" INTEGER NOT NULL DEFAULT 0,

"rank_id" INTEGER NOT NULL,

"guildnick" VARCHAR(255) NOT NULL DEFAULT '',

"lastlogout" INTEGER NOT NULL DEFAULT 0,

"blessings" INTEGER NOT NULL DEFAULT 0,

"balance" INTEGER NOT NULL DEFAULT 0,

"stamina" INTEGER NOT NULL DEFAULT 151200000,

"direction" INTEGER NOT NULL DEFAULT 2,

"loss_experience" INTEGER NOT NULL DEFAULT 100,

"loss_mana" INTEGER NOT NULL DEFAULT 100,

"loss_skills" INTEGER NOT NULL DEFAULT 100,

"loss_containers" INTEGER NOT NULL DEFAULT 100,

"loss_items" INTEGER NOT NULL DEFAULT 100,

"premend" INTEGER NOT NULL DEFAULT 0,

"online" TINYINT NOT NULL DEFAULT 0,

"marriage" INTEGER NOT NULL DEFAULT 0,

"promotion" INTEGER NOT NULL DEFAULT 0,

"deleted" BOOLEAN NOT NULL DEFAULT 0,

"description" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "deleted"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")

)

&U

tableplayersplayers

CREATE TABLE "players" (

"id" INTEGER PRIMARY KEY NOT NULL,

"name" VARCHAR(255) NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (

"account_id" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"player_id" INTEGER NOT NULL,

UNIQUE ("account_id", "player_id"),

FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id")

)=

Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (

"key" INTEGER NOT NULL,

"world_id" INTEGER NOT NULL DEFAULT 0,

"value" VARCHAR(255) NOT NULL DEFAULT '0',

UNIQUE ("key", "world_id")

);O)indexsqlite_autoindex_global_storage_1global_storage\[V^]n

`_

Wanted#The Reapers!Miss Click!BarbariansAwaken'Allahu Akabar

--Y

tableguildsguildsCREATE TABLE "guilds" (

"id" INTEGER PRIMARY KEY,

"world_id" INTEGER NOT NULL DEFAULT 0,

"name" VARCHAR(255) NOT NULL,

"ownerid" INTEGER NOT NULL,

"creationdata" INTEGER NOT NULL,

"motd" VARCHAR(255) NOT NULL DEFAULT '',

UNIQUE ("name", "world_id"),

FOREIGN KEY ("ownerid") REFERENCES "players" ("id")

)+?indexsqlite_autoindex_guilds_1guilds''stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (

"player_id" INTEGER NOT NULL,

"guild_id" INTEGER NOT NULL,

UNIQUE ("player_id", "guild_id"),

FOREIGN KEY ("player_id") REFERENCES "players" ("id"),

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)9M'indexsqlite_autoindex_guild_invites_1guild_inviteso##%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (

"id" INTEGER PRIMARY KEY,

"guild_id" INTEGER NOT NULL,

"name" VARCHAR(255) NOT NULL,

"level" INTEGER NOT NULL,

FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")

)

yj[G8)

Member#Vice-Leader

Leader

Member#Vice-Leader

 

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader

Member#Vice-Leader

Leader4|vpjd^XRLF@:4.("

U<#

qX?&

t[B)o^H0~g~X}I|:{+zyzxcwNv:u&tszraqMp;

----FIM CRU----

 

 

consulta SQL:

SQLite format 3@ k ,t~ytVUSPNKIGECA>:74B3>17,2(.#) &! !encryption!db_version !encryption!db_version i"]9Bom jogo"E Bem vindo ao Global Compacto# G Bem vindo a EvilSoft Otserver" EBem vindo ao Global Compacto6mBem vindo ao Mix World - By MixSoft ! Bom jogo !CSeja bem vindo ao BRFox 2. Revoluo em servidores de Tibia!F Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!E Seja bem vindo ao Mix World. Revoluo em servidores de Tibia!$ISeja bem vindo ao Mix Yourots!?Seja bem vindo ao Yourots&MWelcome to the Forgotten Server!&MWelcome to The Forgotten Server! L: L*4 K~Ź K}z L:L*4K~ŹK}z $''tableserver_configserver_configCREATE TABLE "server_config" ( "config" VARCHAR(35) NOT NULL DEFAULT '', "value" INTEGER NOT NULL, UNIQUE ("config") )9M'indexsqlite_autoindex_server_config_1server_configC##Mtableserver_motdserver_motdCREATE TABLE "server_motd" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "text" TEXT NOT NULL DEFAULT '', UNIQUE ("id", "world_id") )5I#indexsqlite_autoindex_server_motd_1server_motd[''utableserver_recordserver_recordCREATE TABLE "server_record" ( "record" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL, UNIQUE ("record", "world_id", "timestamp") )9M'indexsqlite_autoindex_server_record_1server_record WW))utableserver_reportsserver_reportsCREATE TABLE "server_reports" ( "id" INTEGER PRIMARY KEY, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL DEFAULT 0, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL DEFAULT 0, "report" TEXT NOT NULL DEFAULT '', "reads" INTEGER NOT NULL DEFAULT 0 )U}tableaccountsaccountsCREATE TABLE "accounts" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "password" VARCHAR(255) NOT NULL, "premdays" INTEGER NOT NULL DEFAULT 0, "lastday" INTEGER NOT NULL DEFAULT 0, "email" VARCHAR(255) NOT NULL DEFAULT '', "key" VARCHAR(20) NOT NULL DEFAULT '0', "blocked" BOOLEAN NOT NULL DEFAULT 0, "warnings" INTEGER NOT NULL DEFAULT 0, "group_id" INTEGER NOT NULL DEFAULT 1, UNIQUE ("name") )/ Cindexsqlite_autoindex_accounts_1accountsFEND4CHG elfonegro89/`R7X[s<->LWVVQUKTE&@19Q4P.O( #NMKJIZ 7DestruiYJesus@0, "group_id" INTEGER NOT NULL, "account_id" INTEGER NOT NULL, "level" INTEGER NOT NULL DEFAULT 1, "vocation" INTEGER NOT NULL DEFAULT 0, "health" INTEGER NOT NULL DEFAULT 100, "healthmax" INTEGER NOT NULL DEFAULT 100, "experience" INTEGER NOT NULL DEFAULT 0, "lookbody" INTEGER NOT NULL DEFAULT 10, "lookfeet" INTEGER NOT NULL DEFAULT 10, "lookhead" INTEGER NOT NULL DEFAULT 10, "looklegs" INTEGER NOT NULL DEFAULT 10, "looktype" INTEGER NOT NULL DEFAULT 136, "lookaddons" INTEGER NOT NULL DEFAULT 0, "maglevel" INTEGER NOT NULL DEFAULT 0, "mana" INTEGER NOT NULL DEFAULT 100, "manamax" INTEGER NOT NULL DEFAULT 100, "manaspent" INTEGER NOT NULL DEFAULT 0, "soul" INTEGER NOT NULL DEFAULT 0, "town_id" INTEGER NOT NULL, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "conditions" BLOB NOT NULL, "cap" INTEGER NOT NULL DEFAULT 0, "sex" INTEGER NOT NULL DEFAULT 0, "lastlogin" INTEGER NOT NULL DEFAULT 0, "lastip" INTEGER NOT NULL DEFAULT 0, "save" BOOLEAN NOT NULL DEFAULT 1, "skull" INTEGER NOT NULL DEFAULT 0, "skulltime" INTEGER NOT NULL DEFAULT 0, "rank_id" INTEGER NOT NULL, "guildnick" VARCHAR(255) NOT NULL DEFAULT '', "lastlogout" INTEGER NOT NULL DEFAULT 0, "blessings" INTEGER NOT NULL DEFAULT 0, "balance" INTEGER NOT NULL DEFAULT 0, "stamina" INTEGER NOT NULL DEFAULT 151200000, "direction" INTEGER NOT NULL DEFAULT 2, "loss_experience" INTEGER NOT NULL DEFAULT 100, "loss_mana" INTEGER NOT NULL DEFAULT 100, "loss_skills" INTEGER NOT NULL DEFAULT 100, "loss_containers" INTEGER NOT NULL DEFAULT 100, "loss_items" INTEGER NOT NULL DEFAULT 100, "premend" INTEGER NOT NULL DEFAULT 0, "online" TINYINT NOT NULL DEFAULT 0, "marriage" INTEGER NOT NULL DEFAULT 0, "promotion" INTEGER NOT NULL DEFAULT 0, "deleted" BOOLEAN NOT NULL DEFAULT 0, "description" VARCHAR(255) NOT NULL DEFAULT '', UNIQUE ("name", "deleted"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id") ) &U tableplayersplayers CREATE TABLE "players" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "world_id" INTEGER NOT NULL DEFAULT -Aindexsqlite_autoindex_players_1playersQ++Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" ( "account_id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL, UNIQUE ("account_id", "player_id"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id") )= Q+indexsqlite_autoindex_account_viplist_1account_viplistX))ktableglobal_storageglobal_storageCREATE TABLE "global_storage" ( "key" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "value" VARCHAR(255) NOT NULL DEFAULT '0', UNIQUE ("key", "world_id") );O)indexsqlite_autoindex_global_storage_1global_storage\[V^]n `_ Wanted#The Reapers!Miss Click!BarbariansAwaken'Allahu Akabar --Y tableguildsguildsCREATE TABLE "guilds" ( "id" INTEGER PRIMARY KEY, "world_id" INTEGER NOT NULL DEFAULT 0, "name" VARCHAR(255) NOT NULL, "ownerid" INTEGER NOT NULL, "creationdata" INTEGER NOT NULL, "motd" VARCHAR(255) NOT NULL DEFAULT '', UNIQUE ("name", "world_id"), FOREIGN KEY ("ownerid") REFERENCES "players" ("id") )+?indexsqlite_autoindex_guilds_1guilds''stableguild_invitesguild_invitesCREATE TABLE "guild_invites" ( "player_id" INTEGER NOT NULL, "guild_id" INTEGER NOT NULL, UNIQUE ("player_id", "guild_id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id"), FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") )9M'indexsqlite_autoindex_guild_invites_1guild_inviteso##%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" ( "id" INTEGER PRIMARY KEY, "guild_id" INTEGER NOT NULL, "name" VARCHAR(255) NOT NULL, "level" INTEGER NOT NULL, FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") ) yj[G8) Member#Vice-Leader Leader Member#Vice-Leader Leader Member#Vice-Leader Leader Member#Vice-Leader Leader Member#Vice-Leader Leader Member#Vice-Leader Leader4|vpjd^XRLF@:4.(" U<# qX?& t[B)o^H0~g~X}I|:{+zyzxcwNv:u&tszraqMp;

Mensagens do MySQL : b_help.png

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLite format 3' at line 1

Link para o comentário
https://xtibia.com/forum/topic/213534-erro-ao-importar-meu-database-no-mysql/
Compartilhar em outros sites

0 respostass a esta questão

Posts Recomendados

Até agora não há respostas para essa pergunta

Arquivado

Este tópico foi arquivado e está fechado para novas respostas.

×
×
  • Criar Novo...