Normal Convert Querry, SQL to MYSQL

[JcA 13]

Conversão das Querrys do SQL para o MYSQL

 

CREATE TABLE death_list (
    id          INTEGER NOT NULL,
    player_id   INTEGER NOT NULL,
    date        INTEGER NOT NULL,
    level       INTEGER NOT NULL,
    killer_name INTEGER NOT NULL,
    PRIMARY KEY ( id )
);

 

 

ALTER TABLE `players` ADD `ot_points` INTEGER NOT NULL DEFAULT 0

 

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

 

ALTER TABLE `accounts` ADD `vip_time` INT NOT NULL DEFAULT 0; 

 

ALTER TABLE `accounts` ADD loot_time INT(15) NOT NULL DEFAULT 0;

 

 

CREATE TABLE marriage_system (

		id				INTEGER NOT NULL,

		player_id   INTEGER NOT NULL,

		partner	 VARCHAR( 255 )  NOT NULL,

		marriage_date INTEGER NOT NULL,

		PRIMARY KEY ( id )

);

 

 

 

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT 0,
  `end` BIGINT NOT NULL DEFAULT 0,
  `frags` INT NOT NULL DEFAULT 0,
  `payment` BIGINT NOT NULL DEFAULT 0,
  `guild_kills` INT NOT NULL DEFAULT 0,
  `enemy_kills` INT NOT NULL DEFAULT 0,
  `status` TINYINT(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)  
);

 

Editado Setembro 23, 2017 por JcA (veja o histórico de edições)