From c4dfc485eb6f6243962a3b55a4bb311c733c4541 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Fri, 4 Apr 2003 10:47:37 +0000
Subject: [PATCH] Fixes for main SQL defintions - from Juro Chlebec

---
 mod/quiz/db/postgres7.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/mod/quiz/db/postgres7.sql b/mod/quiz/db/postgres7.sql
index e6fd3d8641..33293c025d 100644
--- a/mod/quiz/db/postgres7.sql
+++ b/mod/quiz/db/postgres7.sql
@@ -104,7 +104,7 @@ CREATE INDEX question_prefix_quiz_match_idx ON prefix_quiz_match (question);
 # Table structure for table `quiz_match_sub`
 #
 
-CREATE TABLE `prefix_quiz_match_sub` (
+CREATE TABLE prefix_quiz_match_sub (
   id SERIAL PRIMARY KEY,
   question integer NOT NULL default '0',
   questiontext text NOT NULL default '',
@@ -149,7 +149,7 @@ CREATE TABLE prefix_quiz_questions (
   name varchar(255) NOT NULL default '',
   questiontext text NOT NULL default '',
   image varchar(255) NOT NULL default '',
-  defaultgrade integer NOT NULL default '1'
+  defaultgrade integer NOT NULL default '1',
   qtype integer NOT NULL default '0'
 );
 # --------------------------------------------------------
@@ -161,7 +161,7 @@ CREATE TABLE prefix_quiz_questions (
 CREATE TABLE prefix_quiz_randomsamatch (
   id SERIAL PRIMARY KEY,
   question integer NOT NULL default '0',
-  choose integer NOT NULL default '4',
+  choose integer NOT NULL default '4'
 );
 
 #
-- 
2.39.5