Every valid table MUST have at least 3 Fields
1: Field of type INTEGER or VARSCHAR marked as PRIMARY table.
2: Title or name field type VARCHAR, TINY-, MEDIUMTEXT.
(A simple TEXT-Type field as title is not accepted, because you can not use an index on text-fields)
3: Content or description field of type TEXT or
Lets take a look at the joodb_sample table:
CREATE TABLE IF NOT EXISTS 'jos_joodb_sample' (
'myid' int(1) NOT NULL AUTO_INCREMENT,
'title' varchar(100) NOT NULL,
'description' text NOT NULL,