| 1 | -- phpMyAdmin SQL Dump |
| 2 | -- version 3.3.7 |
| 3 | -- http://www.phpmyadmin.net |
| 4 | -- |
| 5 | -- Host: localhost |
| 6 | -- Generation Time: May 25, 2011 at 06:20 PM |
| 7 | -- Server version: 5.1.41 |
| 8 | -- PHP Version: 5.3.2-1ubuntu4.7 |
| 9 | |
| 10 | SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
| 11 | |
| 12 | |
| 13 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
| 14 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
| 15 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
| 16 | /*!40101 SET NAMES utf8 */; |
| 17 | |
| 18 | -- |
| 19 | -- Database: `civicrm_trunk` |
| 20 | -- |
| 21 | |
| 22 | -- |
| 23 | -- Dumping data for table `civicrm_action_schedule` |
| 24 | -- |
| 25 | |
| 26 | INSERT INTO `civicrm_action_schedule` (`id`, `name`, `title`, `recipient`, `entity_value`, `entity_status`, `start_action_offset`, `start_action_unit`, `start_action_condition`, `start_action_date`, `is_repeat`, `repetition_frequency_unit`, `repetition_frequency_interval`, `end_frequency_unit`, `end_frequency_interval`, `end_action`, `end_date`, `is_active`, `recipient_manual`, `body_text`, `body_html`, `subject`, `record_activity`, `mapping_id`, `group_id`) VALUES |
| 27 | (1, 'equipment_form_ daily_reminder', 'Equipment form, daily reminder', '3', '9', '2', 2, 'day', 'before', NULL, 1, 'hour', 1, 'year', 3, 'after', NULL, 1, NULL, 'This is a Text Body. If you see this message its text message that you reading.\r\n\r\nCheck if below tokens work\r\n{activity.activity_type}\r\n{activity.activity_date_time}\r\n', 'This a html message. If you see this message its html message that you reading.\r\n\r\nCheck if below tokens work\r\n{activity.activity_type}\r\n{activity.activity_date_time}', 'Action cron activity mail', 1, 1, NULL); |