Mysql setting constraints - Revision history

George2 at 17:04, 22 January 2019

2019-01-22T17:04:51Z

2019-01-22T12:43:22Z

2019-01-22T12:36:15Z

2019-01-22T12:34:41Z

2019-01-22T12:33:29Z

2019-01-22T12:18:09Z

2019-01-22T12:17:14Z

2019-01-22T12:14:33Z

2019-01-22T12:12:17Z

2019-01-22T12:09:52Z

@@ Line 2: / Line 2: @@
 <source lang="sql">
    CONSTRAINT education_ibfk_1
      FOREIGN KEY (profile_id)
@@ Line 17: / Line 10: @@
      REFERENCES Institution (institution_id)
      ON DELETE CASCADE ON UPDATE CASCADE,

← Older revision		Revision as of 12:43, 22 January 2019
Line 2:		Line 2:

	<source lang="sql">		<source lang="sql">
−		+	CREATE TABLE sslhosts (
		+	hostname varchar(30) NOT NULL,
		+	port int(11) DEFAULT 443,
		+	PRIMARY KEY (hostname)
		+	) ENGINE=InnoDB DEFAULT CHARSET=utf8

@@ Line 22: / Line 22: @@
 FOREIGN KEY (hostname)
 REFERENCES sslhosts (hostname)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 </source>
 http://www.mysqltutorial.org/mysql-primary-key/<br>

@@ Line 22: / Line 22: @@
 FOREIGN KEY (hostname)
 REFERENCES sslhosts (hostname)
-);
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 </source>
 http://www.mysqltutorial.org/mysql-primary-key/<br>

@@ Line 1: / Line 1: @@
 <source lang="sql">
    CONSTRAINT education_ibfk_1
      FOREIGN KEY (profile_id)
@@ Line 17: / Line 22: @@
 FOREIGN KEY (hostname)
 REFERENCES sslhosts (hostname)
 );
 </source>
 http://www.mysqltutorial.org/mysql-primary-key/<br>

@@ Line 15: / Line 15: @@
 notes varchar(100),
 constraint myconst_1
-FOREIGN KEY hostname
+FOREIGN KEY (hostname)
 REFERENCES sslhosts (hostname)
 ON DELETE CASCADE ON UPDATE CASCADE