File: postgres7.sql

package info (click to toggle)
moodle 1.4.4.dfsg.1-3sarge1
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 57,876 kB
  • ctags: 29,496
  • sloc: php: 271,617; sql: 5,084; xml: 702; perl: 638; sh: 403; java: 283; makefile: 42; pascal: 21
file content (12 lines) | stat: -rw-r--r-- 401 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
 
CREATE TABLE prefix_label (
  id SERIAL PRIMARY KEY,
  course integer NOT NULL default '0',
  name varchar(255) default NULL,
  content text,
  timemodified integer NOT NULL default '0'
);

CREATE INDEX prefix_label_course_idx ON prefix_label (course);

INSERT INTO prefix_log_display VALUES ('label', 'add', 'quiz', 'name');
INSERT INTO prefix_log_display VALUES ('label', 'update', 'quiz', 'name');