Changeset 178037

Timestamp:

11/30/2009 09:10:19 AM (16 years ago)

Author:

binnyva

Message:

Bugfix - db inconsistancy

File:

• surveys/trunk/surveys.php (modified) (2 diffs)

surveys/trunk/surveys.php

@@ -66 +66 @@
     add_option('surveys_insert_csv_header', 1);
     
-    $database_version = '2';
+    $database_version = '3';
     $installed_db = get_option('surveys_db_version');
     
@@ -84 +84 @@
                     survey_ID int(11) unsigned NOT NULL,
                     question mediumtext NOT NULL,
-                    allow_user_answer INT( 1 ) NOT NULL DEFAULT '0',
-                    allow_multiple_answers INT( 2 ) NOT NULL DEFAULT '0',
-                    INDEX ( survey_ID ),
-                    PRIMARY KEY  (ID)
+                    allow_user_answer int(1) NOT NULL default '0',
+                    allow_multiple_answers int(2) NOT NULL default '0',
+                    user_answer_format enum('entry','textarea','checkbox') NOT NULL default 'entry',
+                    PRIMARY KEY  (ID),
+                    KEY survey_id (survey_ID)
                     ) ;
                 CREATE TABLE {$wpdb->prefix}surveys_result (