Difference between revisions of "Database Table: txtmsg"

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

Revision as of 14:41, 1 April 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