· 6 years ago · Apr 24, 2019, 04:26 PM
1DROP TABLE IF EXISTS ``;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3 SET character_set_client = utf8mb4 ;
4CREATE TABLE `ecomm_site`.`uploaded_images` (
5 `ID` INT NOT NULL,
6 `imageName` VARCHAR(45) NOT NULL,
7 `extension` VARCHAR(4) NOT NULL,
8 PRIMARY KEY (`ID`),
9 UNIQUE INDEX `ID_UNIQUE` (`ID` ASC) VISIBLE,
10 UNIQUE INDEX `imageName_UNIQUE` (`imageName` ASC) VISIBLE,
11 CONSTRAINT `ID`
12 FOREIGN KEY (`ID`)
13 REFERENCES `ecomm_site`.`cus_customers` (`ID`)
14 ON DELETE CASCADE
15 ON UPDATE CASCADE);