Difference between revisions of "Database Table: txtmsg"

From Dreamwidth Notes
Jump to: navigation, search
Line 1: Line 1:
{{#set:name=txtmsg|Table type=global}}
+
{{Database Table|name=txtmsg|Table type=global}}
 
[[Description::This table stores numbers and message data for text messaging. NOT specific to the TextLJ feature, which is not supported in DreamWidth.]]
 
[[Description::This table stores numbers and message data for text messaging. NOT specific to the TextLJ feature, which is not supported in DreamWidth.]]
 
= Definition =
 
= Definition =

Revision as of 12:42, 27 January 2010

  • "{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property.
  • "{{{table type}}}" is not in the list of possible values (global, clustered, other) for this property.

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