File: postgres7.sql

package info (click to toggle)
moodle 1.6.3-2
  • links: PTS
  • area: main
  • in suites: etch-m68k
  • size: 37,052 kB
  • ctags: 51,688
  • sloc: php: 231,916; sql: 5,631; xml: 2,688; perl: 638; sh: 441; makefile: 48; pascal: 36
file content (19 lines) | stat: -rw-r--r-- 657 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 

# --------------------------------------------------------
#
# Table structure for table prefix_question_calculated
#

CREATE TABLE prefix_question_calculated (
    id SERIAL8 PRIMARY KEY,
    question INT8  NOT NULL default '0',
    answer INT8  NOT NULL default '0',
    tolerance varchar(20) NOT NULL default '0.0',
    tolerancetype INT8 NOT NULL default '1',
    correctanswerlength INT8 NOT NULL default '2',
    correctanswerformat INT8 NOT NULL default '2'
);

CREATE INDEX prefix_question_calculated_question_idx ON prefix_question_calculated (question);
CREATE INDEX prefix_question_calculated_answer_idx ON prefix_question_calculated (answer);