edit-task

Task Name:

Task Description:

TaskGroup ID:

Start Date:

Start Time:

Duration:

Priority:

Status:

Add Photo:

Owner ID:

Content: use HTML Edit Content

<h1 style="text-align: center;">DB - inventories</h1>
<h2>[previously]</h2>
<ol>
<li><strong>[REFERENCE] 2013-05-dd new&nbsp;<a href="task?id=1658" target="_blank">template v-012</a></strong></li>
<ol>
<li>] removes VIEWS - x] view booksInLibrary, x] view ChaptersInBook,&nbsp;</li>
<li>] removes TABLES - x] Subjects, x] Events, * still present in local version&nbsp;</li>
</ol>
<li><strong>2013-05-dd x] created dbs/ renamed dbs</strong></li>
<ol>
<li>x] new format for db naming bc db-## does NOT like the - (dash),</li>
<ol>
<li>*] can create the db with - from phpAdmin but NOT from basil console&nbsp;</li>
</ol>
<li>*] dont want the underscored because they are listed as all 1 db in list</li>
<li>*] TRY db##, start with db10,&nbsp;</li>
<li>x] CREATED new dbs, db10 ... db13</li>
<li>x] use new DB gen script (v-012) to create above dbs</li>
<ol>
<li>] ERROR - view_address, view_... - MSG =&nbsp;</li>
<li>*] see DB-Template-v012&nbsp;</li>
</ol>
<li>x] CREATED new dbs, db14 ... db17</li>
<ol>
<li>x] use new DB gen script (v-012) to create above dbs, NO ERRORs, 45 successfull</li>
</ol></ol>
<li><strong>2013-05-dd x] inventory db10 -db14 - CORRECTed</strong></li>
<ol>
<li>x] view_buying</li>
<li>x] view priority</li>
</ol>
<li><strong>2013-06-02 x] PRB PG view/step - feild name consistency</strong></li>
<ol>
<li>x] ALTER TABLE &nbsp;`steps` CHANGE &nbsp;`start_time` &nbsp;`start_date` DATETIME NOT NULL DEFAULT &nbsp;'2013-05-24 13:00:00'</li>
<li>x] check db_9 - db_4 OK,&nbsp;</li>
<li>x] db_1 - db_3 - DROPPED existing steps table(no record), replaced with current</li>
<li>x] db10&nbsp;</li>
</ol>
<li><strong>2013-06-03 x] ADD missing tables</strong></li>
<ol>
<li>x] po, - used by FEA 'combine', ...</li>
<li>x] po-lines&nbsp;</li>
<li>x] TO: db_1 ... db_6 -</li>
</ol>
<li><strong>2013-06-03 ] rename db-1 ... db-10 to db18 ...</strong></li>
<ol>
<li>x] SQL = &nbsp;CREATE DATABASE &nbsp;`db18` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; DROP DATABASE &nbsp;`db-1` ;</li>
<li>*] see NOTE in NEXT #2,#3</li>
</ol>
<li><strong>2013-06-10 x] table-articles&nbsp;</strong></li>
<ol>
<li>x] UPDATE articles SET priority = '-5' WHERE priority is null;</li>
<li>x] ALTER tables db_1 - db_9 , NOT NULL, default -5</li>
<li>x] Verify db10+ = OK</li>
<li>x] verify template-v-012 = OK</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li>] &nbsp;</li>
</ol>
<h2>[next]</h2>
<ol>
<li>] CLEANUP db-1 ... db-9&nbsp;</li>
<li>*] db created in phpadmin, do NOT show up in console, EX ( db12, db13, db14 )</li>
<li>*] db-11 can be renamed as db11 BUT will not show up in console</li>
</ol>