1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3 <html xmlns="http://www.w3.org/1999/xhtml" id="sixapart-standard">
5 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
6 <meta name="generator" content="Movable Type 5.2.3" />
8 <link rel="stylesheet" href="http://defaria.com/blogs/Status/styles-site.css" type="text/css" />
9 <link rel="alternate" type="application/atom+xml" title="Atom" href="http://defaria.com/blogs/Status/atom.xml" />
10 <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://defaria.com/blogs/Status/index.xml"$>" />
12 <title>Status for Andrew DeFaria: December 10, 2006 - December 16, 2006 Archives</title>
14 <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
15 <link rel="prev" href="http://defaria.com/blogs/Status/archives/week_2006_11_26.html" title="November 26, 2006 - December 2, 2006" />
16 <link rel="next" href="http://defaria.com/blogs/Status/archives/week_2006_12_17.html" title="December 17, 2006 - December 23, 2006" />
18 <body class="layout-one-column">
20 <div id="container-inner" class="pkg">
23 <div id="banner-inner" class="pkg">
24 <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
25 <h2 id="banner-description">Searchable status reports and work log</h2>
30 <div id="pagebody-inner" class="pkg">
32 <div id="alpha-inner" class="pkg">
34 <p class="content-nav">
35 <a href="http://defaria.com/blogs/Status/archives/week_2006_11_26.html">« November 26, 2006 - December 2, 2006</a> |
36 <a href="http://defaria.com/blogs/Status/">Main</a>
37 | <a href="http://defaria.com/blogs/Status/archives/week_2006_12_17.html">December 17, 2006 - December 23, 2006 »</a>
43 <h2 class="date-header">December 14, 2006</h2>
45 <div class="entry" id="entry-601">
46 <h3 class="entry-header">Users/Sites and Projects</h3>
47 <div class="entry-content">
48 <div class="entry-body">
50 <li>Implemented schema changes for GPDB based on previous meetings</li>
52 <li>Dropped PDB_ from table names to make them shorter and more understandable</li>
54 <li>Created all new tables and mapping tables. Adjusted sequencing</li>
56 <li>Changed users table to use AXID for key. Associated changes to other tables</li>
58 <li>Added synonyms where required</li>
60 <li>Updated drop_all.sql to reflected all new tables, views and sequences</li>
62 <li>Reorienting gpdb.pm for new database layout</li>
64 <li>Initially dropped the projects_by_site view as the new data structures handle this in a different way. Later added the view back this time gathering information from 3 different tables.</li>
66 <li>Got convertdb to be able to add users, sites and projects.</li>
68 <li>Got gpdb_add_vobs.pl working again in new structure</li>
70 <li>Started getting web pages to reveal data in new structures</li>
72 <li>Working on gpdb_add_project.pl to accommodate new schema layout</li>
74 <li>Changed gpdb_add_project.pl to use sites table instead of a sites file</li>
76 <li>Changed -s parm for gpdb_add_project.pl to instead specify a site to process - default being all sites</li>
79 <p class="entry-footer">
80 <span class="post-footers">Posted by at 3:48 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000601.html">Permalink</a>