· 7 years ago · Jan 21, 2019, 02:50 PM
1CREATE TABLE IF NOT EXISTS `#__web_projects`
2(
3`id` int(11) NOT NULL AUTO_INCREMENT,
4`type_website` varchar(30) COLLATE utf8_polish_ci NOT NULL,
5`web_color` varchar(255) COLLATE utf8_polish_ci NOT NULL,
6`web_fonts` varchar(255) COLLATE utf8_polish_ci NOT NULL,
7`web_layout` text COLLATE utf8_polish_ci NOT NULL,
8`web_menu` text COLLATE utf8_polish_ci NOT NULL,
9`similar_web_sites` text COLLATE utf8_polish_ci NOT NULL,
10`additional_info` text COLLATE utf8_polish_ci,
11`about_company` text COLLATE utf8_polish_ci,
12`offer` text COLLATE utf8_polish_ci,
13`logo` varchar(255) COLLATE utf8_polish_ci NOT NULL,
14`user_id` int(11) NOT NULL,
15PRIMARY KEY(id),
16FOREIGN KEY (`user_id`) REFERENCES `#__users`(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci