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