-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `db_lotre`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE `about` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(100) NOT NULL,
  `titleBg` varchar(100) NOT NULL,
  `descriptionBg` text NOT NULL,
  `createdBy` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `title`, `description`, `image`, `titleBg`, `descriptionBg`, `createdBy`) VALUES
(1, 'Statistics', 'Let statistics be your reference to scientific prediction of the most favoured winning number', 'icons8-graph-100.png', 'Statistics', 'Let statistics be your reference to scientific prediction of the most favoured winning number', 19),
(2, 'About our games', 'New to the game? Click here and to be a lucky winner.', 'icons8-8-of-hearts-100.png', 'About our games', 'New to the game? Click here and to be a lucky winner.', 19),
(3, 'Happenings', 'There are various community activities that we are involved in. Click here to check us out.', 'icons8-events-100.png', 'Happenings', 'There are various community activities that we are involved in. Click here to check us out.', 19),
(4, 'How to identify scam.', 'Dollar Millions will not ask you to pay any type of \'fee\' to receive your prize', 'icons8-robber-100.png', 'How to identify scam.', 'Dollar Millions will not ask you to pay any type of \'fee\' to receive your prize', 19);

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

--
-- Table structure for table `company_info`
--

CREATE TABLE `company_info` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `address` varchar(300) NOT NULL,
  `logo` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `whatsapp` varchar(100) NOT NULL,
  `facebook` varchar(100) NOT NULL,
  `instagram` varchar(100) NOT NULL,
  `youtube` varchar(100) NOT NULL,
  `drawtime` time NOT NULL,
  `color` varchar(12) NOT NULL,
  `favicon` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `company_info`
--

INSERT INTO `company_info` (`id`, `name`, `address`, `logo`, `email`, `whatsapp`, `facebook`, `instagram`, `youtube`, `drawtime`, `color`, `favicon`) VALUES
(1, 'My Lottery', 'Address ', 'removal_ai_0357e02f-cb03-4a37-b537-6debb93c84ee-images.png', 'admin@mylottery.com', '628123456789', 'https://facebook.com/tes', '#', '#', '20:59:59', '#FF9800', '2102168.png');

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

--
-- Table structure for table `draws`
--

CREATE TABLE `draws` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `firstprize` varchar(11) NOT NULL,
  `secondprize` varchar(11) NOT NULL,
  `thirdprize` varchar(11) NOT NULL,
  `starterprize` varchar(11) NOT NULL,
  `consolprize` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `draws`
--

INSERT INTO `draws` (`id`, `date`, `firstprize`, `secondprize`, `thirdprize`, `starterprize`, `consolprize`) VALUES
(14, '2024-03-02', '346534', '867976', '989809', '567457', '797807'),
(16, '2024-02-25', '547547', '235235', '898989', '356346', '567568'),
(17, '2024-02-26', '678967', '346346', '078078', '436346', '568568'),
(18, '2024-02-28', '354747', '870898', '325235', '457457', '235235'),
(19, '2024-02-29', '346346', '568585', '325235', '547548', '876967'),
(20, '2024-03-01', '253465', '769679', '346346', '679679', '089898'),
(21, '2024-03-03', '436346', '346346', '346346', '346346', '346436'),
(22, '2024-02-24', '547457', '235235', '679870', '346346', '807808'),
(23, '2024-02-23', '806067', '346346', '658585', '346346', '769670'),
(24, '2024-02-22', '547457', '870898', '346346', '899090', '568568'),
(25, '2024-02-20', '980898', '547854', '235235', '457457', '679679'),
(26, '2024-03-04', '547457', '789898', '235235', '568688', '436467');

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

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id_templates` int(11) NOT NULL,
  `judul` varchar(100) NOT NULL,
  `aktif` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `templates`
--

INSERT INTO `templates` (`id_templates`, `judul`, `aktif`) VALUES
(1, 'lottery', 'Y');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `company_info`
--
ALTER TABLE `company_info`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about`
--
ALTER TABLE `about`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `company_info`
--
ALTER TABLE `company_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `draws`
--
ALTER TABLE `draws`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
COMMIT;

