Install Node JS di Linux Ubuntu Server

<div class="MsoNormal"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1umCJr1ByVae-_1KDGlA1mo9ru2ertdS0ISnaMMV1PHkrWbuiYJhrYay719Y5qexnQ3ONSOqa5bkfrs2MwEiEw2H4aeIf_RBr_HHf2JuBy7lmDY5KqZLDRzqk3zZ202uDCNCJ7eRDNoy0/s1600/node-js-300x224.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="149" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1umCJr1ByVae-_1KDGlA1mo9ru2ertdS0ISnaMMV1PHkrWbuiYJhrYay719Y5qexnQ3ONSOqa5bkfrs2MwEiEw2H4aeIf_RBr_HHf2JuBy7lmDY5KqZLDRzqk3zZ202uDCNCJ7eRDNoy0/s200/node-js-300x224.jpg" width="200" /></a></div> <br /> Node.js merupakan salah satu penerapan serverside javascript yang memungkinkan suatu program javascript bisa dijalankan secara paralel dan client-server. Ini biasanya diimplementasikan untuk aplikasi-aplikasi yang membutuhkan proses realtime seperti chat dan notifikasi.<o:p></o:p></div> <div class="MsoNormal"> <b>1) Instalasi<o:p></o:p></b></div> <div class="MsoNormal"> Menambahkan Chris Lea’s Repo dengan perintah berikut (opsional):<o:p></o:p></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo apt-get install python-software-properties<o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo apt-add-repository ppa:chris-lea/node.js<o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo apt-get update<o:p></o:p></span></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> Berikutnya install node.js dari repo yang telah ditambahkan tersebut dengan cara ketik perintah berikut:<o:p></o:p></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo apt-get install nodejs<o:p></o:p></span></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> Setelah instalasi selesai maka cek versi dengan cara:<o:p></o:p></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">node –v<o:p></o:p></span></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> hingga muncul versi nya misal:<o:p></o:p></div> <div class="MsoNormal"> installed: v0.10.33<o:p></o:p></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> <b>2) Contoh penggunaan<o:p></o:p></b></div> <div class="MsoNormal"> Selanjutnya kita bisa menjalankan (execute) perintah js menggunakan node. berikut contoh menjalankan node.js yg telah dibuat untuk mengaktifkan socket chat.<o:p></o:p></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">Nodejs [lokasi]/[nama_file_anda].js<o:p></o:p></span></div> <div class="MsoNormal"> contoh:<o:p></o:p></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">nodejs /usr/share/nginx/www/aplikasianda/js/nodejs/index.js<o:p></o:p></span></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> “<span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">/usr/share/nginx/www/aplikasianda/js/nodejs/index.js</span>” merupakan lokasi dan file js yang akan di jalankan disesuaikan dengan yang digunakan.<o:p></o:p></div> <div class="MsoNormal"> lalu muncul:<o:p></o:p></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">Listening port 3000<o:p></o:p></span></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> <b>3) Konfigurasi agar node js berjalan secara otomatis ketika boot<o:p></o:p></b></div> <div class="MsoNormal"> Agar script js yang kita buat otomatis berjalan ketika system start maka buat file “.conf” di direktori /etc/init/ dengan cara:<o:p></o:p></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo nano /etc/init/[nama-konfigurasi].conf<o:p></o:p></span></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> contoh:<o:p></o:p></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo nano /etc/init/nodejs-aplikasianda.conf<o:p></o:p></span></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> lalu isi dengan script ini:<o:p></o:p></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">start on startup<o:p></o:p></span></div> <div class="MsoNormal"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">exec nodejs nodejs usr/share/nginx/www/aplikasianda/js/nodejs/index.js<o:p></o:p></span></div> <div class="MsoNormal"> <br /></div> <div class="MsoNormal"> Simpan dengan cara tekan Ctrl+Shift+X lalu ketik Y dan enter. “<span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">nodejs /usr/share/nginx/www/aplikasianda/js/nodejs/index.js</span> “ merupakan lokasi dan nama file yang akan dieksekusi yang sudah dibahas di atas. <o:p></o:p></div> <div class="MsoNormal"> Setelah itu lalu coba reboot system dengan perintah:<o:p></o:p></div> <br /> <div class="MsoNormal"> <span style="font-family: "Courier New";">sudo reboot<o:p></o:p></span></div>

Install Node JS di Linux Ubuntu Server

Node.js merupakan salah satu penerapan serverside javascript yang memungkinkan suatu program javascript bisa dijalankan secara paralel d...

Baca selengkapnya »

Install dan Konfigurasi Gammu di Linux Ubuntu

<div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlog4OximlNiMd2ttyuM4X_71PImRLKm2IoYV54YymkZk4_DKBdcv1yY5-FUCa3wnT6P0fl1Y5AWNunyLEoKeZJTpw4MsVnD3jWJT7oKxCY1FwoInc4bOjo6WoUbwspVBWv2orUTDzJGZw/s1600/box_sms_gateway.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="177" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlog4OximlNiMd2ttyuM4X_71PImRLKm2IoYV54YymkZk4_DKBdcv1yY5-FUCa3wnT6P0fl1Y5AWNunyLEoKeZJTpw4MsVnD3jWJT7oKxCY1FwoInc4bOjo6WoUbwspVBWv2orUTDzJGZw/s200/box_sms_gateway.gif" width="200" /></a></div> <b><br /></b> <b>1) Install aplikasi gammu dan gammu-smsd<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo apt-get update<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo apt-get install gammu gammu-smsd<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>2) Untuk melihat konfigurasi port device (modem)<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">dmesg | grep tty<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>3) Konfigurasi Gammu terlebih dahulu<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo gammu-config<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">port = /dev/ttyUSB0 # disesuaikan<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">connection = at115200 # disesuaikan<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">synchronizetime = yes<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">logfile = /var/log/gammulog<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">logformat = textall<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">use_locking = # isi yes jika ingin resource modem di kunci<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>4) Konfigurasi berkas /etc/gammu-smsdrc<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">port = /dev/ttyUSB0 //disesuaikan<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">connection = at115200 //disesuaikan<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">logformat = textall<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">service = sql<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">driver = native_pgsql<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">DeliveryReport = sms<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">logfile = var/log/smsdlog<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">debuglevel = 1<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">User = postgres<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">password = postgres<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">pc = 192.168.1.8<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">database = aplikasianda<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">phoneid = phone1 //dapat di ubah atau disesuaikan<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> - WARNING!! untuk menggunakan perintah gammu, matikan dulu service gammu-smsd. Pastikan dengan cara ketik perintah:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo /etc/init.d/gammu-smsd stop<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>5) Cek identify modem dengan perintah<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo gammu --identify<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>6) Aktifkan kembali service<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">sudo /etc/init.d/gammu-smsd start<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>7) Tabel yang harus di buat pada database<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Database: "smsd"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- CREATE USER "smsd" WITH NOCREATEDB NOCREATEUSER;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- CREATE DATABASE "smsd" WITH OWNER = "smsd" ENCODING = 'UTF8';<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- \connect "smsd" "smsd"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- COMMENT ON DATABASE "smsd" IS 'Gammu SMSD Database';<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Function declaration for updating timestamps<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE LANGUAGE plpgsql;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE OR REPLACE FUNCTION update_timestamp() RETURNS trigger AS $update_timestamp$<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> BEGIN<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> NEW."UpdatedInDB" := LOCALTIMESTAMP(0);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> RETURN NEW;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> END;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">$update_timestamp$ LANGUAGE plpgsql;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Sequence declarations for tables' primary keys<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE SEQUENCE inbox_ID_seq;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE SEQUENCE outbox_ID_seq;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE SEQUENCE outbox_multipart_ID_seq;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE SEQUENCE pbk_groups_ID_seq;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE SEQUENCE sentitems_ID_seq;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Index declarations for tables' primary keys<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE UNIQUE INDEX inbox_pkey ON inbox USING btree ("ID");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE UNIQUE INDEX outbox_pkey ON outbox USING btree ("ID");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE UNIQUE INDEX outbox_multipart_pkey ON outbox_multipart USING btree ("ID");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE UNIQUE INDEX pbk_groups_pkey ON pbk_groups USING btree ("ID");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--CREATE UNIQUE INDEX sentitems_pkey ON sentitems USING btree ("ID");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Table structure for table "daemons"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TABLE daemons (<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Start" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Info" text NOT NULL<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Dumping data for table "daemons"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Table structure for table "gammu"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TABLE gammu (<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Version" smallint NOT NULL DEFAULT '0'<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Dumping data for table "gammu"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">INSERT INTO gammu ("Version") VALUES (14);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Table structure for table "inbox"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TABLE inbox (<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "UpdatedInDB" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "ReceivingDateTime" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Text" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SenderNumber" varchar(20) NOT NULL DEFAULT '',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Coding" varchar(255) NOT NULL DEFAULT 'Default_No_Compression',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "UDH" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SMSCNumber" varchar(20) NOT NULL DEFAULT '',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Class" integer NOT NULL DEFAULT '-1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "TextDecoded" text NOT NULL DEFAULT '',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "ID" serial PRIMARY KEY,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "RecipientID" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Processed" boolean NOT NULL DEFAULT 'false',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> CHECK ("Coding" IN<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> ('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression'))<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Dumping data for table "inbox"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Create trigger for table "inbox"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TRIGGER update_timestamp BEFORE UPDATE ON inbox FOR EACH ROW EXECUTE PROCEDURE update_timestamp();<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Table structure for table "outbox"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TABLE outbox (<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "UpdatedInDB" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "InsertIntoDB" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SendingDateTime" timestamp NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SendBefore" time NOT NULL DEFAULT '23:59:59',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SendAfter" time NOT NULL DEFAULT '00:00:00',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Text" text,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "DestinationNumber" varchar(20) NOT NULL DEFAULT '',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Coding" varchar(255) NOT NULL DEFAULT 'Default_No_Compression',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "UDH" text,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Class" integer DEFAULT '-1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "TextDecoded" text NOT NULL DEFAULT '',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "ID" serial PRIMARY KEY,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "MultiPart" boolean NOT NULL DEFAULT 'false',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "RelativeValidity" integer DEFAULT '-1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SenderID" varchar(255),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SendingTimeOut" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "DeliveryReport" varchar(10) DEFAULT 'default',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "CreatorID" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> CHECK ("Coding" IN<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> ('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression')),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> CHECK ("DeliveryReport" IN ('default','yes','no'))<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE INDEX outbox_date ON outbox("SendingDateTime", "SendingTimeOut");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE INDEX outbox_sender ON outbox("SenderID");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Dumping data for table "outbox"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Create trigger for table "outbox"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TRIGGER update_timestamp BEFORE UPDATE ON outbox FOR EACH ROW EXECUTE PROCEDURE update_timestamp();<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Table structure for table "outbox_multipart"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TABLE outbox_multipart (<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Text" text,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Coding" varchar(255) NOT NULL DEFAULT 'Default_No_Compression',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "UDH" text,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Class" integer DEFAULT '-1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "TextDecoded" text DEFAULT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "ID" serial,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SequencePosition" integer NOT NULL DEFAULT '1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> PRIMARY KEY ("ID", "SequencePosition"),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> CHECK ("Coding" IN<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> ('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression'))<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Dumping data for table "outbox_multipart"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Table structure for table "pbk"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TABLE pbk (<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "ID" serial PRIMARY KEY,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "GroupID" integer NOT NULL DEFAULT '-1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Name" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Number" text NOT NULL<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Dumping data for table "pbk"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Table structure for table "pbk_groups"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TABLE pbk_groups (<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Name" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "ID" serial PRIMARY KEY<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Dumping data for table "pbk_groups"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Table structure for table "phones"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TABLE phones (<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "ID" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "UpdatedInDB" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "InsertIntoDB" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "TimeOut" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Send" boolean NOT NULL DEFAULT 'no',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Receive" boolean NOT NULL DEFAULT 'no',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "IMEI" varchar(35) PRIMARY KEY NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "NetCode" varchar(10) DEFAULT 'ERROR',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "NetName" varchar(35) DEFAULT 'ERROR',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Client" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Battery" integer NOT NULL DEFAULT -1,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Signal" integer NOT NULL DEFAULT -1,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Sent" integer NOT NULL DEFAULT 0,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Received" integer NOT NULL DEFAULT 0<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Dumping data for table "phones"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Create trigger for table "phones"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TRIGGER update_timestamp BEFORE UPDATE ON phones FOR EACH ROW EXECUTE PROCEDURE update_timestamp();<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Table structure for table "sentitems"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TABLE sentitems (<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "UpdatedInDB" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "InsertIntoDB" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SendingDateTime" timestamp(0) WITHOUT time zone NOT NULL DEFAULT LOCALTIMESTAMP(0),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "DeliveryDateTime" timestamp(0) WITHOUT time zone NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Text" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "DestinationNumber" varchar(20) NOT NULL DEFAULT '',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Coding" varchar(255) NOT NULL DEFAULT 'Default_No_Compression',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "UDH" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SMSCNumber" varchar(20) NOT NULL DEFAULT '',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Class" integer NOT NULL DEFAULT '-1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "TextDecoded" text NOT NULL DEFAULT '',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "ID" serial,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SenderID" varchar(255) NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "SequencePosition" integer NOT NULL DEFAULT '1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "Status" varchar(255) NOT NULL DEFAULT 'SendingOK',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "StatusError" integer NOT NULL DEFAULT '-1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "TPMR" integer NOT NULL DEFAULT '-1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "RelativeValidity" integer NOT NULL DEFAULT '-1',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> "CreatorID" text NOT NULL,<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> CHECK ("Status" IN<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> ('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending',<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> 'DeliveryUnknown','Error')),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> CHECK ("Coding" IN<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> ('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression')),<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";"> PRIMARY KEY ("ID", "SequencePosition")<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE INDEX sentitems_date ON sentitems("DeliveryDateTime");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE INDEX sentitems_tpmr ON sentitems("TPMR");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE INDEX sentitems_dest ON sentitems("DestinationNumber");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE INDEX sentitems_sender ON sentitems("SenderID");<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Dumping data for table "sentitems"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- --------------------------------------------------------<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">-- Create trigger for table "sentitems"<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">--<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <br /> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New"; mso-bidi-font-weight: bold; mso-fareast-font-family: "Times New Roman";">CREATE TRIGGER update_timestamp BEFORE UPDATE ON sentitems FOR EACH ROW EXECUTE PROCEDURE update_timestamp();</span><o:p></o:p></div>

Install dan Konfigurasi Gammu di Linux Ubuntu

1) Install aplikasi gammu dan gammu-smsd sudo apt-get update sudo apt-get install gammu gammu-smsd 2) Untuk melihat konfiguras...

Baca selengkapnya »

Install dan Konfigurasi Linux Ubuntu Server, Postgres, Nginx, PHP5-FPM, Aplikasi Yii Anda

<div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE5AvZxf06tnjyMNNMG2vGbjgyutO_jD0_cTHrdoVXQVfkGBvjgh5pin1GddpL6nwUqpcl_28JWs-jSbQvb15KUBWQ44d6PhM_WkZbybkQFSYRzQOIMvImwFsJJublWcunoHbqfJXhCr6e/s1600/ubuntunginxphppostgres.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgE5AvZxf06tnjyMNNMG2vGbjgyutO_jD0_cTHrdoVXQVfkGBvjgh5pin1GddpL6nwUqpcl_28JWs-jSbQvb15KUBWQ44d6PhM_WkZbybkQFSYRzQOIMvImwFsJJublWcunoHbqfJXhCr6e/s1600/ubuntunginxphppostgres.jpg" /></a></div> <b><br /></b> <b>1. Install Ubuntu Server 12.04</b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Source : http://releases.ubuntu.com/12.04/ubuntu-12.04.5-server-amd64.iso<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>2. Konfigurasi Repository Ubuntu<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo nano /etc/apt/sources.list<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Isi file (dibaris paling bawah) dengan:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">deb http://kambing.ui.ac.id/ubuntu/ precise-proposed main restricted universe multiverse<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">deb http://kambing.ui.ac.id/ubuntu/ precise-security main restricted universe multiverse<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">deb http://kambing.ui.ac.id/ubuntu/ precise-updates main restricted universe multiverse<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">deb http://kambing.ui.ac.id/ubuntu/ precise main restricted universe multiverse <o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Close dengan tekan tombol (Ctrl + Shift + X) lalu tekan “Y” dan enter<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo apt-get update<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> PERHATIAN: jangan pernah ketik perintah “apt-get upgrade” karena bisa meng-upgrade kernel ubuntu semuanya / bisa crash<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>3. Install Aplikasi Pendukung<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 1) Install Postgresql 9.1:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo apt-get install postgresql-9.1<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 2) Install nginx:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo apt-get install nginx<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 3) Install PHP5 & PHP5-fpm:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo apt-get install php5 php5-fpm php5-gd php5-pgsql php5-curl<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 4) Install SSH:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo apt-get install ssh<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 5) Install Git<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo apt-get install git<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>4. Konfigurasi Aplikasi Pendukung<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 1) Konfigurasi Postgresql 9.1:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo service postgresql restart<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo nano /etc/postgresql/9.1/main/postgresql.conf<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Hapus tanda “#” di #listen_addresses = ‘localhost’<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Ubah “localhost” dengan “*” sehingga menjadi:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">listen_addresses = '*'<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Close (Ctrl+Shift+X) dan simpan (Tekan “Y” lalu Enter)<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo nano /etc/postgresql/9.1/main/pg_hba.conf<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Ubah text dibawah “# IPv4 local connections:” menjadi:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> # IPv4 local connections:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">host all all 127.0.0.1/32 trust<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">host all all 192.168.1.0/24 md5<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Buat user postgres:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo -u postgres psql template1<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">ALTER USER postgres with encrypted password 'postgres';<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> password ‘postgres’ boleh diganti / disesuaikan. misal: password<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> lalu close dengan ketik: ”\q” (tanpa tanda kutip)<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo service postgresql restart<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Test dengan konek postgres dari PC cilent ke server menggunakan PG Admin</div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 2) Konfigurasi Nginx:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo service nginx restart<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo nano /etc/nginx/nginx.conf<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Tambahkan script ini:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">fastcgi_buffers 8 128k;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">fastcgi_buffer_size 128k;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">fastcgi_connect_timeout 3000;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">fastcgi_send_timeout 3000;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">fastcgi_read_timeout 3000;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">proxy_buffers 8 128k;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">proxy_buffer_size 128k;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">Setelah “http { “<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Lalu ketik perintah:</div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo service nginx restart<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Test dengan akses : http://[ip_server] di browser PC client<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Jika muncul “welcome to nginx” instalasi sukses</div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 3) Konfigurasi PHP5-FPM:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo service php5-fpm restart<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 4) Konfigurasi SSH:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo su<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">cd /root<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo mkdir .ssh<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">cd .ssh<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo ssh-keygen<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> jika muncul seperti ini:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Enter file in which to save the key (/home/root/.ssh/id_rsa):<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> langsung tekan enter (kosongkan). Begitu juga untuk passphrase langsung tekan enter (kosongkan).<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> ketik “ls” lalu enter.<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> file “id_rsa.pub” berisi kode enkripsi untuk didaftarkan di bitbucket oleh RD. kirimkan file tersebut ke manager RD / yang berhak mendaftarkan SSH di bitbucket. Jika berada di server maka pindahkan file tersebut ke PC Client dengan menggunakan perintah “scp” (ubuntu) atau tool WinSCP.</div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 5. Install Aplikasi Yii Anda<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Simpan aplikasi anda di:</div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">/usr/share/nginx/www/aplikasianda<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 6. Konfigurasi Aplikasi Yii anda di nginx<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo nano /etc/nginx/sites-available/default<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Masukan script berikut di baris paling atas:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">server{<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     listen 80;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     server_name localhost;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     root /usr/share/nginx/www;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     index index.php index.html index.htm;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     error_log /var/log/nginx/error.log error;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     location ~ \.php$ {<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     fastcgi_split_path_info ^(.+\.php)(/.+)$;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     fastcgi_pass 127.0.0.1:9000;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     fastcgi_index index.php;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     include fastcgi_params;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";"> }<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";"> location ~ /(protected|framework|nbproject) {<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     deny all;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     access_log off;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     log_not_found off;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";"> }<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";"> location ~ /themes/\w+/views {<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     deny all;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     access_log off;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     log_not_found off;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";"> }<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";"> location ~ \.(js|css|png|jpg|gif|swf|ico|pdf|mov|fla|zip|rar)$ {<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     try_files $uri =404;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";"> }<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">  location /aplikasianda {<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     if (!-e $request_filename){<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">         rewrite ^/(.+)$ /aplikasianda /index.php?url=$1 last;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">     }<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";"> }<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">}<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Cari “<span style="font-family: "Courier New";">server_name localhost;” </span>di konfigurasi “server{“ dibawah lalu beri tanda kres “#” di baris depannya sehingga menjadi “#<span style="font-family: "Courier New";">server_name localhost;”. I</span>ni dilakukan agar server_name tidak bentrok dengan konfigurasi yang kita buat. Simpan dengan tekan Ctrl+Shift+X lalu ketik “Y” dan enter.<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Setelah itu lalu ketik perintah berikut dan pastikan tidak muncul pesan error:<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo service nginx restart<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Buat folder “runtime” (jika belum ada):<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo mkdir /usr/share/nginx/www/aplikasianda/protected/runtime<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo chown -R www-data /usr/share/nginx/www/aplikasianda/protected/runtime<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Buat folder “assets” (Jika belum ada):<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo mkdir /usr/share/nginx/www/aplikasianda/assets<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "Courier New";">sudo chown -R www-data /usr/share/nginx/www/aplikasianda/ assets<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Akses SIMRS melalui browser : “http://[alamat_ip_server]/[aplikasianda]<o:p></o:p></div> <br /> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> contoh: http://192.168.1.10/aplikasianda</div>

Install dan Konfigurasi Linux Ubuntu Server, Postgres, Nginx, PHP5-FPM, Aplikasi Yii Anda

1. Install Ubuntu Server 12.04 Source : http://releases.ubuntu.com/12.04/ubuntu-12.04.5-server-amd64.iso 2. Konfigurasi Repository U...

Baca selengkapnya »