File:  [Coherent Logic Development] / ChivanetConvoBot / convobot.sql
Revision 1.1: download - view: text, annotated - select for diffs
Mon Feb 3 15:38:12 2025 UTC (8 weeks, 2 days ago) by snw
Branches: MAIN
CVS tags: HEAD
Begin SQL work

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;
       

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>