Difference between revisions of "Database Table: rateabuse"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'rateabuse =Definition= <source lang="sql"> CREATE TABLE rateabuse ( rlid TINYINT UNSIGNED NOT NULL, userid INT UNSIGNED NOT NULL, evttime I...')
 
Line 1: Line 1:
[[Category: Database Table|rateabuse]]
+
= Definition =
=Definition=
+
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE rateabuse
 
CREATE TABLE rateabuse
Line 15: Line 15:
 
</source>
 
</source>
  
=Relationships=
+
= Relationships =
 +
 
 +
= Location =
  
=Location=
 
 
[[Global database]]
 
[[Global database]]
 +
 +
[[Category: Database Tables|rateabuse]]

Revision as of 14:09, 1 April 2009

Definition

CREATE TABLE rateabuse
(
 rlid     TINYINT UNSIGNED NOT NULL,
 userid   INT UNSIGNED NOT NULL,
 evttime  INT UNSIGNED NOT NULL,
 ip       INT UNSIGNED NOT NULL,
 enum     ENUM('soft','hard') NOT NULL,
 INDEX (rlid, evttime),
 INDEX (userid),
 INDEX (ip)
 )

Relationships

Location

Global database