· 4 years ago · Feb 18, 2021, 04:54 AM
1DROP TABLE IF EXISTS `tbl_post`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!50503 SET character_set_client = utf8mb4 */;
4CREATE TABLE `tbl_post` (
5 `id_post` int NOT NULL AUTO_INCREMENT,
6 `tgl_post` datetime NOT NULL,
7 `type_post` varchar(15) NOT NULL,
8 `judul_post` varchar(40) NOT NULL,
9 `isi_post` text NOT NULL,
10 `privacy_post` varchar(10) NOT NULL,
11 `author_post` int NOT NULL,
12 PRIMARY KEY (`id_post`)
13) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
14/*!40101 SET character_set_client = @saved_cs_client */;
15