(public).sospep.events ~ view task ~ DB-create-v-012

<h1 style="text-align: center;">DB - template - v-012</h1>
<h2>[previously]</h2>
<ol>
<li><strong>x] DB - Template Script&nbsp;</strong></li>
<ol>
<li>] <a href="/view/task?id=2793" target="_blank">overview</a> and version history&nbsp;</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li><strong>x] 2013-05-12 FEA - NEW field - 'owner' FOR tasks&nbsp;</strong></li>
<ol>
<li>x] PGs - add, edit, delete, view - add fields, code&nbsp;</li>
<li>x] CLASS - Task&nbsp;</li>
<li>x] DB - table - &nbsp;tasks &nbsp;- set default value, fill fields</li>
</ol>
<li><strong>] 2013-05-12 PRB - don.sagrott - view/person ERROR Parametor@0 must be defined</strong></li>
<ol>
<li>] SET - &nbsp;DEFAULT VALUES for person.primary_location, location default in db_1 ...<span style="background-color: #ffff00;">&nbsp;( MAPPed to default_db script)</span></li>
<li>] CODE - in PG view/person - for person.location - still using db access code&nbsp;</li>
</ol>
<li><strong>] 2013-05-dd - FEA - NEW field - 'created'&nbsp;</strong>] for each of articles, items, steps, people,&nbsp;</li>
<ol>
<li>] set values</li>
<li>] PGs - add, edit, delete, view</li>
<li>]&nbsp;</li>
</ol>
<li><strong>x] 2013-05-17 - DB template -v-012</strong></li>
<ol>
<li>*] because recent 'field' changes have been made to the "live db" and NOT the local instance &nbsp;the DB GENERATION TEMPLATE needs to be verified / updated&nbsp;</li>
<li>x] ensure that each L5 table has fields of - x] created, x] owner fields,&nbsp;</li>
<li>x] SET value to NN for all int fieds (EX priority,sequence, owner),&nbsp;</li>
<li>x] specify default values for above fields,</li>
<li>x] ensure all EXISTING int fields are SET to NN and have a default value specified</li>
</ol>
<li><strong>x] 2013-05-dd PRB mySql Error with</strong>&nbsp;view-address</li>
<ol>
<li>x] EDIT create view statement for view_address, view_buying, view_priority, ALTER DEFINER statement</li>
<ol>
<li>EDIT =</li>
</ol>
<li>x] aligned EXISTING DBS with new sql statement for this view ( were previosly created as tables ) &nbsp;</li>
<ol>
<li>EDIT =&nbsp;</li>
</ol></ol>
<li><strong>x] 2013-06-04 CC 1630 db changes default</strong></li>
<ol>
<li>x] mergeD these 2 records&nbsp;</li>
<li>x] OR use changes as container for pending&nbsp;</li>
<ol>
<li>x] NO -this PAGE record will ALSO contain pending changes in the NEXT section</li>
</ol></ol></ol>
<h2>[next]</h2>
<ol>
<li>]</li>
<li>]&nbsp;</li>
</ol>
<div>
<div>
<h2>[POST-GENERATION-SCRIPT-EDITS]</h2>
<ol>
<li><strong>] EDIT(S)</strong></li>
<ol>
<li><strong>] CREATE STATEMENT view_address -&nbsp;</strong>ALTER DEFINER statement</li>
<li><strong>] CREATE STATEMENT view_scheduleR -&nbsp;</strong>ALTER DEFINER statement</li>
</ol>
<li><strong>x] DELETEd</strong></li>
<ol>
<li>x] table - subjects</li>
<li>x] table - events &nbsp;</li>
</ol>
<li><strong>x] DELETEd</strong>&nbsp;</li>
<ol>
<li>x] view booksInLibrary</li>
</ol>
<li><strong>x] DELETEd</strong>&nbsp;</li>
<ol>
<li>x] view ChaptersInBook</li>
</ol></ol></div>
<div>-- 001] CUT - DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW from ] view_address, ] view books in library , ] view chapters in book</div>
<div>-- 001A] ADD -&nbsp;</div>
<div>-- 002] CUT TABLE - EVENTS ( STILL in local with data)</div>
<div>-- 003] CUT TABLE - SUBJECTS&nbsp;</div>
<div>-- 004] ? TABLE = webpages membership</div>
<div>-- 005] NEW TABLE = tech_hw,&nbsp;</div>
<div>-- 006] ERROR - booksInlibrary</div>
<div>-- 006] CUT placeholder table viewBooksInLibrary, viewChaptersInBook&nbsp;</div>
<div>-- 007] CUT drop/create statement for these 2 views</div>
<div>-- 008] ERROR - view_address</div>
<div>-- 009] SOL - replace 'global_sospep' with sospep</div>
<div>-- 010] PRB ERROR - view_buying RESOL</div>
<div>-- 011] SOL - corrected error on syntax with 'DEFINER statement'&nbsp;</div>
</div>

~ view task ~ TaskGroup] DB FROM [ Plan] doc-projects IN [ calendars] prj-022-sospep