| The creation transaction was previously used to retrieve the
created date and creator for an issue. This makes some queries
complex and error prone as well as adding inefficiency to the query.
Denormalizing a bit for easier and faster queries.
If the columns have not previously been added to SCARAB_ISSUE, this
script adds them and populates the columns with data from the
SCARAB_TRANSACTION table.
author: John McNally version: $Id: DB_1_MoveIssueCreateInfo.java 9049 2004-04-03 22:30:24Z pledbrook $ |