-- http://www.phpmyadmin.net
--




--
-- Database: `numo_1319684120`
--

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

--
-- Table structure for table `accounts`
--

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NOT NULL,
  `is_admin` int(11) NOT NULL DEFAULT '0',
  `pending` int(1) NOT NULL DEFAULT '0',
  `activated` int(1) NOT NULL DEFAULT '0',
  `ip_address` varchar(25) NOT NULL,
  `when_created` datetime NOT NULL,
  `last_accessed` datetime NOT NULL,
  `slot_1` text NOT NULL COMMENT 'login id',
  `slot_2` text NOT NULL COMMENT 'password',
  `slot_3` text NOT NULL COMMENT 'email address',
  `slot_4` text NOT NULL COMMENT 'full name',
  `slot_5` text NOT NULL,
  `slot_6` text NOT NULL,
  `slot_7` text NOT NULL,
  `slot_8` text NOT NULL,
  `slot_9` text NOT NULL,
  `slot_10` text NOT NULL,
  `slot_11` text NOT NULL,
  `slot_12` text NOT NULL,
  `slot_13` text NOT NULL,
  `slot_14` text NOT NULL,
  `slot_15` text NOT NULL,
  `slot_16` text NOT NULL,
  `slot_17` text NOT NULL,
  `slot_18` text NOT NULL,
  `slot_19` text NOT NULL,
  `slot_20` text NOT NULL,
  `slot_21` text NOT NULL,
  `slot_22` text NOT NULL,
  `slot_23` text NOT NULL,
  `slot_24` text NOT NULL,
  `slot_25` text NOT NULL,
  `slot_26` text NOT NULL,
  `slot_27` text NOT NULL,
  `slot_28` text NOT NULL,
  `slot_29` text NOT NULL,
  `slot_30` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `type_id`, `is_admin`, `pending`, `activated`, `ip_address`, `when_created`, `last_accessed`, `slot_1`, `slot_2`, `slot_3`, `slot_4`, `slot_5`, `slot_6`, `slot_7`, `slot_8`, `slot_9`, `slot_10`, `slot_11`, `slot_12`, `slot_13`, `slot_14`, `slot_15`, `slot_16`, `slot_17`, `slot_18`, `slot_19`, `slot_20`, `slot_21`, `slot_22`, `slot_23`, `slot_24`, `slot_25`, `slot_26`, `slot_27`, `slot_28`, `slot_29`, `slot_30`) VALUES
(1, 1, 1, 0, 1, '96.50.118.234', '2011-10-27 08:47:48', '2011-11-19 06:36:32', 'Admin', '$1$C6VH7wES$Zl1mFrkUTBtL2Ds1T4qxf/', 'kenneth.browne@publicadjusters.com', 'Administrator', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(3, 2, 0, 0, 1, '24.127.215.109', '2011-10-29 19:34:36', '0000-00-00 00:00:00', 'Claims', '$1$4uIadO2K$U2FOKLlTL4HI8SmPwrpEZ0', 'claims@publicadjusters.com', 'Claims', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(4, 2, 0, 0, 1, '24.127.215.109', '2011-10-29 19:36:13', '2011-10-30 18:03:29', 'Sgiindy', '$1$NRliMKHC$N1JRuA.IZWcNC5h93LFOb1', 'sgiindy2000@yahoo.com', 'Sgiindy', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

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

--
-- Table structure for table `fields`
--

CREATE TABLE IF NOT EXISTS `fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL COMMENT 'name (label) of the field displayed',
  `slot` int(11) NOT NULL COMMENT 'slot number the field information can be found within',
  `position` int(11) NOT NULL COMMENT 'the position order the field should be displayed in',
  `required` int(1) NOT NULL DEFAULT '0' COMMENT 'required to be filled out to create an account',
  `locked` int(1) NOT NULL DEFAULT '0' COMMENT 'field cannot be removed',
  `show_on_registration` int(1) NOT NULL DEFAULT '1' COMMENT 'display on registration component',
  `input_type` varchar(50) NOT NULL COMMENT 'how the information should be input (i.e. select, text, number)',
  `input_options` text NOT NULL COMMENT 'any additional information that is needed for a given field type (i.e. list options for option list)',
  `regex` text NOT NULL COMMENT 'regular expression to match input on',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `fields`
--

INSERT INTO `fields` (`id`, `type_id`, `name`, `slot`, `position`, `required`, `locked`, `show_on_registration`, `input_type`, `input_options`, `regex`) VALUES
(1, 1, 'Username', 1, 3, 1, 1, 1, 'text', '', ''),
(2, 1, 'Password', 2, 4, 1, 1, 1, 'password', '', ''),
(3, 1, 'Email Address', 3, 2, 1, 1, 1, 'text', '', '^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$'),
(4, 1, 'Name', 4, 1, 1, 1, 1, 'text', '', ''),
(5, 2, 'Username', 1, 3, 1, 1, 1, 'text', '', ''),
(6, 2, 'Password', 2, 4, 1, 1, 1, 'password', '', ''),
(7, 2, 'Email Address', 3, 2, 1, 1, 1, 'text', '', '^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$'),
(8, 2, 'Name', 4, 1, 1, 1, 1, 'text', '', '');

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

--
-- Table structure for table `language_syntax`
--

CREATE TABLE IF NOT EXISTS `language_syntax` (
  `id` varchar(50) NOT NULL,
  `site_id` int(11) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `language_syntax`
--

INSERT INTO `language_syntax` (`id`, `site_id`, `value`) VALUES
('NUMO-INVALID_REQUEST_CODE', 1, 'Invalid request code. Please try again or contact your website administrator.'),
('NUMO-ADMINISTRATIVE_EMAIL_ADDRESS', 1, 'admin@sitename.com'),
('NUMO-FILE_NOT_FOUND_TITLE', 1, 'File Not Found'),
('NUMO-FILE_NOT_FOUND', 1, 'Oops! We were unable to locate the file you requested.'),
('RESTRICTED-LOGIN_REQUIRED', 1, '[NUMO.ACCOUNTS: LOGIN BOX]'),
('RESTRICTED-PERMISSION_NOT_GRANTED', 1, 'This page is not available to be viewed.'),
('RESTRICTED-LOGIN_REQUIRED_TITLE', 1, 'Login'),
('RESTRICTED-PERMISSION_NOT_GRANTED_TITLE', 1, 'No Permission'),
('RESTRICTED-MEMBER_LINK', 1, '<li><a href="[File]">[Label]</a></li>'),
('RESTRICTED-MEMBER_LINK_LOGOUT_LABEL', 1, 'Logout'),
('ACCOUNT-PENDING_ACTIVATION_ALERT', 1, 'Before you will be able to access your account information you will need to activate your account.  A welcome email message was sent to the email you used to register your account which contains instructions for activating your account.'),
('ACCOUNT-PENDING_REVIEW', 1, 'Your account is pending administrative review.  This content is currently not available at this time.  Once your account has been reviewed we will send you an email to notfity you.'),
('ACCOUNT-WELCOME_EMAIL', 1, 'Hi [Name],<br><br>Thank you for registering with SITE NAME.  Below are your login details.<br><br>Username: [Username]<br>Password: [Password]<br><br>To complete your account creation please activate you account: [activation link]<br><br>If you have any questions please contact us at (123) 456-7890<br><br>Regards,<br>SITE NAME Staff'),
('ACCOUNT-WELCOME_EMAIL-SUBJECT', 1, 'Welcome To SITE NAME'),
('ACCOUNT-APPROVED_EMAIL', 1, 'Hi [Name],<br><br>Thank you for registering with SITE NAME.  Your account has now been approved.<br><br>If you have any questions please contact us at (123) 456-7890<br><br>Regards,<br>SITE NAME Staff'),
('ACCOUNT-APPROVED_EMAIL-SUBJECT', 1, 'Account Approved at SITE NAME'),
('ACCOUNT-PENDING_ACTIVATION_ALERT_TITLE', 1, 'Account Pending Activation'),
('ACCOUNT-PENDING_REVIEW_TITLE', 1, 'Account Pending Review'),
('ACCOUNT-NEW_ACCOUNT_NOTIFICATION', 1, 'A new account has just been created.<br><br>Name: [Name]<br>Username: [Username]'),
('ACCOUNT-NEW_ACCOUNT_NOTIFICATION_SUBJECT', 1, 'New Account Created'),
('ACCOUNT-REGISTRATION_UNABLE_TO_CREATE_ACCOUNT', 1, 'Unable to create new account. Please try again.'),
('ACCOUNT-REGISTRATION_ACCOUNT_CREATED', 1, 'Account Created'),
('ACCOUNT-REGISTRATION_EMAIL_IN_USE', 1, 'Email address already in use; please enter a different Email address.'),
('ACCOUNT-REGISTRATION_USERNAME_IN_USE', 1, 'Username already in use; please enter a different username.'),
('ACCOUNT-REGISTRATION_BUTTON_LABEL', 1, 'Register'),
('ACCOUNT-LOGIN_INFORMATION_NOT_VALID', 1, 'Could not find account matching login information. Please try again.'),
('ACCOUNT-LOGIN_BUTTON_LABEL', 1, 'Login'),
('ACCOUNT-LOGIN_USERNAME_FIELD_LABEL', 1, 'Username'),
('ACCOUNT-LOGIN_PASSWORD_FIELD_LABEL', 1, 'Password'),
('ACCOUNT-FORGOT_LOGIN_INFO_EMAIL_SUBJECT', 1, 'SITE NAME Login Information Reminder'),
('ACCOUNT-FORGOT_LOGIN_INFO_EMAIL', 1, 'Hi [Name],<br><br>Your account login id is: [Username]<br><br>To change your password please click on the following link: [update password link]'),
('ACCOUNT-PASSWORD_UPDATED', 1, 'Thank-you; your password has been updated.'),
('ACCOUNT-UPDATE_PASSWORD_FIELD_LABEL', 1, 'Password'),
('ACCOUNT-UPDATE_PASSWORD_REPEAT_FIELD_LABEL', 1, 'Repeat Password'),
('ACCOUNT-REGISTRATION_VALUE_REQUIRED', 1, '** value required'),
('ACCOUNT-PASSWORDS_DONT_MATCH', 1, 'Passwords entered do not match.  Please try again.'),
('ACCOUNT-UPDATE_PASSWORD_BUTTON_LABEL', 1, 'Update'),
('ACCOUNT-DETAILS_UPDATED', 1, 'Thank-you, your account details have been updated.'),
('ACCOUNT-UPDATE_ACCOUNT_BUTTON_LABEL', 1, 'Update'),
('ACCOUNT-FORGOT_LOGIN_INFO_BUTTON_LABEL', 1, 'Retrieve Login Information'),
('ACCOUNT-FORGOT_LOGIN_INFO_EMAIL_FIELD_LABEL', 1, 'Email Address'),
('ACCOUNT-UPDATE_PASSWORD_REQUEST_COMPLETE', 1, 'Thank-you; your password has now been updated.  Please <a href="index.htm">click here</a> to continue.'),
('ACCOUNT-FORGOT_LOGIN_INFO_MESSAGE_SENT', 1, 'Thank-you.  An email notification has been sent out you containing your account login information.'),
('ACCOUNT-NO_SUCH_ACCOUNT', 1, 'There were no accounts in our system matching the information provided.'),
('ACCOUNT-ACTIVATION_COMPLETED', 1, 'Thank-you.  You''re account has been activated.'),
('ACCOUNT-ACTIVATION_CODE_INVALID', 1, 'We were unable to locate the pending activation request. Please try again or contact the webmaster.'),
('ACCOUNT-REGISTRATION_EMAIL_NOT_VALID', 1, 'Invalid email address entered'),
('ACCOUNT-LOGOUT_LABEL', 1, 'Logout'),
('ACCOUNT-LINK', 1, '<li><a href="[File]">[Label]</a></li>'),
('NUMO-TIMEZONE_CODE', 1, '');

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

--
-- Table structure for table `modules`
--

CREATE TABLE IF NOT EXISTS `modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`id`, `site_id`, `name`) VALUES
(1, 1, 'access_control'),
(2, 1, 'accounts'),
(3, 1, 'settings');

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

--
-- Table structure for table `pending_requests`
--

CREATE TABLE IF NOT EXISTS `pending_requests` (
  `id` varchar(50) NOT NULL,
  `site_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `module` varchar(50) NOT NULL,
  `component` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pending_requests`
--

INSERT INTO `pending_requests` (`id`, `site_id`, `account_id`, `module`, `component`) VALUES
('2adf3c140784adb1675318da6e4f385b8', 1, 2, 'accounts', 'activate');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NOT NULL,
  `protected_file_id` int(11) NOT NULL,
  `show_on_menu` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `type_id`, `protected_file_id`, `show_on_menu`) VALUES
(16, 1, 1, 1),
(15, 2, 5, 1),
(14, 1, 5, 1),
(6, 1, 3, 1),
(7, 2, 3, 1),
(8, 1, 4, 1),
(9, 2, 4, 1),
(17, 2, 1, 1),
(18, 1, 6, 1),
(19, 2, 6, 1),
(20, 1, 7, 1),
(21, 2, 7, 1),
(22, 1, 8, 1),
(23, 2, 8, 1),
(24, 1, 9, 1),
(25, 2, 9, 1);

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

--
-- Table structure for table `protected_files`
--

CREATE TABLE IF NOT EXISTS `protected_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `file_name` text NOT NULL,
  `link_label` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `protected_files`
--

INSERT INTO `protected_files` (`id`, `site_id`, `file_name`, `link_label`) VALUES
(1, 1, 'Staff Documents/Appraisal Contract - Ken Browne.doc', 'Appraisal Contract'),
(5, 1, 'Staff Documents/Document1.doc', ''),
(3, 1, 'staff_documents.htm', ''),
(4, 1, 'Table of Contents.htm', ''),
(6, 1, 'Staff Documents/Document2.doc', ''),
(7, 1, 'Staff Documents/Document3.doc', ''),
(8, 1, 'Staff Documents/Document4.doc', ''),
(9, 1, 'Staff Documents/Document5.doc', '');

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

--
-- Table structure for table `sites`
--

CREATE TABLE IF NOT EXISTS `sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain` text NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sites`
--

INSERT INTO `sites` (`id`, `domain`, `name`) VALUES
(1, 'single domain', 'Default');

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

--
-- Table structure for table `types`
--

CREATE TABLE IF NOT EXISTS `types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `available_slots` text NOT NULL,
  `allow_registration` int(1) NOT NULL DEFAULT '0',
  `require_approval` int(1) NOT NULL DEFAULT '0',
  `require_activation` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `types`
--

INSERT INTO `types` (`id`, `site_id`, `name`, `available_slots`, `allow_registration`, `require_approval`, `require_activation`) VALUES
(1, 1, 'default', '5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30', 0, 0, 0),
(2, 1, 'Employees', '5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30', 0, 0, 1);
