DROP TABLE person;
CREATE TABLE person(
       pidm int PRIMARY KEY,
       username varchar(10));
       
DROP TABLE here_now;
CREATE TABLE here_now(
       pidm int REFERENCES person,
       location char(40),
       now timestamp);
       
DROP TABLE last_read;
CREATE TABLE last_read(
	  last timestamp,
	  location char(40) UNIQUE);
		     
DROP TABLE newtime;
CREATE TABLE newtime(
          new_t timestamp);
	  
INSERT
INTO person
VALUES (53, 'chip');

INSERT
INTO person
VALUES (23, 'marwan');

INSERT
INTO person
VALUES (11, 'hassan');

INSERT
INTO person
VALUES (33, 'chrisma');

INSERT
INTO person
VALUES (18, 'uptongl');

INSERT
INTO person
VALUES (13, 'rabah');

INSERT
INTO person
VALUES (00, 'joshh');

INSERT
INTO person
VALUES (12, 'alarha');

INSERT
INTO person
VALUES (63, 'jrogers');

INSERT
INTO person
VALUES (43, 'charliep');