--
-- Table structure for table `ws_smsmanager_config`
--
CREATE TABLE `ws_smsmanager_config` (
`setting` text COLLATE utf8_unicode_ci,
`value` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ws_smsmanager_confirmations`
--
CREATE TABLE `ws_smsmanager_confirmations` (
`id` int(10) UNSIGNED NOT NULL,
`userid` int(11) DEFAULT NULL,
`recipent` text COLLATE utf8_unicode_ci,
`confirmed` int(11) DEFAULT NULL,
`timestamp` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ws_smsmanager_hooks`
--
CREATE TABLE `ws_smsmanager_hooks` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci,
`description` text COLLATE utf8_unicode_ci,
`class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`hook` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`groupname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`isadmin` tinyint(1) NOT NULL DEFAULT '0',
`orderid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ws_smsmanager_logs`
--
CREATE TABLE `ws_smsmanager_logs` (
`id` int(10) UNSIGNED NOT NULL,
`userid` int(11) DEFAULT NULL,
`relid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci,
`type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`isadmin` tinyint(1) NOT NULL DEFAULT '0',
`send_at` datetime DEFAULT NULL,
`status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ws_smsmanager_multiconfig`
--
CREATE TABLE `ws_smsmanager_multiconfig` (
`id` int(10) UNSIGNED NOT NULL,
`country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`countrycode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`gateway` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`setting` text COLLATE utf8_unicode_ci,
`value` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ws_smsmanager_multilanguages`
--
CREATE TABLE `ws_smsmanager_multilanguages` (
`id` int(10) UNSIGNED NOT NULL,
`lang` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`value` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ws_smsmanager_preferences`
--
CREATE TABLE `ws_smsmanager_preferences` (
`id` int(10) UNSIGNED NOT NULL,
`userid` int(11) DEFAULT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`value` text COLLATE utf8_unicode_ci,
`status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `ws_smsmanager_confirmations`
--
ALTER TABLE `ws_smsmanager_confirmations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ws_smsmanager_hooks`
--
ALTER TABLE `ws_smsmanager_hooks`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ws_smsmanager_logs`
--
ALTER TABLE `ws_smsmanager_logs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ws_smsmanager_multiconfig`
--
ALTER TABLE `ws_smsmanager_multiconfig`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ws_smsmanager_multilanguages`
--
ALTER TABLE `ws_smsmanager_multilanguages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ws_smsmanager_preferences`
--
ALTER TABLE `ws_smsmanager_preferences`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `ws_smsmanager_confirmations`
--
ALTER TABLE `ws_smsmanager_confirmations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ws_smsmanager_hooks`
--
ALTER TABLE `ws_smsmanager_hooks`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ws_smsmanager_logs`
--
ALTER TABLE `ws_smsmanager_logs`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ws_smsmanager_multiconfig`
--
ALTER TABLE `ws_smsmanager_multiconfig`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ws_smsmanager_multilanguages`
--
ALTER TABLE `ws_smsmanager_multilanguages`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ws_smsmanager_preferences`
--
ALTER TABLE `ws_smsmanager_preferences`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;