On August 8, 2009 01:05:49 pm Colin Law wrote: > 2009/8/8 Phil Longstaff <plongst...@rogers.com>: > > On August 8, 2009 04:37:26 am Colin Law wrote: > >> 2009/8/8 Marcus Wolschon <mar...@wolschon.biz>: > >> - Hide quoted text - > >> > >> > What`s the point of not having that entry for the root-account? > >> > "books" would just reference it`s guid. > >> > It`s the one thing that would make referential integrity possible > >> > when access-patterns/transactions have been changed to > >> > allow for it at some point. > >> > > >> > BTW: The database created has no index whatsoever. > >> > Somehow that does not sound right too. > >> > >> The fact that a number of the tables do not have primary keys is also > >> causing me problems. > > > > "Database created has no index whatsoever". What do you mean? Indexes (I > > assume you mean mysql) for each table based on primary key? postgresql > > creates them automatically. I have added a few indexes on large tables to > > improve query performance. What other indexes do you need? > > > > "tables do not have primary keys" - Which tables? > > recurrences, slots, taxtable_entries and versions
Since the versions table is simply a set of table_name/table_version pairs, would it work for you if the table_name was the primary key? The rows need unique table_name anyway. Phil _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
