SPC_Rule

Add "obsolete" (logical, default false) after "priority" to indicate that a custom rule is no longer to be used, but without invalidating its rule_id.

Allow for test1 and test2 to have a value from 1 to 12 inclusive, with 6 meaning "run beyond", 7 meaning "alternating about", 8 meaning "capability sigma", 9 meaning "Cpk", 10 meaning "mean", 11 meaning "Ppk", and 12 meaning "standard deviation". For test1, "above" should be appended to the end of the descriptions for 8 through 12, and for test2 "below" should be appended to the end of the descriptions for 8 through 12. Change test1 to be nullable. Rename the "rs_not_x" field to "use_for_ix". Add after it 8 more logical fields "use_for_mr", "use_for_x-bar", "use_for_range", "use_for_sigma", "use_for_ma", "use_for_ewmaix", "use_for_run", and "use_for_attr". Note that for level1 and level2, if the corresponding test is 3, 4, or 6, NULL will be used to indicate the control limits, which may be different from 3 standard deviations. If the corresponding test is 9 or 11, the units are dimensionless, and if the corresponding test is 10, the units are those of the characteristic. Modify the default data script to populate spc_rule with the "standard" set of control rules. The default data will be:

‘1 outside control limits’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, NULL, NULL, 1, 1, 50, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 0

‘2 of 3 outside of 2 std. dev.’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, 2, -2, 2, 3, 51, 0,NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 1

‘3 of 7 outside of 2 std. dev.’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, 2, -2, 3, 7, 52, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 2

‘4 of 10 outside of 2 std. dev.’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, 2, -2, 4, 10, 53, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 3

‘4 of 5 outside of 1 std. dev.’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, 1, -1, 4, 5, 54, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 4

‘7 of 7 on one side of center line’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, 0, 0, 7, 7, 55, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 5

‘8 of 8 on one side of center line’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, 0, 0, 8, 8, 56, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 6

‘8 of 8 beyond 1 std. dev.’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 6, NULL, 0, 1, NULL, 8, 8, 57, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 7

‘9 of 9 on one side of center line’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, 0, 0, 9, 9, 58, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 8

‘10 of 11 on one side of center line’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, 0, 0, 10, 11, 59, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 9

‘12 of 14 on one side of center line’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 4, 0, 0, 0, 12, 14, 60, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 10

‘6 of 6 increasing or decreasing’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 0, NULL, NULL, 6, 6, 61, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 11

‘7 of 7 increasing or decreasing’, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 0, NULL, NULL, 7, 7, 62, 0, NULL, ‘INSTALL’, ‘INSTALL’, GETUTCDATE(), GETUTCDATE(), 12