imageboards

Hey ^EXPERT _PROGRAMMERS
I want to make something that'll archive the imageboards I want. I know the text field is limited to 2000 characters, but what about the name/mail/subject ones? Oh, and how does it work with unicode characters?

From AoRF's (slightly modified) script:

create table if not exists $self->{table} (
    num int unsigned primary key not null,
    parent int unsigned,
    timestamp int unsigned,
    preview text,
    preview_w smallint unsigned,
    preview_h smallint unsigned,
    media text,
    media_w smallint unsigned,
    media_h smallint unsigned,
    media_size INT unsigned,
    media_hash tinytext,

    spoiler bool,
    deleted bool,
    capcode ENUM('N', 'M', 'A') not null default 'N',

    email tinytext,
    name text,
    trip tinytext,
    title text,
    comment text,
   
    index parent_index(parent),
    index media_hash_index(media_hash(8)),
    index name_index(name(10)),
    index trip_index(trip(8)),

    fulltext index comment_index(comment)
) engine=myisam;

You'll need at least another field for the full size image (three if you want the dimensions). MyISAM because of the FULLTEXT search. Or you could just put everything except comment_index on an InnoDB table and num + comment_index on a MyISAM one.