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

START TRANSACTION;



--
-- Database: `dataweb`
--

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

--
-- Table structure for table `blocked_ips`
--

CREATE TABLE `blocked_ips` (
  `id` int(11) NOT NULL,
  `ip` varchar(45) NOT NULL,
  `attempts` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `login_attempts`
--

CREATE TABLE `login_attempts` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ip` varchar(45) NOT NULL,
  `date` datetime NOT NULL,
  `attempts` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `session_log`
--

CREATE TABLE `session_log` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `session` varchar(255) NOT NULL,
  `ip` varchar(45) NOT NULL,
  `logged_in` varchar(255) DEFAULT NULL,
  `logged_out` varchar(255) DEFAULT NULL,
  `browser_info` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `session_log`
--

INSERT INTO `session_log` (`id`, `user_id`, `session`, `ip`, `logged_in`, `logged_out`, `browser_info`, `created_at`) VALUES
(1, 1, '1f646923b7a60038061b3f2caa0c9b691a7d911b3f7022638f1494ef1ecf91feae9c81a9d67334650a1e9ddc98a18e2c', '::1', '1734079820', '0', '6c0c1620ade311d2ed47eb25667f95d5d703e62491cafe4dd330cd1c7a84dcdd', '2024-12-13 08:50:20'),
(2, 1, 'a5343484d5c7c2aa2cc029d0b09b155696c7ed45e8c8f902f59ff7a7c5f852011e83597884b8f2affb8ec638def130b9', '::1', '1734082882', '0', '6fc7992134b8c73c3a16e5e7b805cb0c2853818c3e923784daf2a34b38515ccf', '2024-12-13 09:41:22'),
(3, 1, 'f9ee5f5efc3efecdc5f15f37c476be1cbc9d141362785b66ba45caede8949ec118770eedefa5f9e42acfe5fbb2837822', '::1', '1734083918', '0', '80a82735e112293fad21d6d274340cf39b6de6f2d0faacbe169c969b403a0e1f', '2024-12-13 09:58:38'),
(4, 1, '77f87cf0b4cd6d61436b0d182160a143c6a2a831081b0a1a9a8dc2ec1c5d85e72c38b3a4cc8833f1093f667da70c5a74', '::1', '1734084066', '0', 'e03949d409cd1155f8b4cb4c564cc24e8a3628e25eb4cfd94e9017a09e9a3a7f', '2024-12-13 10:01:06'),
(5, 1, '9ed48c4df917ef23458c51b7a00d8c59a8c004b7e8d1dbd9668e5a2f3664c71a248fbf1f9553c9426fb1ffd5e29c4f81', '::1', '1734275089', '0', '28b28e9b4c59cc10e3e7c41b838364140ebdf4fec7558d5c3bc787954bd249a6', '2024-12-15 15:04:49'),
(6, 1, '02b3fce1372bdf022f7b6efb3a763408a1ef2903652566ff984fbc491205a6300420ceeaa253e43efd8b3087651db766', '::1', '1734276082', '0', 'ecec0aecc5e56d5d72b976e2cfdc1fdfd176fe57c121e18008ba59a0f88f4260', '2024-12-15 15:21:22'),
(7, 1, '3b589d4866dca3fc10470dc622c53d8aff892f2ee8d2723cf99263583cd81d4a8633247eb8ee3ca4ba21d7a02c5fbfeb', '::1', '1734276114', '0', '526c367242f4f8cd2d6b55d7390967543934bad7305f33a5f83a068bb8bf8746', '2024-12-15 15:21:54'),
(8, 1, '83d42bce8bea20ede33db1eefd195b9ed1765d2ca0b58390d71b275d7549a996c1b9f18a7402955668970ad79f334550', '::1', '1734770354', '0', '24b40a33e189443115140d29cac950c405add1c5804b81139b8bed46dbe92c63', '2024-12-21 08:39:14'),
(9, 1, 'c3f4f08de5a7f263246441f836b4e696ed4c29eac5906ea4d80bb8cba75da5e53ce9c84316631d513064944790befbad', '::1', '1734777276', '0', '636cbb6d789feb725a63e02dfbcb3b82517de6bd2eb46c64b72a4c30d2b921de', '2024-12-21 10:34:36'),
(10, 1, '561040b2a4d615852357c7c58469dce2cea454bc2dea7a4f16981c4c27705e0a5217b9080f6ca8bd4372c400d6aaeb07', '::1', '1734793084', '0', '566991e7fc6cad689a0e1623315054b93701730da7c93aa1a85b21c03e422437', '2024-12-21 14:58:04');

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

--
-- Table structure for table `tickers`
--

CREATE TABLE `tickers` (
  `ticker_id` int(11) NOT NULL,
  `ticker_symbol` varchar(10) NOT NULL,
  `ticker_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blocked_ips`
--
ALTER TABLE `blocked_ips`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ip` (`ip`);

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

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

--
-- Indexes for table `tickers`
--
ALTER TABLE `tickers`
  ADD PRIMARY KEY (`ticker_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blocked_ips`
--
ALTER TABLE `blocked_ips`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `login_attempts`
--
ALTER TABLE `login_attempts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `tickers`
--
ALTER TABLE `tickers`
  MODIFY `ticker_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

