File: postgres7.sql

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

# --------------------------------------------------------

#
# Table structure for table prefix_question_multichoice
#

CREATE TABLE prefix_question_multichoice (
  id SERIAL PRIMARY KEY,
  question integer NOT NULL default '0',
  layout integer NOT NULL default '0',
  answers varchar(255) NOT NULL default '',
  single integer NOT NULL default '0',
  shuffleanswers integer NOT NULL default '1'
);

CREATE INDEX prefix_question_multichoice_question_idx ON prefix_question_multichoice (question);