roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From agillil...@apache.org
Subject svn commit: r332349 - in /incubator/roller/trunk/metadata/database: 130-to-200-migration-raw.sql droptables.sql
Date Thu, 10 Nov 2005 18:26:30 GMT
Author: agilliland
Date: Thu Nov 10 10:26:28 2005
New Revision: 332349

URL: http://svn.apache.org/viewcvs?rev=332349&view=rev
Log:
fixing droptables so it drops roller_comments.
modified roller_audit_log create table statement to use "comment_text" for oracle compatability


Modified:
    incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql
    incubator/roller/trunk/metadata/database/droptables.sql

Modified: incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql?rev=332349&r1=332348&r2=332349&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql (original)
+++ incubator/roller/trunk/metadata/database/130-to-200-migration-raw.sql Thu Nov 10 10:26:28
2005
@@ -44,7 +44,7 @@
     user_id         varchar(48) not null,  
     object_id       varchar(48),           
     object_class    varchar(255),          
-    comment         varchar(255) not null, 
+    comment_text    varchar(255) not null, 
     change_time     timestamp              
 );
 
@@ -263,7 +263,3 @@
     
 -- Oracle compatability DDL
 alter table comment rename to roller_comment;
-alter table roller_audit_log add column comment_text varchar(255);
-update roller_audit_log set comment_text = comment;
-alter table roller_audit_log modify comment_text varchar(255) not null;
-alter table roller_audit_log drop column comment;

Modified: incubator/roller/trunk/metadata/database/droptables.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/droptables.sql?rev=332349&r1=332348&r2=332349&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/droptables.sql (original)
+++ incubator/roller/trunk/metadata/database/droptables.sql Thu Nov 10 10:26:28 2005
@@ -6,7 +6,7 @@
 drop table newsfeed;
 drop table weblogcategoryassoc;
 drop table bookmark;
-drop table blogcomment;
+drop table roller_comment;
 drop table entryattribute;
 drop table weblogentry;
 drop table weblogcategory;
@@ -25,4 +25,4 @@
 drop table rag_group_subscription;
 drop table roller_properties;
 drop table roller_audit_log;
-drop table roller_user_permissions;
\ No newline at end of file
+drop table roller_user_permissions;



Mime
View raw message