ADL Buckets - General Schema
CREATE TABLE ADL_fields_buckets (
collection	varchar(25)	NOT NULL,
unique_identifier	varchar(30)	NOT NULL,
title	varchar(100)	NOT NULL,
last_updated	timestamp(14)	NOT NULL,
w_b_coord	float(9,3)	NOT NULL,
e_b_coord	float(9,3)	NOT NULL,
n_b_coord	float(9,3)	NOT NULL,
s_b_coord	float(9,3)	NOT NULL,
other_coords	varchar(255)
subject_related_text	varchar(255)
assigned_terms	char(1)
assigned_terms_authority_list	varchar(50)
originator	varchar(255)	NOT NULL,
type	varchar(25)	NOT NULL,
frmt	varchar(25)	NOT NULL,
beginning_date	date	NOT NULL,
ending_date	date	NOT NULL,
scale	int(11)
mapname_quadname	varchar(25)
other_info	varchar(255)
) TYPE=MyISAM