Someone else can give you an authoritative response, but I've noticed mine has notes or dates associated with some transactions. I've tweaked it from SQL scripts, but always after backing up my database. Mostly I just avoid deleting or creating any record on any table outside of GnuCash. The "name" field on all of "my" records is either "'notes'" or "'date-posted'", so it appears to be a metadata thing. I've noticed that the "'date-posted'" records also have a "null" "string_val" entry with a valid "gdate_val" entry and vice-versa which suggests a "virtual" table indirection for flexibility.
- Art ________________________________ From: Jorge Zapata <[email protected]> To: [email protected] Sent: Sunday, September 16, 2012 12:12 PM Subject: What the use of 'slots' table in gnucash with mysql Hi, I'm developing a PHP web application and I want this app to read/write into gnucash mysql database just like the program does. I have an idea what is the goal of most of the tables but I simply don't what's the use of slots table. I activated a log in mysql server just to understand which insertions are performed by gnucash in simple transactions and I've realized that every insertion involves the slots table. Can someone explain me what slots table does? If I don't want to consider sots table in my application will that cause a problem when working with the same database but using the program? Thanks -- *Ing. Jorge A. Zapata Guridi* *Software Developer* _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
