Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Search the Community

Showing results for tags 'discount coupon add on'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • News and Announcements
    • News and Announcements
  • osCommerce v4.x
    • General Support
    • Migration from old osCommerce
    • Design and Templates
    • Apps / Add-ons
    • Translations
    • API and import/export
    • Marketplace integration
    • Manuals and How-to
    • Blog's discussion
  • osCommerce Online Merchant v2.x
    • General Support
    • osCommerce Online Merchant Community Bootstrap Edition
    • Add-Ons
  • Development
  • General
    • General Discussions
    • Live Shop Reviews
    • Security
    • Commercial Support Inquiries
    • Developer Feedback

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Real Name


Location


Interests


Website

Found 1 result

  1. I know I am going to sound like a pure moron with this question, but HOW do I perform the SQL Query? I know I have to go into my phpadmin, select my database, select sql. I guess I am attempting to create these 2 tables? CREATE TABLE `customers_to_discount_codes` ( `customers_id` int(11) NOT NULL default '0', `discount_codes_id` int(11) NOT NULL default '0', KEY `customers_id` (`customers_id`), KEY `discount_codes_id` (`discount_codes_id`) ); CREATE TABLE `discount_codes` ( `discount_codes_id` int(11) NOT NULL auto_increment, `products_id` text, `categories_id` text, `manufacturers_id` text, `excluded_products_id` text, `customers_id` text, `orders_total` tinyint(1) NOT NULL default '0', `order_info` tinyint(1) NOT NULL default '0', `exclude_specials` tinyint(1) NOT NULL default '0', `discount_codes` varchar(8) NOT NULL default '', `discount_values` varchar(8) NOT NULL default '', `minimum_order_amount` decimal(15,4) NOT NULL default '0.0000', `expires_date` date NOT NULL default '0000-00-00', `number_of_orders` int(4) NOT NULL default '0', `number_of_use` int(4) NOT NULL default '0', `number_of_products` int(4) NOT NULL default '0', `status` tinyint(1) NOT NULL default '1', PRIMARY KEY (`discount_codes_id`) ); Now my question is what exactly are these? Do I need to do 2 seperate queries? I kinda like to know I am not going to destroy my database even though I took backups. I just don't want to get into the position of trying to fix something that I am not 100% sure I can fix.
×
×
  • Create New...