ebl fix javascript

[bacula/bacula] / gui / bweb / script / bweb-postgresql.sql

diff --git a/gui/bweb/script/bweb-postgresql.sql b/gui/bweb/script/bweb-postgresql.sql
index 8bc14bf3100651206caaeba003d9c1f0f069833d..626333a5fadbf30aaff51b2daaee4a3f0643afc3 100644 (file)
--- a/gui/bweb/script/bweb-postgresql.sql
+++ b/gui/bweb/script/bweb-postgresql.sql
@@ -1,3 +1,4 @@
+CREATE PROCEDURAL LANGUAGE plpgsql;
 BEGIN;
 
 CREATE FUNCTION SEC_TO_TIME(timestamp with time zone)
@@ -20,4 +21,21 @@ RETURNS double precision AS $$
     select extract(epoch from $1);
 $$ LANGUAGE SQL;
 
-COMMIT;
\ No newline at end of file
+CREATE OR REPLACE FUNCTION base64_decode_lstat(int4, varchar) RETURNS int8 AS $$
+DECLARE
+val int8;
+b64 varchar(64);
+size varchar(64);
+i int;
+BEGIN
+size := split_part($2, ' ', $1);
+b64 := 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/';
+val := 0;
+FOR i IN 1..length(size) LOOP
+val := val + (strpos(b64, substr(size, i, 1))-1) * (64^(length(size)-i));
+END LOOP;
+RETURN val;
+END;
+$$ language 'plpgsql';
+
+COMMIT;