Create table using query

 CREATE TABLE products(

pid INT(11) NOT NULL AUTO_INCREMENT,

cid INT(11) NOT NULL,

bid INT(11) NOT NULL,

product_name VARCHAR(200) NOT NULL,

product_price DOUBLE(11) NOT NULL,

product_stock INT(11) NOT NULL,

added_date DATE NOT NULL,

p_status ENUM('1','0') NOT NULL,

PRIMARY KEY(pid),

UNIQUE KEY(product_name),

FOREIGN KEY(cid) REFERENCES catergoris(cid),

FOREIGN KEY(bid) REFERENCES brand(bid)

  

    

);