You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@roller.apache.org by sn...@apache.org on 2006/10/03 23:58:04 UTC

svn commit: r452648 - in /incubator/roller/trunk/metadata/database: 200-to-310-migration.vm 300-to-310-migration.vm createdb.vm

Author: snoopdave
Date: Tue Oct  3 14:58:03 2006
New Revision: 452648

URL: http://svn.apache.org/viewvc?view=rev&rev=452648
Log:
Shorten varchar(512) fields to 255 to please MySQL

Added:
    incubator/roller/trunk/metadata/database/300-to-310-migration.vm
      - copied unchanged from r450973, incubator/roller/trunk/metadata/database/200-to-310-migration.vm
Removed:
    incubator/roller/trunk/metadata/database/200-to-310-migration.vm
Modified:
    incubator/roller/trunk/metadata/database/createdb.vm

Modified: incubator/roller/trunk/metadata/database/createdb.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/createdb.vm?view=diff&rev=452648&r1=452647&r2=452648
==============================================================================
--- incubator/roller/trunk/metadata/database/createdb.vm (original)
+++ incubator/roller/trunk/metadata/database/createdb.vm Tue Oct  3 14:58:03 2006
@@ -113,7 +113,7 @@
     commentmod           $BOOLEAN_SQL_TYPE_FALSE not null,
     displaycnt           integer default 15 not null,
     lastmodified         $TIMESTAMP_SQL_TYPE,
-    pagemodels           varchar(512) default null,
+    pagemodels           varchar(255) default null,
     enablemultilang   $BOOLEAN_SQL_TYPE_FALSE not null,
     showalllangs      $BOOLEAN_SQL_TYPE_TRUE not null
 );
@@ -197,7 +197,7 @@
     status          varchar(20) not null,
     summary         $TEXT_SQL_TYPE default null, 
     content_type    varchar(48) default null, 
-    content_src     varchar(512) default null
+    content_src     varchar(255) default null
 );
 create index we_websiteid_idx on weblogentry( websiteid );
 create index we_categoryid_idx on weblogentry( categoryid );