-- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 06, 2006 at 06:43 PM -- Server version: 4.0.27 -- PHP Version: 4.3.11 -- -- Database: `quicklyw_cwispy` -- -- -------------------------------------------------------- -- -- Table structure for table `Accounts` -- DROP TABLE IF EXISTS `Accounts`; CREATE TABLE IF NOT EXISTS `Accounts` ( `AccountID` int(10) unsigned NOT NULL auto_increment, `CustomerID` int(10) unsigned default NULL, `Username` varchar(50) default NULL, `Password` varchar(50) default NULL, `DateOpened` date default NULL, `DateClosed` date default NULL, `Status` varchar(25) default NULL, `PackageGroupID` int(10) unsigned default NULL, `Domain` varchar(125) default NULL, `LastDateBilled` date default NULL, `NextDateBilled` date default NULL, `Price` float(4,2) NOT NULL default '0.00', PRIMARY KEY (`AccountID`), UNIQUE KEY `AccountID` (`AccountID`) ) TYPE=InnoDB AUTO_INCREMENT=108 ; -- -------------------------------------------------------- -- -- Table structure for table `Balance` -- DROP TABLE IF EXISTS `Balance`; CREATE TABLE IF NOT EXISTS `Balance` ( `balanceID` int(11) unsigned NOT NULL auto_increment, `InvoiceID` int(11) NOT NULL default '0', `PaymentID` int(11) NOT NULL default '0', KEY `CustomerID` (`balanceID`) ) TYPE=InnoDB COMMENT='Links payments to Invoices and vice versa' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `BillInterval` -- DROP TABLE IF EXISTS `BillInterval`; CREATE TABLE IF NOT EXISTS `BillInterval` ( `BillIntervalID` int(10) unsigned NOT NULL auto_increment, `Description` text, `Year` int(10) unsigned default NULL, `Month` int(10) unsigned default NULL, `Day` int(10) unsigned default NULL, PRIMARY KEY (`BillIntervalID`) ) TYPE=InnoDB AUTO_INCREMENT=8 ; -- -- Dumping data for table `BillInterval` -- INSERT INTO `BillInterval` (`BillIntervalID`, `Description`, `Year`, `Month`, `Day`) VALUES (2, 'Bi Monthly', 0, 2, 0); INSERT INTO `BillInterval` (`BillIntervalID`, `Description`, `Year`, `Month`, `Day`) VALUES (3, 'Half Yearly', 0, 6, 0); INSERT INTO `BillInterval` (`BillIntervalID`, `Description`, `Year`, `Month`, `Day`) VALUES (4, 'Bi Yearly', 2, 0, 0); INSERT INTO `BillInterval` (`BillIntervalID`, `Description`, `Year`, `Month`, `Day`) VALUES (5, 'monthly', 0, 1, 0); INSERT INTO `BillInterval` (`BillIntervalID`, `Description`, `Year`, `Month`, `Day`) VALUES (6, 'quarterly', 0, 3, 0); INSERT INTO `BillInterval` (`BillIntervalID`, `Description`, `Year`, `Month`, `Day`) VALUES (7, 'annually', 1, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `BillingInfo` -- DROP TABLE IF EXISTS `BillingInfo`; CREATE TABLE IF NOT EXISTS `BillingInfo` ( `BillTypeID` int(10) unsigned NOT NULL auto_increment, `BillName` varchar(100) default NULL, `Header` text, `Footer` text, `EmailBillHeader` text, `EmailBillFooter` text, `StatementHeader` text, `StatementFooter` text, `BillFromPerson` varchar(60) default NULL, `BillFromAddress` varchar(100) default NULL, `BillReplyAddress` varchar(100) default NULL, `BillSubject` varchar(100) default NULL, `BillBcc` varchar(100) default NULL, `PaymentSubject` varchar(50) default NULL, `PaymentHeader` text, `PaymentFooter` text, `StatementSubject` varchar(50) default NULL, `FrontEndUrl` varchar(100) default NULL, `Subject` varchar(50) default NULL, PRIMARY KEY (`BillTypeID`) ) TYPE=InnoDB AUTO_INCREMENT=3 ; -- -- Dumping data for table `BillingInfo` -- INSERT INTO `BillingInfo` (`BillTypeID`, `BillName`, `Header`, `Footer`, `EmailBillHeader`, `EmailBillFooter`, `StatementHeader`, `StatementFooter`, `BillFromPerson`, `BillFromAddress`, `BillReplyAddress`, `BillSubject`, `BillBcc`, `PaymentSubject`, `PaymentHeader`, `PaymentFooter`, `StatementSubject`, `FrontEndUrl`, `Subject`) VALUES (2, 'QUICKLYWEB', '\r\n\r\n\r\nQuicklyweb Invoice\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

INVOICE


\r\n', '\r\n\r\n

Payable Upon Receipt.

\r\n

Please make the checks payable to Mr M. Anur and reference the invoice number.

\r\n\r\n\r\n', '======================= INVOICE ======================= \r\nQUICKLYWEB ENTERPRISES Tel : +44 08707740286\r\n51 Brigstock Road Fax : +44 08707740286\r\nThorton Heath, Surrey, CR7 7JH billing@quicklyweb.co.uk\r\nUnited Kingdom \r\n============================================================', '======================= THANK YOU ========================\r\nTo view or print a HTML version of this invoice go to\r\nhttp://www.quicklyweb.co.uk/account/\r\nYou will need your account ID and your password to login to\r\nthe system. If you do not have this, please contact support.\r\nYou can pay for this invoice trough nochex by using following link\r\nhttp://www.nochex.com/payme.asap?email=nochex@quicklyshop.com\r\n ', '======================= STATEMENT ======================= \r\nQUICKLYWEB ENTERPRISES Tel : +44 08707740286\r\n51 Brigstock Road Fax : +44 08707740286\r\nThorton Heath, Surrey, CR7 7JH billing@quicklyweb.co.uk\r\nUnited Kingdom \r\n============================================================', '======================= THANK YOU ========================', 'Billing @ QUICKLYWEB', 'billing@quicklyweb.co.uk', 'shane@2000cn.com.au', 'Quicklyweb Invoice', 'cwispy@cwispy.com', 'Payment Received', '======================= RECEIPT ======================= \r\nQUICKLYWEB ENTERPRISES Tel : +44 08707740286\r\n51 Brigstock Road Fax : +44 08707740286\r\nThorton Heath, Surrey, CR7 7JH billing@quicklyweb.co.uk\r\nUnited Kingdom \r\n\r\n============================================================', '======================= THANK YOU ========================', 'Monthly Statement', 'http://www.cwispy.com/gcdb', '2000 Computers & Networks Invoice -'); -- -------------------------------------------------------- -- -- Table structure for table `CompanyInformation` -- DROP TABLE IF EXISTS `CompanyInformation`; CREATE TABLE IF NOT EXISTS `CompanyInformation` ( `id` tinyint(3) unsigned NOT NULL auto_increment, `CompanyName` varchar(100) default NULL, `Address1` varchar(255) default NULL, `Address2` varchar(255) default NULL, `Suburb` varchar(100) default NULL, `State` varchar(50) default NULL, `Zip` varchar(10) default NULL, `Country` varchar(50) default NULL, `Phone` varchar(16) default NULL, `Fax` varchar(16) default NULL, `Web` varchar(100) default NULL, `Email` varchar(100) default NULL, `CompanyNumber` varchar(50) default NULL, UNIQUE KEY `id` (`id`), KEY `id_2` (`id`) ) TYPE=InnoDB AUTO_INCREMENT=2 ; -- -- Dumping data for table `CompanyInformation` -- INSERT INTO `CompanyInformation` (`id`, `CompanyName`, `Address1`, `Address2`, `Suburb`, `State`, `Zip`, `Country`, `Phone`, `Fax`, `Web`, `Email`, `CompanyNumber`) VALUES (1, 'QUICKLYWEB', '51 Brigstock Road', '', 'Thorton Heath', 'Surrey', 'CR7 7JH', 'United Kingdom', '+44(0)2086832252', '', 'http://www.quicklyweb.co.uk', 'sales@quicklyweb.co.uk', ''); -- -------------------------------------------------------- -- -- Table structure for table `Configuration` -- DROP TABLE IF EXISTS `Configuration`; CREATE TABLE IF NOT EXISTS `Configuration` ( `LoginLang` varchar(50) default NULL, `Name` varchar(100) default NULL, `State` varchar(25) default NULL, `Country` varchar(50) default NULL, `SmtpServer` varchar(100) default NULL, `TicketNotifier` varchar(100) default NULL ) TYPE=InnoDB; -- -- Dumping data for table `Configuration` -- INSERT INTO `Configuration` (`LoginLang`, `Name`, `State`, `Country`, `SmtpServer`, `TicketNotifier`) VALUES ('english.php', '2000cn', 'England', 'United Kingdom', 'localhost', 'on'); -- -------------------------------------------------------- -- -- Table structure for table `Contacts` -- DROP TABLE IF EXISTS `Contacts`; CREATE TABLE IF NOT EXISTS `Contacts` ( `ContactID` int(10) unsigned NOT NULL auto_increment, `CustomerID` int(10) unsigned default NULL, `First` varchar(30) default NULL, `Mid` char(1) default NULL, `Last` varchar(40) default NULL, `Phone` varchar(16) default NULL, `Mobile` varchar(16) default NULL, `Email` varchar(100) default NULL, `Notes` varchar(80) default NULL, PRIMARY KEY (`ContactID`), UNIQUE KEY `ContactID` (`ContactID`) ) TYPE=InnoDB AUTO_INCREMENT=1 ; -- -- Dumping data for table `Contacts` -- -- -------------------------------------------------------- -- -- Table structure for table `Customers` -- DROP TABLE IF EXISTS `Customers`; CREATE TABLE IF NOT EXISTS `Customers` ( `CustomerID` int(10) unsigned NOT NULL auto_increment, `BillTypeID` int(10) unsigned NOT NULL default '0', `First` varchar(30) default NULL, `Mid` char(1) default NULL, `Last` varchar(40) default NULL, `Address` varchar(255) default NULL, `Telephone` varchar(16) default NULL, `Fax` varchar(16) default NULL, `Mobile` varchar(16) default NULL, `Email` varchar(100) default NULL, `City` varchar(50) default NULL, `State` varchar(50) default NULL, `Zip` varchar(10) default NULL, `TaxID` int(10) default NULL, `Balance` float(10,2) default NULL, `CCNumber` varchar(20) default NULL, `CCName` varchar(80) default NULL, `Username` varchar(20) NOT NULL default '', `Password` varchar(20) default NULL, `Company` varchar(100) default NULL, `CCExpire` varchar(10) default NULL, `CCMonth` double default NULL, `Country` varchar(100) default NULL, `Overdraft` float(10,2) default NULL, `Closed` enum('Open','Closed') default 'Open', PRIMARY KEY (`CustomerID`), UNIQUE KEY `id` (`CustomerID`) ) TYPE=InnoDB AUTO_INCREMENT=60 ; -- -- Table structure for table `DomainGroup` -- DROP TABLE IF EXISTS `DomainGroup`; CREATE TABLE IF NOT EXISTS `DomainGroup` ( `DomainGroupID` int(10) NOT NULL auto_increment, `tld` varchar(10) NOT NULL default '', `MinimumPeriod` int(10) NOT NULL default '0', `MaximumPeriod` int(10) NOT NULL default '0', `Price` float(4,2) NOT NULL default '0.00', KEY `DomainGroupID` (`DomainGroupID`) ) TYPE=MyISAM AUTO_INCREMENT=12 ; -- -- Dumping data for table `DomainGroup` -- INSERT INTO `DomainGroup` (`DomainGroupID`, `tld`, `MinimumPeriod`, `MaximumPeriod`, `Price`) VALUES (1, '.com', 1, 10, 6.79); INSERT INTO `DomainGroup` (`DomainGroupID`, `tld`, `MinimumPeriod`, `MaximumPeriod`, `Price`) VALUES (5, '.net', 1, 10, 6.79); INSERT INTO `DomainGroup` (`DomainGroupID`, `tld`, `MinimumPeriod`, `MaximumPeriod`, `Price`) VALUES (6, '.org', 1, 10, 6.79); INSERT INTO `DomainGroup` (`DomainGroupID`, `tld`, `MinimumPeriod`, `MaximumPeriod`, `Price`) VALUES (7, '.co.uk', 2, 10, 3.99); INSERT INTO `DomainGroup` (`DomainGroupID`, `tld`, `MinimumPeriod`, `MaximumPeriod`, `Price`) VALUES (8, '.me.uk', 2, 10, 3.99); INSERT INTO `DomainGroup` (`DomainGroupID`, `tld`, `MinimumPeriod`, `MaximumPeriod`, `Price`) VALUES (9, '.org.uk', 2, 10, 3.99); INSERT INTO `DomainGroup` (`DomainGroupID`, `tld`, `MinimumPeriod`, `MaximumPeriod`, `Price`) VALUES (10, '.info', 1, 10, 6.79); INSERT INTO `DomainGroup` (`DomainGroupID`, `tld`, `MinimumPeriod`, `MaximumPeriod`, `Price`) VALUES (11, '.biz', 1, 10, 6.79); -- -------------------------------------------------------- -- -- Table structure for table `Domains` -- DROP TABLE IF EXISTS `Domains`; CREATE TABLE IF NOT EXISTS `Domains` ( `DomainID` int(10) unsigned default NULL, `CustomerID` int(10) NOT NULL default '0', `DomainGroupID` int(10) NOT NULL default '0', `Domain` varchar(125) default NULL, `Registered_on` date NOT NULL default '0000-00-00', `Renewal_date` date NOT NULL default '0000-00-00', `Last_updated` date NOT NULL default '0000-00-00', `Status` enum('PENDING','OPEN','CLOSE','SUSPENDED') NOT NULL default 'PENDING', `ns1` varchar(255) NOT NULL default '', `ip1` varchar(255) NOT NULL default '', `ns2` varchar(255) NOT NULL default '', `ip2` varchar(255) NOT NULL default '' ) TYPE=InnoDB; -- -- Dumping data for table `Domains` -- -- -------------------------------------------------------- -- -- Table structure for table `Forum_Categories` -- DROP TABLE IF EXISTS `Forum_Categories`; CREATE TABLE IF NOT EXISTS `Forum_Categories` ( `CategoryID` int(10) NOT NULL auto_increment, `MainCategoryID` int(10) NOT NULL default '0', `CategoryName` varchar(255) NOT NULL default '', `CategoryDescription` varchar(255) NOT NULL default '', UNIQUE KEY `CategoryID` (`CategoryID`) ) TYPE=MyISAM AUTO_INCREMENT=23 ; -- -- Dumping data for table `Forum_Categories` -- INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (1, 0, 'Automotive', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (2, 0, 'Business & Entrepreneurs', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (3, 0, 'Campus Life', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (4, 0, 'Career Center', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (5, 0, 'Comedy', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (6, 0, 'Computers & Technology', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (7, 0, 'Culture, Arts & Literature', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (8, 0, 'Filmmakers', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (9, 0, 'Food & Drink', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (10, 0, 'Games', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (11, 0, 'General Discussion', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (12, 0, 'Health & Fitness', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (13, 0, 'Love & Relationships', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (14, 0, 'Movies', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (15, 0, 'Music', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (16, 0, 'Quicklyweb', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (17, 0, 'News & Politics', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (18, 0, 'Religion & Philosophy', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (19, 0, 'Science', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (20, 0, 'Sports', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (21, 0, 'Television', ''); INSERT INTO `Forum_Categories` (`CategoryID`, `MainCategoryID`, `CategoryName`, `CategoryDescription`) VALUES (22, 0, 'Travel & Vacations', ''); -- -------------------------------------------------------- -- -- Table structure for table `Forum_Posts` -- DROP TABLE IF EXISTS `Forum_Posts`; CREATE TABLE IF NOT EXISTS `Forum_Posts` ( `PostID` int(255) NOT NULL auto_increment, `MainPostID` int(255) NOT NULL default '0', `CategoryID` int(255) NOT NULL default '0', `UserID` varchar(255) NOT NULL default '', `PostTitle` varchar(255) NOT NULL default '', `PostDescription` text NOT NULL, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', `Status` varchar(255) NOT NULL default '', UNIQUE KEY `PostID` (`PostID`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; -- -- Dumping data for table `Forum_Posts` -- INSERT INTO `Forum_Posts` (`PostID`, `MainPostID`, `CategoryID`, `UserID`, `PostTitle`, `PostDescription`, `DatePosted`, `Status`) VALUES (1, 0, 16, 'test', 'Testing the forum', 'Well clet se how the forum works', '2006-06-12 00:28:00', ''); INSERT INTO `Forum_Posts` (`PostID`, `MainPostID`, `CategoryID`, `UserID`, `PostTitle`, `PostDescription`, `DatePosted`, `Status`) VALUES (2, 0, 16, 'test', 'Testing the forum again', 'Well let see how this will work out', '2006-06-12 00:52:00', ''); -- -------------------------------------------------------- -- -- Table structure for table `InvoiceItems` -- DROP TABLE IF EXISTS `InvoiceItems`; CREATE TABLE IF NOT EXISTS `InvoiceItems` ( `ItemID` int(10) unsigned NOT NULL auto_increment, `InvoiceID` int(10) default NULL, `Description` text, `Amount` float(10,2) default NULL, `Taxes` float(10,2) default NULL, PRIMARY KEY (`ItemID`), UNIQUE KEY `ItemID` (`ItemID`), KEY `ItemID_2` (`ItemID`) ) TYPE=InnoDB COMMENT='items are related to one invoice in the invoice table' AUTO_INCREMENT=408 ; -- -- Table structure for table `Invoices` -- DROP TABLE IF EXISTS `Invoices`; CREATE TABLE IF NOT EXISTS `Invoices` ( `InvoiceID` int(10) unsigned NOT NULL auto_increment, `CustomerID` int(10) unsigned default NULL, `DateBilled` date default NULL, `Status` enum('Open','Part','Closed') default 'Open', `Sent` enum('Yes','No') default 'No', PRIMARY KEY (`InvoiceID`), UNIQUE KEY `InvoiceID` (`InvoiceID`) ) TYPE=InnoDB COMMENT='Invoice table' AUTO_INCREMENT=1840 ; -- -- Table structure for table `Items` -- DROP TABLE IF EXISTS `Items`; CREATE TABLE IF NOT EXISTS `Items` ( `ItemID` int(11) unsigned NOT NULL auto_increment, `Name` varchar(50) default NULL, `Length` int(11) unsigned default NULL, PRIMARY KEY (`ItemID`), UNIQUE KEY `ItemID` (`ItemID`), KEY `ItemID_2` (`ItemID`) ) TYPE=InnoDB AUTO_INCREMENT=4 ; -- -- Dumping data for table `Items` -- INSERT INTO `Items` (`ItemID`, `Name`, `Length`) VALUES (1, 'UserName', 18); INSERT INTO `Items` (`ItemID`, `Name`, `Length`) VALUES (2, 'Password', 18); INSERT INTO `Items` (`ItemID`, `Name`, `Length`) VALUES (3, 'Email', 100); -- -------------------------------------------------------- -- -- Table structure for table `News` -- DROP TABLE IF EXISTS `News`; CREATE TABLE IF NOT EXISTS `News` ( `NewsID` int(10) unsigned NOT NULL auto_increment, `Title` varchar(255) default NULL, `Content` text, `PostedDate` date default NULL, `Poster` varchar(50) default NULL, PRIMARY KEY (`NewsID`), UNIQUE KEY `NewsID` (`NewsID`) ) TYPE=InnoDB AUTO_INCREMENT=4 ; -- -- Dumping data for table `News` -- INSERT INTO `News` (`NewsID`, `Title`, `Content`, `PostedDate`, `Poster`) VALUES (1, 'PAY AS YOU GO dial up service', 'We are proud to announce our new dial up service.\r\nIf you are on the go or away and need to get online; this service is for you. PAY AS YOU GO Dial Up service. All you need is below information to get you online.\r\n

\r\n - DIAL-UP NUMBER: 0845 123 2064
\r\n - DIAL-UP USERNAME: quicklyweb
\r\n - DIAL-UP PASSWORD: (Use any password)
\r\n - SMTP ADDRESS: smtp.usermail.co.uk

\r\n\r\nCall charges are standard BT call rates for 0845 local calls.

\r\nWeekday calls between 8am and 6pm : 3.95 pence per minute
\r\nWeekday evening calls between 6pm and 8am : 1.48 pence per minute
\r\nWeekend calls between midnight Friday and midnight Monday : 1 pence per minute \r\n', '2005-08-17', ''); INSERT INTO `News` (`NewsID`, `Title`, `Content`, `PostedDate`, `Poster`) VALUES (2, 'Better Support Desk', 'We did improve our Support Desk System. Now you can close the tickets which has been solved. Please report any problem or bug on account section trough Support Desk.', '2006-03-29', ''); INSERT INTO `News` (`NewsID`, `Title`, `Content`, `PostedDate`, `Poster`) VALUES (3, 'Paypal Payments', 'Due to high demand from users we now accept \r\nPAYPAL as payment method as well as 2Checkout, \r\nNochex, Credit/Debit Cards and Cheque \r\npayments ', '2006-07-08', ''); -- -------------------------------------------------------- -- -- Table structure for table `Notes` -- DROP TABLE IF EXISTS `Notes`; CREATE TABLE IF NOT EXISTS `Notes` ( `NoteID` int(10) unsigned NOT NULL auto_increment, `Note` varchar(255) default NULL, `PostedDate` date default NULL, `Poster` varchar(50) default NULL, `CustomerID` int(10) unsigned default NULL, PRIMARY KEY (`NoteID`), UNIQUE KEY `NoteID` (`NoteID`) ) TYPE=InnoDB AUTO_INCREMENT=5 ; -- -- Table structure for table `Package` -- DROP TABLE IF EXISTS `Package`; CREATE TABLE IF NOT EXISTS `Package` ( `PackageID` int(10) unsigned NOT NULL auto_increment, `PackageGroupID` int(10) unsigned NOT NULL default '0', `ResourceID` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`PackageID`), UNIQUE KEY `PackageID` (`PackageID`) ) TYPE=InnoDB AUTO_INCREMENT=25 ; -- -- Dumping data for table `Package` -- INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (7, 4, 1); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (8, 4, 2); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (9, 5, 3); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (12, 7, 5); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (13, 7, 4); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (14, 7, 1); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (15, 8, 1); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (16, 8, 4); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (17, 8, 5); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (18, 9, 2); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (19, 9, 4); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (20, 11, 1); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (21, 11, 4); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (22, 1, 6); INSERT INTO `Package` (`PackageID`, `PackageGroupID`, `ResourceID`) VALUES (24, 1, 4); -- -------------------------------------------------------- -- -- Table structure for table `PackageGroup` -- DROP TABLE IF EXISTS `PackageGroup`; CREATE TABLE IF NOT EXISTS `PackageGroup` ( `PackageGroupID` int(10) unsigned NOT NULL auto_increment, `Description` varchar(100) default NULL, `Detail` varchar(255) default NULL, `Category` varchar(50) default NULL, `Price` float(4,2) default NULL, `Tax` int(11) default NULL, `Charged` varchar(15) default NULL, `BillIntervalID` int(10) unsigned default NULL, PRIMARY KEY (`PackageGroupID`), UNIQUE KEY `PackageGroupID` (`PackageGroupID`) ) TYPE=InnoDB AUTO_INCREMENT=70 ; -- -- Dumping data for table `PackageGroup` -- INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (25, '.CO.UK', '.co.uk domain registeration\r\npaid biyearly', 'DOMAIN', 8.95, 0, '', 4); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (30, '.COM', '.com domain registeration\r\npaid yearly', 'DOMAIN', 6.95, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (31, '.NET', '.net domain registeration \r\npaid yearly', 'DOMAIN', 6.95, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (32, '.ORG', '.org domain registeration\r\npaid yearly', 'DOMAIN', 7.95, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (33, 'RESELLER_5GB', '5.0 Gb Reseller Hosting Account with 50 Gb Monthly Transfer', 'CUSTOM', 9.99, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (42, 'BASIC', '200 MB WEB SPACE/n\r\n2000 MB MONTHLY TRANSFER/n\r\n20 POP EMAIL ACCOUNTS/n', 'HOSTING', 33.20, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (44, 'RESELLER_2GB', '2.0 Gb Web Space\r\n20.0 Gb Bandwidth', 'CUSTOM', 4.00, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (45, 'SOHO_QUARTERLY', '600MB Web Space with 6000 Mb Monthly Transfer', 'HOSTING', 20.45, 0, '', 6); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (46, 'QWSERVER MONTHLY SUBSCRIPTION', 'AMD XP2400 Processor\r\n512 MB DDR Memory\r\n80 Gb Harddrive\r\nWHM/CPANEL/FANTASTICO\r\n1000GB Monthly Bandwidth (750Gb-800 Gb Usable)\r\n', 'SERVERS', 99.00, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (47, 'SOHO', '600 Mb Web Space\r\n6000 Mb Bandwidth', 'HOSTING', 6.95, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (49, 'CUSTOM_100MB', 'put the details of package here', 'CUSTOM', 4.99, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (50, 'BASIC', '200 MB Web Hosting with 2000 MB Monthly Data Transfer', 'HOSTING', 2.95, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (51, 'BASIC', '200 MB Web Space with 2000 Mb Monthly Transfer', 'HOSTING', 8.45, 0, '', 6); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (52, 'SOHO_ANNUAL', '600 Mb Web Space with 6000 Mb Monthly Transfer', 'HOSTING', 81.20, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (53, 'RESELLER PLAN BASIC', '6.0 Gb Web Space, 60 Gb Bandwidth', 'CUSTOM', 17.95, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (54, 'ENTERPRISEPLUS', 'ENTERPRISEPLUS HOSTING ACCOUNT', 'HOSTING', 19.95, NULL, NULL, 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (55, 'BUSINESSPLUS', '1400 mb webspace, 14000 mb bandwidth', 'HOSTING', 129.50, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (56, '.ORG.UK', '.ORG.UK Domain Registeration for 2 years', 'DOMAIN', 6.99, 0, '', 4); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (57, 'ENTERPRISEPLUS', 'ENTERPRISEPLUS', 'HOSTING', 199.50, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (58, 'BASICPLUS', '400 MB Web Space\r\n4000 MB Monthly Bandwidth', 'HOSTING', 4.95, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (59, 'BASICPLUS', '400 MB Web Space\r\n4000 MB Monthly', 'HOSTING', 14.45, 0, '', 6); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (60, 'BASICPLUS', '400 MB Web Space\r\n4000 MB Monthly', 'HOSTING', 49.50, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (61, 'BUSINESS', '1000 Mb Web Space\r\n10000 Mb Monthly Data Transfer', 'HOSTING', 9.95, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (62, 'BUSINESS', 'put the details of package here', 'HOSTING', 29.45, 0, '', 6); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (63, 'BUSINESS', '400 MB Web Space\r\n4000 MB Monthly', 'HOSTING', 99.50, 0, '', 2); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (64, 'BUSINESSPLUS', '1400 MB Web Space\r\n14000 MB Monthly', 'HOSTING', 12.95, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (65, 'BUSINESSPLUS', '1400 MB Web Space\r\n14000 MB Monthly', 'HOSTING', 37.95, 0, '', 6); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (66, 'ENTERPRISE', '2000 MB Web Space\r\n20000 MB Monthly', 'HOSTING', 16.95, 0, '', 5); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (67, 'ENTERPRISE', '2000 MB Web Space\r\n20000 MB Monthly', 'HOSTING', 49.95, 0, '', 6); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (68, 'ENTERPRISE', 'put the details of package here', 'HOSTING', 169.50, 0, '', 7); INSERT INTO `PackageGroup` (`PackageGroupID`, `Description`, `Detail`, `Category`, `Price`, `Tax`, `Charged`, `BillIntervalID`) VALUES (69, 'ENTERPRISEPLUS', '3000 MB Web Space\r\n30000 MB Monthly', 'HOSTING', 57.95, 0, '', 6); -- -------------------------------------------------------- -- -- Table structure for table `PaymentMethods` -- DROP TABLE IF EXISTS `PaymentMethods`; CREATE TABLE IF NOT EXISTS `PaymentMethods` ( `PaymentMethodID` int(10) unsigned NOT NULL auto_increment, `CustomerID` int(10) unsigned default NULL, `PaymentName` varchar(40) default NULL, `CCNumber` varchar(20) default NULL, `CCName` varchar(80) default NULL, `CCExpire` varchar(10) default NULL, `CCAddress` varchar(50) default NULL, `CCZip` varchar(10) default NULL, `CCTelephone` varchar(16) default NULL, PRIMARY KEY (`PaymentMethodID`), UNIQUE KEY `PaymentMethodID` (`PaymentMethodID`) ) TYPE=InnoDB AUTO_INCREMENT=1 ; -- -- Dumping data for table `PaymentMethods` -- -- -------------------------------------------------------- -- -- Table structure for table `PaymentType` -- DROP TABLE IF EXISTS `PaymentType`; CREATE TABLE IF NOT EXISTS `PaymentType` ( `PaymentTypeID` int(11) unsigned NOT NULL auto_increment, `PaymentType` varchar(50) default NULL, PRIMARY KEY (`PaymentTypeID`), UNIQUE KEY `PaymentTypeID` (`PaymentTypeID`), KEY `PaymentTypeID_2` (`PaymentTypeID`) ) TYPE=InnoDB AUTO_INCREMENT=8 ; -- -- Dumping data for table `PaymentType` -- INSERT INTO `PaymentType` (`PaymentTypeID`, `PaymentType`) VALUES (1, 'Cash'); INSERT INTO `PaymentType` (`PaymentTypeID`, `PaymentType`) VALUES (2, 'Cheque'); INSERT INTO `PaymentType` (`PaymentTypeID`, `PaymentType`) VALUES (3, 'Paypal'); INSERT INTO `PaymentType` (`PaymentTypeID`, `PaymentType`) VALUES (4, 'Money Order'); INSERT INTO `PaymentType` (`PaymentTypeID`, `PaymentType`) VALUES (5, 'Direct Deposit'); INSERT INTO `PaymentType` (`PaymentTypeID`, `PaymentType`) VALUES (6, 'Nochex'); INSERT INTO `PaymentType` (`PaymentTypeID`, `PaymentType`) VALUES (7, 'Credit Card'); -- -------------------------------------------------------- -- -- Table structure for table `Payments` -- DROP TABLE IF EXISTS `Payments`; CREATE TABLE IF NOT EXISTS `Payments` ( `PaymentID` int(10) unsigned NOT NULL auto_increment, `CustomerID` int(10) unsigned NOT NULL default '0', `PaymentDate` date default NULL, `PaymentTypeID` int(11) default NULL, `PaymentDetail` varchar(50) default NULL, `TransactionID` varchar(60) default NULL, `Amount` float(10,2) default NULL, `Sent` enum('Yes','No') default 'No', PRIMARY KEY (`PaymentID`), UNIQUE KEY `PaymentID` (`PaymentID`) ) TYPE=InnoDB AUTO_INCREMENT=139 ; DROP TABLE IF EXISTS `PaypalConfig`; CREATE TABLE IF NOT EXISTS `PaypalConfig` ( `Enabled` int(2) default NULL, `Email` varchar(50) default NULL, `Refunds` int(2) default NULL, `Currency` enum('USD','GBP','CAD','EUR','JPY') default NULL, `PaymentTypeID` int(10) default NULL ) TYPE=InnoDB; -- -- Dumping data for table `PaypalConfig` -- INSERT INTO `PaypalConfig` (`Enabled`, `Email`, `Refunds`, `Currency`, `PaymentTypeID`) VALUES (1, 'sales@monitorsonline.co.uk', 0, 'GBP', 3); -- -------------------------------------------------------- -- -- Table structure for table `Priority` -- DROP TABLE IF EXISTS `Priority`; CREATE TABLE IF NOT EXISTS `Priority` ( `PriorityID` int(10) unsigned NOT NULL default '0', `PriorityName` varchar(50) default NULL, PRIMARY KEY (`PriorityID`), UNIQUE KEY `PriorityID` (`PriorityID`) ) TYPE=InnoDB; -- -- Dumping data for table `Priority` -- INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (0, 'Time Permitting'); INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (1, 'Budget Item'); INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (2, 'Hold'); INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (100, 'Low'); INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (200, 'Normal'); INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (300, 'Needed'); INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (400, 'Medium'); INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (500, 'High'); INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (995, 'Urgent'); INSERT INTO `Priority` (`PriorityID`, `PriorityName`) VALUES (999, 'Security'); -- -------------------------------------------------------- -- -- Table structure for table `Servers` -- DROP TABLE IF EXISTS `Servers`; CREATE TABLE IF NOT EXISTS `Servers` ( `ID` int(4) NOT NULL auto_increment, `Domain` varchar(100) NOT NULL default '', `Nameserver1` varchar(100) NOT NULL default '', `IpAddress1` varchar(15) NOT NULL default '', `Nameserver2` varchar(100) NOT NULL default '', `IpAddress2` varchar(15) NOT NULL default '', `ControlPanel` varchar(50) NOT NULL default '', `Username` varchar(8) NOT NULL default '', `Password` text NOT NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=5 ; -- -------------------------------------------------------- -- -- Table structure for table `TaxInfo` -- DROP TABLE IF EXISTS `TaxInfo`; CREATE TABLE IF NOT EXISTS `TaxInfo` ( `TaxInfoID` int(10) unsigned NOT NULL auto_increment, `TaxTag` text, `Description` text, `Quantity` float(10,2) default NULL, `TaxType` enum('Rate','Flat') default NULL, PRIMARY KEY (`TaxInfoID`) ) TYPE=InnoDB AUTO_INCREMENT=1 ; -- -- Dumping data for table `TaxInfo` -- -- -------------------------------------------------------- -- -- Table structure for table `Taxes` -- DROP TABLE IF EXISTS `Taxes`; CREATE TABLE IF NOT EXISTS `Taxes` ( `TaxID` int(10) unsigned NOT NULL auto_increment, `TaxRate` float(4,2) default NULL, PRIMARY KEY (`TaxID`), UNIQUE KEY `TaxID` (`TaxID`), KEY `TaxID_2` (`TaxID`) ) TYPE=InnoDB AUTO_INCREMENT=2 ; -- -- Dumping data for table `Taxes` -- INSERT INTO `Taxes` (`TaxID`, `TaxRate`) VALUES (1, 0.10); -- -------------------------------------------------------- -- -- Table structure for table `TicketPosts` -- DROP TABLE IF EXISTS `TicketPosts`; CREATE TABLE IF NOT EXISTS `TicketPosts` ( `TicketPostID` int(10) NOT NULL auto_increment, `TicketID` int(10) NOT NULL default '0', `Poster` varchar(50) NOT NULL default '', `DatePosted` varchar(10) NOT NULL default '', `TimePosted` varchar(10) NOT NULL default '', `PostDescription` text NOT NULL, PRIMARY KEY (`TicketPostID`) ) TYPE=MyISAM AUTO_INCREMENT=33 ; -- -- Table structure for table `Tickets` -- DROP TABLE IF EXISTS `Tickets`; CREATE TABLE IF NOT EXISTS `Tickets` ( `TicketID` int(10) unsigned NOT NULL auto_increment, `CustomerID` int(10) unsigned NOT NULL default '0', `Description` text, `Status` enum('Open','Closed') default NULL, `OpenDate` date default NULL, `OpenTime` time default NULL, `CloseDate` date default NULL, `CloseTime` time default NULL, `Opener` varchar(100) default NULL, `Billable` enum('Yes','No') default NULL, `Billed` enum('Yes','No') default NULL, `DueDate` date default NULL, `PriorityID` int(10) default NULL, `AssignedID` int(10) default NULL, `Subject` varchar(255) default NULL, PRIMARY KEY (`TicketID`), UNIQUE KEY `TicketID` (`TicketID`) ) TYPE=InnoDB AUTO_INCREMENT=24 ; -- -- Table structure for table `Transactions` -- DROP TABLE IF EXISTS `Transactions`; CREATE TABLE IF NOT EXISTS `Transactions` ( `TransactionID` int(10) NOT NULL auto_increment, `CustomerID` varchar(10) NOT NULL default '', `Action` varchar(50) NOT NULL default '', `Var1` varchar(100) NOT NULL default '', `Var2` varchar(100) NOT NULL default '', `Var3` varchar(100) NOT NULL default '', `Status` varchar(100) NOT NULL default 'Pending', PRIMARY KEY (`TransactionID`) ) TYPE=MyISAM AUTO_INCREMENT=38 ; -- -------------------------------------------------------- -- -- Table structure for table `UserACL` -- DROP TABLE IF EXISTS `UserACL`; CREATE TABLE IF NOT EXISTS `UserACL` ( `UserID` int(10) unsigned default NULL, `AccFlag` text ) TYPE=InnoDB; -- -- Dumping data for table `UserACL` -- INSERT INTO `UserACL` (`UserID`, `AccFlag`) VALUES (1, 'admin'); INSERT INTO `UserACL` (`UserID`, `AccFlag`) VALUES (1, 'debug_dest:html'); INSERT INTO `UserACL` (`UserID`, `AccFlag`) VALUES (1, 'Main_SearchBar'); -- -------------------------------------------------------- -- -- Table structure for table `UserInfo` -- DROP TABLE IF EXISTS `UserInfo`; CREATE TABLE IF NOT EXISTS `UserInfo` ( `UserID` int(10) unsigned default NULL, `Phone` varchar(16) default NULL, `Fax` varchar(16) default NULL, `Email` varchar(100) default NULL, `Building` varchar(50) default NULL, `Room` varchar(50) default NULL, `Organization` varchar(50) default NULL, `Notes` text, `Firstname` varchar(100) default NULL, `Lastname` varchar(100) default NULL, `Location` varchar(100) default NULL, `Status` varchar(100) default NULL ) TYPE=InnoDB; -- -- Dumping data for table `UserInfo` -- INSERT INTO `UserInfo` (`UserID`, `Phone`, `Fax`, `Email`, `Building`, `Room`, `Organization`, `Notes`, `Firstname`, `Lastname`, `Location`, `Status`) VALUES (1, 'Phone', 'Fax', 'Email', 'Building', 'Room', 'Org', 'Notes', 'System', 'Administrator', 'Here', 'Awake'); -- -------------------------------------------------------- -- -- Table structure for table `Users` -- DROP TABLE IF EXISTS `Users`; CREATE TABLE IF NOT EXISTS `Users` ( `UserID` int(10) unsigned NOT NULL auto_increment, `Username` varchar(50) default NULL, `Password` varchar(50) default NULL, `Language` varchar(50) default NULL, PRIMARY KEY (`UserID`) ) TYPE=InnoDB AUTO_INCREMENT=2 ; -- -- Dumping data for table `Users` -- INSERT INTO `Users` (`UserID`, `Username`, `Password`, `Language`) VALUES (1, 'quicklyweb', '', 'english.php'); -- -------------------------------------------------------- -- -- Table structure for table `conf_images` -- DROP TABLE IF EXISTS `conf_images`; CREATE TABLE IF NOT EXISTS `conf_images` ( `alias` varchar(20) default NULL, `src` varchar(90) default NULL, `width` int(10) unsigned default NULL, `height` int(10) unsigned default NULL ) TYPE=InnoDB; -- -- Dumping data for table `conf_images` -- INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('PATH', 'images', 0, 0); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('edit', 'edit.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('work_start', 'work_start.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('work_stop', 'work_stop.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('submit', 'submit.png', 41, 20); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('sendbill', 'sendbill.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('search', 'search.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('refresh', 'refresh.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('open', 'open.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('manage_user', 'manage_user.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('manage_resource', 'manage_resource.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('manage_package', 'manage_package.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('manage_news', 'manage_news.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('logout', 'logout.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('list', 'list.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('home', 'home.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('help', 'help.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('go', 'go.png', 41, 20); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('edit', 'edit.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('edit_customer', 'edit_customer.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('delete', 'delete.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('create_package', 'create_package.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('configuration', 'configuration.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('close', 'close.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('clear', 'clear.png', 41, 20); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_user', 'add_user.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_ticket', 'add_ticket.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_resource', 'add_resource.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_payment', 'add_payment.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_note', 'add_note.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_news', 'add_news.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_invoice', 'add_invoice.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_customer', 'add_customer.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_contact', 'add_contact.png', 24, 24); INSERT INTO `conf_images` (`alias`, `src`, `width`, `height`) VALUES ('add_account', 'add_account.png', 24, 24); -- -------------------------------------------------------- -- -- Table structure for table `faq_categories` -- DROP TABLE IF EXISTS `faq_categories`; CREATE TABLE IF NOT EXISTS `faq_categories` ( `c_id` int(8) NOT NULL auto_increment, `c_order` int(8) NOT NULL default '0', `category` varchar(255) NOT NULL default '', PRIMARY KEY (`c_id`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; -- -- Dumping data for table `faq_categories` -- INSERT INTO `faq_categories` (`c_id`, `c_order`, `category`) VALUES (1, 0, 'General'); -- -------------------------------------------------------- -- -- Table structure for table `faq_questions` -- DROP TABLE IF EXISTS `faq_questions`; CREATE TABLE IF NOT EXISTS `faq_questions` ( `q_id` int(8) NOT NULL auto_increment, `c_id` int(8) NOT NULL default '0', `q_order` int(8) NOT NULL default '0', `question` varchar(255) NOT NULL default '', `answer` text NOT NULL, PRIMARY KEY (`q_id`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; -- -- Dumping data for table `faq_questions` -- INSERT INTO `faq_questions` (`q_id`, `c_id`, `q_order`, `question`, `answer`) VALUES (1, 1, 1, 'Question 1', 'Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. '); INSERT INTO `faq_questions` (`q_id`, `c_id`, `q_order`, `question`, `answer`) VALUES (2, 1, 2, 'Question 2', 'Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. '); INSERT INTO `faq_questions` (`q_id`, `c_id`, `q_order`, `question`, `answer`) VALUES (3, 1, 3, 'Question 3', 'Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. Replace this with your text. Here is the answer to this question. ');