|
1451.1.2
by William Grant
Move Subject.url to Offering, and add Offering.description. Show these on the offering index. |
1 |
BEGIN; |
2 |
||
3 |
ALTER TABLE offering ADD COLUMN description TEXT; |
|
4 |
ALTER TABLE offering ADD COLUMN url TEXT; |
|
5 |
||
6 |
UPDATE offering SET url = (SELECT url FROM subject WHERE subject.subjectid = offering.subject); |
|
7 |
||
8 |
ALTER TABLE subject DROP COLUMN url; |
|
9 |
||
10 |
COMMIT; |