From d463a84f4fca5cb86880195235cc645a08538636 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Wed, 7 Jan 2009 13:20:30 +0000 Subject: [PATCH] Bug in SQL syntax. --- sql/alter2.1.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/alter2.1.sql b/sql/alter2.1.sql index cf6d369d..3585a970 100644 --- a/sql/alter2.1.sql +++ b/sql/alter2.1.sql @@ -128,7 +128,7 @@ INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '6730', '1', '0', 0, '0', '0 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '3000', '1', '0', 0, '0', '0'); ALTER TABLE `0_users` DROP COLUMN `print_profile`; -ALTER TABLE `0_users` ADD `print_profile` NOT NULL VARCHAR(30) DEFAULT '1'; +ALTER TABLE `0_users` ADD `print_profile` VARCHAR(30) NOT NULL DEFAULT '1'; ALTER TABLE `0_users` DROP COLUMN `rep_popup`; ALTER TABLE `0_users` ADD `rep_popup` TINYINT(1) DEFAULT '1'; -- 2.30.2