Pokoknya Kerja Kerja Kerja !

<div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipYCl_BBwR9tKMPjThvk90oH6LTZ4E7ZZlnFE7FPbhTXQpWpItYcqrAF6uFPkSjGUOsBA4sTSIEqjHoe9dltTVMExad_P5LI-CDl6QllXBO0ElgZQGIv-w_TtG4mdwgazmwYFwyvjiTYDo/s1600/kerjakerjakerja.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="282" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipYCl_BBwR9tKMPjThvk90oH6LTZ4E7ZZlnFE7FPbhTXQpWpItYcqrAF6uFPkSjGUOsBA4sTSIEqjHoe9dltTVMExad_P5LI-CDl6QllXBO0ElgZQGIv-w_TtG4mdwgazmwYFwyvjiTYDo/s320/kerjakerjakerja.jpg" width="320" /></a></div> <br /> <div style="text-align: center;"> Meme:</div> <div style="text-align: center;"> Pokoknya kerja kerja kerja</div> <div style="text-align: center;"> <span style="color: red;">Mikirnya kapan?</span></div> <div style="text-align: center;"> Tapi kan..</div> <div style="text-align: center;"> ..kerja..</div> <div style="text-align: center;"> *speechless</div>

Pokoknya Kerja Kerja Kerja !

Meme: Pokoknya kerja kerja kerja Mikirnya kapan? Tapi kan.. ..kerja.. *speechless

Baca selengkapnya »

Yii 1 : Membuat Extends Model

<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/AVvXsEhC2CYj9-mfbbfKV04QB1f_kapAyHyWD3jVsIWxUGpaPjPdnxYSZEcLWlkeK9Lws1Uey3v2dSilQUIlbffBY6e0CmQpKjVsofX5m4oBeKoMJfZXr0r8l3TmRUtVxd6loyeSGZdbE7QjRFC3/s1600/yii_framework_developer.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhC2CYj9-mfbbfKV04QB1f_kapAyHyWD3jVsIWxUGpaPjPdnxYSZEcLWlkeK9Lws1Uey3v2dSilQUIlbffBY6e0CmQpKjVsofX5m4oBeKoMJfZXr0r8l3TmRUtVxd6loyeSGZdbE7QjRFC3/s200/yii_framework_developer.jpg" width="200" /></a></div> <b><br /></b> <b>#Langkah Membuat Model Baru<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 1. Akses Gii (Generator Yii): /index.php?r=gii<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 2. masukan password<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 3. pilih “model generator”<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 4. isi table name lalu tekan tab<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 5. biarkan model class terisi otomatis<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 6. cek “Build Relations”<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 7. klik preview<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 8. klik generate<o:p></o:p></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>#Langkah Membuat Model Extend<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 1. copy file model yang akan di extend di folder: protected/models<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 2. rename file dan nama class dibedakan dengan nama model aslinya. contoh: ExtJeniskelaminM.<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> 3. tambahkan extend. contoh : public class ExtJeniskelaminM extend JeniskelaminM.<o:p></o:p></div> 4. hapus semua function di dalam class kecuali function : public static function model<br /> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <br /></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <iframe height="280" src="https://drive.google.com/file/d/0B08K6Cdvmsf0cWFFbzVVbFNuQXM/preview" width="640"></iframe></div>

Yii 1 : Membuat Extends Model

#Langkah Membuat Model Baru 1. Akses Gii (Generator Yii): /index.php?r=gii 2. masukan password 3. pilih “model generator” 4. isi...

Baca selengkapnya »

Yii 1 : Membuat Tab Menu dengan BootMenu, iframe dan javascript

<div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <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/AVvXsEhUxFVO8hIghJAj6-6uxElDlLoBrosqbN1YCGdDplEXGB5P0Ql5RSylGdGDdEqXYKoJM_qPc4iyPUIBULsDA7vf8mbDIVATcZZpRj5mYOrcPoca3N5WDPmsw2AUYB1rrJTLJ_Iv38HX_ynM/s1600/yii_framework_developer.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhUxFVO8hIghJAj6-6uxElDlLoBrosqbN1YCGdDplEXGB5P0Ql5RSylGdGDdEqXYKoJM_qPc4iyPUIBULsDA7vf8mbDIVATcZZpRj5mYOrcPoca3N5WDPmsw2AUYB1rrJTLJ_Iv38HX_ynM/s200/yii_framework_developer.jpg" width="200" /></a></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <b><br /></b> <b>1. Buat Controller Baru<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Controller baru digunakan untuk index yang menyimpan tab menu serta iframe. Contoh controller:<o:p></o:p></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";">MasterIdentitasController.php<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Courier New;"><span style="line-height: 24px;"><iframe height="400" src="https://drive.google.com/file/d/0B08K6Cdvmsf0ZTBKQ0lLVmFIX0k/preview" width="640"></iframe></span></span><br /> <span style="font-family: Courier New;"><span style="line-height: 24px;"><br /> </span></span> <br /> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b>2. Buat direktori baru<o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Direktori baru ditempatkan di direktori “views” dalam module yang sama dengan Controller yang sudah di buat. Contoh direktori untuk “masterIdentitas” disimpan di views/masterIdentitas/<o:p></o:p></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. Tambahkan file view <o:p></o:p></b></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Tambahkan 3 file php berikut ke direktori yang telah di buat contoh didalam folder masterIdentitas :<o:p></o:p></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b><i>1) “index.php” :<o:p></o:p></i></b></div> <br /> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> File ini untuk menampilkan halaman utama.<o:p></o:p></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="line-height: 24px;"><iframe height="180" src="https://drive.google.com/file/d/0B08K6Cdvmsf0eXZXQnE5VGVFYzg/preview" width="640"></iframe></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="line-height: 24px;"><br /> </span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b><i>2) “_tabMenu.php” :<o:p></o:p></i></b></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> </div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> File ini untuk menampilkan tabular / tab menu.<o:p></o:p></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="line-height: 24px;"><iframe height="380" src="https://drive.google.com/file/d/0B08K6Cdvmsf0UUc1b0pWdmhtdVE/preview" width="640"></iframe></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="line-height: 24px;"><br /> </span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Code yang boleh disesuaikan /diubah di _tabMenu.php:<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";">'label'='Jenis Kelamin'<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> merupakan label yang akan muncul di tab menu (tabulasi)<o:p></o:p></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";">'id'='tab-default'<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> merupakan tab menu yang dijadikan default tampil. Ini disimpan di salah satu tab.<o:p></o:p></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";">'tab'='JenisKelamin'<o:p></o:p></span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-weight: bold; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;">merupakan nama controller / url yang akan ditampilkan pada iframe jika tab menu itu di klik.</span></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: "Calibri","sans-serif"; font-size: 11.0pt; line-height: 115%; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-weight: bold; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US; mso-hansi-theme-font: minor-latin;"><br /> </span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> <b><i>3) “_jsFunctions.php” :<o:p></o:p></i></b></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> </div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> File ini untuk menyimpan seluruh function js yang di gunakan baik itu oleh tab menu atau function lainnya.<o:p></o:p></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="line-height: 24px;"><iframe height="480" src="https://drive.google.com/file/d/0B08K6Cdvmsf0V1N6UUVPTlBrVHc/preview" width="640"></iframe></span></div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> Catatan:<o:p></o:p></div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> </div> <div class="MsoNormal" style="line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;"> “JenisKelamin” (JenisKelaminController) dan “StatusPernikahan” (StatusPernikahanController) merupakan MVC yang sudah dibuat sebelumnya.<o:p></o:p></div> </div> <div class="MsoNormal" style="margin-bottom: 0.0001pt;"> <span style="font-family: Courier New;"><span style="line-height: 24px;"><br /> </span></span></div> </div> </div> </div> </div>

Yii 1 : Membuat Tab Menu dengan BootMenu, iframe dan javascript

1. Buat Controller Baru Controller baru digunakan untuk index yang menyimpan tab menu serta iframe. Contoh controller: Master...

Baca selengkapnya »

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 »