CREATE TABLE chat ( chatid        INT                   NOT NULL  AUTO_INCREMENT,
                    linktype      TINYINT(4),
                    linkid        BIGINT,
                    poster        INT,
                    projectid     INT  UNSIGNED         NOT NULL  DEFAULT 0,
                    postdate      DATETIME,
                    inreplyto     INT                   NOT NULL  DEFAULT 0,
                    deleted       TINYINT(1)            NOT NULL  DEFAULT 0,
                    message       text,
                    summary       VARCHAR(255)          NOT NULL  DEFAULT '',
                    fullpath      TEXT                  NOT NULL,
                    leafcount     INT         UNSIGNED  NOT NULL  DEFAULT 0,
                    newestleafid  INT         UNSIGNED,
                    channelid     INT         UNSIGNED,
                    tran_flag     TINYINT(1)  UNSIGNED            DEFAULT 0,
      PRIMARY KEY ( chatid ),
            INDEX ( linktype, linkid, chatid ),
            INDEX ( linkid, linktype, poster),
            INDEX ( poster, postdate ),
            INDEX ( channelid )
                  )
           ENGINE = MyISAM
  INDEX DIRECTORY = '/home/mysql/INDEXES/INDEX1/'


CREATE TABLE chat ( chatid        INT  NOT NULL  AUTO_INCREMENT,
                    projectid     INT,
                    linktype      INT,
                    linkid        INT,
                    personaid     INT,
                    postdate      TIMESTAMP  DEFAULT  CURRENT_TIMESTAMP,
                    channelid     INT         UNSIGNED,
                    inreplyto     INT,
                    fullpath      CHAR(8),
                    message       TEXT,
                    leafcount     INT         UNSIGNED  NOT NULL  DEFAULT 0,
                    newestleafid  INT         UNSIGNED,
                    deleted       TINYINT(1)            NOT NULL  DEFAULT 0,
      PRIMARY KEY ( chatid ),
            INDEX ( projectid, linktype, linkid, personaid, postdate ),
            INDEX ( channelid )
                  )
           ENGINE = MyISAM
  INDEX DIRECTORY = '/home/mysql/INDEXES/INDEX1/'