ESX Sql File

CREATE TABLE IF NOT EXISTS `tgiann_mdt_arananlar` (
  `citizenid` varchar(50) DEFAULT NULL,
  `sebep` longtext DEFAULT NULL,
  `baslangic` varchar(255) DEFAULT NULL,
  `bitis` varchar(255) DEFAULT NULL,
  `isim` varchar(255) DEFAULT NULL,
  `img` longtext DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS `tgiann_mdt_fines` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) DEFAULT NULL,
  `aciklama` longtext DEFAULT NULL,
  `ceza` varchar(255) DEFAULT NULL,
  `polis` mediumtext DEFAULT NULL,
  `zanli` mediumtext DEFAULT NULL,
  `cezalar` longtext DEFAULT NULL,
  `olayid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `tgiann_mdt_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `note` longtext CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `tgiann_mdt_notes_tab` (
  `id` int(11) NOT NULL DEFAULT 0,
  `text` longtext NOT NULL DEFAULT ''
);

CREATE TABLE IF NOT EXISTS `tgiann_mdt_c_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aciklama` longtext DEFAULT NULL,
  `polis` mediumtext DEFAULT NULL,
  `zanli` mediumtext DEFAULT NULL,
  `zaman` varchar(50) DEFAULT current_timestamp(),
  `esyalar` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`)
);

ALTER TABLE `users` ADD COLUMN `mdtphoto` longtext DEFAULT 'nophoto';
ALTER TABLE `users` ADD COLUMN `aranma` mediumtext DEFAULT '[]';
ALTER TABLE `owned_vehicles` ADD COLUMN `mdtWantedData` longtext NULL;
ALTER TABLE `owned_vehicles` ADD COLUMN `isWanted` int(1) NULL;