FinanceFerret/2.0/sql/user pref

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

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

SQL

<section begin=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>

<section end=sql />