[TikiWiki-commits] [Git][tikiwiki/tiki][30.x] [BP][ENH][DB] Calendar: use unsigned ints for calendar item timestamps

Adrien Mbuya Maloba pushed to branch 30.x at Tiki Wiki CMS Groupware / Tiki


Commits:
9f385f9a by Adrien Mbuya Maloba at 2026-06-11T15:33:02+03:00
[BP][ENH][DB] Calendar: use unsigned ints for calendar item timestamps
---
* [ENH][DB] Calendar: use unsigned ints for calendar item timestamps
---
* [ENH][DB] Calendar: use unsigned ints for calendar item timestamps

See merge request tikiwiki/tiki!10258

See merge request tikiwiki/tiki!10490

- - - - -


2 changed files:

- db/tiki.sql
- + installer/schema/20260520_change_calendar_items_recurrence_tiki.sql


Changes:

=====================================
db/tiki.sql
=====================================
@@ -432,8 +432,8 @@ CREATE TABLE `tiki_calendar_recurrence` (
   `yearlyFirstlastWeekdayValue` int default NULL,
   `yearlyWeekMonth` int default NULL,
   `nbRecurrences` int(8),
-  `startPeriod` int(14),
-  `endPeriod` int(14),
+  `startPeriod` INT UNSIGNED,
+  `endPeriod` INT UNSIGNED,
   `user` varchar(200) default '',
   `created` int(14) NOT NULL default '0',
   `lastmodif` int(14) NOT NULL default '0',
@@ -448,8 +448,8 @@ DROP TABLE IF EXISTS `tiki_calendar_items`;
 CREATE TABLE `tiki_calendar_items` (
   `calitemId` int(14) NOT NULL auto_increment,
   `calendarId` int(14) NOT NULL default '0',
-  `start` int(14) NOT NULL default '0',
-  `end` int(14) NOT NULL default '0',
+  `start` INT UNSIGNED NOT NULL default '0',
+  `end` INT UNSIGNED NOT NULL default '0',
   `locationId` int(14) default NULL,
   `categoryId` int(14) default NULL,
   `nlId` int(12) NOT NULL default '0',


=====================================
installer/schema/20260520_change_calendar_items_recurrence_tiki.sql
=====================================
@@ -0,0 +1,7 @@
+ALTER TABLE `tiki_calendar_items`
+CHANGE `start` `start` INT UNSIGNED NOT NULL DEFAULT '0',
+CHANGE `end` `end` INT UNSIGNED NOT NULL DEFAULT '0';
+
+ALTER TABLE `tiki_calendar_recurrence`
+CHANGE `startPeriod` `startPeriod` INT UNSIGNED,
+CHANGE `endPeriod` `endPeriod` INT UNSIGNED;



View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/9f385f9af8b83c13348ffd43a29e5967d23c4db2

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/9f385f9af8b83c13348ffd43a29e5967d23c4db2
You're receiving this email because of your account on gitlab.com. Manage all notifications: https://gitlab.com/-/profile/notifications | Help: https://gitlab.com/help

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