Database Table: txtmsg

From Dreamwidth Notes
Revision as of 14:41, 1 April 2009 by Dreamnestia (Talk | contribs)

Jump to: navigation, search

This table stores numbers and message data for text messaging. NOT specific to the TextLJ feature, which is not supported in DreamWidth.

Definition

CREATE TABLE txtmsg (
  userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  provider VARCHAR(25) DEFAULT NULL,
  NUMBER VARCHAR(60) DEFAULT NULL,
  security enum('all','reg','friends') NOT NULL DEFAULT 'all',
  PRIMARY KEY  (userid)
)

Relationships

Location

Global database