Difference between revisions of "Database Table: site messages"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'site_messages =Definition= <source lang="sql"> CREATE TABLE site_messages ( mid INT UNSIGNED NOT NULL AUTO_INCREMENT, time_start INT...')
 
Line 1: Line 1:
[[Category: Database Table|site_messages]]
+
= Definition =
=Definition=
+
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE site_messages (
 
CREATE TABLE site_messages (
Line 14: Line 14:
 
</source>
 
</source>
  
=Relationships=
+
= Relationships =
 +
 
 +
= Location =
  
=Location=
 
 
[[Global database]]
 
[[Global database]]
 +
 +
[[Category: Database Tables|site_messages]]

Revision as of 15:38, 31 March 2009

Definition

CREATE TABLE site_messages (
  mid           INT UNSIGNED NOT NULL AUTO_INCREMENT,
  time_start    INT UNSIGNED NOT NULL DEFAULT '0',
  time_end      INT UNSIGNED NOT NULL DEFAULT '0',
  active        ENUM('Y','N') NOT NULL DEFAULT 'Y',
  text          TEXT NOT NULL DEFAULT '',
  PRIMARY KEY (mid),
  INDEX (time_start),
  INDEX (time_end)
)

Relationships

Location

Global database