diff options
| author | Evan Prodromou <evan@prodromou.name> | 2008-05-18 15:46:53 -0400 |
|---|---|---|
| committer | Evan Prodromou <evan@prodromou.name> | 2008-05-18 15:46:53 -0400 |
| commit | 88483fe3b839541d2cc22a1fb553307a1b759493 (patch) | |
| tree | c7f6713240eaa40a3354078822b81aa04e5d4160 /db | |
| parent | 6396504aa60a3ae7505211ab7e99733b1c74267b (diff) | |
timestamps for avatar
darcs-hash:20080518194653-84dde-33205b1f2f6297006d63aec41fa91a8bcffda1ef.gz
Diffstat (limited to 'db')
| -rw-r--r-- | db/stoica.sql | 2 |
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) |