Installation

Welcome to the Quasar Smartphone PRO installation guide, here you can learn how to completely install our asset, following each step we will achieve a clean and fluid installation where you will not find any problems, as long as the documentation has been completed in full.

If you do not have programming experience, we recommend that you read each step completely without skipping any lines, since all documentation is important and should not be ignored under any circumstances. If you have a trusted developer, you can install this quickly, easily and safely if you complete this documentation step by step.

If at the end of this documentation you still have any problems, review each step again, after having checked that everything is correct, you can obtain more information about common errors in the Common Problems section within this same documentation to seek help independently.


Asset download

To find the asset, you must have made the purchase using your own keymaster account. Otherwise, you can use the transfer system to move the asset to a different keymaster account.

Once the purchase is made on our official website, you will receive your asset directly in your Keymaster, in your own panel you can download the asset and install it following the following documentation.

If you have more problems regarding Fivem Escrow, accounts or asset startup errors you can go here and see if any of them match your case, since Escrow requires some basic things for its operation, such as your keymaster account, your licensekey , etc.

pageFiveM Asset Escrow System

Asset dependencies

READ CAREFULLY: We strongly recommend NOT USING phpmyadmin. Use Heidisql and the most stable version of MariaDB.

To use this asset you must have gamebuild version 2545 or higher. If you do not complete this step, you will never be able to open or start the phone.

How to update the game build to version 2545?

This is a very simple step, we will directly access the artifacts for Windows or Linux, depending on our type of server. We will download it and replace it with the artifacts from our server.

Once this step was done, they added sv_enforceGameBuild 2545 in your server.cfg, make sure you don't have another convar with the same name or another version.

This asset has some dependencies that are completely mandatory and important for the operation of the asset. If you do not have these dependencies, your asset will probably start and have some error or message in its command console.

This system will adapt automatically if you want to use mx-surround!


Asset positioning

Correctly position the assets by following this step, if something goes wrong you will probably get errors about exports not found, do not skip this step.

For the execution of this asset, we will respect the respective order mentioned below. We recommend starting both dependencies and the same smartphone asset in the same [smartphone] folder. Otherwise we will have to start the dependencies first and then the qs-smartphone-pro.

-- First we will start the cores, never below
ensure es_extended or qb-core

-- Your inventory system, always on top
ensure [inventory]

-- Run qs-advancedgarages here along with its dependencies
ensure [smartphone] 

Database

Our Smartphone PRO system includes multiple databases, which will require you to wipe your current databases on other phones.

Before running the Smartphone PRO we will have to update and install our database, select the option that suits your framework since each one is different.

Database for esx

This database is exclusive for esx, if you do not use said framework, look for the next part of this document. This event will remove your current data and install the new ones completely.

ALTER TABLE
    `users`
ADD
    IF NOT EXISTS `cryptocurrency` LONGTEXT NOT NULL DEFAULT '',
ADD
    IF NOT EXISTS `crypto_wallet` INT(11) NULL DEFAULT '0',
ADD
    IF NOT EXISTS `phone_number` VARCHAR(25) NULL;

DROP TABLE IF EXISTS `crypto_transactions`;

CREATE TABLE `crypto_transactions` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `citizenid` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `title` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `message` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `date` TIMESTAMP NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `citizenid` (`citizenid`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `darkchat_messages`;

CREATE TABLE `darkchat_messages` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `owner` varchar(46) DEFAULT NULL,
    `name` varchar(50) DEFAULT '',
    `messages` text DEFAULT NULL,
    `password` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    KEY `id` (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 DEFAULT CHARSET = utf8mb4;

DROP TABLE IF EXISTS `instagram_accounts`;

CREATE TABLE `instagram_accounts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `phone` varchar(50) NOT NULL DEFAULT '0',
    `owner` varchar(120) DEFAULT NULL,
    `name` varchar(50) DEFAULT NULL,
    `username` varchar(50) DEFAULT '0',
    `password` varchar(50) NOT NULL DEFAULT '0',
    `avatar` text DEFAULT NULL,
    `bio` text DEFAULT NULL,
    `verified` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `username` (`username`) USING BTREE,
    KEY `phone` (`phone`) USING BTREE,
    KEY `id` (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `instagram_follow`;

CREATE TABLE `instagram_follow` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `follower` int(11) NOT NULL DEFAULT 0,
    `following` int(11) NOT NULL DEFAULT 0,
    `updatedDate` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 104 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `instagram_messages`;

CREATE TABLE `instagram_messages` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `sender` INT(11) NOT NULL DEFAULT '0',
    `receiver` INT(11) NOT NULL DEFAULT '0',
    `time` TIMESTAMP NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `messages` LONGTEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `instagram_notifications`;

CREATE TABLE `instagram_notifications` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL DEFAULT 0,
    `targetId` int(11) NOT NULL DEFAULT 0,
    `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
    `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 116 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `instagram_posts`;

CREATE TABLE `instagram_posts` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `time` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `userId` int(11) DEFAULT NULL,
    `data` longtext DEFAULT NULL,
    `content` text DEFAULT NULL,
    `description` text DEFAULT NULL,
    `type` tinytext DEFAULT NULL,
    `likes` text DEFAULT NULL,
    `filter` tinytext DEFAULT NULL,
    `commentCount` int(11) DEFAULT 0,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 525 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `instagram_post_comments` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) DEFAULT NULL,
    `postId` int(11) DEFAULT NULL,
    `comment` text DEFAULT NULL,
    `time` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id`),
    KEY `postId` (`postId`)
) ENGINE = InnoDB AUTO_INCREMENT = 4405 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;

DROP TRIGGER IF EXISTS `instagram_decrement_comment_count`;

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER `instagram_decrement_comment_count` AFTER DELETE ON `instagram_post_comments` FOR EACH ROW BEGIN
    UPDATE instagram_posts SET commentCount = commentCount + 1 WHERE id = OLD.postId;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

DROP TRIGGER IF EXISTS `instagram_increment_comment_count`;

SET @OLDTMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
DELIMITER //
CREATE TRIGGER `instagram_increment_comment_count` AFTER INSERT ON `instagram_post_comments` FOR EACH ROW BEGIN
    UPDATE instagram_posts SET commentCount = commentCount + 1 WHERE id = NEW.postId;
END//
DELIMITER ;
SET SQL_MODE=@OLDTMP_SQL_MODE;

DROP TABLE IF EXISTS `instagram_stories`;

CREATE TABLE `instagram_stories` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userId` int(11) NOT NULL DEFAULT 0,
    `updatedDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `data` text COLLATE armscii8_bin NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 DEFAULT CHARSET = armscii8 COLLATE = armscii8_bin;

DROP TABLE IF EXISTS `mail_accounts`;

CREATE TABLE `mail_accounts` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner` VARCHAR(50) NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_ci',
    `mail` VARCHAR(50) NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_ci',
    `name` VARCHAR(50) NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_ci',
    `password` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    `phone` VARCHAR(50) NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 14;

DROP TABLE IF EXISTS `phone_gallery`;

CREATE TABLE `phone_gallery` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `identifier` VARCHAR(46) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `content` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
    `type` VARCHAR(15) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `data` LONGTEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `filter` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `type` (`type`) USING BTREE,
    INDEX `identifier` (`identifier`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `phone_messages`;

CREATE TABLE `phone_messages` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `phone` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `number` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `messages` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `created` TIMESTAMP NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `unreaded` INT(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 150;

DROP TABLE IF EXISTS `phone_notifies`;

CREATE TABLE `phone_notifies` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `phone` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `msg_content` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `msg_head` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `app_name` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `msg_time` TIMESTAMP NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `phone_recipes`;

CREATE TABLE `phone_recipes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `number` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
    `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `player_contacts`;

CREATE TABLE `player_contacts` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `identifier` VARCHAR(46) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `name` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `number` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `iban` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `display` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `note` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `pp` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `isBlocked` INT(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `identifier` (`identifier`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 67;

DROP TABLE IF EXISTS `player_mails`;

CREATE TABLE `player_mails` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `taker` VARCHAR(46) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `sender` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `subject` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `message` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `read` TINYINT(4) NULL DEFAULT '0',
    `mailid` INT(11) NULL DEFAULT NULL,
    `date` TIMESTAMP NULL DEFAULT current_timestamp(),
    `button` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `medias` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `identifier` (`taker`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `tiktok_users`;

CREATE TABLE `tiktok_users` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `username` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `password` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `phone` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `pp` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `bio` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `birthday` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `videos` TEXT NOT NULL DEFAULT '{}' COLLATE 'utf8mb4_general_ci',
    `followers` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
    `following` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
    `liked` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
    `verified` INT(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `username` (`username`) USING BTREE,
    INDEX `id` (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `tiktok_videos`;

CREATE TABLE `tiktok_videos` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `userID` int(11) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `data` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `market_accounts`;

CREATE TABLE `market_accounts` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    `created` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
    `phone` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_unicode_ci',
    `name` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_unicode_ci',
    `username` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_unicode_ci',
    `avatar` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
    `password` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `username` (`username`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 3;

DROP TABLE IF EXISTS `market_messages`;

CREATE TABLE `market_messages` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `sender` INT(11) NOT NULL,
    `receiver` INT(11) NOT NULL,
    `time` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `messages` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
    `isMarket` INT(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 3;

DROP TABLE IF EXISTS `market_markets`;

CREATE TABLE `market_markets` (
    `id` INT(11) NOT NULL,
    `name` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    `description` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
    `job` TEXT NOT NULL DEFAULT '[]' COLLATE 'utf8mb4_unicode_ci',
    `ratings` TEXT NOT NULL DEFAULT '[]' COLLATE 'utf8mb4_unicode_ci',
    `coords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `twitter_accounts`;

CREATE TABLE `twitter_accounts` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner` VARCHAR(46) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_ci',
    `created` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `phone` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `username` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `password` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `avatar` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `bio` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `verified` INT(11) NULL DEFAULT NULL,
    `background` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `username` (`username`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 4;

DROP TABLE IF EXISTS `twitter_follow`;

CREATE TABLE `twitter_follow` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `follower` INT(11) NULL DEFAULT NULL,
    `following` INT(11) NULL DEFAULT NULL,
    `updatedDate` TIMESTAMP NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 14;

DROP TABLE IF EXISTS `twitter_messages`;

CREATE TABLE `twitter_messages` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `sender` INT(11) NOT NULL,
    `receiver` INT(11) NOT NULL,
    `time` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `messages` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 2;

DROP TABLE IF EXISTS `twitter_notifications`;

CREATE TABLE `twitter_notifications` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `userId` INT(11) NOT NULL DEFAULT '0',
    `targetUserId` INT(11) NOT NULL DEFAULT '0',
    `type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `tweetId` INT(11) NULL DEFAULT NULL,
    `time` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 28;

DROP TABLE IF EXISTS `twitter_retweets`;

CREATE TABLE `twitter_retweets` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `userId` INT(11) NOT NULL DEFAULT '0',
    `tweetId` INT(11) NOT NULL DEFAULT '0',
    `created` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 8;

DROP TABLE IF EXISTS `twitter_tweets`;

CREATE TABLE `twitter_tweets` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `userId` INT(11) NOT NULL,
    `time` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
    `text` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `media` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `likes` TEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_unicode_ci',
    `mentions` TEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_unicode_ci',
    `comments` TEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_unicode_ci',
    `retweets` TEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 19;

DROP TABLE IF EXISTS `phone_metadata`;

CREATE TABLE `phone_metadata` (
    `identifier` VARCHAR(90) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    `metadata` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `phoneNumber` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`identifier`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `phone_yellowpages`;

CREATE TABLE `phone_yellowpages` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `title` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `description` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `image` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `price` INT(11) NULL DEFAULT '0',
    `created` TIMESTAMP NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 4;

DROP TABLE IF EXISTS `phone_bills`;

CREATE TABLE `phone_bills` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `price` INT(11) NOT NULL DEFAULT '0',
    `identifier` VARCHAR(46) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `timestamp` TIMESTAMP NULL DEFAULT current_timestamp(),
    `sender` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `label` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `id` (`id`) USING BTREE,
    INDEX `identifier` (`identifier`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `whatsapp_accounts`;

CREATE TABLE `whatsapp_accounts` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `phone` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `avatar` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `bio` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `group_creator` INT(11) NULL DEFAULT NULL,
    `created` TIMESTAMP NULL DEFAULT current_timestamp(),
    `hide_receipts` INT(11) NULL DEFAULT '0',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `whatsapp_call_history`;

CREATE TABLE `whatsapp_call_history` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `caller` INT(11) NOT NULL DEFAULT '0',
    `calledId` INT(11) NULL DEFAULT NULL,
    `time` TIMESTAMP NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `whatsapp_call_history_users`;

CREATE TABLE `whatsapp_call_history_users` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `userId` INT(11) NOT NULL DEFAULT '0',
    `callId` INT(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `whatsapp_chats`;

CREATE TABLE `whatsapp_chats` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `sender` INT(11) NOT NULL DEFAULT '0',
    `receiver` INT(11) NOT NULL DEFAULT '0',
    `wallpaper` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `isGroup` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `time` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `messages` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 21;

DROP TABLE IF EXISTS `whatsapp_group_admins`;

CREATE TABLE `whatsapp_group_admins` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `userId` INT(11) NOT NULL DEFAULT '0',
    `groupId` INT(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 11;

DROP TABLE IF EXISTS `whatsapp_group_members`;

CREATE TABLE `whatsapp_group_members` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `userId` INT(11) NOT NULL DEFAULT '0',
    `groupId` INT(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 28;

DROP TABLE IF EXISTS `whatsapp_status`;

CREATE TABLE `whatsapp_status` (
    `userId` INT(11) NOT NULL DEFAULT '0',
    `data` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`userId`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `phone_app_store`;

CREATE TABLE `phone_app_store` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `application` VARCHAR(50) NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `ratings` TEXT NULL DEFAULT '[]' COLLATE 'utf8mb4_general_ci',
    `downloads` INT(11) NULL DEFAULT '0',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `weazel`;

CREATE TABLE `weazel` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner` VARCHAR(46) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `title` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `content` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `image` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
    `created` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 2;

DROP TABLE IF EXISTS `tinder_accounts`;

CREATE TABLE `tinder_accounts` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `phone` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `owner` VARCHAR(70) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `photos` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `dob` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `bio` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `password` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `gender` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `interested` VARCHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 7;

DROP TABLE IF EXISTS `tinder_messages`;

CREATE TABLE `tinder_messages` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `unread` INT(11) NOT NULL DEFAULT '0',
    `sender` INT(11) NOT NULL DEFAULT '0',
    `receiver` INT(11) NOT NULL DEFAULT '0',
    `time` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `messages` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 5;

DROP TABLE IF EXISTS `tinder_swipers`;

CREATE TABLE `tinder_swipers` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `userId` INT(11) NOT NULL DEFAULT '0',
    `targetId` INT(11) NOT NULL DEFAULT '0',
    `liked` INT(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 21;

DROP TABLE IF EXISTS `uber_rider_last_transactions`;

CREATE TABLE `uber_rider_last_transactions` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `date` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
    `target` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `targetName` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `plate` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `price` INT(11) NULL DEFAULT NULL,
    `type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 6;

DROP TABLE IF EXISTS `phone_chatrooms`;

CREATE TABLE `phone_chatrooms` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `room_code` VARCHAR(10) NOT NULL COLLATE 'utf8mb4_general_ci',
    `room_name` VARCHAR(15) NOT NULL COLLATE 'utf8mb4_general_ci',
    `room_owner_id` INT(11) NULL DEFAULT NULL,
    `room_owner_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `room_members` TEXT NULL DEFAULT '{}' COLLATE 'utf8mb4_general_ci',
    `room_pin` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `unpaid_balance` DECIMAL(10, 2) NULL DEFAULT '0.00',
    `is_masked` TINYINT(1) NULL DEFAULT '0',
    `is_pinned` TINYINT(1) NULL DEFAULT '0',
    `created` DATETIME NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `room_code` (`room_code`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

INSERT INTO
    `phone_chatrooms` (
        `room_code`,
        `room_name`,
        `room_owner_id`,
        `room_owner_name`,
        `is_pinned`
    )
VALUES
    ('411', '411', -1, 'Government', 1),
    (
        'lounge',
        'The Lounge',
        -1,
        'Government',
        1
    ),
    ('events', 'Events', -1, 'Government', 1);

DROP TABLE IF EXISTS `phone_chatroom_messages`;

CREATE TABLE `phone_chatroom_messages` (
    `id` INT unsigned NOT NULL AUTO_INCREMENT,
    `room_id` INT unsigned,
    `member_id` VARCHAR(20),
    `member_name` VARCHAR(50),