Here is an example SQL statement used to set up a user:
INSERT INTO `member` VALUES (1, 'yourdomain.com', 'yourpassword', 'Your Company Name', '[email protected]', 'y', 'customtemplate.html', 'Website Page From !MAILFROMNAME!', 'yourdomain.com', 'yourlogo.jpg', 'The following page from the Your Company Name websitern(YourDomain.com) was suggested to you by: !MAILFROMNAME!.rnPage Title: !TITLE!rnLink: !URL!rnNote from !MAILFROMNAME!:rn!MESSAGE!', 'Your Company Name');
Next we create the cache table. It is relational to the
member table via the username field. Each record will
store the URL of the respective webpage in all lowercase,
the timestamp of when it was added to the table for use in
expiration, the <head> title of the webpage, and the
printable content.
member table via the username field. Each record will
store the URL of the respective webpage in all lowercase,
the timestamp of when it was added to the table for use in
expiration, the <head> title of the webpage, and the
printable content.
CREATE TABLE `cache` ( `id` tinyint(7) NOT NULL auto_increment, `username` varchar(25) NOT NULL default '', `url` varchar(100) default NULL, `date` varchar(20) default NULL, `title` varchar(50) default NULL, `body` blob, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ;
