wiki:TablePMsFolders

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
Last modified 11 years ago Last modified on Apr 4, 2007, 12:41:52 AM