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

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