Difference between revisions of "Database Table: interests"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Changing Category:Database Tables)
Line 19: Line 19:
 
[[Global database]]
 
[[Global database]]
  
[[Category: Database Tables|interests]]
+
[[Category:Database Tables Needing Conversion|interests]]

Revision as of 14:02, 2 October 2009

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

Definition

CREATE TABLE interests (
  intid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  interest VARCHAR(255) NOT NULL DEFAULT '',
  intcount mediumint(8) UNSIGNED DEFAULT NULL,
  PRIMARY KEY  (intid),
  UNIQUE interest (interest)
)

Relationships

Location

Global database