db.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 24, 2026 at 12:11 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `phpmyadmin`
--
CREATE DATABASE IF NOT EXISTS `phpmyadmin` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE `phpmyadmin`;

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

--
-- Table structure for table `pma__bookmark`
--

CREATE TABLE `pma__bookmark` (
  `id` int(10) UNSIGNED NOT NULL,
  `dbase` varchar(255) NOT NULL DEFAULT '',
  `user` varchar(255) NOT NULL DEFAULT '',
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `query` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks';

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

--
-- Table structure for table `pma__central_columns`
--

CREATE TABLE `pma__central_columns` (
  `db_name` varchar(64) NOT NULL,
  `col_name` varchar(64) NOT NULL,
  `col_type` varchar(64) NOT NULL,
  `col_length` text DEFAULT NULL,
  `col_collation` varchar(64) NOT NULL,
  `col_isNull` tinyint(1) NOT NULL,
  `col_extra` varchar(255) DEFAULT '',
  `col_default` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Central list of columns';

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

--
-- Table structure for table `pma__column_info`
--

CREATE TABLE `pma__column_info` (
  `id` int(5) UNSIGNED NOT NULL,
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `table_name` varchar(64) NOT NULL DEFAULT '',
  `column_name` varchar(64) NOT NULL DEFAULT '',
  `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `mimetype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `transformation` varchar(255) NOT NULL DEFAULT '',
  `transformation_options` varchar(255) NOT NULL DEFAULT '',
  `input_transformation` varchar(255) NOT NULL DEFAULT '',
  `input_transformation_options` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column information for phpMyAdmin';

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

--
-- Table structure for table `pma__designer_settings`
--

CREATE TABLE `pma__designer_settings` (
  `username` varchar(64) NOT NULL,
  `settings_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Settings related to Designer';

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

--
-- Table structure for table `pma__export_templates`
--

CREATE TABLE `pma__export_templates` (
  `id` int(5) UNSIGNED NOT NULL,
  `username` varchar(64) NOT NULL,
  `export_type` varchar(10) NOT NULL,
  `template_name` varchar(64) NOT NULL,
  `template_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved export templates';

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

--
-- Table structure for table `pma__favorite`
--

CREATE TABLE `pma__favorite` (
  `username` varchar(64) NOT NULL,
  `tables` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Favorite tables';

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

--
-- Table structure for table `pma__history`
--

CREATE TABLE `pma__history` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `username` varchar(64) NOT NULL DEFAULT '',
  `db` varchar(64) NOT NULL DEFAULT '',
  `table` varchar(64) NOT NULL DEFAULT '',
  `timevalue` timestamp NOT NULL DEFAULT current_timestamp(),
  `sqlquery` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='SQL history for phpMyAdmin';

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

--
-- Table structure for table `pma__navigationhiding`
--

CREATE TABLE `pma__navigationhiding` (
  `username` varchar(64) NOT NULL,
  `item_name` varchar(64) NOT NULL,
  `item_type` varchar(64) NOT NULL,
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Hidden items of navigation tree';

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

--
-- Table structure for table `pma__pdf_pages`
--

CREATE TABLE `pma__pdf_pages` (
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `page_nr` int(10) UNSIGNED NOT NULL,
  `page_descr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='PDF relation pages for phpMyAdmin';

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

--
-- Table structure for table `pma__recent`
--

CREATE TABLE `pma__recent` (
  `username` varchar(64) NOT NULL,
  `tables` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Recently accessed tables';

--
-- Dumping data for table `pma__recent`
--

INSERT INTO `pma__recent` (`username`, `tables`) VALUES
('root', '[{\"db\":\"bookstore\",\"table\":\"book\"}]');

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

--
-- Table structure for table `pma__relation`
--

CREATE TABLE `pma__relation` (
  `master_db` varchar(64) NOT NULL DEFAULT '',
  `master_table` varchar(64) NOT NULL DEFAULT '',
  `master_field` varchar(64) NOT NULL DEFAULT '',
  `foreign_db` varchar(64) NOT NULL DEFAULT '',
  `foreign_table` varchar(64) NOT NULL DEFAULT '',
  `foreign_field` varchar(64) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Relation table';

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

--
-- Table structure for table `pma__savedsearches`
--

CREATE TABLE `pma__savedsearches` (
  `id` int(5) UNSIGNED NOT NULL,
  `username` varchar(64) NOT NULL DEFAULT '',
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `search_name` varchar(64) NOT NULL DEFAULT '',
  `search_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Saved searches';

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

--
-- Table structure for table `pma__table_coords`
--

CREATE TABLE `pma__table_coords` (
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `table_name` varchar(64) NOT NULL DEFAULT '',
  `pdf_page_number` int(11) NOT NULL DEFAULT 0,
  `x` float UNSIGNED NOT NULL DEFAULT 0,
  `y` float UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for phpMyAdmin PDF output';

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

--
-- Table structure for table `pma__table_info`
--

CREATE TABLE `pma__table_info` (
  `db_name` varchar(64) NOT NULL DEFAULT '',
  `table_name` varchar(64) NOT NULL DEFAULT '',
  `display_field` varchar(64) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table information for phpMyAdmin';

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

--
-- Table structure for table `pma__table_uiprefs`
--

CREATE TABLE `pma__table_uiprefs` (
  `username` varchar(64) NOT NULL,
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  `prefs` text NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Tables'' UI preferences';

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

--
-- Table structure for table `pma__tracking`
--

CREATE TABLE `pma__tracking` (
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  `version` int(10) UNSIGNED NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  `schema_snapshot` text NOT NULL,
  `schema_sql` text DEFAULT NULL,
  `data_sql` longtext DEFAULT NULL,
  `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') DEFAULT NULL,
  `tracking_active` int(1) UNSIGNED NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database changes tracking for phpMyAdmin';

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

--
-- Table structure for table `pma__userconfig`
--

CREATE TABLE `pma__userconfig` (
  `username` varchar(64) NOT NULL,
  `timevalue` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `config_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User preferences storage for phpMyAdmin';

--
-- Dumping data for table `pma__userconfig`
--

INSERT INTO `pma__userconfig` (`username`, `timevalue`, `config_data`) VALUES
('root', '2026-04-13 09:21:01', '{\"Console\\/Mode\":\"collapse\"}');

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

--
-- Table structure for table `pma__usergroups`
--

CREATE TABLE `pma__usergroups` (
  `usergroup` varchar(64) NOT NULL,
  `tab` varchar(64) NOT NULL,
  `allowed` enum('Y','N') NOT NULL DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User groups with configured menu items';

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

--
-- Table structure for table `pma__users`
--

CREATE TABLE `pma__users` (
  `username` varchar(64) NOT NULL,
  `usergroup` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and their assignments to user groups';

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `pma__central_columns`
--
ALTER TABLE `pma__central_columns`
  ADD PRIMARY KEY (`db_name`,`col_name`);

--
-- Indexes for table `pma__column_info`
--
ALTER TABLE `pma__column_info`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`);

--
-- Indexes for table `pma__designer_settings`
--
ALTER TABLE `pma__designer_settings`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__export_templates`
--
ALTER TABLE `pma__export_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`);

--
-- Indexes for table `pma__favorite`
--
ALTER TABLE `pma__favorite`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__history`
--
ALTER TABLE `pma__history`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`,`db`,`table`,`timevalue`);

--
-- Indexes for table `pma__navigationhiding`
--
ALTER TABLE `pma__navigationhiding`
  ADD PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`);

--
-- Indexes for table `pma__pdf_pages`
--
ALTER TABLE `pma__pdf_pages`
  ADD PRIMARY KEY (`page_nr`),
  ADD KEY `db_name` (`db_name`);

--
-- Indexes for table `pma__recent`
--
ALTER TABLE `pma__recent`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__relation`
--
ALTER TABLE `pma__relation`
  ADD PRIMARY KEY (`master_db`,`master_table`,`master_field`),
  ADD KEY `foreign_field` (`foreign_db`,`foreign_table`);

--
-- Indexes for table `pma__savedsearches`
--
ALTER TABLE `pma__savedsearches`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`);

--
-- Indexes for table `pma__table_coords`
--
ALTER TABLE `pma__table_coords`
  ADD PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`);

--
-- Indexes for table `pma__table_info`
--
ALTER TABLE `pma__table_info`
  ADD PRIMARY KEY (`db_name`,`table_name`);

--
-- Indexes for table `pma__table_uiprefs`
--
ALTER TABLE `pma__table_uiprefs`
  ADD PRIMARY KEY (`username`,`db_name`,`table_name`);

--
-- Indexes for table `pma__tracking`
--
ALTER TABLE `pma__tracking`
  ADD PRIMARY KEY (`db_name`,`table_name`,`version`);

--
-- Indexes for table `pma__userconfig`
--
ALTER TABLE `pma__userconfig`
  ADD PRIMARY KEY (`username`);

--
-- Indexes for table `pma__usergroups`
--
ALTER TABLE `pma__usergroups`
  ADD PRIMARY KEY (`usergroup`,`tab`,`allowed`);

--
-- Indexes for table `pma__users`
--
ALTER TABLE `pma__users`
  ADD PRIMARY KEY (`username`,`usergroup`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pma__bookmark`
--
ALTER TABLE `pma__bookmark`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pma__column_info`
--
ALTER TABLE `pma__column_info`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pma__export_templates`
--
ALTER TABLE `pma__export_templates`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pma__history`
--
ALTER TABLE `pma__history`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pma__pdf_pages`
--
ALTER TABLE `pma__pdf_pages`
  MODIFY `page_nr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pma__savedsearches`
--
ALTER TABLE `pma__savedsearches`
  MODIFY `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- Database: `test`
--
CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `test`;
--
-- Database: `threadit`
--
CREATE DATABASE IF NOT EXISTS `threadit` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `threadit`;

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(11) NOT NULL,
  `content` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `content`, `user_id`, `thread_id`, `created_at`, `updated_at`) VALUES
(1, 'Totally agree. Standard web APIs have caught up. Things like FormData and standard query selectors make frameworks feel optional for smaller projects.', 3, 1, '2026-02-21 09:15:00', '2026-05-23 22:10:38'),
(2, 'While that is true for blogs or simple landing pages, good luck managing state in a massive enterprise application without a structured framework.', 10, 1, '2026-02-21 09:45:00', '2026-05-23 22:10:38'),
(3, 'I love vanilla JS, but the script you shared earlier with an AJAX setup is exactly why people like frameworks. It handles all that boilerplate natively.', 4, 1, '2026-02-21 10:12:00', '2026-05-23 22:10:38'),
(4, 'Have you looked at your execution plan using EXPLAIN? Check if you are hitting full table scans. Indexing foreign keys is usually step one.', 1, 2, '2026-02-22 10:45:00', '2026-05-23 22:10:38'),
(5, 'Also, consider introducing a caching layer like Redis for data that doesn\'t change every second. Don\'t hit the database if you don\'t have to.', 10, 2, '2026-02-22 11:00:00', '2026-05-23 22:10:38'),
(6, 'Show us the query! It\'s hard to tell without seeing how many subqueries or aggregates you are running.', 8, 2, '2026-02-22 12:30:00', '2026-05-23 22:10:38'),
(7, 'Go with Python first to understand programming concepts without the brutal syntax. Once you get comfortable, look into Go for backend scaling.', 3, 3, '2026-02-23 15:00:00', '2026-05-23 22:10:38'),
(8, 'Do not start with Rust as a complete beginner. The borrow checker will make you want to throw your computer out the window.', 8, 3, '2026-02-23 15:15:00', '2026-05-23 22:10:38'),
(9, 'Thanks for the warning! I think I will stick to Python for a few months.', 2, 3, '2026-02-23 15:45:00', '2026-05-23 22:10:38'),
(10, 'Go is also incredibly elegant and readable. Definitely look into it after you grasp basic concepts.', 5, 3, '2026-02-23 16:00:00', '2026-05-23 22:10:38'),
(11, 'Browser support is finally great for this. It makes UI component libraries much more standalone and portable.', 9, 4, '2026-02-24 09:00:00', '2026-05-23 22:10:38'),
(12, 'I still catch myself using media queries out of muscle memory, but I am trying to break the habit.', 2, 4, '2026-02-24 10:22:00', '2026-05-23 22:10:38'),
(13, 'I treat it like a junior developer who writes incredibly fast but makes stupid mistakes. You have to review everything carefully.', 1, 5, '2026-02-25 13:30:00', '2026-05-23 22:10:38'),
(14, 'It has definitely made me lazier with syntax details, but it lets me focus much more on architecture and system design.', 6, 5, '2026-02-25 14:10:00', '2026-05-23 22:10:38'),
(15, 'Ouch! The terminal tab mistake is a classic. This is why my production terminal has a bright, flashing red background.', 5, 6, '2026-02-26 16:35:00', '2026-05-23 22:10:38'),
(16, 'I accidentally set an infinite loop in a script that emailed our entire user base. Sent about 15 duplicate marketing emails to 50k users before killing the process.', 7, 6, '2026-02-26 17:10:00', '2026-05-23 22:10:38'),
(17, 'Reading these comments makes me feel so much better about my minor git merge conflicts today.', 2, 6, '2026-02-26 18:00:00', '2026-05-23 22:10:38');

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

--
-- Table structure for table `comment_votes`
--

CREATE TABLE `comment_votes` (
  `id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `value` tinyint(4) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `comment_votes`
--

INSERT INTO `comment_votes` (`id`, `comment_id`, `user_id`, `value`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(2, 1, 4, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(3, 2, 3, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(4, 2, 1, -1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(5, 4, 5, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(6, 4, 10, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(7, 5, 5, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(8, 7, 2, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(9, 7, 8, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(10, 8, 2, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(11, 8, 3, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(12, 8, 5, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(13, 11, 7, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(14, 13, 4, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(15, 13, 6, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(16, 15, 3, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(17, 15, 7, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(18, 16, 3, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(19, 16, 5, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(20, 16, 1, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(21, 15, 4, 1, '2026-05-23 22:11:08', '2026-05-23 22:11:08'),
(22, 16, 4, -1, '2026-05-23 22:11:09', '2026-05-23 22:11:09'),
(23, 17, 4, 1, '2026-05-23 22:11:10', '2026-05-23 22:11:10');

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

--
-- Table structure for table `threads`
--

CREATE TABLE `threads` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `threads`
--

INSERT INTO `threads` (`id`, `title`, `content`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Why is Vanilla JavaScript making a comeback?', 'With frameworks getting heavier and build steps becoming overly complex, I find myself writing more vanilla JS with custom elements. Anyone else moving away from React/Vue?', 1, '2026-02-21 09:00:00', '2026-05-23 22:10:38'),
(2, 'How to optimize deeply nested SQL queries?', 'I have a tracking table with millions of rows. My JOIN statements are taking upwards of 4 seconds to execute. What are your go-to indexing strategies for optimization?', 5, '2026-02-22 10:30:00', '2026-05-23 22:10:38'),
(3, 'What is the best language to learn in 2026?', 'Hey everyone! Absolute beginner here. I want to dive into backend engineering but I am stuck choosing between Python, Go, and Rust. What do you recommend?', 2, '2026-02-23 14:45:00', '2026-05-23 22:10:38'),
(4, 'CSS Container Queries are a total game changer', 'Seriously, if you are still relying entirely on media queries for responsive components, go check out container queries right now. It makes modular design so much easier.', 7, '2026-02-24 08:15:00', '2026-05-23 22:10:38'),
(5, 'Is AI writing your code or are you writing it?', 'Lately, I feel like I am just an editor for AI-generated boilerplate code. It speeds things up, but I feel like my actual logic-solving skills are getting rusty. Thoughts?', 4, '2026-02-25 13:00:00', '2026-05-23 22:10:38'),
(6, 'The worst deployment mistake you ever made?', 'Let’s clear the air and share some horror stories. I once dropped a production database instead of the staging one because the terminal tabs looked identical. Your turn!', 3, '2026-02-26 16:20:00', '2026-05-23 22:10:38');

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

--
-- Table structure for table `thread_votes`
--

CREATE TABLE `thread_votes` (
  `id` int(11) NOT NULL,
  `thread_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `value` tinyint(4) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `thread_votes`
--

INSERT INTO `thread_votes` (`id`, `thread_id`, `user_id`, `value`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(2, 1, 3, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(3, 1, 4, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(4, 1, 10, -1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(5, 1, 7, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(6, 2, 1, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(7, 2, 8, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(8, 2, 10, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(9, 3, 1, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(10, 3, 3, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(11, 3, 4, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(12, 3, 5, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(13, 3, 8, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(14, 4, 9, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(15, 4, 2, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(16, 5, 1, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(17, 5, 6, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(18, 5, 2, -1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(19, 5, 3, -1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(20, 6, 1, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(21, 6, 2, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(22, 6, 4, -1, '2026-05-23 22:10:38', '2026-05-23 22:11:01'),
(23, 6, 5, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(24, 6, 7, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38'),
(25, 6, 9, 1, '2026-05-23 22:10:38', '2026-05-23 22:10:38');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `email`, `password`, `created_at`, `updated_at`) VALUES
(1, 'tech_guru', 'guru@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-01-10 09:00:00', '2026-05-23 22:10:38'),
(2, 'code_newbie', 'newbie@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-01-11 13:22:00', '2026-05-23 22:10:38'),
(3, 'alice_dev', 'alice@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-01-12 08:15:00', '2026-05-23 22:10:38'),
(4, 'bob_coder', 'bob@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-01-15 17:40:00', '2026-05-23 22:10:38'),
(5, 'database_boss', 'db_boss@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-01-18 10:05:00', '2026-05-23 22:10:38'),
(6, 'charlie_brown', 'charlie@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-02-01 07:30:00', '2026-05-23 22:10:38'),
(7, 'web_weaver', 'weaver@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-02-03 20:12:00', '2026-05-23 22:10:38'),
(8, 'shadow_coder', 'shadow@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-02-10 12:45:00', '2026-05-23 22:10:38'),
(9, 'pixel_perfect', 'pixel@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-02-14 15:18:00', '2026-05-23 22:10:38'),
(10, 'stack_master', 'stack@example.com', '$2y$10$jA3Xgo7pTdetqAGNXRhSJuQlEl0mS/.k/ErPZK3bJlgdbi9FCIr2G', '2026-02-20 18:02:00', '2026-05-23 22:10:38');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_comments_user_id` (`user_id`),
  ADD KEY `idx_comments_thread_id` (`thread_id`);

--
-- Indexes for table `comment_votes`
--
ALTER TABLE `comment_votes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_comment_vote` (`comment_id`,`user_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `idx_comment_votes_comment_id` (`comment_id`);

--
-- Indexes for table `threads`
--
ALTER TABLE `threads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_threads_user_id` (`user_id`);

--
-- Indexes for table `thread_votes`
--
ALTER TABLE `thread_votes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_thread_vote` (`thread_id`,`user_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `idx_thread_votes_thread_id` (`thread_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`thread_id`) REFERENCES `threads` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `comment_votes`
--
ALTER TABLE `comment_votes`
  ADD CONSTRAINT `comment_votes_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `comments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `comment_votes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `threads`
--
ALTER TABLE `threads`
  ADD CONSTRAINT `threads_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `thread_votes`
--
ALTER TABLE `thread_votes`
  ADD CONSTRAINT `thread_votes_ibfk_1` FOREIGN KEY (`thread_id`) REFERENCES `threads` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `thread_votes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;