Paylaşım - Şifreli MDT

CREATE TABLE IF NOT EXISTS `mdt_login` (
  `cid` int(11) DEFAULT NULL,
  `username` longtext DEFAULT NULL,
  `password` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `user_mdt` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `char_id` int(11) DEFAULT NULL,
    `notes` varchar(255) DEFAULT NULL,
    `mugshot_url` varchar(255) DEFAULT NULL,

    PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `user_convictions` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `char_id` int(11) DEFAULT NULL,
    `offense` varchar(255) DEFAULT NULL,
    `count` int(11) DEFAULT NULL,
  
    PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `mdt_reports` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `char_id` int(11) DEFAULT NULL,
    `title` varchar(255) DEFAULT NULL,
    `incident` longtext DEFAULT NULL,
    `charges` longtext DEFAULT NULL,
    `author` varchar(255) DEFAULT NULL,
    `name` varchar(255) DEFAULT NULL,
    `date` varchar(255) DEFAULT NULL,
    `jailtime` int(11) DEFAULT NULL,

    PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `mdt_warrants` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `char_id` int(11) DEFAULT NULL,
    `report_id` int(11) DEFAULT NULL,
    `report_title` varchar(255) DEFAULT NULL,
    `charges` longtext DEFAULT NULL,
    `date` varchar(255) DEFAULT NULL,
    `expire` varchar(255) DEFAULT NULL,
    `notes` varchar(255) DEFAULT NULL,
    `author` varchar(255) DEFAULT NULL,

    PRIMARY KEY (`id`)
);