← Back to branch summary

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

« back to all changes in this revision

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

  • Committer: Matt Giuca
  • Date: 2009-02-24 02:02:03 UTC
  • mto: This revision was merged to the branch mainline in revision 1119.
  • Revision ID: matt.giuca@gmail.com-20090224020203-aqdcjnsj6y7wl32o
Added a new look to the IVLE header bar. Mmmm... Web 2.0.
Added top-level directory image-source, containing SVG and script files for
    generating the images.
ivle/webapp/coremedia/images: Added 'chrome' directory containing the rendered
    images.
Modified ivle/webapp/base/ivle-headings.html and
    ivle/webapp/coremedia/ivle.css to support the new images.
    Note that the H1 and H2 at the top of the page are no longer displayed
    (and their custom styles have been removed). There is a heading image
    instead.

Show diffs side-by-side

added added

removed removed

Lines of Context:
userdb/migrations/20100216-01.sql
1
 
BEGIN;
2
 
 
3
 
CREATE OR REPLACE FUNCTION valid_url_name(name text) RETURNS boolean AS 
4
 
$$
5
 
    BEGIN
6
 
        RETURN name ~ E'^[a-z0-9][a-z0-9_\+\.\-]*$';
7
 
    END;
8
 
$$ LANGUAGE 'plpgsql';
9
 
 
10
 
CREATE OR REPLACE FUNCTION valid_login_name(name text) RETURNS boolean AS 
11
 
$$
12
 
    BEGIN
13
 
        RETURN name ~ E'^[a-z0-9][a-z0-9@_\+\.\-]*$';
14
 
    END;
15
 
$$ LANGUAGE 'plpgsql';
16
 
 
17
 
ALTER TABLE login ADD CONSTRAINT login_login_check CHECK (valid_login_name(login)); 
18
 
ALTER TABLE subject ADD CONSTRAINT subject_subj_short_name_check CHECK (valid_url_name(subj_short_name)); 
19
 
ALTER TABLE semester ADD CONSTRAINT semester_year_check CHECK (valid_url_name(year)); 
20
 
ALTER TABLE semester ADD CONSTRAINT semester_semester_check CHECK (valid_url_name(semester)); 
21
 
ALTER TABLE project ADD CONSTRAINT project_short_name_check CHECK (valid_url_name(short_name)); 
22
 
ALTER TABLE project_group ADD CONSTRAINT project_group_groupnm_check CHECK (valid_url_name(groupnm)); 
23
 
ALTER TABLE exercise ADD CONSTRAINT exercise_identifier_check CHECK (valid_url_name(identifier)); 
24
 
ALTER TABLE worksheet ADD CONSTRAINT worksheet_identifier_check CHECK (valid_url_name(identifier)); 
25
 
 
26
 
COMMIT;