task

FIX-PRB - create-db-script-v-016

[previously]

  1. [2014-12-25] FIX PRB - ADD db
    1. *] ERROR MSG- A duplicate value cannot be inserted into a unique index. [ Table name = db_owner,Constraint name = PK_db_owner_id ]
    2. x] TRY WORKAROUND - manually add record TO:TABLE db owner, used WM ide,
    3. x] RESULT = PASS - added 3 records, 18,19,20
    4. ] ( need auto increment field for id,
    5. ] can't CHANGE existing id field to autoincrement, ERROR re incompatible values(int) )
  2. [2014-12-27] FIX PRB - ERROR w/create-script
    1. ] view buying -
      1. PRB- ERROR on sort by, no field itemcategories
  3. [2014-12-27] FIX PRB - TABLES NOT VIEWS
    1. x]  view priority, view priority1
      1. PRB = these are showing up/being created as TABLES in db VS as VIEWS
    2. *] HAVE = dload of 'view priority' 'create script' from public, created as VIEW
    3. ] COMPARE to
    4. ] REPLACE IN 'db-create-script-v-016'
    5. *] HAVE = create script from schema .mwb -v-016
    6. x] TEST script for both,
    7. x] RESULT = PASS
    8. *] USE default schema - ERROR re: permissions, REMOVE line
  4. [2014-12-27] ADD db's
    1. x] # 19 -
    2. x] # 20 -
  5. [2014-12-27] create using script
    1. ] # 19 - use file import sql VS copy/paste
      1. *] PRB error on view-priority
      2. x] 30/32 created
      3. *] REM the DROP TABLE if EXISTS line, both views are created OK
      4. ]
    2. ] # 20 -
      1. *] PRB = same error
      2. x] created 2 tables for view-priority,
      3. x] delete tables
      4. x] paste 'create view' script

[currently]

  1. ]  

[next]

  1. ] TRY - paste script VS import
  2. ] TRY - genereate script from model, ] check counter #'s
Details Photos Edit more

Details

ID: 4574

NAME: FIX-PRB-DB-create-v-016

DESCRIPTION: ]

START DATE TIME: 2014-12-27 14:15:21

EST DURATION: 01:00:00

END DATE TIME: 2014-12-27 15:15:21

STATUS:

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities