Difference between revisions of "Database Table: renames"

From Dreamwidth Notes
Jump to: navigation, search
m (Create page for new table renames)
 
m (Robot: Updating: Format, definition)
 
(One intermediate revision by one other user not shown)
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">
Line 11: Line 11:
 
     touser CHAR(25),
 
     touser CHAR(25),
 
     rendate INT UNSIGNED,
 
     rendate INT UNSIGNED,
   
+
 
 
     INDEX (ownerid)
 
     INDEX (ownerid)
 
)
 
)
 
</source>
 
</source>
 
{{Database Table Footer}}
 
{{Database Table Footer}}

Latest revision as of 19:32, 22 September 2011

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