-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 18, 2006 at 03:01 PM
-- Server version: 4.1.12
-- PHP Version: 5.0.4

-- --------------------------------------------------------

-- 
-- Table structure for table `ur_destination`
-- 

CREATE TABLE `ur_destination` (
  `id` int(11) NOT NULL default '0',
  `portal_id` int(11) NOT NULL default '0',
  `member_id` int(11) NOT NULL default '0',
  `username` varchar(32) NOT NULL default '',
  `url` text NOT NULL,
  `last_use` tinytext NOT NULL,
  `last_hit_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `hit_count` int(11) NOT NULL default '0',
  `max_hit_count` int(11) NOT NULL default '0',
  `hit_count_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `max_hit_count_sunday` int(11) NOT NULL default '0',
  `max_hit_count_monday` int(11) NOT NULL default '0',
  `max_hit_count_tuesday` int(11) NOT NULL default '0',
  `max_hit_count_wednesday` int(11) NOT NULL default '0',
  `max_hit_count_thursday` int(11) NOT NULL default '0',
  `max_hit_count_friday` int(11) NOT NULL default '0',
  `max_hit_count_saturday` int(11) NOT NULL default '0',
  `hits_today` int(11) NOT NULL default '0',
  `hits_this_round` int(11) NOT NULL default '0',
  `hits_per_round` int(11) NOT NULL default '0',
  `creation_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `active_period_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `active_period_end_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `description` tinytext NOT NULL,
  `status` enum('enabled','disabled') NOT NULL default 'enabled',
  PRIMARY KEY  (`id`),
  KEY `portal_id` (`portal_id`,`hits_this_round`,`status`),
  KEY `username` (`username`,`portal_id`),
  KEY `member_id` (`member_id`,`portal_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `ur_destination`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `ur_destination_seq`
-- 

CREATE TABLE `ur_destination_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `ur_destination_seq`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `ur_member`
-- 

CREATE TABLE `ur_member` (
  `id` int(11) NOT NULL default '0',
  `username` varchar(32) NOT NULL default '',
  `hashed_password` varchar(32) NOT NULL default '',
  `email_address` varchar(255) NOT NULL default '',
  `user_level` tinytext NOT NULL,
  `creation_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `expiration_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_login_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_login_ip` tinytext NOT NULL,
  `total_logins` int(11) NOT NULL default '0',
  `custom_max_portals` int(11) NOT NULL default '0',
  `custom_max_destinations_per_portal` int(11) NOT NULL default '0',
  `custom_traffic_diversion_interval` int(11) NOT NULL default '0',
  `custom_traffic_diversion_url` text NOT NULL,
  `language` tinytext NOT NULL,
  `date_format` tinytext NOT NULL,
  `thousands_separator` tinytext NOT NULL,
  `decimal_point` tinytext NOT NULL,
  `user_privileges` enum('member','administrator') NOT NULL default 'member',
  `recovery_key` tinytext NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `email_address` (`email_address`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `ur_member`
-- 

INSERT INTO `ur_member` VALUES (1, 'admin', 'cf2861e058054980c8398afdc758348c', 'nobody@127.0.0.1', '0', '2005-01-01 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 100, 1000, 0, '', 'english', '%I:%M %p %a, %d %b, %Y', ',', '.', 'administrator', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `ur_member_seq`
-- 

CREATE TABLE `ur_member_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `ur_member_seq`
-- 

INSERT INTO `ur_member_seq` VALUES (1);

-- --------------------------------------------------------

-- 
-- Table structure for table `ur_portal`
-- 

CREATE TABLE `ur_portal` (
  `id` int(11) NOT NULL default '0',
  `member_id` int(11) NOT NULL default '0',
  `username` varchar(32) NOT NULL default '',
  `portal_name` varchar(255) NOT NULL default '',
  `description` tinytext NOT NULL,
  `last_hit_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `hit_count_rotated` int(11) NOT NULL default '0',
  `hit_count_revisited` int(11) NOT NULL default '0',
  `hit_count_defaulted` int(11) NOT NULL default '0',
  `hit_count_diverted` int(11) NOT NULL default '0',
  `hit_count_total` int(11) NOT NULL default '0',
  `hit_count_start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `creation_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `default_url` text NOT NULL,
  `revisit_behaviour` enum('normal_rotation','reuse_previous_destination') NOT NULL default 'normal_rotation',
  `traffic_diversion_hit_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `username` (`username`,`portal_name`),
  KEY `member_id` (`member_id`,`portal_name`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `ur_portal`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `ur_portal_seq`
-- 

CREATE TABLE `ur_portal_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `ur_portal_seq`
--