 -- 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 `pivot_ranking`
--

CREATE TABLE IF NOT EXISTS `pivot_ranking` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sportsmen_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

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


-- Table structure for table `login_abilities`
--

CREATE TABLE IF NOT EXISTS login_abilities (
    PRIMARY KEY (id),
    id          INT(11)     NOT NULL AUTO_INCREMENT,
    login_id    INT(11)     DEFAULT NULL,
    ability_id  INT(11)     DEFAULT NULL,
    created_at  TIMESTAMP   NULL DEFAULT NULL,
    updated_at  TIMESTAMP   NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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