Yellowpages ile ilgili bütün tablolarını sil.
DROP TABLE IF EXISTS `yellowpages_posts`;
CREATE TABLE IF NOT EXISTS `yellowpages_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`authorId` int(11) NOT NULL,
`realUser` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`message` varchar(256) COLLATE utf8mb4_general_ci NOT NULL,
`image` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`time` timestamp NOT NULL DEFAULT current_timestamp(),
`phone` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
`likes` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `FK_yellowpages_posts_twitter_accounts` (`authorId`),
CONSTRAINT `FK_yellowpages_posts_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
bu tabloyu okut datana tekrar okumaz ise ;
CREATE TABLE IF NOT EXISTS `yellowpages_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`authorId` int(11) NOT NULL,
`realUser` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`message` varchar(256) COLLATE utf8mb4_general_ci NOT NULL,
`image` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`time` timestamp NOT NULL DEFAULT current_timestamp(),
`phone` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
`likes` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `FK_yellowpages_posts_twitter_accounts` (`authorId`),
CONSTRAINT `FK_yellowpages_posts_twitter_accounts` FOREIGN KEY (`authorId`) REFERENCES `twitter_accounts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
bu şekilde okut hata kaynağı "utf8mb4_unicode_ci" kullanması onu "utf8mb4_general_ci" olarak değiştirmelisiniz.
DeathFung
A
AhmetGamingsss