ALTER TABLE `users` ADD COLUMN `phone` LONGTEXT NULL;
ALTER TABLE `users` ADD COLUMN `profilepicture` LONGTEXT NULL;
ALTER TABLE `users` ADD COLUMN `background` LONGTEXT NULL;
ALTER TABLE `users` ADD COLUMN `iban` LONGTEXT NULL;
CREATE TABLE IF NOT EXISTS `player_contacts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(50) DEFAULT NULL,
`name` varchar(50) DEFAULT NULL,
`number` varchar(50) DEFAULT NULL,
`iban` varchar(50) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=12433 DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `phone_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(50) DEFAULT NULL,
`number` varchar(50) DEFAULT NULL,
`messages` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `identifier` (`identifier`),
KEY `number` (`number`)
) ENGINE=InnoDB AUTO_INCREMENT=6732 DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `player_mails` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(50) DEFAULT NULL,
`sender` varchar(50) DEFAULT NULL,
`subject` varchar(50) DEFAULT NULL,
`message` text DEFAULT NULL,
`read` tinyint(4) DEFAULT 0,
`mailid` int(11) DEFAULT NULL,
`date` timestamp NULL DEFAULT current_timestamp(),
`button` text DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `identifier` (`identifier`)
) ENGINE=InnoDB AUTO_INCREMENT=67023 DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `lapraces` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
`checkpoints` text DEFAULT NULL,
`records` text DEFAULT NULL,
`creator` varchar(50) DEFAULT NULL,
`distance` int(11) DEFAULT NULL,
`raceid` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `twitter_tweets` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`firstName` varchar(50) DEFAULT NULL,
`lastName` varchar(50) DEFAULT NULL,
`message` varchar(50) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`time` varchar(50) DEFAULT NULL,
`picture` varchar(255) DEFAULT NULL,
`owner` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;