use keck
go


/* table was keck.dbo.Memes 			*/
drop table Memes
go
create table Memes (
  mid	int	NOT NULL,
  name	char(16)  NOT NULL,
  alt_name	varchar(80)  NULL,
  context	char(16)  NULL,
  iscounter	char(1)  NULL,
  units	char(40)  NULL,
  semantics	varchar(255)  NOT NULL,
  syty	varchar(40)  NULL,
  ffmt	char(12)  NOT NULL,
  cfmt	varchar(80)  NULL,
  delim	char(2)  NULL,
  isa_mid	int	NULL,
  ctrl_mid	char(24)  NULL,
  ifmt	char(24)  NULL,
  rpt_mid	int	NULL,
  separ	char(1)  NULL,
  minv	float	NULL,
  maxv	float	NULL,
  nmin	float	NULL,
  nmax	float	NULL,
  defv	char(40)  NULL,
  nulv	char(40)  NULL,
  access	char(2)  NULL,
  comment	varchar(80)  NULL,
  uri	varchar(255)  NULL,
  startd	smalldatetime	NULL,
  endd	smalldatetime	NULL,
  uid	int	NULL,
  stamp	smalldatetime	NULL,
  wildcard	char(20)  NULL,
  tolv	float	NULL,
  map_mid	int	NULL
)
go

grant select on Memes to public
go

grant insert on Memes to tucker
go

grant delete on Memes to sla
go

grant select on Memes to deimos
go

grant insert on Memes to deimos
go

grant update on Memes to deimos
go

sp_primarykey Memes,  mid
go