Author: snoopdave
Date: Tue Jun 19 08:09:10 2007
New Revision: 548757
URL: http://svn.apache.org/viewvc?view=rev&rev=548757
Log:
weblogentry.locale was added in 2.0
Modified:
roller/trunk/apps/weblogger/src/sql/240-to-300-migration.vm
roller/trunk/apps/weblogger/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql
Modified: roller/trunk/apps/weblogger/src/sql/240-to-300-migration.vm
URL:
http://svn.apache.org/viewvc/roller/trunk/apps/weblogger/src/sql/240-to-300-migration.vm?view=diff&rev=548757&r1=548756&r2=548757
==============================================================================
--- roller/trunk/apps/weblogger/src/sql/240-to-300-migration.vm (original)
+++ roller/trunk/apps/weblogger/src/sql/240-to-300-migration.vm Tue Jun 19
08:09:10 2007
@@ -13,11 +13,6 @@
#addColumnNotNull("website" "enablemultilang" $db.BOOLEAN_SQL_TYPE
$db.BOOLEAN_FALSE)
#addColumnNotNull("website" "showalllangs" $db.BOOLEAN_SQL_TYPE
$db.BOOLEAN_TRUE)
--- add new column which holds the locale for a weblog entry
--- then set the values and make column not null
-#addColumnNull("weblogentry" "locale" "varchar(20)")
-create index we_locale_idx on weblogentry(locale);
-
-- add new column which holds the hidden status for a page, default is false
#addColumnNotNull("webpage" "hidden" $db.BOOLEAN_SQL_TYPE $db.BOOLEAN_FALSE)
Modified:
roller/trunk/apps/weblogger/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql
URL:
http://svn.apache.org/viewvc/roller/trunk/apps/weblogger/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql?view=diff&rev=548757&r1=548756&r2=548757
==============================================================================
---
roller/trunk/apps/weblogger/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql
(original)
+++
roller/trunk/apps/weblogger/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql
Tue Jun 19 08:09:10 2007
@@ -61,6 +61,11 @@
update weblogentry set status='', pubtime=pubtime, updatetime=updatetime;
alter table weblogentry modify status varchar(20) not null;
+-- add new column which holds the locale for a weblog entry
+-- then set the values and make column not null
+ alter table weblogentry add column locale varchar(20) default null;
+create index we_locale_idx on weblogentry(locale);
+
create index we_status_idx on weblogentry(status);
create index weblogentry_userid_index on weblogentry(userid);
