civicrm_arms_sample_data.sql 1.56 KB
Newer Older
totten's avatar
totten committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 25, 2011 at 06:20 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.2-1ubuntu4.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `civicrm_trunk`
--

--
-- Dumping data for table `civicrm_action_schedule`
--

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
(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);