From: Benjamin Mako Hill <mako@atdot.cc>
Date: Tue, 8 Nov 2011 00:13:52 +0000 (-0500)
Subject: increased description size to 1000 characters
X-Git-Url: https://projects.mako.cc/source/scuttle/commitdiff_plain/dcbb87d3162249189239bb0407f23214cc2cf4a1?ds=inline

increased description size to 1000 characters

The default maximum description in Delicious was raised to 1000
characters instead of 255 several years ago. The current setting in
Scuttle makes it impossible for users to import data from their
Delicious account into Scuttle.

When the limit is increased, the old text-box was a bit too small. This
increases it (in line with what Delicious did when they made the
change).

In this patch, tables.sql is updated, but existing installations will
need to alter their database table my hand. In the absense of a system
for migrations, this seems to be able the best we can do.
---

diff --git a/tables.sql b/tables.sql
index 578fa06..84cf153 100644
--- a/tables.sql
+++ b/tables.sql
@@ -11,7 +11,7 @@ CREATE TABLE `sc_bookmarks` (
   `bModified` datetime NOT NULL default '0000-00-00 00:00:00',
   `bTitle` varchar(255) NOT NULL default '',
   `bAddress` text NOT NULL,
-  `bDescription` varchar(255) default NULL,
+  `bDescription` varchar(1000) default NULL,
   `bHash` varchar(32) NOT NULL default '',
   PRIMARY KEY  (`bId`),
   KEY `sc_bookmarks_usd` (`uId`,`bStatus`,`bDatetime`),
@@ -65,4 +65,4 @@ CREATE TABLE `sc_watched` (
   `watched` int(11) NOT NULL default '0',
   PRIMARY KEY  (`wId`),
   KEY `sc_watched_uId` (`uId`)
-);
\ No newline at end of file
+);
diff --git a/templates/editbookmark.tpl.php b/templates/editbookmark.tpl.php
index 16b56c7..dbc0006 100644
--- a/templates/editbookmark.tpl.php
+++ b/templates/editbookmark.tpl.php
@@ -31,7 +31,7 @@ switch ($row['bStatus']) {
 </tr>
 <tr>
     <th align="left"><?php echo T_('Description'); ?></th>
-    <td><input type="text" name="description" size="75" maxlength="255" value="<?php echo filter($row['bDescription'], 'xml'); ?>" /></td>
+    <td><textarea name="description" cols="74" rows="5" maxlength="1000"><?php echo filter($row['bDescription'], 'xml'); ?></textarea></td>
     <td></td>
 </tr>
 <tr>
@@ -108,4 +108,4 @@ document.write('<\/ul>');
 <?php
 }
 $this->includeTemplate($GLOBALS['bottom_include']); 
-?>
\ No newline at end of file
+?>