--- civicrm_schema.mysql 2006-09-01 17:03:49.000000000 -0700
+++ civimailtest_org_civicrm.mysql 2006-09-01 17:01:51.000000000 -0700
@@ -1,6 +1,6 @@
-- MySQL dump 10.10
--
--- Host: localhost Database: civicrm_schema
+-- Host: localhost Database: civimailtest_org_civicrm
-- ------------------------------------------------------
-- Server version 5.0.22
@@ -304,10 +304,10 @@
`bcc_receipt` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'comma-separated list of email addresses to bcc each time a receipt is sent',
`receipt_text` text collate utf8_unicode_ci COMMENT 'text to include above standard receipt info on receipt email. emails are text-only, so do not allow html for now',
`is_active` tinyint(4) default NULL COMMENT 'Is this property active?',
- `footer_text` text collate utf8_unicode_ci COMMENT 'Text and html allowed. Displayed at the bottom of the first page of the contribution wizard.',
- `amount_block_is_active` tinyint(4) default '1' COMMENT 'Is this property active?',
`is_thermometer` tinyint(4) default NULL COMMENT 'Should this contribution have the thermometer block enabled?',
`thermometer_title` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Title for thermometer block.',
+ `footer_text` text collate utf8_unicode_ci COMMENT 'Text and html allowed. Displayed at the bottom of the first page of the contribution wizard.',
+ `amount_block_is_active` tinyint(4) default '1' COMMENT 'Is this property active?',
PRIMARY KEY (`id`),
KEY `domain_id` (`domain_id`),
KEY `contribution_type_id` (`contribution_type_id`),
@@ -353,7 +353,7 @@
`cancel_date` date NOT NULL COMMENT 'Date this recurring contribution was cancelled by contributor- if we can get access to it ??',
`is_active` tinyint(4) NOT NULL COMMENT 'Set to false by contributor cancellation or greater than max permitted failures - if we know about that.',
`cycle_day` int(10) unsigned NOT NULL default '1' COMMENT 'Day in the period when the payment should be charged e.g. 1st of month, 15th etc.',
- `next_sched_contribution` date NOT NULL COMMENT 'At Groundspring this was used by the cron job which triggered payments. If we''re not doing that but we know about payments, it might still be useful to store for display to org andor contributors.',
+ `next_sched_contribution` date NOT NULL COMMENT 'At Groundspring this was used by the cron job which triggered payments. If we are not doing that but we know about payments, it might still be useful to store for display to org andor contributors.',
`failure_count` int(10) unsigned default '0' COMMENT 'Number of failed charge attempts since last success. Business rule could be set to deactivate on more than x failures.',
`failure_retry_date` date default NULL COMMENT 'At Groundspring we set a business rule to retry failed payments every 7 days - and stored the next scheduled attempt date there.',
`processor_id` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Possibly needed to store a unique identifier for this recurring payment order - if this is available from the processor??',
@@ -564,7 +564,6 @@
`hold_date` datetime default NULL COMMENT 'When the address went on bounce hold',
`reset_date` datetime default NULL COMMENT 'When the address bounce status was last reset',
PRIMARY KEY (`id`),
- KEY `UI_email` (`email`),
KEY `location_id` (`location_id`),
CONSTRAINT `civicrm_email_ibfk_1` FOREIGN KEY (`location_id`) REFERENCES `civicrm_location` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
@@ -1453,6 +1452,7 @@
`entity_id` int(10) unsigned NOT NULL COMMENT 'Foreign key to the referenced item.',
`note` text collate utf8_unicode_ci COMMENT 'Note and/or Comment.',
`contact_id` int(10) unsigned NOT NULL COMMENT 'FK to Contact ID creator',
+ `solicitor_id` int(10) unsigned default NULL COMMENT 'FK to Solicitor ID',
`modified_date` date default NULL COMMENT 'When was this note last modified/edited',
`subject` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'subject of note description',
PRIMARY KEY (`id`),
@@ -1641,7 +1641,7 @@
`min_contribution` decimal(20,2) default NULL COMMENT 'Minimum contribution required to be eligible to select this premium.',
`cost` decimal(20,2) default NULL COMMENT 'Actual cost of this product. Useful to determine net return from sale or using this as an incentive.',
`is_active` tinyint(4) NOT NULL COMMENT 'Disabling premium removes it from the premiums_premium join table below.',
- `period_type` enum('rolling','fixed') collate utf8_unicode_ci default 'rolling' COMMENT 'Rolling means we set start/end based on current day, fixed means we set start/end for current year or month\n(e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006) ',
+ `period_type` enum('rolling','fixed') collate utf8_unicode_ci default 'rolling' COMMENT 'Rolling means we set start/end based on current day, fixed means we set start/end for current year or month (e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006) ',
`fixed_period_start_day` int(11) default '101' COMMENT 'Month and day (MMDD) that fixed period type subscription or membership starts.',
`duration_unit` enum('day','month','week','year') collate utf8_unicode_ci default 'year',
`duration_interval` int(11) default NULL COMMENT 'Number of units for total duration of subscription, service, membership (e.g. 12 Months).',
@@ -1899,7 +1899,6 @@
`is_active` tinyint(4) default '1' COMMENT 'Is this form currently active? If false, hide all related fields for all sharing contexts.',
`form_type` enum('CiviCRM Profile') collate utf8_unicode_ci default NULL COMMENT 'Type of form.',
`title` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Form title.',
- `collapse_display` int(10) unsigned default '0' COMMENT 'Will this group be in collapsed or expanded mode on initial display ?',
`help_pre` text collate utf8_unicode_ci COMMENT 'Description and/or help text to display before fields in form.',
`help_post` text collate utf8_unicode_ci COMMENT 'Description and/or help text to display after fields in form.',
`limit_listings_group_id` int(10) unsigned default NULL COMMENT 'Group id, foriegn key from civicrm_group',
@@ -1907,7 +1906,7 @@
`add_to_group_id` int(10) unsigned default NULL COMMENT 'foreign key to civicrm_group_id',
`add_captcha` tinyint(4) default '0' COMMENT 'Should a CAPTCHA widget be included this Profile form.',
`is_map` tinyint(4) default '0' COMMENT 'Do we want to map results from this profile.',
- `cancel_URL` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Redirect to URL when Cancle button clik .',
+ `cancel_URL` varchar(255) collate utf8_unicode_ci default NULL COMMENT 'Redirect to URL when Cancle button clik (sp) .',
PRIMARY KEY (`id`),
KEY `domain_id` (`domain_id`),
KEY `limit_listings_group_id` (`limit_listings_group_id`),