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
| Error at the line 29986: );
Query: CREATE TABLE post (
postid int(10) unsigned NOT NULL auto_increment,
threadid int(10) unsigned NOT NULL,
parentid int(10) unsigned NOT NULL,
username varchar(100) NOT NULL,
userid int(10) unsigned NOT NULL,
title varchar(250) NOT NULL,
dateline int(10) unsigned NOT NULL,
pagetext mediumtext NOT NULL,
allowsmilie smallint(6) NOT NULL,
showsignature smallint(6) NOT NULL,
ipaddress varchar(15) NOT NULL,
iconid smallint(5) unsigned NOT NULL,
visible smallint(6) NOT NULL,
attach smallint(5) unsigned NOT NULL,
importthreadid bigint(20) NOT NULL,
importpostid bigint(20) NOT NULL,
PRIMARY KEY (postid),
KEY userid (userid),
KEY threadid (threadid,userid),
KEY importpost_index (importpostid),
KEY title (title,pagetext)
);
MySQL: BLOB/TEXT column 'pagetext' used in key specification without a key length |
