-
Notifications
You must be signed in to change notification settings - Fork 19
/
mysql_install.php
84 lines (81 loc) · 4.21 KB
/
mysql_install.php
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
77
78
79
80
81
82
83
84
<?php
/* Reminder: always indent with 4 spaces (no tabs). */
// +---------------------------------------------------------------------------+
// | Static Pages Plugin 1.7 |
// +---------------------------------------------------------------------------+
// | Installation SQL |
// +---------------------------------------------------------------------------+
// | Copyright (C) 2000-2017 by the following authors: |
// | |
// | Authors: Tony Bibbs - tony AT tonybibbs DOT com |
// | Tom Willett - twillett AT users DOT sourceforge DOT net |
// | Blaine Lang - langmail AT sympatico DOT ca |
// | Dirk Haun - dirk AT haun-online DOT de |
// +---------------------------------------------------------------------------+
// | |
// | This program is licensed under the terms of the GNU General Public License|
// | as published by the Free Software Foundation; either version 2 |
// | of the License, or (at your option) any later version. |
// | |
// | This program is distributed in the hope that it will be useful, |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
// | See the GNU General Public License for more details. |
// | |
// | You should have received a copy of the GNU General Public License |
// | along with this program; if not, write to the Free Software Foundation, |
// | Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. |
// | |
// +---------------------------------------------------------------------------+
/**
* MySQL install
*
* @package StaticPages
*/
$_SQL[] = "
CREATE TABLE {$_TABLES['staticpage']} (
sp_id varchar(128) NOT NULL default '',
sp_title varchar(128) NOT NULL default '',
sp_page_title varchar(128) NOT NULL default '',
sp_content text NOT NULL,
page_data text DEFAULT NULL,
sp_hits mediumint(8) unsigned NOT NULL default '0',
`created` datetime default NULL,
modified datetime default NULL,
sp_format varchar(20) NOT NULL default '',
sp_onmenu tinyint(1) unsigned NOT NULL default '0',
sp_onhits tinyint(1) unsigned NOT NULL default '1',
sp_onlastupdate tinyint(1) unsigned NOT NULL default '1',
sp_label varchar(64) default NULL,
commentcode tinyint(4) NOT NULL default '0',
structured_data_type varchar(40) NOT NULL DEFAULT '',
meta_description TEXT NULL,
meta_keywords TEXT NULL,
template_flag tinyint(1) unsigned default '0',
template_id varchar(40) NOT NULL default '',
cache_time INT NOT NULL DEFAULT '0',
draft_flag tinyint(1) unsigned default '0',
search tinyint(1) NOT NULL default '1',
owner_id mediumint(8) unsigned NOT NULL default '1',
group_id mediumint(8) unsigned NOT NULL default '1',
perm_owner tinyint(1) unsigned NOT NULL default '3',
perm_group tinyint(1) unsigned NOT NULL default '2',
perm_members tinyint(1) unsigned NOT NULL default '2',
perm_anon tinyint(1) unsigned NOT NULL default '2',
sp_centerblock tinyint(1) unsigned NOT NULL default '0',
sp_help varchar(255) default '',
sp_where tinyint(1) unsigned NOT NULL default '1',
sp_php tinyint(1) unsigned NOT NULL default '0',
sp_nf tinyint(1) unsigned default '0',
sp_inblock tinyint(1) unsigned default '1',
postmode varchar(16) NOT NULL default 'html',
sp_prev varchar(128) NOT NULL default '',
sp_next varchar(128) NOT NULL default '',
sp_parent varchar(128) NOT NULL default '',
PRIMARY KEY (sp_id),
KEY staticpage_created (created),
KEY staticpage_sp_onmenu (sp_onmenu),
KEY staticpage_sp_centerblock (sp_centerblock),
KEY staticpage_sp_where (sp_where)
) ENGINE=MyISAM
";