Difference between revisions of "Database Table: blockwatch events"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Converting database table to use semantic mediawiki form.)
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{#set:name=blockwatch_events|table type=global}}
+
{{Database Table|name=blockwatch_events|table type=global|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE blockwatch_events (
 
CREATE TABLE blockwatch_events (
  id int unsigned NOT NULL auto_increment,
+
    id int unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL,
+
    name varchar(255) NOT NULL,
  PRIMARY KEY (id),
+
 
  UNIQUE KEY (name)
+
    PRIMARY KEY (id),
 +
    UNIQUE KEY (name)
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer|no_out_rels=1}}
{{Database Table Footer}}
+

Latest revision as of 11:42, 7 September 2010

This is a global table.

Definition

CREATE TABLE blockwatch_events (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
 
    PRIMARY KEY (id),
    UNIQUE KEY (name)
)

Relationships