clear both for footer

[quix0rs-gnu-social.git] / db / stoica.sql

diff --git a/db/stoica.sql b/db/stoica.sql
index 080b74758562efff13d1b39cb0c6ff8cbe6e4b9f..6f43cd2214ce7160a446efcd08818c5471ef8ff0 100644 (file)
--- a/db/stoica.sql
+++ b/db/stoica.sql
@@ -22,6 +22,8 @@ create table avatar (
     mediatype varchar(32) not null comment 'file type',
     filename varchar(255) null comment 'local filename, if local',
     url varchar(255) unique key comment 'avatar location',
+    created datetime not null comment 'date this record was created',
+    modified timestamp comment 'date this record was modified',
     
     constraint primary key (profile_id, width, height),
     index avatar_profile_id_idx (profile_id)