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
database [2014/05/06 00:56]
craag [Node Display]
database [2014/08/04 21:30] (current)
mfa298 [Upload RSSI]
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: 2014/08/04 21:30 by mfa298