USE deptdb
go

drop table enander.Person
drop table enander.Message
go

create table enander.Person
(
   userID varchar(8) NOT NULL primary key,
   FirstName varchar(20) NULL,
   LastName varchar(20) NULL
)

create table enander.Message
(
        userID varchar(8) ,
        Message varchar(1000),
        Topic  varchar(20),
        TimeStamp varchar(25)
)


insert into enander.Person values ( 'enander', 'Eric', 'Anderson')
insert into enander.Message values('enander', 'Hello World?','Hi','2000-08-17 23:32:32Z')

GO