Difference between revisions of "Database Table: txtmsg"

From Dreamwidth Notes
Jump to: navigation, search
 
Line 1: Line 1:
See [[LJ features not in Dreamwidth]]
+
This table stores numbers and message data for text messaging. NOT specific to the TextLJ feature, which is not supported in DreamWidth.
  
[[Category: Unused Database Tables|txtmsg]]
+
[[Category: Database Table|txtmsg]]
 +
=Definition=
 +
<source lang="sql">
 +
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)
 +
)
 +
</source>
 +
 
 +
=Relationships=
 +
 
 +
=Location=
 +
[[Global database]]

Revision as of 23:29, 22 March 2009

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