Texte vergleichen

Finde den Unterschied zwischen zwei Textdateien

Live-Editor

Gleiches ausblenden

Zeilenumbruch aus

Ansicht

Vergleichsgenauigkeit

Syntaxhervorhebung

Diffchecker Desktop Der sicherste Weg, Diffchecker zu nutzen. Hol dir die Desktop-App: Deine Diffs verlassen nie deinen Computer!Desktop holen

Untitled diff

Erstellt vor 9 JahrenDiff läuft nie ab

0 Entfernungen

Zeilen
Gesamt
Entfernt

Zeichen
Gesamt
Entfernt

Um diese Funktion weiterhin zu nutzen, aktualisiere auf Diffchecker Pro Preise anzeigen

60 Zeilen

1 Hinzufügung

Zeilen
Gesamt
Hinzugefügt

Zeichen
Gesamt
Hinzugefügt

Um diese Funktion weiterhin zu nutzen, aktualisiere auf Diffchecker Pro Preise anzeigen

61 Zeilen

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;

Gespeicherte Diffs

Originaltext

Datei öffnen

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;

Bearbeitung

Datei öffnen

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;