summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/stoica.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/stoica.sql b/db/stoica.sql
index 080b74758..6f43cd221 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)