-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: PostgreSQL 16.0, compiled by Visual C++ build 1935, 64-bit -- Server OS: -- HeidiSQL Version: 12.5.0.6677 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- Dumping structure for table public.cms_perpages CREATE TABLE IF NOT EXISTS "cms_perpages" ( "id" BIGINT NOT NULL DEFAULT 'nextval(''cms_perpages_id_seq''::regclass)', "page_id" BIGINT NOT NULL, "key" VARCHAR(255) NOT NULL, "type" VARCHAR(255) NOT NULL, "input_type" VARCHAR(255) NOT NULL, "value" TEXT NULL DEFAULT NULL, "note" VARCHAR(255) NULL DEFAULT NULL, "created_at" TIMESTAMP NULL DEFAULT NULL, "updated_at" TIMESTAMP NULL DEFAULT NULL, "label" VARCHAR(255) NULL DEFAULT NULL, PRIMARY KEY ("id"), CONSTRAINT "cms_perpages_page_id_foreign" FOREIGN KEY ("page_id") REFERENCES "pages" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT "cms_perpages_type_check" CHECK ((((type)::text = ANY ((ARRAY['text'::character varying, 'image'::character varying, 'text_image'::character varying])::text[])))), CONSTRAINT "cms_perpages_input_type_check" CHECK ((((input_type)::text = ANY ((ARRAY['text'::character varying, 'image'::character varying, 'textarea'::character varying, 'texteditor'::character varying])::text[])))) ); -- Dumping data for table public.cms_perpages: 17 rows DELETE FROM "cms_perpages"; /*!40000 ALTER TABLE "cms_perpages" DISABLE KEYS */; INSERT INTO "cms_perpages" ("id", "page_id", "key", "type", "input_type", "value", "note", "created_at", "updated_at", "label") VALUES (1, 1, 'home_partners', 'image', 'image', '/storage/files/1/Home/clients.png', NULL, '2024-02-05 14:12:21', '2024-02-13 07:03:11', 'Images Partners'), (2, 6, 'sett_addrs', 'text', 'textarea', 'Ruko Plaza de Lumina, Jl. Perumahan Taman Semanan Indah No.2, RT.3/RW.7, Duri Kosambi, Cengkareng, West Jakarta City, Jakarta 11850', NULL, '2024-02-05 14:12:21', '2024-02-13 07:06:04', 'Address'), (5, 6, 'sett_ig', 'text', 'text', 'https://www.instagram.com/ideincreative', NULL, '2024-02-05 14:12:21', '2024-02-13 07:07:10', 'Link Instagram'), (6, 6, 'sett_tiktok', 'text', 'text', 'https://www.tiktok.com/@ideincreative', NULL, '2024-02-05 14:12:21', '2024-02-13 07:07:27', 'Link Tiktok'), (7, 6, 'sett_linkedin', 'text', 'text', 'https://www.linkedin.com/company/idein-branding-advertising/', NULL, '2024-02-05 14:12:21', '2024-02-13 07:07:50', 'Link Linkedin'), (4, 6, 'sett_phone', 'text', 'text', '+62 812 8909 6672', NULL, '2024-02-05 14:12:21', '2024-02-13 07:40:27', 'Phone'), (17, 3, 'reachus_phone_idn_workshop', 'text', 'text', '+62 815 1994 8846', NULL, '2024-02-05 14:12:21', '2024-02-13 08:48:18', 'Phone Idein Workshop'), (3, 6, 'sett_email', 'text', 'text', 'management@idein.id', NULL, '2024-02-05 14:12:21', '2024-02-13 07:40:27', 'Email'), (9, 2, 'work_bi_image', 'image', 'image', '/storage/files/1/Work/img-hero-work.png', NULL, '2024-02-05 14:12:21', '2024-02-13 07:59:46', 'Brand Identity (hero image)'), (13, 3, 'reachus_addrs_idn_creative', 'text', 'textarea', 'Ruko Plaza de Lumina, Jl. Perumahan Taman Semanan Indah No.2, RT.3/RW.7, Duri Kosambi, Cengkareng, West Jakarta City, Jakarta 11850', NULL, '2024-02-05 14:12:21', '2024-02-13 09:09:12', 'Address Idein Creative & Idein Studio'), (10, 2, 'work_smm_image', 'image', 'image', '/storage/files/1/Work/asset-work-hp.png', NULL, '2024-02-05 14:12:21', '2024-02-13 08:04:55', 'Social Media Management (hero image)'), (12, 2, 'work_pm_image', 'image', 'image', '/storage/files/1/Work/asset-work-005.png', NULL, '2024-02-05 14:12:21', '2024-02-13 08:05:15', 'Performance Marketing (hero image)'), (8, 2, 'work_ccp_image', 'image', 'image', '/storage/files/1/Work/identity.png', NULL, '2024-02-05 14:12:21', '2024-02-13 08:12:39', 'Creative Communication Plan (Images)'), (11, 2, 'work_cm_image', 'image', 'image', '/storage/files/1/Work/asset-work-004.png', NULL, '2024-02-05 14:12:21', '2024-02-13 08:18:13', 'Creative Marketing (hero image)'), (14, 3, 'reachus_email_idn_creative', 'text', 'text', 'management@idein.id', NULL, '2024-02-05 14:12:21', '2024-02-13 08:46:08', 'Email Idein Creative & Idein Studio'), (15, 3, 'reachus_addrs_idn_workshop', 'text', 'textarea', 'Jl Pinang tengah no 67 (samping lapangan, RT.1/RW.8, Semanan, Kec. Kalideres, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta 11850', NULL, '2024-02-05 14:12:21', '2024-02-13 08:46:19', 'Address Idein Workshop'), (16, 3, 'reachus_email_idn_workshop', 'text', 'text', 'idein.workshop@gmail.com', NULL, '2024-02-05 14:12:21', '2024-02-13 08:46:43', 'Email Idein Workshop'); /*!40000 ALTER TABLE "cms_perpages" ENABLE KEYS */; -- Dumping structure for table public.pages CREATE TABLE IF NOT EXISTS "pages" ( "id" BIGINT NOT NULL DEFAULT 'nextval(''pages_id_seq''::regclass)', "code" VARCHAR(255) NOT NULL, "label" VARCHAR(255) NOT NULL, "created_at" TIMESTAMP NULL DEFAULT NULL, "updated_at" TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY ("id"), UNIQUE INDEX "pages_code_unique" ("code") ); -- Dumping data for table public.pages: 6 rows DELETE FROM "pages"; /*!40000 ALTER TABLE "pages" DISABLE KEYS */; INSERT INTO "pages" ("id", "code", "label", "created_at", "updated_at") VALUES (1, 'home', 'Home', '2024-01-19 07:32:52', '2024-01-19 07:32:52'), (2, 'work', 'Work', '2024-01-19 07:32:52', '2024-01-19 07:32:52'), (3, 'reach_us', 'Reach Us', '2024-01-19 07:32:52', '2024-01-19 07:32:52'), (4, 'carreer', 'Carreer', '2024-01-19 07:32:52', '2024-01-19 07:32:52'), (5, 'thoughts', 'Thoughts', '2024-01-19 07:32:52', '2024-01-19 07:32:52'), (6, 'settings', 'Settings', '2024-01-19 07:32:52', '2024-01-19 07:32:52'); /*!40000 ALTER TABLE "pages" ENABLE KEYS */; -- Dumping structure for table public.page_sliders CREATE TABLE IF NOT EXISTS "page_sliders" ( "id" BIGINT NOT NULL DEFAULT 'nextval(''page_sliders_id_seq''::regclass)', "page_id" BIGINT NOT NULL, "group" VARCHAR(255) NOT NULL, "type" VARCHAR(255) NOT NULL, "input_type" VARCHAR(255) NOT NULL, "image" VARCHAR(255) NULL DEFAULT NULL, "text" TEXT NULL DEFAULT NULL, "note" VARCHAR(255) NULL DEFAULT NULL, "created_at" TIMESTAMP NULL DEFAULT NULL, "updated_at" TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY ("id"), CONSTRAINT "page_sliders_page_id_foreign" FOREIGN KEY ("page_id") REFERENCES "pages" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT "page_sliders_type_check" CHECK ((((type)::text = ANY ((ARRAY['text'::character varying, 'image'::character varying, 'text_image'::character varying])::text[])))), CONSTRAINT "page_sliders_input_type_check" CHECK ((((input_type)::text = ANY ((ARRAY['text'::character varying, 'image'::character varying, 'textarea'::character varying, 'texteditor'::character varying])::text[])))) ); -- Dumping data for table public.page_sliders: 65 rows DELETE FROM "page_sliders"; /*!40000 ALTER TABLE "page_sliders" DISABLE KEYS */; INSERT INTO "page_sliders" ("id", "page_id", "group", "type", "input_type", "image", "text", "note", "created_at", "updated_at") VALUES (52, 2, 'work_slider_fifth', 'text_image', 'textarea', '/storage/files/1/Sliders/work/silde4-work-01.png', 'Branding', NULL, '2024-01-29 03:51:41', '2024-01-29 03:51:41'), (53, 2, 'work_slider_fifth', 'text_image', 'textarea', '/storage/files/1/Sliders/work/silde4-work-02.png', 'Graphic Design', NULL, '2024-01-29 03:52:10', '2024-01-29 03:52:10'), (54, 2, 'work_slider_fifth', 'text_image', 'textarea', '/storage/files/1/Sliders/work/silde4-work-03.png', 'Social Media', NULL, '2024-01-29 03:52:29', '2024-01-29 03:52:29'), (55, 2, 'work_slider_fifth', 'text_image', 'textarea', '/storage/files/1/Sliders/work/silde4-work-04.png', 'Finance Collab w/ TERNAKUANG', NULL, '2024-01-29 03:52:58', '2024-01-29 03:52:58'), (56, 2, 'work_slider_fifth', 'text_image', 'textarea', '/storage/files/1/Sliders/work/silde4-work-05.png', 'HR', NULL, '2024-01-29 03:53:20', '2024-01-29 03:53:20'), (58, 2, 'work_incorporating', 'text', 'text', NULL, 'audience segmentation', NULL, '2024-02-01 06:30:18', '2024-02-01 06:30:18'), (48, 4, 'carreer_slider', 'image', 'image', '/storage/files/1/Sliders/carreer/carreer-slide-01.png', NULL, NULL, '2024-01-25 10:13:57', '2024-01-25 10:13:57'), (49, 4, 'carreer_slider', 'image', 'image', '/storage/files/1/Sliders/carreer/carreer-slide-02.png', NULL, NULL, '2024-01-25 10:14:05', '2024-01-25 10:14:05'), (5, 2, 'work_slider_first', 'text', 'text', NULL, 'Creative planning', NULL, '2024-01-25 07:35:47', '2024-01-25 07:35:47'), (7, 2, 'work_slider_first', 'text', 'text', NULL, 'Logo creation', NULL, '2024-01-25 07:36:09', '2024-01-25 07:36:09'), (8, 2, 'work_slider_first', 'text', 'text', NULL, 'to captivating collaterals design', NULL, '2024-01-25 07:36:17', '2024-01-25 07:36:17'), (50, 4, 'carreer_slider', 'image', 'image', '/storage/files/1/Sliders/carreer/carreer-slide-03.png', NULL, NULL, '2024-01-25 10:14:13', '2024-01-25 10:14:13'), (6, 2, 'work_slider_first', 'text', 'text', NULL, 'Concepting', NULL, '2024-01-25 07:35:59', '2024-01-25 07:53:29'), (10, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-01.png', NULL, NULL, '2024-01-25 10:01:50', '2024-01-25 10:01:50'), (11, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-010.png', NULL, NULL, '2024-01-25 10:02:01', '2024-01-25 10:02:01'), (12, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-011.png', NULL, NULL, '2024-01-25 10:02:45', '2024-01-25 10:02:45'), (13, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-012.png', NULL, NULL, '2024-01-25 10:03:00', '2024-01-25 10:03:00'), (14, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-02.png', NULL, NULL, '2024-01-25 10:03:13', '2024-01-25 10:03:13'), (15, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-03.png', NULL, NULL, '2024-01-25 10:03:36', '2024-01-25 10:03:36'), (16, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-010.png', NULL, NULL, '2024-01-25 10:04:50', '2024-01-25 10:04:50'), (17, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-011.png', NULL, NULL, '2024-01-25 10:05:02', '2024-01-25 10:05:02'), (18, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-012.png', NULL, NULL, '2024-01-25 10:05:16', '2024-01-25 10:05:16'), (19, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-02.png', NULL, NULL, '2024-01-25 10:05:33', '2024-01-25 10:05:33'), (20, 2, 'work_slider_second', 'image', 'image', '/storage/files/1/Sliders/work/slide-work-03.png', NULL, NULL, '2024-01-25 10:05:45', '2024-01-25 10:05:45'), (21, 2, 'work_slider_third', 'image', 'image', '/storage/files/1/Sliders/work/slide2-work-01.png', NULL, NULL, '2024-01-25 10:06:03', '2024-01-25 10:06:03'), (22, 2, 'work_slider_third', 'image', 'image', '/storage/files/1/Sliders/work/slide2-work-02.png', NULL, NULL, '2024-01-25 10:06:14', '2024-01-25 10:06:14'), (23, 2, 'work_slider_third', 'image', 'image', '/storage/files/1/Sliders/work/slide2-work-03.png', NULL, NULL, '2024-01-25 10:06:24', '2024-01-25 10:06:24'), (24, 2, 'work_slider_third', 'image', 'image', '/storage/files/1/Sliders/work/slide2-work-04.png', NULL, NULL, '2024-01-25 10:06:44', '2024-01-25 10:06:44'), (25, 2, 'work_slider_third', 'image', 'image', '/storage/files/1/Sliders/work/slide2-work-01.png', NULL, NULL, '2024-01-25 10:07:23', '2024-01-25 10:07:23'), (26, 2, 'work_slider_third', 'image', 'image', '/storage/files/1/Sliders/work/slide2-work-02.png', NULL, NULL, '2024-01-25 10:07:34', '2024-01-25 10:07:34'), (27, 2, 'work_slider_third', 'image', 'image', '/storage/files/1/Sliders/work/slide2-work-03.png', NULL, NULL, '2024-01-25 10:07:47', '2024-01-25 10:07:47'), (28, 2, 'work_slider_third', 'image', 'image', '/storage/files/1/Sliders/work/slide2-work-04.png', NULL, NULL, '2024-01-25 10:07:57', '2024-01-25 10:07:57'), (29, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-00.png', NULL, NULL, '2024-01-25 10:08:37', '2024-01-25 10:08:37'), (30, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-01.png', NULL, NULL, '2024-01-25 10:08:48', '2024-01-25 10:08:48'), (31, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-02.png', NULL, NULL, '2024-01-25 10:08:58', '2024-01-25 10:08:58'), (32, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-03.png', NULL, NULL, '2024-01-25 10:09:09', '2024-01-25 10:09:09'), (33, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-04.png', NULL, NULL, '2024-01-25 10:09:20', '2024-01-25 10:09:20'), (34, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-00.png', NULL, NULL, '2024-01-25 10:10:13', '2024-01-25 10:10:13'), (35, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-01.png', NULL, NULL, '2024-01-25 10:10:24', '2024-01-25 10:10:24'), (36, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-02.png', NULL, NULL, '2024-01-25 10:10:37', '2024-01-25 10:10:37'), (37, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-03.png', NULL, NULL, '2024-01-25 10:10:51', '2024-01-25 10:10:51'), (38, 2, 'work_slider_fourth', 'image', 'image', '/storage/files/1/Sliders/work/slide3-work-04.png', NULL, NULL, '2024-01-25 10:11:02', '2024-01-25 10:11:02'), (39, 3, 'reachus_slider', 'image', 'image', '/storage/files/1/Sliders/reachus/slider-reachus-01.png', NULL, NULL, '2024-01-25 10:11:33', '2024-01-25 10:11:33'), (40, 3, 'reachus_slider', 'image', 'image', '/storage/files/1/Sliders/reachus/slider-reachus-02.png', NULL, NULL, '2024-01-25 10:11:40', '2024-01-25 10:11:40'), (41, 3, 'reachus_slider', 'image', 'image', '/storage/files/1/Sliders/reachus/slider-reachus-01.png', NULL, NULL, '2024-01-25 10:11:48', '2024-01-25 10:11:48'), (42, 3, 'reachus_slider', 'image', 'image', '/storage/files/1/Sliders/reachus/slider-reachus-02.png', NULL, NULL, '2024-01-25 10:11:56', '2024-01-25 10:11:56'), (43, 4, 'carreer_slider', 'image', 'image', '/storage/files/1/Sliders/carreer/carreer-slide-01.png', NULL, NULL, '2024-01-25 10:12:23', '2024-01-25 10:12:23'), (44, 4, 'carreer_slider', 'image', 'image', '/storage/files/1/Sliders/carreer/carreer-slide-02.png', NULL, NULL, '2024-01-25 10:12:35', '2024-01-25 10:12:35'), (45, 4, 'carreer_slider', 'image', 'image', '/storage/files/1/Sliders/carreer/carreer-slide-03.png', NULL, NULL, '2024-01-25 10:12:45', '2024-01-25 10:12:45'), (46, 4, 'carreer_slider', 'image', 'image', '/storage/files/1/Sliders/carreer/carreer-slide-04.png', NULL, NULL, '2024-01-25 10:13:06', '2024-01-25 10:13:06'), (47, 4, 'carreer_slider', 'image', 'image', '/storage/files/1/Sliders/carreer/carreer-slide-05.png', NULL, NULL, '2024-01-25 10:13:20', '2024-01-25 10:13:20'), (59, 2, 'work_incorporating', 'text', 'text', NULL, 'content pillars', NULL, '2024-02-01 06:30:28', '2024-02-01 06:30:28'), (60, 2, 'work_incorporating', 'text', 'text', NULL, 'key message', NULL, '2024-02-01 06:30:36', '2024-02-01 06:30:36'), (61, 2, 'work_incorporating', 'text', 'text', NULL, 'visual identity', NULL, '2024-02-01 06:30:44', '2024-02-01 06:30:44'), (62, 2, 'work_incorporating', 'text', 'text', NULL, 'brand discovery', NULL, '2024-02-01 06:30:52', '2024-02-01 06:30:52'), (63, 2, 'work_incorporating', 'text', 'text', NULL, 'marketing strategy', NULL, '2024-02-01 06:31:04', '2024-02-01 06:31:04'), (64, 2, 'work_incorporating', 'text', 'text', NULL, 'budgeting & timeline', NULL, '2024-02-01 06:31:12', '2024-02-01 06:34:28'), (57, 2, 'work_incorporating', 'text', 'text', NULL, 'communication objectives', NULL, '2024-02-01 06:29:50', '2024-02-01 06:34:51'), (65, 2, 'work_comprising', 'text', 'text', NULL, 'account manager', NULL, '2024-02-01 06:40:43', '2024-02-01 06:40:43'), (66, 2, 'work_comprising', 'text', 'text', NULL, 'social media officer', NULL, '2024-02-01 06:40:54', '2024-02-01 06:40:54'), (67, 2, 'work_comprising', 'text', 'text', NULL, 'creative director', NULL, '2024-02-01 06:41:03', '2024-02-01 06:41:03'), (68, 2, 'work_comprising', 'text', 'text', NULL, 'graphic designer', NULL, '2024-02-01 06:41:18', '2024-02-01 06:41:18'), (69, 2, 'work_comprising', 'text', 'text', NULL, 'marketing strategist', NULL, '2024-02-01 06:41:38', '2024-02-01 06:41:38'), (70, 2, 'work_comprising', 'text', 'text', NULL, 'production assistant', NULL, '2024-02-01 06:41:45', '2024-02-01 06:41:45'), (71, 2, 'work_comprising', 'text', 'text', NULL, 'photographer & videographer', NULL, '2024-02-01 06:41:53', '2024-02-01 06:41:53'); /*!40000 ALTER TABLE "page_sliders" ENABLE KEYS */; /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;