DROP TABLE IF EXISTS `nuke_lastvisit`;
CREATE TABLE `nuke_lastvisit` (
`lvid` int(11) NOT NULL auto_increment,
`id` int(11) NOT NULL default '0',
`lvname` varchar(25) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`ip` varchar(15) NOT NULL default '0',
`startdate` int(11) NOT NULL default '0',
`lastlogin` int(12) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`lastlogindate` varchar(12) NOT NULL default '0',
`lastlogintime` varchar(8) NOT NULL default '0',
`flagged` int(1) NOT NULL default '0',
`flagdate` varchar(12) NOT NULL default '0',
`flagdatedispl` varchar(12) NOT NULL default '0',
`lvstatus` int(1) NOT NULL default '0',
`susp` int(1) NOT NULL default '0',
`protect` int(1) NOT NULL default '0',
`lvprocess` int(1) NOT NULL default '0',
`mark` int(1) NOT NULL default '0',
`lvgroup` int(11) NOT NULL default '0',
`lvtype` int(1) NOT NULL default '0',
`agent` varchar(255) NOT NULL default '',
PRIMARY KEY (`lvid`),
KEY `id` (`id`),
KEY `lvstatus` (`lvstatus`),
KEY `hits` (`hits`),
KEY `lastlogindate` (`lastlogindate`),
KEY `susp` (`susp`),
KEY `protect` (`protect`),
KEY `flagged` (`flagged`),
KEY `lastlogin` (`lastlogin`),
KEY `lvname` (`lvname`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `nuke_lastvisit_ban`;
CREATE TABLE `nuke_lastvisit_ban` (
`lvipid` int(11) NOT NULL auto_increment,
`lvbanip` varchar(16) NOT NULL default '',
PRIMARY KEY (`lvipid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `nuke_lastvisit_dls`;
CREATE TABLE `nuke_lastvisit_dls` (
`lvdlid` int(11) NOT NULL auto_increment,
`lvdluid` int(11) NOT NULL default '0',
`lvdllid` int(11) NOT NULL default '0',
`lvdlhits` int(11) NOT NULL default '0',
`lvdldate` varchar(12) NOT NULL default '0',
`lvdltime` varchar(8) NOT NULL default '0',
PRIMARY KEY (`lvdlid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `nuke_lastvisit_groups`;
CREATE TABLE `nuke_lastvisit_groups` (
`lvgroupid` int(11) NOT NULL auto_increment,
`lvgroupname` varchar(150) NOT NULL default '',
`lvgroupcolor` varchar(6) NOT NULL default 'FFFFFF',
PRIMARY KEY (`lvgroupid`),
KEY `groupid` (`lvgroupid`),
KEY `groupname` (`lvgroupname`),
KEY `groupcolor` (`lvgroupcolor`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `nuke_lastvisit_job`;
CREATE TABLE `nuke_lastvisit_job` (
`lastrun` int(11) NOT NULL default '0',
`active` int(1) NOT NULL default '0',
`online` int(11) NOT NULL default '0',
`onlineactive` char(1) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `nuke_lastvisit_job`
--

INSERT INTO `nuke_lastvisit_job` VALUES (1133834107, 0, 1133835003, '0');

DROP TABLE IF EXISTS `nuke_lastvisit_mail`;
CREATE TABLE `nuke_lastvisit_mail` (
`wid` int(11) NOT NULL auto_increment,
`body` text NOT NULL,
`mailsub` varchar(255) NOT NULL default '',
`descr` varchar(255) NOT NULL default '',
PRIMARY KEY (`wid`),
KEY `wid` (`wid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

--
-- Dumping data for table `nuke_lastvisit_mail`
--

INSERT INTO `nuke_lastvisit_mail` VALUES (1, 'Hello [mn]: \r\nThis email is to inform you that your account at [sn] may soon be terminated due to inactivity. To avoid account cancellation simply login to your account at <a href=[url]>[sn]</a>.\r\n\r\nWe value our members and hope that you will continue to be one!\r\n\r\nBest regards,\r\n [sn] Staff\r\n\r\n\r\nThis message was automatically generated by the [sn] accounts management system.', '[sn] Account Cancellation Notice', 'Example');
INSERT INTO `nuke_lastvisit_mail` VALUES (2, 'Hello [mn]:\r\n\r\nWe are worried about you! The [sn] accounts management system says that you have not logged into your [sn] account since [lv]. We certainly hope that all is well. [sn] memberships automatically expire when there is extensive inactivity, but we sure do hope you will visit us at [url] before that happens.\r\n\r\nBest wishes,\r\n[sn] Accounts Management Staff', 'Thinking of you ...', 'Example 2');

DROP TABLE IF EXISTS `nuke_lastvisit_settings`;
CREATE TABLE `nuke_lastvisit_settings` (
`jobint` int(6) NOT NULL default '3600',
`jobinc` int(1) NOT NULL default '0',
`defmail` int(4) NOT NULL default '1',
`autoterm` int(1) NOT NULL default '0',
`terminc` int(6) NOT NULL default '30',
`automail` int(1) NOT NULL default '0',
`mailinc` int(6) NOT NULL default '20',
`trackmax` int(5) NOT NULL default '10',
`listmax` int(5) NOT NULL default '100',
`sendlog` int(1) NOT NULL default '1',
`logadd` varchar(255) NOT NULL default '',
`defordr` int(2) NOT NULL default '1',
`eadd` varchar(200) NOT NULL default '0',
`hadd` varchar(255) NOT NULL default '',
`autop` int(1) NOT NULL default '0',
`promax` varchar(5) NOT NULL default '100',
`bbspare` int(1) NOT NULL default '0',
`bbspareid` int(11) NOT NULL default '0',
`flood` int(3) NOT NULL default '1000',
`suspmes` longtext NOT NULL,
`ccmail` int(1) NOT NULL default '0',
`ccmailadd` varchar(255) NOT NULL default '',
`allaccess` int(1) NOT NULL default '2',
`jobfile` varchar(255) NOT NULL default '',
`tzone` varchar(150) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `nuke_lastvisit_settings`
--

INSERT INTO `nuke_lastvisit_settings` VALUES (1, 1, 1, 0, 30, 0, 20, 10, 15, 1, ' ', 10, ' ', 'x', 1, '3000', 1, 1, 3000, 'You are suspended!', 1, ' ', 2, 'lastvisit_job', 'America/Chicago');

DROP TABLE IF EXISTS `nuke_lastvisit_track`;
CREATE TABLE `nuke_lastvisit_track` (
`tid` int(11) NOT NULL auto_increment,
`truid` varchar(25) NOT NULL default '',
`mname` varchar(255) NOT NULL default '',
`purl` varchar(255) NOT NULL default '',
`ptime` varchar(8) NOT NULL default '00:00:00',
`pdate` varchar(12) NOT NULL default '0',
`hits` varchar(11) NOT NULL default '0',
PRIMARY KEY (`tid`),
KEY `uid` (`truid`),
KEY `mname` (`mname`),
KEY `purl` (`purl`),
KEY `hits` (`hits`),
KEY `tid` (`tid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;