-- --------------------------------------------------------
-- Värd: 127.0.0.1
-- Serverversion: 10.4.28-MariaDB - mariadb.org binary distribution
-- Server-OS: Win64
-- HeidiSQL Version: 12.5.0.6677
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;-- Dumpar databasstruktur för vrpfx
CREATE DATABASE IF NOT EXISTS `vrpfx`
/*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;USE `vrpfx`;-- Dumpar struktur för tabell vrpfx.bilforhandler
CREATE TABLE IF NOT EXISTS `bilforhandler` (
`id` int(11) NOT NULL,
`vehicle` varchar(100) NOT NULL,
`vehicle_name` varchar(255) DEFAULT NULL,
`type` varchar(10) DEFAULT NULL,
`price` varchar(255) DEFAULT NULL,
`stock` int(11) DEFAULT 0
) ENGINE = InnoDB DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.clothing_outfits
CREATE TABLE IF NOT EXISTS `clothing_outfits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`citizenid` varchar(255) NOT NULL,
`modelHash` text NOT NULL,
`name` text NOT NULL,
`outfit` text NOT NULL,
`uniqueOutfitid` text DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 52 DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.cpr
CREATE TABLE IF NOT EXISTS `cpr` (
`id` varchar(50) DEFAULT NULL,
`antal` varchar(255) DEFAULT NULL,
`timer` int(255) DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.kaz_combatlog
CREATE TABLE IF NOT EXISTS `kaz_combatlog` (
`id` int(11) NOT NULL,
`deadstatus` varchar(255) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.mdt_reports
CREATE TABLE IF NOT EXISTS `mdt_reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_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,
`months` int(11) DEFAULT NULL,
`fine` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 46 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.mdt_warrants
CREATE TABLE IF NOT EXISTS `mdt_warrants` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`user_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`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.mm_offduty
CREATE TABLE IF NOT EXISTS `mm_offduty` (
`user_id` int(11) DEFAULT NULL,
`job` varchar(255) DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.mm_onduty
CREATE TABLE IF NOT EXISTS `mm_onduty` (
`user_id` int(11) DEFAULT NULL,
`nr` varchar(255) DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.mm_salary
CREATE TABLE IF NOT EXISTS `mm_salary` (
`user_id` int(11) DEFAULT NULL,
`tid` varchar(255) DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.okokbanking_societies
CREATE TABLE IF NOT EXISTS `okokbanking_societies` (
`society` varchar(255) DEFAULT NULL,
`society_name` varchar(255) DEFAULT NULL,
`value` int(50) DEFAULT NULL,
`iban` varchar(255) NOT NULL,
`is_withdrawing` int(1) DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.okokbanking_transactions
CREATE TABLE IF NOT EXISTS `okokbanking_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`receiver_identifier` varchar(255) NOT NULL,
`receiver_name` varchar(255) NOT NULL,
`sender_identifier` varchar(255) NOT NULL,
`sender_name` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`value` int(50) NOT NULL,
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 55 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.omik_polititabletan
CREATE TABLE IF NOT EXISTS `omik_polititabletan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`name` text NOT NULL,
`phone` text NOT NULL,
`profileLogo` text NOT NULL DEFAULT 'https://i.imgur.com/DGW6ZHZ.png',
`rank` text NOT NULL,
`extraRank` text NOT NULL,
`badgeNumber` text NOT NULL,
`password` text NOT NULL,
`ranks` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`ranks`)),
`certs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`certs`)),
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 15 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.omik_polititabletans
CREATE TABLE IF NOT EXISTS `omik_polititabletans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`type` text NOT NULL,
`badge` int(11) NOT NULL,
`name` text NOT NULL,
`reason` text NOT NULL,
`dato` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`icon` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 32 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.omik_polititabletbo
CREATE TABLE IF NOT EXISTS `omik_polititabletbo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`law` text NOT NULL,
`para` text NOT NULL,
`offense` text NOT NULL,
`price` int(11) NOT NULL,
`clip` int(11) NOT NULL,
`jail` int(11) DEFAULT 0,
`disq` text NOT NULL,
`info` text NOT NULL,
`amount` int(11) DEFAULT 1,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 7 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.omik_polititabletef
CREATE TABLE IF NOT EXISTS `omik_polititabletef` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` timestamp NOT NULL DEFAULT current_timestamp(),
`creator` text NOT NULL,
`name` text NOT NULL,
`offense` text NOT NULL,
`reason` text NOT NULL,
`price` int(11) NOT NULL,
`jail` int(11) NOT NULL,
`disq` text NOT NULL,
`status` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.omik_polititabletefk
CREATE TABLE IF NOT EXISTS `omik_polititabletefk` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL DEFAULT current_timestamp(),
`creator` text NOT NULL,
`numberplate` text NOT NULL,
`reason` text NOT NULL,
`status` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.omik_polititabletinf
CREATE TABLE IF NOT EXISTS `omik_polititabletinf` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`writer` text NOT NULL,
`date` timestamp NOT NULL DEFAULT current_timestamp(),
`content` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.omik_polititabletkr
CREATE TABLE IF NOT EXISTS `omik_polititabletkr` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`cprNumber` int(11) NOT NULL,
`profileLogo` text NOT NULL DEFAULT 'https://i.imgur.com/DGW6ZHZ.png',
`height` int(11) NOT NULL,
`clip` int(11) NOT NULL,
`phone` text NOT NULL,
`disq` text NOT NULL,
`name` text NOT NULL,
`age` int(11) NOT NULL,
`bdate` text NOT NULL,
`records` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '[]' CHECK (json_valid(`records`)),
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 16 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_backups
CREATE TABLE IF NOT EXISTS `phone_backups` (
`identifier` varchar(100) NOT NULL,
`phone_number` varchar(15) NOT NULL,
PRIMARY KEY (`identifier`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_backups_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_clock_alarms
CREATE TABLE IF NOT EXISTS `phone_clock_alarms` (
`id` varchar(10) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`hours` int(2) NOT NULL DEFAULT 0,
`minutes` int(2) NOT NULL DEFAULT 0,
`label` varchar(50) DEFAULT NULL,
`enabled` tinyint(1) DEFAULT 1,
PRIMARY KEY (`id`, `phone_number`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_clock_alarms_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_crypto
CREATE TABLE IF NOT EXISTS `phone_crypto` (
`identifier` varchar(100) NOT NULL,
`coin` varchar(15) NOT NULL,
`amount` double NOT NULL DEFAULT 0,
`invested` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`identifier`, `coin`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_darkchat_accounts
CREATE TABLE IF NOT EXISTS `phone_darkchat_accounts` (
`phone_number` varchar(15) NOT NULL,
`username` varchar(20) NOT NULL,
PRIMARY KEY (`username`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_darkchat_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_darkchat_channels
CREATE TABLE IF NOT EXISTS `phone_darkchat_channels` (
`name` varchar(50) NOT NULL,
`last_message` varchar(50) NOT NULL DEFAULT '',
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`name`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_darkchat_members
CREATE TABLE IF NOT EXISTS `phone_darkchat_members` (
`channel_name` varchar(50) NOT NULL,
`username` varchar(20) NOT NULL,
PRIMARY KEY (`channel_name`, `username`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_darkchat_messages
CREATE TABLE IF NOT EXISTS `phone_darkchat_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`channel` varchar(50) NOT NULL,
`sender` varchar(20) NOT NULL,
`content` varchar(1000) DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_accounts
CREATE TABLE IF NOT EXISTS `phone_instagram_accounts` (
`display_name` varchar(30) NOT NULL,
`username` varchar(20) NOT NULL,
`password` varchar(100) NOT NULL,
`profile_image` varchar(200) DEFAULT NULL,
`bio` varchar(100) DEFAULT NULL,
`post_count` int(11) NOT NULL DEFAULT 0,
`story_count` int(11) NOT NULL DEFAULT 0,
`follower_count` int(11) NOT NULL DEFAULT 0,
`following_count` int(11) NOT NULL DEFAULT 0,
`phone_number` varchar(15) NOT NULL,
`private` tinyint(1) DEFAULT 0,
`verified` tinyint(1) DEFAULT 0,
`date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`username`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_instagram_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_comments
CREATE TABLE IF NOT EXISTS `phone_instagram_comments` (
`id` varchar(10) NOT NULL,
`post_id` varchar(50) NOT NULL,
`username` varchar(20) NOT NULL,
`comment` varchar(500) NOT NULL DEFAULT '',
`like_count` int(11) NOT NULL DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `post_id` (`post_id`),
KEY `username` (`username`),
CONSTRAINT `phone_instagram_comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `phone_instagram_posts` (`id`) ON DELETE CASCADE,
CONSTRAINT `phone_instagram_comments_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_follows
CREATE TABLE IF NOT EXISTS `phone_instagram_follows` (
`followed` varchar(20) NOT NULL,
`follower` varchar(20) NOT NULL,
PRIMARY KEY (`followed`, `follower`),
KEY `follower` (`follower`),
CONSTRAINT `phone_instagram_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_instagram_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_follow_requests
CREATE TABLE IF NOT EXISTS `phone_instagram_follow_requests` (
`requester` varchar(20) NOT NULL,
`requestee` varchar(20) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`requester`, `requestee`),
KEY `requestee` (`requestee`),
CONSTRAINT `phone_instagram_follow_requests_ibfk_1` FOREIGN KEY (`requester`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_instagram_follow_requests_ibfk_2` FOREIGN KEY (`requestee`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_likes
CREATE TABLE IF NOT EXISTS `phone_instagram_likes` (
`id` varchar(10) NOT NULL,
`username` varchar(20) NOT NULL,
`is_comment` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`, `username`),
KEY `username` (`username`),
CONSTRAINT `phone_instagram_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_loggedin
CREATE TABLE IF NOT EXISTS `phone_instagram_loggedin` (
`phone_number` varchar(15) NOT NULL,
`username` varchar(20) NOT NULL,
PRIMARY KEY (`phone_number`),
KEY `username` (`username`),
CONSTRAINT `phone_instagram_loggedin_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_instagram_loggedin_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_messages
CREATE TABLE IF NOT EXISTS `phone_instagram_messages` (
`id` varchar(10) NOT NULL,
`sender` varchar(20) NOT NULL,
`recipient` varchar(20) NOT NULL,
`content` varchar(1000) DEFAULT NULL,
`attachments` text DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `sender` (`sender`),
KEY `recipient` (`recipient`),
CONSTRAINT `phone_instagram_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_instagram_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_notifications
CREATE TABLE IF NOT EXISTS `phone_instagram_notifications` (
`id` varchar(10) NOT NULL,
`username` varchar(20) NOT NULL,
`from` varchar(20) NOT NULL,
`type` varchar(20) NOT NULL,
`post_id` varchar(50) DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `username` (`username`),
KEY `from` (`from`),
CONSTRAINT `phone_instagram_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_instagram_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_posts
CREATE TABLE IF NOT EXISTS `phone_instagram_posts` (
`id` varchar(10) NOT NULL,
`media` text DEFAULT NULL,
`caption` varchar(500) NOT NULL DEFAULT '',
`location` varchar(50) DEFAULT NULL,
`like_count` int(11) NOT NULL DEFAULT 0,
`comment_count` int(11) NOT NULL DEFAULT 0,
`username` varchar(20) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `username` (`username`),
CONSTRAINT `phone_instagram_posts_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_stories
CREATE TABLE IF NOT EXISTS `phone_instagram_stories` (
`id` varchar(10) NOT NULL,
`username` varchar(20) NOT NULL,
`image` varchar(200) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `username` (`username`),
CONSTRAINT `phone_instagram_stories_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_instagram_stories_views
CREATE TABLE IF NOT EXISTS `phone_instagram_stories_views` (
`story_id` varchar(50) NOT NULL,
`viewer` varchar(20) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`story_id`, `viewer`),
KEY `viewer` (`viewer`),
CONSTRAINT `phone_instagram_stories_views_ibfk_1` FOREIGN KEY (`story_id`) REFERENCES `phone_instagram_stories` (`id`) ON DELETE CASCADE,
CONSTRAINT `phone_instagram_stories_views_ibfk_2` FOREIGN KEY (`viewer`) REFERENCES `phone_instagram_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_last_phone
CREATE TABLE IF NOT EXISTS `phone_last_phone` (
`identifier` varchar(100) NOT NULL,
`phone_number` varchar(15) NOT NULL,
PRIMARY KEY (`identifier`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_last_phone_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_logged_in_accounts
CREATE TABLE IF NOT EXISTS `phone_logged_in_accounts` (
`phone_number` varchar(15) NOT NULL,
`app` varchar(50) NOT NULL,
`username` varchar(100) NOT NULL,
PRIMARY KEY (`phone_number`, `app`, `username`),
CONSTRAINT `phone_logged_in_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_mail_accounts
CREATE TABLE IF NOT EXISTS `phone_mail_accounts` (
`address` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
PRIMARY KEY (`address`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_mail_loggedin
CREATE TABLE IF NOT EXISTS `phone_mail_loggedin` (
`address` varchar(100) NOT NULL,
`phone_number` varchar(15) NOT NULL,
PRIMARY KEY (`phone_number`),
KEY `address` (`address`),
CONSTRAINT `phone_mail_loggedin_ibfk_1` FOREIGN KEY (`address`) REFERENCES `phone_mail_accounts` (`address`) ON DELETE CASCADE,
CONSTRAINT `phone_mail_loggedin_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_mail_messages
CREATE TABLE IF NOT EXISTS `phone_mail_messages` (
`id` varchar(10) NOT NULL,
`recipient` varchar(100) NOT NULL,
`sender` varchar(100) NOT NULL,
`subject` varchar(100) NOT NULL,
`content` text NOT NULL,
`attachments` longtext DEFAULT NULL,
`actions` longtext DEFAULT NULL,
`read` tinyint(1) NOT NULL DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_maps_locations
CREATE TABLE IF NOT EXISTS `phone_maps_locations` (
`id` varchar(10) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`name` varchar(50) NOT NULL,
`x_pos` float NOT NULL,
`y_pos` float NOT NULL,
PRIMARY KEY (`id`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_maps_locations_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_marketplace_posts
CREATE TABLE IF NOT EXISTS `phone_marketplace_posts` (
`id` varchar(10) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`title` varchar(50) NOT NULL,
`description` varchar(1000) NOT NULL,
`attachments` text DEFAULT NULL,
`price` int(11) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_message_channels
CREATE TABLE IF NOT EXISTS `phone_message_channels` (
`channel_id` varchar(50) NOT NULL,
`is_group` tinyint(1) NOT NULL DEFAULT 0,
`name` varchar(50) DEFAULT NULL,
`last_message` varchar(50) NOT NULL DEFAULT '',
`last_message_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`channel_id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_message_members
CREATE TABLE IF NOT EXISTS `phone_message_members` (
`channel_id` varchar(50) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`is_owner` tinyint(1) NOT NULL DEFAULT 0,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`unread` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`channel_id`, `phone_number`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_message_messages
CREATE TABLE IF NOT EXISTS `phone_message_messages` (
`id` varchar(10) NOT NULL,
`channel_id` varchar(50) NOT NULL,
`sender` varchar(15) NOT NULL,
`content` varchar(1000) DEFAULT NULL,
`attachments` text DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_music_playlists
CREATE TABLE IF NOT EXISTS `phone_music_playlists` (
`id` varchar(10) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`name` varchar(50) NOT NULL,
`cover` varchar(500) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_music_playlists_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_music_saved_playlists
CREATE TABLE IF NOT EXISTS `phone_music_saved_playlists` (
`playlist_id` varchar(50) NOT NULL,
`phone_number` varchar(15) NOT NULL,
PRIMARY KEY (`playlist_id`, `phone_number`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_music_saved_playlists_ibfk_1` FOREIGN KEY (`playlist_id`) REFERENCES `phone_music_playlists` (`id`) ON DELETE CASCADE,
CONSTRAINT `phone_music_saved_playlists_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_music_songs
CREATE TABLE IF NOT EXISTS `phone_music_songs` (
`song_id` varchar(100) NOT NULL,
`playlist_id` varchar(50) NOT NULL,
PRIMARY KEY (`song_id`, `playlist_id`),
KEY `playlist_id` (`playlist_id`),
CONSTRAINT `phone_music_songs_ibfk_1` FOREIGN KEY (`playlist_id`) REFERENCES `phone_music_playlists` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_notes
CREATE TABLE IF NOT EXISTS `phone_notes` (
`id` varchar(10) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`title` varchar(50) NOT NULL,
`content` longtext DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_notes_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_notifications
CREATE TABLE IF NOT EXISTS `phone_notifications` (
`id` varchar(10) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`app` varchar(50) NOT NULL,
`title` varchar(50) DEFAULT NULL,
`content` varchar(500) DEFAULT NULL,
`thumbnail` varchar(250) DEFAULT NULL,
`avatar` varchar(250) DEFAULT NULL,
`show_avatar` tinyint(1) DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_notifications_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_phones
CREATE TABLE IF NOT EXISTS `phone_phones` (
`id` varchar(100) NOT NULL,
`owner` varchar(100) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`name` varchar(50) DEFAULT NULL,
`pin` varchar(4) DEFAULT NULL,
`face_id` varchar(100) DEFAULT NULL,
`settings` longtext DEFAULT NULL,
`is_setup` tinyint(1) DEFAULT 0,
`assigned` tinyint(1) DEFAULT 0,
`battery` int(11) NOT NULL DEFAULT 100,
PRIMARY KEY (`id`),
UNIQUE KEY `phone_number` (`phone_number`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_phone_blocked_numbers
CREATE TABLE IF NOT EXISTS `phone_phone_blocked_numbers` (
`phone_number` varchar(15) NOT NULL,
`blocked_number` varchar(15) NOT NULL,
PRIMARY KEY (`phone_number`, `blocked_number`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_phone_calls
CREATE TABLE IF NOT EXISTS `phone_phone_calls` (
`id` varchar(10) NOT NULL,
`caller` varchar(15) NOT NULL,
`callee` varchar(15) NOT NULL,
`duration` int(11) NOT NULL DEFAULT 0,
`answered` tinyint(1) DEFAULT 0,
`hide_caller_id` tinyint(1) DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_phone_contacts
CREATE TABLE IF NOT EXISTS `phone_phone_contacts` (
`contact_phone_number` varchar(15) NOT NULL,
`firstname` varchar(50) NOT NULL DEFAULT '',
`lastname` varchar(50) NOT NULL DEFAULT '',
`profile_image` varchar(200) DEFAULT NULL,
`email` varchar(50) DEFAULT NULL,
`address` varchar(50) DEFAULT NULL,
`favourite` tinyint(1) DEFAULT 0,
`phone_number` varchar(15) NOT NULL,
PRIMARY KEY (`contact_phone_number`, `phone_number`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_phone_voicemail
CREATE TABLE IF NOT EXISTS `phone_phone_voicemail` (
`id` varchar(10) NOT NULL,
`caller` varchar(15) NOT NULL,
`callee` varchar(15) NOT NULL,
`url` varchar(200) NOT NULL,
`duration` int(11) NOT NULL,
`hide_caller_id` tinyint(1) DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_photos
CREATE TABLE IF NOT EXISTS `phone_photos` (
`phone_number` varchar(15) NOT NULL,
`link` varchar(200) NOT NULL,
`is_video` tinyint(1) DEFAULT 0,
`size` float NOT NULL DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`phone_number`, `link`),
CONSTRAINT `phone_photos_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_services_channels
CREATE TABLE IF NOT EXISTS `phone_services_channels` (
`id` varchar(10) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`company` varchar(50) NOT NULL,
`last_message` varchar(100) DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_services_messages
CREATE TABLE IF NOT EXISTS `phone_services_messages` (
`id` varchar(10) NOT NULL,
`channel_id` varchar(50) NOT NULL,
`sender` varchar(15) NOT NULL,
`message` varchar(1000) NOT NULL,
`x_pos` int(11) DEFAULT NULL,
`y_pos` int(11) DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `channel_id` (`channel_id`),
CONSTRAINT `phone_services_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_services_channels` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_accounts
CREATE TABLE IF NOT EXISTS `phone_tiktok_accounts` (
`name` varchar(30) NOT NULL,
`bio` varchar(100) DEFAULT NULL,
`avatar` varchar(200) DEFAULT NULL,
`username` varchar(20) NOT NULL,
`password` varchar(100) NOT NULL,
`verified` tinyint(1) DEFAULT 0,
`follower_count` int(11) NOT NULL DEFAULT 0,
`following_count` int(11) NOT NULL DEFAULT 0,
`like_count` int(11) NOT NULL DEFAULT 0,
`video_count` int(11) NOT NULL DEFAULT 0,
`twitter` varchar(20) DEFAULT NULL,
`instagram` varchar(20) DEFAULT NULL,
`show_likes` tinyint(1) DEFAULT 1,
`phone_number` varchar(15) NOT NULL,
`date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`username`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_tiktok_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_channels
CREATE TABLE IF NOT EXISTS `phone_tiktok_channels` (
`id` varchar(10) NOT NULL,
`last_message` varchar(50) NOT NULL,
`member_1` varchar(20) NOT NULL,
`member_2` varchar(20) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`),
UNIQUE KEY `member_1` (`member_1`, `member_2`),
KEY `member_2` (`member_2`),
CONSTRAINT `phone_tiktok_channels_ibfk_1` FOREIGN KEY (`member_1`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_channels_ibfk_2` FOREIGN KEY (`member_2`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_comments
CREATE TABLE IF NOT EXISTS `phone_tiktok_comments` (
`id` varchar(10) NOT NULL,
`reply_to` varchar(10) DEFAULT NULL,
`video_id` varchar(10) NOT NULL,
`username` varchar(20) NOT NULL,
`comment` varchar(550) NOT NULL,
`likes` int(11) NOT NULL DEFAULT 0,
`replies` int(11) NOT NULL DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `video_id` (`video_id`),
KEY `username` (`username`),
KEY `reply_to` (`reply_to`),
CONSTRAINT `phone_tiktok_comments_ibfk_1` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_comments_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_comments_ibfk_3` FOREIGN KEY (`reply_to`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_comments_likes
CREATE TABLE IF NOT EXISTS `phone_tiktok_comments_likes` (
`username` varchar(20) NOT NULL,
`comment_id` varchar(10) NOT NULL,
PRIMARY KEY (`username`, `comment_id`),
KEY `comment_id` (`comment_id`),
CONSTRAINT `phone_tiktok_comments_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_comments_likes_ibfk_2` FOREIGN KEY (`comment_id`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_follows
CREATE TABLE IF NOT EXISTS `phone_tiktok_follows` (
`followed` varchar(20) NOT NULL,
`follower` varchar(20) NOT NULL,
PRIMARY KEY (`followed`, `follower`),
KEY `follower` (`follower`),
CONSTRAINT `phone_tiktok_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_likes
CREATE TABLE IF NOT EXISTS `phone_tiktok_likes` (
`username` varchar(20) NOT NULL,
`video_id` varchar(10) NOT NULL,
PRIMARY KEY (`username`, `video_id`),
KEY `video_id` (`video_id`),
CONSTRAINT `phone_tiktok_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_likes_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_loggedin
CREATE TABLE IF NOT EXISTS `phone_tiktok_loggedin` (
`username` varchar(20) NOT NULL,
`phone_number` varchar(15) NOT NULL,
PRIMARY KEY (`phone_number`),
KEY `username` (`username`),
CONSTRAINT `phone_tiktok_loggedin_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_loggedin_ibfk_2` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_messages
CREATE TABLE IF NOT EXISTS `phone_tiktok_messages` (
`id` varchar(10) NOT NULL,
`channel_id` varchar(10) NOT NULL,
`sender` varchar(20) NOT NULL,
`content` varchar(500) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `channel_id` (`channel_id`),
KEY `sender` (`sender`),
CONSTRAINT `phone_tiktok_messages_ibfk_1` FOREIGN KEY (`channel_id`) REFERENCES `phone_tiktok_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_messages_ibfk_2` FOREIGN KEY (`sender`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_notifications
CREATE TABLE IF NOT EXISTS `phone_tiktok_notifications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL,
`from` varchar(20) NOT NULL,
`type` varchar(20) NOT NULL,
`video_id` varchar(10) DEFAULT NULL,
`comment_id` varchar(10) DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `username` (`username`),
KEY `from` (`from`),
KEY `video_id` (`video_id`),
KEY `comment_id` (`comment_id`),
CONSTRAINT `phone_tiktok_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_notifications_ibfk_3` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_notifications_ibfk_4` FOREIGN KEY (`comment_id`) REFERENCES `phone_tiktok_comments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_pinned_videos
CREATE TABLE IF NOT EXISTS `phone_tiktok_pinned_videos` (
`username` varchar(20) NOT NULL,
`video_id` varchar(10) NOT NULL,
PRIMARY KEY (`username`, `video_id`),
KEY `video_id` (`video_id`),
CONSTRAINT `phone_tiktok_pinned_videos_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_pinned_videos_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_saves
CREATE TABLE IF NOT EXISTS `phone_tiktok_saves` (
`username` varchar(20) NOT NULL,
`video_id` varchar(10) NOT NULL,
PRIMARY KEY (`username`, `video_id`),
KEY `video_id` (`video_id`),
CONSTRAINT `phone_tiktok_saves_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_saves_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_unread_messages
CREATE TABLE IF NOT EXISTS `phone_tiktok_unread_messages` (
`username` varchar(20) NOT NULL,
`channel_id` varchar(10) NOT NULL,
`amount` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`username`, `channel_id`),
KEY `channel_id` (`channel_id`),
CONSTRAINT `phone_tiktok_unread_messages_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_unread_messages_ibfk_2` FOREIGN KEY (`channel_id`) REFERENCES `phone_tiktok_channels` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_videos
CREATE TABLE IF NOT EXISTS `phone_tiktok_videos` (
`id` varchar(10) NOT NULL,
`username` varchar(20) NOT NULL,
`src` varchar(200) NOT NULL,
`caption` varchar(100) DEFAULT NULL,
`metadata` longtext DEFAULT NULL,
`music` text DEFAULT NULL,
`likes` int(11) NOT NULL DEFAULT 0,
`comments` int(11) NOT NULL DEFAULT 0,
`views` int(11) NOT NULL DEFAULT 0,
`saves` int(11) NOT NULL DEFAULT 0,
`pinned_comment` varchar(10) DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `username` (`username`),
CONSTRAINT `phone_tiktok_videos_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tiktok_views
CREATE TABLE IF NOT EXISTS `phone_tiktok_views` (
`username` varchar(20) NOT NULL,
`video_id` varchar(10) NOT NULL,
PRIMARY KEY (`username`, `video_id`),
KEY `video_id` (`video_id`),
CONSTRAINT `phone_tiktok_views_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_tiktok_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tiktok_views_ibfk_2` FOREIGN KEY (`video_id`) REFERENCES `phone_tiktok_videos` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tinder_accounts
CREATE TABLE IF NOT EXISTS `phone_tinder_accounts` (
`name` varchar(50) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`photos` text DEFAULT NULL,
`bio` varchar(500) DEFAULT NULL,
`dob` date NOT NULL,
`is_male` tinyint(1) NOT NULL,
`interested_men` tinyint(1) NOT NULL,
`interested_women` tinyint(1) NOT NULL,
PRIMARY KEY (`phone_number`),
CONSTRAINT `phone_tinder_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tinder_matches
CREATE TABLE IF NOT EXISTS `phone_tinder_matches` (
`phone_number_1` varchar(15) NOT NULL,
`phone_number_2` varchar(15) NOT NULL,
`latest_message` varchar(1000) DEFAULT NULL,
`latest_message_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`phone_number_1`, `phone_number_2`),
KEY `phone_number_2` (`phone_number_2`),
CONSTRAINT `phone_tinder_matches_ibfk_1` FOREIGN KEY (`phone_number_1`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tinder_matches_ibfk_2` FOREIGN KEY (`phone_number_2`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tinder_messages
CREATE TABLE IF NOT EXISTS `phone_tinder_messages` (
`id` varchar(10) NOT NULL,
`sender` varchar(15) NOT NULL,
`recipient` varchar(15) NOT NULL,
`content` varchar(1000) DEFAULT NULL,
`attachments` text DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `sender` (`sender`),
KEY `recipient` (`recipient`),
CONSTRAINT `phone_tinder_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tinder_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_tinder_swipes
CREATE TABLE IF NOT EXISTS `phone_tinder_swipes` (
`swiper` varchar(15) NOT NULL,
`swipee` varchar(15) NOT NULL,
`liked` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`swiper`, `swipee`),
KEY `swipee` (`swipee`),
CONSTRAINT `phone_tinder_swipes_ibfk_1` FOREIGN KEY (`swiper`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_tinder_swipes_ibfk_2` FOREIGN KEY (`swipee`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_accounts
CREATE TABLE IF NOT EXISTS `phone_twitter_accounts` (
`display_name` varchar(30) NOT NULL,
`username` varchar(20) NOT NULL,
`password` varchar(100) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`bio` varchar(100) DEFAULT NULL,
`profile_image` varchar(200) DEFAULT NULL,
`profile_header` varchar(200) DEFAULT NULL,
`pinned_tweet` varchar(50) DEFAULT NULL,
`verified` tinyint(1) DEFAULT 0,
`follower_count` int(11) NOT NULL DEFAULT 0,
`following_count` int(11) NOT NULL DEFAULT 0,
`private` tinyint(1) DEFAULT 0,
`date_joined` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`username`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_twitter_accounts_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_follows
CREATE TABLE IF NOT EXISTS `phone_twitter_follows` (
`followed` varchar(20) NOT NULL,
`follower` varchar(20) NOT NULL,
`notifications` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`followed`, `follower`),
KEY `follower` (`follower`),
CONSTRAINT `phone_twitter_follows_ibfk_1` FOREIGN KEY (`followed`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_twitter_follows_ibfk_2` FOREIGN KEY (`follower`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_follow_requests
CREATE TABLE IF NOT EXISTS `phone_twitter_follow_requests` (
`requester` varchar(20) NOT NULL,
`requestee` varchar(20) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`requester`, `requestee`),
KEY `requestee` (`requestee`),
CONSTRAINT `phone_twitter_follow_requests_ibfk_1` FOREIGN KEY (`requester`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_twitter_follow_requests_ibfk_2` FOREIGN KEY (`requestee`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_hashtags
CREATE TABLE IF NOT EXISTS `phone_twitter_hashtags` (
`hashtag` varchar(50) NOT NULL,
`amount` int(11) NOT NULL DEFAULT 0,
`last_used` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`hashtag`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_likes
CREATE TABLE IF NOT EXISTS `phone_twitter_likes` (
`tweet_id` varchar(50) NOT NULL,
`username` varchar(20) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`tweet_id`, `username`),
KEY `username` (`username`),
CONSTRAINT `phone_twitter_likes_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_loggedin
CREATE TABLE IF NOT EXISTS `phone_twitter_loggedin` (
`phone_number` varchar(15) NOT NULL,
`username` varchar(20) NOT NULL,
PRIMARY KEY (`phone_number`),
KEY `username` (`username`),
CONSTRAINT `phone_twitter_loggedin_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_twitter_loggedin_ibfk_2` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_messages
CREATE TABLE IF NOT EXISTS `phone_twitter_messages` (
`id` varchar(10) NOT NULL,
`sender` varchar(20) NOT NULL,
`recipient` varchar(20) NOT NULL,
`content` varchar(1000) DEFAULT NULL,
`attachments` text DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `sender` (`sender`),
KEY `recipient` (`recipient`),
CONSTRAINT `phone_twitter_messages_ibfk_1` FOREIGN KEY (`sender`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_twitter_messages_ibfk_2` FOREIGN KEY (`recipient`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_notifications
CREATE TABLE IF NOT EXISTS `phone_twitter_notifications` (
`id` varchar(10) NOT NULL,
`username` varchar(20) NOT NULL,
`from` varchar(20) NOT NULL,
`type` varchar(20) NOT NULL,
`tweet_id` varchar(50) DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `username` (`username`),
KEY `from` (`from`),
CONSTRAINT `phone_twitter_notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `phone_twitter_notifications_ibfk_2` FOREIGN KEY (`from`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_promoted
CREATE TABLE IF NOT EXISTS `phone_twitter_promoted` (
`tweet_id` varchar(50) NOT NULL,
`promotions` int(11) NOT NULL DEFAULT 0,
`views` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`tweet_id`),
CONSTRAINT `phone_twitter_promoted_ibfk_1` FOREIGN KEY (`tweet_id`) REFERENCES `phone_twitter_tweets` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_retweets
CREATE TABLE IF NOT EXISTS `phone_twitter_retweets` (
`tweet_id` varchar(50) NOT NULL,
`username` varchar(20) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`tweet_id`, `username`),
KEY `username` (`username`),
CONSTRAINT `phone_twitter_retweets_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_twitter_tweets
CREATE TABLE IF NOT EXISTS `phone_twitter_tweets` (
`id` varchar(10) NOT NULL,
`username` varchar(20) NOT NULL,
`content` varchar(280) DEFAULT NULL,
`attachments` text DEFAULT NULL,
`reply_to` varchar(50) DEFAULT NULL,
`like_count` int(11) DEFAULT 0,
`reply_count` int(11) DEFAULT 0,
`retweet_count` int(11) DEFAULT 0,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `username` (`username`),
CONSTRAINT `phone_twitter_tweets_ibfk_1` FOREIGN KEY (`username`) REFERENCES `phone_twitter_accounts` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_voice_memos_recordings
CREATE TABLE IF NOT EXISTS `phone_voice_memos_recordings` (
`id` varchar(10) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`file_name` varchar(50) NOT NULL,
`file_url` varchar(100) NOT NULL,
`file_length` int(11) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_voice_memos_recordings_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_wallet_transactions
CREATE TABLE IF NOT EXISTS `phone_wallet_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`phone_number` varchar(15) NOT NULL,
`amount` int(11) NOT NULL,
`company` varchar(50) NOT NULL,
`logo` varchar(200) DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`),
KEY `phone_number` (`phone_number`),
CONSTRAINT `phone_wallet_transactions_ibfk_1` FOREIGN KEY (`phone_number`) REFERENCES `phone_phones` (`phone_number`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 5 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.phone_yellow_pages_posts
CREATE TABLE IF NOT EXISTS `phone_yellow_pages_posts` (
`id` varchar(10) NOT NULL,
`phone_number` varchar(15) NOT NULL,
`title` varchar(50) NOT NULL,
`description` varchar(1000) NOT NULL,
`attachment` varchar(500) DEFAULT NULL,
`price` int(11) DEFAULT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.radiocar
CREATE TABLE IF NOT EXISTS `radiocar` (
`id` int(11) NOT NULL,
`label` varchar(64) NOT NULL,
`url` varchar(256) NOT NULL,
`spz` varchar(32) NOT NULL,
`index_music` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.radiocar_owned
CREATE TABLE IF NOT EXISTS `radiocar_owned` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.tbg_opkaldsliste
CREATE TABLE IF NOT EXISTS `tbg_opkaldsliste` (
`user_id` varchar(1000) NOT NULL,
`phone` varchar(1000) NOT NULL,
`message` varchar(1000) NOT NULL,
`identity` varchar(1000) NOT NULL,
`x` varchar(1000) NOT NULL,
`y` varchar(1000) NOT NULL,
`z` varchar(1000) NOT NULL,
`date` varchar(1000) NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för procedur vrpfx.tiktok_insert_notification_if_unique
DELIMITER / / CREATE PROCEDURE `tiktok_insert_notification_if_unique`(
IN p_username VARCHAR(20),
IN p_from VARCHAR(20),
IN p_type VARCHAR(20),
IN p_video_id VARCHAR(10),
IN p_comment_id VARCHAR(10)
) BEGIN DECLARE duplicate_entry INT DEFAULT 0;
SELECT
COUNT(*) INTO duplicate_entry
FROM
phone_tiktok_notifications
WHERE
(username = p_username)
AND (`from` = p_from)
AND (`type` = p_type)
AND (
video_id = p_video_id
OR (
video_id IS NULL
AND p_video_id IS NULL
)
)
AND (
comment_id = p_comment_id
OR (
comment_id IS NULL
AND p_comment_id IS NULL
)
);IF duplicate_entry = 0 THEN
INSERT INTO
phone_tiktok_notifications (username, `from`, `type`, video_id, comment_id)
VALUES
(
p_username,
p_from,
p_type,
p_video_id,
p_comment_id
);END IF;END / / DELIMITER;-- Dumpar struktur för tabell vrpfx.vehicles_for_sale
CREATE TABLE IF NOT EXISTS `vehicles_for_sale` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sellerid` varchar(50) NOT NULL,
`description` text DEFAULT NULL,
`price` int(11) NOT NULL DEFAULT 0,
`model` varchar(255) NOT NULL DEFAULT '',
`vtype` varchar(255) NOT NULL DEFAULT '',
`sellername` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_kort
CREATE TABLE IF NOT EXISTS `vrp_kort` (
`user_id` int(11) DEFAULT NULL,
`visitkorturl` varchar(100) DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_srv_data
CREATE TABLE IF NOT EXISTS `vrp_srv_data` (
`dkey` varchar(255) NOT NULL DEFAULT '',
`dvalue` text DEFAULT NULL,
PRIMARY KEY (`dkey`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_users
CREATE TABLE IF NOT EXISTS `vrp_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`last_login` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`last_date` text DEFAULT NULL,
`whitelisted` tinyint(1) DEFAULT 0,
`banned` tinyint(1) DEFAULT 0,
`reason` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`DmvTest` int(11) DEFAULT 1,
`warnings` int(11) NOT NULL DEFAULT 0,
`freason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`_updated` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`verify` tinyint(1) DEFAULT 0,
`discord` varchar(255) DEFAULT NULL,
`iban` varchar(255) DEFAULT NULL,
`pincode` int(50) DEFAULT NULL,
`gunlicense` int(11) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 21 DEFAULT CHARSET = utf8 COLLATE = utf8_danish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_user_business
CREATE TABLE IF NOT EXISTS `vrp_user_business` (
`user_id` int(11) NOT NULL DEFAULT 0,
`name` varchar(30) DEFAULT NULL,
`description` text DEFAULT NULL,
`capital` int(11) DEFAULT 0,
`laundered` int(11) DEFAULT 0,
`reset_timestamp` int(11) DEFAULT 0,
PRIMARY KEY (`user_id`),
CONSTRAINT `fk_user_business_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_user_data
CREATE TABLE IF NOT EXISTS `vrp_user_data` (
`user_id` int(11) NOT NULL DEFAULT 0,
`dkey` varchar(255) NOT NULL DEFAULT '',
`dvalue` text DEFAULT NULL,
PRIMARY KEY (`user_id`, `dkey`),
CONSTRAINT `fk_user_data_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_user_homes
CREATE TABLE IF NOT EXISTS `vrp_user_homes` (
`user_id` int(11) NOT NULL DEFAULT 0,
`home` varchar(255) DEFAULT NULL,
`number` int(11) DEFAULT 0,
KEY `home` (`home`, `number`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_user_identities
CREATE TABLE IF NOT EXISTS `vrp_user_identities` (
`user_id` int(11) NOT NULL,
`registration` varchar(100) NOT NULL,
`tattoos` longtext DEFAULT NULL,
`phone` varchar(100) DEFAULT NULL,
`firstname` varchar(100) DEFAULT NULL,
`name` varchar(100) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`height` varchar(50) DEFAULT NULL,
`sex` text DEFAULT NULL,
`skin` longtext DEFAULT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `unique_user_id` (`user_id`),
CONSTRAINT `fk_user_identities_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_danish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_user_ids
CREATE TABLE IF NOT EXISTS `vrp_user_ids` (
`identifier` varchar(255) NOT NULL,
`user_id` int(11) DEFAULT 0,
KEY `fk_user_ids_users` (`user_id`),
KEY `identifier` (`identifier`),
ADD
CONSTRAINT `fk_user_ids_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE;
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_user_moneys
CREATE TABLE IF NOT EXISTS `vrp_user_moneys` (
`user_id` int(11) NOT NULL DEFAULT 0,
`wallet` bigint(20) DEFAULT 0,
`bank` bigint(20) DEFAULT 0,
`_log_upd` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`user_id`),
CONSTRAINT `fk_user_moneys_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.vrp_user_vehicles
CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
`user_id` int(11) NOT NULL DEFAULT 0,
`sted` int(11) DEFAULT 1,
`vehicle` varchar(255) NOT NULL DEFAULT '',
`vehicle_name` varchar(255) NOT NULL,
`vehicle_plate` varchar(15) NOT NULL,
`veh_type` varchar(255) NOT NULL DEFAULT 'default',
`vehicle_colorprimary` varchar(255) DEFAULT NULL,
`vehicle_colorsecondary` varchar(255) DEFAULT NULL,
`vehicle_pearlescentcolor` varchar(255) DEFAULT NULL,
`vehicle_wheelcolor` varchar(255) DEFAULT NULL,
`vehicle_plateindex` varchar(255) DEFAULT NULL,
`vehicle_neoncolor1` varchar(255) DEFAULT NULL,
`vehicle_neoncolor2` varchar(255) DEFAULT NULL,
`vehicle_neoncolor3` varchar(255) DEFAULT NULL,
`vehicle_windowtint` varchar(255) DEFAULT NULL,
`vehicle_wheeltype` varchar(255) DEFAULT NULL,
`vehicle_mods0` varchar(255) DEFAULT NULL,
`vehicle_mods1` varchar(255) DEFAULT NULL,
`vehicle_mods2` varchar(255) DEFAULT NULL,
`vehicle_mods3` varchar(255) DEFAULT NULL,
`vehicle_mods4` varchar(255) DEFAULT NULL,
`vehicle_mods5` varchar(255) DEFAULT NULL,
`vehicle_mods6` varchar(255) DEFAULT NULL,
`vehicle_mods7` varchar(255) DEFAULT NULL,
`vehicle_mods8` varchar(255) DEFAULT NULL,
`vehicle_mods9` varchar(255) DEFAULT NULL,
`vehicle_mods10` varchar(255) DEFAULT NULL,
`vehicle_mods11` varchar(255) DEFAULT NULL,
`vehicle_mods12` varchar(255) DEFAULT NULL,
`vehicle_mods13` varchar(255) DEFAULT NULL,
`vehicle_mods14` varchar(255) DEFAULT NULL,
`vehicle_mods15` varchar(255) DEFAULT NULL,
`vehicle_mods16` varchar(255) DEFAULT NULL,
`vehicle_turbo` varchar(255) NOT NULL DEFAULT 'off',
`vehicle_tiresmoke` varchar(255) NOT NULL DEFAULT 'off',
`vehicle_xenon` varchar(255) NOT NULL DEFAULT 'off',
`vehicle_mods23` varchar(255) DEFAULT NULL,
`vehicle_mods24` varchar(255) DEFAULT NULL,
`vehicle_neon0` varchar(255) DEFAULT NULL,
`vehicle_neon1` varchar(255) DEFAULT NULL,
`vehicle_neon2` varchar(255) DEFAULT NULL,
`vehicle_neon3` varchar(255) DEFAULT NULL,
`vehicle_bulletproof` varchar(255) DEFAULT NULL,
`vehicle_smokecolor1` varchar(255) DEFAULT NULL,
`vehicle_smokecolor2` varchar(255) DEFAULT NULL,
`vehicle_smokecolor3` varchar(255) DEFAULT NULL,
`vehicle_modvariation` varchar(255) NOT NULL DEFAULT 'off',
`vehicle_price` int(60) NOT NULL DEFAULT 0,
`vehicle_damage` varchar(255) NOT NULL DEFAULT '',
`vehicle_impound` varchar(255) NOT NULL DEFAULT '',
`vehicle_livery` varchar(255) DEFAULT NULL,
`modifications` text DEFAULT NULL,
`beslaglagt` int(11) DEFAULT 0,
`appearance` text DEFAULT NULL,
`last_parking` varchar(255) DEFAULT NULL,
PRIMARY KEY (`user_id`, `vehicle_plate`, `vehicle`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.weapons
CREATE TABLE IF NOT EXISTS `weapons` (
`user_id` int(11) DEFAULT NULL,
`glock` int(11) DEFAULT 0,
`sns` int(11) DEFAULT 0,
`deagle` int(11) DEFAULT 0,
`scorpion` int(11) DEFAULT 0,
`shotgun` int(11) DEFAULT 0,
`tec9` int(11) DEFAULT 0
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx.zonesystem
CREATE TABLE IF NOT EXISTS `zonesystem` (
`zone` varchar(50) DEFAULT NULL,
`bande` varchar(255) DEFAULT NULL,
`points` int(11) DEFAULT NULL,
`alliance` varchar(255) NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx._log
CREATE TABLE IF NOT EXISTS `_log` (
`timestamp` timestamp NULL DEFAULT current_timestamp(),
`user_id` int(11) DEFAULT NULL,
`type` varchar(190) DEFAULT NULL,
`action` varchar(190) DEFAULT NULL,
`text` longtext DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx._log_banstory
CREATE TABLE IF NOT EXISTS `_log_banstory` (
`uid` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`ban_from` int(11) NOT NULL,
`ban_to` int(11) NOT NULL,
`ban_reason` varchar(255) NOT NULL,
`_upd` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`uid`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx._log_cashflow
CREATE TABLE IF NOT EXISTS `_log_cashflow` (
`uid` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`cash_type` varchar(45) NOT NULL,
`cash_start` bigint(20) NOT NULL,
`cash_move` bigint(20) NOT NULL,
`cash_end` bigint(20) NOT NULL,
`_upd` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`uid`)
) ENGINE = InnoDB AUTO_INCREMENT = 630 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx._log_user_switch
CREATE TABLE IF NOT EXISTS `_log_user_switch` (
`uid` bigint(20) NOT NULL AUTO_INCREMENT,
`identifier` varchar(250) NOT NULL,
`userid` bigint(20) NOT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `userid_UNIQUE` (`userid`)
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = latin1 COLLATE = latin1_swedish_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx._log_vehicles
CREATE TABLE IF NOT EXISTS `_log_vehicles` (
`uid` bigint(20) NOT NULL AUTO_INCREMENT,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`action` varchar(250) NOT NULL,
`user_id` bigint(20) NOT NULL,
`vehicle` varchar(250) NOT NULL,
`vehicle_price` bigint(20) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE = InnoDB AUTO_INCREMENT = 3 DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för tabell vrpfx._log_weapons_user
CREATE TABLE IF NOT EXISTS `_log_weapons_user` (
`user_id` int(11) DEFAULT NULL,
`to` varchar(255) NOT NULL DEFAULT '',
`from` varchar(255) NOT NULL DEFAULT '0',
`weapon_name` varchar(255) DEFAULT '',
`_time` timestamp NULL DEFAULT current_timestamp(),
`weapon_amount` varchar(255) DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_general_ci;-- Dataexport var bortvalt.
-- Dumpar struktur för trigger vrpfx.phone_instagram_decrement_comment_count
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_decrement_comment_count
AFTER
DELETE ON phone_instagram_comments FOR EACH ROW BEGIN
UPDATE
phone_instagram_posts
SET
comment_count = comment_count - 1
WHERE
id = OLD.post_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_instagram_decrement_like_count
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_decrement_like_count
AFTER
DELETE ON phone_instagram_likes FOR EACH ROW BEGIN IF OLD.is_comment = 0 THEN
UPDATE
phone_instagram_posts
SET
like_count = like_count - 1
WHERE
id = OLD.id;ELSE
UPDATE
phone_instagram_comments
SET
like_count = like_count - 1
WHERE
id = OLD.id;END IF;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_instagram_decrement_post_count
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_decrement_post_count
AFTER
DELETE ON phone_instagram_posts FOR EACH ROW BEGIN
UPDATE
phone_instagram_accounts
SET
post_count = post_count - 1
WHERE
username = OLD.username;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_instagram_decrement_story_count
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_decrement_story_count
AFTER
DELETE ON phone_instagram_stories FOR EACH ROW BEGIN
UPDATE
phone_instagram_accounts
SET
story_count = story_count - 1
WHERE
username = OLD.username;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_instagram_increment_comment_count
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_increment_comment_count
AFTER
INSERT ON phone_instagram_comments FOR EACH ROW BEGIN
UPDATE
phone_instagram_posts
SET
comment_count = comment_count + 1
WHERE
id = NEW.post_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_instagram_increment_like_count
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_increment_like_count
AFTER
INSERT ON phone_instagram_likes FOR EACH ROW BEGIN IF NEW.is_comment = 0 THEN
UPDATE
phone_instagram_posts
SET
like_count = like_count + 1
WHERE
id = NEW.id;ELSE
UPDATE
phone_instagram_comments
SET
like_count = like_count + 1
WHERE
id = NEW.id;END IF;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_instagram_increment_post_count
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_increment_post_count
AFTER
INSERT ON phone_instagram_posts FOR EACH ROW BEGIN
UPDATE
phone_instagram_accounts
SET
post_count = post_count + 1
WHERE
username = NEW.username;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_instagram_increment_story_count
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_increment_story_count
AFTER
INSERT ON phone_instagram_stories FOR EACH ROW BEGIN
UPDATE
phone_instagram_accounts
SET
story_count = story_count + 1
WHERE
username = NEW.username;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_instagram_update_counts_after_follow
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_update_counts_after_follow
AFTER
INSERT ON phone_instagram_follows FOR EACH ROW BEGIN
UPDATE
phone_instagram_accounts
SET
follower_count = follower_count + 1
WHERE
username = NEW.followed;
UPDATE
phone_instagram_accounts
SET
following_count = following_count + 1
WHERE
username = NEW.follower;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_instagram_update_counts_after_unfollow
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_instagram_update_counts_after_unfollow
AFTER
DELETE ON phone_instagram_follows FOR EACH ROW BEGIN
UPDATE
phone_instagram_accounts
SET
follower_count = follower_count - 1
WHERE
username = OLD.followed;
UPDATE
phone_instagram_accounts
SET
following_count = following_count - 1
WHERE
username = OLD.follower;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_decrement_account_likes
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_decrement_account_likes
AFTER
DELETE ON phone_tiktok_likes FOR EACH ROW BEGIN
UPDATE
phone_tiktok_accounts
JOIN phone_tiktok_videos ON phone_tiktok_videos.username = phone_tiktok_accounts.username
SET
phone_tiktok_accounts.like_count = phone_tiktok_accounts.like_count - 1
WHERE
phone_tiktok_videos.id = OLD.video_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_decrement_comment_likes
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_decrement_comment_likes
AFTER
DELETE ON phone_tiktok_comments_likes FOR EACH ROW BEGIN
UPDATE
phone_tiktok_comments
SET
likes = likes - 1
WHERE
id = OLD.comment_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_decrement_video_comments
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_decrement_video_comments BEFORE DELETE ON phone_tiktok_comments FOR EACH ROW BEGIN DECLARE v_replies_count INT;-- Count the replies for the comment
SELECT
COUNT(*) INTO v_replies_count
FROM
phone_tiktok_comments
WHERE
reply_to = OLD.id;-- Update the video's comments count
UPDATE
phone_tiktok_videos
SET
comments = comments - (1 + v_replies_count)
WHERE
id = OLD.video_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_decrement_video_likes
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_decrement_video_likes
AFTER
DELETE ON phone_tiktok_likes FOR EACH ROW BEGIN
UPDATE
phone_tiktok_videos
SET
likes = likes - 1
WHERE
id = OLD.video_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_decrement_video_saves
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_decrement_video_saves
AFTER
DELETE ON phone_tiktok_saves FOR EACH ROW BEGIN
UPDATE
phone_tiktok_videos
SET
saves = saves - 1
WHERE
id = OLD.video_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_increment_account_likes
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_increment_account_likes
AFTER
INSERT ON phone_tiktok_likes FOR EACH ROW BEGIN
UPDATE
phone_tiktok_accounts
JOIN phone_tiktok_videos ON phone_tiktok_videos.username = phone_tiktok_accounts.username
SET
phone_tiktok_accounts.like_count = phone_tiktok_accounts.like_count + 1
WHERE
phone_tiktok_videos.id = NEW.video_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_increment_comment_likes
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_increment_comment_likes
AFTER
INSERT ON phone_tiktok_comments_likes FOR EACH ROW BEGIN
UPDATE
phone_tiktok_comments
SET
likes = likes + 1
WHERE
id = NEW.comment_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_increment_video_comments
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_increment_video_comments
AFTER
INSERT ON phone_tiktok_comments FOR EACH ROW BEGIN
UPDATE
phone_tiktok_videos
SET
comments = comments + 1
WHERE
id = NEW.video_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_increment_video_count
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_increment_video_count
AFTER
INSERT ON phone_tiktok_videos FOR EACH ROW BEGIN
UPDATE
phone_tiktok_accounts
SET
video_count = video_count + 1
WHERE
username = NEW.username;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_increment_video_likes
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_increment_video_likes
AFTER
INSERT ON phone_tiktok_likes FOR EACH ROW BEGIN
UPDATE
phone_tiktok_videos
SET
likes = likes + 1
WHERE
id = NEW.video_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_increment_video_saves
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_increment_video_saves
AFTER
INSERT ON phone_tiktok_saves FOR EACH ROW BEGIN
UPDATE
phone_tiktok_videos
SET
saves = saves + 1
WHERE
id = NEW.video_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_increment_video_views
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_increment_video_views
AFTER
INSERT ON phone_tiktok_views FOR EACH ROW BEGIN
UPDATE
phone_tiktok_videos
SET
views = views + 1
WHERE
id = NEW.video_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_update_counts_after_follow
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_update_counts_after_follow
AFTER
INSERT ON phone_tiktok_follows FOR EACH ROW BEGIN -- Increment the follower_count for the followed user
UPDATE
phone_tiktok_accounts
SET
follower_count = follower_count + 1
WHERE
username = NEW.followed;-- Increment the following_count for the follower user
UPDATE
phone_tiktok_accounts
SET
following_count = following_count + 1
WHERE
username = NEW.follower;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_update_counts_after_unfollow
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_update_counts_after_unfollow
AFTER
DELETE ON phone_tiktok_follows FOR EACH ROW BEGIN -- Decrement the follower_count for the followed user
UPDATE
phone_tiktok_accounts
SET
follower_count = follower_count - 1
WHERE
username = OLD.followed;-- Decrement the following_count for the follower user
UPDATE
phone_tiktok_accounts
SET
following_count = following_count - 1
WHERE
username = OLD.follower;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_tiktok_update_last_message
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_tiktok_update_last_message
AFTER
INSERT ON phone_tiktok_messages FOR EACH ROW BEGIN DECLARE modified_content TEXT CHARACTER SET utf8mb4;IF NEW.content LIKE '<!SHARED-VIDEO-URL%' THEN
SET
modified_content = 'Shared a video';ELSEIF LENGTH(NEW.content) > 50 THEN
SET
modified_content = CONCAT(SUBSTR(NEW.content, 1, 17), '...');ELSE
SET
modified_content = NEW.content;END IF;
UPDATE
phone_tiktok_channels
SET
last_message = modified_content
WHERE
id = NEW.channel_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_twitter_update_counts_after_follow
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_twitter_update_counts_after_follow
AFTER
INSERT ON phone_twitter_follows FOR EACH ROW BEGIN -- Increment the follower_count for the followed user
UPDATE
phone_twitter_accounts
SET
follower_count = follower_count + 1
WHERE
username = NEW.followed;-- Increment the following_count for the follower user
UPDATE
phone_twitter_accounts
SET
following_count = following_count + 1
WHERE
username = NEW.follower;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_twitter_update_counts_after_unfollow
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_twitter_update_counts_after_unfollow
AFTER
DELETE ON phone_twitter_follows FOR EACH ROW BEGIN -- Decrement the follower_count for the followed user
UPDATE
phone_twitter_accounts
SET
follower_count = follower_count - 1
WHERE
username = OLD.followed;-- Decrement the following_count for the follower user
UPDATE
phone_twitter_accounts
SET
following_count = following_count - 1
WHERE
username = OLD.follower;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_twitter_update_like_count_after_like
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_twitter_update_like_count_after_like
AFTER
INSERT ON phone_twitter_likes FOR EACH ROW BEGIN
UPDATE
phone_twitter_tweets
SET
like_count = like_count + 1
WHERE
id = NEW.tweet_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_twitter_update_like_count_after_unlike
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_twitter_update_like_count_after_unlike
AFTER
DELETE ON phone_twitter_likes FOR EACH ROW BEGIN
UPDATE
phone_twitter_tweets
SET
like_count = like_count - 1
WHERE
id = OLD.tweet_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_twitter_update_retweet_count_after_retweet
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_twitter_update_retweet_count_after_retweet
AFTER
INSERT ON phone_twitter_retweets FOR EACH ROW BEGIN
UPDATE
phone_twitter_tweets
SET
retweet_count = retweet_count + 1
WHERE
id = NEW.tweet_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.phone_twitter_update_retweet_count_after_unretweet
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER IF NOT EXISTS phone_twitter_update_retweet_count_after_unretweet
AFTER
DELETE ON phone_twitter_retweets FOR EACH ROW BEGIN
UPDATE
phone_twitter_tweets
SET
retweet_count = retweet_count - 1
WHERE
id = OLD.tweet_id;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.vrp_user_ids_logging
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER `vrp_user_ids_logging`
AFTER
DELETE ON `vrp_user_ids` FOR EACH ROW BEGIN
INSERT INTO
`_log_user_switch` (`identifier`, `userid`)
VALUES
(OLD.`identifier`, OLD.`user_id`) ON DUPLICATE KEY
UPDATE
`userid` = `userid`;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;-- Dumpar struktur för trigger vrpfx.vrp_user_moneys_analysis_update
SET
@OLDTMP_SQL_MODE = @ @SQL_MODE,
SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';DELIMITER / / CREATE TRIGGER `vrp_user_moneys_analysis_update`
AFTER
UPDATE
ON `vrp_user_moneys` FOR EACH ROW BEGIN
/* Lets check if the wallet has changed */
IF (
IFNULL(OLD.`wallet`, 0) != IFNULL(NEW.`wallet`, 0)
) THEN
INSERT INTO
`vrpfx`.`_log_cashflow` (
`user_id`,
`cash_type`,
`cash_start`,
`cash_move`,
`cash_end`
)
VALUES
(
OLD.`user_id`,
'WALLET',
IFNULL(OLD.`wallet`, 0),
(
IFNULL(NEW.`wallet`, 0) - IFNULL(OLD.`wallet`, 0)
),
IFNULL(NEW.`wallet`, 0)
);END IF;
/* Lets check if the wallet has changed */
IF (IFNULL(OLD.`bank`, 0) != IFNULL(NEW.`bank`, 0)) THEN
INSERT INTO
`vrpfx`.`_log_cashflow` (
`user_id`,
`cash_type`,
`cash_start`,
`cash_move`,
`cash_end`
)
VALUES
(
OLD.`user_id`,
'BANK',
IFNULL(OLD.`bank`, 0),
(IFNULL(NEW.`bank`, 0) - IFNULL(OLD.`bank`, 0)),
IFNULL(NEW.`bank`, 0)
);END IF;END / / DELIMITER;
SET
SQL_MODE = @OLDTMP_SQL_MODE;
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
Telegram: DB developers channel