use keck
go


/* table was keck.dbo.Mpaths 			*/
drop table Mpaths
go
create table Mpaths (
  mpid	int	NOT NULL,
  ptype	char(1)  NULL,
  mid	int	NOT NULL,
  sendr	int	NOT NULL,
  rcvr	int	NOT NULL,
  ctrlr	int	NOT NULL,
  medid	char(3)  NOT NULL,
  timid	char(12)  NOT NULL,
  formid	char(3)  NOT NULL,
  elaps	int	NULL,
  pcontext	char(20)  NULL,
  pcomment	varchar(255)  NULL,
  uid	smallint	NULL,
  stamp	smalldatetime	NULL,
  owner	int	NULL
)
go

grant select on Mpaths to public
go

grant insert on Mpaths to deimos
go

grant delete on Mpaths to deimos
go

grant update on Mpaths to deimos
go

sp_primarykey Mpaths,  mpid
go