CREATE TABLE `userslog` (
  `id` int(12) NOT NULL,
  `username` varchar(255) NOT NULL,
  `activity` varchar(255) NOT NULL,
  `datetime` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

INSERT INTO `userslog` (`id`, `username`, `activity`, `datetime`) VALUES
(1, 'Admin', 'Created a new game: kilo ', '2024-11-16 12:18:49'),
(2, 'Admin', 'Game deteted,game name  kilo ', '2024-11-16 12:19:04'),
(3, 'Admin', 'Initiated closing of game,and awaiting confirmation ', '2024-11-16 14:09:45');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `userslog`
--
ALTER TABLE `userslog`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `userslog`
--
ALTER TABLE `userslog`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;
COMMIT;


CREATE TABLE `closegames` (
  `id` int(12) NOT NULL,
  `first_win` varchar(255) NOT NULL,
  `second_win` varchar(255) NOT NULL,
  `third_win` varchar(255) NOT NULL,
  `forth_win` varchar(255) NOT NULL,
  `fifth_win` varchar(255) NOT NULL,
  `gameid` varchar(255) NOT NULL,
  `userid` varchar(255) NOT NULL,
  `datetime` varchar(255) NOT NULL,
  `gamestatus` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `closegames`
--

INSERT INTO `closegames` (`id`, `first_win`, `second_win`, `third_win`, `forth_win`, `fifth_win`, `gameid`, `userid`, `datetime`, `gamestatus`) VALUES
(1, '23', '54', '45', '67', '23', '21', 'Admin', '2024-11-16 14:09:45', 'pending');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `closegames`
--
ALTER TABLE `closegames`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `closegames`
--
ALTER TABLE `closegames`
  MODIFY `id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;
