# Dumped by islamicShell.SQL v. edition ADVANCED # Home page: http://securityprobe.net # # Host settings: # MySQL version: (5.0.90-community-log) running on 210.8.91.152 (audiobahn.com.au) # Date: 08.10.2010 02:07:26 # DB: "aud35365_osc1" #--------------------------------------------------------- DROP TABLE IF EXISTS `orders`; CREATE TABLE `orders` ( `orders_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `customers_name` varchar(64) NOT NULL default '', `customers_company` varchar(32) default NULL, `customers_street_address` varchar(64) NOT NULL default '', `customers_suburb` varchar(32) default NULL, `customers_city` varchar(32) NOT NULL default '', `customers_postcode` varchar(10) NOT NULL default '', `customers_state` varchar(32) default NULL, `customers_country` varchar(32) NOT NULL default '', `customers_telephone` varchar(32) NOT NULL default '', `customers_email_address` varchar(96) NOT NULL default '', `customers_address_format_id` int(5) NOT NULL default '0', `delivery_name` varchar(64) NOT NULL default '', `delivery_company` varchar(32) default NULL, `delivery_street_address` varchar(64) NOT NULL default '', `delivery_suburb` varchar(32) default NULL, `delivery_city` varchar(32) NOT NULL default '', `delivery_postcode` varchar(10) NOT NULL default '', `delivery_state` varchar(32) default NULL, `delivery_country` varchar(32) NOT NULL default '', `delivery_address_format_id` int(5) NOT NULL default '0', `billing_name` varchar(64) NOT NULL default '', `billing_company` varchar(32) default NULL, `billing_street_address` varchar(64) NOT NULL default '', `billing_suburb` varchar(32) default NULL, `billing_city` varchar(32) NOT NULL default '', `billing_postcode` varchar(10) NOT NULL default '', `billing_state` varchar(32) default NULL, `billing_country` varchar(32) NOT NULL default '', `billing_address_format_id` int(5) NOT NULL default '0', `payment_method` varchar(32) NOT NULL default '', `cc_type` varchar(20) default NULL, `cc_owner` varchar(64) default NULL, `cc_number` varchar(32) default NULL, `cc_expires` varchar(4) default NULL, `last_modified` datetime default NULL, `date_purchased` datetime default NULL, `orders_status` int(5) NOT NULL default '0', `orders_date_finished` datetime default NULL, `currency` char(3) default NULL, `currency_value` decimal(14,6) default NULL, PRIMARY KEY (`orders_id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; INSERT INTO `orders`(`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES ('1', '2', 'John Robinson', '', 'P.O. Box 242', '', 'Whittlesea', '3757', '', 'Australia', '0418832471', 'john@dynamomarketing.com.au', '1', 'John Robinson', '', 'P.O. Box 242', '', 'Whittlesea', '3757', '', 'Australia', '1', 'John Robinson', '', 'P.O. Box 242', '', 'Whittlesea', '3757', '', 'Australia', '1', 'Credit Card', 'Visa', 'John Robinson', '4564000000000000', '0107', '2006-12-11 23:42:01', '2006-12-01 23:36:59', '5', '', 'USD', '1.000000'); INSERT INTO `orders`(`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES ('2', '4', 'Jodie HHHH', '', 'ppppp', '', 'West Melbourne', '3891', '', 'Australia', '0418000000', 'jodie@audiobahn.com.au', '1', 'Jodie HHHH', '', 'ppppp', '', 'West Melbourne', '3891', '', 'Australia', '1', 'Jodie HHHH', '', 'ppppp', '', 'West Melbourne', '3891', '', 'Australia', '1', 'Credit Card', 'Visa', 'Jodie HHHH', '4564000000000000', '0107', '2006-12-12 14:20:10', '2006-12-12 14:18:35', '5', '', 'AUD', '1.000000'); INSERT INTO `orders`(`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES ('3', '2', 'John Robinson', '', 'P.O. Box 242', '', 'Whittlesea', '3757', '', 'Australia', '0418832471', 'john@dynamomarketing.com.au', '1', 'John Robinson', '', 'P.O. Box 242', '', 'Whittlesea', '3757', '', 'Australia', '1', 'John Robinson', '', 'P.O. Box 242', '', 'Whittlesea', '3757', '', 'Australia', '1', 'Credit Card', 'Visa', 'John Robinson', '4564000000000000', '0608', '2008-03-17 11:02:04', '2008-03-17 10:59:25', '3', '', 'AUD', '1.000000'); INSERT INTO `orders`(`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES ('4', '26', 'Rebecca Taylor', '', '6 Kingfisher Tce', '', 'Jubilee Pocket', '4802', '', 'Australia', '0414369516', 'becbabe99@hotmail.com', '1', 'Rebecca Taylor', '', '6 Kingfisher Tce', '', 'Jubilee Pocket', '4802', '', 'Australia', '1', 'Rebecca Taylor', '', '6 Kingfisher Tce', '', 'Jubilee Pocket', '4802', '', 'Australia', '1', 'Credit Card', 'Master Card', 'Rebecca Taylor', '5446370360512014', '1110', '2008-06-24 12:14:42', '2008-06-23 21:34:01', '3', '', 'AUD', '1.000000'); INSERT INTO `orders`(`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES ('5', '27', 'Kim Godden', '', '96 hudson court', '', 'parap', '0820', '', 'Australia', '61452458254', 'goddenk@yahoo.com', '1', 'Kim Godden', '', '96 hudson court', '', 'parap', '0820', '', 'Australia', '1', 'Kim Godden', '', '96 hudson court', '', 'parap', '0820', '', 'Australia', '1', 'Credit Card', 'Master Card', 'James Pack', '5405949000076248', '0809', '2008-08-01 10:44:41', '2008-07-30 09:49:39', '2', '', 'AUD', '1.000000'); INSERT INTO `orders`(`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES ('6', '33', 'john brittain', '', '2/13 soldiers point rd', '', 'soldiers point', '2317', '', 'Australia', '0429836608', 'fordlover82@hotmail.com', '1', 'john brittain', '', '2/13 soldiers point rd', '', 'soldiers point', '2317', '', 'Australia', '1', 'john brittain', '', '2/13 soldiers point rd', '', 'soldiers point', '2317', '', 'Australia', '1', 'Cheque/Money Order', '', '', '', '', '', '2008-11-20 21:05:15', '1', '', 'AUD', '1.000000'); INSERT INTO `orders`(`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES ('7', '39', 'michael heather', '', '2 sutherland road jannali', '', 'jannali', '2226', '', 'Australia', '0405724425', 'the_poon_palace@hotmail.com', '1', 'michael heather', '', '2 sutherland road jannali', '', 'jannali', '2226', '', 'Australia', '1', 'michael heather', '', '2 sutherland road jannali', '', 'jannali', '2226', '', 'Australia', '1', 'Credit Card', 'Master Card', 'michael heather', '5353161308517707', '0511', '', '2009-02-04 10:29:03', '2', '', 'AUD', '1.000000'); INSERT INTO `orders`(`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES ('8', '52', 'Steven O\'Brien', '', '8 Ashbourne Road', '', 'Woodend', '3442', '', 'Australia', '0430448402', 'stevo9992004@hotmail.com', '1', 'Steven O\'Brien', '', '8 Ashbourne Road', '', 'Woodend', '3442', '', 'Australia', '1', 'Steven O\'Brien', '', '8 Ashbourne Road', '', 'Woodend', '3442', '', 'Australia', '1', 'Cheque/Money Order', '', '', '', '', '', '2009-11-04 14:50:21', '1', '', 'AUD', '1.000000'); #---------------------------------------------------------------------------------