CREATE TABLE galleries (
gid int(4) unsigned NOT NULL auto_increment,
title varchar(255),
text blob,
PRIMARY KEY (gid)
);
CREATE TABLE images (
iid int(4) unsigned NOT NULL,
gid int(4) unsigned NOT NULL,
file varchar(255) NOT NULL,
title varchar(255),
text blob,
date varchar(64),
tech varchar(255),
size varchar(64),
price varchar(255),
PRIMARY KEY (iid)
);
|