DROP TABLE IF EXISTS `Client`; CREATE TABLE `Client` (
`ID` int(11) NOT NULL AUTO_INCREMENT, `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `Client_Number` varchar(15) NOT NULL DEFAULT '', `Privil` varchar(15) NOT NULL DEFAULT '', `Active` enum('0','1') NOT NULL DEFAULT '0', `ActiveUntil` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `MaxDomains` int(11) NOT NULL DEFAULT '100', `Title` varchar(10) DEFAULT NULL, `First_Name` varchar(70) DEFAULT NULL, `Surname` varchar(70) DEFAULT NULL, `Company` varchar(70) DEFAULT NULL, `Street` varchar(70) DEFAULT NULL, `Postal_Code` varchar(10) DEFAULT NULL, `Suburb` varchar(70) NOT NULL DEFAULT '', `Country` varchar(70) NOT NULL DEFAULT '0', `City` varchar(70) NOT NULL DEFAULT '', `CountryGroup` enum('0','1','2') NOT NULL DEFAULT '0', `Telephone` varchar(50) DEFAULT NULL, `Cellphone` varchar(50) NOT NULL DEFAULT '', `ID_Number` varchar(30) DEFAULT NULL, `Date_Of_Birth` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Fax` varchar(50) DEFAULT NULL, `RipeHandle` varchar(16) NOT NULL DEFAULT '', `Login` varchar(15) DEFAULT NULL, `Password` varchar(30) DEFAULT NULL, `FromEmail1` varchar(40) NOT NULL DEFAULT '', `FromEmail2` varchar(40) DEFAULT NULL, `FromEmail3` varchar(40) DEFAULT NULL, `PublicKey` mediumtext NOT NULL, `Newsletter` enum('0','1') NOT NULL DEFAULT '0', `Notice` enum('0','1') NOT NULL DEFAULT '1', `Notifyemail` varchar(100) DEFAULT NULL, `Notifyemail_Robot` varchar(100) NOT NULL DEFAULT '', `Notifyemail_Traffic` varchar(100) DEFAULT NULL, `Notifyemail_Invoice` text, `FreeTraffic` decimal(4,2) DEFAULT NULL, `Bank_Branch_Code` varchar(8) DEFAULT NULL, `Bank_Account_Number` varchar(30) DEFAULT NULL, `Bank_Account_Holder` varchar(60) DEFAULT NULL, `Bank_Account_Type` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0', `Bank_Name` varchar(60) NOT NULL DEFAULT '', `Bank_Branch_Location` varchar(60) NOT NULL DEFAULT '', `Reseller` enum('0','1') NOT NULL DEFAULT '0', `Reseller_Proof` varchar(60) NOT NULL DEFAULT '', `CreditCardNumber` varchar(30) NOT NULL DEFAULT '', `CreditCardExpiration` varchar(6) NOT NULL DEFAULT '', `CreditCardName` varchar(15) NOT NULL DEFAULT '', `payment_method` enum('Unspecified','Cash','Debit Order') NOT NULL DEFAULT 'Unspecified', `Mother_ID` varchar(12) NOT NULL DEFAULT '', `ChargeVAT` enum('0','1') NOT NULL DEFAULT '1', `Summary_Invoice` enum('0','1') NOT NULL DEFAULT '0', `Separate_Invoice` enum('0','1') NOT NULL DEFAULT '0', `Email_Format` enum('0','1','2','3') NOT NULL DEFAULT '1', `Dedi_Graph` enum('0','1') NOT NULL DEFAULT '1', `TaxID` varchar(20) NOT NULL DEFAULT '', `Discount` decimal(4,2) DEFAULT NULL, `ChargeRobotSetup` enum('0','1','2') DEFAULT NULL, `ClientCreated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `Comment` text, `Advice` mediumtext NOT NULL, `Vat_Number` varchar(30) DEFAULT NULL, `Rejection_Counter` tinyint(11) DEFAULT '0', `Marketing` enum('Print','Brainstorm','ComputerActive','Google','ITWeb','Mouth','Website','Search','Designer','Hetzner','Other','SA Computer Magazine','Entrepreneur Magazine','Financial Mail') DEFAULT NULL, `Marketing_other` mediumtext, `Billing_First_Name` varchar(70) NOT NULL DEFAULT '', `Billing_Surname` varchar(70) NOT NULL DEFAULT '', `Billing_Telephone` varchar(50) NOT NULL DEFAULT '', `Billing_Cellphone` varchar(50) NOT NULL DEFAULT '', `Tech_First_Name` varchar(70) NOT NULL DEFAULT '', `Tech_Surname` varchar(70) NOT NULL DEFAULT '', `Notifyemail_Tech` varchar(100) NOT NULL DEFAULT '', `Tech_Telephone` varchar(50) NOT NULL DEFAULT '', `Tech_Cellphone` varchar(50) NOT NULL DEFAULT '', `Verified` enum('0','1') NOT NULL DEFAULT '1', `mass_update_notification_sent` enum('1','2','3','more','no') NOT NULL DEFAULT 'no', `mass_update_submission_sent` enum('yes','no') NOT NULL DEFAULT 'no', `contact_Confirmed` enum('True','False') NOT NULL DEFAULT 'True', `is_test_profile` enum('0','1') DEFAULT '0', `Google` enum('None','Eligible','Emailed','Issued') NOT NULL DEFAULT 'None', `Google_Value_ID` int(11) NOT NULL DEFAULT '0', `Google_Expiry` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `app_installer_active` tinyint(1) DEFAULT '1', PRIMARY KEY (`ID`), KEY `Login` (`Login`), KEY `Password` (`Password`), KEY `Notifyemail_Invoice` (`Notifyemail_Invoice`(20)), KEY `Client_Number` (`Client_Number`)
) ENGINE=InnoDB AUTO_INCREMENT=185532 DEFAULT CHARSET=latin1;