-- --------------------------------------------------------
-- Sunucu: 127.0.0.1
-- Sunucu sürümü: 10.5.8-MariaDB - mariadb.org binary distribution
-- Sunucu İşletim Sistemi: Win64
-- HeidiSQL Sürüm: 11.0.0.5919
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- essentialmode için veritabanı yapısı dökülüyor
CREATE DATABASE IF NOT EXISTS `essentialmode` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_turkish_ci */;
USE `essentialmode`;
-- tablo yapısı dökülüyor essentialmode.characters
CREATE TABLE IF NOT EXISTS `characters` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(255) NOT NULL,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`dateofbirth` varchar(255) NOT NULL,
`sex` varchar(1) NOT NULL DEFAULT 'M',
`height` varchar(128) NOT NULL,
`lastdigits` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`joblimit` int(5) DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `id` (`id`) USING BTREE,
KEY `identifier` (`identifier`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- essentialmode.characters: ~1 rows (yaklaşık) tablosu için veriler indiriliyor
/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
INSERT INTO `characters` (`id`, `identifier`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`, `lastdigits`, `joblimit`) VALUES
(1, 'Char1:1100001178f50d7', 'Alino', 'Godorov', '1995-01-01', 'f', '180', NULL, 0);
/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
-- tablo yapısı dökülüyor essentialmode.users
CREATE TABLE IF NOT EXISTS `users` (
`identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`money` int(11) DEFAULT NULL,
`name` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
`job` varchar(50) COLLATE utf8mb4_bin DEFAULT 'unemployed',
`job_grade` int(11) DEFAULT 0,
`position` varchar(36) COLLATE utf8mb4_bin DEFAULT NULL,
`bank` int(11) DEFAULT NULL,
`group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`firstname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
`lastname` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
`dateofbirth` varchar(25) COLLATE utf8mb4_bin DEFAULT '',
`sex` varchar(10) COLLATE utf8mb4_bin DEFAULT '',
`height` varchar(5) COLLATE utf8mb4_bin DEFAULT '',
`status` longtext COLLATE utf8mb4_bin DEFAULT NULL,
`is_dead` tinyint(1) DEFAULT 0,
`phone_number` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
`onDuty` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
`jail` int(11) NOT NULL DEFAULT 0,
`skills` longtext COLLATE utf8mb4_bin DEFAULT NULL,
`loadout` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '[]',
`metadata` longtext COLLATE utf8mb4_bin NOT NULL DEFAULT '[]',
`permission_level` int(11) DEFAULT 0,
`license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`house` longtext COLLATE utf8mb4_bin NOT NULL DEFAULT '{"owns":false,"furniture":[],"houseId":0}',
`bought_furniture` longtext COLLATE utf8mb4_bin NOT NULL DEFAULT '{}',
UNIQUE KEY `identifier` (`identifier`) USING BTREE,
KEY `identifier2` (`identifier`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
-- essentialmode.users: ~1 rows (yaklaşık) tablosu için veriler indiriliyor
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`identifier`, `money`, `name`, `job`, `job_grade`, `position`, `bank`, `group`, `firstname`, `lastname`, `dateofbirth`, `sex`, `height`, `status`, `is_dead`, `phone_number`, `onDuty`, `jail`, `skills`, `loadout`, `metadata`, `permission_level`, `license`, `house`, `bought_furniture`) VALUES
('Char1:1100001178f50d7', 0, 'Prenses Baran', 'unemployed', 0, '{"x":327.0,"z":54.1,"y":-221.1}', 473, 'superadmin', 'Alino', 'Godorov', '1995-01-01', 'f', '180', '[{"name":"hunger","val":965000,"percent":96.5},{"name":"thirst","val":973750,"percent":97.375}]', 0, '1010711', '0', 0, NULL, '[]', '[]', 0, NULL, '{"owns":false,"furniture":[],"houseId":0}', '{}'),
('steam:1100001178f50d7', 0, 'Prenses Baran', 'unemployed', 0, '{"x":0.0,"z":0.0,"y":0.0}', 200, 'user', '', '', '', '', '', '[{"name":"hunger","val":959100,"percent":95.91},{"name":"thirst","val":969325,"percent":96.9325}]', 0, '2326049', '0', 0, NULL, '[]', '[]', 0, NULL, '{"owns":false,"furniture":[],"houseId":0}', '{}');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
-- tablo yapısı dökülüyor essentialmode.user_lastcharacter
CREATE TABLE IF NOT EXISTS `user_lastcharacter` (
`steamid` varchar(255) NOT NULL,
`charid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- essentialmode.user_lastcharacter: ~0 rows (yaklaşık) tablosu için veriler indiriliyor
/*!40000 ALTER TABLE `user_lastcharacter` DISABLE KEYS */;
INSERT INTO `user_lastcharacter` (`steamid`, `charid`) VALUES
('steam:1100001178f50d7', 2);
/*!40000 ALTER TABLE `user_lastcharacter` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;