Difference between revisions of "Database Table: moodthemedata"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'moodthemedata =Definition= <source lang="sql"> CREATE TABLE moodthemedata ( moodthemeid int(10) unsigned NOT NULL default '0', moodid int(10) uns...')
(No difference)

Revision as of 17:30, 22 March 2009

Definition

CREATE TABLE moodthemedata (
  moodthemeid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  moodid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  picurl VARCHAR(100) DEFAULT NULL,
  width tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  height tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  KEY (moodthemeid),
  PRIMARY KEY  (moodthemeid,moodid)
)

Relationships

Location

Global database