Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 293608 Details for
Bug 420611
3.41 Update database code in Bugzilla 3.0 to work with data from Red Hat 2.18 Bugzilla
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
SQL script making some changes needed for checksetup.pl to run properly (v2)
fix.sql (text/plain), 15.91 KB, created by
David Lawrence
on 2008-01-31 17:47:02 UTC
(
hide
)
Description:
SQL script making some changes needed for checksetup.pl to run properly (v2)
Filename:
MIME Type:
Creator:
David Lawrence
Created:
2008-01-31 17:47:02 UTC
Size:
15.91 KB
patch
obsolete
>---Need to add isactive and sortkey to old ENUM tables and give sortkey values > >ALTER TABLE resolution ADD COLUMN isactive BOOLEAN; >UPDATE resolution SET isactive = 1; > >ALTER TABLE resolution ADD COLUMN sortkey INTEGER; >UPDATE resolution SET sortkey = 0 WHERE value = ''; >UPDATE resolution SET sortkey = 1 WHERE value = 'NOTABUG'; >UPDATE resolution SET sortkey = 2 WHERE value = 'WONTFIX'; >UPDATE resolution SET sortkey = 3 WHERE value = 'DEFERRED'; >UPDATE resolution SET sortkey = 4 WHERE value = 'WORKSFORME'; >UPDATE resolution SET sortkey = 5 WHERE value = 'CURRENTRELEASE'; >UPDATE resolution SET sortkey = 6 WHERE value = 'RAWHIDE'; >UPDATE resolution SET sortkey = 7 WHERE value = 'ERRATA'; >UPDATE resolution SET sortkey = 8 WHERE value = 'DUPLICATE'; >UPDATE resolution SET sortkey = 9 WHERE value = 'UPSTREAM'; >UPDATE resolution SET sortkey = 10 WHERE value = 'NEXTRELEASE'; >UPDATE resolution SET sortkey = 11 WHERE value = 'CANTFIX'; >UPDATE resolution SET sortkey = 12 WHERE value = 'INSUFFICIENT_DATA'; > >ALTER TABLE priority ADD COLUMN isactive BOOLEAN; >UPDATE priority SET isactive = 1; > >ALTER TABLE priority ADD COLUMN sortkey INTEGER; >UPDATE priority SET sortkey = 1 WHERE value = 'urgent'; >UPDATE priority SET sortkey = 2 WHERE value = 'high'; >UPDATE priority SET sortkey = 3 WHERE value = 'medium'; >UPDATE priority SET sortkey = 4 WHERE value = 'low'; > >ALTER TABLE bug_severity ADD COLUMN isactive BOOLEAN; >UPDATE bug_severity SET isactive = 1; > >ALTER TABLE bug_severity ADD COLUMN sortkey BOOLEAN; >UPDATE bug_severity SET sortkey = 1 WHERE value = 'urgent'; >UPDATE bug_severity SET sortkey = 2 WHERE value = 'high'; >UPDATE bug_severity SET sortkey = 3 WHERE value = 'medium'; >UPDATE bug_severity SET sortkey = 4 WHERE value = 'low'; > >ALTER TABLE rep_platform ADD COLUMN isactive BOOLEAN; >UPDATE rep_platform SET isactive = 1; > >ALTER TABLE rep_platform ADD COLUMN sortkey INTEGER; >UPDATE rep_platform SET sortkey = 0 WHERE value = 'All'; >UPDATE rep_platform SET sortkey = 1 WHERE value = 'i386'; >UPDATE rep_platform SET sortkey = 2 WHERE value = 'alpha'; >UPDATE rep_platform SET sortkey = 3 WHERE value = 'sparc'; >UPDATE rep_platform SET sortkey = 4 WHERE value = 'noarch'; >UPDATE rep_platform SET sortkey = 5 WHERE value = 'ia64'; >UPDATE rep_platform SET sortkey = 6 WHERE value = 'i586'; >UPDATE rep_platform SET sortkey = 7 WHERE value = 'i686'; >UPDATE rep_platform SET sortkey = 8 WHERE value = 'sparc64'; >UPDATE rep_platform SET sortkey = 9 WHERE value = 'sparcv9'; >UPDATE rep_platform SET sortkey = 10 WHERE value = 'alphaev6'; >UPDATE rep_platform SET sortkey = 11 WHERE value = 'athlon'; >UPDATE rep_platform SET sortkey = 12 WHERE value = 'arm7'; >UPDATE rep_platform SET sortkey = 13 WHERE value = 'arm9'; >UPDATE rep_platform SET sortkey = 14 WHERE value = 'am31'; >UPDATE rep_platform SET sortkey = 15 WHERE value = 'am33'; >UPDATE rep_platform SET sortkey = 16 WHERE value = 'mips32'; >UPDATE rep_platform SET sortkey = 17 WHERE value = 'mips64'; >UPDATE rep_platform SET sortkey = 18 WHERE value = 'mipstx39'; >UPDATE rep_platform SET sortkey = 19 WHERE value = 'mipstx49'; >UPDATE rep_platform SET sortkey = 20 WHERE value = 'mipsrm7000'; >UPDATE rep_platform SET sortkey = 21 WHERE value = 'mipsnecvr4xxx'; >UPDATE rep_platform SET sortkey = 22 WHERE value = 'powerpc'; >UPDATE rep_platform SET sortkey = 23 WHERE value = 'sh3'; >UPDATE rep_platform SET sortkey = 24 WHERE value = 'sh4'; >UPDATE rep_platform SET sortkey = 25 WHERE value = 'sparclite'; >UPDATE rep_platform SET sortkey = 26 WHERE value = 'strongarm'; >UPDATE rep_platform SET sortkey = 27 WHERE value = 'v850'; >UPDATE rep_platform SET sortkey = 28 WHERE value = 'xscale'; >UPDATE rep_platform SET sortkey = 29 WHERE value = 'other'; >UPDATE rep_platform SET sortkey = 30 WHERE value = 'synth'; >UPDATE rep_platform SET sortkey = 31 WHERE value = 's390x'; >UPDATE rep_platform SET sortkey = 32 WHERE value = 'parisc11'; >UPDATE rep_platform SET sortkey = 33 WHERE value = 'x86_64'; >UPDATE rep_platform SET sortkey = 34 WHERE value = 'ia32e'; >UPDATE rep_platform SET sortkey = 35 WHERE value = 's390'; >UPDATE rep_platform SET sortkey = 36 WHERE value = 'ppc64'; > >ALTER TABLE op_sys ADD COLUMN isactive BOOLEAN; >UPDATE op_sys SET isactive = 1; > >ALTER TABLE op_sys ADD COLUMN sortkey INTEGER; >UPDATE op_sys SET sortkey = 0 WHERE value = 'Linux'; >UPDATE op_sys SET sortkey = 1 WHERE value = 'All'; >UPDATE op_sys SET sortkey = 2 WHERE value = 'Windows'; >UPDATE op_sys SET sortkey = 3 WHERE value = 'Mac OS'; >UPDATE op_sys SET sortkey = 4 WHERE value = 'Other'; > >---Need to drop several foreign keys to allow the fielddefs table change from fieldid to id >ALTER TABLE bugs_activity DROP FOREIGN KEY bugs_activity_ibfk_4; >ALTER TABLE profiles_activity DROP FOREIGN KEY profiles_activity_ibfk_3; > >---Cannot have bug aliases the same even if different case >UPDATE bugs SET alias = NULL WHERE bug_id = 109196; >UPDATE bugs SET alias = NULL WHERE bug_id = 131589; >UPDATE bugs SET alias = NULL WHERE bug_id = 205171; >UPDATE bugs SET alias = NULL WHERE bug_id = 209253; >UPDATE bugs SET alias = NULL WHERE alias = ''; > >---Cannot use MyISAM with foreign keys assigned >ALTER TABLE longdescs DROP FOREIGN KEY longdescs_ibfk_2; >ALTER TABLE longdescs DROP FOREIGN KEY longdescs_ibfk_1; >ALTER TABLE longdescs ENGINE = MyISAM; > >---Drop foreign keys on certain tables to help alleviate errors later due to regenerating indexes >ALTER TABLE attachments DROP FOREIGN KEY attachments_ibfk_2; >ALTER TABLE attachments DROP FOREIGN KEY attachments_ibfk_1; >ALTER TABLE group_group_map DROP FOREIGN KEY group_group_map_ibfk_1; >ALTER TABLE group_group_map DROP FOREIGN KEY group_group_map_ibfk_2; > >---Some submitters in attachments table do not match ids in profiles so change to bugzilla@redhat.com >UPDATE attachments SET submitter_id = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE submitter_id = 11616; >UPDATE attachments SET submitter_id = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE submitter_id = 12963; >UPDATE attachments SET submitter_id = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE submitter_id = 17808; >UPDATE attachments SET submitter_id = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE submitter_id = 34412; >UPDATE attachments SET submitter_id = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE submitter_id = 85801; >UPDATE attachments SET submitter_id = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE submitter_id = 92468; >UPDATE attachments SET submitter_id = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE submitter_id = 160812; > >---Non-existent bug ids found in bug_group_map table need to be removed >DELETE FROM bug_group_map WHERE bug_id IN ( >105087, 105088, 105089, 105090, 105091, 105092, 105093, 105094, 105095, 105096, 105097, 105098, 105099, 105100, 105101, 105102, 105103, 105104, 105105, 105106, 105107, 105108, >105109, 105110, 105111, 105112, 105113, 105114, 105115, 105116, 105117, 105118, 105119, 105120, 105121, 105122, 105123, 105124, 105125, 105126, 105127, 105128, 105129, 105130, >105131, 105132, 105133, 105134, 105135, 105136, 105137, 105138, 105139, 105140, 105141, 105142, 105143, 105144, 105145, 105146, 105147, 105148, 105149, 105150, 105151, 105152, >105153, 105154, 105155, 105156, 105157, 105158, 105159, 105160, 105161, 105162, 105163, 105164, 105165, 105166, 105167, 105168, 105169, 105170, 105171, 105172, 105173, 105174, >105175, 105176, 105177, 105178, 105179, 105180, 105181, 105182, 105183, 105184, 105185, 105186, 105187, 105188, 105189, 105190, 105191, 105192, 105193, 105194, 105195, 105196, >105197, 105198, 105199, 105200, 105201, 105202, 105203, 105204, 105205, 105206, 105207, 105208, 105209, 105210, 105211, 105212, 105213, 105214, 105215, 105216, 105217, 105218, >105219, 105220, 105221, 105222, 105223, 105224, 105225, 105226, 105227, 105228, 105229, 105230, 105231, 105232, 105233, 105234, 105236, 105237, 105238, 105239, 105240, 105241, >105242, 105243, 105244, 105245, 105246, 105247, 105248, 105249, 105250, 105251, 105252, 105253, 105254, 105255, 105256, 105257, 105258, 105259, 105260, 105261, 105262, 105263, >105264, 105265, 105266, 105267, 105268, 105269, 105270, 105271, 105272, 105273, 105274, 105275, 105276, 105277, 105278, 105279, 105280, 105281, 105282, 105283, 105284, 105285, >105286, 105287, 105288, 105289, 105290, 105291, 105292, 105293, 105294, 105295, 105296, 105297, 105298, 105299, 105300, 105301, 105302, 105303, 105304, 105305, 105306, 105307, >105308, 105309, 105310, 105311, 105312, 105313, 105314, 105315, 105316, 105317, 105318, 105319, 105320, 105321, 105322, 105323, 105324, 105325); > >---Several bugs found with assigned_to found that do not exist in profiles >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'jbowes@redhat.com') WHERE bug_id = 19174; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'jakub@redhat.com') WHERE bug_id = 48776; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'jakub@redhat.com') WHERE bug_id = 48201; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'jakub@redhat.com') WHERE bug_id = 48282; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'karsten@redhat.com') WHERE bug_id = 48345; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'jakub@redhat.com') WHERE bug_id = 48371; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'jakub@redhat.com') WHERE bug_id = 48771; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'ggainey@redhat.com') WHERE bug_id = 57626; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'ggainey@redhat.com') WHERE bug_id = 58889; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'ggainey@redhat.com') WHERE bug_id = 59189; >UPDATE bugs SET assigned_to = (SELECT userid FROM profiles WHERE login_name = 'ggainey@redhat.com') WHERE bug_id = 59357; > >---Some bugs set to 0 for qa_contact or had an empty string ''. Change to NULL. Fix others to proper value. >UPDATE bugs SET qa_contact = NULL WHERE qa_contact = 0 OR qa_contact = ''; >UPDATE bugs SET qa_contact = (SELECT userid FROM profiles WHERE login_name = 'jclover@redhat.com') WHERE bug_id = 23867; >UPDATE bugs SET qa_contact = NULL WHERE bug_id = 58127; >UPDATE bugs SET qa_contact = NULL WHERE bug_id = 55300; >UPDATE bugs SET qa_contact = NULL WHERE bug_id = 56464; >UPDATE bugs SET qa_contact = NULL WHERE qa_contact = 105329; > >---Several rows in bugs_activity map to bugs that do not exist, so remove them >DELETE FROM bugs_activity WHERE bug_id IN (26178, 36326, 43632); > >---Several rows in bugs_activity map to attachments that do not exist so remove them >DELETE FROM bugs_activity WHERE attach_id IN (93000, 94077, 96520, 96899, 123296, 154253); > >---Several rows in bugs_acitivity have who set to non-existing profiles. Change to bugzilla@redhat.com >UPDATE bugs_activity SET who = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE who IN (0, 23, 289, 956, 1014, 7965, 8032, 11616, 12963, 16840, 17808, >80221, 160812, 162584, 164666, 182439, 211604); > >---Several rows in bugs_acitivity have fieldid set to 15 which used to be assigned_to but now should be 41 >UPDATE bugs_activity SET fieldid = 41 WHERE fieldid = 15; > >---Several rows in cc table have who set to profiles that no longer exist. Should we delete them or try to remap them? >DELETE FROM cc WHERE who IN (23, 287, 1014, 1831, 2791, 7963, 7965, 8117, 10172, 12963, 16840, 17808, 34412, 41639, 80221, 85801, 87800, 88029, 105329, 130686, 159676, 160592, >160812, 162584, 164666, 166720, 182439); > >---One component had an initialqacontact that no longer existed in the profiles table. Removing value >UPDATE components SET initialqacontact = NULL WHERE initialqacontact = 68153; > >---Some flaginclusions include product that no longer exists so remove >DELETE FROM flaginclusions WHERE product_id = 59; > >---Some rows in group_control map point to a product that no longer exists so remove >DELETE FROM group_control_map WHERE product_id = 59; > >---Product/bugs remove and comments were left behind. Removing >DELETE FROM longdescs WHERE bug_id IN (26178, 36326, 43632, 105049, 105052, 105053, 105054, 105055, 105056, 105057, 105058, 105059, 105060, 105061, 105062, 105063, 105064, 105065, 105066, 105067, 105068, 105069, 105070, >105071, 105072, 105073, 105074, 105075, 105076, 105077, 105078, 105079, 105080, 105081, 105082, 105083, 105084, 105085, 105086, 105087, 105088, 105089, 105090, 105091, 105092, >105093, 105094, 105095, 105096, 105097, 105098, 105099, 105100, 105101, 105102, 105103, 105104, 105105, 105106, 105107, 105108, 105109, 105110, 105111, 105112, 105113, 105114, >105115, 105116, 105117, 105118, 105119, 105120, 105121, 105122, 105123, 105124, 105125, 105126, 105127, 105128, 105129, 105130, 105131, 105132, 105133, 105134, 105135, 105136, >105137, 105138, 105139, 105140, 105141, 105142, 105143, 105144, 105145, 105146, 105147, 105148, 105149, 105150, 105151, 105152, 105153, 105154, 105155, 105156, 105157, 105158, >105159, 105160, 105161, 105162, 105163, 105164, 105165, 105166, 105167, 105168, 105169, 105170, 105171, 105172, 105173, 105174, 105175, 105176, 105177, 105178, 105179, 105180, >105181, 105182, 105183, 105184, 105185, 105186, 105187, 105188, 105189, 105190, 105191, 105192, 105193, 105194, 105195, 105196, 105197, 105198, 105199, 105200, 105201, 105202, >105203, 105204, 105205, 105206, 105207, 105208, 105209, 105210, 105211, 105212, 105213, 105214, 105215, 105216, 105217, 105218, 105219, 105220, 105221, 105222, 105223, 105224, >105225, 105226, 105227, 105228, 105229, 105230, 105231, 105232, 105233, 105234, 105236, 105237, 105238, 105239, 105240, 105241, 105242, 105243, 105244, 105245, 105246, 105247, >105248, 105249, 105250, 105251, 105252, 105253, 105254, 105255, 105256, 105257, 105258, 105259, 105260, 105261, 105262, 105263, 105264, 105265, 105266, 105267, 105268, 105269, >105270, 105271, 105272, 105273, 105274, 105275, 105276, 105277, 105278, 105279, 105280, 105281, 105282, 105283, 105284, 105285, 105286, 105287, 105288, 105289, 105290, 105291, >105292, 105293, 105294, 105295, 105296, 105297, 105298, 105299, 105300, 105301, 105302, 105303, 105304, 105305, 105306, 105307, 105308, 105309, 105310, 105311, 105312, 105313, >105314, 105315, 105316, 105317, 105318, 105319, 105320, 105321, 105322, 105323, 105324, 105325, 136839); > >---Some values in longdesc.who no longer exist in profiles, reassign them to bugzilla@redhat.com >UPDATE longdescs SET who = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE who IN (23, 287, 289, 453, 870, 956, 1014, 2791, 2850, 4420, 7965, 8032, >10172, 11616, 12963, 15695, 16156, 16840, 17808, 24015, 24555, 30050, 33725, 34412, 41639, 44029, 49411, 60983, 80221, 85801, 87800, 88029, 92468, 98575, 101155, 130686, 160812, >162584, 164666, 182439, 211953, 212062, 212779); > >---Bad product id in milestone table >DELETE FROM milestones WHERE product_id = 59; > >---Values in namedqueries.userid do not have match in profiles tables, so removing >DELETE FROM namedqueries WHERE userid IN (0, 23, 202, 1014, 1763, 11616, 16840, 17808, 33725, 101155); > >---Bad values in profiles_activity.userid so replacing with bugzilla@redhat.com >UPDATE profiles_activity SET userid = (SELECT userid FROM profiles WHERE login_name = 'bugzilla@redhat.com') WHERE userid IN (105329, 156511, 160812, 161845, 182439, 211658); > >---Bad values in user_group_map.user_id so removing >DELETE FROM user_group_map WHERE user_id IN (156511, 147463, 155642, 159676, 161845, 20998, 25991, 48771, 51175, 52865, 54988, 62727, 67605, 105805, 107014, 16840, 30050, 37703, >45879, 46333, 46370, 49303, 49312, 49313, 49314, 49315, 130686); > >---Bad values in user_group_map.group_id so removing >DELETE FROM user_group_map WHERE group_id = 115; > >---Bad product id in versions table >DELETE FROM versions WHERE product_id = 59; > >---Bad watcher value in watch table >DELETE FROM watch WHERE watcher = 165722; > >---Drop logincookies table and allow it to be recreated with standard 3.0 layout >DROP TABLE logincookies; >
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=293608">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 420611
:
284681
|
285731
|
285741
|
291816
|
291817
|
291818
|
292118
|
292119
|
292335
|
292336
|
292464
|
292465
|
293354
|
293546
| 293608