sql/civicrm_arms_sample_data.sql

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