· 8 years ago · Feb 26, 2018, 10:26 AM
1DROP TABLE IF EXISTS `users`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `users` (
5 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
6 `name` varchar(50) NOT NULL,
7 `username` varchar(50) NOT NULL,
8 `telegram_id` int(50) NOT NULL,
9 `password` text NOT NULL,
10 `auth_code` varchar(5) NOT NULL,
11 PRIMARY KEY (`id`)
12) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
13/*!40101 SET character_set_client = @saved_cs_client */;
14
15--
16-- Dumping data for table `users`
17--
18
19LOCK TABLES `users` WRITE;
20/*!40000 ALTER TABLE `users` DISABLE KEYS */;
21INSERT INTO `users` VALUES (1,'Rizky Ramadhan','rizkyramadhan@example.com',12345678,'21232f297a57a5a743894a0e4a801fc3','00000');
22/*!40000 ALTER TABLE `users` ENABLE KEYS */;
23UNLOCK TABLES;