AudioFerret/v1/sql/Shared

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< AudioFerret‎ | v1‎ | sql
Jump to: navigation, search

About

  • Purpose: Provides read/write globals so clients can see what's going on.
    • It might be better done through a web API, but this design doesn't require the server to also provide a web interface.
    • It might also be better done through stored procedures.

SQL

<mysql>CREATE TABLE `Shared` (

 `name` varchar(50) NOT NULL,
 `val` varchar(255) default NULL,
 `whenset` datetime default NULL,
 PRIMARY KEY  (`name`)

) ENGINE=MyISAM;</mysql>