fvByjNUL

1CREATE TABLE IF NOT EXISTS `enrollments` (
2`id` int(11) NOT NULL,
3`account_id` int(11) NOT NULL,
4`enrollment_condition_id` int(11) DEFAULT NULL,
5`enrollment_constraints` varchar(3000) COLLATE utf8_unicode_ci DEFAULT '--- []nn',
6`start_date` date DEFAULT NULL,
7`end_date` date DEFAULT NULL,
8`enabled` tinyint(1) DEFAULT '0',
9`created_at` datetime DEFAULT NULL,
10`updated_at` datetime DEFAULT NULL,
11`pre_enrolled` tinyint(1) DEFAULT '0',
12`accepted_covenants` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
13`enrolled` tinyint(1) DEFAULT '0',
14 `notes` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
15`society_id` int(11) DEFAULT NULL,
16`enrollment_creator_id` int(11) DEFAULT NULL,
17`refused_by_admin` tinyint(1) DEFAULT '0',
18`canceled_by_account` tinyint(1) DEFAULT '0',
19`deleted` tinyint(1) DEFAULT '0',
20`refuse_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
21`activator_id` int(11) DEFAULT NULL,
22`activation_datetime` datetime DEFAULT NULL,
23`number` int(11) DEFAULT '0',
24`society_role_id` int(11) DEFAULT NULL,
25`created_by_admin` tinyint(1) DEFAULT '0',
26`accounts_campaign_id` int(11) DEFAULT NULL,
27`ancestry` varchar(1020) COLLATE utf8_unicode_ci DEFAULT NULL,
28`dont_renew` tinyint(1) DEFAULT '0',
29`start_time` time DEFAULT NULL,
30`end_time` time DEFAULT NULL
31) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=393868 ;
32
33ALTER TABLE `enrollments`
34ADD PRIMARY KEY (`id`), ADD KEY `index_enrollments_on_enrollment_condition_id` (`enrollment_condition_id`), ADD KEY `accounting_tesseramento_soci2` (`society_id`,`activation_datetime`), ADD KEY `index_enrollments_on_society_role_id` (`society_role_id`), ADD KEY `index_enrollments_on_accounts_campaign_id` (`accounts_campaign_id`), ADD KEY `index_enrollments_on_ancestry_limited` (`ancestry`(254)), ADD KEY `enrollment_validation_uniqueness` (`account_id`,`enrollment_condition_id`,`canceled_by_account`,`number`);
35	
36UPDATE `enrollments` SET `accepted_covenants` = '--- []nn', `enrollment_constraints` = '--- n- :verified: falsen :value: {}nn :confirmed: falsen :id: 1n' WHERE `id` = 392587