wiki:TablePMsFolders

Version 2 (modified by julian, 12 years ago) (diff)

latin1->utf8

Database layout -> Table pms_folders

  • Columns
    • folderID SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'
      The id of the folder. It is not unique! It starts from 2 for each user (0 is reserved for inbox, 1 for outbox).
    • userID MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'
      The id of the user the folder belongs to.
    • folderName VARCHAR(255) DEFAULT '' NOT NULL
      The name of the folder.
  • Keys
    • userID (userID)
    • folderIDUserID (folderID,userID)

MySQL-Code

CREATE TABLE `pms_folders` (
  `folderID` smallint(5) unsigned NOT NULL default '0',
  `userID` mediumint(8) unsigned NOT NULL default '0',
  `folderName` varchar(255) NOT NULL default '',
  KEY `userID` (`userID`),
  KEY `folderIDUserID` (`folderID`,`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8