[TikiWiki-commits] [Git][tikiwiki/tiki][master] [DB] Change url field in tiki_performance table from VARCHAR(255) to TEXT to...

Bruno Kambere pushed to branch master at Tiki Wiki CMS Groupware / Tiki


Commits:
7fe12a26 by Yves Ngalamulume at 2025-09-04T13:37:55+03:00
[DB] Change url field in tiki_performance table from VARCHAR(255) to TEXT to accommodate longer URLs
---
* [UPD] Change url field in tiki_performance table from VARCHAR(255) to TEXT to accommodate longer URLs

* [UPD] Change url field in tiki_performance table from VARCHAR(255) to TEXT to accommodate longer URLs

* [FIX] Validate URL length in addRecord method to prevent oversized entries

See merge request tikiwiki/tiki!8483

- - - - -


2 changed files:

- db/tiki.sql
- + installer/schema/20250903_performance_url_text_tiki.sql


Changes:

=====================================
db/tiki.sql
=====================================
@@ -4054,7 +4054,7 @@ CREATE TABLE `tiki_oauthserver_clients` (
 DROP TABLE IF EXISTS `tiki_performance`;
 CREATE TABLE `tiki_performance` (
     `id` int(12) NOT NULL AUTO_INCREMENT,
-    `url` varchar (255) NOT NULL,
+    `url` TEXT NOT NULL,
     `time_taken` int(12) NOT NULL,
     PRIMARY KEY (`id`)
 ) ENGINE=MyISAM;


=====================================
installer/schema/20250903_performance_url_text_tiki.sql
=====================================
@@ -0,0 +1 @@
+ALTER TABLE `tiki_performance` MODIFY `url` text NOT NULL;
\ No newline at end of file



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/7fe12a26e5a880857a8c8286e61a1ebb13dde814

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/7fe12a26e5a880857a8c8286e61a1ebb13dde814
You're receiving this email because of your account on gitlab.com.

_______________________________________________
TikiWiki-cvs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-cvs