-- --------------------------------------------------------
-- Server OS:                    
-- HeidiSQL Version:             12.5.0.6677
-- --------------------------------------------------------


-- 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";
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');

-- 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";
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');

