Kings DB: updates to db structure

05/07/11

Permalink 11:01:40 am, by mholmes, 146 words, 115 views   English (CA)
Categories: Academic; Mins. worked: 60

Kings DB: updates to db structure

Met with PC today, and discussed the db structure. We arrived at the following changes to be made this week:

  • Replace the datePrecision field in multiple tables with a plain text field called dateInfo, in the db, and then in local_classes.php.
  • When that's done, delete the datePrecisions table from the db and from local_classes.php.
  • Add a new multiline text field called sc_citation to the sources table, and include it in local_classes.php.

PC will also send over the latest block of biblio items he's collected into Zotero in MODS output format, which I'll then try running through my mods_to_sql.xsl file to create an import file and get them into the db. It's not clear how well this will work, but if it proves relatively simple it'll be worth doing to eliminate a lot of manual data entry.

Pingbacks:

No Pingbacks for this post yet...

Depts

This blog is for work done for academic departments which does not fall under other categories.

Reports

Categories

July 2014
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

XML Feeds