 -- Table structure for table `users`
 --
 
-CREATE TABLE IF NOT EXISTS `users` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `ban_id` int(11) DEFAULT '0',
-  `avatar` varchar(255) DEFAULT NULL,
-  `avatar_name` varchar(255) DEFAULT NULL,
-  `username` varchar(255) DEFAULT NULL,
-  `name` varchar(255) DEFAULT NULL,
-  `blocked` varchar(1) DEFAULT NULL,
-  `password` varchar(125) DEFAULT NULL,
-  `email` varchar(255) DEFAULT NULL,
-  `updated_at` timestamp NULL DEFAULT NULL,
-  `created_at` timestamp NULL DEFAULT NULL,
-  `deleted_at` timestamp NULL DEFAULT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
+CREATE TABLE IF NOT EXISTS users (
+    PRIMARY KEY (id),
+    id              INT(11)         NOT NULL AUTO_INCREMENT,
+    ban_id          INT(11)         DEFAULT '0',
+    avatar          VARCHAR(255)    DEFAULT NULL,
+    avatar_name     VARCHAR(255)    DEFAULT NULL,
+    username        VARCHAR(255)    DEFAULT NULL,
+    name            VARCHAR(255)    DEFAULT NULL,
+    blocked         VARCHAR(1)      DEFAULT NULL,
+    password        VARCHAR(125)    DEFAULT NULL,
+    email           VARCHAR(255)    DEFAULT NULL,
+    updated_at      TIMESTAMP NULL  DEFAULT NULL,
+    created_at      TIMESTAMP NULL  DEFAULT NULL,
+    deleted_at      TIMESTAMP NULL  DEFAULT NULL,
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

-- Table structure for table `gov_members`
--

CREATE TABLE IF NOT EXISTS `gov_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `Function` varchar(255) DEFAULT NULL,
  `Union_id` int(11) DEFAULT NULL,
  `Information` varchar(500) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;

-- --------------------------------------------------------


-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS categories (
    PRIMARY KEY (id),
    id          INT(11)     NOT NULL AUTO_INCREMENT,
    creator_id  INT(11)     DEFAULT NULL,
    category    VARCHAR(40) DEFAULT NULL,
    description TEXT,
    created_at  TIMESTAMP   NULL DEFAULT NULL,
    updated_at  TIMESTAMP   NULL DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

