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 e26c412d3777243638fdcf599c3275c79ba9f663..304ede6466701d46da4fc023882414da650ec644 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
+?>