-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Sep 09, 2026 at 07:28 PM -- Server version: 10.11.18-MariaDB-0+deb12u1 -- 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: `cooper57_journal2` -- -- -------------------------------------------------------- -- -- Table structure for table `entries` -- CREATE TABLE `entries` ( `id` int(11) NOT NULL, `entry_date` date NOT NULL, `content` mediumtext NOT NULL DEFAULT '', `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', 'this is a test ', '2026-09-02 03:45:20', '2026-09-02 15:32:15'), (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'); -- -------------------------------------------------------- -- -- 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'); -- -- 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=68; -- -- AUTO_INCREMENT for table `entry_photos` -- ALTER TABLE `entry_photos` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- 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 */;