lib/Odin.pm: Provide substitutions on mail recipient addresses.

[odin-cgi] / sql / setup-pastebin.sql

diff --git a/sql/setup-pastebin.sql b/sql/setup-pastebin.sql
index 06d35449fb878aea8f651e5882005e91f840f107..391f8be96fa7a3dcd2980dca7ac5a5a1e48e394f 100644 (file)
--- a/sql/setup-pastebin.sql
+++ b/sql/setup-pastebin.sql
@@ -14,7 +14,7 @@ drop table if exists odin_pastebin_lang;
 drop table if exists odin_pastebin_seq;
 
 create table odin_pastebin_lang
 drop table if exists odin_pastebin_seq;
 
 create table odin_pastebin_lang

-       (lang varchar(32) primary key
+       (lang varchar(32) primary key,

         descr varchar(64) not null);
 insert into odin_pastebin_lang (lang, descr) values ('txt', 'Plain text');
 
         descr varchar(64) not null);
 insert into odin_pastebin_lang (lang, descr) values ('txt', 'Plain text');
 


@@ -23,12 +23,12 @@ insert into odin_pastebin_seq (seq) values (10000);
 
 create table odin_pastebin
        (tag varchar(16) primary key,
 
 create table odin_pastebin
        (tag varchar(16) primary key,

-        stamp timestamp not null default current_timestamp,
+        stamp bigint not null,

         edithash varchar(128) not null,
         owner varchar(64) not null,
         title varchar(128) not null,
         lang varchar(32) not null
         edithash varchar(128) not null,
         owner varchar(64) not null,
         title varchar(128) not null,
         lang varchar(32) not null

-               default 'plain-text'
+               default 'txt'

                references odin_pastebin_lang (lang)
                        on update cascade
                        on delete set default
                references odin_pastebin_lang (lang)
                        on update cascade
                        on delete set default