PHP Classes

File: all.sql

Recommend this page to a friend!
  Classes of very shafrudin   mysql.export   all.sql   Download  
File: all.sql
Role: Sample output
Content type: text/plain
Description: example output structure and data
Class: mysql.export
Export MySQL database to ZIP files
Author: By
Last change: file type
Date: 14 years ago
Size: 11,477 bytes
 

Contents

Class file image Download
-- Database Export Class----------------- -- Database Name smsgateway----------------- -- Class Created BY Very Shafrudin--------------- -- Struktur Tabel admin -------------------- CREATE TABLE IF NOT EXISTS `admin` ( `nomor` varchar(30) NOT NULL , `nama` varchar(20) NOT NULL , PRIMARY KEY (`nomor`) ); -- Data Tabel admin -------------------- INSERT INTO `admin` (`nomor`, `nama` ) VALUES ('085245019167','Udin Penyok' ), ('08115706122','Sony Maulana, ST' ); -- Struktur Tabel daemons -------------------- CREATE TABLE IF NOT EXISTS `daemons` ( `Start` text NOT NULL , `Info` text NOT NULL ); -- Data Tabel daemons -------------------- -- Struktur Tabel gammu -------------------- CREATE TABLE IF NOT EXISTS `gammu` ( `Version` tinyint(4) NOT NULL ); -- Data Tabel gammu -------------------- INSERT INTO `gammu` (`Version` ) VALUES ('7' ); -- Struktur Tabel inbox -------------------- CREATE TABLE IF NOT EXISTS `inbox` ( `UpdatedInDB` timestamp NOT NULL , `ReceivingDateTime` timestamp NOT NULL , `Text` text NOT NULL , `SenderNumber` varchar(20) NOT NULL , `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL , `UDH` text NOT NULL , `SMSCNumber` varchar(20) NOT NULL , `Class` int(11) NOT NULL , `TextDecoded` varchar(160) NOT NULL , `ID` int(11) unsigned NOT NULL auto_increment, `RecipientID` text NOT NULL , `Processed` enum('false','true') NOT NULL , UNIQUE KEY `ID` (`ID`) ); -- Data Tabel inbox -------------------- -- Struktur Tabel outbox -------------------- CREATE TABLE IF NOT EXISTS `outbox` ( `UpdatedInDB` timestamp NOT NULL , `InsertIntoDB` timestamp NOT NULL , `SendingDateTime` timestamp NOT NULL , `Text` text NULL , `DestinationNumber` varchar(20) NOT NULL , `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NULL , `UDH` text NULL , `Class` int(11) NULL , `TextDecoded` varchar(160) NOT NULL , `ID` int(11) unsigned NOT NULL auto_increment, `MultiPart` enum('false','true') NULL , `RelativeValidity` int(11) NULL , `SenderID` text NULL , `SendingTimeOut` timestamp NULL , `DeliveryReport` enum('default','yes','no') NULL , `CreatorID` text NOT NULL , UNIQUE KEY `ID` (`ID`) ); -- Data Tabel outbox -------------------- INSERT INTO `outbox` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `Class`, `TextDecoded`, `ID`, `MultiPart`, `RelativeValidity`, `SenderID`, `SendingTimeOut`, `DeliveryReport`, `CreatorID` ) VALUES ('2009-12-16 18:18:54','2009-12-16 18:18:54','2009-12-16 18:18:54','','085245019167','Default_No_Compression','','-1','Very Shafrudin, kondisi jaringan saat ini adalah SPOTA is lancar, Router Lab is unreachable, Puskom is unreachable . Network Monitoring Informatika.','4','false','-1','','2009-12-16 18:18:54','yes','' ); -- Struktur Tabel outbox_multipart -------------------- CREATE TABLE IF NOT EXISTS `outbox_multipart` ( `Text` text NULL , `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NULL , `UDH` text NULL , `Class` int(11) NULL , `TextDecoded` varchar(160) NULL , `ID` int(11) unsigned NOT NULL , `SequencePosition` int(11) NOT NULL ); -- Data Tabel outbox_multipart -------------------- -- Struktur Tabel pbk -------------------- CREATE TABLE IF NOT EXISTS `pbk` ( `GroupID` int(11) NOT NULL , `Name` text NOT NULL , `Number` text NOT NULL ); -- Data Tabel pbk -------------------- -- Struktur Tabel pbk_groups -------------------- CREATE TABLE IF NOT EXISTS `pbk_groups` ( `Name` text NOT NULL , `ID` int(11) NOT NULL auto_increment , UNIQUE KEY `ID` (`ID`) ); -- Data Tabel pbk_groups -------------------- -- Struktur Tabel pemberitahuan -------------------- CREATE TABLE IF NOT EXISTS `pemberitahuan` ( `id` bigint(20) NOT NULL auto_increment, `waktu` datetime NOT NULL , PRIMARY KEY (`id`) ); -- Data Tabel pemberitahuan -------------------- INSERT INTO `pemberitahuan` (`id`, `waktu` ) VALUES ('2','2009-12-16 18:18:54' ); -- Struktur Tabel phones -------------------- CREATE TABLE IF NOT EXISTS `phones` ( `ID` text NOT NULL , `UpdatedInDB` timestamp NOT NULL , `InsertIntoDB` timestamp NOT NULL , `TimeOut` timestamp NOT NULL , `Send` enum('yes','no') NOT NULL , `Receive` enum('yes','no') NOT NULL , `IMEI` text NOT NULL , `Client` text NOT NULL ); -- Data Tabel phones -------------------- INSERT INTO `phones` (`ID`, `UpdatedInDB`, `InsertIntoDB`, `TimeOut`, `Send`, `Receive`, `IMEI`, `Client` ) VALUES ('','2009-12-13 19:20:18','2009-12-13 19:18:35','2009-12-13 19:20:28','yes','yes','357123032865700','Gammu 1.09.00, Win XP Pro SP2, MS VC .NET 2005' ); -- Struktur Tabel sentitems -------------------- CREATE TABLE IF NOT EXISTS `sentitems` ( `UpdatedInDB` timestamp NOT NULL , `InsertIntoDB` timestamp NOT NULL , `SendingDateTime` timestamp NOT NULL , `DeliveryDateTime` timestamp NOT NULL , `Text` text NOT NULL , `DestinationNumber` varchar(20) NOT NULL , `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL , `UDH` text NOT NULL , `SMSCNumber` varchar(20) NOT NULL , `Class` int(11) NOT NULL , `TextDecoded` varchar(160) NOT NULL , `ID` int(11) unsigned NOT NULL , `SenderID` text NOT NULL , `SequencePosition` int(11) NOT NULL , `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL , `StatusError` int(11) NOT NULL , `TPMR` int(11) NOT NULL , `RelativeValidity` int(11) NOT NULL , `CreatorID` text NOT NULL ); -- Data Tabel sentitems -------------------- INSERT INTO `sentitems` (`UpdatedInDB`, `InsertIntoDB`, `SendingDateTime`, `DeliveryDateTime`, `Text`, `DestinationNumber`, `Coding`, `UDH`, `SMSCNumber`, `Class`, `TextDecoded`, `ID`, `SenderID`, `SequencePosition`, `Status`, `StatusError`, `TPMR`, `RelativeValidity`, `CreatorID` ) VALUES ('2009-12-13 19:08:31','2009-12-13 19:08:23','2009-12-13 19:08:31','0000-00-00 00:00:00','0020006C00610070006F00720061006E0020006B006F006E00640069007300690020006A006100720069006E00670061006E0020007300610061007400200069006E00690020006100640061006C00610068002000530050004F0054004100200069007300200075006E0072006500610063006800610062006C0065002C00200052006F00750074006500720020004C0061006200200069007300200063006F006E006E006500630074002C0020005000750073006B006F006D00200069007300200075006E0072006500610063006800610062006C006500200020002E0020004E006500740077006F0072006B0020004D006F006E00690074006F00720069006E006700200049006E0066006F0072006D006100740069006B0061002E','085245019167','Default_No_Compression','','+62818445009','-1',' laporan kondisi jaringan saat ini adalah SPOTA is unreachable, Router Lab is connect, Puskom is unreachable . Network Monitoring Informatika.','1','','1','SendingOKNoReport','-1','13','255','' ), ('2009-12-13 19:10:14','2009-12-13 19:10:03','2009-12-13 19:10:14','0000-00-00 00:00:00','0056006500720079002000530068006100660072007500640069006E002C0020006C00610070006F00720061006E0020006B006F006E00640069007300690020006A006100720069006E00670061006E0020007300610061007400200069006E00690020006100640061006C00610068002000530050004F0054004100200069007300200075006E0072006500610063006800610062006C0065002C00200052006F00750074006500720020004C0061006200200069007300200063006F006E006E006500630074002C0020005000750073006B006F006D00200069007300200075006E0072006500610063006800610062006C006500200020002E0020004E006500740077006F0072006B0020004D006F006E00690074006F00720069006E006700200049006E0066006F0072006D006100740069006B0061002E','085245019167','Default_No_Compression','','+62818445009','-1','Very Shafrudin, laporan kondisi jaringan saat ini adalah SPOTA is unreachable, Router Lab is connect, Puskom is unreachable . Network Monitoring Informatika.','2','','1','SendingOKNoReport','-1','14','255','' ), ('2009-12-13 19:16:16','2009-12-13 19:16:00','2009-12-13 19:16:16','0000-00-00 00:00:00','0056006500720079002000530068006100660072007500640069006E002C0020006B006F006E00640069007300690020006A006100720069006E00670061006E0020007300610061007400200069006E00690020006100640061006C00610068002000530050004F0054004100200069007300200075006E0072006500610063006800610062006C0065002C00200052006F00750074006500720020004C0061006200200069007300200063006F006E006E006500630074002C0020005000750073006B006F006D00200069007300200075006E0072006500610063006800610062006C006500200020002E0020004E006500740077006F0072006B0020004D006F006E00690074006F00720069006E006700200049006E0066006F0072006D006100740069006B0061002E','085245019167','Default_No_Compression','','+62818445009','-1','Very Shafrudin, kondisi jaringan saat ini adalah SPOTA is unreachable, Router Lab is connect, Puskom is unreachable . Network Monitoring Informatika.','1','','1','SendingOKNoReport','-1','15','255','' ), ('2009-12-13 19:16:33','2009-12-13 19:16:00','2009-12-13 19:16:33','0000-00-00 00:00:00','005900750073002000530068006F006C00760061002000530054002C0020004D0054002C0020006B006F006E00640069007300690020006A006100720069006E00670061006E0020007300610061007400200069006E00690020006100640061006C00610068002000530050004F0054004100200069007300200075006E0072006500610063006800610062006C0065002C00200052006F00750074006500720020004C0061006200200069007300200063006F006E006E006500630074002C0020005000750073006B006F006D00200069007300200075006E0072006500610063006800610062006C006500200020002E0020004E006500740077006F0072006B0020004D006F006E00690074006F00720069006E006700200049006E0066006F0072006D006100740069006B0061002E','08152203638','Default_No_Compression','','+62818445009','-1','Yus Sholva ST, MT, kondisi jaringan saat ini adalah SPOTA is unreachable, Router Lab is connect, Puskom is unreachable . Network Monitoring Informatika.','2','','1','SendingOKNoReport','-1','16','255','' ), ('2009-12-13 19:17:41','2009-12-13 19:17:33','2009-12-13 19:17:41','0000-00-00 00:00:00','0056006500720079002000530068006100660072007500640069006E002C0020006B006F006E00640069007300690020006A006100720069006E00670061006E0020007300610061007400200069006E00690020006100640061006C00610068002000530050004F0054004100200069007300200075006E0072006500610063006800610062006C0065002C00200052006F00750074006500720020004C0061006200200069007300200063006F006E006E006500630074002C0020005000750073006B006F006D00200069007300200075006E0072006500610063006800610062006C006500200020002E0020004E006500740077006F0072006B0020004D006F006E00690074006F00720069006E006700200049006E0066006F0072006D006100740069006B0061002E','085245019167','Default_No_Compression','','+62818445009','-1','Very Shafrudin, kondisi jaringan saat ini adalah SPOTA is unreachable, Router Lab is connect, Puskom is unreachable . Network Monitoring Informatika.','3','','1','SendingOK','-1','17','255','' ); -- Struktur Tabel t_user -------------------- CREATE TABLE IF NOT EXISTS `t_user` ( `username` varchar(30) NOT NULL , `password` varchar(50) NOT NULL , `level` tinyint(4) NOT NULL ); -- Data Tabel t_user -------------------- INSERT INTO `t_user` (`username`, `password`, `level` ) VALUES ('ADMIN','21232f297a57a5a743894a0e4a801fc3','1' ), ('SONY','6bec9c852847242e384a4d5ac0962ba0','2' );