task

DB - template - v-012

[previously]

x] DB - Template Script

] overview and version history

[currently]

x] 2013-05-12 FEA - NEW field - 'owner' FOR tasks

x] PGs - add, edit, delete, view - add fields, code
x] CLASS - Task
x] DB - table - tasks - set default value, fill fields

] 2013-05-12 PRB - don.sagrott - view/person ERROR Parametor@0 must be defined

] SET - DEFAULT VALUES for person.primary_location, location default in db_1 ... ( MAPPed to default_db script)
] CODE - in PG view/person - for person.location - still using db access code

] 2013-05-dd - FEA - NEW field - 'created' ] for each of articles, items, steps, people,

] set values
] PGs - add, edit, delete, view
]

x] 2013-05-17 - DB template -v-012

*] because recent 'field' changes have been made to the "live db" and NOT the local instance the DB GENERATION TEMPLATE needs to be verified / updated
x] ensure that each L5 table has fields of - x] created, x] owner fields,
x] SET value to NN for all int fieds (EX priority,sequence, owner),
x] specify default values for above fields,
x] ensure all EXISTING int fields are SET to NN and have a default value specified

x] 2013-05-dd PRB mySql Error with view-address

x] EDIT create view statement for view_address, view_buying, view_priority, ALTER DEFINER statement

EDIT =

x] aligned EXISTING DBS with new sql statement for this view ( were previosly created as tables )

EDIT =

x] 2013-06-04 CC 1630 db changes default

x] mergeD these 2 records
x] OR use changes as container for pending

x] NO -this PAGE record will ALSO contain pending changes in the NEXT section

[next]

]
]

[POST-GENERATION-SCRIPT-EDITS]

] EDIT(S)

] CREATE STATEMENT view_address - ALTER DEFINER statement
] CREATE STATEMENT view_scheduleR - ALTER DEFINER statement

x] DELETEd

x] table - subjects
x] table - events

x] DELETEd

x] view booksInLibrary

x] DELETEd

x] view ChaptersInBook

-- 001] CUT - DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW from ] view_address, ] view books in library , ] view chapters in book

-- 001A] ADD -

-- 002] CUT TABLE - EVENTS ( STILL in local with data)

-- 003] CUT TABLE - SUBJECTS

-- 004] ? TABLE = webpages membership

-- 005] NEW TABLE = tech_hw,

-- 006] ERROR - booksInlibrary

-- 006] CUT placeholder table viewBooksInLibrary, viewChaptersInBook

-- 007] CUT drop/create statement for these 2 views

-- 008] ERROR - view_address

-- 009] SOL - replace 'global_sospep' with sospep

-- 010] PRB ERROR - view_buying RESOL

-- 011] SOL - corrected error on syntax with 'DEFINER statement'

Details Photos Edit more

Details

ID: 1658

NAME: DB-create-v-012

DESCRIPTION: updated the DB generation template to reflect recent changes to the db structure

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

EST DURATION: 01:00:00

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

STATUS: Completed

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more