   `adddate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `modifydate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `status` enum('active','canceled') COLLATE utf8_bin NOT NULL DEFAULT 'active'
-) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
 
 -- --------------------------------------------------------
 

  `status` enum('registered','verified') COLLATE utf8_bin NOT NULL,
  `register_date` datetime NOT NULL,
  `modifydate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `email_verification`
--
ALTER TABLE `email_verification`
  ADD PRIMARY KEY (`fk_user_id`,`token`);

--
-- Indexes for table `place`

  `fk_sport_id` mediumint(9) NOT NULL,
  `sportsubname` varchar(50) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `token`
--

CREATE TABLE IF NOT EXISTS `token` (
  `fk_user_id` mediumint(9) NOT NULL,
  `token` varchar(32) COLLATE utf8_bin NOT NULL,
  `action` enum('emailverification','passwordreset') COLLATE utf8_bin NOT NULL,
  `adddate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

