phpodpworld-users — Discussions related to usage (and development) of phpODPWorld

[Jason Y. <go...@gm...>]

 I want to tell you another problem (I don't know it's my problem or the
program's).
In the db.sql file
---------------------------------------------
CREATE TABLE "structure" (
 catid INT NOT NULL DEFAULT '0' PRIMARY KEY,
 topic VARCHAR(1024) NOT NULL,   /// Notice this line
 title VARCHAR(1024),
 description VARCHAR(8192),
 lastupdate TIMESTAMP,
 count INT DEFAULT '-1',
 totalcount INT DEFAULT '-1'
);
--------------------------------------------
but in mysql the topic Field will be changed to text type automaticly.
so when go to :

CREATE INDEX structure_topic_index ON structure (topic);

it will be wrong . because text can't  be maked to index.

Can you help????