· 9 years ago · Nov 16, 2016, 01:58 AM
1CREATE TABLE IF NOT EXISTS `tbl_users` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
4 `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
5 `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6 PRIMARY KEY (`id`)
7) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
8
9CREATE TABLE IF NOT EXISTS `tbl_gallery` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
12 PRIMARY KEY (`id`)
13)