task

SCRIPT-db_create-v-017

[previously]

  1. [REFERENCE] HAVE
    1. ] # # - script.sql create-database -  ovu, status
  2. [2015-09-20]
    1. x] # # - ADD 'url' field to locations table
  3. [00:00] NEW task
    1. x] # # - EDIT 'priority' field for steps, NOT NULL default = -5,
  4. [***] ADDed 'default records' DATA SET
    1. x] automatically generate 'content records' to populate new instance of db
    2. x] will maintain 'default data set' as a seperate file VS adding to this script
    3. *] dds will be a temporary solution until import default data, default data on public is setup 
    4. x] FILE= default-data-set.sql

[currently]

  1. ] INV
    1. ] alter table statement - steps priority NOT NULL default = -15
    2. ] alter table statement - new field = location.url 

[next]

  1. [] view problem
    1. ] download and swap 'view' scripts
  2. [] schema.mwb VS create-script.sql
    1. ] y do we need 'create' file, cant we just fwd engineer a create script?
    2. ] plus document
  3. ] FIND
    1. ] db script (stored procedure ON DB __)  sp generated the a whole new instance of db,
    2. *] didnt work on hosted server b/c of permissions
  4. x]  check db_1 ... db_x for view_address RE: PRB address-book-NF on user ###
    1. x] recreated VIEW but PRB exists
  5. *] MISSING from INVENTORY
    1. ] TABLE visits
    2. ?] tech-hw (custom)
  6. ] compare - global(35)
    1. ] has visits, no tech-hw, also has (2) dropped, bookChapters, cur script should = 32

 

Details Photos Edit more

Details

ID: 5611

NAME: DB-create-v-017

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

START DATE TIME: 2015-09-20 13:04:14

EST DURATION: 01:00:00

END DATE TIME: 2015-09-20 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