← All changes | wpf-includes/install-sql.php +16 -62 1.4.1 → beta-4 View file →

		@@ -29,13 +29,9 @@
29	29	`is_cat` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
30	30	`cat_layout` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
31	31	`order` INT UNSIGNED NOT NULL DEFAULT 0,
32	32	PRIMARY KEY (`forumid`),
33		- UNIQUE KEY `UNIQUE SLUG` (`slug`(191)),
34		- KEY `order` (`order`),
35		- KEY `status` (`status`),
36		- KEY `parentid` (`parentid`),
37		- KEY `is_cat` (`is_cat`)
	33	+ UNIQUE KEY `UNIQUE SLUG` (`slug`(191))
38	34	) ENGINE=MyISAM $charset_collate;",
39	35	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_topics`(
40	36	`topicid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
41	37	`forumid` INT UNSIGNED NOT NULL,
		@@ -54,24 +50,11 @@
54	50	`meta_desc` TEXT,
55	51	`type` TINYINT NOT NULL DEFAULT 0,
56	52	`closed` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
57	53	`has_attach` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
58		- `private` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
59		- `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
60		- `name` VARCHAR(50) NOT NULL DEFAULT '',
61		- `email` VARCHAR(50) NOT NULL DEFAULT '',
62	54	PRIMARY KEY (`topicid`),
63	55	UNIQUE KEY `UNIQUE SLUG` (`slug`(191)),
64		- FULLTEXT KEY `title` (`title`),
65		- KEY `forumid` (`forumid`),
66		- KEY `first_postid` (`first_postid`),
67		- KEY `created` (`created`),
68		- KEY `modified` (`modified`),
69		- KEY `type` (`type`),
70		- KEY `status` (`status`),
71		- KEY `email` (`email`),
72		- KEY `is_private` (`private`),
73		- KEY `own_private` (`userid`,`private`)
	56	+ FULLTEXT KEY `title` (`title`)
74	57	) ENGINE=$engine $charset_collate;",
75	58	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_posts`(
76	59	`postid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
77	60	`parentid` BIGINT UNSIGNED NOT NULL DEFAULT 0,
		@@ -85,23 +68,12 @@
85	68	`likes` INT UNSIGNED NOT NULL DEFAULT 0,
86	69	`votes` INT NOT NULL DEFAULT 0,
87	70	`is_answer` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
88	71	`is_first_post` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
89		- `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
90		- `name` VARCHAR(50) NOT NULL DEFAULT '',
91		- `email` VARCHAR(50) NOT NULL DEFAULT '',
92	72	PRIMARY KEY (`postid`),
93	73	FULLTEXT KEY `title`(`title`(191)),
94	74	FULLTEXT KEY `body` (`body`),
95		- FULLTEXT KEY `title_plus_body` (`title`,`body`),
96		- KEY `topicid` (`topicid`),
97		- KEY `forumid` (`forumid`),
98		- KEY `userid` (`userid`),
99		- KEY `parentid` (`parentid`),
100		- KEY `is_answer` (`is_answer`),
101		- KEY `is_first_post` (`is_first_post`),
102		- KEY `status` (`status`),
103		- KEY `email` (`email`)
	75	+ FULLTEXT KEY `title_plus_body` (`title`,`body`)
104	76	) ENGINE=$engine $charset_collate;",
105	77	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_profiles` (
106	78	`userid` INT UNSIGNED NOT NULL,
107	79	`title` VARCHAR(255) NOT NULL DEFAULT 'member',
		@@ -120,11 +92,11 @@
120	92	`twitter` VARCHAR(255) DEFAULT NULL,
121	93	`gtalk` VARCHAR(255) DEFAULT NULL,
122	94	`skype` VARCHAR(255) DEFAULT NULL,
123	95	`avatar` VARCHAR(255) DEFAULT NULL,
124		- `signature` TEXT,
	96	+ `signature` VARCHAR(255) DEFAULT NULL,
125	97	`about` TEXT,
126		- `occupation` TEXT,
	98	+ `occupation` VARCHAR(255) DEFAULT NULL,
127	99	`location` VARCHAR(255) DEFAULT NULL,
128	100	`last_login` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
129	101	`rank` INT UNSIGNED NOT NULL DEFAULT 0,
130	102	`like` INT UNSIGNED NOT NULL DEFAULT 0,
		@@ -131,20 +103,17 @@
131	103	`status` VARCHAR(8) DEFAULT 'active' COMMENT 'active, blocked, trashed, spamer',
132	104	`timezone` VARCHAR(255),
133	105	PRIMARY KEY (`userid`),
134	106	UNIQUE KEY `UNIQUE ID` (`userid`),
135		- UNIQUE KEY `UNIQUE USERNAME` (`username`(191)),
136		- KEY `groupid` (`groupid`),
137		- KEY `posts` (`posts`),
138		- KEY `status` (`status`)
	107	+ UNIQUE KEY `UNIQUE USERNAME` (`username`(191))
139	108	) ENGINE=MyISAM $charset_collate;",
140	109	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_usergroups`(
141	110	`groupid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
142	111	`name` VARCHAR(255) NOT NULL,
143		- `cans` LONGTEXT NOT NULL COMMENT 'board permissions',
	112	+ `cans` LONGTEXT NOT NULL COMMENT 'board permissions',
144	113	`description` TEXT,
145	114	PRIMARY KEY (`groupid`),
146		- UNIQUE KEY `UNIQUE_GROUP_NAME` (`name`(191))
	115	+ UNIQUE KEY `UNIQUE GROUP NAME` (`name`(191))
147	116	) ENGINE=MyISAM $charset_collate;",
148	117	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_languages`(
149	118	`langid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
150	119	`name` VARCHAR(255) NOT NULL,
		@@ -153,11 +122,10 @@
153	122	) ENGINE=MyISAM $charset_collate;",
154	123	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_phrases` (
155	124	`phraseid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
156	125	`langid` INT UNSIGNED NOT NULL,
157		- `phrase_key` VARCHAR(255) NOT NULL,
	126	+ `phrase_key` varchar(255) NOT NULL,
158	127	`phrase_value` text NOT NULL,
159		- `package` VARCHAR(255) NOT NULL DEFAULT 'wpforo',
160	128	PRIMARY KEY (`phraseid`),
161	129	KEY `langid` (`langid`),
162	130	KEY `phrase_key` (`phrase_key`(191)),
163	131	UNIQUE KEY lng_and_key_uniq (`langid`, `phrase_key`(191))
		@@ -173,11 +141,10 @@
173	141	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_views`(
174	142	`vid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
175	143	`userid` INT UNSIGNED NOT NULL,
176	144	`topicid` INT UNSIGNED NOT NULL,
177		- `created` INT UNSIGNED NOT NULL,
178		- PRIMARY KEY (`vid`),
179		- KEY `user_topic` (`userid`,`topicid`)
	145	+ `created` TIMESTAMP NOT NULL,
	146	+ PRIMARY KEY (`vid`)
180	147	) ENGINE=$engine $charset_collate;",
181	148	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_votes`(
182	149	`voteid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
183	150	`userid` INT UNSIGNED NOT NULL,
		@@ -197,30 +164,17 @@
197	164	) ENGINE=MyISAM $charset_collate;",
198	165	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_subscribes` (
199	166	`subid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
200	167	`itemid` BIGINT UNSIGNED NOT NULL,
201		- `type` VARCHAR(5) NOT NULL,
	168	+ `type` varchar(5) NOT NULL,
202	169	`confirmkey` varchar(32) NOT NULL,
203	170	`userid` BIGINT UNSIGNED NOT NULL,
204		- `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
	171	+ `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
205	172	PRIMARY KEY (`subid`),
206	173	UNIQUE KEY `itemid` (`itemid`,`type`,`userid`),
207	174	UNIQUE KEY `confirmkey` (`confirmkey`),
208	175	KEY `itemid_2` (`itemid`),
209	176	KEY `userid` (`userid`)
210		- ) ENGINE=$engine $charset_collate;",
211		- "CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_visits` (
212		- `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
213		- `userid` BIGINT UNSIGNED NOT NULL,
214		- `name` VARCHAR(60) NOT NULL,
215		- `ip` VARCHAR(60) NOT NULL,
216		- `time` INT UNSIGNED NOT NULL,
217		- `forumid` INT UNSIGNED NOT NULL,
218		- `topicid` BIGINT UNSIGNED NOT NULL,
219		- PRIMARY KEY (`id`),
220		- KEY `userid` (`userid`),
221		- KEY `forumid` (`forumid`),
222		- KEY `topicid` (`topicid`),
223		- KEY `time` (`time`),
224		- KEY `ip` (`ip`)
225	177	) ENGINE=$engine $charset_collate;"
226		- );
	178	+ );
	179	+
	180	+?>