User Tools

Site Tools


database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
database [2014/05/06 00:56]
craag [Node Display]
database [2020/06/27 23:02] (current)
Line 31: Line 31:
  
 **Added to Schema 2014-04-26 - Mike ** **Added to Schema 2014-04-26 - Mike **
 +
 +
 +===== !msg function =====
 +Changes to bot, api and specialist gateways.
 +
 +<code sql>
 +CREATE TYPE ukhasnet.msgstate AS ENUM ('Pending', 'Sent');
 +CREATE TABLE ukhasnet.irc_msg (
 +  id              serial       NOT NULL,
 +  time            TIMESTAMP    NOT NULL DEFAULT now(),
 +  src_nick        VARCHAR(20)  NOT NULL,
 +  src_chan        VARCHAR(20)  NOT NULL,
 +  gatewayid       INT          NOT NULL,
 +  nodeid          INT          NOT NULL,
 +  message         VARCHAR(100)  NOT NULL,
 +  status          ukhasnet.msgstate NOT NULL DEFAULT 'Pending',
 +  PRIMARY KEY (id),
 +  FOREIGN KEY (nodeid) REFERENCES ukhasnet.nodes(id),
 +  FOREIGN KEY (gatewayid) REFERENCES ukhasnet.nodes(id)
 +);
 +</code>
 ===== Node Types ===== ===== Node Types =====
 This is a proposal of the changes to make to add Node Type functionality This is a proposal of the changes to make to add Node Type functionality
database.txt ยท Last modified: 2020/06/27 23:02 (external edit)