FinanceFerret/2.0/sql/user pref: Difference between revisions

From Woozle Writes Code
< FinanceFerret‎ | 2.0‎ | sql
Jump to navigation Jump to search
(Created page with '==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` ( …')
 
m (1 revision imported: stuff I missed the first time)
(No difference)

Revision as of 13:45, 2 March 2020

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 />

Retrieved from "https://wooz.dev/mw/index.php?title=FinanceFerret/2.0/sql/user_pref&oldid=383"