diff -rupN limesurvey-orig/admin/install/create-postgres.sql limesurvey/admin/install/create-postgres.sql --- limesurvey-orig/admin/install/create-postgres.sql 2012-01-10 15:28:22.000000000 -0500 +++ limesurvey/admin/install/create-postgres.sql 2012-01-27 16:33:53.499296593 -0500 @@ -71,7 +71,7 @@ CREATE TABLE prefix_defaultvalues ( -- CREATE TABLE prefix_expression_errors ( - id integer NOT NULL AUTO_INCREMENT, + id SERIAL, errortime varchar(50) DEFAULT NULL, sid integer DEFAULT NULL, gid integer DEFAULT NULL, @@ -95,7 +95,7 @@ CREATE TABLE prefix_groups ( group_order integer DEFAULT 0 NOT NULL, description text, "language" character varying(20) DEFAULT 'en'::character varying NOT NULL, - randomization_group varying(20) DEFAULT ''::character varying NOT NULL, + randomization_group character varying(20) DEFAULT ''::character varying NOT NULL, grelevance text DEFAULT NULL, CONSTRAINT prefix_groups_pkey PRIMARY KEY (gid, "language") ); @@ -419,8 +419,7 @@ CREATE TABLE prefix_users ( templateeditormode character(7) DEFAULT 'default'::bpchar, questionselectormode character(7) DEFAULT 'default'::bpchar, one_time_pw bytea, - "dateformat" integer DEFAULT 1 NOT NULL, - participant_panel integer NOT NULL DEFAULT '0' + "dateformat" integer DEFAULT 1 NOT NULL );