edit-task
Home
Up
Delete
Task Name:
Task Description:
this is the default 'data-set' that will be included in any users initial sospep (vs just having a blank canvas)
TaskGroup ID:
Start Date:
Start Time:
Duration:
Priority:
Status:
To Do
Completed
In Process
Add Photo:
Owner ID:
Content:
use HTML
Edit Content
<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>] 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>] ( ADD to build script ) </li> </ol></ol> <p> <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 ...", 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> -- 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>-- 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'); </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> </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 />-- ATLAS MAPS<br />INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES (NULL, NULL, NULL);</p> <p> </p> <p> </p>