home *** CD-ROM | disk | FTP | other *** search
- UPDATE so.conceptualfield SET fieldnumber=90, offset=90 WHERE conceptualtable_id=8 AND name='document_id';
- UPDATE so.conceptualfield SET fieldnumber=18, offset=54 WHERE conceptualtable_id=8 AND name='project_id';
- UPDATE so.conceptualfield SET fieldnumber=19, offset=58 WHERE conceptualtable_id=8 AND name='mother_id';
- UPDATE so.conceptualfield SET fieldnumber=20, offset=62 WHERE conceptualtable_id=8 AND name='userdef_id';
- UPDATE so.conceptualfield SET fieldnumber=21, offset=66 WHERE conceptualtable_id=8 AND name='document_id';
-
- UPDATE so.physicalfield SET offset=54 WHERE id=96;
- UPDATE so.physicalfield SET offset=58 WHERE id=97;
- UPDATE so.physicalfield SET offset=62 WHERE id=98;
- UPDATE so.physicalfield SET offset=66 WHERE id=95;
-
-
- UPDATE so.conceptualfield SET fieldnumber=90, offset=90 WHERE conceptualtable_id=29 AND name='document_id';
- UPDATE so.conceptualfield SET fieldnumber=18, offset=54 WHERE conceptualtable_id=29 AND name='project_id';
- UPDATE so.conceptualfield SET fieldnumber=19, offset=58 WHERE conceptualtable_id=29 AND name='mother_id';
- UPDATE so.conceptualfield SET fieldnumber=20, offset=62 WHERE conceptualtable_id=29 AND name='userdef_id';
- UPDATE so.conceptualfield SET fieldnumber=21, offset=66 WHERE conceptualtable_id=29 AND name='document_id';
-
- UPDATE so.physicalfield SET offset=54 WHERE id=266;
- UPDATE so.physicalfield SET offset=58 WHERE id=267;
- UPDATE so.physicalfield SET offset=62 WHERE id=268;
- UPDATE so.physicalfield SET offset=66 WHERE id=265;
-
-
- ALTER TABLE SO.appointment RENAME document_id TO tmp_id;
- ALTER TABLE SO.appointment ADD document_id INT;
- UPDATE SO.appointment SET document_id = userdef_id;
- UPDATE SO.appointment SET userdef_id = mother_id;
- UPDATE SO.appointment SET mother_id = project_id;
- UPDATE SO.appointment SET project_id = tmp_id;
- ALTER TABLE SO.appointment DELETE tmp_id;
-
- ALTER TABLE SO.mailappointment RENAME document_id TO tmp_id;
- ALTER TABLE SO.mailappointment ADD document_id INT;
- UPDATE SO.mailappointment SET document_id = userdef_id;
- UPDATE SO.mailappointment SET userdef_id = mother_id;
- UPDATE SO.mailappointment SET mother_id = project_id;
- UPDATE SO.mailappointment SET project_id = tmp_id;
- ALTER TABLE SO.mailappointment DELETE tmp_id;
-
- GRANT SELECT, UPDATE, INSERT, DELETE ON SO.appointment TO SOUSER;
- GRANT SELECT, UPDATE, INSERT, DELETE, REFERENCES ON SO.appointment TO SOADMIN;
-
- GRANT SELECT, UPDATE, INSERT, DELETE ON SO.mailappointment TO SOUSER;
- GRANT SELECT, UPDATE, INSERT, DELETE, REFERENCES ON SO.mailappointment TO SOADMIN;
-
- commit;
-
-