-- http://www.phpmyadmin.net
--




--
-- Database: `dd_game`
--

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

--
-- Table structure for table `user_accounts`
--

CREATE TABLE `user_accounts` (
  `ID` int(32) NOT NULL,
  `USERNAME` varchar(32) NOT NULL,
  `PASSWORD` varchar(32) NOT NULL,
  `SCORE` int(32) NOT NULL,
  `LEVEL` int(1) NOT NULL,
  `LAST_UPDATED` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_accounts`
--

INSERT INTO `user_accounts` (`ID`, `USERNAME`, `PASSWORD`, `SCORE`, `LEVEL`, `LAST_UPDATED`) VALUES
(47, 'alikutluozen', 'alicik123', 42, 0, '2017-01-13 15:22:38'),
(48, 'manjur', 'manjur123', 27, 0, '2017-01-16 09:24:33'),
(49, 'manjur123', 'asdfasdfasdfasdf', 0, 0, '2017-01-13 14:57:20'),
(50, 'oscar123', 'oscar1991', 129, 0, '2017-01-13 15:20:29');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `user_accounts`
--
ALTER TABLE `user_accounts`
  ADD PRIMARY KEY (`ID`),
  ADD UNIQUE KEY `USERNAME` (`USERNAME`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `user_accounts`
--
ALTER TABLE `user_accounts`
  MODIFY `ID` int(32) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
