edit-task
Home
Up
Delete
Task Name:
Task Description:
adding the 'created' field to the SUBJECTS app
TaskGroup ID:
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;">FEATURE subjects - FIELD - created</h1> <h2>[WHAT]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li>] new field for SUBJECTS 'created', created is an auto generated timestamp that indicate the date/time the record was initially created</li> </ol> <h2>[WHY]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li>] </li> </ol> <h2>[WHERE]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li>] view/article - created date & time timestamp value is display in the 'details' panel of this page, value is NON EDITABLE </li> </ol> <h2>[WHEN]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li>] </li> </ol> <h2>[EXAMPLE]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li>] </li> </ol> <h2>[HOW-TO]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li>] search for articles by </li> </ol> <h2>[REFERENCE]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li>] </li> </ol><hr style="font-size: 10px; font-weight: normal;" /> <h1 style="text-align: center;">developer implementation</h1> <h2>[process]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li> </li> </ol> <h2>[notes]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li>] </li> </ol> <h2>[by_date]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li><strong>x] 2013-mm-dd FEA - subjects article - field - created</strong></li> <ol> <li><strong>x] PGs -</strong> </li> <ol> <li>] delete, </li> <li>x] view</li> </ol> <li><strong>x] CLASS - Article.cs</strong></li> <ol> <li>x] constructors, - modify to set value of property where instance creation is based upon exisiting</li> <li>x] add, - add arg for field</li> <li>x] edit, - add arg for field</li> <li>x] properties - qstring (add,edit) </li> </ol> <li><strong>x] DB - table - people ( SET default value 1, fill fields )</strong></li> <ol> <li>x] ALTER TABLE `db_9`.`locations` CHANGE `owner` `owner` INT( 11 ) NOT NULL DEFAULT '0'</li> </ol> <li><strong>] TEST - </strong></li> <ol> <li>] add </li> <li>] edit </li> <li>] view </li> </ol> <li><strong>x] publishED as ... </strong></li> <ol> <li>] rev-00#</li> </ol></ol></ol><hr style="font-size: 10px; font-weight: normal;" /> <h1 style="text-align: center;">status</h1> <h2>[current]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li> ] </li> </ol> <h2>[next]</h2> <ol style="font-size: 10px; font-weight: normal;"> <li>] check validation object for NEW FIELDS testing</li> <li><strong>x] FEATURE people - FIELD created</strong></li> <ol> <li>] ALTER TABLE `articles` ADD `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP</li> <li>] update items set created='2013-05-14 13:00:00' WHERE created='0000-00-00 00:00:00'</li> <li>] PG x] add - NOT REQURIRED - entry is created by db </li> <li>PG x] edit - read only, no edit</li> <li>PG x] view</li> </ol></ol>