wpforo / wpf-includes / install-sql.php

install-sql.php in wpForo Forum 1.3.1, at wpf-includes/install-sql.php

210 lines 8.7 KB

Raw Download Zip

1	<?php
2	// Exit if accessed directly
3	if( !defined( 'ABSPATH' ) ) exit;
4
5
6	$charset_collate = '';
7	if ( ! empty($wpforo->db->charset) ) $charset_collate = "DEFAULT CHARACTER SET " . $wpforo->db->charset;
8	if ( ! empty($wpforo->db->collate) ) $charset_collate .= " COLLATE " . $wpforo->db->collate;
9	$engine = version_compare($wpforo->db->db_version(), '5.6.4', '>=') ? 'InnoDB' : 'MyISAM';
10
11	$wpforo_sql = array(
12	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_forums`(
13	`forumid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
14	`title` VARCHAR(255) NOT NULL,
15	`slug` VARCHAR(255) NOT NULL,
16	`description` LONGTEXT,
17	`parentid` INT UNSIGNED NOT NULL DEFAULT 0,
18	`icon` VARCHAR(255),
19	`last_topicid` INT UNSIGNED NOT NULL DEFAULT 0,
20	`last_postid` INT UNSIGNED NOT NULL DEFAULT 0,
21	`last_userid` INT UNSIGNED NOT NULL DEFAULT 0,
22	`last_post_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
23	`topics` INT NOT NULL DEFAULT 0,
24	`posts` INT NOT NULL DEFAULT 0,
25	`permissions` TEXT,
26	`meta_key` TEXT,
27	`meta_desc` TEXT,
28	`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
29	`is_cat` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
30	`cat_layout` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
31	`order` INT UNSIGNED NOT NULL DEFAULT 0,
32	PRIMARY KEY (`forumid`),
33	UNIQUE KEY `UNIQUE SLUG` (`slug`(191))
34	) ENGINE=MyISAM $charset_collate;",
35	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_topics`(
36	`topicid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
37	`forumid` INT UNSIGNED NOT NULL,
38	`first_postid` BIGINT UNSIGNED NOT NULL DEFAULT 0,
39	`userid` INT UNSIGNED NOT NULL,
40	`title` VARCHAR(255) NOT NULL,
41	`slug` VARCHAR(255) NOT NULL,
42	`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
43	`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
44	`last_post` BIGINT UNSIGNED NOT NULL DEFAULT 0,
45	`posts` INT NOT NULL DEFAULT 0,
46	`votes` INT NOT NULL DEFAULT 0,
47	`answers` INT NOT NULL DEFAULT 0,
48	`views` INT UNSIGNED NOT NULL DEFAULT 0,
49	`meta_key` TEXT,
50	`meta_desc` TEXT,
51	`type` TINYINT NOT NULL DEFAULT 0,
52	`closed` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
53	`has_attach` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
54	`private` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
55	`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
56	`name` VARCHAR(50) NOT NULL DEFAULT '',
57	`email` VARCHAR(50) NOT NULL DEFAULT '',
58	PRIMARY KEY (`topicid`),
59	UNIQUE KEY `UNIQUE SLUG` (`slug`(191)),
60	FULLTEXT KEY `title` (`title`),
61	KEY `status` (`status`),
62	KEY `email` (`email`),
63	KEY `is_private` (`private`),
64	KEY `own_private` (`userid`,`private`)
65	) ENGINE=$engine $charset_collate;",
66	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_posts`(
67	`postid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
68	`parentid` BIGINT UNSIGNED NOT NULL DEFAULT 0,
69	`forumid` INT UNSIGNED NOT NULL,
70	`topicid` BIGINT UNSIGNED NOT NULL,
71	`userid` INT UNSIGNED NOT NULL,
72	`title` varchar(255),
73	`body` LONGTEXT,
74	`created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
75	`modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
76	`likes` INT UNSIGNED NOT NULL DEFAULT 0,
77	`votes` INT NOT NULL DEFAULT 0,
78	`is_answer` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
79	`is_first_post` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
80	`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
81	`name` VARCHAR(50) NOT NULL DEFAULT '',
82	`email` VARCHAR(50) NOT NULL DEFAULT '',
83	PRIMARY KEY (`postid`),
84	FULLTEXT KEY `title`(`title`(191)),
85	FULLTEXT KEY `body` (`body`),
86	FULLTEXT KEY `title_plus_body` (`title`,`body`),
87	KEY `status` (`status`),
88	KEY `email` (`email`)
89	) ENGINE=$engine $charset_collate;",
90	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_profiles` (
91	`userid` INT UNSIGNED NOT NULL,
92	`title` VARCHAR(255) NOT NULL DEFAULT 'member',
93	`username` VARCHAR(255) NOT NULL,
94	`groupid` INT UNSIGNED NOT NULL,
95	`posts` INT NOT NULL DEFAULT 0,
96	`questions` INT NOT NULL DEFAULT 0,
97	`answers` INT NOT NULL DEFAULT 0,
98	`comments` INT NOT NULL DEFAULT 0,
99	`site` VARCHAR(255) DEFAULT NULL,
100	`icq` VARCHAR(255) DEFAULT NULL,
101	`aim` VARCHAR(255) DEFAULT NULL,
102	`yahoo` VARCHAR(255) DEFAULT NULL,
103	`msn` VARCHAR(255) DEFAULT NULL,
104	`facebook` VARCHAR(255) DEFAULT NULL,
105	`twitter` VARCHAR(255) DEFAULT NULL,
106	`gtalk` VARCHAR(255) DEFAULT NULL,
107	`skype` VARCHAR(255) DEFAULT NULL,
108	`avatar` VARCHAR(255) DEFAULT NULL,
109	`signature` TEXT,
110	`about` TEXT,
111	`occupation` TEXT,
112	`location` VARCHAR(255) DEFAULT NULL,
113	`last_login` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
114	`rank` INT UNSIGNED NOT NULL DEFAULT 0,
115	`like` INT UNSIGNED NOT NULL DEFAULT 0,
116	`status` VARCHAR(8) DEFAULT 'active' COMMENT 'active, blocked, trashed, spamer',
117	`timezone` VARCHAR(255),
118	PRIMARY KEY (`userid`),
119	UNIQUE KEY `UNIQUE ID` (`userid`),
120	UNIQUE KEY `UNIQUE USERNAME` (`username`(191))
121	) ENGINE=MyISAM $charset_collate;",
122	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_usergroups`(
123	`groupid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
124	`name` VARCHAR(255) NOT NULL,
125	`cans` LONGTEXT NOT NULL COMMENT 'board permissions',
126	`description` TEXT,
127	PRIMARY KEY (`groupid`),
128	UNIQUE KEY `UNIQUE GROUP NAME` (`name`(191))
129	) ENGINE=MyISAM $charset_collate;",
130	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_languages`(
131	`langid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
132	`name` VARCHAR(255) NOT NULL,
133	PRIMARY KEY (`langid`),
134	UNIQUE KEY `UNIQUE language name` (`name`(191))
135	) ENGINE=MyISAM $charset_collate;",
136	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_phrases` (
137	`phraseid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
138	`langid` INT UNSIGNED NOT NULL,
139	`phrase_key` VARCHAR(255) NOT NULL,
140	`phrase_value` text NOT NULL,
141	`package` VARCHAR(255) NOT NULL DEFAULT 'wpforo',
142	PRIMARY KEY (`phraseid`),
143	KEY `langid` (`langid`),
144	KEY `phrase_key` (`phrase_key`(191)),
145	UNIQUE KEY lng_and_key_uniq (`langid`, `phrase_key`(191))
146	) ENGINE=MyISAM $charset_collate;",
147	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_likes`(
148	`likeid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
149	`userid` INT UNSIGNED NOT NULL,
150	`postid` INT UNSIGNED NOT NULL,
151	`post_userid` INT UNSIGNED NOT NULL,
152	PRIMARY KEY (`likeid`),
153	UNIQUE KEY `userid` (`userid`,`postid`)
154	) ENGINE=$engine $charset_collate;",
155	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_views`(
156	`vid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
157	`userid` INT UNSIGNED NOT NULL,
158	`topicid` INT UNSIGNED NOT NULL,
159	`created` INT UNSIGNED NOT NULL,
160	PRIMARY KEY (`vid`),
161	KEY `user_topic` (`userid`,`topicid`)
162	) ENGINE=$engine $charset_collate;",
163	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_votes`(
164	`voteid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
165	`userid` INT UNSIGNED NOT NULL,
166	`postid` INT UNSIGNED NOT NULL,
167	`reaction` TINYINT NOT NULL DEFAULT 1,
168	`post_userid` INT UNSIGNED NOT NULL,
169	PRIMARY KEY (`voteid`),
170	UNIQUE KEY `userid` (`userid`,`postid`)
171	) ENGINE=$engine $charset_collate;",
172	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_accesses`(
173	`accessid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
174	`access` VARCHAR(255) NOT NULL,
175	`title` VARCHAR(255) NOT NULL,
176	`cans` LONGTEXT NOT NULL COMMENT 'forum permissions',
177	PRIMARY KEY (`accessid`),
178	UNIQUE KEY ( `access`(191) )
179	) ENGINE=MyISAM $charset_collate;",
180	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_subscribes` (
181	`subid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
182	`itemid` BIGINT UNSIGNED NOT NULL,
183	`type` VARCHAR(5) NOT NULL,
184	`confirmkey` varchar(32) NOT NULL,
185	`userid` BIGINT UNSIGNED NOT NULL,
186	`active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
187	PRIMARY KEY (`subid`),
188	UNIQUE KEY `itemid` (`itemid`,`type`,`userid`),
189	UNIQUE KEY `confirmkey` (`confirmkey`),
190	KEY `itemid_2` (`itemid`),
191	KEY `userid` (`userid`)
192	) ENGINE=$engine $charset_collate;",
193	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_visits` (
194	`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
195	`userid` BIGINT UNSIGNED NOT NULL,
196	`name` VARCHAR(60) NOT NULL,
197	`ip` VARCHAR(60) NOT NULL,
198	`time` INT UNSIGNED NOT NULL,
199	`forumid` INT UNSIGNED NOT NULL,
200	`topicid` BIGINT UNSIGNED NOT NULL,
201	PRIMARY KEY (`id`),
202	KEY `userid` (`userid`),
203	KEY `forumid` (`forumid`),
204	KEY `topicid` (`topicid`),
205	KEY `time` (`time`),
206	KEY `ip` (`ip`)
207	) ENGINE=$engine $charset_collate;"
208	);
209
210	?>