· 5 years ago · Mar 12, 2020, 06:04 PM
1DROP TABLE IF EXISTS `users`;
2CREATE TABLE IF NOT EXISTS `users` (
3 `pk` int(11) NOT NULL AUTO_INCREMENT,
4 `username` varchar(100) NOT NULL,
5 `password` varchar(255) NOT NULL,
6 `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
7 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
8 PRIMARY KEY (`pk`)
9) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;