diff options
| author | Camil Staps | 2020-02-03 21:29:36 +0100 |
|---|---|---|
| committer | Camil Staps | 2020-02-03 21:29:36 +0100 |
| commit | 9ded34f9d3d84fb1ea311c2fb3d935c91d4afddb (patch) | |
| tree | a34c8e1280ac6a7a4513632a2cdce981d49bb7ed /install.sql | |
| parent | Add ability to see description on list.php (diff) | |
Add sequence,added_at, and updated_at to events table; implement SEQUENCE in iCal export
Diffstat (limited to 'install.sql')
| -rw-r--r-- | install.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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, |