SQL

ALTER TABLE users ADD coins int(11) NOT NULL DEFAULT 0;
ALTER TABLE users ADD avis int(11) NOT NULL DEFAULT 0;

CREATE TABLE `fg_shop_histo` (
  `identifier` varchar(255) NOT NULL,
  `player` varchar(255) NOT NULL,
  `object` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `fg_shop_histo`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `fg_shop_histo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;


CREATE TABLE `fg_shop_case` (
  `id` int(11) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `box` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `fg_shop_case`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `fg_shop_case`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

CREATE TABLE `tebex_histo` (
  `id` int(11) NOT NULL,
  `player` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `package_id` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `month` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `fg_shop_stock` (
  `stock` varchar(100) NOT NULL,
  `vehicle` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


ALTER TABLE `fg_shop_stock`
  ADD PRIMARY KEY (`vehicle`);
COMMIT;


ALTER TABLE `tebex_histo`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tebex_histo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
COMMIT