xKGSNtfw

1CREATE TABLE IF NOT EXISTS `tbl_users` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `username` varchar(255) NOT NULL,
4  `email` varchar(255) NOT NULL,
5  `password` varchar(32) NOT NULL,
6  PRIMARY KEY (`id`)
7)
8
9CREATE TABLE IF NOT EXISTS `tbl_admin` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `username` varchar(255) NOT NULL,
12  `email` varchar(255) NOT NULL,
13  `password` varchar(32) NOT NULL,
14  PRIMARY KEY (`id`)
15)
16
17CREATE TABLE IF NOT EXISTS `tbl_img_categories` (
18  `catId` int(11) NOT NULL AUTO_INCREMENT,
19  `catName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
20  PRIMARY KEY (`catId`)
21)
22
23CREATE TABLE IF NOT EXISTS `tbl_img_gallery` (
24  `imgId` int(11) NOT NULL AUTO_INCREMENT,
25  `imgName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
26  `catId` int(11) NOT NULL,
27  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
28  PRIMARY KEY (`imgId`)
29)