· 8 years ago · Mar 24, 2018, 07:44 PM
1CREATE TABLE IF NOT EXISTS `portfolio_works` (
2 `id` int(10) unsigned NOT NULL,
3 `portfolio_id` int(10) unsigned NOT NULL,
4 `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5 `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
6 `description` text COLLATE utf8mb4_unicode_ci,
7) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
8
9CREATE TABLE IF NOT EXISTS `portfolio_work_images` (
10 `id` int(10) unsigned NOT NULL,
11 `portfolio_id` int(10) unsigned NOT NULL,
12 `portfolio_work_id` int(10) unsigned NOT NULL,
13 `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
14 `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;