-- phpMyAdmin SQL Dump
-- version 2.6.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generatie Tijd: 15 Mar 2007 om 06:32
-- Server versie: 4.1.12
-- PHP Versie: 5.0.4
-- 
-- Database: `rmprovider`
-- 

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

-- 
-- Tabel structuur voor tabel `role`
-- 

CREATE TABLE `role` (
  `Name` varchar(50) NOT NULL default '',
  `ApplicationName` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`Name`,`ApplicationName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- 
-- Tabel structuur voor tabel `user`
-- 

CREATE TABLE `user` (
  `ProviderUserKey` bigint(20) NOT NULL auto_increment,
  `Email` varchar(50) default NULL,
  `ApplicationName` varchar(50) default NULL,
  `UserName` varchar(50) default NULL,
  `Password` varchar(50) default NULL,
  `PasswordQuestion` varchar(50) default NULL,
  `PasswordAnswer` varchar(50) default NULL,
  `IsApproved` tinyint(1) NOT NULL default '0',
  `IsLockedOut` tinyint(1) NOT NULL default '0',
  `CreationDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `LastLoginDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `LastActivityDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `LastPasswordChangeDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `LastLockoutDate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ProviderUserKey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

-- 
-- Tabel structuur voor tabel `userrole`
-- 

CREATE TABLE `userrole` (
  `ApplicationName` varchar(50) NOT NULL default '',
  `UserName` varchar(50) NOT NULL default '',
  `RoleName` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`ApplicationName`,`UserName`,`RoleName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;