print "Using database observations"
use observations
go

print "Creating new rename_schema table"
go

Create table rename_schema
(
     schema_id tinyint not null,
     schema_string varchar(255) not null
)
go
create unique index primary_idx 
	on rename_schema ( schema_id, schema_string) 
go

grant select on rename_schema to public
grant insert on rename_schema to frameingest
grant all on rename_schema to archeso
go
