task

DB - inventories

[previously]

  1. [REFERENCE] 2013-05-dd new template v-012
    1. ] removes VIEWS - x] view booksInLibrary, x] view ChaptersInBook, 
    2. ] removes TABLES - x] Subjects, x] Events, * still present in local version 
  2. 2013-05-dd x] created dbs/ renamed dbs
    1. x] new format for db naming bc db-## does NOT like the - (dash),
      1. *] can create the db with - from phpAdmin but NOT from basil console 
    2. *] dont want the underscored because they are listed as all 1 db in list
    3. *] TRY db##, start with db10, 
    4. x] CREATED new dbs, db10 ... db13
    5. x] use new DB gen script (v-012) to create above dbs
      1. ] ERROR - view_address, view_... - MSG = 
      2. *] see DB-Template-v012 
    6. x] CREATED new dbs, db14 ... db17
      1. x] use new DB gen script (v-012) to create above dbs, NO ERRORs, 45 successfull
  3. 2013-05-dd x] inventory db10 -db14 - CORRECTed
    1. x] view_buying
    2. x] view priority
  4. 2013-06-02 x] PRB PG view/step - feild name consistency
    1. x] ALTER TABLE  `steps` CHANGE  `start_time`  `start_date` DATETIME NOT NULL DEFAULT  '2013-05-24 13:00:00'
    2. x] check db_9 - db_4 OK, 
    3. x] db_1 - db_3 - DROPPED existing steps table(no record), replaced with current
    4. x] db10 
  5. 2013-06-03 x] ADD missing tables
    1. x] po, - used by FEA 'combine', ...
    2. x] po-lines 
    3. x] TO: db_1 ... db_6 -
  6. 2013-06-03 ] rename db-1 ... db-10 to db18 ...
    1. x] SQL =  CREATE DATABASE  `db18` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; DROP DATABASE  `db-1` ;
    2. *] see NOTE in NEXT #2,#3
  7. 2013-06-10 x] table-articles 
    1. x] UPDATE articles SET priority = '-5' WHERE priority is null;
    2. x] ALTER tables db_1 - db_9 , NOT NULL, default -5
    3. x] Verify db10+ = OK
    4. x] verify template-v-012 = OK

[currently]

  1. ]  

[next]

  1. ] CLEANUP db-1 ... db-9 
  2. *] db created in phpadmin, do NOT show up in console, EX ( db12, db13, db14 )
  3. *] db-11 can be renamed as db11 BUT will not show up in console
Details Photos Edit more

Details

ID: 1659

NAME: DB-inventory

DESCRIPTION: changes made to existing db's

START DATE TIME: 2013-05-17 21:19:02

EST DURATION: 01:00:00

END DATE TIME: 2013-05-17 22:19:02

STATUS: To-Do

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more

photos

photos for this task

actions

Agenda Email task SMS task Priorities