diff options
| -rw-r--r-- | ical.php | 1 | ||||
| -rw-r--r-- | install.sql | 3 |
2 files changed, 4 insertions, 0 deletions
@@ -52,6 +52,7 @@ $events=isset($_GET['keywords']) ? get_events (explode (',',$_GET['keywords'])) foreach ($events as $event){ echo "BEGIN:VEVENT\r\n"; echo icalline ('UID','event-'.$event['id'].'@agenda.hebrewtools.org'); + echo icalline ('SEQUENCE',$event['sequence']); echo icalline ('SUMMARY',$event['title']); echo icalline ('LOCATION',$event['location']); echo icalline ('DTSTART',date ('Ymd',strtotime ($event['start_date']))); diff --git a/install.sql b/install.sql index 8eb299a..a81729d 100644 --- a/install.sql +++ b/install.sql @@ -1,5 +1,8 @@ CREATE TABLE `events` ( `id` int(11) NOT NULL, + `sequence` tinyint(4) NOT NULL DEFAULT '0', + `added_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `title` text NOT NULL, `location` text NOT NULL, `start_date` date NOT NULL, |