[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

--

[10] Fix | Delete

-- Database: `rainloop1170`

[11] Fix | Delete

--

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

--

[16] Fix | Delete

-- Table structure for table `rainloop_ab_contacts`

[17] Fix | Delete

--

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `rainloop_ab_contacts` (

[20] Fix | Delete

`id_contact` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`id_contact_str` varchar(128) NOT NULL DEFAULT '',

[22] Fix | Delete

`id_user` int(10) unsigned NOT NULL,

[23] Fix | Delete

`display` varchar(255) NOT NULL DEFAULT '',

[24] Fix | Delete

`changed` int(10) unsigned NOT NULL DEFAULT '0',

[25] Fix | Delete

`deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',

[26] Fix | Delete

`etag` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '',

[27] Fix | Delete

PRIMARY KEY (`id_contact`),

[28] Fix | Delete

KEY `id_user_rainloop_ab_contacts_index` (`id_user`)

[29] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[30] Fix | Delete

[31] Fix | Delete

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

[32] Fix | Delete

[33] Fix | Delete

--

[34] Fix | Delete

-- Table structure for table `rainloop_ab_properties`

[35] Fix | Delete

--

[36] Fix | Delete

[37] Fix | Delete

CREATE TABLE `rainloop_ab_properties` (

[38] Fix | Delete

`id_prop` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

[39] Fix | Delete

`id_contact` bigint(20) unsigned NOT NULL,

[40] Fix | Delete

`id_user` int(10) unsigned NOT NULL,

[41] Fix | Delete

`prop_type` tinyint(3) unsigned NOT NULL,

[42] Fix | Delete

`prop_type_str` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',

[43] Fix | Delete

`prop_value` text NOT NULL,

[44] Fix | Delete

`prop_value_custom` text NOT NULL,

[45] Fix | Delete

`prop_value_lower` text NOT NULL,

[46] Fix | Delete

`prop_frec` int(10) unsigned NOT NULL DEFAULT '0',

[47] Fix | Delete

PRIMARY KEY (`id_prop`),

[48] Fix | Delete

KEY `id_user_rainloop_ab_properties_index` (`id_user`),

[49] Fix | Delete

KEY `id_user_id_contact_rainloop_ab_properties_index` (`id_user`,`id_contact`),

[50] Fix | Delete

KEY `id_contact_prop_type_rainloop_ab_properties_index` (`id_contact`,`prop_type`)

[51] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[52] Fix | Delete

[53] Fix | Delete

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

[54] Fix | Delete

[55] Fix | Delete

--

[56] Fix | Delete

-- Table structure for table `rainloop_system`

[57] Fix | Delete

--

[58] Fix | Delete

[59] Fix | Delete

CREATE TABLE `rainloop_system` (

[60] Fix | Delete

`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

[61] Fix | Delete

`sys_name` varchar(50) NOT NULL,

[62] Fix | Delete

`value_int` int(10) unsigned NOT NULL DEFAULT '0',

[63] Fix | Delete

`value_str` varchar(128) NOT NULL DEFAULT '',

[64] Fix | Delete

PRIMARY KEY (`id`),

[65] Fix | Delete

KEY `sys_name_rainloop_system_index` (`sys_name`)

[66] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

[67] Fix | Delete

[68] Fix | Delete

--

[69] Fix | Delete

-- Dumping data for table `rainloop_system`

[70] Fix | Delete

--

[71] Fix | Delete

[72] Fix | Delete

INSERT INTO `rainloop_system` VALUES

[73] Fix | Delete

(3, 'mysql-ab-version_version', 3, '');

[74] Fix | Delete

[75] Fix | Delete

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

[76] Fix | Delete

[77] Fix | Delete

--

[78] Fix | Delete

-- Table structure for table `rainloop_users`

[79] Fix | Delete

--

[80] Fix | Delete

[81] Fix | Delete

CREATE TABLE `rainloop_users` (

[82] Fix | Delete

`id_user` int(10) unsigned NOT NULL AUTO_INCREMENT,

[83] Fix | Delete

`rl_email` varchar(128) NOT NULL DEFAULT '',

[84] Fix | Delete

PRIMARY KEY (`id_user`),

[85] Fix | Delete

KEY `rl_email_rainloop_users_index` (`rl_email`)

[86] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[87] Fix | Delete

[88] Fix | Delete

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[89] Fix | Delete

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

[90] Fix | Delete

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[91] Fix | Delete

[92] Fix | Delete