- Katılım
- 4 yıl 11 ay 8 gün
- Mesajlar
- 347
- Discord
- Cross#0404
Linkleri,görmek için
Giriş yap veya üye ol.
SQL:
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`)
);
