Changeset 19213 for extensions/gvideo/include/install.inc.php

Timestamp:

Nov 28, 2012, 12:49:06 PM (11 years ago)

Author:

mistic100

Message:

• add safe mode
• fix little error when adding video without thumbnail

File:

• extensions/gvideo/include/install.inc.php (modified) (2 diffs)

extensions/gvideo/include/install.inc.php

@@ -65 +65 @@
   `url` varchar(255) DEFAULT NULL,
   `type` varchar(64) NOT NULL,
-  `video_id` varchar(64) NOT NULL,
+  `video_id` varchar(128) NOT NULL,
   `width` smallint(9) DEFAULT NULL,
   `height` smallint(9) DEFAULT NULL,
@@ -73 +73 @@
   pwg_query($query);
   
+  // update video_id lenght
+  $query = 'ALTER TABLE `'.gvideo_table.'` CHANGE `video_id` `video_id` VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;';
+  pwg_query($query);
+  
   // new collumn in images table
   $result = pwg_query('SHOW COLUMNS FROM '.IMAGES_TABLE.' LIKE "is_gvideo";');
   if (!pwg_db_num_rows($result))
-  {      
+  {
     pwg_query('ALTER TABLE `' . IMAGES_TABLE . '` ADD `is_gvideo` TINYINT(1) NOT NULL DEFAULT 0;');