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

<h1 style="text-align: center;">DEFAULT - content data set</h1>
<h2>[previously] structure</h2>
<ol>
<li><strong>] my-library</strong></li>
<ol>
<li><strong>] my-book</strong></li>
<ol>
<li><strong>] my-book-chapters</strong></li>
<ol>
<li><strong>] ch-000-contents</strong></li>
<ol>
<li>] art# toc</li>
</ol>
<li><strong>] ch-001-introduction</strong></li>
<ol>
<li>] art# overview</li>
</ol>
<li><strong>] ch-next-__</strong></li>
<li>] ch-999-index</li>
<li>] research</li>
<li>] strategy</li>
<li>] analysis</li>
</ol></ol></ol>
<li><strong>] my-warehouse</strong></li>
<ol>
<li><strong>] my-inventory</strong></li>
<ol>
<li><strong>] my-itemCategories</strong></li>
<ol>
<li>] itemCat-001(home)</li>
<li>] itemCat-002(auto)</li>
<li>] itemCat-003(...)</li>
</ol></ol></ol>
<li><strong>] my-server</strong></li>
<ol>
<li><strong>] my-app</strong></li>
<ol>
<li><strong>] my-procedures</strong></li>
<ol>
<li>] procedure-001()</li>
<li>] procedure-002()</li>
</ol></ol></ol>
<li><strong>] my-community</strong></li>
<ol>
<li><strong>] my-members(family)</strong></li>
<ol>
<li><strong>] my-membergroups(moms-side)</strong></li>
<ol>
<li>] person-001(mom)</li>
<li>] person-002(sibling1)</li>
<li>] moms-mom(grandma-moms-side)</li>
<li>] moms-dad(grandpa-moms-side)</li>
</ol>
<li><strong>] my-membergroups(dads-side)</strong></li>
<ol>
<li>] person-001(dad)</li>
<li>] person-002(sibling1)</li>
<li>] dads-mom(grandma)</li>
<li>] dads-dad(grandpa)</li>
</ol></ol>
<li><strong>] my-friends</strong></li>
<ol>
<li>] group-school</li>
<ol>
<li>] person-001</li>
</ol>
<li>] group-college</li>
<ol>
<li>] person-001</li>
</ol>
<li>] group-workplace-1</li>
<li>] group-workplace-2</li>
<li>] group-interest</li>
<li>] more ...</li>
</ol>
<li><strong>] my-clients</strong></li>
<ol>
<li>] wkplace-001</li>
</ol>
<li><strong>] my-servers</strong></li>
<ol>
<li>] home</li>
<li>] auto</li>
<li>] health</li>
</ol></ol>
<li><strong>] my-calendar</strong></li>
<ol>
<li><strong>] my-plans-period</strong></li>
<ol>
<li>] current</li>
<li>] next</li>
<li>] today</li>
<li>] this-week</li>
<li>] month-ahead</li>
<li>] someday</li>
</ol>
<li><strong>] my-plans-project()</strong></li>
<ol>
<li>] prj-001-life-work</li>
<li>] prj-002-life-play</li>
<li>]</li>
</ol>
<li><strong>] my-documents-period</strong></li>
<ol>
<li>]&nbsp;today</li>
<li>] week-of</li>
<li>] month-of</li>
<li>] year-of</li>
</ol>
<li><strong>] my-documents-project</strong></li>
<ol>
<li>] life-work</li>
<li>] life-play</li>
<li>]</li>
</ol></ol>
<li><strong>] my-atlas(my atlas)</strong></li>
<ol>
<li><strong>] my-maps(diet,ent,fitness)</strong></li>
<ol>
<li><strong>] my-sectors(restaurants,grocery)</strong></li>
<ol>
<li>] my location()</li>
<li>] my-location()</li>
</ol></ol></ol>
<li><strong>] my-templates</strong></li>
<ol>
<li>]&nbsp;( ADD to build script )&nbsp;</li>
</ol></ol>
<p>&nbsp;<br /><strong>-- L1 EXAMPLE STRUCTURE</strong></p>
<p>INSERT INTO `libraries` ( `name_library`, `description_library`, `parent_id`) VALUES ("My Library", "A collection of all my personal Books including Diet, Electronics, Entertainment, Fitness, Furniture, Housekeeping, Humour, Money, Transportation, Tools, Life, Politics, Religion, Motivation, Inspiration, Education", 1)</p>
<p>INSERT INTO `warehouses` (`name_warehouse`, `description_warehouse`, `parent_id`) VALUES ( "My Warehouse", "A collection of all of my personal things including Diet, Electronics, Entertainment, Fitness, Furniture, Housekeeping, Money, Transportation, Tools, ... ", 1);</p>
<p>INSERT INTO `servers` ( `name_server`, `description_server`, `parent_id`) VALUES ( "My Server", " A collecton of all my personal applications including Diet, Fitness, Entertainment, Housekeeping, Money&nbsp;...", 1);</p>
<p>INSERT INTO `communities` (`name_community`,`description_community`, `parent_id`, `dob`, `primary_location`, `email_1`, `telephone_cell`) VALUES ( "My Community", "A collection of all of my personal community members including Family, Friends, Clients and Servers", 1, NULL, NULL, NULL, NULL);</p>
<p>INSERT INTO `calendars` (`name_calendar`, `description_calendar`, `parent_id`) VALUES ("My Calendar", "A collection of all of my personal projects including Diet, Fitness, Entertainment, Housekeeping, ...",1);</p>
<p>INSERT INTO `atlases` (`name_atlas`, `code_country`, `population`, `description_atlas`) VALUES ("My Atlas", NULL, NULL, "A collection of my personal locations including Family, Friends, Clients, Servers, ...");</p>
<p><strong>&nbsp;-- L2 includes books, inventories, apps, members, plans and maps</strong></p>
<p>INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Diet", "includes MenuItems, FoodItems, ...", 1, NULL);</p>
<p>INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Entertainment", "includes TV, Sports, Recreation, Concerts", 1, NULL);<br />INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Fitness", "includes Routines, Strategies, Results", 1, NULL);<br />INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Health", "includes Conditions, Treatments, Symptoms, ...", 1, NULL);<br />INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Money", "includes Assets, Expenses, Income, Reports, ", 1, NULL);<br />INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Templates", "includes Articles by Type, Articles by Project", 1, NULL);</p>
<p>INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Diet", "includes MenuItems, FoodItems, Cookware, Dishes, ...",1);<br />INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Entertainment", "includes Movies, CD/DVD, ...",1);</p>
<p>INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Fitness", "includes Equipment, Wardrobe, ...",1);</p>
<p>INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Health", "includes Equipment, Medicines, ...",1);<br />INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Money", "includes Assets, Liabilities, Investments, ...",1);<br />INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Templates", "includes Items By Type, Items By Project, ...",1);</p>
<p>INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Diet", "includes FoodItems, MenuItems, ...", 1);<br />INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Entertainment", "includes TV, Music, ...", 1);<br />INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Fitness", "includes Workouts, ...", 1);<br />INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Health", "includes Diagnosis, Treatments", 1);<br />INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Money", "includes Budgeting, Recording, Reporting, ...", 1);<br />INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Templates", "includes Steps by Type, Steps by Project", 1);</p>
<p>INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Family", "includes immediate, moms side, dads side", 1);<br />INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Friends", "includes school, work, SM, ...", 1);<br />INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Clients", "includes byWorkType, byStatus ", 1);<br />INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Servers", "includes byWorkType, byStatus", 1);</p>
<p>INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Diet", "includes ...", 1);<br />INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Entertainment", "includes ...", 1);<br />INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Fitness", "includes ...", 1);<br />INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Health", "includes ...", 1);<br />INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Money", "includes ...", 1);</p>
<p>INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Templates", "includes ...", 1);</p>
<p><br />INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES ("Plan-Period", "includes ] today ] week ahead ] month ahead ] year ahead", 1);<br />INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES ("Document-Period", "includes ] today ] this week ] this month ] this year", 1);<br />INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES ("Plan-Project", "includes ] diet ] entertainment ] fitness ] health ] ... ", 1);<br />INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES ("Document-Project", "includes ] diet ] entertainment ] fitness ] health ] ... ", 1);</p>
<p><br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Family", "includes ...", 1);<br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Friends", "includes ...", 1);<br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Clients", "includes ...", 1);<br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Servers", "includes ...", 1);</p>
<p>-- ??</p>
<p>INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Diet", "includes ...", 1);<br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Entertainment", "includes ...", 1);<br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Fitness", "includes ...", 1);<br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Health", "includes ...", 1);<br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Money", "includes ...", 1);</p>
<p>INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Templates", "includes ...", 1);</p>
<p><strong>-- L3 ( chapters, itemCategories, procedures, memberGroups, sectors)</strong></p>
<p><strong></strong>INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 1);</p>
<p>INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 2);</p>
<p>INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 3);</p>
<p>INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 4);</p>
<p>INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 5);</p>
<div>INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 6);</div>
<div><strong>-- itemcategories</strong></div>
<div>INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 1);</div>
<div>INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 2);</div>
<div>
<div>INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 3);</div>
<div>INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 4);</div>
<div>INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 5);</div>
<div>INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 6);</div>
<div><strong>-- procedures</strong></div>
<div>INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 1);</div>
<div>INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 2);</div>
<div>INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 3);</div>
<div>INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 4);</div>
<div>INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 5);</div>
<div>INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 6);</div>
<div>
<div><strong>-- membergroups</strong></div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 1);</div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 2);</div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 3);</div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 4);</div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 5);</div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 6);</div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 7);</div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 8);</div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 9);</div>
<div>INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 10);</div>
<div><strong>-- &nbsp;EVENTS</strong></div>
<div>INSERT INTO `taskgroups` (`name_taskgroup`, `description_taskgroup`, `parent_id`) VALUES ("Taskgroup-1", "includes ... ", 1);</div>
<div>INSERT INTO `taskgroups` (`name_taskgroup`, `description_taskgroup`, `parent_id`) VALUES ("Taskgroup-1", "includes ... ", 2);</div>
<div>INSERT INTO `taskgroups` (`name_taskgroup`, `description_taskgroup`, `parent_id`) VALUES ("Taskgroup-1", "includes ... ", 3);</div>
<div>INSERT INTO `taskgroups` (`name_taskgroup`, `description_taskgroup`, `parent_id`) VALUES ("Taskgroup-1", "includes ... ", 4);</div>
<div><strong>-- LOCATION</strong></div>
<strong></strong>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 1);
<div>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 2);</div>
<div>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 3);</div>
<div>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 4);</div>
<div>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 5);</div>
<div>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 6);</div>
<div>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 7);</div>
<div>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 8);</div>
<div>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 9);</div>
<div>INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 10);</div>
<div><strong>-- L4 artice, item, step, person, task, location</strong></div>
<div>
<div>INSERT INTO `articles` (`name_article`, `description_article`, `parent_id`, `content_article`, `content_format`, `priority`, `photo`, `status`, `owner`, `sequence`, `created`, `author`, `editor`) VALUES ( 'default-article', 'default-article description', 6, 'default template', 1, -5, NULL, "Write", 1,0,'2012-10-31 21:19:17',1,1)</div>
<div>
<div>INSERT INTO `items` (`name_item`, `description_item`, `parent_id`, `cogs`, `quantity`, `unit`, `content_item`, `content_format`, `photo`, `status`, `owner`, `priority`, `created`) VALUES ('default-item','default item description', 6, 0.00, 0, 'Each', 'default item content', 1, NULL, 'Have', 1, -5, '2015-09-19 13:00:00');</div>
<div>INSERT INTO `steps` (`name_step`, `description_step`, `parent_id`, `sequence`, `start_date`, `duration`, `content_step`, `content_format`, `priority`, `created`, `photo`, `status`, `owner`) VALUES ('default-step', 'default step description', 6, 0, '2015-09-19 13:00:00', '00:00', 'content default step', 1, -5, '2015-09-19 13:00:00', NULL, 'Do', 1);</div>
<div>INSERT INTO `people` (`name_last`, `name_first`, `name_middle`, `description_person`, `email_1`, `telephone_cell`, `dob`, `primary_location`, `parent_id`, `pw`, `content_person`, `content_format`, `priority`, `photo`, `status`, `owner`, `name_twitter`, `id_g_plus`, `id_facebook`, `created`) VALUES ( 'name first', 'name last', 'name middle', 'a little about ...', 'no@email.com', '123-456-7890', '2015-01-01', NULL, 6, NULL, 'content person', 1, -5, NULL, 'status', 1, 'sospepTime', '+DonSagrott', 'facebook', '2015-01-01 13:00:00');&nbsp;</div>
<div>
<div>INSERT INTO `tasks` (`name_task`, `description_task`, `parent_id`, `start_time`, `duration`, `content_task`, `content_format`, `status`, `priority`, `photo`, `owner`, `created`) VALUES ('default-task', 'task description', '4', '2012-10-31 21:19:17', '01:00', 'content task', 1, 'To Do', -5, NULL, 1, '2012-10-31 21:19:17');</div>
<div>INSERT INTO `locations` (`name_location`, `description_location`, `parent_id`, `street1`, `street2`, `city`, `stateORprovince`, `country`, `postalORzip`, `priority`, `photo`, `status`, `owner`, `content_format`, `content_location`, `telephone`, `primary_person`, `sequence`,`url`, `created`) VALUES ('default-location', 'brief description of this location', 6, '1st street', 'Unit 12', 2, 9, 1, 'n/a', -5, NULL, 'go', 1, 1, 'location content', '?', '1', 0, 'http://','2015-09-05 15:40:54');</div>
</div>
</div>
</div>
<p>&nbsp;</p>
</div>
</div>
<h2>-- TEMPLATES BLANK (MODIFIED from mwb)</h2>
<hr />
<p>-- REMOVE id field, value<br />-- REMOVE prefix default_schema</p>
<p>-- LIBRARY BOOKS<br />INSERT INTO `libraries` (`name_library`, `description_library`, `parent_id`) VALUES ( NULL, NULL, NULL);<br />-- WAREHOUSE INVENTORIES<br />INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES (NULL, NULL, NULL);<br />-- SERVER APPS<br />INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES (NULL, NULL, NULL);<br />-- COMMUNITY MEMBERS<br />INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES (NULL, NULL, NULL);<br />-- CALENDAR PLANS<br />INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES (NULL, NULL, NULL);<br />--&nbsp;ATLAS MAPS<br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES (NULL, NULL, NULL);</p>
<p>&nbsp;</p>
<p>&nbsp;</p>

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