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 578fa0670986a4e1dcf87cf65013ed61e0910ff5..84cf153a652708715c49997d554fca8b5c30b453 100644 (file)
--- 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,
   `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`),
   `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`)
   `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 16b56c7fd0ad47274ad852bcc850e50843ea47ec..dbc0006f310dd550ad9ba09dafdca6ed6ed6e150 100644 (file)
--- 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>
 </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>
     <td></td>
 </tr>
 <tr>


@@ -108,4 +108,4 @@ document.write('<\/ul>');
 <?php
 }
 $this->includeTemplate($GLOBALS['bottom_include']); 
 <?php
 }
 $this->includeTemplate($GLOBALS['bottom_include']); 

-?>
\ No newline at end of file
+?>