Step 5
Database installation
If you receive missing columns or tables errors, repeat this step more slowly and in parts.
Quasar Smartphone contains a very large database, which may have some table names that are similar to those of your old phone, but they are not, therefore it is important to always remove the sql from your old phone or make sure that none table is duplicated.
To do this, we will execute the following code in our sql:
DROP TABLE IF EXISTS `insta_stories`;
DROP TABLE IF EXISTS `instagram_stories`;
DROP TABLE IF EXISTS `instagram_account`;
DROP TABLE IF EXISTS `instagram_followers`;
DROP TABLE IF EXISTS `instagram_posts`;
DROP TABLE IF EXISTS `tinder_accounts`;
DROP TABLE IF EXISTS `tinder_likes`;
DROP TABLE IF EXISTS `phone_invoices`;
DROP TABLE IF EXISTS `phone_accounts`;
DROP TABLE IF EXISTS `phone_chats`;
DROP TABLE IF EXISTS `phone_messages`;
DROP TABLE IF EXISTS `phone_notifies`;
DROP TABLE IF EXISTS `phone_alertjobs`;
DROP TABLE IF EXISTS `phone_news`;
DROP TABLE IF EXISTS `player_contacts`;
DROP TABLE IF EXISTS `player_gallery`;
DROP TABLE IF EXISTS `player_notes`;
DROP TABLE IF EXISTS `player_mails`;
DROP TABLE IF EXISTS `tinder_messages`;
DROP TABLE IF EXISTS `twitter_account`;
DROP TABLE IF EXISTS `twitter_hashtags`;
DROP TABLE IF EXISTS `twitter_mentions`;
DROP TABLE IF EXISTS `twitter_tweets`;
DROP TABLE IF EXISTS `whatsapp_accounts`;
DROP TABLE IF EXISTS `whatsapp_chats`;
DROP TABLE IF EXISTS `whatsapp_chats_messages`;
DROP TABLE IF EXISTS `whatsapp_groups`;
DROP TABLE IF EXISTS `whatsapp_groups_messages`;
DROP TABLE IF EXISTS `whatsapp_groups_users`;
DROP TABLE IF EXISTS `yellowpages_posts`;
DROP TABLE IF EXISTS `whatsapp_stories`;
DROP TABLE IF EXISTS `darkchat_messages`;
DROP TABLE IF EXISTS `tiktok_users`;
DROP TABLE IF EXISTS `tiktok_videos`;
DROP TABLE IF EXISTS `crypto_transactions`;
DROP TABLE IF EXISTS `phone_crypto`;Once this is executed, we will continue installing the sql of our new Smartphone, make sure to install all of them or install them little by little so as not to receive missing column errors.
The sql of the players table is as follows, don't forget to install any:
ALTER TABLE `users` ADD IF NOT EXISTS `apps` TEXT;
ALTER TABLE `users` ADD IF NOT EXISTS `widget` TEXT;
ALTER TABLE `users` ADD IF NOT EXISTS `bt` TEXT;
ALTER TABLE `users` ADD IF NOT EXISTS `charinfo` TEXT;
ALTER TABLE `users` ADD IF NOT EXISTS `metadata` mediumtext;
ALTER TABLE `users` ADD IF NOT EXISTS `cryptocurrency` longtext;
ALTER TABLE `users` ADD IF NOT EXISTS `cryptocurrencytransfers` TEXT;
ALTER TABLE `users` ADD IF NOT EXISTS `phonePos` TEXT;
ALTER TABLE `users` ADD IF NOT EXISTS `spotify` TEXT;
ALTER TABLE `users` ADD IF NOT EXISTS `ringtone` TEXT;
ALTER TABLE `users` ADD IF NOT EXISTS `first_screen_showed` INT(11) DEFAULT NULL;The sql of our complete phone and all its applications is as follows, do not forget to install any so as not to receive errors:
CREATE TABLE IF NOT EXISTS `insta_stories` (
`username` varchar(50),
`location` varchar(50),
`filter` varchar(50),
`description` varchar(50),
`image` text,
`created` time
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `instagram_stories` (
`owner` varchar(50) COLLATE armscii8_bin,
`data` text COLLATE armscii8_bin,
PRIMARY KEY (`owner`) USING BTREE
) ENGINE = InnoDB DEFAULT CHARSET = armscii8 COLLATE = armscii8_bin;
CREATE TABLE IF NOT EXISTS `instagram_account` (
`id` varchar(90) NOT NULL,
`name` varchar(50) NOT NULL,
`phone` varchar(50) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`avatar` text,
`description` text,
`verify` INT(11) NOT NULL DEFAULT '0'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `instagram_followers` (
`username` varchar(50) NOT NULL,
`followed` varchar(50) NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `instagram_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`image` text NOT NULL,
`description` varchar(255) NOT NULL,
`location` varchar(50) NOT NULL DEFAULT 'Los Santos',
`filter` varchar(50) NOT NULL,
`created` timestamp NOT NULL,
`likes` TEXT COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 14 DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `player_mails` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NULL COLLATE 'utf8mb4_general_ci',
`sender` VARCHAR(50) NULL COLLATE 'utf8mb4_general_ci',
`subject` VARCHAR(50) NULL COLLATE 'utf8mb4_general_ci',
`message` TEXT NULL COLLATE 'utf8mb4_general_ci',
`read` TINYINT(4) NULL,
`mailid` INT(11) NULL,
`date` TIMESTAMP NULL DEFAULT current_timestamp(),
`button` TEXT COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE,
INDEX `identifier` (`identifier`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 2;
CREATE TABLE IF NOT EXISTS `tinder_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`phone` varchar(50) NOT NULL DEFAULT '0',
`pp` text NOT NULL,
`name` varchar(50) NOT NULL DEFAULT '0',
`gender` varchar(50) NOT NULL,
`targetGender` varchar(50) NOT NULL DEFAULT '0',
`hobbies` varchar(50) NOT NULL DEFAULT '0',
`age` varchar(50) NOT NULL DEFAULT '0',
`description` varchar(50) NOT NULL DEFAULT '0',
`password` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 17 DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `tinder_likes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`phone` varchar(1024) NOT NULL,
`likeds` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `phone_invoices` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`citizenid` varchar(50) DEFAULT NULL,
`amount` int(11) NOT NULL DEFAULT 0,
`society` tinytext DEFAULT NULL,
`sender` varchar(50) NULL,
`sendercitizenid` varchar(50) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
CREATE TABLE IF NOT EXISTS `phone_accounts` (
`app` varchar(50) NOT NULL,
`id` varchar(80) NOT NULL,
`name` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`birthdate` varchar(50) NOT NULL,
`gender` varchar(50) NOT NULL,
`interested` text NOT NULL,
`avatar` text NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `phone_chats` (
`app` varchar(50) NOT NULL,
`author` varchar(50) NOT NULL,
`number` varchar(50) NOT NULL,
`created` varchar(50) NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `phone_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`phone` varchar(50),
`number` varchar(50) NOT NULL,
`owner` varchar(50),
`messages` text NOT NULL,
`type` varchar(50),
`read` int(11),
`created` varchar(50),
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 20 DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `phone_notifies` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`phone` varchar(50) NOT NULL,
`msg_content` text NOT NULL,
`msg_head` varchar(50) NOT NULL DEFAULT '',
`app_name` text NOT NULL,
`msg_time` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 64 DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `player_contacts` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`name` VARCHAR(50) 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) COLLATE 'utf8mb4_general_ci',
`note` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
`pp` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
`isBlocked` INT(11) NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `identifier` (`identifier`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 38;
CREATE TABLE IF NOT EXISTS `player_gallery` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
`resim` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
`data` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
`created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 11;
CREATE TABLE IF NOT EXISTS `tinder_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`phone` varchar(50) NOT NULL,
`number` longtext NOT NULL,
`messages` longtext DEFAULT '{}',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11;
CREATE TABLE IF NOT EXISTS `twitter_account` (
`id` varchar(90) NOT NULL,
`name` varchar(50) NOT NULL,
`phone` varchar(50) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`avatar` text NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `twitter_hashtags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) NOT NULL,
`created` varchar(50) NOT NULL,
`count` int(11) NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `twitter_mentions` (
`id` INT(11) NOT NULL AUTO_INCREMENT COLLATE 'utf8mb4_general_ci',
`id_tweet` INT(11) NOT NULL COLLATE 'utf8mb4_general_ci',
`username` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
`mentioned` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
`created` VARCHAR(50) NOT NULL COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 4;
CREATE TABLE IF NOT EXISTS `twitter_tweets` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`username` varchar(80) NOT NULL,
`message` longtext NOT NULL,
`hashtags` varchar(50) NOT NULL,
`mentions` varchar(50) NOT NULL,
`created` varchar(50) NOT NULL,
`image` text NOT NULL,
`likes` TEXT NULL COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 24 DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `whatsapp_accounts` (
`id` varchar(100) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
`name` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
`phone` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
`password` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
`avatar` text NOT NULL COLLATE UTF8MB4_UNICODE_CI
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `whatsapp_chats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`phone` varchar(50) NOT NULL,
`number` varchar(50) NOT NULL,
`created` varchar(50) NOT NULL,
`messages` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 43 DEFAULT CHARSET = utf8mb4;
DROP TABLE IF EXISTS `whatsapp_chats_messages`;
CREATE TABLE IF NOT EXISTS `whatsapp_chats_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_chat` int(11) NOT NULL,
`owner` varchar(50) NOT NULL,
`type` varchar(50) NOT NULL,
`created` varchar(50) NOT NULL,
`message` text NOT NULL,
`readed` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
CREATE TABLE IF NOT EXISTS `whatsapp_groups` (
`id` int(11) AUTO_INCREMENT,
`phone` varchar(50) NOT NULL,
`number` varchar(50) NOT NULL,
`type` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL,
`image` text NOT NULL,
`created` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = utf8mb4;
DROP TABLE IF EXISTS `whatsapp_groups_messages`;
CREATE TABLE IF NOT EXISTS `whatsapp_groups_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_group` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`owner` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`message` text COLLATE utf8mb4_unicode_ci NOT NULL,
`created` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`read` int(11) NOT NULL,
`name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `whatsapp_groups_users` (
`number_group` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
`admin` int(11) NOT NULL COLLATE UTF8MB4_UNICODE_CI,
`phone` varchar(50) NOT NULL COLLATE UTF8MB4_UNICODE_CI
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `player_notes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` text NOT NULL,
`baslik` text NOT NULL,
`aciklama` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `whatsapp_stories` (
`phone` varchar(50) NOT NULL,
`image` text NOT NULL,
`created` varchar(50) NOT NULL,
`description` varchar(50),
`location` varchar(50),
`filter` varchar(50)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `darkchat_messages` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`password` text NOT NULL,
`owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`name` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`messages` TEXT NULL COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 10;
CREATE TABLE IF NOT EXISTS `phone_alertjobs` (
`id` int(11) NOT NULL,
`job` varchar(255) NOT NULL,
`alerts` longtext NULL,
`date` timestamp NULL DEFAULT current_timestamp()
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;
CREATE TABLE IF NOT EXISTS `yellowpages_posts` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`message` TEXT,
`name` VARCHAR(255),
`number` VARCHAR(20),
`url` VARCHAR(255)
);
CREATE TABLE IF NOT EXISTS `phone_news` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`title` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`content` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`image` TEXT 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=5;
CREATE TABLE IF NOT EXISTS `tiktok_users` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`phone` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`pp` TEXT 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',
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=13
;
CREATE TABLE IF NOT EXISTS `tiktok_videos` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`userID` INT(11) NULL DEFAULT NULL,
`created` VARCHAR(50) NOT NULL DEFAULT '00:00:00' COLLATE 'utf8mb4_unicode_ci',
`data` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`phone` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=440
;
ALTER TABLE `phone_alertjobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `job` (`job`);
ALTER TABLE `phone_alertjobs`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;
ALTER TABLE whatsapp_groups_messages CONVERT TO CHARACTER SET utf8mb4 COLLATE UTF8MB4_UNICODE_CI;
ALTER TABLE whatsapp_groups_users CONVERT TO CHARACTER SET utf8mb4 COLLATE UTF8MB4_UNICODE_CI;
ALTER TABLE whatsapp_accounts CONVERT TO CHARACTER SET utf8mb4 COLLATE UTF8MB4_UNICODE_CI;
ALTER TABLE whatsapp_chats_messages CONVERT TO CHARACTER SET utf8mb4 COLLATE UTF8MB4_UNICODE_CI;Last updated