lib/Odin.pm, mason/pastebin/dhandler: Apply a size limit on pastes.

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

diff --git a/sql/setup-pastebin.sql b/sql/setup-pastebin.sql
index 98331724a8b15b97fec1c29c8ccd3c0f05cb3d6a..391f8be96fa7a3dcd2980dca7ac5a5a1e48e394f 100644 (file)
--- a/sql/setup-pastebin.sql
+++ b/sql/setup-pastebin.sql
@@ -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