Links

okokPhone

Installation Guide

Requirements:

Execute the following SQL code in your database:

ESX
QBCore
CREATE TABLE IF NOT EXISTS `okokphone_backups` (
`imei` varchar(100) NOT NULL,
`owner` varchar(100) NOT NULL,
`avatar` mediumtext NOT NULL,
`name` varchar(255) NOT NULL,
`phone_number` varchar(10) NOT NULL,
`pincode` varchar(10) NOT NULL,
`wallpaper` varchar(255) NOT NULL,
`ringtone` varchar(255) NOT NULL,
`notification_sound` varchar(255) NOT NULL,
`notifications` longtext NOT NULL,
`lockscreen` varchar(255) NOT NULL,
`homescreen` longtext NOT NULL,
`gallery` longtext NOT NULL,
`albums` longtext NOT NULL,
`contacts` longtext NOT NULL,
`chats` longtext NOT NULL,
`notes` longtext NOT NULL,
`clock` longtext NOT NULL,
`settings` longtext NOT NULL,
`flashlight_color` mediumtext NOT NULL,
`last_location` mediumtext DEFAULT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`imei`),
KEY `imei` (`imei`),
KEY `owner` (`owner`),
KEY `phone_number` (`phone_number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `okokphone_call_logs` (
`id` varchar(100) NOT NULL DEFAULT '0',
`caller` varchar(100) NOT NULL,
`caller_imei` varchar(100) NOT NULL,
`receiver` varchar(100) NOT NULL,
`receiver_imei` varchar(100) DEFAULT NULL,
`type` varchar(50) NOT NULL DEFAULT '0',
`duration` int(11) NOT NULL DEFAULT 0,
`timestamp` datetime(3) NOT NULL,
`caller_history` tinyint(4) NOT NULL,
`receiver_history` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `caller` (`caller`),
KEY `receiver` (`receiver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okokphone_chats` (
`app` varchar(100) NOT NULL,
`id` varchar(36) NOT NULL,
`author` longtext NOT NULL,
`participants` longtext NOT NULL,
`last_message` text NOT NULL,
`timestamp` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `app` (`app`),
KEY `author` (`author`(768))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okokphone_chat_messages` (
`app` varchar(50) NOT NULL DEFAULT '',
`id` varchar(36) NOT NULL,
`chat_id` varchar(36) NOT NULL,
`author` longtext NOT NULL,
`text` text NOT NULL,
`media_src` varchar(512) DEFAULT NULL,
`media_type` varchar(10) DEFAULT NULL,
`audio` varchar(512) DEFAULT NULL,
`gps` text DEFAULT NULL,
`timestamp` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `app` (`app`),
KEY `id` (`id`),
KEY `chat_id` (`chat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okokphone_media` (
`id` varchar(36) NOT NULL,
`creator` varchar(100) DEFAULT NULL,
`type` enum('image','video') NOT NULL,
`src` varchar(512) NOT NULL DEFAULT '',
`width` int(11) NOT NULL DEFAULT 0,
`height` int(11) NOT NULL DEFAULT 0,
`timestamp` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `type` (`type`),
KEY `owner` (`creator`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okokphone_phones` (
`imei` varchar(100) NOT NULL,
`owner` varchar(100) NOT NULL,
`avatar` mediumtext NOT NULL,
`name` varchar(255) NOT NULL,
`phone_number` varchar(10) NOT NULL,
`pincode` varchar(10) NOT NULL,
`wallpaper` varchar(255) NOT NULL,
`ringtone` varchar(255) NOT NULL,
`notification_sound` varchar(255) NOT NULL,
`notifications` longtext NOT NULL,
`lockscreen` varchar(255) NOT NULL,
`homescreen` longtext NOT NULL,
`gallery` longtext NOT NULL,
`albums` longtext NOT NULL,
`contacts` longtext NOT NULL,
`chats` longtext NOT NULL,
`notes` longtext NOT NULL,
`clock` longtext NOT NULL,
`settings` longtext NOT NULL,
`flashlight_color` mediumtext NOT NULL,
`last_location` mediumtext DEFAULT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`imei`),
KEY `imei` (`imei`),
KEY `owner` (`owner`),
KEY `phone_number` (`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_darknet_accounts` (
`id` varchar(36) NOT NULL,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`avatar` varchar(255) NOT NULL,
`chats` longtext NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_darknet_chats` (
`id` varchar(36) NOT NULL,
`author` varchar(255) NOT NULL,
`partner` varchar(255) NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `partner` (`partner`),
KEY `creator` (`author`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_darknet_listings` (
`id` varchar(36) NOT NULL,
`author` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`thumbnail` mediumtext NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_marketplace_ads` (
`id` varchar(36) NOT NULL,
`title` varchar(100) NOT NULL,
`description` varchar(100) NOT NULL,
`price` int(11) NOT NULL DEFAULT 0,
`img` varchar(255) NOT NULL DEFAULT '0',
`phone_number` int(11) NOT NULL DEFAULT 0,
`creator` varchar(50) NOT NULL DEFAULT '',
`expiration` datetime(3) NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_racing_history` (
`id` varchar(36) NOT NULL,
`type` varchar(50) NOT NULL,
`location` varchar(255) NOT NULL,
`winner` varchar(255) NOT NULL DEFAULT '',
`entry_fee` int(11) unsigned NOT NULL,
`prize` int(10) unsigned NOT NULL,
`participants` longtext NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_racing_leaderboard` (
`identifier` varchar(50) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`elo` int(10) unsigned NOT NULL,
`earnings` int(10) unsigned NOT NULL,
`wins` int(10) unsigned NOT NULL,
`losses` int(10) unsigned NOT NULL,
`race_history` longtext NOT NULL,
PRIMARY KEY (`identifier`),
KEY `identifier` (`identifier`),
KEY `elo` (`elo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_racing_routes` (
`id` varchar(36) NOT NULL,
`name` varchar(255) NOT NULL,
`location` varchar(255) NOT NULL,
`creator` varchar(50) NOT NULL,
`checkpoints` longtext NOT NULL,
`timestamp` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_v_accounts` (
`username` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL,
`verified` tinyint(1) DEFAULT 0,
`avatar` varchar(255) NOT NULL,
`name` varchar(50) DEFAULT NULL,
`bio` varchar(150) DEFAULT NULL,
`background` varchar(255) DEFAULT NULL,
`following` longtext NOT NULL,
`followers` longtext NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`username`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_v_chats` (
`id` varchar(36) NOT NULL,
`author` varchar(255) NOT NULL,
`partner` varchar(255) NOT NULL,
`created_at` datetime(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_v_comments` (
`id` varchar(36) NOT NULL,
`post_id` varchar(36) NOT NULL,
`author` varchar(50) NOT NULL,
`text` varchar(255) NOT NULL,
`likes` longtext NOT NULL,
`media` longtext DEFAULT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `post_id` (`post_id`),
KEY `author` (`author`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_v_posts` (
`id` varchar(36) NOT NULL DEFAULT '',
`author` varchar(50) NOT NULL,
`text` varchar(255) NOT NULL,
`likes` longtext NOT NULL,
`comments` int(10) unsigned NOT NULL,
`tags` longtext NOT NULL,
`media` longtext DEFAULT NULL,
`timestamp` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `author` (`author`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_v_shorts` (
`id` varchar(36) NOT NULL,
`author` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`likes` longtext NOT NULL,
`comments` int(11) NOT NULL,
`src` mediumtext NOT NULL,
`created_at` datetime(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `luxucex_market_transactions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`identifier` varchar(100) NOT NULL,
`type` enum('buy','sell') NOT NULL,
`coin` varchar(50) NOT NULL,
`amount` decimal(20,8) unsigned NOT NULL,
`price` decimal(20,8) unsigned NOT NULL,
`created_at` datetime NOT NULL DEFAULT curtime(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `luxucex_transfers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sender` varchar(100) NOT NULL,
`receiver` int(100) unsigned NOT NULL,
`coin` int(10) unsigned NOT NULL,
`amount` decimal(20,8) unsigned NOT NULL,
`created_at` datetime NOT NULL DEFAULT curtime(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `luxucex_positions` (
`code` char(36) NOT NULL,
`pair` varchar(100) NOT NULL,
`type` varchar(100) NOT NULL,
`contract_quantity` varchar(100) NOT NULL,
`entry` float NOT NULL,
`leverage` int(11) NOT NULL,
`allocated_margin` float NOT NULL,
`date` datetime NOT NULL DEFAULT current_timestamp(),
`liquidation` float DEFAULT NULL,
`owner` varchar(100) NOT NULL,
PRIMARY KEY (`code`)
);
CREATE TABLE `luxucex_tradinghistory` (
`key` int(11) NOT NULL AUTO_INCREMENT,
`pair` varchar(100) NOT NULL,
`entry` varchar(100) DEFAULT NULL,
`margin` varchar(100) NOT NULL,
`leverage` varchar(100) NOT NULL,
`size` varchar(100) NOT NULL,
`type` varchar(100) NOT NULL,
`close` varchar(100) DEFAULT NULL,
`date` datetime NOT NULL DEFAULT current_timestamp(),
`action` varchar(100) NOT NULL,
`pnl` varchar(100) DEFAULT NULL,
`owner` varchar(100) NOT NULL,
PRIMARY KEY (`key`)
);
ALTER TABLE `users` ADD COLUMN `luxucryptoaddress` longtext;
ALTER TABLE `users` ADD COLUMN `luxucexassets` longtext NOT NULL DEFAULT '{}';
ALTER TABLE `users` ADD COLUMN `luxucwbalance` float NOT NULL DEFAULT '0';
CREATE TABLE IF NOT EXISTS `okokphone_backups` (
`imei` varchar(100) NOT NULL,
`owner` varchar(100) NOT NULL,
`avatar` mediumtext NOT NULL,
`name` varchar(255) NOT NULL,
`phone_number` varchar(10) NOT NULL,
`pincode` varchar(10) NOT NULL,
`wallpaper` varchar(255) NOT NULL,
`ringtone` varchar(255) NOT NULL,
`notification_sound` varchar(255) NOT NULL,
`notifications` longtext NOT NULL,
`lockscreen` varchar(255) NOT NULL,
`homescreen` longtext NOT NULL,
`gallery` longtext NOT NULL,
`albums` longtext NOT NULL,
`contacts` longtext NOT NULL,
`chats` longtext NOT NULL,
`notes` longtext NOT NULL,
`clock` longtext NOT NULL,
`settings` longtext NOT NULL,
`flashlight_color` mediumtext NOT NULL,
`last_location` mediumtext DEFAULT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`imei`),
KEY `imei` (`imei`),
KEY `owner` (`owner`),
KEY `phone_number` (`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `okokphone_call_logs` (
`id` varchar(100) NOT NULL DEFAULT '0',
`caller` varchar(36) NOT NULL,
`caller_imei` varchar(100) NOT NULL,
`receiver` varchar(36) NOT NULL,
`receiver_imei` varchar(100) DEFAULT NULL,
`type` varchar(50) NOT NULL DEFAULT '0',
`duration` int(11) NOT NULL DEFAULT 0,
`timestamp` datetime(3) NOT NULL,
`caller_history` tinyint(4) NOT NULL,
`receiver_history` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `caller` (`caller`),
KEY `receiver` (`receiver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okokphone_chats` (
`app` varchar(100) NOT NULL,
`id` varchar(36) NOT NULL,
`author` longtext NOT NULL,
`participants` longtext NOT NULL,
`last_message` text NOT NULL,
`timestamp` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `app` (`app`),
KEY `author` (`author`(768))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okokphone_chat_messages` (
`app` varchar(50) NOT NULL DEFAULT '',
`id` varchar(36) NOT NULL,
`chat_id` varchar(36) NOT NULL,
`author` longtext NOT NULL,
`text` text NOT NULL,
`media_src` varchar(512) DEFAULT NULL,
`media_type` varchar(10) DEFAULT NULL,
`audio` varchar(512) DEFAULT NULL,
`gps` text DEFAULT NULL,
`timestamp` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `app` (`app`),
KEY `id` (`id`),
KEY `chat_id` (`chat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okokphone_media` (
`id` varchar(36) NOT NULL,
`creator` varchar(100) DEFAULT NULL,
`type` enum('image','video') NOT NULL,
`src` varchar(512) NOT NULL DEFAULT '',
`width` int(11) NOT NULL DEFAULT 0,
`height` int(11) NOT NULL DEFAULT 0,
`timestamp` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `type` (`type`),
KEY `owner` (`creator`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okokphone_phones` (
`imei` varchar(100) NOT NULL,
`owner` varchar(100) NOT NULL,
`avatar` mediumtext NOT NULL,
`name` varchar(255) NOT NULL,
`phone_number` varchar(10) NOT NULL,
`pincode` varchar(10) NOT NULL,
`wallpaper` varchar(255) NOT NULL,
`ringtone` varchar(255) NOT NULL,
`notification_sound` varchar(255) NOT NULL,
`notifications` longtext NOT NULL,
`lockscreen` varchar(255) NOT NULL,
`homescreen` longtext NOT NULL,
`gallery` longtext NOT NULL,
`albums` longtext NOT NULL,
`contacts` longtext NOT NULL,
`chats` longtext NOT NULL,
`notes` longtext NOT NULL,
`clock` longtext NOT NULL,
`settings` longtext NOT NULL,
`flashlight_color` mediumtext NOT NULL,
`last_location` mediumtext DEFAULT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`imei`),
KEY `imei` (`imei`),
KEY `owner` (`owner`),
KEY `phone_number` (`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_darknet_accounts` (
`id` varchar(36) NOT NULL,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`avatar` varchar(255) NOT NULL,
`chats` longtext NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_darknet_chats` (
`id` varchar(36) NOT NULL,
`author` varchar(255) NOT NULL,
`partner` varchar(255) NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `partner` (`partner`),
KEY `creator` (`author`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_darknet_listings` (
`id` varchar(36) NOT NULL,
`author` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
`thumbnail` mediumtext NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_marketplace_ads` (
`id` varchar(36) NOT NULL,
`title` varchar(100) NOT NULL,
`description` varchar(100) NOT NULL,
`price` int(11) NOT NULL DEFAULT 0,
`img` varchar(255) NOT NULL DEFAULT '0',
`phone_number` int(11) NOT NULL DEFAULT 0,
`creator` varchar(50) NOT NULL DEFAULT '',
`expiration` datetime(3) NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_racing_history` (
`id` varchar(36) NOT NULL,
`type` varchar(50) NOT NULL,
`location` varchar(255) NOT NULL,
`winner` varchar(255) NOT NULL DEFAULT '',
`entry_fee` int(11) unsigned NOT NULL,
`prize` int(10) unsigned NOT NULL,
`participants` longtext NOT NULL,
`created_at` datetime(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_racing_leaderboard` (
`identifier` varchar(50) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`elo` int(10) unsigned NOT NULL,
`earnings` int(10) unsigned NOT NULL,
`wins` int(10) unsigned NOT NULL,
`losses` int(10) unsigned NOT NULL,
`race_history` longtext NOT NULL,
PRIMARY KEY (`identifier`),
KEY `identifier` (`identifier`),
KEY `elo` (`elo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `okp_racing_routes` (
`id` varchar(36) NOT NULL,
`name` varchar(255) NOT NULL,
`location` varchar(255) NOT NULL,
`creator` varchar(50) NOT NULL,
`checkpoints` longtext NOT NULL,