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

START TRANSACTION;



--
-- Database: `gopools_crm`
--

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_person` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` decimal(10,7) DEFAULT NULL,
  `lng` decimal(10,7) DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `code`, `name`, `contact_person`, `phone`, `email`, `address`, `postal_code`, `city`, `lat`, `lng`, `notes`, `active`, `created_at`, `updated_at`) VALUES
(1, NULL, 'ΠΕΤΡΟΣ ΦΙΛΙΠΠΟΥΣΗΣ', 'ΠΕΤΡΟΣ ΦΙΛΙΠΠΟΥΣΗΣ', '6977269099', 'petros.filippousis@alfil.gr', NULL, NULL, NULL, NULL, NULL, 'Created from inbox email #2', 1, '2026-03-27 23:30:44', '2026-03-28 08:06:27'),
(2, NULL, 'IDEALES', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:30:58', '2026-03-28 09:30:58'),
(3, NULL, 'OREON POOLS', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:31:09', '2026-03-28 09:31:09'),
(4, NULL, 'ΡΑΜΜΟΣ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:31:49', '2026-03-28 09:31:49'),
(5, NULL, 'REDOX', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:32:29', '2026-03-28 09:32:29'),
(6, NULL, 'FILPRO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:32:37', '2026-03-28 09:32:37'),
(7, NULL, 'ΣΤΑΘΟΠΟΥΛΟΣ ΝΙΚΟΣ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:32:52', '2026-03-28 09:32:52'),
(8, NULL, 'TOP PISINES', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:33:12', '2026-03-28 09:33:12'),
(9, NULL, 'ΓΡΗΓΟΡΗΣ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:33:23', '2026-03-28 09:33:23'),
(10, NULL, 'ΚΟΡΦΙΑΤΗΣ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:33:47', '2026-03-28 09:33:47'),
(11, NULL, 'NOVALIS', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:33:58', '2026-03-28 09:33:58'),
(12, NULL, 'ΤΕΧΝΙΚΗ ΠΙΣΙΝΕΣ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:34:18', '2026-03-28 09:34:18'),
(13, NULL, 'GOPOOLS', NULL, '1234567890', 'test@gopools.gr', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-28 09:34:40', '2026-04-05 10:02:39'),
(14, NULL, 'ΣΤΕΛΙΟΣ ΛΟΥΤΣΑ', 'ΣΤΕΛΙΟΣ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ΠΙΣΙΝΑ ΜΠΕΤΟ. ΜΟΝΟ ΜΗΧΑΝΟΣΤΑΣΙΟ', 1, '2026-03-29 23:48:45', '2026-03-29 23:48:45'),
(15, NULL, 'Ioannis Orfanidis', 'Ioannis Orfanidis', '+30 694 660 8899', 'ioan.orfanidis@gmail.com', NULL, NULL, NULL, NULL, NULL, 'Auto-created from inbox email #4 using signature matching', 1, '2026-04-02 21:49:48', '2026-04-02 21:49:48'),
(16, NULL, 'Orfanidis Ioannis', 'Orfanidis Ioannis', '+30 210 61 48 419', 'i.orfanidis@gopools.gr', NULL, NULL, NULL, NULL, NULL, 'Created from inbox email #11 using signature matching', 1, '2026-04-03 00:04:12', '2026-04-03 00:04:12'),
(17, NULL, 'ANASTASIA SPIRIDI', 'ANASTASIA SPIRIDI', '+30 6956290290', 'ailantzi@novalisterra.gr', '47 Avenue Nikis', '54629', 'Thessaloniki', NULL, NULL, 'Auto-created from inbox email #12 using signature matching', 1, '2026-04-06 15:20:24', '2026-04-08 22:10:17'),
(18, NULL, 'KATRATZIS', 'MARIZA KATRATZI', '6987932982', 'katratzis_n@yahoo.com', NULL, NULL, NULL, NULL, NULL, 'Created from inbox email #13 using signature matching', 1, '2026-04-07 11:11:03', '2026-04-07 11:12:04'),
(19, NULL, 'ΑΡΗΣ ΚΟΜΗΣ', NULL, '6938534435', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-04-23 08:54:09', '2026-04-23 08:54:09'),
(20, NULL, 'Orfanidis Ioannis', 'Orfanidis Ioannis', NULL, 'i.orfanidis@gopools.gr', NULL, NULL, NULL, NULL, NULL, 'Auto-created from inbox email #14 using signature matching', 1, '2026-04-29 18:56:07', '2026-04-29 18:56:07');

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_name` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_title` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hourly_rate` decimal(10,2) DEFAULT NULL,
  `daily_rate` decimal(10,2) DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `hourly_rate_local` decimal(12,2) DEFAULT NULL,
  `hourly_rate_outstation` decimal(12,2) DEFAULT NULL,
  `daily_allowance_outstation` decimal(12,2) DEFAULT NULL,
  `food_allowance` decimal(12,2) DEFAULT NULL,
  `overnight_allowance` decimal(12,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`id`, `code`, `full_name`, `phone`, `email`, `role_title`, `hourly_rate`, `daily_rate`, `notes`, `active`, `created_at`, `updated_at`, `hourly_rate_local`, `hourly_rate_outstation`, `daily_allowance_outstation`, `food_allowance`, `overnight_allowance`) VALUES
(1, NULL, 'ΠΑΝΑΓΙΩΤΙΔΗΣ ΠΑΥΛΟΣ', '6972147268', 'p.panagiotidis@gopools.gr', 'MASTER', 10.00, 0.00, NULL, 1, '2026-03-28 08:30:09', '2026-04-02 11:14:20', 10.00, 11.00, NULL, NULL, NULL),
(2, NULL, 'ΛΕΜΠΕΣΗΣ ΜΑΡΙΝΟΣ', '6945111601', 'lempesismarinos0@gmail.com', 'MASTER APRENTICE', 9.00, 0.00, NULL, 1, '2026-03-28 08:34:55', '2026-04-17 08:08:36', 9.00, 10.00, NULL, NULL, NULL),
(3, NULL, 'ΡΟΥΣΙΝΑΣ ΧΡΗΣΤΟΣ', '6981130032', 'christosrousinas79@gmail.com', 'APRENTISE', 8.00, 0.00, NULL, 1, '2026-03-28 08:35:45', '2026-04-17 08:09:27', 8.00, 9.00, NULL, NULL, NULL),
(4, NULL, 'ΙΩΑΝΝΗΣ ΟΡΦΑΝΙΔΗΣ', '6978235976', 'ioan.orfanidis@gmail.com', NULL, 8.00, 0.00, NULL, 1, '2026-03-31 21:48:42', '2026-04-02 21:39:13', 8.00, 9.00, NULL, NULL, NULL);

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

--
-- Table structure for table `employee_job_photos`
--

CREATE TABLE `employee_job_photos` (
  `id` int(11) NOT NULL,
  `project_assignment_id` int(11) NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uploaded_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `employee_project_expenses`
--

CREATE TABLE `employee_project_expenses` (
  `id` int(10) UNSIGNED NOT NULL,
  `employee_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `expense_date` date NOT NULL,
  `expense_type` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `external_partners`
--

CREATE TABLE `external_partners` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_person` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `specialty` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vat_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rate_type` enum('per_hour','per_day','per_project','custom') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'custom',
  `rate_amount` decimal(12,2) DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `external_partners`
--

INSERT INTO `external_partners` (`id`, `code`, `company_name`, `contact_person`, `phone`, `email`, `specialty`, `vat_number`, `city`, `rate_type`, `rate_amount`, `notes`, `active`, `created_at`, `updated_at`) VALUES
(1, 'PART-20260328-092343', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', '6983300598', 't.bouronikos@gopools.gr', 'LINER', '164307991', 'ATHENS', 'per_project', NULL, NULL, 1, '2026-03-28 09:23:43', '2026-04-06 21:24:06'),
(2, 'PART-20260328-092947', 'ΚΩΝΣΤΑΝΤΙΝΙΔΗΣ ΝΙΚΟΛΑΟΣ', 'ΚΩΝΣΤΑΝΤΙΝΙΔΗΣ ΝΙΚΟΛΑΟΣ', '6955250797', 'nikoskonst1986@icloud.com', 'LINER', '801322897', 'ATHENS', 'per_project', NULL, NULL, 1, '2026-03-28 09:29:47', '2026-04-08 17:43:39');

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

--
-- Table structure for table `inbox_attachments`
--

CREATE TABLE `inbox_attachments` (
  `id` int(10) UNSIGNED NOT NULL,
  `inbox_email_id` int(10) UNSIGNED NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` int(10) UNSIGNED DEFAULT NULL,
  `extracted_text` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inbox_attachments`
--

INSERT INTO `inbox_attachments` (`id`, `inbox_email_id`, `file_name`, `file_path`, `mime_type`, `file_size`, `extracted_text`, `created_at`) VALUES
(9, 4, 'image001.png', '/gopools/public/uploads/inbox/2026/04/1775117044_7186_image001.png', 'application/png', 135, NULL, '2026-04-02 11:04:04'),
(10, 4, '____01.pdf', '/gopools/public/uploads/inbox/2026/04/1775117044_6808_____01.pdf', 'application/pdf', 406717, NULL, '2026-04-02 11:04:04'),
(11, 4, '_________________________________________________OKT_25_.pdf', '/gopools/public/uploads/inbox/2026/04/1775117044_5988__________________________________________________OKT_25_.pdf', 'application/pdf', 793966, NULL, '2026-04-02 11:04:04'),
(12, 4, '______________________________________OKT_25.pdf', '/gopools/public/uploads/inbox/2026/04/1775117044_9460_______________________________________OKT_25.pdf', 'application/pdf', 956350, NULL, '2026-04-02 11:04:04'),
(13, 5, 'image001.jpg', '/gopools/public/uploads/inbox/2026/04/1775117050_1083_image001.jpg', 'application/jpeg', 2011, NULL, '2026-04-02 11:04:10'),
(14, 5, '22914_FILAGPAR______1696084___.02_______________________________20251202.pdf', '/gopools/public/uploads/inbox/2026/04/1775117050_1140_22914_FILAGPAR______1696084___.02_______________________________20251202.pdf', 'application/pdf', 2627556, NULL, '2026-04-02 11:04:10'),
(15, 5, '22914_FILAGPAR______1696084__________.01__________________20251202.pdf', '/gopools/public/uploads/inbox/2026/04/1775117050_9649_22914_FILAGPAR______1696084__________.01__________________20251202.pdf', 'application/pdf', 1989720, NULL, '2026-04-02 11:04:10'),
(16, 5, '22914_FILAGPAR______1696084________________________20251202.pdf', '/gopools/public/uploads/inbox/2026/04/1775117050_9426_22914_FILAGPAR______1696084________________________20251202.pdf', 'application/pdf', 882994, NULL, '2026-04-02 11:04:10'),
(17, 5, '22914_FILAGPAR______1696084___.01_______________________________20251202.pdf', '/gopools/public/uploads/inbox/2026/04/1775117050_9758_22914_FILAGPAR______1696084___.01_______________________________20251202.pdf', 'application/pdf', 827832, NULL, '2026-04-02 11:04:10'),
(31, 10, 'cpanel-logo-tiny.png', '/gopools/public/uploads/inbox/2026/04/1775155737_5950_cpanel-logo-tiny.png', 'application/png', 18341, NULL, '2026-04-02 21:48:57'),
(32, 10, 'email-projects_gopools.gr.mobileconfig', '/gopools/public/uploads/inbox/2026/04/1775155737_1945_email-projects_gopools.gr.mobileconfig', 'application/octet-stream', 6144, NULL, '2026-04-02 21:48:57'),
(33, 11, 'image001.png', '/gopools/public/uploads/inbox/2026/04/1775163842_6640_image001.png', 'application/png', 17890, NULL, '2026-04-03 00:04:02'),
(34, 11, 'image003.jpg', '/gopools/public/uploads/inbox/2026/04/1775163842_7886_image003.jpg', 'application/jpeg', 217024, NULL, '2026-04-03 00:04:02'),
(35, 11, 'image004.jpg', '/gopools/public/uploads/inbox/2026/04/1775163842_1271_image004.jpg', 'application/jpeg', 13673, NULL, '2026-04-03 00:04:02'),
(36, 11, 'image002.png', '/gopools/public/uploads/inbox/2026/04/1775163842_6034_image002.png', 'application/png', 145461, NULL, '2026-04-03 00:04:02'),
(37, 11, 'image005.jpg', '/gopools/public/uploads/inbox/2026/04/1775163842_1651_image005.jpg', 'application/jpeg', 308080, NULL, '2026-04-03 00:04:02'),
(38, 14, 'image002.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_1983_image002.jpg', 'application/jpeg', 11075, NULL, '2026-04-29 18:55:34'),
(39, 14, 'foto_pisina_tzia_1.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_3104_foto_pisina_tzia_1.jpg', 'application/jpeg', 87959, NULL, '2026-04-29 18:55:34'),
(40, 14, 'foto_pisina_tzia_2.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_4616_foto_pisina_tzia_2.jpg', 'application/jpeg', 100809, NULL, '2026-04-29 18:55:34'),
(41, 14, 'foto_pisina_tzia_3.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_6714_foto_pisina_tzia_3.jpg', 'application/jpeg', 108374, NULL, '2026-04-29 18:55:34'),
(42, 14, 'foto_pisina_tzia_4.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_3994_foto_pisina_tzia_4.jpg', 'application/jpeg', 70535, NULL, '2026-04-29 18:55:34');

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

--
-- Table structure for table `inbox_emails`
--

CREATE TABLE `inbox_emails` (
  `id` int(10) UNSIGNED NOT NULL,
  `message_uid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mailbox` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_email` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_name` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body_text` longtext COLLATE utf8mb4_unicode_ci,
  `body_html` longtext COLLATE utf8mb4_unicode_ci,
  `received_at` datetime DEFAULT NULL,
  `status` enum('new','parsed','approved','archived') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
  `suggested_type` enum('project','customer','task','expense','unknown') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unknown',
  `linked_customer_id` int(10) UNSIGNED DEFAULT NULL,
  `linked_project_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inbox_emails`
--

INSERT INTO `inbox_emails` (`id`, `message_uid`, `mailbox`, `from_email`, `from_name`, `subject`, `body_text`, `body_html`, `received_at`, `status`, `suggested_type`, `linked_customer_id`, `linked_project_id`, `created_at`, `updated_at`) VALUES
(4, NULL, NULL, 'ioan.orfanidis@gmail.com', 'Ioannis Orfanidis', 'Fwd: FW: ΖΗΤΗΣΗ ΠΡΟΣΦΟΡΑΣ ΜΗΧΑΝΟΛΟΓΙΚΟΥ ΕΞΟΠΛΙΣΜΟΥ ΚΑΙ ΕΠΕΝΔΥΣΕΩΝ ΠΙΣΙΝΑΣ', '---------- Forwarded message ---------\nFrom: Ορφανίδης Γεώργιος <g.orfanidis@gopools.gr>\nDate: Thu, Apr 2, 2026 at 8:43 AM\nSubject: FW: ΖΗΤΗΣΗ ΠΡΟΣΦΟΡΑΣ ΜΗΧΑΝΟΛΟΓΙΚΟΥ ΕΞΟΠΛΙΣΜΟΥ ΚΑΙ ΕΠΕΝΔΥΣΕΩΝ\nΠΙΣΙΝΑΣ\nTo: <ioan.orfanidis@gmail.com>\n\n*From:* Anestis Berberis <asb_athens@outlook.com>\n\n*Sent:* Wednesday, September 17, 2025 8:13 PM\n*To:* g.orfanidis@gopools.gr\n*Cc:* Aristotelis Ninios - Euroxx Securities <aninios@euroxx.gr>; Steve\nMoustakas <kendromas@gmail.com>\n*Subject:* ΖΗΤΗΣΗ ΠΡΟΣΦΟΡΑΣ ΜΗΧΑΝΟΛΟΓΙΚΟΥ ΕΞΟΠΛΙΣΜΟΥ ΚΑΙ ΕΠΕΝΔΥΣΕΩΝ ΠΙΣΙΝΑΣ\n\nΓιάννη καλησπέρα,\n\nΣυνημμένα θα βρεις τα αρχιτεκτονικά σχεδία καθώς και την τεχνική περιγραφή\nγια δυο πισίνες στα Καλύβια Αττικής\n\nΠαρακαλώ για την τεχνοοικονομική σου προσφορά που θα περιλαμβάνει τον\nαπαιτούμενο μηχανολογικό εξοπλισμό καθώς και μεμβράνες επένδυσης.\n\nΓια οποιαδήποτε απορία επικοινώνησε μαζί μου.\n\nΜφχ\n\nΜε εκτίμηση\n\n*Μπερμπέρης Ανέστης*\n\nΠολιτικός Μηχανικός\n\nPhone: +30 694 660 8899\nEmail: asb_athens@outlook.com', NULL, '2026-04-02 09:03:40', 'approved', 'project', 15, 7, '2026-04-02 11:04:04', '2026-04-02 21:49:48'),
(5, NULL, NULL, 'i.orfanidis@gopools.gr', 'Orfanidis Ioannis', 'FW: ΠΡΟΣΦΟΡΑ ΚΑΤΑΣΚΕΥΗΣ 3 ΠΙΣΙΝΩΝ ΣΤΗ ΤΗΝΟ', '-------- Αρχικό μήνυμα --------Από: ΠΕΤΡΟΣ ΦΙΛΙΠΠΟΥΣΗΣ <petros.filippousis@alfil.gr> Ημερομηνία: 27/3/26 7:26 π.μ. (GMT+02:00) Προς: i.orfanidis@gopools.gr Κοιν.: Markos Marabotos <mmarabotos@gmail.com> Θέμα: ΠΡΟΣΦΟΡΑ ΚΑΤΑΣΚΕΥΗΣ 3 ΠΙΣΙΝΩΝ ΣΤΗ ΤΗΝΟ \n\nΚαλημέρα σας,\n \nΚατόπιν σύστασης από τον Μάρκο Μαραμπότο, θα ήθελα να μου στείλετε οικονομική προσφορά για την κατασκευή 3 πισίνων στη Χώρα της Τήνου.\n \nΣας στέλνω κάποια σχέδια, για οποιαδήποτε διευκρίνηση επικοινωνήστε μαζί μου.\n \n \nΜε εκτίμηση,\n \n\nΠέτρος Φιλιππούσης\n \nE-mail:\npetros.filippousis@alfil.gr\nΚιν:\n+30 6977269099\nΤηλ:\n 2109852620 & 636\nWeb:\nwww.alfil.gr\n\n \n ', NULL, '2026-03-27 23:29:09', 'new', 'project', NULL, NULL, '2026-04-02 11:04:10', '2026-04-02 11:04:10'),
(10, NULL, NULL, '__cpanel__service__auth__icontact__sbyiz26v07uomdx5@one.titanhost.gr', 'cPanel on gopools.gr', '[gopools.gr] Client configuration settings for “projects@gopools.gr”.', 'Client Configuration settings for “projects@gopools.gr”.\n\nMail Client Manual Settings\n---------------------------\n\nSecure SSL/TLS Settings (Recommended)\n\nUsername:\n\nprojects@gopools.gr\n\nPassword:\n\nUse the email account’s password.\n\nIncoming Server:\n\nmail.gopools.gr\n\n * IMAP Port: 993\n\n * POP3 Port: 995\n\nOutgoing Server:\n\nmail.gopools.gr\n\n * SMTP Port: 465\n\nIMAP, POP3, and SMTP require authentication.\n\nNon-SSL Settings (NOT Recommended)\n\nUsername:\n\nprojects@gopools.gr\n\nPassword:\n\nUse the email account’s password.\n\nIncoming Server:\n\nmail.gopools.gr\n\n * IMAP Port: 143\n\n * POP3 Port: 110\n\nOutgoing Server:\n\nmail.gopools.gr\n\n * SMTP Port: 587\n\nIMAP, POP3, and SMTP require authentication.\n\nA .mobileconfig file for use with iOS for iPhone/iPad/iPod and MacOS® Mail.app® for Mountain Lion (10.8+) is attached to this message.\n\nThis notice is the result of a request made by a computer with the IP address of “150.228.61.74” through the “cpanel” service on the server.\n\nA reverse DNS lookup on the remote IP address returned the host name “customer.sfiabgr1.isp.starlink.com”.\n\nThe remote computer’s location appears to be: Greece (GR).\n\nThe system generated this notice on Friday, March 27, 2026 at 8:51:34 PM UTC.\n\nDo not reply to this automated message.\n\ncP\n\nCopyright© 2026 cPanel, L.L.C.', NULL, '2026-03-27 22:51:34', 'new', 'project', NULL, NULL, '2026-04-02 21:48:57', '2026-04-02 21:48:57'),
(11, NULL, NULL, 'i.orfanidis@gopools.gr', 'Orfanidis Ioannis', 'FW: ΜΠΕΓΛΕΡΗΣ ΧΡΗΣΤΟΣ ΣΠΕΤΣΕΣ', 'From: Dimitra Sikiaridi <sikiaridi@ideales.gr> \nSent: Thursday, April 2, 2026 8:28 PM\nTo: Orfanidis Ioannis <i.orfanidis@gopools.gr>\nSubject: ΜΠΕΓΛΕΡΗΣ ΧΡΗΣΤΟΣ ΣΠΕΤΣΕΣ\n\n \n\nΓιαννη παρακάτω το σχέδιο και φωτογραφίες πως τελικά υλοποιήθηκε 1 σκιμερ, 3\nστόμια, 1 στόμιο αναπλήρωσης, 1 στόμιο υπερχείλισης, 1 φρεάτιο, 2 φώτα.\n\n \n\nΠοσότητες έχουν πάει τα παρακάτω Δες τα πλζ και επιβεβαίωσε ότι φτάνουν για\nνα μην βρεθούμε προ εκπλήξεων \n\n \n\nΑύριο θα είμαι στην αποθήκη μέχρι τις 11:00 εάν είναι πρόλαβε με γιατί θα\nσου στείλω τις βαμμένες φλάντζες, 2 λάμπες, υγρό μεμβράνης \n\n \n\nΠες μου πόσα άτομα θα είναι και πότε υπολογίζεται να ξεκινήσει να γεμίζει\n\n \n\n \n\n \n\n \n\n \n\n \n\n \n\n \n\n \n\nDimitra Sikiaridi\n\nCustomer Care/Sales \n\nIdeales Group \n\n+30 210 61 48 419\n\nDive into <http://www.idealesresort.gr/> www.Ideales.gr', NULL, '2026-04-03 00:03:47', 'approved', 'project', 16, 8, '2026-04-03 00:04:02', '2026-04-03 00:04:34'),
(12, NULL, NULL, 'i.orfanidis@gopools.gr', 'Orfanidis Ioannis', 'FW: Πισίνα Καλλιράχη', '-------- Αρχικό μήνυμα --------Από: Anastasia Ilantzi <ailantzi@novalisterra.gr> Ημερομηνία: 6/4/26 11:04 π.μ. (GMT+02:00) Προς: i.orfanidis@gopools.gr Θέμα: Πισίνα Καλλιράχη Καλημέρα,Όπως είπαμε για την πισίνα της Θάσου 3 ρολά μεμβράνη (σχεδόν 4*10, 1.60 βάθος)ΥγρόΛύση μάλλον χωρίς αρμούς ο πυθμέναςΜηχάνημα το 25 με την ανάποδη κολύμβηση (αν το λέω σωστά)Σκάλα μεταλλική muro 4 lux (316)+ 3 έξτρα φώτα (ξέρει ο Γρηγόρης)Για οτιδήποτε περαιτέρω είμαστε σε επικοινωνία Kind Regards,Anastasia Ilantzi 47 Avenue NikisThessaloniki 54629M.+30 6956290290', NULL, '2026-04-06 11:05:12', 'approved', 'project', 17, 10, '2026-04-06 15:19:34', '2026-04-06 15:20:24'),
(13, NULL, NULL, 'i.orfanidis@gopools.gr', 'Orfanidis Ioannis', 'FW: πισινα Βριλήσσια', '-------- Αρχικό μήνυμα --------Από: nikos katrantzis <katrantzis_n@yahoo.com> Ημερομηνία: 7/4/26 10:16 π.μ. (GMT+02:00) Προς: Orfanidis Ioannis <i.orfanidis@gopools.gr> Θέμα: πισινα Βριλήσσια καλημέρα η διευθυνση για αύριο Τετάρτη  είναι ΣΟΦΟΚΛΕΟΥΣ 3Α ΒΡΙΛΛΗΣΙΑ τηλ του Χρήστου που θα παει 6987932982.κουδουνι ΜΑΡΙΝΗΣ ΑΡΗΣ. Αν έχετε θα ήθελα το στεφάνι και τη φλάντζα του φωτιστικου αστραλ το στανταρ  ΜΕ ΕΚΤΙΜΗΣΗΓΙΑ ΤΗΝ ΟΕΚΑΤΡΑΝΤΖΗ MAΡΙΖΑΝΙΚΟΣ ΚΑΤΡΑΝΤΖΗΣ ΟΕΕΠΕΞΕΡΓΑΣΙΑ ΝΕΡΟΥΒΕΡΜΙΟΥ 14 ΚΕΡΑΤΣΙΝΙΤΗΛ: 210 4329154FAX: 210 4317185email: katrantzis_n@yahoo.com', NULL, '2026-04-07 10:17:35', 'approved', 'project', 18, 14, '2026-04-07 11:10:56', '2026-04-07 11:13:18'),
(14, NULL, NULL, 'i.orfanidis@gopools.gr', 'Orfanidis Ioannis', 'FW: Προσφορά για τοποθέτηση lyner σε πισίνα στη Τζια.', '-------- Αρχικό μήνυμα --------Από: Redox Engineering <engineering@redoxhellas.com> Ημερομηνία: 27/4/26 3:26 μ.μ. (GMT+02:00) Προς: i.orfanidis@gopools.gr Κοιν.: Christos Christodoulou <christodoulou@redoxhellas.com> Θέμα: FW: Προσφορά για τοποθέτηση lyner σε πισίνα στη Τζια. \n\nΓιάννη καλησπέρα,\n \nΣε παρακαλώ την προσφορά για εγκατάσταση\nliner. Η πισίνα είναι στην Τζια.Eπίσης\n θέλω να ρωτήσω , έτσι όπως είναι τα σκιμμερ , μπαίνει liner?\n\n \nΟι διαστάσεις της πισίνας είναι οι εξής:\nΜήκος 12μ\nΠλάτος 6μ\nΒάθη 1,20μ – 1,70μ – 2,6μ\n \n \nΔεν έχει ρωγμές , δεν έχουμε πουθενά απώλειά νερού και πίσω από το χρώμα υπάρχει μόνωση που αποτελείται από πατητή τσιμεντοκονία με δίχτυ από όσο μπορούμε να γνωρίζουμε.\n\n \nOι εργασίες να έχουν ολοκληρωθεί αρχές Ιουνίου.\n \n Aναμένω νεα σου!!\n \n\n \n\n \n \n ', NULL, '2026-04-27 19:01:52', 'approved', 'project', 20, 46, '2026-04-29 18:55:34', '2026-04-29 18:56:07');

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

--
-- Table structure for table `partner_project_costings`
--

CREATE TABLE `partner_project_costings` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `external_partner_id` int(10) UNSIGNED NOT NULL,
  `submitted_by_user_id` int(10) UNSIGNED DEFAULT NULL,
  `quote_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `status` enum('draft','submitted','approved') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'submitted',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partner_project_costings`
--

INSERT INTO `partner_project_costings` (`id`, `project_id`, `external_partner_id`, `submitted_by_user_id`, `quote_amount`, `notes`, `status`, `created_at`, `updated_at`) VALUES
(1, 6, 1, 1, 620.00, NULL, 'approved', '2026-04-01 19:53:44', '2026-04-02 21:54:05'),
(4, 36, 1, 3, 690.00, NULL, 'submitted', '2026-04-18 14:28:46', '2026-04-18 14:28:46'),
(5, 17, 2, 5, 5000.00, NULL, 'submitted', '2026-04-23 08:48:39', '2026-04-23 08:48:39'),
(6, 34, 2, 5, 1940.00, '8,25x3.5 χωρίς ραφές. Σκάλα πάγκο \r\nΝτύσιμο Στηθαίο \r\nΣτοκαρισμα 1520€\r\nΧιλ αποζημίωση 210€ \r\nΈξοδα ( φαγητά , κόλλα στοκαρισματος ) 210€ \r\n Σύνολο 1940€', 'submitted', '2026-04-25 14:01:40', '2026-04-25 14:04:22'),
(10, 4, 2, 5, 2020.00, NULL, 'submitted', '2026-04-26 11:51:11', '2026-04-26 11:51:11'),
(12, 42, 2, 5, 2260.00, NULL, 'submitted', '2026-05-01 20:17:20', '2026-05-01 20:17:20'),
(13, 49, 2, 5, 580.00, NULL, 'submitted', '2026-05-01 20:17:45', '2026-05-01 20:17:45'),
(15, 50, 2, 5, 1000.00, 'Χωρίς ραφές 6.5 Χ 3 με 4 σκαλιά \r\nΚαι 12 κοψίματα 930€\r\n\r\nΈξοδα αμάξι 70€', 'submitted', '2026-05-05 16:41:29', '2026-05-05 16:42:38');

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

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `status` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT NULL,
  `distance_km` decimal(10,2) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date_planned` date DEFAULT NULL,
  `end_date_actual` date DEFAULT NULL,
  `budget` decimal(12,2) DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `installation_cost` decimal(12,2) DEFAULT NULL,
  `work_region_type` enum('local','outstation') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local',
  `offer_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `code`, `title`, `customer_id`, `category_id`, `status`, `address`, `city`, `latitude`, `longitude`, `distance_km`, `start_date`, `end_date_planned`, `end_date_actual`, `budget`, `notes`, `created_at`, `updated_at`, `installation_cost`, `work_region_type`, `offer_filename`) VALUES
(1, 'PRJ-20260328-080759', 'ΠΡΟΣΦΟΡΑ ΚΑΤΑΣΚΕΥΗΣ 3 ΠΙΣΙΝΩΝ ΣΤΗ ΤΗΝΟ', 1, 1, 'quotation', NULL, 'TINOS', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 'Created from inbox email #2 using signature matching', '2026-03-28 08:07:59', '2026-04-05 00:37:06', NULL, 'local', NULL),
(2, 'PRJ-20260328-094931', 'ΒΑΡΗΣ ΚΟΡΩΠΙΟΥ', 3, 1, 'pending_close', NULL, NULL, NULL, NULL, NULL, '2026-03-26', '2026-03-27', '2026-03-27', NULL, NULL, '2026-03-28 09:49:31', '2026-03-30 18:51:02', NULL, 'local', NULL),
(3, 'PRJ-20260328-095010', 'ΛΥΚΟΒΡΥΣΗ ΒΑΓΓ', 3, 1, 'pending_close', NULL, NULL, NULL, NULL, NULL, '2026-03-28', '2026-03-28', '2026-03-28', NULL, NULL, '2026-03-28 09:50:10', '2026-04-01 17:33:18', NULL, 'local', NULL),
(4, 'PRJ-20260328-095223', 'ΠΗΛΙΟΣ', 2, 1, 'pending_close', NULL, 'ΕΡΕΤΡΙΑ', NULL, NULL, NULL, '2026-03-26', '2026-03-27', '2026-03-28', 2580.00, NULL, '2026-03-28 09:52:23', '2026-04-08 22:18:58', NULL, 'local', NULL),
(5, 'PRJ-20260329-234933', 'ΣΤΕΛΙΟΣ ΛΟΥΤΣΑ ΜΗΧΑΝΟΣΤΑΣΙΟ', 14, 1, 'in_progress', 'ΕΘΝΙΚΗΣ ΑΝΤΙΣΤΑΣΕΩΣ 204', 'Spata-Artemida', 37.9837380, 23.9259356, 26.20, '2026-03-31', '2026-03-31', NULL, 5800.00, 'ΘΕΛΕΙ ΚΑΙ ΑΝΤΛΙΑ ΘΕΡΜΟΤΗΤΑΣ. ΠΡΕΠΕΙ ΝΑ ΠΛΗΡΩΣΕΙ ΓΙΑ ΝΑ ΓΙΝΕΙ ΠΑΡΑΓΓΕΛΙΑ\r\n3 ΦΩΤΑ', '2026-03-29 23:49:33', '2026-04-16 18:12:06', NULL, 'local', NULL),
(6, 'PRJ-20260401-173513', 'ΒΑΦΕΙΑΔΗΣ', 7, 1, 'completed', 'προυσης 21', 'ΝΙΚΑΙΑ', NULL, NULL, NULL, '2026-04-01', '2026-04-01', '2026-04-01', 2250.00, NULL, '2026-04-01 17:35:13', '2026-04-06 21:28:50', NULL, 'local', NULL),
(7, 'PRJ-20260402-214948', 'ΖΗΤΗΣΗ ΠΡΟΣΦΟΡΑΣ ΜΗΧΑΝΟΛΟΓΙΚΟΥ ΕΞΟΠΛΙΣΜΟΥ ΚΑΙ ΕΠΕΝΔΥΣΕΩΝ ΠΙΣΙΝΑΣ', 13, 1, 'new', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Created from inbox email #4 using signature matching', '2026-04-02 21:49:48', '2026-04-02 21:50:12', NULL, 'local', NULL),
(8, 'PRJ-20260403-000434', 'FW: ΜΠΕΓΛΕΡΗΣ ΧΡΗΣΤΟΣ ΣΠΕΤΣΕΣ', 2, 2, 'completed', NULL, 'Spetses', 37.2586958, 23.1397191, 177.20, '2026-04-24', '2026-04-26', NULL, 2600.00, 'Created from inbox email #11 using signature matching', '2026-04-03 00:04:34', '2026-04-29 23:53:07', NULL, 'local', NULL),
(9, 'PRJ-20260403-080415', 'KOTSONIS', 13, 1, 'in_progress', NULL, 'Fyli', 38.1036218, 23.6693778, 3.80, '2026-04-04', '2026-04-07', NULL, 22500.00, 'Ηλεκτρολυση wifi\r\nΧωρις ραφες πυθμενας', '2026-04-03 08:04:15', '2026-04-16 18:10:49', NULL, 'local', NULL),
(10, 'PRJ-20260406-152024', 'Πισίνα Καλλιράχη', 17, 1, 'new', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Created from inbox email #12 using signature matching', '2026-04-06 15:20:24', '2026-04-30 22:33:14', NULL, 'local', NULL),
(11, 'PRJ-20260406-200356', 'Παρης εκαλη club', 2, 2, 'new', NULL, NULL, NULL, NULL, NULL, '2026-04-07', '2026-04-07', NULL, NULL, NULL, '2026-04-06 20:03:56', '2026-04-06 20:03:56', NULL, 'local', NULL),
(12, 'PRJ-20260406-200648', 'Παρης Βαρναβα', 2, 2, 'new', NULL, NULL, 38.2675090, 23.9715070, NULL, '2026-04-07', '2026-04-07', '2026-04-07', NULL, NULL, '2026-04-06 20:06:48', '2026-04-07 16:53:04', NULL, 'local', NULL),
(13, 'PRJ-20260406-200752', 'Βασιλειαδης', 13, 2, 'new', NULL, 'Βραχάτι', 37.9674395, 22.7968538, NULL, '2026-04-06', '2026-04-07', NULL, NULL, 'Μηχανοστάσιο και μεμβράνη', '2026-04-06 20:07:52', '2026-04-06 20:11:30', NULL, 'local', NULL),
(14, 'PRJ-20260407-111318', 'FW: πισινα Βριλήσσια', 18, 2, 'approved', 'ΣΟΦΟΚΛΕΟΥΣ 3Α', 'ΒΡΙΛΛΗΣΙΑ', NULL, NULL, NULL, '2026-04-08', '2026-04-08', NULL, NULL, 'Created from inbox email #13 using signature matching', '2026-04-07 11:13:18', '2026-04-07 16:34:44', NULL, 'local', NULL),
(15, 'PRJ-20260407-164710', 'AGIA ANNA', 13, 2, 'new', 'ΑΓΙΑ ΑΝΝΑ', 'AGIA ANNA', 38.8598730, 23.4440340, NULL, '2026-04-08', '2026-04-08', NULL, NULL, 'ΕΧΕΙ ΡΑΦΕΣ ΠΟΥ ΘΕΛΟΥΝ ΚΟΛΛΗΜΑ. ΕΙΝΑΙ ΣΤΗΝ ΕΓΓΥΗΣΗ', '2026-04-07 16:47:10', '2026-04-17 08:13:16', NULL, 'local', NULL),
(16, 'PRJ-20260407-165411', 'KS FERTILITY - ΦΙΛΟΘΕΗ', 2, 1, 'new', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-07 16:54:11', '2026-04-10 14:37:20', NULL, 'local', NULL),
(17, 'PRJ-20260407-165507', 'ΣΚΙΑΘΟ ΑΛΕΞΑΝΔΡΟΣ', 13, 2, 'completed', NULL, NULL, NULL, NULL, NULL, '2026-04-14', '2026-04-16', NULL, 7080.00, NULL, '2026-04-07 16:55:07', '2026-04-29 23:30:34', NULL, 'local', NULL),
(18, 'PRJ-20260407-165536', 'ΜΠΕΤΣΙΚΑΣ - ΣΥΡΟΣ', 2, 1, 'completed', NULL, 'siros', NULL, NULL, NULL, '2026-04-20', '2026-04-22', NULL, 3580.00, NULL, '2026-04-07 16:55:36', '2026-04-29 23:52:15', NULL, 'local', NULL),
(19, 'PRJ-20260407-165557', 'Βαγγελης 3.10 χ2 φλατ 1.3 κεφαλονια', 3, NULL, 'new', NULL, 'Kefalonia', NULL, NULL, NULL, '2026-04-17', '2026-04-19', NULL, NULL, NULL, '2026-04-07 16:56:04', '2026-04-16 13:48:55', NULL, 'local', NULL),
(20, 'PRJ-20260407-165714', 'ΒΟΛΟΣ GOPOOLS', 3, 1, 'new', NULL, NULL, NULL, NULL, NULL, '2026-05-11', '2026-05-13', NULL, NULL, '6x3 σκαλα παγκο', '2026-04-07 16:57:14', '2026-05-05 18:07:44', NULL, 'local', NULL),
(21, 'PRJ-20260407-165740', 'HOLT - ΚΕΦΑΛΟΝΙΑ', 2, NULL, 'new', NULL, 'Kefalonia', 38.3085670, 20.4717080, 376.70, NULL, NULL, NULL, NULL, NULL, '2026-04-07 16:57:40', '2026-04-18 12:53:19', NULL, 'local', NULL),
(22, 'PRJ-20260407-165807', 'Κορονη βαγγελης', 3, 1, 'new', NULL, NULL, NULL, NULL, NULL, '2026-05-18', '2026-05-20', NULL, NULL, '11Χ4,5 ΠΑΓΚΟ ΣΚΑΛΕΣ', '2026-04-07 16:58:07', '2026-05-05 18:08:27', NULL, 'local', NULL),
(23, 'PRJ-20260407-165900', 'FLATLINERS - TZIA', 2, NULL, 'completed', NULL, 'kea', NULL, NULL, NULL, '2026-04-29', '2026-05-01', NULL, 1.00, NULL, '2026-04-07 16:59:00', '2026-04-30 18:29:11', NULL, 'local', NULL),
(24, 'PRJ-20260407-165928', 'ΜΑΝΟΣ ΓΙΑΝΝΗΣ - ΤΖΙΑ', 2, 1, 'new', NULL, 'kea', NULL, NULL, NULL, '2026-05-04', '2026-05-06', NULL, NULL, NULL, '2026-04-07 16:59:28', '2026-04-28 18:01:43', NULL, 'local', NULL),
(25, 'PRJ-20260407-165958', 'τζια 7χ3 με καταρακτη 2 μεριες - η βαρη βαγγελης 7χ3', 3, 1, 'completed', NULL, 'kea', NULL, NULL, NULL, '2026-04-27', '2026-04-30', NULL, 1.00, NULL, '2026-04-07 16:59:58', '2026-04-30 00:03:03', NULL, 'local', NULL),
(26, 'PRJ-20260407-170032', 'ΚΟΝΙΝΗΣ & ΣΩΤΗΡΟΠΟΥΛΟΣ ΚΑΝΑΛΙΑ - ΤΖΙΑ', 2, 1, 'completed', NULL, 'kea', NULL, NULL, NULL, '2026-04-27', '2026-04-28', NULL, 1.00, NULL, '2026-04-07 17:00:32', '2026-04-30 00:02:18', NULL, 'local', NULL),
(27, 'PRJ-20260407-170112', 'Παρος 8χ4 φλατ', 3, NULL, 'new', NULL, NULL, NULL, NULL, NULL, '2026-05-14', '2026-05-16', NULL, NULL, NULL, '2026-04-07 17:01:12', '2026-05-05 18:10:37', NULL, 'local', NULL),
(28, 'PRJ-20260407-170153', 'ΒΕΡΟΣ ΦΡΑΓΚΙΣΚΟΣ - ΚΥΘΝΟΣ', 2, 1, 'new', NULL, NULL, NULL, NULL, NULL, '2026-05-06', '2026-05-08', NULL, NULL, 'Το πλοίο φεύγει 08:30 και φτάνει 10:10 κατευθύνεται προς Κανάλα και θα καλέσει τον κ. Νίκο 694691817 ή κ. Μπουριτη 6976590469\r\n\r\nΑυτοί θα έχουν κανονίσει και την διαμονή', '2026-04-07 17:01:53', '2026-05-07 17:11:06', NULL, 'local', NULL),
(29, 'PRJ-20260407-170227', 'Ζάκυνθος 6.5x 3 παγκος', 3, 1, 'new', NULL, NULL, NULL, NULL, NULL, '2026-05-29', '2026-06-01', NULL, NULL, NULL, '2026-04-07 17:02:27', '2026-05-05 18:08:53', NULL, 'local', NULL),
(30, 'PRJ-20260407-170255', 'ΒΟΥΓΑΣ - ΠΟΛΙΤΕΙΑ', 2, 1, 'new', NULL, NULL, NULL, NULL, NULL, '2026-05-11', '2026-05-13', NULL, NULL, NULL, '2026-04-07 17:02:55', '2026-05-05 17:51:56', NULL, 'local', NULL),
(31, 'PRJ-20260407-170321', 'Αιγάλεω 6x 3x5', 3, 1, 'new', NULL, NULL, NULL, NULL, NULL, '2026-06-01', '2026-06-03', NULL, NULL, NULL, '2026-04-07 17:03:21', '2026-05-05 18:12:05', NULL, 'local', NULL),
(32, 'PRJ-20260407-170348', 'Χανια 5 πισινες 6x2.5 μπορει 1 παγκος', 3, NULL, 'new', NULL, NULL, NULL, NULL, NULL, '2026-05-18', '2026-05-22', NULL, NULL, NULL, '2026-04-07 17:03:48', '2026-05-05 18:09:34', NULL, 'local', NULL),
(33, 'PRJ-20260407-170423', 'ΜΠΕΤΣΗΣ - ΜΑΡΟΥΣΙ', 2, 1, 'new', NULL, NULL, NULL, NULL, NULL, '2026-05-14', '2026-05-16', NULL, NULL, NULL, '2026-04-07 17:04:23', '2026-05-05 18:09:13', NULL, 'local', NULL),
(34, 'PRJ-20260410-100432', 'TOREN LARS - ΠΟΡΟΣ', 2, 1, 'completed', NULL, 'poros', NULL, NULL, NULL, '2026-04-21', '2026-04-22', NULL, 3290.00, '+ εξοδα συνεργειου θωμα πρωτη φορα.', '2026-04-10 10:04:32', '2026-04-29 23:52:42', NULL, 'local', NULL),
(35, 'PRJ-20260414-214242', 'ΠΗΛΙΟΣ 3 ΠΙΣΙΝΕΣ', 2, 1, 'new', NULL, NULL, NULL, NULL, NULL, '2026-05-24', '2026-05-30', NULL, NULL, '3 πισινες για τοποθετηση μεμβρανης', '2026-04-14 21:42:42', '2026-04-14 21:43:02', NULL, 'local', NULL),
(36, 'PRJ-20260415-173110', 'Γεωργοπουλος', 2, 2, 'completed', 'Ευρυτανίας 17', 'Διώνη', NULL, NULL, NULL, '2026-04-16', '2026-04-16', NULL, 1.00, NULL, '2026-04-15 17:31:10', '2026-04-30 00:03:34', NULL, 'local', NULL),
(37, 'PRJ-20260416-091046', 'ΣΤΑΜΑΤΗΣ ΓΚΙΡΤΣΗΣ ΒΟΥΛΑ', 13, 2, 'scheduled', 'ΠΡΙΓΚΗΠΟΣ ΠΕΤΡΟΥ 70', 'ΒΟΥΛΑ', NULL, NULL, NULL, '2026-05-09', '2026-05-09', NULL, 10750.00, 'ΚΟΣΤΟΣ ΧΩΡΙΣ ΣΚΟΥΠΑ', '2026-04-16 09:10:46', '2026-05-06 21:35:41', NULL, 'local', 'offer_new_1776319846.pdf'),
(38, 'PRJ-20260416-093313', 'ΚΕΦΑΛΛΟΝΙΑ ΒΑΓΓΕΛΗΣ', 3, 1, 'approved', NULL, 'Kefalonia', 38.2660322, 20.5373903, 376.70, '2026-04-17', '2026-04-17', NULL, NULL, NULL, '2026-04-16 09:33:13', '2026-04-16 18:11:17', NULL, 'local', NULL),
(39, 'PRJ-20260416-173322', 'IDEALES', 2, 3, 'approved', 'Leof. Kifisias 13', 'Marousi', 38.0267239, 23.7893010, NULL, '2026-04-17', '2026-04-17', NULL, NULL, NULL, '2026-04-16 17:33:22', '2026-04-16 17:40:48', NULL, 'local', NULL),
(40, 'PRJ-20260417-091314', 'ΠΟΡΤΟ ΥΔΡΑ ΓΚΙΚΑΣ', 13, 2, 'completed', NULL, 'Porto hydra', 37.4158059, 23.3438113, 165.50, '2026-04-20', '2026-04-22', NULL, 13200.00, '+ 800 € 2 ΦΩΤΙΣΤΙΚΑ\r\n-10% ΣΕ ΟΤΙ ΔΕΝ ΚΟΠΕΙ', '2026-04-17 09:13:14', '2026-04-29 21:15:50', NULL, 'local', NULL),
(41, 'PRJ-20260417-123251', 'ΝΥΔΡΙ', 13, 1, 'approved', NULL, 'ΝΥΔΡΙ', NULL, NULL, NULL, '2026-04-20', '2026-04-26', NULL, NULL, NULL, '2026-04-17 12:32:51', '2026-04-17 23:21:24', NULL, 'local', NULL),
(42, 'PRJ-20260418-123425', 'ALFONSO', 7, 2, 'completed', NULL, 'ΒΟΛΟΣ', NULL, NULL, NULL, '2026-04-27', '2026-04-29', NULL, 3775.00, NULL, '2026-04-18 12:34:25', '2026-05-04 14:15:03', NULL, 'local', NULL),
(43, 'PRJ-20260421-151317', 'Πατηνιωτης', 13, 3, 'approved', NULL, 'Ανάβυσσος', NULL, NULL, NULL, '2026-05-15', NULL, NULL, 6300.00, 'Μονοχρωμη μεμβρανη μπεζ. \r\nΠρεπει να παμε να δουμε τα φιττινγκς', '2026-04-21 15:13:17', '2026-04-21 15:13:17', NULL, 'local', NULL),
(45, 'PRJ-20260423-091105', '25 *8*1,5', 19, 3, 'quotation', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-04-23 09:11:05', '2026-04-23 09:11:05', NULL, 'local', NULL),
(46, 'PRJ-20260429-185607', 'REDOX Προσφορά για τοποθέτηση lyner σε πισίνα στη Τζια.', 5, 2, 'quotation', NULL, 'ΚΕΑ', 37.6048604, 24.3274958, 107.90, '2026-06-08', '2026-06-11', NULL, NULL, 'Created from inbox email #14 using signature matching', '2026-04-29 18:56:07', '2026-05-04 15:02:09', NULL, 'local', NULL),
(47, 'PRJ-20260430-000451', 'Γεωργοπουλος 2', 2, 2, 'completed', NULL, NULL, NULL, NULL, NULL, '2026-04-24', '2026-04-25', NULL, 1.00, NULL, '2026-04-30 00:04:51', '2026-04-30 00:04:51', NULL, 'local', NULL),
(48, 'PRJ-20260430-000608', 'ΣΥΜΕΩΝΙΔΗΣ', 13, 1, 'pending_close', NULL, NULL, NULL, NULL, NULL, '2026-05-02', NULL, NULL, NULL, NULL, '2026-04-30 00:06:08', '2026-04-30 00:06:08', NULL, 'local', NULL),
(49, 'PRJ-20260501-201557', 'Γεωργοπουλος Διώνη', 2, NULL, 'completed', NULL, NULL, NULL, NULL, NULL, '2026-04-24', '2026-04-25', NULL, 1.00, NULL, '2026-05-01 20:15:57', '2026-05-01 20:15:57', NULL, 'local', NULL),
(50, 'PRJ-20260501-204355', 'ΑΓΙΑ ΜΑΡΙΝΑ', 2, 2, 'completed', NULL, NULL, NULL, NULL, NULL, '2026-05-04', '2026-05-05', NULL, 1.00, NULL, '2026-05-01 20:43:55', '2026-05-06 21:35:01', NULL, 'local', NULL),
(51, 'PRJ-20260504-141653', 'ALIMOS STATHOPOULOS', 7, 2, 'approved', NULL, NULL, NULL, NULL, NULL, '2026-05-21', '2026-05-29', NULL, NULL, NULL, '2026-05-04 14:16:53', '2026-05-05 18:10:48', NULL, 'local', NULL),
(53, 'PRJ-20260505-181738', 'ΔΑΜΚΑΛΙΔΗΣ - ΒΟΥΛΑ', 13, 2, 'approved', NULL, 'ΒΟΥΛΑ', NULL, NULL, NULL, '2026-05-18', '2026-05-20', NULL, NULL, NULL, '2026-05-05 18:17:38', '2026-05-05 18:17:38', NULL, 'local', NULL),
(54, 'PRJ-20260507-133457', 'Χαλκιδα Χριστίνα', 13, 3, 'approved', NULL, 'Χαλκιδα', NULL, NULL, NULL, NULL, NULL, NULL, 16.80, 'Συν σκαλα παγκο.', '2026-05-07 13:40:29', '2026-05-07 13:40:29', NULL, 'local', NULL);

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

--
-- Table structure for table `project_assignments`
--

CREATE TABLE `project_assignments` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `assignment_type` enum('employee','partner') COLLATE utf8mb4_unicode_ci NOT NULL,
  `employee_id` int(10) UNSIGNED DEFAULT NULL,
  `external_partner_id` int(10) UNSIGNED DEFAULT NULL,
  `assigned_date` date DEFAULT NULL,
  `assigned_time` time DEFAULT NULL,
  `role_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `status` enum('assigned','in_progress','completed','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'assigned',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `started_at` datetime DEFAULT NULL,
  `stopped_at` datetime DEFAULT NULL,
  `gps_latitude` decimal(10,7) DEFAULT NULL,
  `gps_longitude` decimal(10,7) DEFAULT NULL,
  `checklist_done` tinyint(1) NOT NULL DEFAULT '0',
  `employee_note` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_assignments`
--

INSERT INTO `project_assignments` (`id`, `project_id`, `assignment_type`, `employee_id`, `external_partner_id`, `assigned_date`, `assigned_time`, `role_label`, `notes`, `status`, `created_at`, `updated_at`, `started_at`, `stopped_at`, `gps_latitude`, `gps_longitude`, `checklist_done`, `employee_note`) VALUES
(3, 4, 'partner', NULL, 2, '2026-03-31', NULL, NULL, NULL, 'assigned', '2026-03-31 21:24:39', '2026-03-31 21:24:39', NULL, NULL, NULL, NULL, 0, NULL),
(4, 6, 'partner', NULL, 1, '2026-04-01', NULL, NULL, NULL, 'assigned', '2026-04-01 17:35:59', '2026-04-01 17:35:59', NULL, NULL, NULL, NULL, 0, NULL),
(7, 8, 'partner', NULL, 1, '2026-04-06', NULL, NULL, NULL, 'assigned', '2026-04-03 00:08:13', '2026-04-03 00:08:13', NULL, NULL, NULL, NULL, 0, NULL),
(8, 12, 'partner', NULL, 1, '2026-04-07', NULL, NULL, NULL, 'assigned', '2026-04-06 21:23:30', '2026-04-06 21:23:30', NULL, NULL, NULL, NULL, 0, NULL),
(9, 13, 'employee', 1, NULL, '2026-04-06', NULL, NULL, NULL, 'assigned', '2026-04-06 21:25:07', '2026-04-06 21:25:07', NULL, NULL, NULL, NULL, 0, NULL),
(10, 9, 'employee', 2, NULL, '2026-04-07', NULL, NULL, NULL, 'assigned', '2026-04-06 21:27:02', '2026-04-06 21:27:02', NULL, NULL, NULL, NULL, 0, NULL),
(11, 9, 'employee', 3, NULL, '2026-04-06', NULL, NULL, NULL, 'assigned', '2026-04-06 21:27:14', '2026-04-06 21:27:14', NULL, NULL, NULL, NULL, 0, NULL),
(12, 14, 'partner', NULL, 1, '2026-04-07', NULL, NULL, NULL, 'assigned', '2026-04-07 11:14:25', '2026-04-07 11:14:25', NULL, NULL, NULL, NULL, 0, NULL),
(13, 15, 'employee', 1, NULL, '2026-04-08', NULL, NULL, NULL, 'assigned', '2026-04-07 16:50:13', '2026-04-07 16:50:13', NULL, NULL, NULL, NULL, 0, NULL),
(15, 36, 'partner', NULL, 1, '2026-04-16', NULL, NULL, 'Πλαστικη σκαλα.', 'assigned', '2026-04-15 17:31:35', '2026-04-15 17:31:35', NULL, NULL, NULL, NULL, 0, NULL),
(17, 39, 'employee', 2, NULL, '2026-04-17', NULL, NULL, NULL, 'assigned', '2026-04-16 17:33:49', '2026-04-16 17:33:49', NULL, NULL, NULL, NULL, 0, NULL),
(19, 38, 'partner', NULL, 1, '2026-04-17', NULL, NULL, NULL, 'assigned', '2026-04-16 20:49:58', '2026-04-16 20:49:58', NULL, NULL, NULL, NULL, 0, NULL),
(20, 21, 'partner', NULL, 1, '2026-04-18', NULL, NULL, NULL, 'assigned', '2026-04-16 20:50:28', '2026-04-16 20:50:28', NULL, NULL, NULL, NULL, 0, NULL),
(21, 41, 'employee', 1, NULL, '2026-04-18', NULL, NULL, NULL, 'assigned', '2026-04-18 12:35:50', '2026-04-18 12:35:50', NULL, NULL, NULL, NULL, 0, NULL),
(22, 18, 'partner', NULL, 1, '2026-04-18', NULL, NULL, NULL, 'assigned', '2026-04-18 12:40:38', '2026-04-18 12:40:38', NULL, NULL, NULL, NULL, 0, NULL),
(23, 40, 'employee', 2, NULL, '2026-04-19', NULL, NULL, NULL, 'assigned', '2026-04-19 19:00:24', '2026-04-19 19:00:24', NULL, NULL, NULL, NULL, 0, NULL),
(24, 40, 'employee', 3, NULL, '2026-04-19', NULL, NULL, NULL, 'assigned', '2026-04-19 19:00:26', '2026-04-19 19:00:26', NULL, NULL, NULL, NULL, 0, NULL),
(25, 40, 'employee', 4, NULL, '2026-04-19', NULL, NULL, NULL, 'assigned', '2026-04-19 19:00:31', '2026-04-19 19:00:31', NULL, NULL, NULL, NULL, 0, NULL),
(27, 34, 'partner', NULL, 2, '2026-04-20', NULL, NULL, NULL, 'assigned', '2026-04-19 19:03:45', '2026-04-19 19:03:45', NULL, NULL, NULL, NULL, 0, NULL),
(28, 17, 'partner', NULL, 2, '2026-04-23', NULL, NULL, NULL, 'assigned', '2026-04-23 08:47:44', '2026-04-23 08:47:44', NULL, NULL, NULL, NULL, 0, NULL),
(29, 42, 'partner', NULL, 2, '2026-04-23', NULL, NULL, NULL, 'assigned', '2026-04-23 08:49:46', '2026-04-23 08:49:46', NULL, NULL, NULL, NULL, 0, NULL),
(31, 23, 'partner', NULL, 1, '2026-04-23', NULL, NULL, NULL, 'assigned', '2026-04-23 08:51:42', '2026-04-23 08:51:42', NULL, NULL, NULL, NULL, 0, NULL),
(34, 26, 'partner', NULL, 1, '2026-04-26', NULL, NULL, NULL, 'assigned', '2026-04-29 23:56:49', '2026-04-29 23:56:49', NULL, NULL, NULL, NULL, 0, NULL),
(35, 25, 'partner', NULL, 1, '2026-04-29', NULL, NULL, NULL, 'assigned', '2026-04-29 23:58:56', '2026-04-29 23:58:56', NULL, NULL, NULL, NULL, 0, NULL),
(36, 25, 'employee', 1, NULL, '2026-04-26', NULL, NULL, NULL, 'assigned', '2026-04-29 23:59:10', '2026-04-29 23:59:10', NULL, NULL, NULL, NULL, 0, NULL),
(37, 49, 'partner', NULL, 2, '2026-04-24', NULL, NULL, NULL, 'assigned', '2026-05-01 20:16:18', '2026-05-01 20:16:18', NULL, NULL, NULL, NULL, 0, NULL),
(38, 50, 'partner', NULL, 2, '2026-05-04', NULL, NULL, NULL, 'assigned', '2026-05-01 20:44:09', '2026-05-01 20:44:09', NULL, NULL, NULL, NULL, 0, NULL),
(40, 28, 'employee', 1, NULL, '2026-05-05', NULL, NULL, NULL, 'assigned', '2026-05-05 18:20:45', '2026-05-05 18:20:45', NULL, NULL, NULL, NULL, 0, NULL),
(42, 20, 'partner', NULL, 1, '2026-05-10', NULL, NULL, NULL, 'assigned', '2026-05-06 21:36:10', '2026-05-06 21:36:10', NULL, NULL, NULL, NULL, 0, NULL),
(43, 30, 'partner', NULL, 2, '2026-05-10', NULL, NULL, NULL, 'assigned', '2026-05-06 21:36:29', '2026-05-06 21:36:29', NULL, NULL, NULL, NULL, 0, NULL);

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

--
-- Table structure for table `project_categories`
--

CREATE TABLE `project_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_categories`
--

INSERT INTO `project_categories` (`id`, `name`, `color`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'New pool', '#2563eb', 1, '2026-03-27 20:51:23', '2026-03-27 20:51:23'),
(2, 'Reconstruction', '#d97706', 1, '2026-03-27 20:51:23', '2026-03-27 20:51:23'),
(3, 'Metallic panels', '#16a34a', 1, '2026-03-27 20:51:23', '2026-03-27 20:51:23'),
(4, 'German pool', '#7c3aed', 1, '2026-03-27 20:51:23', '2026-03-27 20:51:23');

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

--
-- Table structure for table `project_comments`
--

CREATE TABLE `project_comments` (
  `id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_comments`
--

INSERT INTO `project_comments` (`id`, `project_id`, `user_id`, `comment`, `created_at`) VALUES
(1, 10, 1, 'Να γινει παραγγελια μεμβρανες υγρο 3 λαμπες για στομια φλις λωρίδες κολλα', '2026-04-06 15:21:29');

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

--
-- Table structure for table `project_duration_suggestions`
--

CREATE TABLE `project_duration_suggestions` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `assignment_id` int(10) UNSIGNED DEFAULT NULL,
  `suggested_by_user_id` int(10) UNSIGNED NOT NULL,
  `suggested_by_type` enum('employee','partner') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'employee',
  `proposed_start_date` date DEFAULT NULL,
  `proposed_end_date` date DEFAULT NULL,
  `proposed_days` int(11) DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','accepted','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `reviewed_by` int(10) UNSIGNED DEFAULT NULL,
  `reviewed_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_duration_suggestions`
--

INSERT INTO `project_duration_suggestions` (`id`, `project_id`, `assignment_id`, `suggested_by_user_id`, `suggested_by_type`, `proposed_start_date`, `proposed_end_date`, `proposed_days`, `notes`, `status`, `reviewed_by`, `reviewed_at`, `created_at`) VALUES
(1, 13, 9, 2, 'employee', '2026-04-06', '2026-04-07', 1, NULL, 'pending', NULL, NULL, '2026-04-08 23:16:42');

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

--
-- Table structure for table `project_edit_permissions`
--

CREATE TABLE `project_edit_permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `can_edit` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_edit_permissions`
--

INSERT INTO `project_edit_permissions` (`id`, `user_id`, `project_id`, `can_edit`, `created_at`) VALUES
(1, 1, 5, 1, '2026-03-31 22:08:19'),
(2, 4, 10, 1, '2026-04-06 15:22:15');

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

--
-- Table structure for table `project_email_log`
--

CREATE TABLE `project_email_log` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `recipient_email` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recipient_name` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject_line` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body_text` mediumtext COLLATE utf8mb4_unicode_ci,
  `status` enum('sent','failed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sent',
  `error_message` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_email_log`
--

INSERT INTO `project_email_log` (`id`, `project_id`, `recipient_email`, `recipient_name`, `subject_line`, `body_text`, `status`, `error_message`, `created_at`) VALUES
(1, 1, 'thomasmpouro@gmail.com', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - FW: ΠΡΟΣΦΟΡΑ ΚΑΤΑΣΚΕΥΗΣ 3 ΠΙΣΙΝΩΝ ΣΤΗ ΤΗΝΟ', 'PROJECT ASSIGNMENT\r\n\r\nProject: FW: ΠΡΟΣΦΟΡΑ ΚΑΤΑΣΚΕΥΗΣ 3 ΠΙΣΙΝΩΝ ΣΤΗ ΤΗΝΟ\r\nCode: PRJ-20260328-080759\r\nStatus: planned\r\nCustomer: ΠΕΤΡΟΣ ΦΙΛΙΠΠΟΥΣΗΣ\r\nCustomer contact: ΠΕΤΡΟΣ ΦΙΛΙΠΠΟΥΣΗΣ\r\nCustomer phone: 6977269099\r\nCustomer email: petros.filippousis@alfil.gr\r\nAddress: \r\nCity: TINOS\r\nStart date: \r\nPlanned end: \r\nBudget: 0.00\r\nMap: https://www.google.com/maps/search/?api=1&query=TINOS\r\n\r\nPROJECT NOTES\r\nCreated from inbox email #2 using signature matching\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- __UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86RLg_______UTF-8_B_MDFfzprOrM_Ezr_PiM63IM_Fz4DOv86zzrXOr86_z4VfMjAyNTEyMDIucGRm__\r\n- __UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg______UTF-8_B_NF_Ol86cX86azpRfzqTOtc_Nz4fOv8_CXzIwMjUxMjAyLnBkZg____\r\n- __UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86X_____UTF-8_B_zpxfzprOlC4wMV_Oms6xz4TPjM_IzrXOuc_CXzIwMjUxMjAyLnBkZg____\r\n- __UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86RLg_______UTF-8_B_MDJfzprOrM_Ezr_PiM63IM6Zz4POv86zzrXOr86_z4VfMjAyNTEyMDIucGRm__\r\n\r\nGoPools CRM', 'failed', 'mail() failed on server', '2026-03-28 11:21:20'),
(2, 1, 'thomasmpouro@gmail.com', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - FW: ΠΡΟΣΦΟΡΑ ΚΑΤΑΣΚΕΥΗΣ 3 ΠΙΣΙΝΩΝ ΣΤΗ ΤΗΝΟ', 'PROJECT ASSIGNMENT\r\n\r\nProject: FW: ΠΡΟΣΦΟΡΑ ΚΑΤΑΣΚΕΥΗΣ 3 ΠΙΣΙΝΩΝ ΣΤΗ ΤΗΝΟ\r\nCode: PRJ-20260328-080759\r\nStatus: planned\r\nCustomer: ΠΕΤΡΟΣ ΦΙΛΙΠΠΟΥΣΗΣ\r\nCustomer contact: ΠΕΤΡΟΣ ΦΙΛΙΠΠΟΥΣΗΣ\r\nCustomer phone: 6977269099\r\nCustomer email: petros.filippousis@alfil.gr\r\nAddress: \r\nCity: TINOS\r\nStart date: \r\nPlanned end: \r\nBudget: 0.00\r\nMap: https://www.google.com/maps/search/?api=1&query=TINOS\r\n\r\nPROJECT NOTES\r\nCreated from inbox email #2 using signature matching\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- __UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86RLg_______UTF-8_B_MDFfzprOrM_Ezr_PiM63IM_Fz4DOv86zzrXOr86_z4VfMjAyNTEyMDIucGRm__\r\n- __UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg______UTF-8_B_NF_Ol86cX86azpRfzqTOtc_Nz4fOv8_CXzIwMjUxMjAyLnBkZg____\r\n- __UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86X_____UTF-8_B_zpxfzprOlC4wMV_Oms6xz4TPjM_IzrXOuc_CXzIwMjUxMjAyLnBkZg____\r\n- __UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86RLg_______UTF-8_B_MDJfzprOrM_Ezr_PiM63IM6Zz4POv86zzrXOr86_z4VfMjAyNTEyMDIucGRm__\r\n\r\nGoPools CRM', 'failed', 'mail() failed on server', '2026-03-28 11:21:40'),
(3, 4, 'p.panagiotidis@gopools.gr', 'ΛΕΜΠΕΣΗΣ ΜΑΡΙΝΟΣ', 'Project Assignment - ΠΗΛΙΟΣ', 'PROJECT ASSIGNMENT\r\n\r\nProject: ΠΗΛΙΟΣ\r\nCode: PRJ-20260328-095223\r\nStatus: active\r\nCustomer: IDEALES\r\nCustomer contact: \r\nCustomer phone: \r\nCustomer email: \r\nAddress: \r\nCity: ΕΡΕΤΡΙΑ\r\nStart date: 2026-03-26\r\nPlanned end: 2026-03-27\r\nBudget: \r\nMap: https://www.google.com/maps/search/?api=1&query=%CE%95%CE%A1%CE%95%CE%A4%CE%A1%CE%99%CE%91\r\n\r\nPROJECT NOTES\r\n\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- no attached files in project\r\n\r\nGoPools CRM', 'failed', 'SMTP unexpected response: 503 AUTH command used when not advertised', '2026-03-28 14:36:04'),
(4, 4, 'p.panagiotidis@gopools.gr', 'ΛΕΜΠΕΣΗΣ ΜΑΡΙΝΟΣ', 'Project Assignment - ΠΗΛΙΟΣ', 'PROJECT ASSIGNMENT\r\n\r\nProject: ΠΗΛΙΟΣ\r\nCode: PRJ-20260328-095223\r\nStatus: active\r\nCustomer: IDEALES\r\nCustomer contact: \r\nCustomer phone: \r\nCustomer email: \r\nAddress: \r\nCity: ΕΡΕΤΡΙΑ\r\nStart date: 2026-03-26\r\nPlanned end: 2026-03-27\r\nBudget: \r\nMap: https://www.google.com/maps/search/?api=1&query=%CE%95%CE%A1%CE%95%CE%A4%CE%A1%CE%99%CE%91\r\n\r\nPROJECT NOTES\r\n\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- no attached files in project\r\n\r\nGoPools CRM', 'failed', 'SMTP unexpected response: 503 AUTH command used when not advertised', '2026-03-28 14:36:20'),
(5, 4, 'I.orfanidis@gopools.gr', NULL, 'Project Assignment - ΠΗΛΙΟΣ', 'PROJECT ASSIGNMENT\r\n\r\nProject: ΠΗΛΙΟΣ\r\nCode: PRJ-20260328-095223\r\nStatus: active\r\nCustomer: IDEALES\r\nCustomer contact: \r\nCustomer phone: \r\nCustomer email: \r\nAddress: \r\nCity: ΕΡΕΤΡΙΑ\r\nStart date: 2026-03-26\r\nPlanned end: 2026-03-27\r\nBudget: \r\nMap: https://www.google.com/maps/search/?api=1&query=%CE%95%CE%A1%CE%95%CE%A4%CE%A1%CE%99%CE%91\r\n\r\nPROJECT NOTES\r\n\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- no attached files in project\r\n\r\nGoPools CRM', 'failed', 'SMTP unexpected response: 503 AUTH command used when not advertised', '2026-03-28 14:36:31'),
(6, 3, 'thomasmpouro@gmail.com', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - ΛΥΚΟΒΡΥΣΗ', 'PROJECT ASSIGNMENT\r\n\r\nProject: ΛΥΚΟΒΡΥΣΗ\r\nCode: PRJ-20260328-095010\r\nStatus: active\r\nCustomer: OREON POOLS\r\nCustomer contact: \r\nCustomer phone: \r\nCustomer email: \r\nAddress: \r\nCity: \r\nStart date: 2026-03-28\r\nPlanned end: 2026-03-28\r\nBudget: \r\n\r\nPROJECT NOTES\r\n\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- no attached files in project\r\n\r\nGoPools CRM', 'sent', NULL, '2026-03-28 14:51:02'),
(7, 3, 'thomasmpouro@gmail.com', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - ΛΥΚΟΒΡΥΣΗ', 'PROJECT ASSIGNMENT\r\n\r\nProject: ΛΥΚΟΒΡΥΣΗ\r\nCode: PRJ-20260328-095010\r\nStatus: active\r\nCustomer: OREON POOLS\r\nCustomer contact: \r\nCustomer phone: \r\nCustomer email: \r\nAddress: \r\nCity: \r\nStart date: 2026-03-28\r\nPlanned end: 2026-03-28\r\nBudget: \r\n\r\nPROJECT NOTES\r\n\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- no attached files in project\r\n\r\nGoPools CRM', 'sent', NULL, '2026-03-28 14:51:12'),
(8, 3, 'thomasmpouro@gmail.com', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - ΛΥΚΟΒΡΥΣΗ', 'PROJECT ASSIGNMENT\r\n\r\nProject: ΛΥΚΟΒΡΥΣΗ\r\nCode: PRJ-20260328-095010\r\nStatus: active\r\nCustomer: OREON POOLS\r\nCustomer contact: \r\nCustomer phone: \r\nCustomer email: \r\nAddress: \r\nCity: \r\nStart date: 2026-03-28\r\nPlanned end: 2026-03-28\r\nBudget: \r\n\r\nPROJECT NOTES\r\n\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- no attached files in project\r\n\r\nGoPools CRM', 'sent', NULL, '2026-03-28 14:51:15'),
(9, 3, 'I.orfanidis@gopools.gr', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - ΛΥΚΟΒΡΥΣΗ', 'PROJECT ASSIGNMENT\r\n\r\nProject: ΛΥΚΟΒΡΥΣΗ\r\nCode: PRJ-20260328-095010\r\nStatus: active\r\nCustomer: OREON POOLS\r\nCustomer contact: \r\nCustomer phone: \r\nCustomer email: \r\nAddress: \r\nCity: \r\nStart date: 2026-03-28\r\nPlanned end: 2026-03-28\r\nBudget: \r\n\r\nPROJECT NOTES\r\n\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- no attached files in project\r\n\r\nGoPools CRM', 'sent', NULL, '2026-03-28 14:51:26'),
(10, 5, 'nikoskonst1986@gmail.com', 'ΚΩΝΣΤΑΝΤΙΝΙΔΗΣ ΝΙΚΟΛΑΟΣ ΚΩΝΣΤΑΝΤΙΝΙΔΗΣ ΝΙΚΟΛΑΟΣ', 'Project Assignment - ΣΤΕΛΙΟΣ ΛΟΥΤΣΑ ΜΗΧΑΝΟΣΤΑΣΙΟ', 'PROJECT ASSIGNMENT\r\n\r\nProject: ΣΤΕΛΙΟΣ ΛΟΥΤΣΑ ΜΗΧΑΝΟΣΤΑΣΙΟ\r\nCode: PRJ-20260329-234933\r\nStatus: active\r\nCustomer: ΣΤΕΛΙΟΣ ΛΟΥΤΣΑ\r\nCustomer contact: ΣΤΕΛΙΟΣ\r\nCustomer phone: \r\nCustomer email: \r\nAddress: ΕΘΝΙΚΗΣ ΑΝΤΙΣΤΑΣΕΩΣ 204\r\nCity: ΑΡΤΕΜΙΔΑ\r\nStart date: 2026-03-30\r\nPlanned end: \r\nBudget: 5800.00\r\nMap: https://www.google.com/maps/search/?api=1&query=%CE%95%CE%98%CE%9D%CE%99%CE%9A%CE%97%CE%A3%20%CE%91%CE%9D%CE%A4%CE%99%CE%A3%CE%A4%CE%91%CE%A3%CE%95%CE%A9%CE%A3%20204%2C%20%CE%91%CE%A1%CE%A4%CE%95%CE%9C%CE%99%CE%94%CE%91\r\n\r\nPROJECT NOTES\r\nΘΕΛΕΙ ΚΑΙ ΑΝΤΛΙΑ ΘΕΡΜΟΤΗΤΑΣ\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- no attached files in project\r\n\r\nGoPools CRM', 'sent', NULL, '2026-03-30 00:03:30'),
(11, 6, 'thomasmpouro@gmail.com', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - ΒΑΦΕΙΑΔΗΣ', 'PROJECT ASSIGNMENT\r\n\r\nProject: ΒΑΦΕΙΑΔΗΣ\r\nCode: PRJ-20260401-173513\r\nStatus: pending_close\r\nCustomer: ΣΤΑΘΟΠΟΥΛΟΣ ΝΙΚΟΣ\r\nCustomer contact: \r\nCustomer phone: \r\nCustomer email: \r\nAddress: προυσης 21\r\nCity: ΝΙΚΑΙΑ\r\nStart date: 2026-04-01\r\nPlanned end: 2026-04-01\r\nBudget: 2250.00\r\nMap: https://www.google.com/maps/search/?api=1&query=%CF%80%CF%81%CE%BF%CF%85%CF%83%CE%B7%CF%82%2021%2C%20%CE%9D%CE%99%CE%9A%CE%91%CE%99%CE%91\r\n\r\nPROJECT NOTES\r\n\r\n\r\nEQUIPMENT\r\n- none\r\n\r\nTASKS\r\n- none\r\n\r\nFILES\r\n- no attached files in project\r\n\r\nGoPools CRM', 'sent', NULL, '2026-04-01 17:36:12'),
(12, 8, 'thomasmpouro@gmail.com', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - FW: ΜΠΕΓΛΕΡΗΣ ΧΡΗΣΤΟΣ ΣΠΕΤΣΕΣ', '<!doctype html>\r\n<html>\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Project Assignment</title>\r\n</head>\r\n<body style=\"margin:0;padding:24px;background:#f3f6fb;font-family:Arial,Helvetica,sans-serif;color:#0f172a;line-height:1.6;\">\r\n  <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"max-width:820px;margin:0 auto;background:#ffffff;border:1px solid #e5e7eb;border-radius:18px;overflow:hidden;\">\r\n    <tr>\r\n      <td style=\"padding:24px 28px;background:linear-gradient(135deg,#2563eb,#0f172a);color:#ffffff;\">\r\n        <div style=\"font-size:13px;opacity:.9;letter-spacing:.08em;text-transform:uppercase;\">GoPools CRM</div>\r\n        <h1 style=\"margin:8px 0 0 0;font-size:28px;line-height:1.2;\">Project Assignment</h1>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:24px 28px;\">\r\n        <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse;\">\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Project</td><td style=\"padding:8px 0;\">FW: ΜΠΕΓΛΕΡΗΣ ΧΡΗΣΤΟΣ ΣΠΕΤΣΕΣ</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Code</td><td style=\"padding:8px 0;\">PRJ-20260403-000434</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Status</td><td style=\"padding:8px 0;\">approved</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Customer</td><td style=\"padding:8px 0;\">IDEALES</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Contact</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Phone</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Email</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Address</td><td style=\"padding:8px 0;\"> · ΣΠΕΤΣΕΣ</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Start date</td><td style=\"padding:8px 0;\">2026-04-06</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Planned end</td><td style=\"padding:8px 0;\">2026-04-08</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Budget</td><td style=\"padding:8px 0;\"></td></tr>\r\n        </table>\r\n        <p style=\"margin:16px 0 0 0\"><a href=\"https://www.google.com/maps/search/?api=1&amp;query=%CE%A3%CE%A0%CE%95%CE%A4%CE%A3%CE%95%CE%A3\" style=\"display:inline-block;background:#2563eb;color:#ffffff;text-decoration:none;padding:10px 14px;border-radius:10px;font-weight:700\">Open map</a></p>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"border:1px solid #e5e7eb;border-radius:14px;padding:16px;background:#f8fafc;\">\r\n          <div style=\"font-weight:800;margin-bottom:8px;\">Project notes</div>\r\n          <div>Created from inbox email #11 using signature matching</div>\r\n        </div>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Equipment</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Tasks</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 28px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Files</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>image005.jpg</li><li>image002.png</li><li>image004.jpg</li><li>image003.jpg</li><li>image001.png</li></ul>\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</body>\r\n</html>', 'sent', NULL, '2026-04-03 00:09:06'),
(13, 13, 'p.panagiotidis@gopools.gr', NULL, 'Project Assignment - Βασιλειαδης', '<!doctype html>\r\n<html>\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Project Assignment</title>\r\n</head>\r\n<body style=\"margin:0;padding:24px;background:#f3f6fb;font-family:Arial,Helvetica,sans-serif;color:#0f172a;line-height:1.6;\">\r\n  <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"max-width:820px;margin:0 auto;background:#ffffff;border:1px solid #e5e7eb;border-radius:18px;overflow:hidden;\">\r\n    <tr>\r\n      <td style=\"padding:24px 28px;background:linear-gradient(135deg,#2563eb,#0f172a);color:#ffffff;\">\r\n        <div style=\"font-size:13px;opacity:.9;letter-spacing:.08em;text-transform:uppercase;\">GoPools CRM</div>\r\n        <h1 style=\"margin:8px 0 0 0;font-size:28px;line-height:1.2;\">Project Assignment</h1>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:24px 28px;\">\r\n        <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse;\">\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Project</td><td style=\"padding:8px 0;\">Βασιλειαδης</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Code</td><td style=\"padding:8px 0;\">PRJ-20260406-200752</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Status</td><td style=\"padding:8px 0;\">new</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Customer</td><td style=\"padding:8px 0;\">GOPOOLS</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Contact</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Phone</td><td style=\"padding:8px 0;\">1234567890</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Email</td><td style=\"padding:8px 0;\">test@gopools.gr</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Address</td><td style=\"padding:8px 0;\"> · Βραχάτι</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Start date</td><td style=\"padding:8px 0;\">2026-04-06</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Planned end</td><td style=\"padding:8px 0;\">2026-04-07</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Budget</td><td style=\"padding:8px 0;\"></td></tr>\r\n        </table>\r\n        <p style=\"margin:16px 0 0 0\"><a href=\"https://www.google.com/maps?q=37.9674395%2C22.7968538\" style=\"display:inline-block;background:#2563eb;color:#ffffff;text-decoration:none;padding:10px 14px;border-radius:10px;font-weight:700\">Open map</a></p>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"border:1px solid #e5e7eb;border-radius:14px;padding:16px;background:#f8fafc;\">\r\n          <div style=\"font-weight:800;margin-bottom:8px;\">Project notes</div>\r\n          <div>Μηχανοστάσιο και μεμβράνη</div>\r\n        </div>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Equipment</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Tasks</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 28px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Files</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>No attached files in project</li></ul>\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</body>\r\n</html>', 'sent', NULL, '2026-04-06 20:12:31'),
(14, 12, 'thomasmpouro@gmail.com', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - Παρης βραβρωνα', '<!doctype html>\r\n<html>\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Project Assignment</title>\r\n</head>\r\n<body style=\"margin:0;padding:24px;background:#f3f6fb;font-family:Arial,Helvetica,sans-serif;color:#0f172a;line-height:1.6;\">\r\n  <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"max-width:820px;margin:0 auto;background:#ffffff;border:1px solid #e5e7eb;border-radius:18px;overflow:hidden;\">\r\n    <tr>\r\n      <td style=\"padding:24px 28px;background:linear-gradient(135deg,#2563eb,#0f172a);color:#ffffff;\">\r\n        <div style=\"font-size:13px;opacity:.9;letter-spacing:.08em;text-transform:uppercase;\">GoPools CRM</div>\r\n        <h1 style=\"margin:8px 0 0 0;font-size:28px;line-height:1.2;\">Project Assignment</h1>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:24px 28px;\">\r\n        <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse;\">\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Project</td><td style=\"padding:8px 0;\">Παρης βραβρωνα</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Code</td><td style=\"padding:8px 0;\">PRJ-20260406-200648</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Status</td><td style=\"padding:8px 0;\">new</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Customer</td><td style=\"padding:8px 0;\">IDEALES</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Contact</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Phone</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Email</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Address</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Start date</td><td style=\"padding:8px 0;\">2026-04-07</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Planned end</td><td style=\"padding:8px 0;\">2026-04-07</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Budget</td><td style=\"padding:8px 0;\"></td></tr>\r\n        </table>\r\n        <p style=\"margin:16px 0 0 0\"><a href=\"https://www.google.com/maps?q=38.2675090%2C23.9715070\" style=\"display:inline-block;background:#2563eb;color:#ffffff;text-decoration:none;padding:10px 14px;border-radius:10px;font-weight:700\">Open map</a></p>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"border:1px solid #e5e7eb;border-radius:14px;padding:16px;background:#f8fafc;\">\r\n          <div style=\"font-weight:800;margin-bottom:8px;\">Project notes</div>\r\n          <div><span style=\"color:#64748b\">No project notes</span></div>\r\n        </div>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Equipment</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Tasks</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 28px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Files</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>No attached files in project</li></ul>\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</body>\r\n</html>', 'sent', NULL, '2026-04-06 21:23:45'),
(15, 13, 'p.panagiotidis@gopools.gr', 'ΠΑΝΑΓΙΩΤΙΔΗΣ ΠΑΥΛΟΣ', 'Project Assignment - Βασιλειαδης', '<!doctype html>\r\n<html>\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Project Assignment</title>\r\n</head>\r\n<body style=\"margin:0;padding:24px;background:#f3f6fb;font-family:Arial,Helvetica,sans-serif;color:#0f172a;line-height:1.6;\">\r\n  <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"max-width:820px;margin:0 auto;background:#ffffff;border:1px solid #e5e7eb;border-radius:18px;overflow:hidden;\">\r\n    <tr>\r\n      <td style=\"padding:24px 28px;background:linear-gradient(135deg,#2563eb,#0f172a);color:#ffffff;\">\r\n        <div style=\"font-size:13px;opacity:.9;letter-spacing:.08em;text-transform:uppercase;\">GoPools CRM</div>\r\n        <h1 style=\"margin:8px 0 0 0;font-size:28px;line-height:1.2;\">Project Assignment</h1>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:24px 28px;\">\r\n        <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse;\">\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Project</td><td style=\"padding:8px 0;\">Βασιλειαδης</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Code</td><td style=\"padding:8px 0;\">PRJ-20260406-200752</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Status</td><td style=\"padding:8px 0;\">new</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Customer</td><td style=\"padding:8px 0;\">GOPOOLS</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Contact</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Phone</td><td style=\"padding:8px 0;\">1234567890</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Email</td><td style=\"padding:8px 0;\">test@gopools.gr</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Address</td><td style=\"padding:8px 0;\"> · Βραχάτι</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Start date</td><td style=\"padding:8px 0;\">2026-04-06</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Planned end</td><td style=\"padding:8px 0;\">2026-04-07</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Budget</td><td style=\"padding:8px 0;\"></td></tr>\r\n        </table>\r\n        <p style=\"margin:16px 0 0 0\"><a href=\"https://www.google.com/maps?q=37.9674395%2C22.7968538\" style=\"display:inline-block;background:#2563eb;color:#ffffff;text-decoration:none;padding:10px 14px;border-radius:10px;font-weight:700\">Open map</a></p>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"border:1px solid #e5e7eb;border-radius:14px;padding:16px;background:#f8fafc;\">\r\n          <div style=\"font-weight:800;margin-bottom:8px;\">Project notes</div>\r\n          <div>Μηχανοστάσιο και μεμβράνη</div>\r\n        </div>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Equipment</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Tasks</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 28px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Files</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>No attached files in project</li></ul>\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</body>\r\n</html>', 'sent', NULL, '2026-04-06 21:25:56'),
(16, 14, 't.bouronikos@gopools.gr', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - FW: πισινα Βριλήσσια', '<!doctype html>\r\n<html>\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Project Assignment</title>\r\n</head>\r\n<body style=\"margin:0;padding:24px;background:#f3f6fb;font-family:Arial,Helvetica,sans-serif;color:#0f172a;line-height:1.6;\">\r\n  <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"max-width:820px;margin:0 auto;background:#ffffff;border:1px solid #e5e7eb;border-radius:18px;overflow:hidden;\">\r\n    <tr>\r\n      <td style=\"padding:24px 28px;background:linear-gradient(135deg,#2563eb,#0f172a);color:#ffffff;\">\r\n        <div style=\"font-size:13px;opacity:.9;letter-spacing:.08em;text-transform:uppercase;\">GoPools CRM</div>\r\n        <h1 style=\"margin:8px 0 0 0;font-size:28px;line-height:1.2;\">Project Assignment</h1>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:24px 28px;\">\r\n        <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse;\">\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Project</td><td style=\"padding:8px 0;\">FW: πισινα Βριλήσσια</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Code</td><td style=\"padding:8px 0;\">PRJ-20260407-111318</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Status</td><td style=\"padding:8px 0;\">approved</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Customer</td><td style=\"padding:8px 0;\">KATRATZIS</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Contact</td><td style=\"padding:8px 0;\">MARIZA KATRATZI</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Phone</td><td style=\"padding:8px 0;\">6987932982</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Email</td><td style=\"padding:8px 0;\">katratzis_n@yahoo.com</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Address</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Start date</td><td style=\"padding:8px 0;\">2026-04-08</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Planned end</td><td style=\"padding:8px 0;\">2026-04-08</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Budget</td><td style=\"padding:8px 0;\"></td></tr>\r\n        </table>\r\n        \r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"border:1px solid #e5e7eb;border-radius:14px;padding:16px;background:#f8fafc;\">\r\n          <div style=\"font-weight:800;margin-bottom:8px;\">Project notes</div>\r\n          <div>Created from inbox email #13 using signature matching</div>\r\n        </div>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Equipment</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Tasks</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 28px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Files</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>No attached files in project</li></ul>\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</body>\r\n</html>', 'sent', NULL, '2026-04-07 11:14:33'),
(17, 14, 't.bouronikos@gopools.gr', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - FW: πισινα Βριλήσσια', '<!doctype html>\r\n<html>\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Project Assignment</title>\r\n</head>\r\n<body style=\"margin:0;padding:24px;background:#f3f6fb;font-family:Arial,Helvetica,sans-serif;color:#0f172a;line-height:1.6;\">\r\n  <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"max-width:820px;margin:0 auto;background:#ffffff;border:1px solid #e5e7eb;border-radius:18px;overflow:hidden;\">\r\n    <tr>\r\n      <td style=\"padding:24px 28px;background:linear-gradient(135deg,#2563eb,#0f172a);color:#ffffff;\">\r\n        <div style=\"font-size:13px;opacity:.9;letter-spacing:.08em;text-transform:uppercase;\">GoPools CRM</div>\r\n        <h1 style=\"margin:8px 0 0 0;font-size:28px;line-height:1.2;\">Project Assignment</h1>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:24px 28px;\">\r\n        <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse;\">\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Project</td><td style=\"padding:8px 0;\">FW: πισινα Βριλήσσια</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Code</td><td style=\"padding:8px 0;\">PRJ-20260407-111318</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Status</td><td style=\"padding:8px 0;\">approved</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Customer</td><td style=\"padding:8px 0;\">KATRATZIS</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Contact</td><td style=\"padding:8px 0;\">MARIZA KATRATZI</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Phone</td><td style=\"padding:8px 0;\">6987932982</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Email</td><td style=\"padding:8px 0;\">katratzis_n@yahoo.com</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Address</td><td style=\"padding:8px 0;\">ΣΟΦΟΚΛΕΟΥΣ 3Α · ΒΡΙΛΛΗΣΙΑ</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Start date</td><td style=\"padding:8px 0;\">2026-04-08</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Planned end</td><td style=\"padding:8px 0;\">2026-04-08</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Budget</td><td style=\"padding:8px 0;\"></td></tr>\r\n        </table>\r\n        <p style=\"margin:16px 0 0 0\"><a href=\"https://www.google.com/maps/search/?api=1&amp;query=%CE%A3%CE%9F%CE%A6%CE%9F%CE%9A%CE%9B%CE%95%CE%9F%CE%A5%CE%A3%203%CE%91%2C%20%CE%92%CE%A1%CE%99%CE%9B%CE%9B%CE%97%CE%A3%CE%99%CE%91\" style=\"display:inline-block;background:#2563eb;color:#ffffff;text-decoration:none;padding:10px 14px;border-radius:10px;font-weight:700\">Open map</a></p>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"border:1px solid #e5e7eb;border-radius:14px;padding:16px;background:#f8fafc;\">\r\n          <div style=\"font-weight:800;margin-bottom:8px;\">Project notes</div>\r\n          <div>Created from inbox email #13 using signature matching</div>\r\n        </div>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Equipment</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Tasks</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 28px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Files</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>No attached files in project</li></ul>\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</body>\r\n</html>', 'sent', NULL, '2026-04-07 16:35:23'),
(18, 15, 'p.panagiotidis@gopools.gr', 'ΠΑΝΑΓΙΩΤΙΔΗΣ ΠΑΥΛΟΣ', 'Project Assignment - AGIA ANNA', '<!doctype html>\r\n<html>\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<title>Project Assignment</title>\r\n</head>\r\n<body style=\"margin:0;padding:24px;background:#f3f6fb;font-family:Arial,Helvetica,sans-serif;color:#0f172a;line-height:1.6;\">\r\n  <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"max-width:820px;margin:0 auto;background:#ffffff;border:1px solid #e5e7eb;border-radius:18px;overflow:hidden;\">\r\n    <tr>\r\n      <td style=\"padding:24px 28px;background:linear-gradient(135deg,#2563eb,#0f172a);color:#ffffff;\">\r\n        <div style=\"font-size:13px;opacity:.9;letter-spacing:.08em;text-transform:uppercase;\">GoPools CRM</div>\r\n        <h1 style=\"margin:8px 0 0 0;font-size:28px;line-height:1.2;\">Project Assignment</h1>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:24px 28px;\">\r\n        <table role=\"presentation\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" style=\"border-collapse:collapse;\">\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Project</td><td style=\"padding:8px 0;\">AGIA ANNA</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Code</td><td style=\"padding:8px 0;\">PRJ-20260407-164710</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Status</td><td style=\"padding:8px 0;\">new</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Customer</td><td style=\"padding:8px 0;\">GOPOOLS</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Contact</td><td style=\"padding:8px 0;\"></td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Phone</td><td style=\"padding:8px 0;\">1234567890</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Email</td><td style=\"padding:8px 0;\">test@gopools.gr</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Address</td><td style=\"padding:8px 0;\">ΑΓΙΑ ΑΝΝΑ · AGIA ANNA</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Start date</td><td style=\"padding:8px 0;\">2026-04-08</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Planned end</td><td style=\"padding:8px 0;\">2026-04-08</td></tr>\r\n          <tr><td style=\"padding:8px 0;width:180px;color:#475569;font-weight:700;\">Budget</td><td style=\"padding:8px 0;\"></td></tr>\r\n        </table>\r\n        <p style=\"margin:16px 0 0 0\"><a href=\"https://www.google.com/maps?q=38.8598730%2C23.4440340\" style=\"display:inline-block;background:#2563eb;color:#ffffff;text-decoration:none;padding:10px 14px;border-radius:10px;font-weight:700\">Open map</a></p>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"border:1px solid #e5e7eb;border-radius:14px;padding:16px;background:#f8fafc;\">\r\n          <div style=\"font-weight:800;margin-bottom:8px;\">Project notes</div>\r\n          <div>ΕΧΕΙ ΡΑΦΕΣ ΠΟΥ ΘΕΛΟΥΝ ΚΟΛΛΗΜΑ. ΕΙΝΑΙ ΣΤΗΝ ΕΓΓΥΗΣΗ</div>\r\n        </div>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Equipment</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 24px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Tasks</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>None</li></ul>\r\n      </td>\r\n    </tr>\r\n    <tr>\r\n      <td style=\"padding:0 28px 28px 28px;\">\r\n        <div style=\"font-weight:800;margin-bottom:8px;\">Files</div>\r\n        <ul style=\"margin:0;padding-left:20px;\"><li>No attached files in project</li></ul>\r\n      </td>\r\n    </tr>\r\n  </table>\r\n</body>\r\n</html>', 'sent', NULL, '2026-04-07 16:50:44'),
(19, 34, 't.bouronikos@gopools.gr', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Project Assignment - TOREN LARS - ΠΟΡΟΣ', 'Project Assignment\r\n----------------------------------------\r\nProject: TOREN LARS - ΠΟΡΟΣ\r\nCode: PRJ-20260410-100432\r\nStatus: new\r\nCustomer: IDEALES\r\nContact: \r\nPhone: \r\nAddress:  - πορος\r\nStart date: 2026-04-15\r\nPlanned end: 2026-04-17\r\nBudget: \r\n\r\nGoogle Maps: https://www.google.com/maps/search/?api=1&query=%CF%80%CE%BF%CF%81%CE%BF%CF%82\r\n\r\nΘα σε ενημερωσω μολις εχω περισσοτερες πληροφορίες \r\n\r\n[ Equipment ]\r\n- None\r\n\r\n[ Tasks ]\r\n- None\r\n\r\n[ Files ]\r\n- No attached files', 'sent', NULL, '2026-04-10 14:44:44'),
(20, 38, 't.bouronikos@gopools.gr', 'ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ ΜΠΟΥΡΟΝΙΚΟΣ ΘΩΜΑΣ', 'Ανάθεση Έργου - ΚΕΦΑΛΛΟΝΙΑ ΒΑΓΓΕΛΗΣ', 'Project Assignment\r\n----------------------------------------\r\nProject: ΚΕΦΑΛΛΟΝΙΑ ΒΑΓΓΕΛΗΣ\r\nCode: PRJ-20260416-093313\r\nStatus: approved\r\nCustomer: OREON POOLS\r\nContact: \r\nPhone: \r\nAddress: \r\nStart date: \r\nPlanned end: \r\nBudget: \r\n\r\nGoogle Maps: https://www.google.com/maps?q=38.4371390%2C20.5571980\r\n\r\n[ Equipment ]\r\n- None\r\n\r\n[ Tasks ]\r\n- ΑΝΤΙΚΑΤΑΣΤΑΣΗ ΜΕΜΒΡΑΝΗΣ | status: todo | due: 2026-04-17\r\n\r\n[ Files ]\r\n- No attached files', 'sent', NULL, '2026-04-16 09:37:17');

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

--
-- Table structure for table `project_equipment`
--

CREATE TABLE `project_equipment` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `item_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int(10) UNSIGNED NOT NULL DEFAULT '1',
  `unit_cost` decimal(12,2) DEFAULT NULL,
  `line_total` decimal(12,2) DEFAULT NULL,
  `sale_price` decimal(12,2) DEFAULT NULL,
  `moved_by_employee_id` int(10) UNSIGNED DEFAULT NULL,
  `moved_date` date DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_equipment`
--

INSERT INTO `project_equipment` (`id`, `project_id`, `item_name`, `category`, `serial_number`, `quantity`, `unit_cost`, `line_total`, `sale_price`, `moved_by_employee_id`, `moved_date`, `notes`, `created_at`, `updated_at`) VALUES
(1, 5, 'HEAT PUMP', 'ΑΝΤΛΙΑ ΘΕΡΜΟΤΗΤΑΣ', NULL, 1, 800.00, 800.00, 1700.00, NULL, NULL, NULL, '2026-03-30 18:14:43', '2026-04-17 11:49:27'),
(2, 5, 'INSTALATION', 'SETUP', NULL, 1, 0.00, 0.00, 300.00, NULL, NULL, NULL, '2026-03-30 18:15:07', '2026-04-17 11:49:45'),
(3, 37, 'HEAT PUMP IPHCR20', 'ΑΝΤΛΙΑ ΘΕΡΜΟΤΗΤΑΣ', NULL, 1, NULL, 0.00, 1500.00, NULL, NULL, NULL, '2026-04-16 09:12:22', '2026-04-16 09:12:22'),
(5, 40, 'ASTRAL ΦΩΤΙΣΤΙΚΑ', 'ΦΩΤΑ', NULL, 2, NULL, 0.00, NULL, NULL, NULL, '2 ΕΞΤΡΑ ΦΩΤΙΣΤΙΚΑ 800€', '2026-04-17 09:16:14', '2026-04-17 09:16:14');

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

--
-- Table structure for table `project_expenses`
--

CREATE TABLE `project_expenses` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `expense_category` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(12,2) NOT NULL,
  `expense_date` date NOT NULL,
  `vehicle_id` int(10) UNSIGNED DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `project_files`
--

CREATE TABLE `project_files` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `uploaded_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_files`
--

INSERT INTO `project_files` (`id`, `project_id`, `file_name`, `file_path`, `file_type`, `notes`, `uploaded_at`) VALUES
(1, 1, '__UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86RLg_______UTF-8_B_MDJfzprOrM_Ezr_PiM63IM6Zz4POv86zzrXOr86_z4VfMjAyNTEyMDIucGRm__', '/gopools/public/uploads/inbox/inbox_2_1774647017_2___UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86RLg_______UTF-8_B_MDJfzprOrM_Ezr_PiM63IM6Zz4POv86zzrXOr86_z4VfMjAyNTEyMDIucGRm__', NULL, 'Copied from inbox email #2', '2026-03-28 08:07:59'),
(2, 1, '__UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86X_____UTF-8_B_zpxfzprOlC4wMV_Oms6xz4TPjM_IzrXOuc_CXzIwMjUxMjAyLnBkZg____', '/gopools/public/uploads/inbox/inbox_2_1774647021_3___UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86X_____UTF-8_B_zpxfzprOlC4wMV_Oms6xz4TPjM_IzrXOuc_CXzIwMjUxMjAyLnBkZg____', NULL, 'Copied from inbox email #2', '2026-03-28 08:07:59'),
(3, 1, '__UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg______UTF-8_B_NF_Ol86cX86azpRfzqTOtc_Nz4fOv8_CXzIwMjUxMjAyLnBkZg____', '/gopools/public/uploads/inbox/inbox_2_1774647023_4___UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg______UTF-8_B_NF_Ol86cX86azpRfzqTOtc_Nz4fOv8_CXzIwMjUxMjAyLnBkZg____', NULL, 'Copied from inbox email #2', '2026-03-28 08:07:59'),
(4, 1, '__UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86RLg_______UTF-8_B_MDFfzprOrM_Ezr_PiM63IM_Fz4DOv86zzrXOr86_z4VfMjAyNTEyMDIucGRm__', '/gopools/public/uploads/inbox/inbox_2_1774647025_5___UTF-8_B_MjI5MTRfRklMQUdQQVJfzp_OkV8xNjk2MDg0X86RLg_______UTF-8_B_MDFfzprOrM_Ezr_PiM63IM_Fz4DOv86zzrXOr86_z4VfMjAyNTEyMDIucGRm__', NULL, 'Copied from inbox email #2', '2026-03-28 08:07:59'),
(5, 7, 'image001.png', '/gopools/public/uploads/inbox/2026/04/1775117044_7186_image001.png', 'application/png', 'Copied from inbox email #4', '2026-04-02 21:49:48'),
(6, 7, '____01.pdf', '/gopools/public/uploads/inbox/2026/04/1775117044_6808_____01.pdf', 'application/pdf', 'Copied from inbox email #4', '2026-04-02 21:49:48'),
(7, 7, '_________________________________________________OKT_25_.pdf', '/gopools/public/uploads/inbox/2026/04/1775117044_5988__________________________________________________OKT_25_.pdf', 'application/pdf', 'Copied from inbox email #4', '2026-04-02 21:49:48'),
(8, 7, '______________________________________OKT_25.pdf', '/gopools/public/uploads/inbox/2026/04/1775117044_9460_______________________________________OKT_25.pdf', 'application/pdf', 'Copied from inbox email #4', '2026-04-02 21:49:48'),
(9, 8, 'image001.png', '/gopools/public/uploads/inbox/2026/04/1775163842_6640_image001.png', 'application/png', 'Copied from inbox email #11', '2026-04-03 00:04:34'),
(10, 8, 'image003.jpg', '/gopools/public/uploads/inbox/2026/04/1775163842_7886_image003.jpg', 'application/jpeg', 'Copied from inbox email #11', '2026-04-03 00:04:34'),
(11, 8, 'image004.jpg', '/gopools/public/uploads/inbox/2026/04/1775163842_1271_image004.jpg', 'application/jpeg', 'Copied from inbox email #11', '2026-04-03 00:04:34'),
(12, 8, 'image002.png', '/gopools/public/uploads/inbox/2026/04/1775163842_6034_image002.png', 'application/png', 'Copied from inbox email #11', '2026-04-03 00:04:34'),
(13, 8, 'image005.jpg', '/gopools/public/uploads/inbox/2026/04/1775163842_1651_image005.jpg', 'application/jpeg', 'Copied from inbox email #11', '2026-04-03 00:04:34'),
(14, 46, 'image002.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_1983_image002.jpg', 'application/jpeg', 'Copied from inbox email #14', '2026-04-29 18:56:07'),
(15, 46, 'foto_pisina_tzia_1.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_3104_foto_pisina_tzia_1.jpg', 'application/jpeg', 'Copied from inbox email #14', '2026-04-29 18:56:07'),
(16, 46, 'foto_pisina_tzia_2.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_4616_foto_pisina_tzia_2.jpg', 'application/jpeg', 'Copied from inbox email #14', '2026-04-29 18:56:07'),
(17, 46, 'foto_pisina_tzia_3.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_6714_foto_pisina_tzia_3.jpg', 'application/jpeg', 'Copied from inbox email #14', '2026-04-29 18:56:07'),
(18, 46, 'foto_pisina_tzia_4.jpg', '/gopools/public/uploads/inbox/2026/04/1777478134_3994_foto_pisina_tzia_4.jpg', 'application/jpeg', 'Copied from inbox email #14', '2026-04-29 18:56:07');

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

--
-- Table structure for table `project_missing_parts`
--

CREATE TABLE `project_missing_parts` (
  `id` int(11) NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `assignment_id` int(10) UNSIGNED DEFAULT NULL,
  `requested_by_user_id` int(10) UNSIGNED NOT NULL,
  `requested_by_type` enum('employee','partner') COLLATE utf8mb4_unicode_ci NOT NULL,
  `part_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `photo_filename` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','sent') COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `tracking_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `manager_user_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `project_partners`
--

CREATE TABLE `project_partners` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `external_partner_id` int(10) UNSIGNED NOT NULL,
  `work_date` date DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agreed_cost` decimal(12,2) DEFAULT NULL,
  `paid_amount` decimal(12,2) DEFAULT NULL,
  `status` enum('planned','working','done','paid','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'planned',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_partners`
--

INSERT INTO `project_partners` (`id`, `project_id`, `external_partner_id`, `work_date`, `description`, `agreed_cost`, `paid_amount`, `status`, `notes`, `created_at`, `updated_at`) VALUES
(1, 4, 2, '2026-03-31', NULL, NULL, NULL, 'planned', NULL, '2026-03-31 21:24:04', '2026-03-31 21:24:04'),
(3, 6, 1, '2026-04-01', NULL, NULL, NULL, 'planned', NULL, '2026-04-01 20:12:50', '2026-04-01 20:12:50'),
(4, 8, 1, '2026-04-06', 'SEAMLESS LINER', NULL, NULL, 'planned', NULL, '2026-04-03 00:07:07', '2026-04-03 00:07:07'),
(5, 4, 2, '2026-04-08', NULL, 2020.00, 2020.00, 'planned', NULL, '2026-04-08 22:18:34', '2026-04-08 22:18:34');

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

--
-- Table structure for table `project_payments`
--

CREATE TABLE `project_payments` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `payment_type` enum('deposit','payment','refund','other') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'payment',
  `amount` decimal(12,2) NOT NULL,
  `payment_date` date NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_payments`
--

INSERT INTO `project_payments` (`id`, `project_id`, `payment_type`, `amount`, `payment_date`, `notes`, `created_at`, `updated_at`) VALUES
(1, 5, 'payment', 2000.00, '2026-03-29', NULL, '2026-03-29 23:53:40', '2026-03-29 23:53:40'),
(2, 6, 'payment', 900.00, '2026-03-23', NULL, '2026-04-01 17:37:18', '2026-04-01 17:37:18'),
(3, 9, 'payment', 10000.00, '2026-04-07', 'Προκαταβολη', '2026-04-07 08:48:53', '2026-04-07 08:48:53'),
(4, 9, 'payment', 5000.00, '2026-04-08', NULL, '2026-04-08 14:20:41', '2026-04-08 14:20:41'),
(5, 37, 'deposit', 5000.00, '2025-11-14', NULL, '2026-04-16 09:11:32', '2026-04-16 09:11:32'),
(6, 40, 'deposit', 6200.00, '2026-04-29', NULL, '2026-04-29 23:49:56', '2026-04-29 23:49:56'),
(7, 40, 'payment', 8100.00, '2026-04-29', NULL, '2026-04-29 23:50:04', '2026-04-29 23:50:04'),
(8, 17, 'payment', 7080.00, '2026-04-29', NULL, '2026-04-29 23:50:29', '2026-04-29 23:50:29'),
(9, 6, 'payment', 2250.00, '2026-04-29', NULL, '2026-04-29 23:50:49', '2026-04-29 23:50:49'),
(10, 42, 'deposit', 3000.00, '2026-05-01', NULL, '2026-05-01 12:45:42', '2026-05-01 12:45:42'),
(11, 54, 'deposit', 5000.00, '2025-10-14', 'Προκαταβολη', '2026-05-07 17:10:32', '2026-05-07 17:10:32'),
(12, 54, 'payment', 8000.00, '2026-05-07', NULL, '2026-05-07 17:10:44', '2026-05-07 17:10:44');

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

--
-- Table structure for table `project_photos`
--

CREATE TABLE `project_photos` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `assignment_id` int(10) UNSIGNED DEFAULT NULL,
  `uploaded_by_user_id` int(10) UNSIGNED NOT NULL,
  `uploaded_by_type` enum('employee','partner','customer') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'employee',
  `category` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'other',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_size` int(10) UNSIGNED DEFAULT NULL,
  `mime_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `shared_with_crew` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_photos`
--

INSERT INTO `project_photos` (`id`, `project_id`, `assignment_id`, `uploaded_by_user_id`, `uploaded_by_type`, `category`, `title`, `filename`, `original_name`, `file_size`, `mime_type`, `created_at`, `shared_with_crew`) VALUES
(1, 38, 19, 3, 'partner', 'pool', NULL, 'proj_38_69e36a7b976a1.jpg', '1000017406.jpg', 2983696, 'image/jpeg', '2026-04-18 14:26:51', 0),
(2, 38, 19, 3, 'partner', 'pool', NULL, 'proj_38_69e36aa71bbcc.jpg', '1000017403.jpg', 3503051, 'image/jpeg', '2026-04-18 14:27:35', 0),
(3, 38, 19, 3, 'partner', 'pool', NULL, 'proj_38_69e36ab9aba1c.jpg', '1000017402.jpg', 2040198, 'image/jpeg', '2026-04-18 14:27:53', 0),
(4, 38, 19, 3, 'partner', 'pool', NULL, 'proj_38_69e36acecf708.jpg', '1000017400.jpg', 3148621, 'image/jpeg', '2026-04-18 14:28:14', 0),
(5, 38, 19, 3, 'partner', 'pool', NULL, 'proj_38_69e36adc11aaf.jpg', '1000017399.jpg', 3378484, 'image/jpeg', '2026-04-18 14:28:28', 0);

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

--
-- Table structure for table `project_sold_equipment`
--

CREATE TABLE `project_sold_equipment` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `customer_id` int(10) UNSIGNED NOT NULL,
  `item_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `serial_number` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `warranty_start` date DEFAULT NULL,
  `warranty_end` date DEFAULT NULL,
  `supplier_name` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_sold_equipment`
--

INSERT INTO `project_sold_equipment` (`id`, `project_id`, `customer_id`, `item_name`, `brand`, `model`, `serial_number`, `purchase_date`, `warranty_start`, `warranty_end`, `supplier_name`, `notes`, `created_at`, `updated_at`) VALUES
(1, 5, 14, 'HEAT PUMP', 'poolstar', 'Silverline Top 120', NULL, '2026-03-30', '2028-03-30', NULL, NULL, NULL, '2026-03-30 16:44:18', '2026-03-30 16:44:18'),
(2, 37, 13, 'HEAT PUMP', 'FAIRLAND', 'IPHCR20', NULL, '2025-11-10', '2025-11-14', '2027-11-14', 'VAGNER POOL', NULL, '2026-04-16 09:13:34', '2026-04-16 09:13:34'),
(3, 40, 13, 'GOPOOLS WARANTY LINER', NULL, NULL, NULL, '2026-04-23', '2026-04-23', '2036-04-23', NULL, NULL, '2026-04-29 21:15:12', '2026-04-29 21:15:12');

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

--
-- Table structure for table `project_statuses`
--

CREATE TABLE `project_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `status_key` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label_el` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label_en` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT '100',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_statuses`
--

INSERT INTO `project_statuses` (`id`, `status_key`, `label_el`, `label_en`, `sort_order`, `is_active`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'new', 'Νέο', 'New', 10, 1, 1, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(2, 'quotation', 'Προσφορά', 'Quotation', 20, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(3, 'approved', 'Εγκεκριμένο', 'Approved', 30, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(4, 'waiting_deposit', 'Αναμονή προκαταβολής', 'Waiting deposit', 40, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(5, 'waiting_materials', 'Αναμονή υλικών', 'Waiting materials', 50, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(6, 'scheduled', 'Σε προγραμματισμό', 'Scheduled', 60, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(7, 'in_progress', 'Σε εξέλιξη', 'In progress', 70, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(8, 'on_hold', 'Σε αναμονή', 'On hold', 80, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(9, 'pending_close', 'Προς ολοκλήρωση', 'Pending close', 90, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(10, 'completed', 'Ολοκληρωμένο', 'Completed', 100, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06'),
(11, 'cancelled', 'Ακυρωμένο', 'Cancelled', 110, 1, 0, '2026-04-01 17:09:06', '2026-04-01 17:09:06');

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

--
-- Table structure for table `project_tasks`
--

CREATE TABLE `project_tasks` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assigned_employee_id` int(10) UNSIGNED DEFAULT NULL,
  `status` enum('todo','doing','done','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'todo',
  `due_date` date DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_tasks`
--

INSERT INTO `project_tasks` (`id`, `project_id`, `title`, `assigned_employee_id`, `status`, `due_date`, `notes`, `created_at`, `updated_at`) VALUES
(1, 9, 'MPETA', 4, 'done', '2026-04-03', NULL, '2026-04-03 08:05:32', '2026-04-06 21:27:44'),
(2, 9, 'τοποθετηση μηχανοστασιου', 2, 'done', '2026-04-07', NULL, '2026-04-06 21:28:04', '2026-04-30 00:01:34'),
(3, 38, 'ΑΝΤΙΚΑΤΑΣΤΑΣΗ ΜΕΜΒΡΑΝΗΣ', NULL, 'done', '2026-04-17', NULL, '2026-04-16 09:36:59', '2026-04-18 12:55:24'),
(4, 5, 'ΜΗΧΑΝΟΣΤΑΣΙΟ', NULL, 'done', '2026-04-17', NULL, '2026-04-16 16:01:09', '2026-04-18 12:55:11'),
(5, 48, 'ΜΗΧΑΝΟΣΤΑΣΙΟ', NULL, 'done', '2026-05-02', 'ΤΑΡΑΤΣΑ ΜΟΝΟ ΓΙΑ ΤΩΡΑ', '2026-04-30 00:06:31', '2026-05-04 14:06:46');

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

--
-- Table structure for table `project_visits`
--

CREATE TABLE `project_visits` (
  `id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `project_visits`
--

INSERT INTO `project_visits` (`id`, `project_id`, `title`, `start_date`, `end_date`, `created_at`) VALUES
(1, 5, 'ΜΗΧΑΝΟΣΤΑΣΙΟ', '2026-04-17', '2026-04-17', '2026-04-16 15:05:07'),
(3, 54, 'Τοποθετηση μηχανοστασιο', '2026-05-07', '2026-05-07', '2026-05-07 10:40:52');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `setting_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `setting_value` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `setting_key`, `setting_value`, `created_at`, `updated_at`) VALUES
(1, 'app_name', 'GoPools CRM', '2026-03-27 20:48:32', '2026-03-27 20:48:32'),
(2, 'timezone', 'Europe/Athens', '2026-03-27 20:48:32', '2026-03-27 20:48:32'),
(3, 'inbox_email', 'projects@gopools.gr', '2026-03-27 20:48:32', '2026-03-27 20:48:32'),
(4, 'dashboard_vehicle_due_days', '30', '2026-03-27 20:51:32', '2026-03-27 20:51:32'),
(5, 'dashboard_task_due_days', '14', '2026-03-27 20:51:32', '2026-03-27 20:51:32'),
(6, 'imap_host', 'mail.gopools.gr', '2026-03-27 20:51:41', '2026-03-27 22:51:44'),
(7, 'imap_port', '993', '2026-03-27 20:51:41', '2026-03-27 20:51:41'),
(8, 'imap_encryption', 'ssl', '2026-03-27 20:51:41', '2026-03-27 20:51:41'),
(9, 'imap_username', 'projects@gopools.gr', '2026-03-27 20:51:41', '2026-03-27 20:51:41'),
(10, 'imap_password', '6v*}yA_BUs8U', '2026-03-27 20:51:41', '2026-03-28 14:45:07'),
(11, 'imap_mailbox', 'INBOX', '2026-03-27 20:51:41', '2026-03-27 20:51:41'),
(12, 'imap_fetch_limit', '20', '2026-03-27 20:51:41', '2026-03-27 20:51:41'),
(13, 'calendar_default_view', 'dayGridMonth', '2026-03-27 22:42:01', '2026-03-27 22:42:01'),
(14, 'email_to_project_enabled', '1', '2026-03-27 22:42:01', '2026-03-27 22:42:01'),
(15, 'email_auto_create_project', '0', '2026-03-27 22:42:01', '2026-03-27 22:42:01'),
(16, 'email_default_project_status', 'planned', '2026-03-27 22:42:01', '2026-03-27 22:42:01'),
(17, 'email_default_category_name', 'New pool', '2026-03-27 22:42:01', '2026-03-27 22:42:01'),
(29, 'smtp_enabled', '1', '2026-03-28 14:17:49', '2026-03-28 14:19:36'),
(30, 'smtp_host', 'mail.gopools.gr', '2026-03-28 14:17:49', '2026-03-28 14:20:06'),
(31, 'smtp_port', '465', '2026-03-28 14:17:49', '2026-03-28 14:50:27'),
(32, 'smtp_secure', 'ssl', '2026-03-28 14:17:49', '2026-03-28 14:50:27'),
(33, 'smtp_username', 'projects@gopools.gr', '2026-03-28 14:17:49', '2026-03-28 14:19:24'),
(34, 'smtp_password', '6v*}yA_BUs8U', '2026-03-28 14:17:49', '2026-03-28 14:45:15'),
(35, 'smtp_from_email', 'projects@gopools.gr', '2026-03-28 14:17:49', '2026-03-28 14:17:49'),
(36, 'smtp_from_name', 'GoPools CRM', '2026-03-28 14:17:49', '2026-03-28 14:17:49'),
(37, 'smtp_reply_to', '', '2026-03-28 14:17:49', '2026-03-28 14:17:49'),
(38, 'smtp_test_email', 'I.orfanidis@gopools.gr', '2026-03-28 14:17:49', '2026-03-28 14:19:24'),
(232, 'brand_app_name', 'CRM', '2026-03-30 14:13:40', '2026-04-05 00:22:14'),
(233, 'brand_logo', '/gopools/public/uploads/logo.png', '2026-03-30 14:13:40', '2026-03-31 18:00:12'),
(234, 'brand_favicon', '', '2026-03-30 14:13:40', '2026-03-30 14:13:40'),
(235, 'theme_mode', 'light', '2026-03-30 14:13:40', '2026-03-30 14:13:40'),
(236, 'theme_primary', '#0051ff', '2026-03-30 14:13:40', '2026-03-31 21:35:07'),
(237, 'theme_secondary', '#7e879a', '2026-03-30 14:13:40', '2026-03-31 21:35:19'),
(238, 'theme_glass', '1', '2026-03-30 14:13:40', '2026-03-30 14:13:40'),
(239, 'background_type', 'gradient', '2026-03-30 14:13:40', '2026-03-30 14:13:40'),
(240, 'background_color', '', '2026-03-30 14:13:40', '2026-04-05 00:20:01'),
(241, 'background_image', '', '2026-03-30 14:13:40', '2026-03-30 14:13:40'),
(242, 'background_gradient', 'linear-gradient(135deg,#f8fafc 0%,#e2e8f0 100%)', '2026-03-30 14:13:40', '2026-03-30 14:13:40'),
(243, 'background_overlay_opacity', '0.10', '2026-03-30 14:13:40', '2026-03-30 14:13:40'),
(244, 'warranty_reminder_days', '30', '2026-03-30 14:21:48', '2026-03-30 14:21:48'),
(245, 'branding_upload_dir', '/gopools/public/uploads/branding', '2026-03-30 14:21:48', '2026-03-30 14:21:48'),
(307, 'app_language', 'el', '2026-03-31 21:46:11', '2026-03-31 21:46:11'),
(308, 'invite_email_from_name', 'GoPools CRM', '2026-03-31 21:46:11', '2026-03-31 21:46:11'),
(309, 'invite_email_subject_el', 'Πρόσκληση πρόσβασης στο GoPools CRM', '2026-03-31 21:46:11', '2026-03-31 21:46:11'),
(310, 'invite_email_subject_en', 'Invitation to access GoPools CRM', '2026-03-31 21:46:11', '2026-03-31 21:46:11'),
(311, 'last_alert_check_time', '2026-05-07 13:34:29', '2026-04-02 23:15:03', '2026-05-07 13:34:29'),
(327, 'brand_logo_height', '40', '2026-04-05 00:20:01', '2026-04-05 00:22:28'),
(333, 'ui_border_radius', '10', '2026-04-05 00:20:01', '2026-04-05 00:20:01'),
(334, 'sidebar_width', '260', '2026-04-05 00:20:01', '2026-04-05 00:20:01'),
(335, 'font_family', 'Montserrat', '2026-04-05 00:20:01', '2026-04-05 00:20:36'),
(431, 'weather_api_key', '88ac1c36f70798bfdba9c7d6b1f317fe', '2026-04-16 13:29:18', '2026-04-16 15:46:56');

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

--
-- Table structure for table `system_logs`
--

CREATE TABLE `system_logs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `action_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entity_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entity_id` int(11) DEFAULT '0',
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



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

--
-- Table structure for table `user_invites`
--

CREATE TABLE `user_invites` (
  `id` int(10) UNSIGNED NOT NULL,
  `email` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `employee_id` int(10) UNSIGNED DEFAULT NULL,
  `external_partner_id` int(10) UNSIGNED DEFAULT NULL,
  `customer_id` int(10) UNSIGNED DEFAULT NULL,
  `invite_token` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invited_by_user_id` int(10) UNSIGNED DEFAULT NULL,
  `is_used` tinyint(1) NOT NULL DEFAULT '0',
  `expires_at` datetime NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_notifications`
--

CREATE TABLE `user_notifications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_read` tinyint(1) DEFAULT '0',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vehicles`
--

CREATE TABLE `vehicles` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `license_plate` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `brand` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vehicle_type` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year` int(11) DEFAULT NULL,
  `color` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fuel_type` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vin` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `odometer_km` int(11) DEFAULT NULL,
  `next_service_km` int(11) DEFAULT NULL,
  `last_service_date` date DEFAULT NULL,
  `next_service_date` date DEFAULT NULL,
  `insurance_expiry` date DEFAULT NULL,
  `kteo_expiry` date DEFAULT NULL,
  `road_tax_expiry` date DEFAULT NULL,
  `assigned_employee_id` int(10) UNSIGNED DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vehicles`
--

INSERT INTO `vehicles` (`id`, `code`, `license_plate`, `brand`, `model`, `vehicle_type`, `year`, `color`, `fuel_type`, `vin`, `odometer_km`, `next_service_km`, `last_service_date`, `next_service_date`, `insurance_expiry`, `kteo_expiry`, `road_tax_expiry`, `assigned_employee_id`, `active`, `notes`, `created_at`, `updated_at`) VALUES
(1, 'VEH-20260328-094042', 'BKZ-6357', 'OPEL', 'VIVARO', 'Van', NULL, 'Λευκο', 'Πετρέλαιο', NULL, NULL, NULL, NULL, NULL, '2027-03-30', '2028-02-20', '2026-12-20', NULL, 1, NULL, '2026-03-28 09:40:42', '2026-04-16 09:53:49');

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

--
-- Table structure for table `vehicle_services`
--

CREATE TABLE `vehicle_services` (
  `id` int(10) UNSIGNED NOT NULL,
  `vehicle_id` int(10) UNSIGNED NOT NULL,
  `service_date` date NOT NULL,
  `service_type` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `odometer_km` int(11) DEFAULT NULL,
  `cost` decimal(12,2) DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `next_service_km` int(11) DEFAULT NULL,
  `next_service_date` date DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `work_sessions`
--

CREATE TABLE `work_sessions` (
  `id` int(10) UNSIGNED NOT NULL,
  `employee_id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED DEFAULT NULL,
  `work_date` date DEFAULT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `hourly_rate` decimal(10,2) NOT NULL DEFAULT '0.00',
  `work_type` enum('local','outstation') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local',
  `duration_minutes` int(11) DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `paused_at` datetime DEFAULT NULL,
  `pause_minutes_total` int(11) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `work_sessions`
--

INSERT INTO `work_sessions` (`id`, `employee_id`, `project_id`, `work_date`, `start_time`, `end_time`, `hourly_rate`, `work_type`, `duration_minutes`, `notes`, `paused_at`, `pause_minutes_total`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2026-04-02', '2026-04-02 08:22:12', '2026-04-02 08:26:19', 10.00, 'local', NULL, NULL, NULL, 0, '2026-04-02 08:22:12', '2026-04-02 08:26:19'),
(2, 1, 1, '2026-04-02', '2026-04-02 08:26:24', '2026-04-02 08:26:28', 10.00, 'local', NULL, NULL, NULL, 0, '2026-04-02 08:26:24', '2026-04-02 08:26:28'),
(3, 1, 1, '2026-04-02', '2026-04-02 11:17:42', '2026-04-02 11:18:49', 10.00, 'local', NULL, NULL, NULL, 0, '2026-04-02 11:17:42', '2026-04-02 11:18:49'),
(4, 1, 1, '2026-04-04', '2026-04-04 23:56:12', '2026-04-04 23:56:37', 10.00, 'local', NULL, NULL, NULL, 0, '2026-04-04 23:56:12', '2026-04-04 23:56:37'),
(5, 1, 1, '2026-04-06', '2026-04-06 20:05:29', '2026-04-06 20:06:15', 10.00, 'local', NULL, NULL, NULL, 0, '2026-04-06 20:05:29', '2026-04-06 20:06:15'),
(6, 1, 28, '2026-05-06', '2026-05-06 08:41:22', '2026-05-06 08:41:33', 10.00, 'local', NULL, NULL, NULL, 0, '2026-05-06 08:41:22', '2026-05-06 08:41:33');

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

--
-- Table structure for table `work_session_notes`
--

CREATE TABLE `work_session_notes` (
  `id` int(10) UNSIGNED NOT NULL,
  `work_session_id` int(10) UNSIGNED NOT NULL,
  `note_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `work_session_photos`
--

CREATE TABLE `work_session_photos` (
  `id` int(10) UNSIGNED NOT NULL,
  `work_session_id` int(10) UNSIGNED NOT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` int(10) UNSIGNED DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_customers_code` (`code`);

--
-- Indexes for table `employees`
--
ALTER TABLE `employees`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_employees_code` (`code`),
  ADD UNIQUE KEY `uq_employees_email` (`email`);

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

--
-- Indexes for table `employee_project_expenses`
--
ALTER TABLE `employee_project_expenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_employee_project_expenses_employee` (`employee_id`),
  ADD KEY `idx_employee_project_expenses_project` (`project_id`),
  ADD KEY `idx_employee_project_expenses_date` (`expense_date`);

--
-- Indexes for table `external_partners`
--
ALTER TABLE `external_partners`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_external_partners_code` (`code`);

--
-- Indexes for table `inbox_attachments`
--
ALTER TABLE `inbox_attachments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_inbox_attachments_email` (`inbox_email_id`);

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

--
-- Indexes for table `partner_project_costings`
--
ALTER TABLE `partner_project_costings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_partner_project_costings` (`project_id`,`external_partner_id`),
  ADD KEY `idx_partner_project_costings_project` (`project_id`),
  ADD KEY `idx_partner_project_costings_partner` (`external_partner_id`),
  ADD KEY `idx_partner_project_costings_status` (`status`);

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_projects_code` (`code`),
  ADD KEY `idx_projects_customer` (`customer_id`),
  ADD KEY `idx_projects_category` (`category_id`);

--
-- Indexes for table `project_assignments`
--
ALTER TABLE `project_assignments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_assignments_project` (`project_id`),
  ADD KEY `idx_project_assignments_employee` (`employee_id`),
  ADD KEY `idx_project_assignments_partner` (`external_partner_id`);

--
-- Indexes for table `project_categories`
--
ALTER TABLE `project_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_project_categories_name` (`name`);

--
-- Indexes for table `project_comments`
--
ALTER TABLE `project_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_comments` (`project_id`,`created_at`);

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

--
-- Indexes for table `project_edit_permissions`
--
ALTER TABLE `project_edit_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_project_edit_permissions` (`user_id`,`project_id`),
  ADD KEY `idx_project_edit_permissions_user` (`user_id`),
  ADD KEY `idx_project_edit_permissions_project` (`project_id`);

--
-- Indexes for table `project_email_log`
--
ALTER TABLE `project_email_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_email_log_project` (`project_id`);

--
-- Indexes for table `project_equipment`
--
ALTER TABLE `project_equipment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_equipment_project` (`project_id`);

--
-- Indexes for table `project_expenses`
--
ALTER TABLE `project_expenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_expenses_project` (`project_id`);

--
-- Indexes for table `project_files`
--
ALTER TABLE `project_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_files_project` (`project_id`);

--
-- Indexes for table `project_missing_parts`
--
ALTER TABLE `project_missing_parts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_id` (`project_id`);

--
-- Indexes for table `project_partners`
--
ALTER TABLE `project_partners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_partners_project` (`project_id`),
  ADD KEY `idx_project_partners_partner` (`external_partner_id`);

--
-- Indexes for table `project_payments`
--
ALTER TABLE `project_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_payments_project` (`project_id`);

--
-- Indexes for table `project_photos`
--
ALTER TABLE `project_photos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project` (`project_id`),
  ADD KEY `idx_uploader` (`uploaded_by_user_id`);

--
-- Indexes for table `project_sold_equipment`
--
ALTER TABLE `project_sold_equipment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_sold_equipment_project` (`project_id`),
  ADD KEY `idx_project_sold_equipment_customer` (`customer_id`);

--
-- Indexes for table `project_statuses`
--
ALTER TABLE `project_statuses`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_project_statuses_key` (`status_key`),
  ADD KEY `idx_project_statuses_sort` (`sort_order`),
  ADD KEY `idx_project_statuses_active` (`is_active`);

--
-- Indexes for table `project_tasks`
--
ALTER TABLE `project_tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_project_tasks_project` (`project_id`);

--
-- Indexes for table `project_visits`
--
ALTER TABLE `project_visits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_id` (`project_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_settings_key` (`setting_key`);

--
-- Indexes for table `system_logs`
--
ALTER TABLE `system_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_action` (`user_id`,`action_type`),
  ADD KEY `idx_entity` (`entity_type`,`entity_id`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `user_invites`
--
ALTER TABLE `user_invites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_user_invites_token` (`invite_token`),
  ADD KEY `idx_user_invites_email` (`email`),
  ADD KEY `idx_user_invites_used` (`is_used`);

--
-- Indexes for table `user_notifications`
--
ALTER TABLE `user_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_read` (`user_id`,`is_read`);

--
-- Indexes for table `vehicles`
--
ALTER TABLE `vehicles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_vehicles_code` (`code`),
  ADD UNIQUE KEY `uq_vehicles_license_plate` (`license_plate`);

--
-- Indexes for table `vehicle_services`
--
ALTER TABLE `vehicle_services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_vehicle_services_vehicle` (`vehicle_id`);

--
-- Indexes for table `work_sessions`
--
ALTER TABLE `work_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_work_sessions_employee` (`employee_id`),
  ADD KEY `idx_work_sessions_project` (`project_id`);

--
-- Indexes for table `work_session_notes`
--
ALTER TABLE `work_session_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_work_session_notes_session` (`work_session_id`);

--
-- Indexes for table `work_session_photos`
--
ALTER TABLE `work_session_photos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_work_session_photos_session` (`work_session_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `employees`
--
ALTER TABLE `employees`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

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

--
-- AUTO_INCREMENT for table `external_partners`
--
ALTER TABLE `external_partners`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `inbox_attachments`
--
ALTER TABLE `inbox_attachments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `inbox_emails`
--
ALTER TABLE `inbox_emails`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `partner_project_costings`
--
ALTER TABLE `partner_project_costings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `project_assignments`
--
ALTER TABLE `project_assignments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `project_categories`
--
ALTER TABLE `project_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `project_duration_suggestions`
--
ALTER TABLE `project_duration_suggestions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `project_edit_permissions`
--
ALTER TABLE `project_edit_permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `project_email_log`
--
ALTER TABLE `project_email_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `project_equipment`
--
ALTER TABLE `project_equipment`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `project_files`
--
ALTER TABLE `project_files`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

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

--
-- AUTO_INCREMENT for table `project_partners`
--
ALTER TABLE `project_partners`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `project_payments`
--
ALTER TABLE `project_payments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `project_photos`
--
ALTER TABLE `project_photos`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `project_sold_equipment`
--
ALTER TABLE `project_sold_equipment`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `project_statuses`
--
ALTER TABLE `project_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `project_tasks`
--
ALTER TABLE `project_tasks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=450;

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

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

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

--
-- AUTO_INCREMENT for table `vehicles`
--
ALTER TABLE `vehicles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `work_sessions`
--
ALTER TABLE `work_sessions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `inbox_attachments`
--
ALTER TABLE `inbox_attachments`
  ADD CONSTRAINT `fk_inbox_attachments_email` FOREIGN KEY (`inbox_email_id`) REFERENCES `inbox_emails` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
  ADD CONSTRAINT `fk_projects_category` FOREIGN KEY (`category_id`) REFERENCES `project_categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_projects_customer` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`);

--
-- Constraints for table `project_email_log`
--
ALTER TABLE `project_email_log`
  ADD CONSTRAINT `fk_project_email_log_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `project_equipment`
--
ALTER TABLE `project_equipment`
  ADD CONSTRAINT `fk_project_equipment_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `project_files`
--
ALTER TABLE `project_files`
  ADD CONSTRAINT `fk_project_files_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `project_partners`
--
ALTER TABLE `project_partners`
  ADD CONSTRAINT `fk_project_partners_partner` FOREIGN KEY (`external_partner_id`) REFERENCES `external_partners` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_project_partners_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `project_payments`
--
ALTER TABLE `project_payments`
  ADD CONSTRAINT `fk_project_payments_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `project_tasks`
--
ALTER TABLE `project_tasks`
  ADD CONSTRAINT `fk_project_tasks_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `vehicle_services`
--
ALTER TABLE `vehicle_services`
  ADD CONSTRAINT `fk_vehicle_services_vehicle` FOREIGN KEY (`vehicle_id`) REFERENCES `vehicles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `work_sessions`
--
ALTER TABLE `work_sessions`
  ADD CONSTRAINT `fk_work_sessions_employee` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_work_sessions_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `work_session_notes`
--
ALTER TABLE `work_session_notes`
  ADD CONSTRAINT `fk_work_session_notes_session` FOREIGN KEY (`work_session_id`) REFERENCES `work_sessions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `work_session_photos`
--
ALTER TABLE `work_session_photos`
  ADD CONSTRAINT `fk_work_session_photos_session` FOREIGN KEY (`work_session_id`) REFERENCES `work_sessions` (`id`) ON DELETE CASCADE;
COMMIT;

