create table gallery_photos (
    photo_id int(8) NOT NULL auto_increment,
    filename varchar(128),
	file_md5 varchar(128),
	title varchar(64),
	caption blob,
	seq_no int(8),
	gallery_id int(8),
	gallery_name varchar(32),
	location varchar(128),
	state varchar(64),
	country varchar(32),
	equipment varchar(128),
	photo_lat float,
	photo_lng float,
	photo_time varchar(16),
	photo_f varchar(8),
	photo_s varchar(16),
	photo_iso varchar(8),
	photo_camera varchar(16),
	photo_mm varchar(8),
	photo_mode varchar(16),
	photo_flash varchar(16),
	photo_ev varchar(8),
	photo_uts int,
	photo_x int,
	photo_y int,
	uploaded_on timestamp,
	photographer  varchar(16),
	search_string blob,
    PRIMARY KEY  (photo_id)
);

ALTER TABLE gallery_photos AUTO_INCREMENT = 10000;


create table tags (
	tag_id int(4) NOT NULL auto_increment,
	tag_name varchar(32),
	tag_desc blob,
	tag_date varchar(32),
	PRIMARY KEY  (tag_id)
);

create table photo_tags (
	photo_id int(8),
	tag_id int(4)
);


create table gallery_desc (
	gallery_id int(4) NOT NULL auto_increment,
	gallery_name varchar(32),
	gallery_desc blob,
	PRIMARY KEY  (gallery_id)
);











create table stock_photos (
    photo_id int(8) NOT NULL auto_increment,
    filename varchar(128),
	file_md5 varchar(128),
	title varchar(64),
	caption blob,
	seq_no int(8),
	gallery_id int(8),
	gallery_name varchar(32),
	location varchar(128),
	state varchar(64),
	country varchar(32),
	equipment varchar(128),
	photo_lat float,
	photo_lng float,
	photo_time varchar(16),
	photo_f varchar(8),
	photo_s varchar(16),
	photo_iso varchar(8),
	photo_camera varchar(16),
	photo_mm varchar(8),
	photo_mode varchar(16),
	photo_flash varchar(16),
	photo_ev varchar(8),
	photo_uts int,
	photo_x int,
	photo_y int,
	uploaded_on timestamp,
	photographer  varchar(16),
	search_string blob,
    PRIMARY KEY  (photo_id)
);

ALTER TABLE stock_photos AUTO_INCREMENT = 10000;


create table stock_tags (
	tag_id int(4) NOT NULL auto_increment,
	tag_name varchar(32),
	tag_desc blob,
	tag_date varchar(32),
	PRIMARY KEY  (tag_id)
);

create table stock_photo_tags (
	photo_id int(8),
	tag_id int(4)
);