Difference between revisions of "Database Table: renames"

From Dreamwidth Notes
Jump to: navigation, search
m (Create page for new table renames)
 
Line 1: Line 1:
{{Database Table|name=renames|table type=global|need desc=1}}
+
{{Database Table|name=renames|table type=global|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 
<source lang="sql">
 
<source lang="sql">

Revision as of 11:45, 7 September 2010

This is a global table.

Definition

CREATE TABLE renames (
    renid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    auth CHAR(13) NOT NULL,
    cartid INT UNSIGNED,
    ownerid INT UNSIGNED NOT NULL,
    renuserid INT UNSIGNED NOT NULL,
    fromuser CHAR(25),
    touser CHAR(25),
    rendate INT UNSIGNED,
 
    INDEX (ownerid)
)

Relationships