텍스트 비교

두 텍스트 파일의 차이점을 찾아보세요

실시간 편집

변경 없는 행 숨기기

줄바꿈 비활성화

레이아웃

비교 단위

구문 강조

Diffchecker Desktop 가장 안전하게 Diffchecker를 사용하는 방법. 데스크톱 앱을 사용하면 비교 데이터가 외부로 전송되지 않습니다!데스크톱 앱 받기

Untitled diff

생성일 9년 전비교 결과 만료 없음

0 삭제

행
총
삭제

글자
총
삭제

이 기능을 계속 사용하려면 업그레이드해 주세요 Diffchecker Pro 요금제 보기

60 행

1 추가

행
총
추가

글자
총
추가

이 기능을 계속 사용하려면 업그레이드해 주세요 Diffchecker Pro 요금제 보기

61 행

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;

저장된 비교 결과

원본

파일 열기

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;

수정본

파일 열기

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;