Comparar texto

Encontre a diferença entre dois arquivos de texto

Editor live

Recolher inalteradas

Sem quebra de linha

Layout

Nível de detalhe

Realce de sintaxe

Diffchecker Desktop A maneira mais segura de usar o Diffchecker. Obtenha o aplicativo Diffchecker Desktop: seus diffs nunca saem do seu computador!Obter Desktop

Untitled diff

Criado há 9 anosO diff nunca expira

0 remoções

Linhas
Total
Removido

Caracteres
Total
Removido

Para continuar usando este recurso, atualize para Diffchecker Pro Ver preços

60 linhas

1 adição

Linhas
Total
Adicionado

Caracteres
Total
Adicionado

Para continuar usando este recurso, atualize para Diffchecker Pro Ver preços

61 linhas

CREATE TABLE IF NOT EXISTS `players` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) NOT NULL,

`group_id` int(11) NOT NULL DEFAULT '1',

`account_id` int(11) NOT NULL DEFAULT '0',

`level` int(11) NOT NULL DEFAULT '1',

`passivedamagebonus` int(11) NOT NULL DEFAULT '0',

`vocation` int(11) NOT NULL DEFAULT '0',

`health` int(11) NOT NULL DEFAULT '150',

`healthmax` int(11) NOT NULL DEFAULT '150',

`experience` bigint(20) NOT NULL DEFAULT '0',

`lookbody` int(11) NOT NULL DEFAULT '0',

`lookfeet` int(11) NOT NULL DEFAULT '0',

`lookhead` int(11) NOT NULL DEFAULT '0',

`looklegs` int(11) NOT NULL DEFAULT '0',

`looktype` int(11) NOT NULL DEFAULT '136',

`lookaddons` int(11) NOT NULL DEFAULT '0',

`maglevel` int(11) NOT NULL DEFAULT '0',

`mana` int(11) NOT NULL DEFAULT '0',

`manamax` int(11) NOT NULL DEFAULT '0',

`manaspent` int(11) unsigned NOT NULL DEFAULT '0',

`soul` int(10) unsigned NOT NULL DEFAULT '0',

`town_id` int(11) NOT NULL DEFAULT '0',

`posx` int(11) NOT NULL DEFAULT '0',

`posy` int(11) NOT NULL DEFAULT '0',

`posz` int(11) NOT NULL DEFAULT '0',

`conditions` blob NOT NULL,

`cap` int(11) NOT NULL DEFAULT '0',

`sex` int(11) NOT NULL DEFAULT '0',

`lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',

`lastip` int(10) unsigned NOT NULL DEFAULT '0',

`save` tinyint(1) NOT NULL DEFAULT '1',

`skull` tinyint(1) NOT NULL DEFAULT '0',

`skulltime` int(11) NOT NULL DEFAULT '0',

`lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',

`blessings` tinyint(2) NOT NULL DEFAULT '0',

`onlinetime` int(11) NOT NULL DEFAULT '0',

`deletion` bigint(15) NOT NULL DEFAULT '0',

`balance` bigint(20) unsigned NOT NULL DEFAULT '0',

`offlinetraining_time` smallint(5) unsigned NOT NULL DEFAULT '43200',

`offlinetraining_skill` int(11) NOT NULL DEFAULT '-1',

`stamina` smallint(5) unsigned NOT NULL DEFAULT '2520',

`skill_fist` int(10) unsigned NOT NULL DEFAULT 10,

`skill_fist_tries` bigint(20) unsigned NOT NULL DEFAULT 0,

`skill_club` int(10) unsigned NOT NULL DEFAULT 10,

`skill_club_tries` bigint(20) unsigned NOT NULL DEFAULT 0,

`skill_sword` int(10) unsigned NOT NULL DEFAULT 10,

`skill_sword_tries` bigint(20) unsigned NOT NULL DEFAULT 0,

`skill_axe` int(10) unsigned NOT NULL DEFAULT 10,

`skill_axe_tries` bigint(20) unsigned NOT NULL DEFAULT 0,

`skill_dist` int(10) unsigned NOT NULL DEFAULT 10,

`skill_dist_tries` bigint(20) unsigned NOT NULL DEFAULT 0,

`skill_shielding` int(10) unsigned NOT NULL DEFAULT 10,

`skill_shielding_tries` bigint(20) unsigned NOT NULL DEFAULT 0,

`skill_fishing` int(10) unsigned NOT NULL DEFAULT 10,

`skill_fishing_tries` bigint(20) unsigned NOT NULL DEFAULT 0,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`),

FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,

KEY `vocation` (`vocation`)

) ENGINE=InnoDB;

Diferenças salvas

Texto original

Abrir arquivo

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `group_id` int(11) NOT NULL DEFAULT '1',
  `account_id` int(11) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '1',
  `vocation` int(11) NOT NULL DEFAULT '0',
  `health` int(11) NOT NULL DEFAULT '150',
  `healthmax` int(11) NOT NULL DEFAULT '150',
  `experience` bigint(20) NOT NULL DEFAULT '0',
  `lookbody` int(11) NOT NULL DEFAULT '0',
  `lookfeet` int(11) NOT NULL DEFAULT '0',
  `lookhead` int(11) NOT NULL DEFAULT '0',
  `looklegs` int(11) NOT NULL DEFAULT '0',
  `looktype` int(11) NOT NULL DEFAULT '136',
  `lookaddons` int(11) NOT NULL DEFAULT '0',
  `maglevel` int(11) NOT NULL DEFAULT '0',
  `mana` int(11) NOT NULL DEFAULT '0',
  `manamax` int(11) NOT NULL DEFAULT '0',
  `manaspent` int(11) unsigned NOT NULL DEFAULT '0',
  `soul` int(10) unsigned NOT NULL DEFAULT '0',
  `town_id` int(11) NOT NULL DEFAULT '0',
  `posx` int(11) NOT NULL DEFAULT '0',
  `posy` int(11) NOT NULL DEFAULT '0',
  `posz` int(11) NOT NULL DEFAULT '0',
  `conditions` blob NOT NULL,
  `cap` int(11) NOT NULL DEFAULT '0',
  `sex` int(11) NOT NULL DEFAULT '0',
  `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',
  `lastip` int(10) unsigned NOT NULL DEFAULT '0',
  `save` tinyint(1) NOT NULL DEFAULT '1',
  `skull` tinyint(1) NOT NULL DEFAULT '0',
  `skulltime` int(11) NOT NULL DEFAULT '0',
  `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',
  `blessings` tinyint(2) NOT NULL DEFAULT '0',
  `onlinetime` int(11) NOT NULL DEFAULT '0',
  `deletion` bigint(15) NOT NULL DEFAULT '0',
  `balance` bigint(20) unsigned NOT NULL DEFAULT '0',
  `offlinetraining_time` smallint(5) unsigned NOT NULL DEFAULT '43200',
  `offlinetraining_skill` int(11) NOT NULL DEFAULT '-1',
  `stamina` smallint(5) unsigned NOT NULL DEFAULT '2520',
  `skill_fist` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_fist_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_club` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_club_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_sword` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_sword_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_axe` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_axe_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_dist` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_dist_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_shielding` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_shielding_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_fishing` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_fishing_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  KEY `vocation` (`vocation`)
) ENGINE=InnoDB;

Texto alterado

Abrir arquivo

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `group_id` int(11) NOT NULL DEFAULT '1',
  `account_id` int(11) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '1',
  `passivedamagebonus` int(11) NOT NULL DEFAULT '0',
  `vocation` int(11) NOT NULL DEFAULT '0',
  `health` int(11) NOT NULL DEFAULT '150',
  `healthmax` int(11) NOT NULL DEFAULT '150',
  `experience` bigint(20) NOT NULL DEFAULT '0',
  `lookbody` int(11) NOT NULL DEFAULT '0',
  `lookfeet` int(11) NOT NULL DEFAULT '0',
  `lookhead` int(11) NOT NULL DEFAULT '0',
  `looklegs` int(11) NOT NULL DEFAULT '0',
  `looktype` int(11) NOT NULL DEFAULT '136',
  `lookaddons` int(11) NOT NULL DEFAULT '0',
  `maglevel` int(11) NOT NULL DEFAULT '0',
  `mana` int(11) NOT NULL DEFAULT '0',
  `manamax` int(11) NOT NULL DEFAULT '0',
  `manaspent` int(11) unsigned NOT NULL DEFAULT '0',
  `soul` int(10) unsigned NOT NULL DEFAULT '0',
  `town_id` int(11) NOT NULL DEFAULT '0',
  `posx` int(11) NOT NULL DEFAULT '0',
  `posy` int(11) NOT NULL DEFAULT '0',
  `posz` int(11) NOT NULL DEFAULT '0',
  `conditions` blob NOT NULL,
  `cap` int(11) NOT NULL DEFAULT '0',
  `sex` int(11) NOT NULL DEFAULT '0',
  `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0',
  `lastip` int(10) unsigned NOT NULL DEFAULT '0',
  `save` tinyint(1) NOT NULL DEFAULT '1',
  `skull` tinyint(1) NOT NULL DEFAULT '0',
  `skulltime` int(11) NOT NULL DEFAULT '0',
  `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0',
  `blessings` tinyint(2) NOT NULL DEFAULT '0',
  `onlinetime` int(11) NOT NULL DEFAULT '0',
  `deletion` bigint(15) NOT NULL DEFAULT '0',
  `balance` bigint(20) unsigned NOT NULL DEFAULT '0',
  `offlinetraining_time` smallint(5) unsigned NOT NULL DEFAULT '43200',
  `offlinetraining_skill` int(11) NOT NULL DEFAULT '-1',
  `stamina` smallint(5) unsigned NOT NULL DEFAULT '2520',
  `skill_fist` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_fist_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_club` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_club_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_sword` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_sword_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_axe` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_axe_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_dist` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_dist_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_shielding` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_shielding_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  `skill_fishing` int(10) unsigned NOT NULL DEFAULT 10,
  `skill_fishing_tries` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
  KEY `vocation` (`vocation`)
) ENGINE=InnoDB;