← All changes | wpf-includes/install-sql.php +9 -39 1.3.1 → beta-4 View file →

		@@ -50,19 +50,11 @@
50	50	`meta_desc` TEXT,
51	51	`type` TINYINT NOT NULL DEFAULT 0,
52	52	`closed` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
53	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	54	PRIMARY KEY (`topicid`),
59	55	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`)
	56	+ FULLTEXT KEY `title` (`title`)
65	57	) ENGINE=$engine $charset_collate;",
66	58	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_posts`(
67	59	`postid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
68	60	`parentid` BIGINT UNSIGNED NOT NULL DEFAULT 0,
		@@ -76,17 +68,12 @@
76	68	`likes` INT UNSIGNED NOT NULL DEFAULT 0,
77	69	`votes` INT NOT NULL DEFAULT 0,
78	70	`is_answer` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
79	71	`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	72	PRIMARY KEY (`postid`),
84	73	FULLTEXT KEY `title`(`title`(191)),
85	74	FULLTEXT KEY `body` (`body`),
86		- FULLTEXT KEY `title_plus_body` (`title`,`body`),
87		- KEY `status` (`status`),
88		- KEY `email` (`email`)
	75	+ FULLTEXT KEY `title_plus_body` (`title`,`body`)
89	76	) ENGINE=$engine $charset_collate;",
90	77	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_profiles` (
91	78	`userid` INT UNSIGNED NOT NULL,
92	79	`title` VARCHAR(255) NOT NULL DEFAULT 'member',
		@@ -105,11 +92,11 @@
105	92	`twitter` VARCHAR(255) DEFAULT NULL,
106	93	`gtalk` VARCHAR(255) DEFAULT NULL,
107	94	`skype` VARCHAR(255) DEFAULT NULL,
108	95	`avatar` VARCHAR(255) DEFAULT NULL,
109		- `signature` TEXT,
	96	+ `signature` VARCHAR(255) DEFAULT NULL,
110	97	`about` TEXT,
111		- `occupation` TEXT,
	98	+ `occupation` VARCHAR(255) DEFAULT NULL,
112	99	`location` VARCHAR(255) DEFAULT NULL,
113	100	`last_login` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
114	101	`rank` INT UNSIGNED NOT NULL DEFAULT 0,
115	102	`like` INT UNSIGNED NOT NULL DEFAULT 0,
		@@ -135,11 +122,10 @@
135	122	) ENGINE=MyISAM $charset_collate;",
136	123	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_phrases` (
137	124	`phraseid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
138	125	`langid` INT UNSIGNED NOT NULL,
139		- `phrase_key` VARCHAR(255) NOT NULL,
	126	+ `phrase_key` varchar(255) NOT NULL,
140	127	`phrase_value` text NOT NULL,
141		- `package` VARCHAR(255) NOT NULL DEFAULT 'wpforo',
142	128	PRIMARY KEY (`phraseid`),
143	129	KEY `langid` (`langid`),
144	130	KEY `phrase_key` (`phrase_key`(191)),
145	131	UNIQUE KEY lng_and_key_uniq (`langid`, `phrase_key`(191))
		@@ -155,11 +141,10 @@
155	141	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_views`(
156	142	`vid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
157	143	`userid` INT UNSIGNED NOT NULL,
158	144	`topicid` INT UNSIGNED NOT NULL,
159		- `created` INT UNSIGNED NOT NULL,
160		- PRIMARY KEY (`vid`),
161		- KEY `user_topic` (`userid`,`topicid`)
	145	+ `created` TIMESTAMP NOT NULL,
	146	+ PRIMARY KEY (`vid`)
162	147	) ENGINE=$engine $charset_collate;",
163	148	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_votes`(
164	149	`voteid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
165	150	`userid` INT UNSIGNED NOT NULL,
		@@ -179,32 +164,17 @@
179	164	) ENGINE=MyISAM $charset_collate;",
180	165	"CREATE TABLE IF NOT EXISTS `{$wpforo->db->prefix}wpforo_subscribes` (
181	166	`subid` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
182	167	`itemid` BIGINT UNSIGNED NOT NULL,
183		- `type` VARCHAR(5) NOT NULL,
	168	+ `type` varchar(5) NOT NULL,
184	169	`confirmkey` varchar(32) NOT NULL,
185	170	`userid` BIGINT UNSIGNED NOT NULL,
186		- `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
	171	+ `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
187	172	PRIMARY KEY (`subid`),
188	173	UNIQUE KEY `itemid` (`itemid`,`type`,`userid`),
189	174	UNIQUE KEY `confirmkey` (`confirmkey`),
190	175	KEY `itemid_2` (`itemid`),
191	176	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	177	) ENGINE=$engine $charset_collate;"
208	178	);
209	179
210	180	?>