-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 11, 2026 at 03:29 PM
-- Server version: 10.11.19-MariaDB
-- PHP Version: 8.4.25

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: `intel145_weather`
--

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

--
-- Table structure for table `wx_locations`
--

CREATE TABLE `wx_locations` (
  `id` int(10) UNSIGNED NOT NULL,
  `label` varchar(80) NOT NULL DEFAULT '',
  `nickname` varchar(40) NOT NULL,
  `zip` char(5) NOT NULL,
  `lat` decimal(9,6) NOT NULL,
  `lon` decimal(9,6) NOT NULL,
  `tz` varchar(64) DEFAULT NULL,
  `nws_json` mediumtext DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wx_locations`
--

INSERT INTO `wx_locations` (`id`, `label`, `nickname`, `zip`, `lat`, `lon`, `tz`, `nws_json`, `is_default`, `enabled`, `sort_order`, `created_at`, `updated_at`) VALUES
(5, 'West End, NC', 'home', '27376', 35.251200, -79.536000, 'America/New_York', '{\"grid\":\"RAH/45,30\",\"forecast_url\":\"https://api.weather.gov/gridpoints/RAH/45,30/forecast\",\"hourly_url\":\"https://api.weather.gov/gridpoints/RAH/45,30/forecast/hourly\",\"stations\":[\"KSOP\",\"KHFF\",\"KRCZ\",\"KPOB\",\"KSCR\"],\"county\":\"https://api.weather.gov/zones/county/NCC125\",\"zone\":\"https://api.weather.gov/zones/forecast/NCZ075\",\"city\":\"Seven Lakes\",\"state\":\"NC\",\"resolved_at\":\"2026-10-10 15:28:22\"}', 1, 1, 0, '2026-10-10 15:28:21', '2026-10-10 15:28:22'),
(6, 'Raleigh, NC', 'Raleigh', '27617', 35.903400, -78.744700, 'America/New_York', '{\"grid\":\"RAH/70,62\",\"forecast_url\":\"https://api.weather.gov/gridpoints/RAH/70,62/forecast\",\"hourly_url\":\"https://api.weather.gov/gridpoints/RAH/70,62/forecast/hourly\",\"stations\":[\"KRDU\",\"KLHZ\",\"KTTA\",\"KTDF\",\"KJNX\"],\"county\":\"https://api.weather.gov/zones/county/NCC183\",\"zone\":\"https://api.weather.gov/zones/forecast/NCZ041\",\"city\":\"Raleigh\",\"state\":\"NC\",\"resolved_at\":\"2026-10-10 15:36:05\"}', 0, 1, 1, '2026-10-10 15:36:04', '2026-10-10 15:36:05'),
(7, 'Beach Haven, NJ', 'LBI', '08008', 39.641100, -74.192200, 'America/New_York', '{\"grid\":\"PHI/85,70\",\"forecast_url\":\"https://api.weather.gov/gridpoints/PHI/85,70/forecast\",\"hourly_url\":\"https://api.weather.gov/gridpoints/PHI/85,70/forecast/hourly\",\"stations\":[\"KACY\",\"KWRI\",\"KBLM\",\"KVAY\",\"KMIV\"],\"county\":null,\"zone\":\"https://api.weather.gov/zones/forecast/ANZ451\",\"city\":\"Ship Bottom\",\"state\":\"NJ\",\"resolved_at\":\"2026-10-10 15:36:33\"}', 0, 1, 2, '2026-10-10 15:36:33', '2026-10-10 15:36:33'),
(12, 'Beverly Hills, CA', 'beverlyhills_90210', '', 34.090100, -118.406500, NULL, NULL, 0, 1, 99, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `wx_locations`
--
ALTER TABLE `wx_locations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_wx_loc_nick` (`nickname`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `wx_locations`
--
ALTER TABLE `wx_locations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
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 */;