[Refdb-users] Initial setup of databases

[Markus H. <mar...@mh...>]

Hi Todd,

Todd Wallentine writes:
 > I am working on getting RefDB 0.9.4 setup for my research group and 
 > needed some clarification.  My understanding is that there is supposed 
 > to be a refdb database that is the "system" database.  I am then 
 > supposed to create a new database that will store the actual reference 
 > information.  Is that right so far?
 > 

Yes that's right. Every RefDB installation needs exactly one system
database which is called "refdb" in the current release. On the
contrary, you may have as many reference databases as you like,
although it's a good idea to keep all references in a single database.

 > Ok, so what tables are supposed to be in the "refdb" database?  Just 
 > t_journal_words, CITSTYLE, REFSTYLE, SEPARATORS, and POSITION?  Or do I 
 > add the other t_* tables to it as well?
 > 
 > Now, when I create a new database with refdba, what tables should this 
 > create?  For example, if I do "create foo" and then look at the tables 
 > in the database, what should I see?
 > 
The manual has more details about it, but you can simply have a look
at the SQL scripts shipped with RefDB. refdb.dump creates the system
database "refdb" and creates the following tables (verify this by
running 'grep "CREATE TABLE" *' in the scripts subdirectory):

refdb.dump:CREATE TABLE CITSTYLE (
refdb.dump:CREATE TABLE POSITIONS (
refdb.dump:CREATE TABLE REFSTYLE (
refdb.dump:CREATE TABLE SEPARATORS (

The reference databases currently contain the following tables, as
seen in empty.mysql.dump:

empty.mysql.dump:CREATE TABLE t_author (
empty.mysql.dump:CREATE TABLE t_keyword (
empty.mysql.dump:CREATE TABLE t_meta (
empty.mysql.dump:CREATE TABLE t_note (
empty.mysql.dump:CREATE TABLE t_periodical (
empty.mysql.dump:CREATE TABLE t_refdb (
empty.mysql.dump:CREATE TABLE t_user (
empty.mysql.dump:CREATE TABLE t_xauthor (
empty.mysql.dump:CREATE TABLE t_xkeyword (
empty.mysql.dump:CREATE TABLE t_xnote (
empty.mysql.dump:CREATE TABLE t_xuser (

regards,
Markus


-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de