projects
/
fa-stable.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
2fa7373
)
Bug in SQL syntax.
author
Janusz Dobrowolski
<janusz@frontaccounting.eu>
Wed, 7 Jan 2009 13:20:30 +0000
(13:20 +0000)
committer
Janusz Dobrowolski
<janusz@frontaccounting.eu>
Wed, 7 Jan 2009 13:20:30 +0000
(13:20 +0000)
sql/alter2.1.sql
patch
|
blob
|
history
diff --git
a/sql/alter2.1.sql
b/sql/alter2.1.sql
index cf6d369dec61295fcda291e2dd21ac65034df26b..3585a970d2ebdb7ba0decabf2f91fc9a06af3726 100644
(file)
--- 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';