-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 28, 2026 at 06:12 PM
-- Server version: 11.8.6-MariaDB-0+deb13u1 from Debian
-- PHP Version: 8.4.26

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

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

--
-- Table structure for table `entries`
--

CREATE TABLE `entries` (
  `id` int(11) NOT NULL,
  `entry_date` date NOT NULL,
  `content` mediumtext NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `entries`
--

INSERT INTO `entries` (`id`, `entry_date`, `content`, `created_at`, `updated_at`) VALUES
(1, '2026-09-12', '2026-09-12 12:34 — coffee girls\nspecial Saturday coffee\nTag: special coffee | Weather: cloud\nJeannie Hailey and Olivia were there $4.28 used free drink. Card balance $8.40. both dogs went.', '2026-09-02 03:45:20', '2026-09-13 03:40:27'),
(8, '2026-09-02', '2026-09-02 12:10 — coffee girls\nspecial Wednesday coffee\nTag: special double punch | Weather: cloud\nRobyn was there. $8.96. card balance $34.05. both dogs went.', '2026-09-02 15:36:56', '2026-09-02 20:32:52'),
(9, '2026-09-01', '2026-09-01 13:05 — coffee girls\nspecial Tuesday coffee\nTag: special coffee | Weather: cloud\nHailey was there. $9.43. card balance $43.01. both dogs went.\n2026-09-01 09:00 — Furrwoods\npuppies daycamp\nTag: puppies | Weather: sun\ntext\n\n\n', '2026-09-02 16:54:52', '2026-09-02 20:26:11'),
(15, '2026-08-31', '2026-08-31 11:45 — coffee girls\nspecial Monday coffee\nTag: special coffee | Weather: sun\nOlivia and Jeannie were there. $7.98. put $50.00 on card. Card balance $52.44. both dogs went. Olivia charged the coffee to the credit card. Should not have done that.', '2026-09-02 19:20:38', '2026-09-02 19:20:38'),
(32, '2026-08-30', '2026-08-30 13:32 — coffee girls\nspecial Sunday coffee\nTag: special coffee | Weather: cloud\nKayla was there. $7.00 cash both dogs went.', '2026-09-02 22:06:54', '2026-09-02 22:06:54'),
(34, '2026-08-29', '2026-08-29 13:54 — coffee girls\nspecial Saturday coffee\nTag: special coffee | Weather: cloud\nEm and Charley were there. $3.50 used free drink. card balance $2.44. both dogs went.', '2026-09-02 22:07:33', '2026-09-02 22:07:33'),
(35, '2026-08-28', '2026-08-28 11:25 — coffee girls\nFriday coffee\nTag: coffee | Weather: cloud\nJeannie was there. $8.96. card balance $5.94. Both dogs went.', '2026-09-02 22:08:06', '2026-09-02 22:08:06'),
(36, '2026-08-27', '2026-08-27 11:27 — coffee girls\nspecial Thursday coffee\nTag: special coffee | Weather: cloud\nKendra was there', '2026-09-02 22:08:43', '2026-09-02 22:08:43'),
(37, '2026-08-26', '2026-08-26 13:21 — coffee girls\nspecial Wednesday coffee\nTag: special double punch | Weather: sun\nRobyn was there. $8.96 card balance $23.86. both dogs went.', '2026-09-02 22:09:15', '2026-09-02 22:09:15'),
(38, '2026-09-03', '2026-09-03 11:40 — coffee girls\nspecial Thursday coffee\nTag: special Thursday coffee | Weather: cloud\nKendra was there. $8.96. card balance $25.09. both dogs went.', '2026-09-02 23:52:00', '2026-09-03 19:58:11'),
(46, '2026-09-04', '2026-09-04 12:58 — coffee girls\nFriday coffee\nTag: coffee | Weather: cloud\nKendra was there. $8.96. card balance $16.13. both dogs went.', '2026-09-04 19:03:54', '2026-09-04 20:10:11'),
(50, '2026-09-05', '2026-09-05 11:25 — coffee girls\nspecial Saturday coffee\nTag: special coffee | Weather: cloud\nEm and Olivia were there. $3.50 used free drink. card balance $12.63. both dogs went.', '2026-09-05 19:32:07', '2026-09-05 19:32:07'),
(52, '2026-09-06', '2026-09-06 11:24 — coffee girls\nspecial Sunday coffee\nTag: special coffee | Weather: sun\nHailey and Olivia were there. $3.50 used free drink. card balance $9.13. both dogs went.', '2026-09-06 20:11:42', '2026-09-06 20:11:42'),
(58, '2026-09-07', '2026-09-07 11:51 — coffee girls\nspecial Monday coffee\nTag: special coffee | Weather: sun\nOlivia Em and Kendra were there. $8.69 put $50.00 on card. both dogs went.\n\n2026-09-07 16:29 — Home\nGutter guards installed\nTag: Appointment | Weather: cloud\nleadher roofing\n', '2026-09-07 17:44:05', '2026-09-07 23:30:23'),
(63, '2026-09-08', '2026-09-08 13:05 — coffee girls\nspecial Tuesday coffee\nTag: special coffee | Weather: cloud\nHailey was there. $11.86 card balance $38.58. both dogs went.\n\n2026-09-08 21:00 — Furrwoods\nPuppies Daycamp\nTag: puppies | Weather: sun\ntext\n\n', '2026-09-08 20:18:29', '2026-09-08 20:18:56'),
(68, '2026-09-09', '2026-09-09 12:16 — coffee girls\nspecial Wednesday coffee\nTag: special double punch | Weather: sun\nRobyn was there $8.96. card balance $29.62. both dogs went.', '2026-09-09 20:44:54', '2026-09-09 20:44:54'),
(71, '2026-09-10', '2026-09-10 11:25 — coffee girls\nspecial Thursday coffee\nTag: special coffee | Weather: cloud\nJeannie was there. $8.96. card balance $20.66. both dogs went.', '2026-09-10 20:36:38', '2026-09-10 20:36:38'),
(72, '2026-09-11', '2026-09-11 13:15 — coffee girls\nFriday coffee\nTag: coffee | Weather: cloud\nKayla was there. $7.98 2 special drinks for the week. card balance $12.68. Both dogs went.', '2026-09-11 22:46:20', '2026-09-11 22:46:20'),
(77, '2026-09-13', '2026-09-13 12:20 — coffee girls\nspecial sunday coffee\nTag: special coffee | Weather: vloud\nBrooklynn and Em were there. $3.50 used free drink. card balance $4.90. both dogs went.', '2026-09-13 18:28:56', '2026-09-13 19:40:29'),
(80, '2026-09-14', '2026-09-14 12:15 — coffee girls\nspecial Monday coffee\nTag: special coffee | Weather: cloud\nJeannie and Em were there. $8.86 put $50.00 on card. card balance $45.94. both dogs went.\n\n2026-09-14 20:00 — Happy Pooch\npuppies grooming\nTag: puppies | Weather: cloud\ntext\n\n', '2026-09-14 17:38:00', '2026-09-14 19:15:08'),
(89, '2026-09-15', 'Got Flu shot today \n\n2026-09-15 13:10 — coffee girls\nspecial Tuesday coffee\nTag: special coffee | Weather: cloud\nKayla was there. $7.00 2 special drinks for the week. card balance $38.94. both dogs went.\n\n2026-09-15 09:00 — Furrwoods\npuppies daycamp\nTag: puppies | Weather: cloud\ntext\n', '2026-09-15 18:57:13', '2026-09-15 22:03:28'),
(99, '2026-09-16', '2026-09-16 12:47 — coffee girls\nspecial Wednesday coffee\nTag: special double punch | Weather: sun\nRobyn was there. $8.96 card balance $28.80. both dogs went.\n\n*Power wash house *', '2026-09-16 20:12:10', '2026-09-16 22:39:14'),
(110, '2026-09-17', '2026-09-17 12:48 — coffee girls\nspecial Thursday coffee\nTag: special coffee | Weather: cloud\nEm was there. $11.86 2 lotus specials card balance $16.94. both dogs went.', '2026-09-17 20:51:48', '2026-09-17 20:51:48'),
(111, '2026-09-18', '2026-09-18 12:12 — coffee girls\nFriday coffee\nTag: coffee | Weather: sun\nKendra was there. $8.96. 2 special drinks for the week. card balance $$7.98. both dogs went.', '2026-09-18 20:07:18', '2026-09-18 20:07:18'),
(114, '2026-09-19', '2026-09-19 13:34 — coffee girls\nspecial Saturday coffee\nTag: special coffee | Weather: sun\nEm and Kayla were there. $3.50(cash)used free drink. card balance same. both dogs went.', '2026-09-19 20:59:38', '2026-09-19 20:59:38'),
(117, '2026-09-20', '2026-09-20 12:25 — coffee girls\nspecial Sunday coffee\nTag: special coffee | Weather: cloud\nHailey and Kayla were there. $10.01(cash)London fog for Debbie and caramel latte for me. card balance same. both dogs went.', '2026-09-20 20:17:38', '2026-09-20 20:17:38'),
(121, '2026-09-21', '2026-09-21 14:33 — coffee girls\nspecial Monday coffee\nTag: special coffee | Weather: sun\nEm and Stela were there $7.63 put $50.00 on card. Debbie got london fog. card balance $50.35. New girl started today Stela. both dogs went.', '2026-09-21 19:24:34', '2026-09-21 19:24:34'),
(125, '2026-09-22', '2026-09-22 13:08 — coffee girls\nspecial Tuesday coffee\nTag: special coffee | Weather: cloud\nKayla was there. $7.98 card balance $42.37. both dogs went.\n\n2026-09-22 09:00 — Furrwoods\npuppies daycamp\nTag: puppies | Weather: sun\ntext', '2026-09-22 20:18:02', '2026-09-25 16:48:07'),
(128, '2026-09-23', '2026-09-23 12:50 — coffee girls\nspecial Wednesday coffee\nTag: special double punch | Weather: rain\nRobyn and Stela were there. $8.94. card balance $33.45. both dogs went.\n\n2026-09-23 21:45 — Valley Drugs\ncovid shot\nTag: appointment | Weather: cloud\ntext\n\n', '2026-09-25 16:48:34', '2026-09-25 16:48:54'),
(131, '2026-09-24', '2026-09-24 14:40 — coffee girls\nspecial Thursday coffee\nTag: special coffee | Weather: cloud\nEm was there. $7.98 debbie got london fog drinnk. Card balance $25.47. Both dogs went.', '2026-09-25 16:49:17', '2026-09-25 16:49:17'),
(133, '2026-09-25', '2026-09-25 12:27 — coffee girls\nFriday coffee\nTag: coffee | Weather: rain\nKendra was there. $8.94. card balance $16.55. both dogs went.', '2026-09-25 19:38:41', '2026-09-25 19:38:41'),
(136, '2026-09-26', '2026-09-26 12:10 — coffee girls\nSpecial Saturday coffee\nTag: special coffee | Weather: cloud\nHailey and Em were there. $3.50 used free drink. card balance $13.05. both dogs went.\n\nCoopers birthday!', '2026-09-26 16:58:40', '2026-09-26 19:52:03'),
(145, '2026-09-27', '2026-09-27 12:56 — coffee girls\nspecial Sunday coffee\nTag: special coffee | Weather: sun\nHailey and Em were there. $3.50 Used free drink. card balance $9.55. both dogs went.', '2026-09-27 16:48:04', '2026-09-27 20:16:19');

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

--
-- Table structure for table `entry_photos`
--

CREATE TABLE `entry_photos` (
  `id` int(11) NOT NULL,
  `entry_id` int(11) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `original_name` varchar(255) NOT NULL,
  `uploaded_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `entry_photos`
--

INSERT INTO `entry_photos` (`id`, `entry_id`, `filename`, `original_name`, `uploaded_at`) VALUES
(9, 52, '071ceeda0a0a24b991a904f300c6c94f.jpg', 'IMG_0457.jpeg', '2026-09-06 20:12:58'),
(10, 38, '195b7de0e34bacbe7eb19aea4bd6d8b3.jpg', 'IMG_0430.jpeg', '2026-09-06 20:13:32'),
(11, 52, '27fa2a88ba510de2cf0ca663d6275988.jpg', 'IMG_0493.jpeg', '2026-09-06 22:13:08'),
(12, 52, '82c478a31eff51fe075021c229249e77.jpg', 'IMG_0498.jpeg', '2026-09-07 02:14:33'),
(13, 58, 'de04bcba91b79fb25ab00bae35ffa741.jpg', 'IMG_0508.jpeg', '2026-09-07 17:44:06'),
(14, 58, '204143dabaaabe631066f92368a1543a.jpg', 'IMG_0516.jpeg', '2026-09-07 20:34:17'),
(15, 63, '257e0c7864298f2424e9e0f7a07a8519.jpg', 'IMG_0534.jpeg', '2026-09-08 20:19:04'),
(16, 63, '18eb7709abd682461c51b6ef0fe9c0f9.jpg', 'IMG_0535.jpeg', '2026-09-08 20:19:11'),
(24, 80, 'd968f97ff5b3a725c929a2737049a886.jpg', 'IMG_0600.jpeg', '2026-09-15 19:14:07'),
(25, 89, 'bd9135cd33a7f9acdae3e3a603f2f9ea.jpg', 'IMG_0645.jpeg', '2026-09-15 22:03:37'),
(26, 89, '8b3a39ae4f9cd4d59ef48b077f6ae3d3.jpg', 'IMG_0644.jpeg', '2026-09-15 22:03:43'),
(27, 99, 'f8ee85ed25a7b3ba9e211c3e339ffebc.jpg', 'IMG_0662.jpeg', '2026-09-16 20:12:16'),
(28, 111, 'b2c0c35303d1f4990d1c26f99fc2b64f.jpg', 'IMG_0697.jpeg', '2026-09-18 23:48:24'),
(29, 111, '0f53614037e61ec4ac805811555d8e1a.png', 'IMG_0700.png', '2026-09-19 00:01:00'),
(30, 114, '113fff2fd9e7e646a3ba8b5049044355.jpg', 'IMG_0712.jpeg', '2026-09-20 00:00:25'),
(31, 114, '809a0cd63460a7312a23393400b7b33c.jpg', 'IMG_0713.jpeg', '2026-09-20 00:18:56'),
(37, 133, '1c167a1864ab28477a900ef86282ae77.jpg', 'IMG_0824.jpeg', '2026-09-25 19:39:12'),
(38, 136, '16a06852e0299bc31fbbe35af8d51baf.jpg', 'IMG_0841.jpeg', '2026-09-26 16:58:40'),
(39, 136, '7d630742180c08efd1b9bc75fb050b98.jpg', 'IMG_0848.jpeg', '2026-09-26 20:53:22'),
(40, 145, '773715715ed9a88e2e621122c7379176.jpg', 'IMG_0850.jpeg', '2026-09-27 16:48:04'),
(41, 145, '70d56f8274b33cceca47dfb20f9ebe31.jpg', 'IMG_0851.jpeg', '2026-09-27 16:48:11'),
(42, 145, '6f7cb9edaefc1c84ec79b9eb6f9a1d48.jpg', 'IMG_0858.jpeg', '2026-09-27 23:01:00'),
(43, 145, '921415aa03da84641bf914ba87145897.jpg', 'IMG_0855.jpeg', '2026-09-27 23:01:07');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `entries`
--
ALTER TABLE `entries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `entry_date` (`entry_date`);
ALTER TABLE `entries` ADD FULLTEXT KEY `ft_content` (`content`);

--
-- Indexes for table `entry_photos`
--
ALTER TABLE `entry_photos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `entry_id` (`entry_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `entry_photos`
--
ALTER TABLE `entry_photos`
  ADD CONSTRAINT `entry_photos_ibfk_1` FOREIGN KEY (`entry_id`) REFERENCES `entries` (`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 */;