Difference between revisions of "Database Table: renames"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Updating: Format, definition)
 
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