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

START TRANSACTION;



--
-- Database: `tnvcca`
--

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `event_id` int(11) NOT NULL,
  `event_title` varchar(80) DEFAULT NULL,
  `event_desc` text DEFAULT NULL,
  `event_start` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `event_end` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`event_id`, `event_title`, `event_desc`, `event_start`, `event_end`) VALUES
(1, 'County Meeting', 'Happy New Year!', '2025-06-21 07:00:00', '2025-06-22 06:59:59'),
(2, 'Last Day of January', 'Last day of the month! Yay!', '2010-01-31 08:00:00', '2010-02-01 07:59:59');

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

--
-- Table structure for table `notices`
--

CREATE TABLE `notices` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `img` varchar(255) NOT NULL,
  `url_link` varchar(255) NOT NULL,
  `published_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `notices`
--

INSERT INTO `notices` (`id`, `title`, `description`, `img`, `url_link`, `published_date`) VALUES
(1, 'It\'s So Easy to Fall in Love', 'Our banks are for people. Their banks are for corporations.\r\nIt\'s that simple.\r\nIf you want to live your life as an American and claim your Constitutional\r\nGuarantees and enjoy your natural freedoms, you have to make a decision\r\nand declare and record it.', 'images/anna194.jpg', 'http://annavonreitz.com/easytofallinlove.pdf', '2025-06-23 04:14:00'),
(2, 'Notice to All World Trust Trustees', 'As the only verifiable senior member of Saint Germain\'s family left on the planet and the only one permitted to stand in the role of Donor, I am appalled by attempts by unauthorized persons to incorporate the St. Germain family trust as part of the publis', 'images/anna194.jpg', 'http://annavonreitz.com/worldtrusttrustees.pdf', '2023-12-24 19:19:00'),
(3, 'declared FEMA Personnel engaged in obstructing', 'All public employees and subcontractors of government at all levels are\r\nrequired to render all assistance possible. ', '', 'https://tasa.americanstatenationals.org/wp-content/uploads/2024/10/hurricanehelenepublicnotice-FEMA-10-5-2024.pdf', '2024-10-05 20:40:00'),
(4, 'Your Political Status has been changed', 'International Public Notice is to inform you that the <br>foreign United States Government has criminally converted your political status', '', 'https://claimyourinheritance.info/wp-content/uploads/2025/06/ASN-Revised-Final-Video.mp4', '2025-06-24 20:42:00');

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

--
-- Table structure for table `officials`
--

CREATE TABLE `officials` (
  `official_id` int(100) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `official` varchar(50) NOT NULL,
  `birthday` varchar(100) DEFAULT NULL,
  `gender` varchar(100) DEFAULT NULL,
  `card_number` varchar(100) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `profile_picture` varchar(100) DEFAULT NULL,
  `bio_info` text DEFAULT NULL,
  `active` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `officials`
--

INSERT INTO `officials` (`official_id`, `firstname`, `lastname`, `username`, `official`, `birthday`, `gender`, `card_number`, `email`, `phone`, `profile_picture`, `bio_info`, `active`) VALUES
(1, 'Keith', 'Love', 'keithl', 'Sheriff', '', 'Male', '', 'keith.love@theclarkcountynevadagov.land', '', '', NULL, 1),
(2, 'Tom', 'varga', 'tomv', 'UnderSheriff', '', 'Male', '', 'tom.varga@thenevadaassemblygov.land', '', '', NULL, 1),
(3, 'Pauline', 'White', 'paulinew', 'JusticeofthePeace', '', 'Female', '', 'justiceofthepeace@theclarkcountynevadagov.land', '', '', NULL, 1),
(4, 'Nader', 'Rouhani', 'naderr', 'Coroner', '', 'Male', '', 'coroner@thenevadaassemblygov.land', '', '', NULL, 1),
(5, 'Pam', 'Banks', 'pamb', 'CountyClerk', '', 'Female', '', 'courtclerk@theclarkcountynevadagov.land', '', '', NULL, 1),
(6, 'Katia', 'Lucey', 'katial', 'Recorder', '', 'Female', '', 'courtrecorder@@theclarkcountynevadagov.land', '', '', NULL, 1),
(7, 'Rockie', 'Roper', 'rockier', 'Coordinator', '', 'Male', '', 'rockie.roper@thenevadaassemblygov.land', '', '../assets/images/Rockie.jpg', NULL, 1),
(8, 'Tamara', 'Amaral', 'tamaraa', 'Coordinator', '', 'Female', '', 'tamara.amaral@thenevadaassemblygov.land', '', '', NULL, 1),
(9, 'Sue', 'Husebus', 'sueh', 'Coordinator', '', 'Female', '', 'suebh@nevadaassembly.org', '', '', NULL, 1),
(10, 'Aaron', 'Lucey', 'aaronl', 'RecordingSecretary', '', 'Male', '', 'aaron.lucey@thenevadaassemblygov.land', '', '', NULL, 1),
(11, 'Michelle', 'Schmidt', 'michells', 'RecordingSecretary', '', 'Female', '', 'michelle.schmidt@thenevadaassemblygov.land', '', '', NULL, 1),
(12, 'Tamara', 'Amaral', 'tamaraa', 'RecordingSecretary', '', 'Female', '', 'tamara.amaral@thenevadaassemblygov.land', '', '', NULL, 1);

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

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

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `user_name` varchar(80) DEFAULT NULL,
  `user_pass` varchar(47) DEFAULT NULL,
  `user_email` varchar(80) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `users` (`user_id`, `user_name`, `user_pass`, `user_email`) VALUES
(1, 'tnvauser', 'a1645e41f29c45c46539192fe29627751e1838f7311eeb4', 'admin@example.com');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`event_id`),
  ADD KEY `event_start` (`event_start`);

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

--
-- Indexes for table `officials`
--
ALTER TABLE `officials`
  ADD PRIMARY KEY (`official_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `user_name` (`user_name`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `officials`
--
ALTER TABLE `officials`
  MODIFY `official_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

