SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `rainloop1170`
--
-- --------------------------------------------------------
--
-- Table structure for table `rainloop_ab_contacts`
--
CREATE TABLE `rainloop_ab_contacts` (
`id_contact` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`id_contact_str` varchar(128) NOT NULL DEFAULT '',
`id_user` int(10) unsigned NOT NULL,
`display` varchar(255) NOT NULL DEFAULT '',
`changed` int(10) unsigned NOT NULL DEFAULT '0',
`deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
`etag` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '',
PRIMARY KEY (`id_contact`),
KEY `id_user_rainloop_ab_contacts_index` (`id_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `rainloop_ab_properties`
--
CREATE TABLE `rainloop_ab_properties` (
`id_prop` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`id_contact` bigint(20) unsigned NOT NULL,
`id_user` int(10) unsigned NOT NULL,
`prop_type` tinyint(3) unsigned NOT NULL,
`prop_type_str` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
`prop_value` text NOT NULL,
`prop_value_custom` text NOT NULL,
`prop_value_lower` text NOT NULL,
`prop_frec` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id_prop`),
KEY `id_user_rainloop_ab_properties_index` (`id_user`),
KEY `id_user_id_contact_rainloop_ab_properties_index` (`id_user`,`id_contact`),
KEY `id_contact_prop_type_rainloop_ab_properties_index` (`id_contact`,`prop_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `rainloop_system`
--
CREATE TABLE `rainloop_system` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sys_name` varchar(50) NOT NULL,
`value_int` int(10) unsigned NOT NULL DEFAULT '0',
`value_str` varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `sys_name_rainloop_system_index` (`sys_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `rainloop_system`
--
INSERT INTO `rainloop_system` VALUES
(3, 'mysql-ab-version_version', 3, '');
-- --------------------------------------------------------
--
-- Table structure for table `rainloop_users`
--
CREATE TABLE `rainloop_users` (
`id_user` int(10) unsigned NOT NULL AUTO_INCREMENT,
`rl_email` varchar(128) NOT NULL DEFAULT '',
PRIMARY KEY (`id_user`),
KEY `rl_email_rainloop_users_index` (`rl_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
