· 8 years ago · Jun 12, 2018, 10:00 AM
1CREATE TABLE IF NOT EXISTS `settings` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `name` varchar(50) DEFAULT '0',
4 `value` varchar(1000) DEFAULT '0',
5 `status` tinyint(4) NOT NULL DEFAULT '1',
6 PRIMARY KEY (`id`)
7) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
8
9INSERT INTO `settings` (`id`, `name`, `value`, `status`) VALUES
10 (1, 'FILE_TYPES', 'png|PNG|jpe?g|JPE?G|gif|GIF|doc|DOC|pdf|PDF|txt|xls|xlsx|mp3|MP3|mp4|MP4|avi|mkv|zip|html?', 1),
11 (2, 'MAX_FILE_SIZE', '10', 1);
12
13INSERT INTO `permissions` (`PERMISSION_NAME`) VALUES ('FILE_UPLOAD_SETUP');
14INSERT INTO `permissions_to_roles` (`PERMISSION_ID`, `ROLE_ID`) VALUES ('45', '9');