Return to convobot.sql CVS log

Up to [Coherent Logic Development] / ChivanetConvoBot

Begin SQL work

    1: USE chivanet_seen;
    2: DROP TABLE IF EXISTS seen;
    3: CREATE TABLE seen
    4:        (id BIGINT(20) NOT NULL AUTO_INCREMENT,
    5:        aim_server VARCHAR(255) NOT NULL,
    6:        aim_sn VARCHAR(20) NOT NULL,
    7:        aim_chatroom VARCHAR(255) NOT NULL,
    8:        sn VARCHAR(20) NOT NULL,
    9:        seen_time VARCHAR(40) NOT NULL,
   10:        PRIMARY KEY(id))
   11:        ENGINE=InnoDB DEFAULT CHARSET=utf8;
   12: