← Back to branch summary

~azzar1/unity/add-show-desktop-key 

1
2
3
4
5
6
7
8
9
10

BEGIN;

ALTER TABLE offering ADD COLUMN description TEXT;
ALTER TABLE offering ADD COLUMN url TEXT;

UPDATE offering SET url = (SELECT url FROM subject WHERE subject.subjectid = offering.subject);

ALTER TABLE subject DROP COLUMN url;

COMMIT;