← Back to branch summary

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

« back to all changes in this revision

Viewing changes to userdb/migrations/20080707-01.sql

  • Committer: chadnickbok
  • Date: 2009-01-19 22:56:46 UTC
  • Revision ID: svn-v3-trunk0:2b9c9e99-6f39-0410-b283-7f802c844ae2:trunk:1170
This commit fixes issue #10 and part of issue #9

There are now two options for moving files with their
svn history intact; svn move and svn copy. These
use the svn commands to move the files, allowing students
to move and rename files without their histories being
lost.

This commit also shows the svn status of a dir, if it is
the 'head' of an svn repository.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/migrations/20080707-01.sql
 
1
BEGIN;
 
2
 
 
3
CREATE TABLE subject (                                                               
 
4
    subjectid       SERIAL PRIMARY KEY NOT NULL,
 
5
    subj_code       VARCHAR UNIQUE NOT NULL,
 
6
    subj_name       VARCHAR NOT NULL,
 
7
    subj_short_name VARCHAR,    -- may be null
 
8
    url             VARCHAR
 
9
);
 
10
  
 
11
DELETE FROM offering;
 
12
ALTER TABLE offering DROP COLUMN subj_code;
 
13
ALTER TABLE offering DROP COLUMN subj_name;
 
14
ALTER TABLE offering DROP COLUMN url;
 
15
ALTER TABLE offering ADD COLUMN subject INT4 REFERENCES subject (subjectid) NOT NULL;
 
16
 
 
17
COMMIT;
 
18