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',
     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)
     
     constraint primary key (profile_id, width, height),
     index avatar_profile_id_idx (profile_id)