Difference between revisions of "Database Table: blockwatch events"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'blockwatch_events =Definition= <source lang="sql"> CREATE TABLE blockwatch_events ( id int unsigned NOT NULL auto_increment, name varchar(255) NO...')
 
 
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
[[Category: Database Table|blockwatch_events]]
+
{{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}}
=Relationships=
+
 
+
=Location=
+
[[Global database]]
+

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