print "Using database observations"
use observations
go

print "Creating table dp_check"
Create table dp_check
(
	dp_id		varchar(45) not null,
	keyword		varchar(50) null,
        value_hdr	varchar(50) null,
	value_db	varchar(50) null
)
go
print "Creating indices on dp_check table"
create index dp_id on dp_check (dp_id)
go

print "Granting"
grant select on dp_check to public
grant all on dp_check to frameingest
grant insert on dp_check to www
go