defaria.com/blogs/Status/archives/000601.html

   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">
   4 <head>
   5    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
   6    <meta name="generator" content="Movable Type 5.2.3" />
   7
   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" />
  11
  12    <title>Status for Andrew DeFaria: Users/Sites and Projects</title>
  13
  14    <link rel="start" href="http://defaria.com/blogs/Status/" title="Home" />
  15    <link rel="prev" href="http://defaria.com/blogs/Status/archives/000600.html" title="GPDB Bug Fixed" />
  16    <link rel="next" href="http://defaria.com/blogs/Status/archives/000602.html" title="GPDB Database performance" />
  17
  18
  19
  20
  21
  22    <script type="text/javascript" src="http://defaria.com/blogs/Status/mt-site.js"></script>
  23 </head>
  24 <body class="layout-one-column" onload="individualArchivesOnLoad(commenter_name)">
  25    <div id="container">
  26       <div id="container-inner" class="pkg">
  27
  28          <div id="banner">
  29             <div id="banner-inner" class="pkg">
  30                <h1 id="banner-header"><a href="http://defaria.com/blogs/Status/" accesskey="1">Status for Andrew DeFaria</a></h1>
  31                <h2 id="banner-description">Searchable status reports and work log</h2>
  32             </div>
  33          </div>
  34
  35          <div id="pagebody">
  36             <div id="pagebody-inner" class="pkg">
  37                <div id="alpha">
  38                   <div id="alpha-inner" class="pkg">
  39
  40                      <p class="content-nav">
  41                         <a href="http://defaria.com/blogs/Status/archives/000600.html">&laquo; GPDB Bug Fixed</a> |
  42                         <a href="http://defaria.com/blogs/Status/">Main</a>
  43                         | <a href="http://defaria.com/blogs/Status/archives/000602.html">GPDB Database performance &raquo;</a>
  44                      </p>
  45
  46                      <a id="a000601"></a>
  47                      <div class="entry" id="entry-601">
  48                         <h3 class="entry-header">Users/Sites and Projects</h3>
  49                         <div class="entry-content">
  50                            <div class="entry-body">
  51                               <ul>
  52   <li>Implemented schema changes for GPDB based on previous meetings</li>
  53
  54   <li>Dropped PDB_ from table names to make them shorter and more understandable</li>
  55
  56   <li>Created all new tables and mapping tables. Adjusted sequencing</li>
  57
  58   <li>Changed users table to use AXID for key. Associated changes to other tables</li>
  59
  60   <li>Added synonyms where required</li>
  61
  62   <li>Updated drop_all.sql to reflected all new tables, views and sequences</li>
  63
  64   <li>Reorienting gpdb.pm for new database layout</li>
  65
  66   <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>
  67
  68   <li>Got convertdb to be able to add users, sites and projects.</li>
  69
  70   <li>Got gpdb_add_vobs.pl working again in new structure</li>
  71
  72   <li>Started getting web pages to reveal data in new structures</li>
  73
  74   <li>Working on gpdb_add_project.pl to accommodate new schema layout</li>
  75
  76   <li>Changed gpdb_add_project.pl to use sites table instead of a sites file</li>
  77
  78   <li>Changed -s parm for gpdb_add_project.pl to instead specify a site to process - default being all sites</li>
  79 </ul>
  80                            </div>
  81                            <div id="more" class="entry-more">
  82
  83                            </div>
  84                         </div>
  85                         <p class="entry-footer">
  86                            <span class="post-footers">Posted by  on December 14, 2006  3:48 PM</span> <span class="separator">|</span> <a class="permalink" href="http://defaria.com/blogs/Status/archives/000601.html">Permalink</a>
  87                         </p>
  88                      </div>
  89
  90
  91
  92
  93                   </div>
  94                </div>
  95             </div>
  96          </div>
  97       </div>
  98    </div>
  99 </body>
 100 </html>