edit-task

Task Description: ]

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