task

SCRIPT-db_create-v-014

[previously]

  1. *] HAVE previous -v-012,
    1. *] doc records show -v-013, looks like it only had 'minor' revisions
  2. x] FORWARD ENGINEER - create script from existing db_instance - global
    1. x] use most recent 'reverse engineerED' version of __
  3. x] DROP VIEW viewBooksInLibrary
    1. x]
  4. x] DROP VIEW viewChaptersInBook
    1. x]
  5. x] COMPARE - VERSUS - DB17 ( this was the last db generated )
    1. x] use svr phpAdmin to Export structure ( this is unformatted text, hard to read )
    2. x] use workbench to build 'model' from script  (reverse engineer)
    3. x] use workbench to build create 'script' from model ( forward engineer)
    4. * loc = my db/
  6. x] COMPARE: db17 TO:  db_create-v-014 - 14 - DOESNT HAVE
    1. ] tech_hw table
    2. Dep] viewBooksInLibrary
    3. Dep] viewChaptersInBook
    4. Dep] webPagesMembership
  7. *] MISSING from INVENTORY
    1. ] visits
  8. x] VERIFY -v-013 changes
    1. x] TABLE webpagesMember dropped
    2. x] field  
    3. *] DID NOT - reorder tables in APP structure VS alpha order
  9. x] VERIFY -v-013-rev-001 changes
    1. x] add photo field to {L2} books
    2. x] size photo field 1024

[currently]

  1. > x]  check db_1 ... db_x for view_address RE: PRB address-book-NF on user ###
    1. x] recreated VIEW but PRB exists

[next]

  1. ]
Details Photos Edit more

Details

ID: 3965

NAME: DB-create-v-014

DESCRIPTION: generate new template (-v-014) from CURRENT sospep

START DATE TIME: 2014-04-22 13:04:14

EST DURATION: 01:00:00

END DATE TIME: 2014-04-22 14:04:14

STATUS: Completed

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities