Skip to content

Commit d743b3b

Browse files
billoneilbilloneil
committed
Switch bigint to int
1 parent 59b0a08 commit d743b3b

File tree

9 files changed

+43
-40
lines changed

9 files changed

+43
-40
lines changed

‎stubbornjava-cms-server/src/generated/java/com/stubbornjava/cms/server/generated/Indexes.java

Lines changed: 2 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎stubbornjava-cms-server/src/generated/java/com/stubbornjava/cms/server/generated/Keys.java

Lines changed: 2 additions & 2 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎stubbornjava-cms-server/src/generated/java/com/stubbornjava/cms/server/generated/tables/PostTable.java

Lines changed: 2 additions & 2 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎stubbornjava-cms-server/src/generated/java/com/stubbornjava/cms/server/generated/tables/PostTagLinksTable.java

Lines changed: 2 additions & 2 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎stubbornjava-cms-server/src/generated/java/com/stubbornjava/cms/server/generated/tables/PostTagTable.java

Lines changed: 3 additions & 3 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎stubbornjava-cms-server/src/generated/java/com/stubbornjava/cms/server/generated/tables/records/PostTagLinksRecord.java

Lines changed: 14 additions & 14 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎stubbornjava-cms-server/src/generated/java/com/stubbornjava/cms/server/generated/tables/records/PostTagRecord.java

Lines changed: 14 additions & 14 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎stubbornjava-cms-server/src/main/java/com/stubbornjava/cms/server/post/PostTag.java

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
@Builder(toBuilder=true)
1111
@AllArgsConstructor
1212
public class PostTag {
13-
private final Long postTagId;
13+
private final Integer postTagId;
1414
private final Integer appId;
1515
private final String name;
1616
private final LocalDateTime lastUpdateTs;

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

Lines changed: 3 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS user (
2222
insert into user (email_hash, email, active, date_created_ts, date_updated_ts) values (md5('bill@dartalley.com'), 'bill@dartalley.com', true, now(), now());
2323

2424
CREATE TABLE IF NOT EXISTS post_tag (
25-
post_tag_id BIGINT NOT NULL AUTO_INCREMENT,
25+
post_tag_id INT NOT NULL AUTO_INCREMENT,
2626
app_id INT NOT NULL,
2727
name VARCHAR(255) NOT NULL,
2828
last_update_ts DATETIME NOT NULL,
@@ -45,12 +45,13 @@ CREATE TABLE IF NOT EXISTS post (
4545
content_template MEDIUMTEXT DEFAULT NULL,
4646
PRIMARY KEY (post_id),
4747
UNIQUE KEY `app_id_slug` (app_id, slug),
48+
KEY `date_created_idx` (date_created),
4849
CONSTRAINT `post_app_id_fk` FOREIGN KEY (`app_id`) REFERENCES `app` (`app_id`)
4950
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
5051

5152
CREATE TABLE IF NOT EXISTS post_tag_links (
5253
post_id BIGINT NOT NULL,
53-
post_tag_id BIGINT NOT NULL,
54+
post_tag_id INT NOT NULL,
5455
PRIMARY KEY (post_id, post_tag_id),
5556
CONSTRAINT `post_tag_links_post_id_fk` FOREIGN KEY (`post_id`) REFERENCES `post` (`post_id`),
5657
CONSTRAINT `post_tag_links_post_tag_id_fk` FOREIGN KEY (`post_tag_id`) REFERENCES `post_tag` (`post_tag_id`)

0 commit comments

Comments
 (0)