SHARE
TWEET

Untitled

a guest Feb 20th, 2019 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. CREATE TABLE `Image` (
  3.   `id` int(25) NOT NULL,
  4.   `imagename` varchar(45) NOT NULL,
  5.   `imageurl` varchar(45) NOT NULL,
  6.   `added` DATETIME NOT NULL,
  7.   `caption` varchar(200) NOT NULL,
  8.   `imagecol` varchar(45) NOT NULL,
  9.   `modified` DATETIME DEFAULT NULL,
  10.   PRIMARY KEY (`id`),
  11.   FOREIGN KEY (`Photographer_id`) REFERENCES `Article` (`Article_id`),
  12.   FOREIGN KEY (`Tag_id`) REFERENCES `Tag` (`Tag_id`)
  13. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  14.  
  15.  
  16. CREATE TABLE `Article` (
  17.   `id` int(25) NOT NULL,
  18.   `name` varchar(45) NOT NULL,
  19.   `caption` varchar(200) NOT NULL,
  20.   `text` TEXT NOT NULL,
  21.   `articlecol` varchar(45) NOT NULL,
  22.   PRIMARY KEY (`id`),
  23.   FOREIGN KEY (`Author_id`) REFERENCES `Image` (`Image_id`)
  24. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  25.  
  26. CREATE TABLE `Photographer` (
  27.     `id` int(25) NOT NULL,
  28.     `name` varchar(45) NOT NULL,
  29.     PRIMARY KEY (`id`));
  30.    
  31. CREATE TABLE `Tag` (
  32.     `id` int(25) NOT NULL,
  33.     `name` varchar(45) NOT NULL,
  34.     FOREIGN KEY (`Image_id`) REFERENCES `Image`(
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top