WHMCS Services- SMS Manager 7.3.0 Not Nulled

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