Add sequence,added_at, and updated_at to events table; implement SEQUENCE in iCal export

2 files changed, 4 insertions, 0 deletions

diff --git a/ical.php b/ical.php
index 92c7eb8..f3ad5b5 100644
--- a/ical.php
+++ b/ical.php
@@ -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,