(public).sospep.events ~ view task ~ DB-CREATE-default-data-set

<h1 style="text-align: center;">CREATE - default data set</h1>
<h2>[previously]</h2>
<ol>
<li>[REFERENCE]</li>
<ol>
<li>] # 3714 <a href="/view/task?id=3714" target="_blank">default data set</a> - example content outline</li>
</ol>
<li>[2014-05-03, 06] &gt; i] 13:30 pomo-14 NEW task IN PRB/SOL</li>
<ol>
<li>i] FIX-PRB-3934 - ALL user dbs have/NEED 'default data set'</li>
<li>*] new users can use as a reference&nbsp;for creating their own</li>
<li>]</li>
</ol>
<li>[2014-05-13]&gt; i] 09:00 - pomo-6 NEW task IN prj/DB</li>
<ol>
<li>x]&nbsp;&nbsp;#&nbsp;### - CREATE db script -v-014 FROM rev. eng SVR public</li>
</ol>
<li>[2014-12-29]</li>
<ol>
<li>] WRITE insert records script for default data set</li>
</ol>
<li>[*]</li>
<ol>
<li>] communities table has feilds for email,dob,telephone, ??= NEED for community?</li>
</ol>
<li>[2014-12-29] top level </li>
<ol>
<li>x] new&nbsp;library -&nbsp;my library</li>
<li>x] new warehouse - my warehouse</li>
<li>x] new server -&nbsp;my server</li>
<li>x] new community -&nbsp;my community</li>
<li>x] new calendar -&nbsp;my calendar</li>
<li>x] new atlas - my atlas</li>
</ol>
<li>[2014-12-29] library books =</li>
<ol>
<li>x] life == x] diet, x] entertainment x] fitness, x] health, x] money, x] templates</li>
</ol>
<li>[2014-12-29] warehouse inventories</li>
<ol>
<li>x]&nbsp;life ==&nbsp;x] diet, x] entertainment,&nbsp;x] fitness, x] health, x] money, x] templates</li>
</ol>
<li>[2014-12-30] server apps&nbsp;</li>
<ol>
<li>x]&nbsp;my server apps&nbsp;== x] diet, x] entertainment,&nbsp;x] fitness, x] health, x] money, x] templates</li>
</ol>
<li>[2014-12-30] community members</li>
<ol>
<li>x]&nbsp;my community members&nbsp;== x] family, x] friends, x] clients, x] servers</li>
<li>+] diet, ent, fitness, ...</li>
</ol>
<li>[2014-12-30] calendar plans</li>
<ol>
<li>x] my calendar plans == ] plan-period, ] plan-projects, ] document-period, ] document-project</li>
</ol>
<li>[2014-12-30] atlas maps</li>
<ol>
<li>x] my atlas maps ]</li>
<li>] ?? == fam, fr, cli, svr OR diet,ent,fit, ...</li>
<ol>
<li>] cli/svr - have diet, ent, fit AS sectors ALIGNED with</li>
</ol>
<li>] ?? ==</li>
<li>] country/state/city</li>
<li>] nations</li>
<li>] sospep.cs, ] register, confirm, thanks</li>
</ol>
<li>[2015-mm-dd] NEW task IN&nbsp;CREATE-REFERENCE - default data set (STRUCTURE)</li>
<ol>
<li>] #&nbsp;3714 - LIST-default-data-set - records to include in default data set</li>
</ol>
<li>[2015-mm-dd] NEW task TESTING</li>
<ol>
<li>] # # -&nbsp;] test with new account creation&nbsp;</li>
<li>x]&nbsp;added records successfully BUT only subjects,objects records were added, NO SYSTEM /PEOPLE/PLACES records were added,&nbsp;</li>
<li>x] only 2 levels library, books, warehouse, inventories&nbsp;</li>
</ol>
<li>[2015-09-18] NEW task IN ANA</li>
<ol>
<li>*] REVIEW= - where is 'add data' code executing? - ( looks like may have manually pasted SQL statements into empty db after running create script )&nbsp;</li>
<li>] likely in db create script -- DONT see it in current create script(v-16))</li>
<li>] MOVE to : call import_library('library'), import_warehouse('my_warehouse')</li>
</ol>
<li>[00:00] NEW task&nbsp;</li>
<ol>
<li>x] manully re paste missing data IN db (apps, members, plans, maps )</li>
<li>x] MODIFY data - ADD subject cats( diet, ent, fit, ..., ), to people</li>
<li>x] MODIFY data - ADD subject cats(diet,ent,fit,...) to places,&nbsp;</li>
<li>x] ADD data - L3 - chapters - add 6 example chapters, 1 for each book, TEST = pass</li>
<li>] REMOVE/PROMOTE templates OR &nbsp;</li>
<li>] append 'insert statements to db-create script</li>
<li>]&nbsp;</li>
</ol>
<li>&gt; [00:00] NEW task IN /pln</li>
<ol>
<li>] review existing 'data' *] found in pln/db &nbsp;</li>
<li>x] # 3714 - example 'default data set - outline and includes SQL statements, outline records dont match existing sQL statements</li>
<li>x] # 3986 - CREATE-default data set (this) -&nbsp;</li>
</ol>
<li>[00:00] NEW task&nbsp;&nbsp;# review db inv&nbsp;</li>
<ol>
<li>i] 18 - has partial default data set, ?? ] ADD bal=defaultdataset, testing SQL&nbsp;</li>
<li>x] 19 - mt,&nbsp;</li>
<li>x] 20 - mt</li>
</ol>
<li>[00:00] NEW task</li>
<ol>
<li>x] # 3714 - default data set - SQL statements updated</li>
</ol>
<li>[2015-09-19]</li>
<ol>
<li>x] # 3715 - default data set - SQL statements added(chapters, itemCategories, procedures, membergroups, taskgroups, sectors)</li>
</ol>
<li>[00:00] NEW task IN TEST&nbsp;</li>
<ol>
<li>x] correction to membergroups 0 using name_group, description_group NOT name_membergroup</li>
<li>x] db-edit - BC of existing content in taskgroups, locations, HAD to edit parent_id values to put records into the right location</li>
</ol>
<li>[00:00] NEW -default-{article} locate in template</li>
<ol>
<li>x] article,&nbsp;</li>
<li>x] item</li>
<li>x] step</li>
<li>x] person</li>
<li>x] task&nbsp;</li>
<li>x] location</li>
</ol>
<li>[sospep] NEW &nbsp;</li>
<ol>
<li>x] # # - CREATE create-v017 - add url field to locations table</li>
</ol>
<li>[] NEW task IN TEST article</li>
<ol>
<li>] PRB have to set values for fields, even though db hase defaults set,, fields = author, editor, created,&nbsp;</li>
<li>] PRB website - pulls all priority articles,&nbsp;</li>
<li>] PRB adding new article without changing title brings down website, priority SET to max OR duplicate 'default-article' titles&nbsp;</li>
<li>] PRB adding new article with changing title also brings down webste,&nbsp;</li>
</ol>
<li>[sospep] NEW task</li>
<ol>
<li>] PAGE add/article - edit name of priorityIn&nbsp;</li>
</ol>
<li>[00:00] NEW task&nbsp;</li>
<ol>
<li>*] PRB current (db) -&nbsp;</li>
<li>] ERROR on add new record (article, item, ...) ] NO 'default-article' record&nbsp;</li>
<li>] imported complete 'templates' library for each S, O,Y,&nbsp;</li>
<li>x] had to delete bunch of extra records</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>[2015-mm-dd] build the example 'content'&nbsp;set (dapp)</li>
<ol>
<li>] use user.ACCOUNT dons to CREATE records THEN export TO __, THEN&nbsp;import&nbsp;&nbsp;INTO __&nbsp;</li>
<li>] create SQL script,</li>
<li>] SCRIPT default data ADD</li>
<ol>
<li>] dapp import</li>
</ol>
<li>] SCRIPT default data REMOVE</li>
<ol>
<li>] dapp delete &nbsp;&nbsp;</li>
</ol></ol>
<li>+ [enviro] NEW task</li>
<ol>
<li>] restrict 'featurette' to priority=0 and BK=&nbsp;</li>
</ol></ol>
<h2>[next]</h2>
<ol>
<li>] DECISION - choosing "example content" for the default data set</li>
<ol>
<li>] CHOICES =</li>
<li>] MORE / ADD = x] politics, x] humour,] motivation, ] inspiration ] religion ]&gt; i] 09:30 - pomo-# NEW task IN prj/DB</li>
<li>] db_# - EDIT table /view&nbsp; ( cc PRB no results for address book, user db_#)</li>
</ol>
<li>+] UPDATE db-create-script-v-Next </li>
<ol>
<li>] ADD - default-data set ||&nbsp;</li>
</ol>
<li>+] inventory update rev-###</li>
<ol>
<li>]</li>
</ol>
<li>[00:00] STRATEGY NEXT&nbsp;</li>
<ol>
<li>] call import (default dapp), ] ?? do we have import dapp *] HAVE = import lib, import wh, ...&nbsp;</li>
<li>*] USE 6 import VS 1 import DAPP statement</li>
<li>] default data content records - maintained in templates dapp VS in sql statements script</li>
<li>] dapp = my-library, my-warehouse, my-server, my-community, my-calender, my-atlas</li>
<li>] HAVE = my-library - data set in templates</li>
<li>] MIGRATION - using existing default-data-set to build next batch of db's(21-25)</li>
</ol></ol>

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