Обсуждение: Change to contrubitor order
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 After sitting on it for a while I see now that hackers emeritus really doesn't belong above major contributor. Please apply: BEGIN; SELECT type,typename,sortorder FROM developers_types; UPDATE developers_types SET sortorder = 1 WHERE type = 1; UPDATE developers_types SET sortorder = 2 WHERE type = 3; UPDATE developers_types SET sortorder = 4 WHERE type = 2; UPDATE developers_types SET sortorder = 3 WHERE type = 4; UPDATE developers_types SET sortorder = 5 WHERE type = 5; SELECT type,typename,sortorder FROM developers_types ORDER BY sortorder; COMMIT; Which should give you: type | typename | sortorder - ------+--------------------+----------- 1 | Core Team | 1 3 | Major Contributors | 2 4 |Minor Contributors | 3 2 | Hackers Emeritus | 4 5 | Past Contributors | 5 Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHkVFOATb/zqfZUUQRAuYwAJ4+I2tB2adOlaQqAJzNMprBCdJj0ACdHRjY dLx9xa1mBwswo8tXbZSPakQ= =OabS -----END PGP SIGNATURE-----
Joshua D. Drake wrote: > After sitting on it for a while I see now that hackers emeritus really > doesn't belong above major contributor. Please apply: > > BEGIN; > SELECT type,typename,sortorder FROM developers_types; > UPDATE developers_types SET sortorder = 1 WHERE type = 1; > UPDATE developers_types SET sortorder = 2 WHERE type = 3; > UPDATE developers_types SET sortorder = 4 WHERE type = 2; > UPDATE developers_types SET sortorder = 3 WHERE type = 4; > UPDATE developers_types SET sortorder = 5 WHERE type = 5; > SELECT type,typename,sortorder FROM developers_types ORDER BY sortorder; > COMMIT; Updated, thanks. //Magnus