Difference between revisions of "Database Table: moods"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'moods =Definition= <source lang="sql"> CREATE TABLE moods ( moodid int(10) unsigned NOT NULL auto_increment, mood varchar(40) default NULL, par...')
(No difference)

Revision as of 17:30, 22 March 2009

Definition

CREATE TABLE moods (
  moodid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  mood VARCHAR(40) DEFAULT NULL,
  parentmood INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (moodid),
  UNIQUE KEY mood (mood)
)

Relationships

Location

Global database