Latest revision as of 20:18, 11 May 2011

This is a global table. This table stores information about interests. For associations to users, see userinterests.

Definition

CREATE TABLE interests (
    intid INT(10) UNSIGNED NOT NULL,
    intcount mediumint(8) UNSIGNED DEFAULT NULL,
 
    PRIMARY KEY  (intid)
)

@@ Line 1: / Line 1: @@
-This table stores information about interests. For associations to users, see [[Database Table: userinterests|userinterests]]
+{{Database Table|name=interests|table type=global|repo=dw-free}}
+[[Description::This table stores information about interests.]] For associations to users, see [[Database Table: userinterests|userinterests]].
-[[Category: Database Table|interests]]
+= Definition =
-=Definition=
 <source lang="sql">
 CREATE TABLE interests (
-  intid int(10) unsigned NOT NULL auto_increment,
+    intid int(10) unsigned NOT NULL,
-  interest varchar(255) NOT NULL default '',
+    intcount mediumint(8) unsigned default NULL,
-  intcount mediumint(8) unsigned default NULL,
-  PRIMARY KEY  (intid),
+    PRIMARY KEY  (intid)
-  UNIQUE interest (interest)
 )
 </source>
+{{Database Table Footer}}
-=Relationships=
-=Location=
-[[Global database]]