USE chivanet_seen;
DROP TABLE IF EXISTS seen;
CREATE TABLE seen
       (id BIGINT(20) NOT NULL AUTO_INCREMENT,
       aim_server VARCHAR(255) NOT NULL,
       aim_sn VARCHAR(20) NOT NULL,
       aim_chatroom VARCHAR(255) NOT NULL,
       sn VARCHAR(20) NOT NULL,
       seen_time VARCHAR(40) NOT NULL,
       PRIMARY KEY(id))
       ENGINE=InnoDB DEFAULT CHARSET=utf8;
       
