File: all.sql

-- 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' );