From ae68eb9c157f193b483ac14fc3c47b76626a9ab9 Mon Sep 17 00:00:00 2001 From: skodak Date: Mon, 10 Jan 2005 21:31:41 +0000 Subject: [PATCH] fixed typos --- mod/workshop/db/postgres7.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/mod/workshop/db/postgres7.sql b/mod/workshop/db/postgres7.sql index 0ce59fa545..83106a9d8f 100644 --- a/mod/workshop/db/postgres7.sql +++ b/mod/workshop/db/postgres7.sql @@ -23,7 +23,7 @@ CREATE TABLE prefix_workshop ( assessmentstart INT8 NOT NULL default '0', submissionend INT8 NOT NULL default '0', assessmentend INT8 NOT NULL default '0', - releasegrades INT8 NOT NULL "0", + releasegrades INT8 NOT NULL default'0', grade INT8 NOT NULL default '0', gradinggrade INT4 NOT NULL default '0', ntassessments INT NOT NULL default '0', @@ -34,7 +34,7 @@ CREATE TABLE prefix_workshop ( teacherweight INT NOT NULL default '1', showleaguetable INT4 NOT NULL default '0', usepassword INT NOT NULL DEFAULT '0', - password VARCHAR(32) NOT NULL DEFAULT '0' + password VARCHAR(32) NOT NULL DEFAULT '' ); CREATE INDEX prefix_workshop_course_idx ON prefix_workshop (course); @@ -107,8 +107,8 @@ CREATE TABLE prefix_workshop_elements ( scale INT NOT NULL default '0', maxscore INT NOT NULL default '1', weight INT4 NOT NULL default '11', - stddev FLOAT NOT NULL default "0", - totalrassesments INT8 NOT NULL DEFAULT "0" + stddev FLOAT NOT NULL default '0', + totalrassesments INT8 NOT NULL DEFAULT '0' ); CREATE INDEX prefix_workshop_elements_workshopid_idx ON prefix_workshop_elements (workshopid); -- 2.39.5