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

Victor Emanouilov pushed to branch master at Tiki Wiki CMS Groupware / Tiki


Commits:
44485b3d by Adrien Mbuya Maloba at 2026-05-28T08:08:30+00:00
[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

- - - - -


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/44485b3d3c680f6e965c7457eac6c8a108ffbcad

-- 
View it on GitLab: https://gitlab.com/tikiwiki/tiki/-/commit/44485b3d3c680f6e965c7457eac6c8a108ffbcad
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