FinanceFerret/tables/user pref

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

About

  • History:
    • 2010-05-02 Created so we can store user's preferences for viewing Transactions

SQL

<mysql>CREATE TABLE `user_pref` (

   ID      INT(4)           NOT NULL AUTO_INCREMENT,
   ID_User INT(4)       DEFAULT NULL COMMENT "ID of user; NULL = general/default setting",
   Name    VARCHAR(127)     NOT NULL COMMENT "name of setting",
   Value   VARCHAR(255) DEFAULT NULL COMMENT "value of setting",
   PRIMARY KEY (`ID`)
) ENGINE = MYISAM;</mysql>