/
page.install.sql
76 lines (72 loc) · 3.55 KB
/
page.install.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
/**
* Page module DB installation
*/
-- Default categories permssions
INSERT INTO `cot_auth` (`auth_groupid`, `auth_code`, `auth_option`,
`auth_rights`, `auth_rights_lock`, `auth_setbyuserid`) VALUES
(1, 'page', 'articles', 5, 250, 1),
(2, 'page', 'articles', 1, 254, 1),
(3, 'page', 'articles', 0, 255, 1),
(4, 'page', 'articles', 7, 0, 1),
(5, 'page', 'articles', 255, 255, 1),
(6, 'page', 'articles', 135, 0, 1),
(1, 'page', 'events', 5, 250, 1),
(2, 'page', 'events', 1, 254, 1),
(3, 'page', 'events', 0, 255, 1),
(4, 'page', 'events', 7, 0, 1),
(5, 'page', 'events', 255, 255, 1),
(6, 'page', 'events', 135, 0, 1),
(1, 'page', 'system', 5, 250, 1),
(2, 'page', 'system', 1, 254, 1),
(3, 'page', 'system', 0, 255, 1),
(4, 'page', 'system', 7, 0, 1),
(5, 'page', 'system', 255, 255, 1),
(6, 'page', 'system', 135, 0, 1),
(1, 'page', 'news', 5, 250, 1),
(2, 'page', 'news', 1, 254, 1),
(3, 'page', 'news', 0, 255, 1),
(4, 'page', 'news', 7, 0, 1),
(5, 'page', 'news', 255, 255, 1),
(6, 'page', 'news', 135, 0, 1);
-- Pages table
CREATE TABLE IF NOT EXISTS `cot_pages` (
`page_id` int UNSIGNED NOT NULL auto_increment,
`page_alias` varchar(255) NOT NULL DEFAULT '',
`page_state` tinyint UNSIGNED NOT NULL DEFAULT '0',
`page_cat` varchar(255) NOT NULL,
`page_title` varchar(255) NOT NULL,
`page_desc` varchar(255) DEFAULT '',
`page_keywords` varchar(255) DEFAULT '',
`page_metatitle` varchar(255) DEFAULT '',
`page_metadesc` varchar(255) DEFAULT '',
`page_text` MEDIUMTEXT DEFAULT NULL,
`page_parser` varchar(64) DEFAULT '',
`page_author` varchar(100) DEFAULT '',
`page_ownerid` int UNSIGNED NOT NULL DEFAULT '0',
`page_date` int UNSIGNED NOT NULL DEFAULT '0',
`page_begin` int UNSIGNED NOT NULL DEFAULT '0',
`page_expire` int UNSIGNED NOT NULL DEFAULT '0',
`page_updated` int UNSIGNED NOT NULL DEFAULT '0',
`page_file` tinyint UNSIGNED NOT NULL DEFAULT '0',
`page_url` varchar(255) DEFAULT '',
`page_size` int UNSIGNED NOT NULL DEFAULT '0',
`page_count` mediumint UNSIGNED NOT NULL DEFAULT '0',
`page_filecount` mediumint UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`page_id`),
KEY `page_cat` (`page_cat`),
KEY `page_alias` (`page_alias`),
KEY `page_date` (`page_date`),
KEY `page_ownerid` (`page_ownerid`),
KEY `page_begin` (`page_begin`),
KEY `page_expire` (`page_expire`),
KEY `page_title` (`page_title`)
);
-- Default page categories
INSERT INTO `cot_structure` (`structure_area`, `structure_code`, `structure_path`, `structure_tpl`, `structure_title`,
`structure_desc`, `structure_icon`, `structure_locked`, `structure_count`) VALUES
('page', 'articles', '001', '', 'Articles', '', '', 0, 0),
('page', 'system', '999', '', 'System', '', '', 0, 0),
('page', 'events', '002', '', 'Events', '', '', 0, 0),
('page', 'news', '003', '', 'News', '', '', 0, 1);
INSERT INTO `cot_pages` (`page_state`, `page_cat`, `page_title`, `page_desc`, `page_text`, `page_author`, `page_ownerid`, `page_date`, `page_begin`, `page_expire`, `page_file`, `page_url`, `page_size`, `page_count`, `page_filecount`, `page_alias`) VALUES
(0, 'news', 'Welcome!', '', 'Congratulations, Cotonti was successfully installed! You can now login with the user account you created during installation. Next step is to go to the Administration panel and change the settings for your website, such as the title, server settings, language, user groups and extensions. You can safely remove this message by clicking its title, then clicking Edit and Delete this page.', '', 1, UNIX_TIMESTAMP(), UNIX_TIMESTAMP(), 0, 0, '', 0, 0, 0, '');