Ini adalah 1.25
CREATE TABLE `pbk` (
`GroupID` integer NOT NULL default '-1',
`Name` text NOT NULL,
`Number` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Ini adalah versi 1.28
CREATE TABLE `pbk` (
`ID` integer NOT NULL auto_increment,
`GroupID` integer NOT NULL default '-1',
`Name` text NOT NULL,
`Number` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Sehingga perkiraan, tabelnya akan seperti ini perbedaannya
1.25
GroupID | Name | Number |
---|---|---|
1.28
ID | GroupID | Name | Number |
---|---|---|---|
Disamping itu struktur database juga mengalami perbedaan pada adanya penambahan CREATE_INDEX untuk Gammu mulai versi 1.28
CREATE INDEX sentitems_date ON sentitems(DeliveryDateTime);
CREATE INDEX sentitems_tpmr ON sentitems(TPMR);
CREATE INDEX sentitems_dest ON sentitems(DestinationNumber);
CREATE INDEX sentitems_sender ON sentitems(SenderID);
Sedangkan pada 1.29 sudah lebih dilengkapi lagi dengan adanya TRIGGER untuk beberapa proses pengolahan data
CREATE INDEX sentitems_date ON sentitems(DeliveryDateTime);
CREATE INDEX sentitems_tpmr ON sentitems(TPMR);
CREATE INDEX sentitems_dest ON sentitems(DestinationNumber);
CREATE INDEX sentitems_sender ON sentitems(SenderID);
--
-- Dumping data for table `sentitems`
--
--
-- Triggers for setting default timestamps
--
DELIMITER //
CREATE TRIGGER inbox_timestamp BEFORE INSERT ON inbox
FOR EACH ROW
BEGIN
IF NEW.ReceivingDateTime = '0000-00-00 00:00:00' THEN
SET NEW.ReceivingDateTime = CURRENT_TIMESTAMP();
END IF;
END;//
CREATE TRIGGER outbox_timestamp BEFORE INSERT ON outbox
FOR EACH ROW
BEGIN
IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
END IF;
IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
END IF;
IF NEW.SendingTimeOut = '0000-00-00 00:00:00' THEN
SET NEW.SendingTimeOut = CURRENT_TIMESTAMP();
END IF;
END;//
CREATE TRIGGER phones_timestamp BEFORE INSERT ON phones
FOR EACH ROW
BEGIN
IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
END IF;
IF NEW.TimeOut = '0000-00-00 00:00:00' THEN
SET NEW.TimeOut = CURRENT_TIMESTAMP();
END IF;
END;//
CREATE TRIGGER sentitems_timestamp BEFORE INSERT ON sentitems
FOR EACH ROW
BEGIN
IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
END IF;
IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
END IF;
END;//
DELIMITER ;
http://wammu.eu/download/gammu/win32/
BalasHapus*gemes*
BalasHapuslha piye karepe .... opo mengko tak dolan meneh
BalasHapuskapan?
BalasHapusklimax
BalasHapusra mudheng
BalasHapusora dong tenan
BalasHapus;;) yuk kapan
BalasHapus;;) yuk kapan
BalasHapuswow klimax setelah dekmaniezt
BalasHapustak gawe mudheng
BalasHapusdong ora tenanan... :D aku yo ra dong kok
BalasHapusSenenge ngono tho, dibolak-balekke terus *manyun*
BalasHapusaku akan sms dirimu :)
BalasHapusnyambi ngobrol menthelengi juga ah...
BalasHapus#tetep radhong :(
Haduh..bahasa macam apa ini...
BalasHapus