 -- Table structure for table `login_permissions`
 --
 
-CREATE TABLE IF NOT EXISTS `login_permissions` (
-  `id` int(11) DEFAULT NULL,
-  `permissions_id` int(11) DEFAULT NULL,
-  `login_id` int(11) DEFAULT NULL,
-  `created_at` timestamp NULL DEFAULT NULL,
-  `updated_at` timestamp NULL DEFAULT NULL
+CREATE TABLE IF NOT EXISTS login_permissions (
+    PRIMARY KEY (id),
+    id              INT(11)     NOT NULL AUTO_INCREMENT,
+    permissions_id  INT(11)     DEFAULT NULL,
+    login_id        INT(11)     DEFAULT NULL,
+    created_at      TIMESTAMP   NULL DEFAULT NULL,
+    updated_at      TIMESTAMP   NULL DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- --------------------------------------------------------

-- Table structure for table `new_items`
--

CREATE TABLE IF NOT EXISTS `new_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `heading` varchar(255) DEFAULT NULL,
  `message` text,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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


-- Table structure for table `sessions`
--

CREATE TABLE IF NOT EXISTS sessions (
    PRIMARY KEY (id, ip_address),
    id          VARCHAR(128) NOT NULL,
    ip_address  VARCHAR(45) NOT NULL,
    TIMESTAMP   INT(10) unsigned NOT NULL DEFAULT '0',
    data        BLOB NOT NULL,
                KEY ci_sessions_TIMESTAMP(TIMESTAMP)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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