register the device ID of the device and to check with the device id and status and date
CREATE TABLE IF NOT EXISTS `users` (
`firstname` varchar(50) NOT NULL DEFAULT '',
`lastname` varchar(50) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`password` varchar(25) NOT NULL DEFAULT '',
`deviceID` tinyint(4) NOT NULL,
`regCode` tinyint(4) NOT NULL,
`end_date` date NOT NULL,
`creation` date NOT NULL,
`status` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='no comment';
Our system http://www.rokumanager.com