Hi Jan, Seems simple, but... if you avoid the use of plurals, the table names will be shorter.
-Geoff -----Original Message----- From: Greg Stein [mailto:gst...@gmail.com] Sent: Thursday, April 01, 2010 3:02 PM To: Jan Horák Cc: dev@subversion.apache.org Subject: Re: SQL backend database scheme Hey Jan, A couple small nits: * maybe use "txn_id" rather than "txt_id". the latter sounds like "text" rather than "transaction", and "txn" is used in the APIs * transactions_proplist has a txnprop_id which is never referenced. I'd suggest making <txn_id, name> the primary key. Cheers, -g 2010/3/29 Jan Horák <horak.ho...@gmail.com>: > Hi everybody, > > I've prepared a database scheme of the upcoming MySQL backend, it is avaible > at: > http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100329_mysql_desi gn_v1.png > > I have arisen from BDB and FSFS backend design, some previous analyses: > http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100309_dag_struct ures_sql.pdf > http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100329_backend_op erations_analysis.pdf > > and from historic MySQL backend design: > http://homepages.paradise.net.nz/~ejrh/subversion/mysql/ > > Any ideas or comments will be appreciated. > > Jan Horak > horak.ho...@gmail.com >
