chiark
/
gitweb
/
~mdw
/
odin-cgi
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
Store Unix timestamps in the database, rather than SQL ones.
[odin-cgi]
/
sql
/
setup-shorturl.sql
diff --git
a/sql/setup-shorturl.sql
b/sql/setup-shorturl.sql
index eaddf90da13f477313f419401fc0a10144b10879..dee90a37b845aa607d40d28f230cbb1f1d4124fb 100644
(file)
--- a/
sql/setup-shorturl.sql
+++ b/
sql/setup-shorturl.sql
@@
-17,7
+17,7
@@
insert into odin_shorturl_seq (seq) values (10000);
create table odin_shorturl
(tag varchar(16) primary key,
- stamp
timestamp not null default current_timestamp
,
+ stamp
bigint not null
,
owner varchar(64) not null,
url text not null);
create index odin_shorturl_by_owner on odin_shorturl (owner);