[PATCH] documentation: postgres table for DLRs (through sdb)
Guillaume Cottenceau <[email protected]>
| Newsgroups | gmane.comp.mobile.kannel.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi, The following patch adds in doc/examples/dlr-sdb.conf the 10-line sql code to create a correct Postgres table that will receive DLRs. -- Guillaume Cottenceau
dlr-postgres.diff
(text/x-patch, 879 B)
Index: doc/examples/dlr-sdb.conf =================================================================== RCS file: /home/cvs/gateway/doc/examples/dlr-sdb.conf,v retrieving revision 1.4 diff -u -r1.4 dlr-sdb.conf --- doc/examples/dlr-sdb.conf 2 Sep 2003 12:58:56 -0000 1.4 +++ doc/examples/dlr-sdb.conf 23 Apr 2004 15:47:42 -0000 @@ -43,6 +43,19 @@ # boxc varchar(40) # ) # +# For Postgres: +# +# CREATE TABLE dlr ( +# smsc VARCHAR(48), +# ts VARCHAR(48), +# destination VARCHAR(48), +# source VARCHAR(48), +# service VARCHAR(48), +# url VARCHAR(255), +# mask INTEGER, +# status INTEGER, +# boxc VARCHAR(48)); +# # Other DB types may vary. Consult your DB admin for help in creating # the appropriate table space and connection details for the real DB. #