|
From: mdw c. <myd...@li...> - 2001-12-06 16:21:15
|
MyDynaWeb CVS committal Author : sukria Project : mydynaweb Module : sql Dir : mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6 Modified Files: alter-news.sql Log Message: fixing alternews to be postgres compliant =================================================================== RCS file: /cvsroot/mydynaweb/mydynaweb/sql/db_upgrade/from-0.3.5__to-0.3.6/alter-news.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -3 -r1.1 -r1.2 --- alter-news.sql 2001/10/29 14:30:44 1.1 +++ alter-news.sql 2001/12/06 16:21:12 1.2 @@ -1,2 +1,2 @@ -alter table news modify titre VARCHAR(50) not null default ''; - +ALTER TABLE news +ALTER COLUMN titre SET VARCHAR(50) DEFAULT ''; |