-- AllFactsWidthTestParameters.sql
/* 2014-08-22 Tom Holden ve3meo
Used after running the results of AllFactsWidthTestGenerate.sql

*/

-- set all fact types to use Description
UPDATE FactTypeTable
  SET UseValue = 1
  WHERE FactTypeID <> 901
;

-- Option to make all other fields non-null
BEGIN TRANSACTION;
DELETE FROM EventTable WHERE EventType = 901; -- Putting the test string into DNA Details causes an access vilation in RM 
UPDATE EventTable SET FamilyID = 1;
UPDATE EventTable SET PlaceID = 0;
UPDATE EventTable SET SiteID = 0;
UPDATE EventTable SET Date = 'D.+19230224..+00000000..';
UPDATE EventTable SET SortDate = 6712135874704834572;
UPDATE EventTable SET IsPrimary = 0;
UPDATE EventTable SET IsPrivate = 0;
UPDATE EventTable SET Proof = 0;
UPDATE EventTable SET Status = 0;
UPDATE EventTable SET EditDate = 41870.7534277662;
UPDATE EventTable SET Sentence = CAST('' AS BLOB);
UPDATE EventTable SET Note = CAST('' AS BLOB);
COMMIT TRANSACTION;