| create table drg_24k_ca
(ocode varchar(50) NOT NULL,
mapname varchar(255) NOT NULL,
state varchar(50),
refcode varchar(50),
w_b_coord real NOT NULL,
e_b_coord real NOT NULL,
n_b_coord real NOT NULL,
s_b_coord real NOT NULL,
year integer,
begin date,
end date,
mbytesize_tif real,
bytesize_bro integer,
bytesize_thu integer,
ucsb_local_c varchar(50)
assigned_ter varchar(255),
subject_relat varchar(255),
alltext varchar(255),
FULLTEXT (assigned_terms, subject_related_text),
PRIMARY KEY (ocode)); |
20000201 |
2003-04-14 15:19:56 |
|
