![]() ![]() | ![]() |
1.1 ! snw 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: