task

DEFAULT - content data set

[previously] structure

  1. ] my-library
    1. ] my-book
      1. ] my-book-chapters
        1. ] ch-000-contents
          1. ] art# toc
        2. ] ch-001-introduction
          1. ] art# overview
        3. ] ch-next-__
        4. ] ch-999-index
        5. ] research
        6. ] strategy
        7. ] analysis
  2. ] my-warehouse
    1. ] my-inventory
      1. ] my-itemCategories
        1. ] itemCat-001(home)
        2. ] itemCat-002(auto)
        3. ] itemCat-003(...)
  3. ] my-server
    1. ] my-app
      1. ] my-procedures
        1. ] procedure-001()
        2. ] procedure-002()
  4. ] my-community
    1. ] my-members(family)
      1. ] my-membergroups(moms-side)
        1. ] person-001(mom)
        2. ] person-002(sibling1)
        3. ] moms-mom(grandma-moms-side)
        4. ] moms-dad(grandpa-moms-side)
      2. ] my-membergroups(dads-side)
        1. ] person-001(dad)
        2. ] person-002(sibling1)
        3. ] dads-mom(grandma)
        4. ] dads-dad(grandpa)
    2. ] my-friends
      1. ] group-school
        1. ] person-001
      2. ] group-college
        1. ] person-001
      3. ] group-workplace-1
      4. ] group-workplace-2
      5. ] group-interest
      6. ] more ...
    3. ] my-clients
      1. ] wkplace-001
    4. ] my-servers
      1. ] home
      2. ] auto
      3. ] health
  5. ] my-calendar
    1. ] my-plans-period
      1. ] current
      2. ] next
      3. ] today
      4. ] this-week
      5. ] month-ahead
      6. ] someday
    2. ] my-plans-project()
      1. ] prj-001-life-work
      2. ] prj-002-life-play
      3. ]
    3. ] my-documents-period
      1. ] today
      2. ] week-of
      3. ] month-of
      4. ] year-of
    4. ] my-documents-project
      1. ] life-work
      2. ] life-play
      3. ]
  6. ] my-atlas(my atlas)
    1. ] my-maps(diet,ent,fitness)
      1. ] my-sectors(restaurants,grocery)
        1. ] my location()
        2. ] my-location()
  7. ] my-templates
    1. ] ( ADD to build script ) 

 
-- L1 EXAMPLE STRUCTURE

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)

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);

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);

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);

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);

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, ...");

 -- L2 includes books, inventories, apps, members, plans and maps

INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Diet", "includes MenuItems, FoodItems, ...", 1, NULL);

INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Entertainment", "includes TV, Sports, Recreation, Concerts", 1, NULL);
INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Fitness", "includes Routines, Strategies, Results", 1, NULL);
INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Health", "includes Conditions, Treatments, Symptoms, ...", 1, NULL);
INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Money", "includes Assets, Expenses, Income, Reports, ", 1, NULL);
INSERT INTO `books` (`name_book`, `description_book`, `parent_id`, `photo`) VALUES ("Templates", "includes Articles by Type, Articles by Project", 1, NULL);

INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Diet", "includes MenuItems, FoodItems, Cookware, Dishes, ...",1);
INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Entertainment", "includes Movies, CD/DVD, ...",1);

INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Fitness", "includes Equipment, Wardrobe, ...",1);

INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Health", "includes Equipment, Medicines, ...",1);
INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Money", "includes Assets, Liabilities, Investments, ...",1);
INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES ("Templates", "includes Items By Type, Items By Project, ...",1);

INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Diet", "includes FoodItems, MenuItems, ...", 1);
INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Entertainment", "includes TV, Music, ...", 1);
INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Fitness", "includes Workouts, ...", 1);
INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Health", "includes Diagnosis, Treatments", 1);
INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Money", "includes Budgeting, Recording, Reporting, ...", 1);
INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES ("Templates", "includes Steps by Type, Steps by Project", 1);

INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Family", "includes immediate, moms side, dads side", 1);
INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Friends", "includes school, work, SM, ...", 1);
INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Clients", "includes byWorkType, byStatus ", 1);
INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Servers", "includes byWorkType, byStatus", 1);

INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Diet", "includes ...", 1);
INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Entertainment", "includes ...", 1);
INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Fitness", "includes ...", 1);
INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Health", "includes ...", 1);
INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Money", "includes ...", 1);

INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES ("Templates", "includes ...", 1);


INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES ("Plan-Period", "includes ] today ] week ahead ] month ahead ] year ahead", 1);
INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES ("Document-Period", "includes ] today ] this week ] this month ] this year", 1);
INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES ("Plan-Project", "includes ] diet ] entertainment ] fitness ] health ] ... ", 1);
INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES ("Document-Project", "includes ] diet ] entertainment ] fitness ] health ] ... ", 1);


INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Family", "includes ...", 1);
INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Friends", "includes ...", 1);
INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Clients", "includes ...", 1);
INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Servers", "includes ...", 1);

-- ??

INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Diet", "includes ...", 1);
INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Entertainment", "includes ...", 1);
INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Fitness", "includes ...", 1);
INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Health", "includes ...", 1);
INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Money", "includes ...", 1);

INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES ("Templates", "includes ...", 1);

-- L3 ( chapters, itemCategories, procedures, memberGroups, sectors)

INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 1);

INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 2);

INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 3);

INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 4);

INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 5);

INSERT INTO `chapters` (`name_chapter`, `description_chapter`, `parent_id`) VALUES ("Chapter-1", "includes ... ", 6);
-- itemcategories
INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 1);
INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 2);
INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 3);
INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 4);
INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 5);
INSERT INTO `itemCategories` (`name_itemCategory`, `description_itemCategory`, `parent_id`) VALUES ("ItemCategory-1", "includes ... ", 6);
-- procedures
INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 1);
INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 2);
INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 3);
INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 4);
INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 5);
INSERT INTO `procedures` (`name_procedure`, `description_procedure`, `parent_id`) VALUES ("Procedure-1", "includes ... ", 6);
-- membergroups
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 1);
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 2);
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 3);
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 4);
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 5);
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 6);
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 7);
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 8);
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 9);
INSERT INTO `membergroups` (`name_group`, `description_group`, `parent_id`) VALUES ("MemberGroup-1", "includes ... ", 10);
--  EVENTS
INSERT INTO `taskgroups` (`name_taskgroup`, `description_taskgroup`, `parent_id`) VALUES ("Taskgroup-1", "includes ... ", 1);
INSERT INTO `taskgroups` (`name_taskgroup`, `description_taskgroup`, `parent_id`) VALUES ("Taskgroup-1", "includes ... ", 2);
INSERT INTO `taskgroups` (`name_taskgroup`, `description_taskgroup`, `parent_id`) VALUES ("Taskgroup-1", "includes ... ", 3);
INSERT INTO `taskgroups` (`name_taskgroup`, `description_taskgroup`, `parent_id`) VALUES ("Taskgroup-1", "includes ... ", 4);
-- LOCATION
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 1);
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 2);
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 3);
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 4);
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 5);
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 6);
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 7);
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 8);
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 9);
INSERT INTO `sectors` (`name_sector`, `description_sector`, `parent_id`) VALUES ("Sector-1", "includes ... ", 10);
-- L4 artice, item, step, person, task, location
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)
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');
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);
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'); 
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');
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');

 

-- TEMPLATES BLANK (MODIFIED from mwb)

-- REMOVE id field, value
-- REMOVE prefix default_schema

-- LIBRARY BOOKS
INSERT INTO `libraries` (`name_library`, `description_library`, `parent_id`) VALUES ( NULL, NULL, NULL);
-- WAREHOUSE INVENTORIES
INSERT INTO `inventories` (`name_inventory`, `description_inventory`, `parent_id`) VALUES (NULL, NULL, NULL);
-- SERVER APPS
INSERT INTO `apps` (`name_app`, `description_app`, `parent_id`) VALUES (NULL, NULL, NULL);
-- COMMUNITY MEMBERS
INSERT INTO `members` (`name_member`, `description_member`, `parent_id`) VALUES (NULL, NULL, NULL);
-- CALENDAR PLANS
INSERT INTO `plans` (`name_plan`, `description_plan`, `parent_id`) VALUES (NULL, NULL, NULL);
-- ATLAS MAPS
INSERT INTO `maps` (`name_map`, `description_map`, `parent_id`) VALUES (NULL, NULL, NULL);

 

 

Details Photos Edit more

Details

ID: 3714

NAME: DB-default-data-set

DESCRIPTION: this is the default 'data-set' that will be included in any users initial sospep (vs just having a blank canvas)

START DATE TIME: 2014-03-25 12:29:08

EST DURATION: 01:00:00

END DATE TIME: 2014-03-25 13:29:08

STATUS: To-Do

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities