Commit6a755ea

committed

test

1 parent9f5d60c commit6a755eaCopy full SHA for 6a755ea

File tree

+10

-0

lines changed

stubbornjava-cms-server/src/main/resources/db/cms/migration
- V_2018.02.16.1__initial-schema.sql

+10

-0

lines changed

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -56,3 +56,13 @@ CREATE TABLE IF NOT EXISTS post_tag_links (`
`56`	`56`	CONSTRAINT`post_tag_links_post_id_fk`FOREIGN KEY (`post_id`)REFERENCES`post` (`post_id`),
`57`	`57`	CONSTRAINT`post_tag_links_post_tag_id_fk`FOREIGN KEY (`post_tag_id`)REFERENCES`post_tag` (`post_tag_id`)
`58`	`58`	`) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`
	`59`	`+`
	`60`	`+CREATETABLEIF NOT EXISTS post_github_file_links (`
	`61`	`+ post_idBIGINTNOT NULL,`
	`62`	`+ github_ownervarchar(255)NOT NULL,`
	`63`	`+ github_repovarchar(255)NOT NULL,`
	`64`	`+ namevarchar(255)NOT NULL,`
	`65`	`+ file_pathTEXTNOT NULL,`
	`66`	`+PRIMARY KEY (post_id, github_owner, github_repo, name),`
	`67`	+CONSTRAINT`post_tag_links_post_id_fk`FOREIGN KEY (`post_id`)REFERENCES`post` (`post_id`),
	`68`	`+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;`

Comments

(0)