FM / tht

/var/softaculous/tht

Name	Size	Mode	Actions
images/	-	0755	rm
php53/	-	0755	rm
php56/	-	0755	rm
php71/	-	0755	rm
clone.php	3472	0644	edit dl rm
conf.inc.php	634	0644	edit dl rm
edit.php	5267	0644	edit dl rm
edit.xml	433	0644	edit dl rm
fileindex.php	93	0644	edit dl rm
import.php	4141	0644	edit dl rm
info.xml	2180	0644	edit dl rm
install.js	924	0644	edit dl rm
install.php	4299	0644	edit dl rm
install.xml	1342	0644	edit dl rm
md5	4499	0644	edit dl rm
notes.txt	146	0644	edit dl rm
tht.sql	28070	0644	edit dl rm
tht.zip	3496845	0644	edit dl rm
upgrade.php	3144	0644	edit dl rm
upgrade.xml	301	0644	edit dl rm

Edit: /var/softaculous/tht/tht.sql (28070B)

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

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

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

--
-- Table structure for table `[[dbprefix]]acpnav`
--

CREATE TABLE `[[dbprefix]]acpnav` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `visual` varchar(20) NOT NULL,
  `icon` varchar(50) NOT NULL,
  `link` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `[[dbprefix]]acpnav`
--

INSERT INTO `[[dbprefix]]acpnav` VALUES
(1, 'Home', 'house.png', 'home'),
(2, 'General Settings', 'cog.png', 'settings'),
(3, 'Servers', 'server.png', 'servers'),
(4, 'Packages', 'package_green.png', 'packages'),
(5, 'Staff Accounts', 'user_gray.png', 'staff'),
(6, 'Subdomains', 'link.png', 'sub'),
(7, 'Clients', 'group.png', 'users'),
(8, 'Change Password', 'shield.png', 'pass'),
(9, 'Server Status', 'computer.png', 'status'),
(10, 'Mail Center', 'email_open.png', 'email'),
(12, 'Client Importer', 'user_orange.png', 'import'),
(13, 'Tickets', 'page_white_text.png', 'tickets'),
(14, 'Knowledge Base', 'folder.png', 'kb'),
(15, 'Look & Feel', 'rainbow.png', 'lof'),
(19, 'Invoice Management', 'script.png', 'invoices'),
(20, 'Logs', 'report.png', 'logs');

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

--
-- Table structure for table `[[dbprefix]]articles`
--

CREATE TABLE `[[dbprefix]]articles` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `catid` mediumint(9) NOT NULL,
  `name` varchar(100) NOT NULL,
  `content` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]cats`
--

CREATE TABLE `[[dbprefix]]cats` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]clientnav`
--

CREATE TABLE `[[dbprefix]]clientnav` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `visual` varchar(20) NOT NULL,
  `icon` varchar(50) NOT NULL,
  `link` varchar(20) NOT NULL,
  `weight` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `[[dbprefix]]clientnav`
--

INSERT INTO `[[dbprefix]]clientnav` VALUES
(1, 'Home', 'house.png', 'home', -100),
(3, 'Announcements', 'bell.png', 'notices', 1),
(4, 'View Package', 'package.png', 'view', 15),
(5, 'Edit Details', 'user_edit.png', 'details', 30),
(2, 'Delete Account', 'cross.png', 'delete', 100),
(7, 'Invoices', 'script.png', 'invoices', 45),
(8, 'Tickets', 'page_white_text.png', 'tickets', 60),
(9, 'Change Email', 'email_edit.png', 'email', 31);

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

--
-- Table structure for table `[[dbprefix]]config`
--

CREATE TABLE `[[dbprefix]]config` (
  `name` varchar(50) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]config`
--

INSERT INTO `[[dbprefix]]config` VALUES
('url', '[[softurl]]/'),
('vname', '1.2.6'),
('vcode', '1010206'),
('whm-ssl', '1'),
('paypalemail', 'your@email.com'),
('default', 'order'),
('theme', 'Reloaded2'),
('name', '[[site_name]]'),
('tos', 'The following content is prohibited on our servers:<ol><li>Illegal use</li><li>Threatening Material</li><li>Fraudulent Content</li><li>Forgery or Impersonation</li><li>Unsolicited Content</li><li>Copyright Infringements</li><li>Collection of Private Date (Unless DPA Registered)</li><li>Viruses</li><li>IRC Networks (Including all IRC Material)</li><li>Peer to Peer software&nbsp; </li><li>Any Adult Content</li><li>Non-english Content</li></ol>'),
('multiple', '1'),
('general', '1'),
('message', 'Signups are currently disabled. Contact your host for more information.'),
('delacc', '1'),
('cenabled', '1'),
('cmessage', 'Client area isn''t enabled. Sorry, contact your host for more details.'),
('emailmethod', 'php'),
('emailfrom', '[[admin_email]]'),
('smtp_host', 'localhost'),
('smtp_user', 'user'),
('smtp_password', 'password'),
('show_version_id', '1'),
('show_acp_menu', '0'),
('show_page_gentime', '1'),
('alerts', '&nbsp;'),
('p2hcheck', ''),
('show_footer', '0'),
('senabled', '1'),
('smessage', 'Support area isn''t enabled. Sorry, contact your host for more details.'),
('terminationdays', '14'),
('suspensiondays', '14'),
('tldonly', '0'),
('currency', 'USD'),
('ui-theme', 'cupertino'),
('timezone', 'UTC'),
('wwwsubdomain', 'both'),
('emailval', '1'),
('smtp_port', '25'),
('smtp_secure', '0');

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

--
-- Table structure for table `[[dbprefix]]invoices`
--

CREATE TABLE `[[dbprefix]]invoices` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `uid` int(255) NOT NULL,
  `amount` varchar(20) NOT NULL,
  `is_paid` int(1) NOT NULL DEFAULT '0',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `due` text NOT NULL,
  `is_suspended` int(1) NOT NULL DEFAULT '0',
  `notes` text NOT NULL,
  `uniqueid` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]logs`
--

CREATE TABLE `[[dbprefix]]logs` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `uid` varchar(5) NOT NULL,
  `loguser` varchar(50) NOT NULL,
  `logtime` varchar(20) NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]navbar`
--

CREATE TABLE `[[dbprefix]]navbar` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `icon` varchar(20) NOT NULL,
  `visual` varchar(70) NOT NULL,
  `link` varchar(20) NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `[[dbprefix]]navbar`
--

INSERT INTO `[[dbprefix]]navbar` VALUES
(1, 'cart.png', 'Order Form', 'order', 1),
(2, 'user.png', 'Client Area', 'client', 0),
(3, 'key.png', 'Admin Area', 'admin', 2),
(4, 'report_magnify.png', 'Knowledge Base', 'support', 3);

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

--
-- Table structure for table `[[dbprefix]]packages`
--

CREATE TABLE `[[dbprefix]]packages` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `backend` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `type` varchar(10) NOT NULL,
  `server` varchar(20) NOT NULL,
  `admin` tinyint(1) NOT NULL,
  `reseller` tinyint(4) NOT NULL,
  `additional` text NOT NULL,
  `order` int(11) NOT NULL DEFAULT '0',
  `is_hidden` int(1) NOT NULL,
  `is_disabled` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]resources`
--

CREATE TABLE `[[dbprefix]]resources` (
  `resource_name` varchar(20) NOT NULL,
  `resource_value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]resources`
--

INSERT INTO `[[dbprefix]]resources` VALUES
('admin_notes', 'Welcome to TheHostingTool!Enjoy this free, open-source web hosting client mangement project! Check out the Credits page on the sidebar menu if you''re interested in becoming involved in the continued development of TheHostingTool. If you need some help, be sure to check out the THT forums and Google Code project page!~ The THT Team');

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

--
-- Table structure for table `[[dbprefix]]servers`
--

CREATE TABLE `[[dbprefix]]servers` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(75) NOT NULL,
  `host` varchar(75) NOT NULL,
  `user` varchar(75) NOT NULL,
  `accesshash` text NOT NULL,
  `type` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]staff`
--

CREATE TABLE `[[dbprefix]]staff` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `user` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `password` text NOT NULL,
  `salt` text NOT NULL,
  `perms` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]staff`
--

INSERT INTO `[[dbprefix]]staff` VALUES
(1, '[[admin_username]]', '[[admin_email]]', '[[admin_realname]]', '[[admin_pass]]', '[[salt]]', '');

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

--
-- Table structure for table `[[dbprefix]]subdomains`
--

CREATE TABLE `[[dbprefix]]subdomains` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `subdomain` varchar(50) NOT NULL,
  `server` varchar(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]supportnav`
--

CREATE TABLE `[[dbprefix]]supportnav` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `visual` varchar(50) NOT NULL,
  `icon` varchar(20) NOT NULL,
  `link` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `[[dbprefix]]supportnav`
--

INSERT INTO `[[dbprefix]]supportnav` VALUES
(1, 'Home', 'house.png', 'home'),
(2, 'Tickets', 'page_white_text.png', 'tickets'),
(3, 'Knowledgebase', 'folder_explore.png', 'kb');

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

--
-- Table structure for table `[[dbprefix]]templates`
--

CREATE TABLE `[[dbprefix]]templates` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `acpvisual` varchar(50) NOT NULL,
  `subject` varchar(250) NOT NULL,
  `content` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `[[dbprefix]]templates`
--

INSERT INTO `[[dbprefix]]templates` VALUES
(1, 'reset', 'Client Reset Password', 'New Password', 'Your password has been reset! New Password: %PASS% Notice! If you didn''t use the forgot password feature, we suggest you log into client area with your new password and use a different email.', 'This is the email a user recieves when they reset their password. Template Variables: %PASS% = Their new password'),
(3, 'newacc', 'New Hosting Account', 'Your Hosting Account', 'Your account has been created! Your account has been successfully created and you''re now able to log into your client control panel and your web hosting control panel. Your details are as follows:Username: %USER% Password: %PASS% Email: %EMAIL% Domain/Subdomain: %DOMAIN% Package: %PACKAGE%', 'This is the email a client gets when they first go though the order form and complete it. This email should contain all their details. They will only receive this email if Email Validation is disabled. Template Variables: %USER% - Client Username %PASS% - Client Password %EMAIL% - Client Email %DOMAIN% - The clients package url %PACKAGE% - The package the client signed up for'),
(4, 'termacc', 'Client Terminated', 'Termination', 'Your account has been terminated! This now means that your client username and password no longer exists. This is the same with your web hosting panel. All your files, databases, records have been removed and aren''t retrievable. Reason for termination: %REASON%', 'This is the email the client recives when their account has been terminated by admin or when they manually deleted it in the client control panel. Email Variables: %REASON% - The reason why their account has been terminated'),
(5, 'suspendacc', 'Suspended Account', 'Suspended', 'Your Account Has Been Suspended! This means that your site on control panel is no longer accessable. Your website and all its content still remain intact. Contact your host for further details.', 'This is the email the client recieves when they''re account has been suspended. '),
(6, 'unsusacc', 'Unsuspended Account', 'Unsuspended', '<div style="color: #000000; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; background-image: initial; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: #ffffff; background-position: initial initial; margin: 8px;">Your Account Has Been Unsuspended! This means that your site on control panel is now accessable. Your website and all its content still remain intact and can be accessed.</div>', 'This is the email a client recieves when their account has been unsuspended.'),
(7, 'newaccadmin', 'Awaiting Validation', 'Awaiting Admin', 'Your account is awaiting admin validation! Your account has been successfully created but you need to wait for an admin to approve your account! You''re now able to log into your client control panel. Your details are as follows:Username:&nbsp;%USER% Password:&nbsp;%PASS% Email:&nbsp;%EMAIL% Domain/Subdomain:&nbsp;%DOMAIN% Package:&nbsp;%PACKAGE%</div>', 'This is the email a client gets when they first go though the order form and complete it but are awaiting the admin. This email should contain all their details. This will only be sent if email confirmation is disabled. Template Variables: %USER% - Client Username %PASS% - Client Password %EMAIL% - Client Email %DOMAIN% - The clients package url %PACKAGE% - The package the client signed up for'),
(8, 'adminval', 'Admin - User Needs Validating', 'User Awaiting Validation', 'A Client Is Awaiting Admin Validation! Log into your ACP now to approve or decline that client.', 'This the email you recieve when a user has signed up to a package requiring admin validation and is awaiting it.'),
(9, 'approvedacc', 'Account Approved', 'Account Approved', 'Your account has now been approved! This means that your account is now active and the details that were sent in your previous email now work. You can proceed to your hosting control panel.', 'This is the email the client recieves when they''re package has been validated by you.'),
(10, 'declinedacc', 'Declined Account', 'Account Declined', 'Your account has been declined! An admin has declined your account. Your record has been deleted from the database. You may try and signup again.', 'This is the email recieved when you decline a account that needs admin validation.'),
(11, 'p2hwarning', 'Post 2 Host - Posts Warning', 'Monthly Posts Warning', 'You haven''t posted enough! You have posted a total of %USERPOSTS%. %MONTHLY% is required for your package!', 'This is the email a client recieves on the 20th of the month if they haven''t posted enough posts to keep their account. Template Variables:%USERPOSTS% - The posts the user has done%MONTHLY% - The posts required'),
(12, 'new ticket', 'Admin - New Ticket', 'New Ticket', 'A Client has posted a new ticket! The ticket is awaiting your staff reply, please look at it ASAP. It''s details: Title:&nbsp;%TITLE% Urgency:&nbsp;%URGENCY% Content:&nbsp;%CONTENT%', 'This is the email all staff members recieve when a ticket has been created. This is supposed to alert you to the ticket. Email Variables: %TITLE% - Ticket Title %CONTENT% - Ticket Content %URGENCY% - Ticket Urgency '),
(13, 'new response', 'Admin - New Ticket Response', 'New Ticket Response', '%USER% has replied to the ticket ''%TITLE%'' and now is awaiting your response! Please look at the ticket ASAP and try to resolve the problem.', 'This email is sent when the CLIENT has replied to a ticket. Ticket Variables: %TITLE% - The response title %CONTENT% - The response %USER% - The user who posted it '),
(14, 'clientresponse', 'New Ticket Response', 'New Ticket Response', '%STAFF% has replied to your ticket! To view this ticket, please login to your support area and check. The title of his response is: %TITLE%', 'This email is sent to the client when they''re ticket has been replied to by a staff member. Ticket Variables: %TITLE% - Reply Title %CONTENT% - Reply Content %STAFF% - Staff Member'),
(15, 'areset', 'Admin Reset Password', 'New ACP Password!', 'Your ACP password has been reset! New Password: %PASS% Notice! If you didn''t use the forgot password feature, we suggest you log into admin CP with your new password and use a different email.', 'This is the email an admin recieves when they reset their password. Template Variables: %PASS% = Their new password'),
(16, 'newinvoice', 'New Invoice', 'New Invoice', 'You have a new unpaid invoice on your account! Make sure you log into your client area (%USER%) and pay the invoice.Invoice Due: %DUE%', 'This is the email a client receives when they''ve got a new unpaid invoice. There are certain variables: %USER% - Username %DUE% - The Invoice Due Date'),
(17, 'cancelacc', 'Account Cancelled', 'Cancelled', 'Your account has been cancelled! This now means that your client username and password no longer work and your web hosting package no longer exists. All your files, databases, records have been removed and aren''t retrievable. Reason for cancellation: %REASON%', 'This is the email the client recives when their account has been cancelled by admin or when they manually cancel it in the client control panel. Email Variables: %REASON% - The reason why their account has been cancelled'),
(18, 'newaccval', 'New Hosting Account + Email Confirmation', 'Your Hosting Account', 'Your account has been created! Your account has been successfully created and you''re now able to log into your client control panel and your web hosting control panel. Your details are as follows:Username: %USER% Password: %PASS% Email: %EMAIL% Domain/Subdomain: %DOMAIN% Package: %PACKAGE% Confirmation Link: <a title="Confirmation Link" href="%CONFIRM%">%CONFIRM%</a>', 'This is the email a client gets when they first go though the order form and complete it. This email should contain all they''re details. They will only receive this email if Email Validation is enabled. Template Variables: %USER% - Client Username %PASS% - Client Password %EMAIL% - Client Email %DOMAIN% - The clients package url %PACKAGE% - The package the client signed up for %CONFIRM% - The confirmation link'),
(19, 'emailconfirm', 'Email Confirmation', 'Please Confirm Your Email', '%USER%, Please confirm the email address associated with your hosting account by clicking the link below.<a href="%CONFIRM%">%CONFIRM%</a>', 'This is the email the user receives if they ask for another confirmation email, they change their email, or an admin requests email verification for that account. Template Variables: %USER% - Client username %CONFIRM% - The confirmation link'),
(20, 'newaccadminval', 'Awaiting Validation + Email Confirmation', 'Awaiting Admin Validation', 'Your account is awaiting admin validation! Your account has been successfully created but you need to wait for an admin to approve your account! You''re now able to log into your client control panel. Your details are as follows:Username:&nbsp;%USER% Password:&nbsp;%PASS% Email:&nbsp;%EMAIL% Domain/Subdomain:&nbsp;%DOMAIN% Package:&nbsp;%PACKAGE% Confirmation Link: <a title="Confirmation Link" href="%CONFIRM%">%CONFIRM%</a>', 'This is the email a client gets when they first go though the order form and complete it but are awaiting the admin. This email should contain all their details. This will only be sent if email confirmation is enabled. Template Variables: %USER% - Client Username %PASS% - Client Password %EMAIL% - Client Email %DOMAIN% - The clients package url %PACKAGE% - The package the client signed up for %CONFIRM% - The confirmation link');

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

--
-- Table structure for table `[[dbprefix]]tickets`
--

CREATE TABLE `[[dbprefix]]tickets` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `urgency` varchar(50) NOT NULL,
  `time` varchar(20) NOT NULL,
  `reply` mediumint(9) NOT NULL,
  `ticketid` mediumint(9) NOT NULL,
  `staff` mediumint(9) NOT NULL,
  `userid` mediumint(9) NOT NULL,
  `status` mediumint(9) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

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

--
-- Table structure for table `[[dbprefix]]types`
--

CREATE TABLE `[[dbprefix]]types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(15) NOT NULL,
  `visual` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `[[dbprefix]]types`
--

INSERT INTO `[[dbprefix]]types` VALUES
(1, 'free', 'Free'),
(2, 'p2h', 'Post2Host'),
(3, 'paid', 'Paid');

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

--
-- Table structure for table `[[dbprefix]]users`
--

CREATE TABLE `[[dbprefix]]users` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `user` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `salt` varchar(50) NOT NULL,
  `signup` varchar(20) NOT NULL,
  `ip` text NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `zip` varchar(7) NOT NULL,
  `state` varchar(55) NOT NULL,
  `country` varchar(2) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT '0',
  `emailval` tinyint(1) NOT NULL DEFAULT '0',
  `confirmcode` varchar(40) DEFAULT NULL,
  `newemail` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]users_bak`
--

CREATE TABLE `[[dbprefix]]users_bak` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `user` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `salt` varchar(50) NOT NULL,
  `signup` varchar(20) NOT NULL,
  `ip` text NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `zip` varchar(7) NOT NULL,
  `state` varchar(55) NOT NULL,
  `country` varchar(2) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]user_packs`
--

CREATE TABLE `[[dbprefix]]user_packs` (
  `id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
  `userid` mediumint(9) unsigned NOT NULL,
  `username` varchar(50) NOT NULL,
  `domain` varchar(50) NOT NULL,
  `pid` varchar(5) NOT NULL,
  `signup` varchar(20) NOT NULL,
  `status` varchar(1) NOT NULL,
  `additional` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]user_packs_bak`
--

CREATE TABLE `[[dbprefix]]user_packs_bak` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `userid` varchar(5) NOT NULL,
  `username` varchar(50) NOT NULL,
  `domain` varchar(50) NOT NULL,
  `pid` varchar(5) NOT NULL,
  `signup` varchar(20) NOT NULL,
  `status` varchar(1) NOT NULL,
  `additional` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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: `soft_tht126` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]acpnav` -- CREATE TABLE `[[dbprefix]]acpnav` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `visual` varchar(20) NOT NULL, `icon` varchar(50) NOT NULL, `link` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ; -- -- Dumping data for table `[[dbprefix]]acpnav` -- INSERT INTO `[[dbprefix]]acpnav` VALUES (1, 'Home', 'house.png', 'home'), (2, 'General Settings', 'cog.png', 'settings'), (3, 'Servers', 'server.png', 'servers'), (4, 'Packages', 'package_green.png', 'packages'), (5, 'Staff Accounts', 'user_gray.png', 'staff'), (6, 'Subdomains', 'link.png', 'sub'), (7, 'Clients', 'group.png', 'users'), (8, 'Change Password', 'shield.png', 'pass'), (9, 'Server Status', 'computer.png', 'status'), (10, 'Mail Center', 'email_open.png', 'email'), (12, 'Client Importer', 'user_orange.png', 'import'), (13, 'Tickets', 'page_white_text.png', 'tickets'), (14, 'Knowledge Base', 'folder.png', 'kb'), (15, 'Look & Feel', 'rainbow.png', 'lof'), (19, 'Invoice Management', 'script.png', 'invoices'), (20, 'Logs', 'report.png', 'logs'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]articles` -- CREATE TABLE `[[dbprefix]]articles` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `catid` mediumint(9) NOT NULL, `name` varchar(100) NOT NULL, `content` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]cats` -- CREATE TABLE `[[dbprefix]]cats` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `description` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]clientnav` -- CREATE TABLE `[[dbprefix]]clientnav` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `visual` varchar(20) NOT NULL, `icon` varchar(50) NOT NULL, `link` varchar(20) NOT NULL, `weight` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; -- -- Dumping data for table `[[dbprefix]]clientnav` -- INSERT INTO `[[dbprefix]]clientnav` VALUES (1, 'Home', 'house.png', 'home', -100), (3, 'Announcements', 'bell.png', 'notices', 1), (4, 'View Package', 'package.png', 'view', 15), (5, 'Edit Details', 'user_edit.png', 'details', 30), (2, 'Delete Account', 'cross.png', 'delete', 100), (7, 'Invoices', 'script.png', 'invoices', 45), (8, 'Tickets', 'page_white_text.png', 'tickets', 60), (9, 'Change Email', 'email_edit.png', 'email', 31); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]config` -- CREATE TABLE `[[dbprefix]]config` ( `name` varchar(50) NOT NULL, `value` text NOT NULL, PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]config` -- INSERT INTO `[[dbprefix]]config` VALUES ('url', '[[softurl]]/'), ('vname', '1.2.6'), ('vcode', '1010206'), ('whm-ssl', '1'), ('paypalemail', 'your@email.com'), ('default', 'order'), ('theme', 'Reloaded2'), ('name', '[[site_name]]'), ('tos', '

The following content is prohibited on our servers:

Illegal use
Threatening Material
Fraudulent Content
Forgery or Impersonation
Unsolicited Content
Copyright Infringements
Collection of Private Date (Unless DPA Registered)
Viruses
IRC Networks (Including all IRC Material)
Peer to Peer software
Any Adult Content
Non-english Content

'), ('multiple', '1'), ('general', '1'), ('message', '

Signups are currently disabled. Contact your host for more information.

'), ('delacc', '1'), ('cenabled', '1'), ('cmessage', '

Client area isn''t enabled. Sorry, contact your host for more details.

'), ('emailmethod', 'php'), ('emailfrom', '[[admin_email]]'), ('smtp_host', 'localhost'), ('smtp_user', 'user'), ('smtp_password', 'password'), ('show_version_id', '1'), ('show_acp_menu', '0'), ('show_page_gentime', '1'), ('alerts', '

'), ('p2hcheck', ''), ('show_footer', '0'), ('senabled', '1'), ('smessage', '

Support area isn''t enabled. Sorry, contact your host for more details.

'), ('terminationdays', '14'), ('suspensiondays', '14'), ('tldonly', '0'), ('currency', 'USD'), ('ui-theme', 'cupertino'), ('timezone', 'UTC'), ('wwwsubdomain', 'both'), ('emailval', '1'), ('smtp_port', '25'), ('smtp_secure', '0'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]invoices` -- CREATE TABLE `[[dbprefix]]invoices` ( `id` int(255) NOT NULL AUTO_INCREMENT, `uid` int(255) NOT NULL, `amount` varchar(20) NOT NULL, `is_paid` int(1) NOT NULL DEFAULT '0', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `due` text NOT NULL, `is_suspended` int(1) NOT NULL DEFAULT '0', `notes` text NOT NULL, `uniqueid` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]logs` -- CREATE TABLE `[[dbprefix]]logs` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `uid` varchar(5) NOT NULL, `loguser` varchar(50) NOT NULL, `logtime` varchar(20) NOT NULL, `message` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]navbar` -- CREATE TABLE `[[dbprefix]]navbar` ( `id` smallint(6) NOT NULL AUTO_INCREMENT, `icon` varchar(20) NOT NULL, `visual` varchar(70) NOT NULL, `link` varchar(20) NOT NULL, `order` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ; -- -- Dumping data for table `[[dbprefix]]navbar` -- INSERT INTO `[[dbprefix]]navbar` VALUES (1, 'cart.png', 'Order Form', 'order', 1), (2, 'user.png', 'Client Area', 'client', 0), (3, 'key.png', 'Admin Area', 'admin', 2), (4, 'report_magnify.png', 'Knowledge Base', 'support', 3); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]packages` -- CREATE TABLE `[[dbprefix]]packages` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `backend` varchar(50) NOT NULL, `description` text NOT NULL, `type` varchar(10) NOT NULL, `server` varchar(20) NOT NULL, `admin` tinyint(1) NOT NULL, `reseller` tinyint(4) NOT NULL, `additional` text NOT NULL, `order` int(11) NOT NULL DEFAULT '0', `is_hidden` int(1) NOT NULL, `is_disabled` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]resources` -- CREATE TABLE `[[dbprefix]]resources` ( `resource_name` varchar(20) NOT NULL, `resource_value` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `[[dbprefix]]resources` -- INSERT INTO `[[dbprefix]]resources` VALUES ('admin_notes', '

Welcome to TheHostingTool!

Enjoy this free, open-source web hosting client mangement project! Check out the Credits page on the sidebar menu if you''re interested in becoming involved in the continued development of TheHostingTool. If you need some help, be sure to check out the THT forums and Google Code project page!

~ The THT Team

'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]servers` -- CREATE TABLE `[[dbprefix]]servers` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `name` varchar(75) NOT NULL, `host` varchar(75) NOT NULL, `user` varchar(75) NOT NULL, `accesshash` text NOT NULL, `type` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]staff` -- CREATE TABLE `[[dbprefix]]staff` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `user` varchar(20) NOT NULL, `email` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `password` text NOT NULL, `salt` text NOT NULL, `perms` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]staff` -- INSERT INTO `[[dbprefix]]staff` VALUES (1, '[[admin_username]]', '[[admin_email]]', '[[admin_realname]]', '[[admin_pass]]', '[[salt]]', ''); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]subdomains` -- CREATE TABLE `[[dbprefix]]subdomains` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `subdomain` varchar(50) NOT NULL, `server` varchar(5) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]supportnav` -- CREATE TABLE `[[dbprefix]]supportnav` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `visual` varchar(50) NOT NULL, `icon` varchar(20) NOT NULL, `link` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]supportnav` -- INSERT INTO `[[dbprefix]]supportnav` VALUES (1, 'Home', 'house.png', 'home'), (2, 'Tickets', 'page_white_text.png', 'tickets'), (3, 'Knowledgebase', 'folder_explore.png', 'kb'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]templates` -- CREATE TABLE `[[dbprefix]]templates` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `acpvisual` varchar(50) NOT NULL, `subject` varchar(250) NOT NULL, `content` text NOT NULL, `description` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ; -- -- Dumping data for table `[[dbprefix]]templates` -- INSERT INTO `[[dbprefix]]templates` VALUES (1, 'reset', 'Client Reset Password', 'New Password', '

Your password has been reset!
New Password: %PASS%

Notice!
If you didn''t use the forgot password feature, we suggest you log into client area with your new password and use a different email.

', 'This is the email a user recieves when they reset their password.

Template Variables:
%PASS% = Their new password'), (3, 'newacc', 'New Hosting Account', 'Your Hosting Account', '

Your account has been created!
Your account has been successfully created and you''re now able to log into your client control panel and your web hosting control panel. Your details are as follows:

Username: %USER%
Password: %PASS%
Email: %EMAIL%
Domain/Subdomain: %DOMAIN%
Package: %PACKAGE%

', 'This is the email a client gets when they first go though the order form and complete it. This email should contain all their details. They will only receive this email if Email Validation is disabled.

Template Variables:
%USER% - Client Username
%PASS% - Client Password
%EMAIL% - Client Email
%DOMAIN% - The clients package url
%PACKAGE% - The package the client signed up for'), (4, 'termacc', 'Client Terminated', 'Termination', '

Your account has been terminated!
This now means that your client username and password no longer exists. This is the same with your web hosting panel. All your files, databases, records have been removed and aren''t retrievable.

Reason for termination: %REASON%

', 'This is the email the client recives when their account has been terminated by admin or when they manually deleted it in the client control panel.

Email Variables:
%REASON% - The reason why their account has been terminated'), (5, 'suspendacc', 'Suspended Account', 'Suspended', '

Your Account Has Been Suspended!
This means that your site on control panel is no longer accessable. Your website and all its content still remain intact. Contact your host for further details.

', 'This is the email the client recieves when they''re account has been suspended. '), (6, 'unsusacc', 'Unsuspended Account', 'Unsuspended', '

Your Account Has Been Unsuspended!
This means that your site on control panel is now accessable. Your website and all its content still remain intact and can be accessed.

', 'This is the email a client recieves when their account has been unsuspended.'), (7, 'newaccadmin', 'Awaiting Validation', 'Awaiting Admin', '

Your account is awaiting admin validation!
Your account has been successfully created but you need to wait for an admin to approve your account! You''re now able to log into your client control panel. Your details are as follows:

Username: %USER%
Password: %PASS%
Email: %EMAIL%
Domain/Subdomain: %DOMAIN%
Package: %PACKAGE%

A Client Is Awaiting Admin Validation!
Log into your ACP now to approve or decline that client.

Your account has now been approved!
This means that your account is now active and the details that were sent in your previous email now work. You can proceed to your hosting control panel.

Your account has been declined!
An admin has declined your account. Your record has been deleted from the database. You may try and signup again.

You haven''t posted enough!
You have posted a total of %USERPOSTS%. %MONTHLY% is required for your package!

A Client has posted a new ticket!
The ticket is awaiting your staff reply, please look at it ASAP. It''s details:

Title: %TITLE%
Urgency: %URGENCY%
Content: %CONTENT%

%USER% has replied to the ticket ''%TITLE%'' and now is awaiting your response!
Please look at the ticket ASAP and try to resolve the problem.

%STAFF% has replied to your ticket!
To view this ticket, please login to your support area and check. The title of his response is: %TITLE%

Your ACP password has been reset!
New Password: %PASS%

Notice!
If you didn''t use the forgot password feature, we suggest you log into admin CP with your new password and use a different email.

You have a new unpaid invoice on your account!
Make sure you log into your client area (%USER%) and pay the invoice.

Your account has been cancelled!
This now means that your client username and password no longer work and your web hosting package no longer exists. All your files, databases, records have been removed and aren''t retrievable.

Reason for cancellation: %REASON%

Your account has been created!
Your account has been successfully created and you''re now able to log into your client control panel and your web hosting control panel. Your details are as follows:

Username: %USER%
Password: %PASS%
Email: %EMAIL%
Domain/Subdomain: %DOMAIN%
Package: %PACKAGE%
Confirmation Link: %CONFIRM%

%USER%,
Please confirm the email address associated with your hosting account by clicking the link below.

Username: %USER%
Password: %PASS%
Email: %EMAIL%
Domain/Subdomain: %DOMAIN%
Package: %PACKAGE%
Confirmation Link: %CONFIRM%', 'This is the email a client gets when they first go though the order form and complete it but are awaiting the admin. This email should contain all their details. This will only be sent if email confirmation is enabled.

Template Variables:
%USER% - Client Username
%PASS% - Client Password
%EMAIL% - Client Email
%DOMAIN% - The clients package url
%PACKAGE% - The package the client signed up for
%CONFIRM% - The confirmation link'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tickets` -- CREATE TABLE `[[dbprefix]]tickets` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `content` text NOT NULL, `urgency` varchar(50) NOT NULL, `time` varchar(20) NOT NULL, `reply` mediumint(9) NOT NULL, `ticketid` mediumint(9) NOT NULL, `staff` mediumint(9) NOT NULL, `userid` mediumint(9) NOT NULL, `status` mediumint(9) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]types` -- CREATE TABLE `[[dbprefix]]types` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(15) NOT NULL, `visual` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]types` -- INSERT INTO `[[dbprefix]]types` VALUES (1, 'free', 'Free'), (2, 'p2h', 'Post2Host'), (3, 'paid', 'Paid'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]users` -- CREATE TABLE `[[dbprefix]]users` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `user` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `salt` varchar(50) NOT NULL, `signup` varchar(20) NOT NULL, `ip` text NOT NULL, `firstname` varchar(50) NOT NULL, `lastname` varchar(50) NOT NULL, `address` varchar(50) NOT NULL, `city` varchar(50) NOT NULL, `zip` varchar(7) NOT NULL, `state` varchar(55) NOT NULL, `country` varchar(2) NOT NULL, `phone` varchar(15) NOT NULL, `status` varchar(1) NOT NULL DEFAULT '0', `emailval` tinyint(1) NOT NULL DEFAULT '0', `confirmcode` varchar(40) DEFAULT NULL, `newemail` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]users_bak` -- CREATE TABLE `[[dbprefix]]users_bak` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `user` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `salt` varchar(50) NOT NULL, `signup` varchar(20) NOT NULL, `ip` text NOT NULL, `firstname` varchar(50) NOT NULL, `lastname` varchar(50) NOT NULL, `address` varchar(50) NOT NULL, `city` varchar(50) NOT NULL, `zip` varchar(7) NOT NULL, `state` varchar(55) NOT NULL, `country` varchar(2) NOT NULL, `phone` varchar(15) NOT NULL, `status` varchar(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_packs` -- CREATE TABLE `[[dbprefix]]user_packs` ( `id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT, `userid` mediumint(9) unsigned NOT NULL, `username` varchar(50) NOT NULL, `domain` varchar(50) NOT NULL, `pid` varchar(5) NOT NULL, `signup` varchar(20) NOT NULL, `status` varchar(1) NOT NULL, `additional` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_packs_bak` -- CREATE TABLE `[[dbprefix]]user_packs_bak` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `userid` varchar(5) NOT NULL, `username` varchar(50) NOT NULL, `domain` varchar(50) NOT NULL, `pid` varchar(5) NOT NULL, `signup` varchar(20) NOT NULL, `status` varchar(1) NOT NULL, `additional` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;