-- Database Export
-- Generated: 2025-06-28T11:55:13.113Z


-- Table: activity_logs
CREATE TABLE activity_logs (created_at TIMESTAMP NOT NULL, user_id INTEGER NOT NULL, performed_by INTEGER, metadata JSON, id INTEGER NOT NULL, ip_address VARCHAR(45), performed_by_type VARCHAR(20) NOT NULL, user_agent TEXT, action_type VARCHAR(50) NOT NULL, action_category VARCHAR(20) NOT NULL, description TEXT NOT NULL);

-- Data for activity_logs
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (1, 1, 'user_created', 'system', 'Kullanıcı hesabı oluşturuldu', NULL, 'system', NULL, NULL, NULL, '"2025-06-05T15:18:06.360Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (2, 1, 'email_verified', 'user', 'E-posta adresi doğrulandı', NULL, 'user', NULL, NULL, NULL, '"2025-06-06T15:18:06.360Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (3, 1, 'login', 'user', 'Sisteme giriş yapıldı', NULL, 'user', NULL, NULL, NULL, '"2025-06-13T15:18:06.360Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (4, 1, 'profile_updated', 'admin', 'İletişim bilgileri admin tarafından güncellendi', NULL, 'admin', NULL, NULL, NULL, '"2025-06-14T15:18:06.360Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (5, 1, 'status_changed', 'admin', 'Kullanıcı durumu admin tarafından değiştirildi', NULL, 'admin', NULL, NULL, NULL, '"2025-06-15T09:18:06.360Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (6, 17, 'contact_updated', 'admin', 'İletişim bilgileri admin tarafından güncellendi', 9, 'admin', '{"updatedFields":{"email":"otowishapp@gmail.com","phone":"054544455556","businessPhone":"056544455558","whatsappNumber":"058544455554","instagramUsername":"qweqwe2222229"}}', NULL, NULL, '"2025-06-15T15:18:52.855Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (7, 17, 'email_verified_by_admin', 'admin', 'E-posta doğrulaması admin tarafından onaylandı', 9, 'admin', '{"action":"manual_email_verification"}', NULL, NULL, '"2025-06-15T15:20:44.421Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (8, 17, 'contact_updated', 'admin', 'İletişim bilgileri admin tarafından güncellendi', 9, 'admin', '{"updatedFields":{"email":"otowishapps@gmail.com","phone":"054544455556","businessPhone":"056544455558","whatsappNumber":"058544455554","instagramUsername":"qweqwe2222229"}}', NULL, NULL, '"2025-06-15T15:21:36.786Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (9, 17, 'contact_updated', 'admin', 'İletişim bilgileri admin tarafından güncellendi', 9, 'admin', '{"updatedFields":{"email":"otowishapp@gmail.com","phone":"054544455556","businessPhone":"056544455558","whatsappNumber":"058544455554","instagramUsername":"qweqwe2222229"}}', NULL, NULL, '"2025-06-15T15:21:42.465Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (10, 17, 'contact_updated', 'admin', 'İletişim bilgileri admin tarafından güncellendi', 9, 'admin', '{"updatedFields":{"email":"otowishapp@gmail.com","phone":"05455000000","businessPhone":"05555555555","whatsappNumber":"058544455554","instagramUsername":"0000000001"}}', NULL, NULL, '"2025-06-15T20:07:12.016Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (11, 17, 'profile_updated', 'admin', 'Hakkında bilgisi admin tarafından güncellendi', 9, 'admin', '{"updatedField":"profileDescription"}', NULL, NULL, '"2025-06-15T20:07:28.628Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (12, 18, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-16T09:15:19.973Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (13, 17, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-16T09:16:27.818Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (14, 18, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 2 olarak güncellendi', 9, 'admin', '{"newQuota":2}', NULL, NULL, '"2025-06-16T10:22:53.833Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (15, 18, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 0 olarak güncellendi', 9, 'admin', '{"newQuota":0}', NULL, NULL, '"2025-06-16T10:23:09.836Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (16, 17, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 2 olarak güncellendi', 9, 'admin', '{"newQuota":2}', NULL, NULL, '"2025-06-16T10:35:26.663Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (17, 23, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-20T15:12:17.198Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (18, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-20T18:35:51.539Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (19, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-20T18:48:52.073Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (20, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 5 olarak güncellendi', 9, 'admin', '{"newQuota":5}', NULL, NULL, '"2025-06-20T18:49:10.191Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (21, 23, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-20T19:04:44.756Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (22, 23, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-20T19:09:49.021Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (23, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-20T19:13:05.640Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (24, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-20T19:13:15.292Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (25, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 2 olarak güncellendi', 9, 'admin', '{"newQuota":2}', NULL, NULL, '"2025-06-20T19:13:24.966Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (26, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 0 olarak güncellendi', 9, 'admin', '{"newQuota":0}', NULL, NULL, '"2025-06-20T19:13:58.549Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (27, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-20T19:14:12.860Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (28, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 2 olarak güncellendi', 9, 'admin', '{"newQuota":2}', NULL, NULL, '"2025-06-20T19:14:21.438Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (29, 24, 'listing_created', 'user', 'İlan oluşturuldu: #202506000027', NULL, 'user', '{"listingId":66,"listingNumber":"202506000027","categoryId":19,"packageId":1,"status":"pending"}', NULL, NULL, '"2025-06-20T19:15:55.498Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (30, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 2 olarak güncellendi', 9, 'admin', '{"newQuota":2}', NULL, NULL, '"2025-06-21T22:24:52.900Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (31, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 20 olarak güncellendi', 9, 'admin', '{"newQuota":20}', NULL, NULL, '"2025-06-21T22:25:03.841Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (32, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 1 olarak güncellendi', 9, 'admin', '{"newQuota":1}', NULL, NULL, '"2025-06-21T23:12:46.990Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (33, 24, 'free_listing_quota_updated', 'admin', 'Ücretsiz ilan hakkı 16 olarak güncellendi', 9, 'admin', '{"newQuota":16}', NULL, NULL, '"2025-06-21T23:13:50.616Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (34, 24, 'listing_created', 'user', 'İlan oluşturuldu: #202506000028', NULL, 'user', '{"listingId":69,"listingNumber":"202506000028","categoryId":19,"packageId":1,"status":"pending"}', NULL, NULL, '"2025-06-23T20:42:57.198Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (35, 24, 'listing_created', 'user', 'İlan oluşturuldu: #202506000029', NULL, 'user', '{"listingId":70,"listingNumber":"202506000029","categoryId":19,"packageId":1,"status":"pending"}', NULL, NULL, '"2025-06-27T20:57:44.947Z"');
INSERT INTO "activity_logs" ("id", "user_id", "action_type", "action_category", "description", "performed_by", "performed_by_type", "metadata", "ip_address", "user_agent", "created_at") VALUES (36, 24, 'listing_updated', 'user', 'İlan güncellendi: #202506000029', NULL, 'user', '{"listingId":70,"listingNumber":"202506000029","updatedFields":["kimden","description","contactPreference","phone","whatsapp","instagram","cityId","districtId","neighborhoodId","customFields","selectedDopings","photos","categoryId"]}', NULL, NULL, '"2025-06-27T20:59:30.939Z"');


-- Table: categories
CREATE TABLE categories (id INTEGER NOT NULL, sort_order INTEGER, created_at TIMESTAMP, updated_at TIMESTAMP, level INTEGER NOT NULL, show_in_details BOOLEAN NOT NULL, show_in_index BOOLEAN NOT NULL, parent_id INTEGER, name TEXT NOT NULL, slug TEXT NOT NULL, icon TEXT, system_name TEXT NOT NULL, status TEXT NOT NULL, level_name TEXT NOT NULL);

-- Data for categories
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (34, 'Mercedes-Benz', 'mercedes-benz', 15, 'Marka', 'active', 0, '', '"2025-06-13T11:36:43.629Z"', '"2025-06-13T11:36:59.688Z"', 3, 'Marka', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (35, 'S Serisi', 's-serisi', 34, 'Seri', 'active', 0, '', '"2025-06-13T11:37:14.233Z"', '"2025-06-13T11:37:23.160Z"', 4, 'Seri', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (36, 'S580', 's580', 35, 'Model', 'active', 0, '', '"2025-06-13T11:37:34.286Z"', '"2025-06-13T11:37:39.589Z"', 5, 'Model', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (37, 'Maybach', 'maybach', 36, 'Paket', 'active', 0, '', '"2025-06-13T11:37:48.067Z"', '"2025-06-13T11:37:55.793Z"', 6, 'Araç Paketi', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (15, 'Otomobil', 'otomobil', 14, 'otomobil', 'active', 0, '', '"2025-06-07T11:36:52.330Z"', '"2025-06-19T12:41:56.455Z"', 2, 'Kategori', FALSE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (28, 'Motosiklet', 'motosiklet', 14, 'motosiklet', 'active', 0, '', '"2025-06-08T00:45:09.211Z"', '"2025-06-08T00:45:09.200Z"', 2, 'Kategori', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (29, 'Arazi, SUV & Pickup', 'arazi-suv-pickup', 14, 'arazisuvpickup', 'active', 0, '', '"2025-06-08T00:45:16.537Z"', '"2025-06-08T00:45:16.525Z"', 2, 'Kategori', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (16, 'BMW', 'bmw', 15, 'Marka', 'active', 0, '/icons/category-1749307900794-777209702.png', '"2025-06-07T11:37:03.972Z"', '"2025-06-09T16:20:57.661Z"', 3, 'Marka', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (27, 'Audi', 'audi', 15, 'Marka', 'active', 0, '', '"2025-06-07T19:43:17.067Z"', '"2025-06-09T16:21:02.256Z"', 3, 'Marka', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (17, '3 Serisi', '3-serisi', 16, 'Seri', 'active', 0, '', '"2025-06-07T11:37:30.725Z"', '"2025-06-09T16:21:13.583Z"', 4, 'Seri', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (18, '320d', '320d', 17, 'Model', 'active', 0, '', '"2025-06-07T11:37:41.239Z"', '"2025-06-09T16:21:30.303Z"', 5, 'Model', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (19, 'M Sport', 'm-sport', 18, 'Paket', 'active', 0, '', '"2025-06-07T11:37:56.567Z"', '"2025-06-09T16:21:40.406Z"', 6, 'Araç Paketi', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (39, 'İkinci El', 'ikinci-el', NULL, 'ikinciel', 'active', 0, '', '"2025-06-23T22:41:02.152Z"', '"2025-06-23T22:41:02.140Z"', 1, 'Ana Kategori', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (40, 'Elektronik', 'elektronik', NULL, 'elektronik', 'active', 0, '', '"2025-06-23T22:41:08.853Z"', '"2025-06-23T22:41:08.840Z"', 1, 'Ana Kategori', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (41, 'Bahçe', 'bahce', NULL, 'bahce', 'active', 0, '', '"2025-06-23T22:41:13.062Z"', '"2025-06-23T22:41:13.051Z"', 1, 'Ana Kategori', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (26, 'Emlak', 'emlak', NULL, 'emlak', 'active', 0, '', '"2025-06-07T16:35:59.991Z"', '"2025-06-23T22:41:58.100Z"', 1, 'Ana Kategori', FALSE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (42, 'Evcil Hayvan', 'evcil-hayvan', NULL, 'evcilhayvan', 'active', 0, '', '"2025-06-23T22:42:31.964Z"', '"2025-06-23T22:42:31.952Z"', 1, 'Ana Kategori', TRUE, TRUE);
INSERT INTO "categories" ("id", "name", "slug", "parent_id", "system_name", "status", "sort_order", "icon", "created_at", "updated_at", "level", "level_name", "show_in_details", "show_in_index") VALUES (14, 'Vasıta', 'vasita', NULL, 'vasita', 'active', 0, '', '"2025-06-07T11:36:45.643Z"', '"2025-06-27T21:07:21.928Z"', 1, 'Ana Kategori', FALSE, FALSE);


-- Table: cities
CREATE TABLE cities (sort_order INTEGER, created_at TIMESTAMP, updated_at TIMESTAMP, id INTEGER NOT NULL, status TEXT NOT NULL, name TEXT NOT NULL, slug TEXT NOT NULL);

-- Data for cities
INSERT INTO "cities" ("id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (6, 'Aksaray', 'aksaray', 'active', 0, '"2025-06-13T00:56:02.694Z"', '"2025-06-13T00:56:02.694Z"');
INSERT INTO "cities" ("id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (1, 'İstanbul', 'istanbul', 'active', 0, '"2025-06-08T10:05:46.256Z"', '"2025-06-08T10:05:46.256Z"');


-- Table: custom_fields
CREATE TABLE custom_fields (units JSONB, category_id INTEGER NOT NULL, created_at TIMESTAMP, updated_at TIMESTAMP, use_thousand_separator BOOLEAN NOT NULL, is_filter BOOLEAN NOT NULL, id INTEGER NOT NULL, required BOOLEAN NOT NULL, min_value INTEGER, max_value INTEGER, step_value INTEGER, options JSON, sort_order INTEGER, is_active BOOLEAN NOT NULL, label TEXT NOT NULL, field_type TEXT NOT NULL, placeholder TEXT, unit TEXT, default_value TEXT);

-- Data for custom_fields
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (3, 15, 'Fiyat (TL)', 'number', 'Fiyat girin', TRUE, NULL, NULL, NULL, NULL, NULL, 0, TRUE, '"2025-06-07T16:37:16.629Z"', '"2025-06-20T11:15:57.601Z"', TRUE, TRUE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (6, 26, 'Brüt m2', 'text', 'm2 Giriniz', TRUE, NULL, NULL, NULL, NULL, NULL, 0, TRUE, '"2025-06-07T19:41:10.767Z"', '"2025-06-07T19:41:10.708Z"', FALSE, FALSE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (7, 15, 'KM', 'number', 'KM girin', TRUE, NULL, NULL, NULL, NULL, NULL, 1, TRUE, '"2025-06-07T21:05:39.901Z"', '"2025-06-20T11:15:57.624Z"', TRUE, TRUE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (9, 15, 'Yıl', 'select', 'Yıl seçin', TRUE, NULL, NULL, NULL, NULL, '["2024","2023","2022","2021","2020"]', 2, TRUE, '"2025-06-08T00:51:23.160Z"', '"2025-06-20T11:15:57.648Z"', FALSE, TRUE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (10, 15, 'Yakıt Tipi', 'select', 'Yakıt tipi seçin', TRUE, NULL, NULL, NULL, NULL, '["Benzin","Benzin & LPG","Dizel","Hibrit","Elektrik"]', 3, TRUE, '"2025-06-08T00:52:29.810Z"', '"2025-06-20T11:15:57.672Z"', FALSE, TRUE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (13, 15, 'Vites', 'select', 'Vites tipi seçin', TRUE, NULL, NULL, NULL, NULL, '["Otomatik","Manuel"]', 4, TRUE, '"2025-06-08T00:53:59.182Z"', '"2025-06-20T11:15:57.697Z"', FALSE, TRUE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (14, 15, 'Renk', 'select', 'Renk seçin', TRUE, NULL, NULL, NULL, NULL, '["Bej","Beyaz","Bordo","Kırmızı","Siyah"]', 5, TRUE, '"2025-06-08T00:54:28.361Z"', '"2025-06-20T11:15:57.720Z"', FALSE, TRUE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (15, 15, 'Takaslı', 'select', 'Seçin', TRUE, NULL, NULL, NULL, NULL, '["Evet","Hayır"]', 6, TRUE, '"2025-06-08T00:55:04.522Z"', '"2025-06-20T11:15:57.745Z"', FALSE, TRUE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (21, 15, 'Motor Gücü', 'number', '1', TRUE, NULL, 1, 9999, NULL, NULL, 7, TRUE, '"2025-06-16T16:41:20.624Z"', '"2025-06-20T11:15:57.770Z"', FALSE, TRUE, NULL, '["hp"]');
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (19, 28, 'Mototest', 'text', NULL, TRUE, NULL, NULL, NULL, NULL, NULL, 0, TRUE, '"2025-06-08T13:55:16.609Z"', '"2025-06-08T13:55:16.550Z"', FALSE, TRUE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (16, 15, 'Araç Durumu', 'select', 'Seçin', TRUE, NULL, NULL, NULL, NULL, '["İkinci El"]', 9, TRUE, '"2025-06-08T00:55:26.405Z"', '"2025-06-20T11:15:57.818Z"', FALSE, TRUE, NULL, NULL);
INSERT INTO "custom_fields" ("id", "category_id", "label", "field_type", "placeholder", "required", "default_value", "min_value", "max_value", "step_value", "options", "sort_order", "is_active", "created_at", "updated_at", "use_thousand_separator", "is_filter", "unit", "units") VALUES (20, 15, 'Motor Hacmi', 'number', 'Motor hacmi girin', TRUE, NULL, 1, 9999, NULL, NULL, 8, TRUE, '"2025-06-16T16:40:38.140Z"', '"2025-06-20T11:16:51.837Z"', FALSE, TRUE, NULL, '["cc"]');


-- Table: districts
CREATE TABLE districts (id INTEGER NOT NULL, city_id INTEGER NOT NULL, sort_order INTEGER, created_at TIMESTAMP, updated_at TIMESTAMP, name TEXT NOT NULL, slug TEXT NOT NULL, status TEXT NOT NULL);

-- Data for districts
INSERT INTO "districts" ("id", "city_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (1, 1, 'Kadıköy', 'kadikoy', 'active', 1, '"2025-06-08T10:05:52.287Z"', '"2025-06-08T10:05:52.287Z"');
INSERT INTO "districts" ("id", "city_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (2, 1, 'Beşiktaş', 'besiktas', 'active', 2, '"2025-06-08T10:05:52.287Z"', '"2025-06-08T10:05:52.287Z"');
INSERT INTO "districts" ("id", "city_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (3, 1, 'Üsküdar', 'uskudar', 'active', 3, '"2025-06-08T10:05:52.287Z"', '"2025-06-08T10:05:52.287Z"');
INSERT INTO "districts" ("id", "city_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (4, 2, 'Çankaya', 'cankaya', 'active', 1, '"2025-06-08T10:05:52.287Z"', '"2025-06-08T10:05:52.287Z"');
INSERT INTO "districts" ("id", "city_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (5, 2, 'Keçiören', 'kecioren', 'active', 2, '"2025-06-08T10:05:52.287Z"', '"2025-06-08T10:05:52.287Z"');
INSERT INTO "districts" ("id", "city_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (6, 3, 'Konak', 'konak', 'active', 1, '"2025-06-08T10:05:52.287Z"', '"2025-06-08T10:05:52.287Z"');
INSERT INTO "districts" ("id", "city_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (7, 3, 'Bornova', 'bornova', 'active', 2, '"2025-06-08T10:05:52.287Z"', '"2025-06-08T10:05:52.287Z"');
INSERT INTO "districts" ("id", "city_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (8, 4, 'Menemen', 'menemen', 'active', 0, '"2025-06-08T10:39:57.416Z"', '"2025-06-08T10:39:57.416Z"');
INSERT INTO "districts" ("id", "city_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (10, 6, 'Merkez', 'merkez', 'active', 0, '"2025-06-13T00:58:25.865Z"', '"2025-06-13T00:58:25.865Z"');


-- Table: dopings
CREATE TABLE dopings (id INTEGER NOT NULL, is_active BOOLEAN NOT NULL, sort_order INTEGER, created_at TIMESTAMP, updated_at TIMESTAMP, price NUMERIC(10,2) NOT NULL, duration INTEGER NOT NULL, name TEXT NOT NULL, description TEXT, icon_name TEXT, color TEXT);

-- Data for dopings
INSERT INTO "dopings" ("id", "name", "description", "price", "duration", "icon_name", "color", "is_active", "sort_order", "created_at", "updated_at") VALUES (2, 'Ana Sayfa Vitrini', 'ilanınız anasayfada gösterilir', '99.00', 7, 'trending-up', '#22c55e', TRUE, 0, '"2025-06-13T02:03:59.198Z"', '"2025-06-13T11:24:32.433Z"');
INSERT INTO "dopings" ("id", "name", "description", "price", "duration", "icon_name", "color", "is_active", "sort_order", "created_at", "updated_at") VALUES (1, 'Acil Acil', 'Aracımı acil satmam lazım diyorsanız! ', '61.00', 1, 'zap', '#ef4444', TRUE, 0, '"2025-06-09T18:26:30.740Z"', '"2025-06-13T11:24:38.578Z"');


-- Table: email_logs
CREATE TABLE email_logs (id INTEGER NOT NULL, sent_at TIMESTAMP NOT NULL, subject VARCHAR(255) NOT NULL, status VARCHAR(20) NOT NULL, error_message TEXT, provider VARCHAR(20) NOT NULL, to_email VARCHAR(255) NOT NULL);

-- Data for email_logs
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (1, 'test@example.com', 'Şifre Sıfırlama Kodu - Test', 'gmail', 'success', NULL, '"2025-06-14T13:08:19.102Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (3, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'gmail', 'success', NULL, '"2025-06-14T13:16:08.262Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (5, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'gmail', 'success', NULL, '"2025-06-14T13:17:06.611Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (7, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'gmail', 'success', NULL, '"2025-06-14T14:57:42.616Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (9, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'gmail', 'success', NULL, '"2025-06-14T14:58:47.669Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (11, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'gmail', 'success', NULL, '"2025-06-14T15:27:35.191Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (2, 'test@example.com', 'Şifre Sıfırlama Kodu - Test', 'system', 'success', NULL, '"2025-06-14T13:08:19.149Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (4, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'system', 'success', NULL, '"2025-06-14T13:16:08.316Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (6, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'system', 'success', NULL, '"2025-06-14T13:17:06.636Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (8, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'system', 'success', NULL, '"2025-06-14T14:57:42.645Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (10, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'system', 'success', NULL, '"2025-06-14T14:58:47.703Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (12, 'vedatplesk@gmail.com', 'Şifre Sıfırlama Kodu - VEDAT', 'system', 'success', NULL, '"2025-06-14T15:27:35.224Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (13, 'vedatplesk@gmail.com', 'İlanınız Hakkında - 202506000009', 'gmail', 'success', NULL, '"2025-06-14T15:41:05.731Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (14, 'vedatplesk@gmail.com', 'İlanınız Hakkında - 202506000009', 'system', 'success', NULL, '"2025-06-14T15:41:05.782Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (15, 'vedatplesk@gmail.com', 'İlanınız Hakkında - 202506000009', 'gmail', 'success', NULL, '"2025-06-14T15:42:00.916Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (16, 'vedatplesk@gmail.com', 'İlanınız Hakkında - 202506000009', 'system', 'success', NULL, '"2025-06-14T15:42:00.942Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (17, 'vedatplesk@gmail.com', 'İlanınız Hakkında - 202506000009', 'gmail', 'success', NULL, '"2025-06-14T15:49:10.664Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (18, 'vedatplesk@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-15T09:21:30.026Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (19, 'otowishapp@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-15T10:01:53.780Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (20, 'otowishapp@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-15T20:09:18.789Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (21, 'materyalco@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-15T20:20:55.211Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (22, 'materyalco@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-16T09:12:38.672Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (23, 'selim@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-16T10:40:05.190Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (24, 'turan@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-16T13:19:28.309Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (25, 'mondial@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-16T13:47:23.636Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (26, 'mondial@gmail.com', 'İlanınız Hakkında - 202506000015', 'gmail', 'success', NULL, '"2025-06-16T17:15:37.759Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (27, 'deli@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-17T20:38:21.717Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (28, 'nuri@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-19T20:32:48.620Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (29, 'cemal@gmail.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-20T15:17:02.258Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (30, 'cemal@gmail.com', 'İlanınız Onaylandı - 202506000026', 'gmail', 'success', NULL, '"2025-06-20T17:09:41.454Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (31, 'workinguser@test.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-22T02:10:50.195Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (32, 'newtest@test.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-22T02:15:31.512Z"');
INSERT INTO "email_logs" ("id", "to_email", "subject", "provider", "status", "error_message", "sent_at") VALUES (33, 'newuser@test.com', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', 'gmail', 'success', NULL, '"2025-06-22T02:25:23.548Z"');


-- Table: email_settings
CREATE TABLE email_settings (id INTEGER NOT NULL, is_active BOOLEAN, settings JSON NOT NULL, created_at TIMESTAMP, updated_at TIMESTAMP, provider VARCHAR(20) NOT NULL);

-- Data for email_settings
INSERT INTO "email_settings" ("id", "provider", "is_active", "settings", "created_at", "updated_at") VALUES (1, 'gmail', FALSE, '{"gmail":{"user":"vedatmacbook@gmail.com","appPassword":"tqvb imxv kwfm vkbn"}}', '"2025-06-14T11:55:29.769Z"', '"2025-06-14T11:55:29.769Z"');
INSERT INTO "email_settings" ("id", "provider", "is_active", "settings", "created_at", "updated_at") VALUES (2, 'gmail', FALSE, '{"gmail":{"user":"vedatmacbook@gmail.com","appPassword":"tqvb imxv kwfm vkbn"}}', '"2025-06-14T11:55:55.914Z"', '"2025-06-14T11:55:55.914Z"');
INSERT INTO "email_settings" ("id", "provider", "is_active", "settings", "created_at", "updated_at") VALUES (3, 'gmail', FALSE, '{"gmail":{"user":"vedatmacbook@gmail.com","appPassword":"tqvbimxvkwfmvkbn"}}', '"2025-06-14T11:56:07.871Z"', '"2025-06-14T11:56:07.871Z"');
INSERT INTO "email_settings" ("id", "provider", "is_active", "settings", "created_at", "updated_at") VALUES (4, 'gmail', TRUE, '{"gmail":{"user":"vedatmacbook@gmail.com","appPassword":"tqvbimxvkwfmvkbn"}}', '"2025-06-14T12:07:16.131Z"', '"2025-06-14T12:07:16.131Z"');


-- Table: email_templates
CREATE TABLE email_templates (is_active BOOLEAN, created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP NOT NULL, id INTEGER NOT NULL, content TEXT NOT NULL, type VARCHAR(50) NOT NULL, subject VARCHAR(255) NOT NULL);

-- Data for email_templates
INSERT INTO "email_templates" ("id", "type", "subject", "content", "is_active", "created_at", "updated_at") VALUES (1, 'verification', 'E-posta Adresinizi Doğrulayın - Otomobil Platformu', '
<div style="font-family: Arial, sans-serif; max-width: 600px; margin: 0 auto;">
  <h2 style="color: #333;">E-posta Adresinizi Doğrulayın</h2>
  <p>Merhaba,</p>
  <p>Otomobil Platformu''na hoş geldiniz! Hesabınızı aktifleştirmek için aşağıdaki butona tıklayın:</p>
  <div style="text-align: center; margin: 30px 0;">
    <a href="{{verification_url}}" 
       style="background-color: #007bff; color: white; padding: 12px 24px; 
              text-decoration: none; border-radius: 5px; display: inline-block;">
      E-postamı Doğrula
    </a>
  </div>
  <p>Eğer buton çalışmıyorsa, aşağıdaki linki tarayıcınıza kopyalayın:</p>
  <p style="word-break: break-all; color: #666;">{{verification_url}}</p>
  <hr style="margin: 20px 0; border: none; border-top: 1px solid #eee;">
  <p style="color: #666; font-size: 12px;">
    Bu e-posta size {{email}} adresine gönderilmiştir. 
    Eğer hesap oluşturmadıysanız, bu e-postayı görmezden gelebilirsiniz.
  </p>
</div>', TRUE, '"2025-06-14T12:13:25.126Z"', '"2025-06-14T12:13:25.126Z"');
INSERT INTO "email_templates" ("id", "type", "subject", "content", "is_active", "created_at", "updated_at") VALUES (3, 'welcome', 'Hoş Geldiniz - Otomobil Platformu', '
<div style="font-family: Arial, sans-serif; max-width: 600px; margin: 0 auto;">
  <h2 style="color: #333;">Hoş Geldiniz!</h2>
  <p>Merhaba {{name}},</p>
  <p>Otomobil Platformu''na hoş geldiniz! E-posta adresiniz başarıyla doğrulandı ve hesabınız aktif hale getirildi.</p>
  <p>Artık platformumuzu kullanarak:</p>
  <ul>
    <li>İlan verebilir</li>
    <li>Araç alım-satım işlemlerinizi gerçekleştirebilir</li>
    <li>Gelişmiş filtreleme seçenekleriyle arama yapabilirsiniz</li>
  </ul>
  <div style="text-align: center; margin: 30px 0;">
    <a href="{{dashboard_url}}" 
       style="background-color: #28a745; color: white; padding: 12px 24px; 
              text-decoration: none; border-radius: 5px; display: inline-block;">
      Panele Git
    </a>
  </div>
  <p>İyi alışverişler dileriz!</p>
</div>', TRUE, '"2025-06-14T12:13:25.126Z"', '"2025-06-14T12:13:25.126Z"');
INSERT INTO "email_templates" ("id", "type", "subject", "content", "is_active", "created_at", "updated_at") VALUES (2, 'password_reset', 'Şifre Sıfırlama Kodu - {{userName}}', '<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>Şifre Sıfırlama</title>
    <style>
        body { font-family: Arial, sans-serif; line-height: 1.6; color: #333; }
        .container { max-width: 600px; margin: 0 auto; padding: 20px; }
        .header { background: #f8f9fa; padding: 20px; text-align: center; border-radius: 5px 5px 0 0; }
        .content { background: #fff; padding: 30px; border: 1px solid #ddd; }
        .code-box { background: #e3f2fd; padding: 20px; text-align: center; border-radius: 5px; margin: 20px 0; }
        .code { font-size: 32px; font-weight: bold; color: #1976d2; letter-spacing: 5px; }
        .footer { background: #f8f9fa; padding: 15px; text-align: center; border-radius: 0 0 5px 5px; font-size: 12px; color: #666; }
        .button { display: inline-block; padding: 12px 24px; background: #1976d2; color: white; text-decoration: none; border-radius: 5px; margin: 10px 0; }
    </style>
</head>
<body>
    <div class="container">
        <div class="header">
            <h2>Şifre Sıfırlama Talebi</h2>
        </div>
        <div class="content">
            <p>Merhaba <strong>{{userName}}</strong>,</p>
            
            <p>Hesabınız için şifre sıfırlama talebinde bulundunuz. Aşağıdaki 6 haneli doğrulama kodunu kullanarak şifrenizi sıfırlayabilirsiniz:</p>
            
            <div class="code-box">
                <div class="code">{{resetCode}}</div>
            </div>
            
            <p><strong>Önemli:</strong> Bu kod <strong>{{expirationTime}}</strong> süre içinde geçerliliğini yitirecektir.</p>
            
            <p>Güvenlik nedeniyle bu kodu kimseyle paylaşmayın ve sadece resmi web sitemizde kullanın.</p>
            
            <p>Eğer bu talebi siz yapmadıysanız, hesabınızın güvenliği için lütfen bizimle iletişime geçin ve bu e-postayı dikkate almayın.</p>
            
            <p>Saygılarımızla,<br>
            <strong>Otomobil Platformu Ekibi</strong></p>
        </div>
        <div class="footer">
            Bu e-posta otomatik olarak gönderilmiştir. Lütfen yanıtlamayın.
        </div>
    </div>
</body>
</html>', TRUE, '"2025-06-14T12:13:25.126Z"', '"2025-06-14T13:08:13.888Z"');
INSERT INTO "email_templates" ("id", "type", "subject", "content", "is_active", "created_at", "updated_at") VALUES (4, 'listing_approved', 'İlanınız Onaylandı - {{listingNumber}}', '<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>İlan Onaylandı</title>
    <style>
        body { font-family: Arial, sans-serif; line-height: 1.6; color: #333; }
        .container { max-width: 600px; margin: 0 auto; padding: 20px; }
        .header { background: #e8f5e8; padding: 20px; text-align: center; border-radius: 5px 5px 0 0; }
        .content { background: #fff; padding: 30px; border: 1px solid #ddd; }
        .success-box { background: #d4edda; padding: 20px; text-align: center; border-radius: 5px; margin: 20px 0; border: 1px solid #c3e6cb; }
        .footer { background: #f8f9fa; padding: 15px; text-align: center; border-radius: 0 0 5px 5px; font-size: 12px; color: #666; }
        .button { display: inline-block; padding: 12px 24px; background: #28a745; color: white; text-decoration: none; border-radius: 5px; margin: 10px 0; }
    </style>
</head>
<body>
    <div class="container">
        <div class="header">
            <h2 style="color: #28a745; margin: 0;">🎉 İlanınız Onaylandı!</h2>
        </div>
        <div class="content">
            <p>Merhaba <strong>{{userName}}</strong>,</p>
            
            <div class="success-box">
                <h3 style="color: #155724; margin-top: 0;">Harika Haber!</h3>
                <p style="margin-bottom: 0;">İlan Numarası: <strong>{{listingNumber}}</strong> başarıyla onaylandı ve artık yayında!</p>
            </div>
            
            <p>İlanınız <strong>{{listingTitle}}</strong> inceleme sürecini başarıyla tamamladı ve artık platformumuzda yayınlanıyor.</p>
            
            <p><strong>Şimdi neler yapabilirsiniz:</strong></p>
            <ul>
                <li>İlanınızı sosyal medyada paylaşabilirsiniz</li>
                <li>Doping paketleri ile daha fazla görünürlük sağlayabilirsiniz</li>
                <li>İlan istatistiklerinizi takip edebilirsiniz</li>
                <li>Mesajları ve aramaları yanıtlayabilirsiniz</li>
            </ul>
            
            <p>Satış sürecinizde başarılar dileriz!</p>
            
            <p>Saygılarımızla,<br>
            <strong>Otomobil Platformu Ekibi</strong></p>
        </div>
        <div class="footer">
            Bu e-posta otomatik olarak gönderilmiştir. Lütfen yanıtlamayın.
        </div>
    </div>
</body>
</html>', TRUE, '"2025-06-14T12:13:25.126Z"', '"2025-06-14T15:33:02.601Z"');
INSERT INTO "email_templates" ("id", "type", "subject", "content", "is_active", "created_at", "updated_at") VALUES (7, 'listing_rejected', 'İlanınız Hakkında - {{listingNumber}}', '<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>İlan İnceleme Sonucu</title>
    <style>
        body { font-family: Arial, sans-serif; line-height: 1.6; color: #333; }
        .container { max-width: 600px; margin: 0 auto; padding: 20px; }
        .header { background: #fff3cd; padding: 20px; text-align: center; border-radius: 5px 5px 0 0; }
        .content { background: #fff; padding: 30px; border: 1px solid #ddd; }
        .warning-box { background: #fff3cd; padding: 20px; text-align: center; border-radius: 5px; margin: 20px 0; border: 1px solid #ffeaa7; }
        .footer { background: #f8f9fa; padding: 15px; text-align: center; border-radius: 0 0 5px 5px; font-size: 12px; color: #666; }
        .button { display: inline-block; padding: 12px 24px; background: #007bff; color: white; text-decoration: none; border-radius: 5px; margin: 10px 0; }
    </style>
</head>
<body>
    <div class="container">
        <div class="header">
            <h2 style="color: #856404; margin: 0;">İlan İnceleme Sonucu</h2>
        </div>
        <div class="content">
            <p>Merhaba <strong>{{userName}}</strong>,</p>
            
            <div class="warning-box">
                <h3 style="color: #856404; margin-top: 0;">İlan İnceleme Sonucu</h3>
                <p style="margin-bottom: 0;">İlan Numarası: <strong>{{listingNumber}}</strong> inceleme sonrası revizyon gerektiği tespit edilmiştir.</p>
            </div>
            
            <p>İlanınız <strong>{{listingTitle}}</strong> platform kurallarımız gereği yayından kaldırılmıştır.</p>
            
            <p><strong>Olası sebepler:</strong></p>
            <ul>
                <li>Eksik veya hatalı araç bilgileri</li>
                <li>Kalitesiz veya uygunsuz fotoğraflar</li>
                <li>İletişim bilgilerinde eksiklik</li>
                <li>Platform kurallarına aykırı içerik</li>
            <li>{{rejectionReason}}</li></ul>
            
            <p><strong>Neler yapabilirsiniz:</strong></p>
            <ul>
                <li>İlanınızı düzenleyerek eksiklikleri tamamlayın</li>
                <li>Fotoğraflarınızı kontrol edin ve kaliteli olanları yükleyin</li>
                <li>Araç bilgilerinin doğruluğunu kontrol edin</li>
                <li>Tekrar yayın için başvurun</li>
            <li>{{rejectionReason}}</li></ul>
            
            <p>Sorularınız için destek ekibimizle iletişime geçebilirsiniz.</p>
            
            <p>Saygılarımızla,<br>
            <strong>Otomobil Platformu Ekibi</strong></p>
        </div>
        <div class="footer">
            Bu e-posta otomatik olarak gönderilmiştir. Lütfen yanıtlamayın.
        </div>
    </div>
</body>
</html>', TRUE, '"2025-06-14T15:33:02.601Z"', '"2025-06-14T15:33:02.601Z"');


-- Table: listing_quota_history
CREATE TABLE listing_quota_history (id INTEGER NOT NULL, user_id INTEGER NOT NULL, quota_change INTEGER NOT NULL, related_listing_id INTEGER, metadata JSON, created_at TIMESTAMP NOT NULL, performed_by INTEGER, balance_before INTEGER NOT NULL, balance_after INTEGER NOT NULL, change_type VARCHAR(30) NOT NULL, change_reason TEXT, performed_by_type VARCHAR(20) NOT NULL);

-- Data for listing_quota_history
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (1, 19, 5, 'system_grant', 'Yeni bireysel üye kaydı - otomatik ilan hakkı', NULL, 'system', 0, 5, NULL, NULL, '"2025-06-16T10:40:03.997Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (2, 20, 9, 'system_grant', 'Yeni kurumsal üye kaydı - otomatik ilan hakkı', NULL, 'system', 0, 9, NULL, NULL, '"2025-06-16T13:19:27.467Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (3, 21, 4, 'system_grant', 'Yeni kurumsal üye kaydı - otomatik ilan hakkı', NULL, 'system', 0, 4, NULL, NULL, '"2025-06-16T13:47:22.676Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (4, 22, 3, 'system_grant', 'Yeni bireysel üye kaydı - otomatik ilan hakkı', NULL, 'system', 0, 3, NULL, NULL, '"2025-06-17T20:38:20.502Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (5, 23, 3, 'system_grant', 'Yeni bireysel üye kaydı - otomatik ilan hakkı', NULL, 'system', 0, 3, NULL, NULL, '"2025-06-19T20:32:47.569Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (6, 23, -1, 'listing_used', 'Ücretsiz ilan hakkı kullanıldı', NULL, 'user', 3, 2, 60, NULL, '"2025-06-19T21:15:32.548Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (7, 23, -1, 'listing_used', 'Ücretsiz ilan hakkı kullanıldı', NULL, 'user', 2, 1, 61, NULL, '"2025-06-19T21:26:40.735Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (8, 23, -1, 'listing_used', 'Ücretsiz ilan hakkı kullanıldı', NULL, 'user', 1, 0, 62, NULL, '"2025-06-20T11:32:31.188Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (9, 24, 4, 'system_grant', 'Yeni kurumsal üye kaydı - otomatik ilan hakkı', NULL, 'system', 0, 4, NULL, NULL, '"2025-06-20T15:16:50.764Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (10, 24, -1, 'listing_used', 'Ücretsiz ilan hakkı kullanıldı', NULL, 'user', 4, 3, 65, NULL, '"2025-06-20T16:58:01.762Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (11, 24, -1, 'listing_used', 'Ücretsiz ilan hakkı kullanıldı', NULL, 'user', 1, 0, 66, NULL, '"2025-06-20T19:15:55.463Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (12, 25, 1, 'system_grant', 'Yeni bireysel üye kaydı - otomatik ilan hakkı', NULL, 'system', 0, 1, NULL, NULL, '"2025-06-22T02:10:49.125Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (13, 26, 1, 'system_grant', 'Yeni bireysel üye kaydı - otomatik ilan hakkı', NULL, 'system', 0, 1, NULL, NULL, '"2025-06-22T02:15:30.445Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (14, 27, 1, 'system_grant', 'Yeni bireysel üye kaydı - otomatik ilan hakkı', NULL, 'system', 0, 1, NULL, NULL, '"2025-06-22T02:25:22.530Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (15, 24, -1, 'listing_used', 'Ücretsiz ilan hakkı kullanıldı', NULL, 'user', 14, 13, 69, NULL, '"2025-06-23T20:42:57.165Z"');
INSERT INTO "listing_quota_history" ("id", "user_id", "quota_change", "change_type", "change_reason", "performed_by", "performed_by_type", "balance_before", "balance_after", "related_listing_id", "metadata", "created_at") VALUES (16, 24, -1, 'listing_used', 'Ücretsiz ilan hakkı kullanıldı', NULL, 'user', 13, 12, 70, NULL, '"2025-06-27T20:57:44.911Z"');


-- Table: listing_settings
CREATE TABLE listing_settings (id INTEGER NOT NULL, watermark_enabled BOOLEAN NOT NULL, updated_at TIMESTAMP NOT NULL, watermark_size INTEGER NOT NULL, watermark_opacity INTEGER NOT NULL, created_at TIMESTAMP NOT NULL, watermark_path VARCHAR(500), watermark_position VARCHAR(50) NOT NULL);

-- Data for listing_settings
INSERT INTO "listing_settings" ("id", "watermark_enabled", "watermark_path", "watermark_opacity", "watermark_position", "created_at", "updated_at", "watermark_size") VALUES (1, TRUE, '/uploads/watermarks/watermark-1750366035824.png', 25, 'center', '"2025-06-19T20:28:42.949Z"', '"2025-06-21T17:15:22.183Z"', 400);


-- Table: listings
CREATE TABLE listings (dopings JSONB, user_id INTEGER NOT NULL, package_id INTEGER NOT NULL, category_id INTEGER NOT NULL, neighborhood_id INTEGER, custom_fields JSON, photos JSON, is_active BOOLEAN NOT NULL, created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP NOT NULL, selected_dopings JSON, id INTEGER NOT NULL, city_id INTEGER NOT NULL, district_id INTEGER NOT NULL, kimden TEXT NOT NULL, contact_preference TEXT NOT NULL, phone TEXT, whatsapp TEXT, instagram TEXT, status TEXT, listing_number TEXT NOT NULL, description TEXT);

-- Data for listings
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (45, 12, 3, 19, 'sahibinden', 'phone', '05454445555', '', '', 6, 10, NULL, '{"3":"3.300.000","7":"12.990","9":"2024","10":"Dizel","13":"Otomatik","14":"Kırmızı","15":"Evet","16":"İkinci El","18":"qweqweqwacıklama"}', '[{"id":"1749780292549-ldl2jgtat","path":"/uploads/listing_photos/202506000006/photo_2.jpg","rotation":0,"order":0,"isCover":true},{"id":"1749780292294-0aglzll5v","path":"/uploads/listing_photos/202506000006/photo_1.jpg","rotation":0,"order":1,"isCover":false},{"id":"1749780291669-k1j71nfhr","path":"/uploads/listing_photos/202506000006/photo_3.jpg","rotation":0,"order":2,"isCover":false},{"id":"1749780492364_u78zdshr05q","path":"/uploads/listing_photos/202506000006/1749780500658-opyigsg8bwn.jpg","rotation":0,"order":3,"isCover":false}]', TRUE, '"2025-06-13T02:07:48.965Z"', '"2025-06-13T11:26:52.569Z"', '[1,2]', 'pending', '202506000006', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (44, 11, 1, 19, 'galeriden', 'phone', '05454445555', '05443333333', 'vereaade', 1, 2, NULL, '{"3":"1.650.000","7":"10.000","9":"2020","10":"Benzin","13":"Otomatik","14":"Beyaz","15":"Hayır","16":"İkinci El","18":"qweqwe qweqweqweqwe1"}', '[{"id":"1749780108977_p84jk034yfi","path":"/uploads/listing_photos/202506000005/1749780117219-mf2463xomvg.jpg","rotation":0,"order":0,"isCover":true},{"id":"1749778484002-7yc7shis2","path":"/uploads/listing_photos/202506000005/photo_1.jpg","rotation":0,"order":1,"isCover":false},{"id":"1749778482367-5n4giw73d","path":"/uploads/listing_photos/202506000005/photo_2.jpg","rotation":0,"order":2,"isCover":false},{"id":"1749778483282-576d6twvu","path":"/uploads/listing_photos/202506000005/photo_3.jpg","rotation":0,"order":3,"isCover":false},{"id":"1749780108023_mrg498jzxzd","path":"/uploads/listing_photos/202506000005/1749780116839-vn8fso5wnw.jpg","rotation":0,"order":4,"isCover":false}]', TRUE, '"2025-06-13T01:35:00.539Z"', '"2025-06-13T11:26:54.172Z"', '[]', 'pending', '202506000005', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (46, 9, 1, 19, 'sahibinden', 'phone', '05555555555', '05444444444', 'rindamin_45', 1, 3, NULL, '{"3":"2.500.000","7":"25.000","9":"2024","10":"Dizel","13":"Otomatik","14":"Kırmızı","15":"Evet","16":"İkinci El","18":"qweqweqweqweqwe","kimden":"sahibinden"}', '[{"id":"1749819229370-avsjh4dlg","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/e0b17620-ab19-4962-8340-5b58c8b50804","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000007/photo_1.jpg"},{"id":"1749819230361-01ggv5e9t","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/4e4b7c88-2587-4789-98d4-47076662c22e","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000007/photo_2.jpg"},{"id":"1749819231070-wgw04rn2o","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/a58e17e4-ca71-4927-b3fd-cd4a55f2fe21","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000007/photo_3.jpg"}]', TRUE, '"2025-06-13T12:54:21.297Z"', '"2025-06-13T12:54:21.297Z"', '[1,2]', 'pending', '202506000007', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (48, 14, 1, 19, 'sahibinden', 'phone', '05555555555', '05443333333', 'rindamin_45', 6, 10, NULL, '{"3":"1.000.000","7":"1.000","9":"2024","10":"Dizel","13":"Otomatik","14":"Kırmızı","15":"Evet","16":"İkinci El","18":"qweqweqweqweqweqweqwe","kimden":"sahibinden"}', '[{"id":"1749914928432-av5tlm42h","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/d66466c6-76c5-434b-9930-be6cab9cc46c","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000009/photo_1.jpg"},{"id":"1749914928759-d4pqxfve9","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/5c46095f-6cf2-45ae-823c-287101fd2745","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000009/photo_2.jpg"},{"id":"1749914927412-ob1z53u4g","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/01bd9127-76d4-4698-869f-b6637e43e930","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000009/photo_3.jpg"}]', TRUE, '"2025-06-14T15:29:16.672Z"', '"2025-06-15T12:21:58.381Z"', '[1,2]', 'active', '202506000009', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (49, 17, 1, 19, 'galeriden', 'phone', '05555555555', NULL, NULL, 6, 10, NULL, '{"3":"6.000.000","7":"20.020","9":"2021","10":"Benzin","13":"Otomatik","14":"Beyaz","15":"Hayır","16":"İkinci El","18":"qweqweqw eqwe qweqweqwe","kimden":"galeriden"}', '[{"id":"1749993240072-8lum15bsi","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/e88f9724-1718-4777-a629-94b44adae130","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000010/photo_1.jpg"},{"id":"1749993239305-7xbhjbruy","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/9f7864a4-cf86-4482-85f9-2df8cd44fbbb","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000010/photo_2.jpg"},{"id":"1749993238540-l5hza9ngz","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/a8a992b4-8645-4cc0-9c90-d43c3601ff53","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000010/photo_3.jpg"},{"id":"1749993237642-swsp2tmg6","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/43d5964e-bcae-4834-812d-647f23ea3848","rotation":0,"order":3,"isCover":false,"path":"/uploads/listing_photos/202506000010/photo_4.jpg"}]', TRUE, '"2025-06-15T13:14:32.481Z"', '"2025-06-15T14:09:30.076Z"', '[1,2]', 'active', '202506000010', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (62, 23, 1, 19, 'sahibinden', 'phone', '05555555555', '', '', 1, 1, NULL, '{"3":"123.123","7":"123.123","9":"2022","10":"Benzin","13":"Otomatik","14":"Beyaz","15":"Evet","16":"İkinci El","20":"123123","21":"123122","description":"qweqweqwe qweqweqw açıklama\nuzunnnn açıklama\nlaerwlwerlqwlelwqe"}', '[{"id":"1750419093896-gqy2pz43t","path":"/uploads/listing_photos/202506000023/optimized_photo_1.jpg","rotation":0,"order":0,"isCover":true},{"id":"1750419094221-75u0585sq","path":"/uploads/listing_photos/202506000023/optimized_photo_2.jpg","rotation":0,"order":1,"isCover":false},{"id":"1750419092963-31t3aptwk","path":"/uploads/listing_photos/202506000023/optimized_photo_3.jpg","rotation":0,"order":2,"isCover":false}]', TRUE, '"2025-06-20T11:32:31.071Z"', '"2025-06-20T11:53:24.079Z"', '[]', 'preparing', '202506000023', 'sdfsdfsdf123123123', '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (70, 24, 1, 37, 'galeriden', 'phone', '05555555555', '', '', 6, 10, NULL, '{"3":"1.300.000","7":"12.300","9":"2023","10":"Benzin","13":"Otomatik","14":"Bordo","15":"Hayır","16":"İkinci El","20":"2344","21":"234","description":"werwerwer"}', '[{"id":"1751057848673-u9bubv7n6","path":"/uploads/listing_photos/202506000029/optimized_photo_1.jpg","rotation":0,"order":0,"isCover":true},{"id":"1751057848211-adltjel4g","path":"/uploads/listing_photos/202506000029/optimized_photo_2.jpg","rotation":0,"order":1,"isCover":false},{"id":"1751057847274-9ivv64ow5","path":"/uploads/listing_photos/202506000029/optimized_photo_3.jpg","rotation":0,"order":2,"isCover":false}]', TRUE, '"2025-06-27T20:57:44.821Z"', '"2025-06-27T20:59:30.907Z"', '[]', 'active', '202506000029', 'werwerwer', '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (51, 17, 1, 37, 'galeriden', 'phone', '', '', '', 1, 1, NULL, '{"18":"werwqerqwerqwer"}', '[]', TRUE, '"2025-06-16T12:47:51.610Z"', '"2025-06-16T13:26:45.333Z"', '[]', 'pending', '202506000012', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (50, 18, 1, 19, 'galeriden', 'phone', '01111111111', '', '', 6, 10, NULL, '{"3":"3.999.999","7":"54.665","9":"2022","10":"Benzin","13":"Otomatik","14":"Bej","15":"Evet","16":"İkinci El","18":"ertertertertertert"}', '[{"id":"1750019824639_gwh6wnbp2qf","path":"/uploads/listing_photos/202506000011/1750019833436-aermrwlgml5.jpg","rotation":0,"order":0,"isCover":true},{"id":"1750019825669_dhwzc8vykga","path":"/uploads/listing_photos/202506000011/1750019834138-bndvprn1k5h.jpg","rotation":0,"order":1,"isCover":false},{"id":"1750019826388_sselnithklh","path":"/uploads/listing_photos/202506000011/1750019835910-esudk7vgv6a.jpg","rotation":0,"order":2,"isCover":false}]', TRUE, '"2025-06-15T20:30:44.475Z"', '"2025-06-19T11:16:57.188Z"', '[1,2]', 'active', '202506000011', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (54, 21, 1, 19, 'galeriden', 'phone', '05555555556', '', '', 6, 10, NULL, '{"3":"3.400.000","7":"32.230","9":"2024","10":"Hibrit","13":"Otomatik","14":"Beyaz","15":"Evet","16":"İkinci El","18":"Sahibinden emsalsiz.","20":"3.000","21":"320"}', '[{"id":"1750092794799_nyn8exx8af","path":"/uploads/listing_photos/202506000015/1750092803209-i7k3atuka7.jpg","rotation":0,"order":0,"isCover":true},{"id":"1750092793678_9e6fv7j3awv","path":"/uploads/listing_photos/202506000015/1750092802461-azi9k7xsul6.jpg","rotation":0,"order":1,"isCover":false},{"id":"1750092795590_g6nbsm1ggzt","path":"/uploads/listing_photos/202506000015/1750092804884-rrdtn5ey48.jpg","rotation":0,"order":2,"isCover":false},{"id":"1750092797228_ghwzh8g4zyt","path":"/uploads/listing_photos/202506000015/1750092805536-zk2w2o1a2r7.jpg","rotation":0,"order":3,"isCover":false}]', TRUE, '"2025-06-16T16:53:07.343Z"', '"2025-06-16T17:15:49.787Z"', '[]', 'active', '202506000015', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (52, 17, 1, 19, 'galeriden', 'phone', '05454445556', NULL, NULL, 1, 2, NULL, '{"3":"6.500.000","7":"36.777","9":"2024","10":"Dizel","13":"Otomatik","14":"Kırmızı","15":"Evet","16":"İkinci El","18":"emsalsiz boyasız","kimden":"galeriden"}', '[{"id":"1750079865217-plnhmhoxl","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/acb087b8-4251-429f-a829-1ff93ff2cf0b","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000013/photo_1.jpg"},{"id":"1750079864066-hsorht09s","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/bdcb3a53-596b-4217-bfbb-16d6ec063ba4","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000013/photo_2.jpg"},{"id":"1750079866395-nrdk7c3a5","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/ce263e3a-24f0-495b-8957-d77a17e21b77","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000013/photo_3.jpg"},{"id":"1750079868063-5sz8badf9","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/00dc7e2a-7904-478f-8cdf-10ee8d2e4f2e","rotation":0,"order":3,"isCover":false,"path":"/uploads/listing_photos/202506000013/photo_4.jpg"},{"id":"1750079869129-l1kmkxsdl","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/806743f5-91e0-4206-a97c-b128dcd1bd03","rotation":0,"order":4,"isCover":false,"path":"/uploads/listing_photos/202506000013/photo_5.jpg"}]', TRUE, '"2025-06-16T13:18:30.203Z"', '"2025-06-16T16:09:08.250Z"', '[]', 'preparing', '202506000013', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (53, 21, 1, 19, 'galeriden', 'phone', '05555555555', '', '', 1, 3, NULL, '{"3":"1.000.000","7":"1.000","9":"2024","10":"Dizel","13":"Otomatik","14":"Beyaz","15":"Evet","16":"İkinci El","18":"acıklamaaaasdasdasdasd"}', '[{"id":"1750081716320-95k4koon9","path":"/uploads/listing_photos/202506000014/photo_1.jpg","rotation":0,"order":0,"isCover":true},{"id":"1750081715862-7bor5mwsp","path":"/uploads/listing_photos/202506000014/photo_2.jpg","rotation":0,"order":1,"isCover":false},{"id":"1750081714923-ala6igvy9","path":"/uploads/listing_photos/202506000014/photo_3.jpg","rotation":0,"order":2,"isCover":false}]', TRUE, '"2025-06-16T13:48:57.374Z"', '"2025-06-16T16:29:46.499Z"', '[]', 'active', '202506000014', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (55, 22, 1, 19, 'sahibinden', 'phone', '05422212121', NULL, NULL, 1, 2, NULL, '{"3":"5.200.000","7":"19.000","9":"2024","10":"Benzin","13":"Otomatik","14":"Beyaz","15":"Evet","16":"İkinci El","18":"hdhdhdhhdhd","20":"2.200","21":"340","kimden":"sahibinden"}', '[{"id":"1750192817677-z08mfv6qt","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/a4655d04-e79b-4a62-997c-207ab1755129","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000016/photo_1.jpg"},{"id":"1750192818928-olke3aske","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/5cbf580b-b800-489b-ba47-331aad803b8d","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_2.jpg"},{"id":"1750192819302-sacopcg7v","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/b224d676-c883-43f1-b8fd-c43832674fe1","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_3.jpg"},{"id":"1750192819536-6as9g7lne","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/d84f4899-ddf9-4a26-b5fa-26e794d42a7c","rotation":0,"order":3,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_4.jpg"},{"id":"1750192819766-mj7j6iggs","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/41d2b40c-e244-4139-b923-c35da74c7ead","rotation":0,"order":4,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_5.jpg"},{"id":"1750192819995-pj3soqoo5","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/f3707c06-b08b-433c-9aa1-88dd4eb34b14","rotation":0,"order":5,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_6.jpg"},{"id":"1750192820248-qjpyecgkx","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/9a3c4a99-2d2d-44c8-b0e0-08a2751e8bfe","rotation":0,"order":6,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_7.jpg"},{"id":"1750192821406-7p1p678fx","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/76feb4d6-d1ff-471c-bcd5-9451a6678d3b","rotation":0,"order":7,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_8.jpg"},{"id":"1750192820936-urf3cc9z6","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/1722d10e-4445-4ce9-bd67-cafba59d9d61","rotation":0,"order":8,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_9.jpg"},{"id":"1750192820468-jtmaoy1q6","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/c3b032e9-9225-4d91-a91d-bb374541afc9","rotation":0,"order":9,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_10.jpg"},{"id":"1750192820703-s2zns9kux","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/e4a3bc88-bfe9-42ba-8d3b-22dde7fec709","rotation":0,"order":10,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_11.jpg"},{"id":"1750192821164-zvj077yuj","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/dc47e0a9-0448-4471-8c1b-1fa3fdca6fdf","rotation":0,"order":11,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_12.jpg"},{"id":"1750192821628-nihl2azps","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/42681faf-5929-49c1-9d2c-caabc8e36cb7","rotation":0,"order":12,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_13.jpg"},{"id":"1750192821864-godlz0sss","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/a2adcb3d-4699-4005-9ec4-d99fa2e4aa4a","rotation":0,"order":13,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_14.jpg"},{"id":"1750192822079-yee1xsn3m","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/ec945778-ba69-491f-8d63-f9512895fcbe","rotation":0,"order":14,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_15.jpg"},{"id":"1750192822286-fb7fdocvw","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/ae0a5415-8b91-4ee3-9b88-517835c9f531","rotation":0,"order":15,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_16.jpg"},{"id":"1750192822509-xcv4tj83q","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/2432b928-405e-4da5-97e0-4d33e1abc5b3","rotation":0,"order":16,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_17.jpg"},{"id":"1750192822725-o7hn7bm3c","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/3a1c8f70-91cf-4418-bc1b-782cb1d22e9a","rotation":0,"order":17,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_18.jpg"},{"id":"1750192822951-9zqxtbk94","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/a6175644-a2ea-4c3c-a080-1888c2619c3e","rotation":0,"order":18,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_19.jpg"},{"id":"1750192823155-pgji9uohn","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/919beffb-d315-48d8-9b97-c92855fee8f8","rotation":0,"order":19,"isCover":false,"path":"/uploads/listing_photos/202506000016/photo_20.jpg"}]', TRUE, '"2025-06-17T20:41:00.963Z"', '"2025-06-17T20:41:20.574Z"', '[]', 'active', '202506000016', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (56, 23, 1, 19, 'sahibinden', 'phone', '05423363737', NULL, NULL, 6, 10, NULL, '{"3":"5.000.000","7":"43.004","9":"2020","10":"Benzin & LPG","13":"Otomatik","14":"Bej","15":"Evet","16":"İkinci El","18":"qweqweqweqwe qwe qweqweqw eqweqwe","20":"3.000","21":"300","kimden":"sahibinden"}', '[{"id":"1750365250745-qd16z18hm","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/cdc2df0d-7180-408e-beb1-08a1fff3f30c","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000017/optimized_photo_1.jpg","originalPath":"/uploads/listing_photos/202506000017/original_photo_1.jpg"},{"id":"1750365248907-5v0ewi97q","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/181f6ed1-dade-420e-b98e-3fdb293248bc","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000017/optimized_photo_2.jpg","originalPath":"/uploads/listing_photos/202506000017/original_photo_2.jpg"},{"id":"1750365246899-auq8iqilw","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/e0522f5e-39f9-440e-8b4e-e9a136027c03","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000017/optimized_photo_3.jpg","originalPath":"/uploads/listing_photos/202506000017/original_photo_3.jpg"},{"id":"1750365247858-5xkuj6l1u","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/7b0ef371-ca84-46d4-b055-5575af81d29a","rotation":0,"order":3,"isCover":false,"path":"/uploads/listing_photos/202506000017/optimized_photo_4.jpg","originalPath":"/uploads/listing_photos/202506000017/original_photo_4.jpg"}]', TRUE, '"2025-06-19T20:34:40.507Z"', '"2025-06-19T20:35:15.356Z"', '[]', 'active', '202506000017', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (57, 23, 1, 19, 'sahibinden', 'phone', '05423363737', NULL, NULL, 6, 10, NULL, '{"3":"2.500.000","7":"23.304","9":"2024","10":"Dizel","13":"Otomatik","14":"Kırmızı","15":"Evet","16":"İkinci El","18":"qweqweqweqweqwe","20":"2.200","21":"233","kimden":"sahibinden"}', '[{"id":"1750366111408-m1bcbc975","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/70e49448-9fbf-4d56-878c-b0a4c5c913d1","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000018/optimized_photo_1.jpg","originalPath":"/uploads/listing_photos/202506000018/original_photo_1.jpg"},{"id":"1750366111736-2xf6odjqm","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/d045948b-58d0-4946-be5a-dc8153c824e8","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000018/optimized_photo_2.jpg","originalPath":"/uploads/listing_photos/202506000018/original_photo_2.jpg"},{"id":"1750366110393-fdirw4rk3","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/76fda9e1-8cdb-4a2f-a088-954214ca7c50","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000018/optimized_photo_3.jpg","originalPath":"/uploads/listing_photos/202506000018/original_photo_3.jpg"}]', TRUE, '"2025-06-19T20:48:48.075Z"', '"2025-06-19T20:48:48.075Z"', '[]', 'pending', '202506000018', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (58, 23, 1, 19, 'sahibinden', 'phone', '05423363737', NULL, NULL, 1, 2, NULL, '{"3":"2.342.343","7":"234.234","9":"2022","10":"Benzin","13":"Otomatik","14":"Bej","15":"Evet","16":"İkinci El","18":"werwerwer","20":"333","21":"423423","kimden":"sahibinden"}', '[{"id":"1750366681236-19f766bfo","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/7bdb7cbc-fc8b-4b42-bbbd-5a5455d2b504","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000019/optimized_photo_1.jpg","originalPath":"/uploads/listing_photos/202506000019/original_photo_1.jpg"},{"id":"1750366682001-tdf1c0dwq","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/57f0fc07-0264-4644-9e28-91f5ce797baf","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000019/optimized_photo_2.jpg","originalPath":"/uploads/listing_photos/202506000019/original_photo_2.jpg"},{"id":"1750366682266-wfy4ve197","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/79664b63-de48-44c3-9ed1-a899a9256360","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000019/optimized_photo_3.jpg","originalPath":"/uploads/listing_photos/202506000019/original_photo_3.jpg"},{"id":"1750366693738-tp638fn36","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/9862d404-6a71-4659-885b-8482c4c8a1e3","rotation":0,"order":3,"isCover":false,"path":"/uploads/listing_photos/202506000019/optimized_photo_4.jpg","originalPath":"/uploads/listing_photos/202506000019/original_photo_4.jpg"}]', TRUE, '"2025-06-19T20:58:35.105Z"', '"2025-06-19T20:59:49.302Z"', '[2]', 'active', '202506000019', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (59, 23, 1, 19, 'sahibinden', 'phone', '05423363737', NULL, NULL, 1, 2, NULL, '{"3":"4.555.555","7":"5.345.345","9":"2022","10":"Hibrit","13":"Otomatik","14":"Beyaz","15":"Hayır","16":"İkinci El","18":"werwerwer","20":"23.423","21":"234","kimden":"sahibinden"}', '[]', TRUE, '"2025-06-19T21:03:39.059Z"', '"2025-06-19T21:03:39.059Z"', '[]', 'pending', '202506000020', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (60, 23, 1, 19, 'sahibinden', 'phone', '05423363737', NULL, NULL, 6, 10, NULL, '{"3":"345.345","7":"345.345","9":"2024","10":"Benzin","13":"Otomatik","14":"Beyaz","15":"Evet","16":"İkinci El","18":"werwerw","20":"23.423","21":"34234","kimden":"sahibinden"}', '[]', TRUE, '"2025-06-19T21:15:32.423Z"', '"2025-06-19T21:15:32.423Z"', '[]', 'pending', '202506000021', NULL, '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (61, 23, 1, 19, 'sahibinden', 'phone', '05423363737', '', '', 6, 10, NULL, '{"3":"4.345.345","7":"345.534","9":"2021","10":"Benzin","13":"Otomatik","14":"Bej","15":"Evet","16":"İkinci El","18":"werwerwer","20":"2.345","21":"455"}', '[{"id":"1750368383419-uxm06kf20","path":"/uploads/listing_photos/202506000022/optimized_photo_1.jpg","rotation":0,"order":0,"isCover":true},{"id":"1750368384382-40l63juhn","path":"/uploads/listing_photos/202506000022/optimized_photo_2.jpg","rotation":0,"order":1,"isCover":false},{"id":"1750368385084-7w2rfxkcx","path":"/uploads/listing_photos/202506000022/optimized_photo_3.jpg","rotation":0,"order":2,"isCover":false}]', TRUE, '"2025-06-19T21:26:40.598Z"', '"2025-06-20T12:12:48.225Z"', '[]', 'active', '202506000022', 'qweqweqwe', '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (63, 23, 1, 19, 'sahibinden', 'phone', '05555555555', '', '', 1, 3, NULL, '{"3":"3.453.455","7":"34.555","9":"2020","10":"Benzin & LPG","13":"Otomatik","14":"Bej","15":"Evet","16":"İkinci El","20":"123123","21":"2312","description":"1231231wqeqweqweqweqweqweqw eqwe qweq weqwe"}', '[{"id":"1750420183039-tcqeaw8b7","path":"/uploads/listing_photos/202506000024/optimized_photo_1.jpg","rotation":0,"order":0,"isCover":true},{"id":"1750420184128-2qdswhvhq","path":"/uploads/listing_photos/202506000024/optimized_photo_2.jpg","rotation":0,"order":1,"isCover":false},{"id":"1750420184846-7lp227ekg","path":"/uploads/listing_photos/202506000024/optimized_photo_3.jpg","rotation":0,"order":2,"isCover":false},{"id":"1750420186485-mp7f8ir4r","path":"/uploads/listing_photos/202506000024/optimized_photo_4.jpg","rotation":0,"order":3,"isCover":false}]', TRUE, '"2025-06-20T11:50:05.491Z"', '"2025-06-20T12:09:23.558Z"', '[2]', 'preparing', '202506000024', '1231231wqeqweqweqweqweqweqw eqwe qweq weqwe55656', '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (64, 23, 1, 19, 'sahibinden', 'phone', '05555555555', NULL, NULL, 6, 10, NULL, '{"3":"3.243.444","7":"2.344.234","9":"2024","10":"Benzin","13":"Otomatik","14":"Beyaz","15":"Evet","16":"İkinci El","20":"111","21":"1111","kimden":"sahibinden","description":"qweqweq"}', '[{"id":"1750432459527-h366xpizu","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/280a844f-a050-4319-9d8b-4b9d9a46887b","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000025/optimized_photo_1.jpg","originalPath":"/uploads/listing_photos/202506000025/original_photo_1.jpg"},{"id":"1750432460703-hi77wph1p","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/7803e164-7327-42ef-a180-508f9582cd06","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000025/optimized_photo_2.jpg","originalPath":"/uploads/listing_photos/202506000025/original_photo_2.jpg"},{"id":"1750432461114-1fhdgrvu6","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/9868b7e6-172a-4480-900f-2db8bd2595b1","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000025/optimized_photo_3.jpg","originalPath":"/uploads/listing_photos/202506000025/original_photo_3.jpg"}]', TRUE, '"2025-06-20T15:14:47.328Z"', '"2025-06-20T15:22:48.680Z"', '[2,1]', 'active', '202506000025', 'qweqweq', '[]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (65, 24, 1, 19, 'galeriden', 'phone', '05555555555', NULL, NULL, 6, 10, NULL, '{"3":"9.990.000","7":"766.766","9":"2020","10":"Benzin & LPG","13":"Otomatik","14":"Bej","15":"Evet","16":"İkinci El","20":"9998","21":"99888","kimden":"galeriden","description":"jhjhhjgghjhjg"}', '[{"id":"1750438656726-gjaf6eij6","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/9858fed5-75d4-4f93-abe1-4a85b4ee4b23","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000026/optimized_photo_1.jpg","originalPath":"/uploads/listing_photos/202506000026/original_photo_1.jpg"},{"id":"1750438657063-dwwp2m6vp","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/50ba15d8-06da-4a85-ae6c-9e535b19d5f7","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000026/optimized_photo_2.jpg","originalPath":"/uploads/listing_photos/202506000026/original_photo_2.jpg"},{"id":"1750438655756-fvpjmyybk","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/b20fbe58-1e08-44cd-b256-44fc692be950","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000026/optimized_photo_3.jpg","originalPath":"/uploads/listing_photos/202506000026/original_photo_3.jpg"}]', TRUE, '"2025-06-20T16:58:01.645Z"', '"2025-06-20T17:09:40.659Z"', '[2,1]', 'published', '202506000026', 'jhjhhjgghjhjg', '["öne çıkanlar","acil"]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (66, 24, 1, 19, 'galeriden', 'phone', '05555555555', NULL, NULL, 6, 10, NULL, '{"3":"11.111.111","7":"12.312","9":"2021","10":"Benzin & LPG","13":"Otomatik","14":"Bej","15":"Evet","16":"İkinci El","20":"123123","21":"12312","kimden":"galeriden","description":"qweqweqwe"}', '[{"id":"1750446935916-v6rzml89e","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/1359c23d-6b24-4058-bad8-4fa71943227c","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000027/optimized_photo_1.jpg","originalPath":"/uploads/listing_photos/202506000027/original_photo_1.jpg"},{"id":"1750446934914-1ou6pb47i","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/c7090453-f9c7-4df6-bf86-c9d99f06dd04","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000027/optimized_photo_2.jpg","originalPath":"/uploads/listing_photos/202506000027/original_photo_2.jpg"},{"id":"1750446935639-z2mhvvvc4","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/e716e245-ba92-46ae-93d2-17a9611902c3","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000027/optimized_photo_3.jpg","originalPath":"/uploads/listing_photos/202506000027/original_photo_3.jpg"}]', TRUE, '"2025-06-20T19:15:55.388Z"', '"2025-06-20T19:16:02.983Z"', '[1,2]', 'active', '202506000027', 'qweqweqwe', '["acil"]');
INSERT INTO "listings" ("id", "user_id", "package_id", "category_id", "kimden", "contact_preference", "phone", "whatsapp", "instagram", "city_id", "district_id", "neighborhood_id", "custom_fields", "photos", "is_active", "created_at", "updated_at", "selected_dopings", "status", "listing_number", "description", "dopings") VALUES (69, 24, 1, 19, 'galeriden', 'phone', '05555555555', NULL, NULL, 1, 2, NULL, '{"3":"1.600.000","7":"19.000","9":"2020","10":"Dizel","13":"Otomatik","14":"Kırmızı","15":"Evet","16":"İkinci El","20":"2600","21":"330","kimden":"galeriden","description":"Sahibinden Emsali Eşi Benzeri Yok...."}', '[{"id":"1750711355428-19v8gwcz8","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/47af6e9b-172b-45f5-ac24-8707fef73445","rotation":0,"order":0,"isCover":true,"path":"/uploads/listing_photos/202506000028/optimized_photo_1.jpg","originalPath":"/uploads/listing_photos/202506000028/original_photo_1.jpg"},{"id":"1750711356357-5oucnnnu0","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/a93dae88-6306-448f-9a36-71cadb67a230","rotation":0,"order":1,"isCover":false,"path":"/uploads/listing_photos/202506000028/optimized_photo_2.jpg","originalPath":"/uploads/listing_photos/202506000028/original_photo_2.jpg"},{"id":"1750711357073-xipweoq9l","preview":"blob:https://6b6febba-2441-4243-9451-0ea32b2a131f-00-394jhnapqbjgz.riker.replit.dev/06bf5328-4623-4ee2-b993-818b9c8a22f3","rotation":0,"order":2,"isCover":false,"path":"/uploads/listing_photos/202506000028/optimized_photo_3.jpg","originalPath":"/uploads/listing_photos/202506000028/original_photo_3.jpg"}]', TRUE, '"2025-06-23T20:42:57.089Z"', '"2025-06-23T20:43:44.790Z"', '[2,1]', 'active', '202506000028', 'Sahibinden Emsali Eşi Benzeri Yok....', '["öne çıkanlar"]');


-- Table: neighborhoods
CREATE TABLE neighborhoods (id INTEGER NOT NULL, district_id INTEGER NOT NULL, sort_order INTEGER, created_at TIMESTAMP, updated_at TIMESTAMP, name TEXT NOT NULL, slug TEXT NOT NULL, status TEXT NOT NULL);

-- Data for neighborhoods
INSERT INTO "neighborhoods" ("id", "district_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (5, 4, 'Kızılay', 'kizilay', 'active', 1, '"2025-06-08T10:05:57.692Z"', '"2025-06-08T10:05:57.692Z"');
INSERT INTO "neighborhoods" ("id", "district_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (6, 4, 'Bahçelievler', 'bahcelievler', 'active', 2, '"2025-06-08T10:05:57.692Z"', '"2025-06-08T10:05:57.692Z"');
INSERT INTO "neighborhoods" ("id", "district_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (7, 4, 'Fenerbahçe', 'fenerbahce', 'active', 0, '"2025-06-08T10:37:28.258Z"', '"2025-06-08T10:37:28.258Z"');
INSERT INTO "neighborhoods" ("id", "district_id", "name", "slug", "status", "sort_order", "created_at", "updated_at") VALUES (8, 8, 'Singapur', 'singapur', 'active', 0, '"2025-06-08T10:40:03.367Z"', '"2025-06-08T10:40:03.367Z"');


-- Table: package_categories
CREATE TABLE package_categories (id INTEGER NOT NULL, package_id INTEGER NOT NULL, category_id INTEGER NOT NULL, created_at TIMESTAMP NOT NULL);

-- Data for package_categories
INSERT INTO "package_categories" ("id", "package_id", "category_id", "created_at") VALUES (32, 3, 14, '"2025-06-16T13:16:09.398Z"');
INSERT INTO "package_categories" ("id", "package_id", "category_id", "created_at") VALUES (33, 3, 15, '"2025-06-16T13:16:09.398Z"');
INSERT INTO "package_categories" ("id", "package_id", "category_id", "created_at") VALUES (34, 3, 26, '"2025-06-16T13:16:09.398Z"');
INSERT INTO "package_categories" ("id", "package_id", "category_id", "created_at") VALUES (35, 3, 28, '"2025-06-16T13:16:09.398Z"');
INSERT INTO "package_categories" ("id", "package_id", "category_id", "created_at") VALUES (36, 3, 29, '"2025-06-16T13:16:09.398Z"');
INSERT INTO "package_categories" ("id", "package_id", "category_id", "created_at") VALUES (37, 1, 14, '"2025-06-20T10:52:39.466Z"');
INSERT INTO "package_categories" ("id", "package_id", "category_id", "created_at") VALUES (38, 1, 15, '"2025-06-20T10:52:39.466Z"');


-- Table: packages
CREATE TABLE packages (id INTEGER NOT NULL, sort_order INTEGER NOT NULL, created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP NOT NULL, show_instagram_field BOOLEAN NOT NULL, show_whatsapp_field BOOLEAN NOT NULL, is_free_quota_eligible BOOLEAN NOT NULL, is_active BOOLEAN NOT NULL, name TEXT NOT NULL, slug TEXT NOT NULL, description TEXT, price TEXT NOT NULL, enabled_fields _text[], features _text[]);

-- Data for packages
INSERT INTO "packages" ("id", "name", "slug", "description", "price", "is_active", "features", "enabled_fields", "sort_order", "created_at", "updated_at", "show_instagram_field", "show_whatsapp_field", "is_free_quota_eligible") VALUES (3, 'Web', 'webde-ilan', NULL, '9.99', TRUE, NULL, '["6","3","19","7","9","10","13","14","15","16","17","18"]', 0, '"2025-06-08T14:14:44.414Z"', '"2025-06-16T13:16:09.111Z"', FALSE, FALSE, FALSE);
INSERT INTO "packages" ("id", "name", "slug", "description", "price", "is_active", "features", "enabled_fields", "sort_order", "created_at", "updated_at", "show_instagram_field", "show_whatsapp_field", "is_free_quota_eligible") VALUES (1, 'Instagram', 'instagram-webde-ilan', 'İlanınız hem instagram''da hem de websitede yayınlanır.', '199', TRUE, '["Instagram''da yayın","Webde yayın"]', '["3","14","15","16","17","18","21","20"]', 0, '"2025-06-08T12:33:21.107Z"', '"2025-06-20T10:52:39.147Z"', TRUE, TRUE, TRUE);


-- Table: password_resets
CREATE TABLE password_resets (id INTEGER NOT NULL, expires_at TIMESTAMP NOT NULL, is_used BOOLEAN NOT NULL, created_at TIMESTAMP NOT NULL, email VARCHAR(255) NOT NULL, code VARCHAR(6) NOT NULL);

-- Data for password_resets
INSERT INTO "password_resets" ("id", "email", "code", "expires_at", "is_used", "created_at") VALUES (1, 'test@example.com', '959696', '"2025-06-14T13:23:18.126Z"', FALSE, '"2025-06-14T13:08:18.187Z"');
INSERT INTO "password_resets" ("id", "email", "code", "expires_at", "is_used", "created_at") VALUES (2, 'vedatplesk@gmail.com', '750181', '"2025-06-14T13:31:07.492Z"', TRUE, '"2025-06-14T13:16:07.567Z"');
INSERT INTO "password_resets" ("id", "email", "code", "expires_at", "is_used", "created_at") VALUES (3, 'vedatplesk@gmail.com', '914126', '"2025-06-14T13:32:05.466Z"', FALSE, '"2025-06-14T13:17:05.530Z"');
INSERT INTO "password_resets" ("id", "email", "code", "expires_at", "is_used", "created_at") VALUES (4, 'vedatplesk@gmail.com', '510259', '"2025-06-14T15:12:41.869Z"', FALSE, '"2025-06-14T14:57:41.924Z"');
INSERT INTO "password_resets" ("id", "email", "code", "expires_at", "is_used", "created_at") VALUES (5, 'vedatplesk@gmail.com', '548878', '"2025-06-14T15:13:46.860Z"', FALSE, '"2025-06-14T14:58:46.926Z"');
INSERT INTO "password_resets" ("id", "email", "code", "expires_at", "is_used", "created_at") VALUES (6, 'vedatplesk@gmail.com', '793467', '"2025-06-14T15:42:34.047Z"', TRUE, '"2025-06-14T15:27:34.104Z"');


-- Table: system_settings
CREATE TABLE system_settings (id INTEGER NOT NULL, created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP NOT NULL, data_type VARCHAR(20) NOT NULL, description TEXT, setting_key VARCHAR(100) NOT NULL, setting_value TEXT NOT NULL);

-- Data for system_settings
INSERT INTO "system_settings" ("id", "setting_key", "setting_value", "description", "data_type", "created_at", "updated_at") VALUES (1, 'default_individual_quota', '1', 'Yeni bireysel üyelere otomatik verilecek ücretsiz ilan hakkı', 'number', '"2025-06-16T10:08:47.855Z"', '"2025-06-20T18:35:25.444Z"');
INSERT INTO "system_settings" ("id", "setting_key", "setting_value", "description", "data_type", "created_at", "updated_at") VALUES (2, 'default_corporate_quota', '1', 'Yeni kurumsal üyelere otomatik verilecek ücretsiz ilan hakkı', 'number', '"2025-06-16T10:08:47.855Z"', '"2025-06-20T18:35:25.512Z"');
INSERT INTO "system_settings" ("id", "setting_key", "setting_value", "description", "data_type", "created_at", "updated_at") VALUES (3, 'free_listing_duration_days', '25', 'Ücretsiz ilanların yayında kalma süresi (gün)', 'number', '"2025-06-16T10:08:47.855Z"', '"2025-06-20T18:35:25.580Z"');
INSERT INTO "system_settings" ("id", "setting_key", "setting_value", "description", "data_type", "created_at", "updated_at") VALUES (4, 'payment_required_when_quota_empty', 'true', 'Ücretsiz ilan hakkı tükendiğinde ödeme zorunlu mu?', 'boolean', '"2025-06-16T10:08:47.855Z"', '"2025-06-20T18:35:25.604Z"');


-- Table: vehicles
CREATE TABLE vehicles (created_at TIMESTAMP, year INTEGER NOT NULL, price INTEGER NOT NULL, mileage INTEGER NOT NULL, user_id INTEGER NOT NULL, category_id INTEGER, id INTEGER NOT NULL, title TEXT NOT NULL, brand TEXT NOT NULL, model TEXT NOT NULL, description TEXT, status TEXT NOT NULL, image_url TEXT);

