· 6 years ago · Apr 24, 2019, 04:40 PM
1DROP TABLE IF EXISTS `uploaded_images`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3 SET character_set_client = utf8mb4 ;
4CREATE TABLE 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`) REFERENCES `ecomm_site`.`cus_customers` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE);