3 id int(11) NOT NULL auto_increment,
7 ALTER TABLE Images ADD COLUMN filename varchar(255) NOT NULL default '';
8 ALTER TABLE Images ADD COLUMN ontable varchar(32) NOT NULL default '';
9 ALTER TABLE Images ADD COLUMN onid int(11) NOT NULL default '0';
10 ALTER TABLE Images ADD COLUMN mimetype varchar(128) NOT NULL default '';
11 ALTER TABLE Images ADD COLUMN width int(11) NOT NULL default '0';
12 ALTER TABLE Images ADD COLUMN height int(11) NOT NULL default '0';
13 ALTER TABLE Images ADD COLUMN filesize int(11) NOT NULL default '0';
14 ALTER TABLE Images ADD COLUMN displayorder int(11) NOT NULL default '0';
15 ALTER TABLE Images ADD COLUMN language varchar(6) NOT NULL default 'en';
16 ALTER TABLE Images ADD COLUMN parent_image_id int(11) NOT NULL default '0';
18 ALTER TABLE Images ADD COLUMN created datetime ;
19 ALTER TABLE Images ADD COLUMN imgtype VARCHAR(32) DEFAULT '' NOT NULL;
20 ALTER TABLE Images ADD COLUMN linkurl VARCHAR(254) DEFAULT '' NOT NULL;
21 ALTER TABLE Images ADD COLUMN descript TEXT DEFAULT '' NOT NULL;
22 ALTER TABLE Images ADD COLUMN title VARCHAR(128) DEFAULT '' NOT NULL;
24 ALTER TABLE Images CHANGE COLUMN mimetype mimetype varchar(128) NOT NULL default '';
27 -- ALTER TABLE Images ALTER COLUMN mimetype TYPE varchar(128) ;
29 ALTER TABLE Images ADD INDEX lookup(ontable, onid);
31 ALTER TABLE Images ADD INDEX lookupc(created, ontable, onid