Jump to content
Bicrypto v3.7.0 + All Plugins ×

Pedro Lucca

Members
  • Posts

    11
  • Reputation

    1
  • Files

    0
  • Joined

  • Last visited

Posts posted by Pedro Lucca

  1. On 4/15/2020 at 2:04 AM, Pedro Lucca said:

    Hello, my compliments. I hope everything is fine with you!

    I have a little problem with the discount codes
    I noticed that in the installation the 'codes' table was not created
    I tried to create manually but I'm not very experienced in it
    if you don't mind
    could you send me the created 'codes' table?

    here's what I tried to do

     

     

    
    CREATE TABLE `codes` (
     `type` enum('DISCOUNT','REDEEMABLE') NOT NULL,
     `days` int(11) NOT NULL,
     `package_id` int(11) DEFAULT NULL,
     `code` int(11) NOT NULL,
     `discount` int(11) NOT NULL,
     `quantity` int(11) NOT NULL,
     `date` datetime DEFAULT NULL,
     PRIMARY KEY (`type`),
     KEY `package_id` (`package_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

     

    @Mahmoud 'payments' mysql tables is missing

  2. Hello, my compliments. I hope everything is fine with you!

    I have a little problem with the discount codes
    I noticed that in the installation the 'codes' table was not created
    I tried to create manually but I'm not very experienced in it
    if you don't mind
    could you send me the created 'codes' table?

    here's what I tried to do

     

     

    CREATE TABLE `codes` (
     `type` enum('DISCOUNT','REDEEMABLE') NOT NULL,
     `days` int(11) NOT NULL,
     `package_id` int(11) DEFAULT NULL,
     `code` int(11) NOT NULL,
     `discount` int(11) NOT NULL,
     `quantity` int(11) NOT NULL,
     `date` datetime DEFAULT NULL,
     PRIMARY KEY (`type`),
     KEY `package_id` (`package_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

     

×
×
  • Create New...