X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=db%2Fstoica.sql;h=6f43cd2214ce7160a446efcd08818c5471ef8ff0;hb=121ae2210882f45e4bfcbcaa7883d0563bdb77e6;hp=080b74758562efff13d1b39cb0c6ff8cbe6e4b9f;hpb=e9bb1ad3b04159fe4e60472a438d13dfafb98d51;p=quix0rs-gnu-social.git

diff --git a/db/stoica.sql b/db/stoica.sql
index 080b747585..6f43cd2214 100644
--- 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)