-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `doctoretcm_database`
--

-- --------------------------------------------------------

--
-- Table structure for table `oc_setting`
--

CREATE TABLE `oc_setting` (
  `setting_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL DEFAULT '0',
  `code` varchar(128) NOT NULL,
  `key` varchar(128) NOT NULL,
  `value` text NOT NULL,
  `serialized` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `oc_setting`
--

INSERT INTO `oc_setting` (`setting_id`, `store_id`, `code`, `key`, `value`, `serialized`) VALUES
(44350, 0, 'config', 'config_sms_appointment', '{\"status\":\"1\",\"template\":\"Your appointment has been {action} {date}  {time} at {storename}. Thank you\"}', 1),
(44349, 0, 'config', 'config_sms', '{\"host\":\"http:\\/\\/broadcast.smsgateway.cc\\/API\\/ReceiveSMS.aspx?Username={username}&amp;Password={password}&amp;MobileNumber={country_code}{mobile_number}&amp;ContentType={content_type}&amp;MsgText={msg_text}\",\"host_unicode\":\"http:\\/\\/broadcast.smsgateway.cc\\/api\\/Unicode.aspx?Username={username}&amp;Password={password}&amp;UMsg={msg_text}\",\"username\":\"tcm@qiangyitang.com\",\"password\":\"p@ssw0rd5400\",\"content_type\":\"1\"}', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `oc_setting`
--
ALTER TABLE `oc_setting`
  ADD PRIMARY KEY (`setting_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `oc_setting`
--
ALTER TABLE `oc_setting`
  MODIFY `setting_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44408;
COMMIT;

