nofuzz-tutorial-blog-api/doc/schema.mysql.sql at master · Celarius/nofuzz-tutorial-blog-api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
/*******************************************************************************
 * Selected metadata objects
 * -------------------------
 * Extracted at 2017-03-12 01:43:23
 ******************************************************************************/

/*******************************************************************************
 * Tables
 * ------
 * Extracted at 2017-03-12 01:43:23
 ******************************************************************************/

CREATE TABLE blog_accounts (
  id            BigInt(20) NOT NULL AUTO_INCREMENT,
  created_dt    Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  modified_dt   Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  uuid          NVarChar(64) COLLATE utf8_general_ci,
  login_name    NVarChar(32) COLLATE utf8_general_ci,
  first_name    NVarChar(32) COLLATE utf8_general_ci,
  last_name     NVarChar(32) COLLATE utf8_general_ci,
  email         NVarChar(128) COLLATE utf8_general_ci,
  jwt_secret    NVarChar(64) COLLATE utf8_general_ci,
  pw_salt       NVarChar(128) COLLATE utf8_general_ci,
  pw_hash       NVarChar(128) COLLATE utf8_general_ci,
  pw_iterations Integer(11) DEFAULT 1,
  status        SmallInt(6) DEFAULT 0,
  PRIMARY KEY (
      id
  )
) ENGINE=InnoDB AUTO_INCREMENT=20 ROW_FORMAT=DYNAMIC DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE blog_accounts COMMENT = '';
CREATE TABLE blog_articles (
  id          BigInt(20) NOT NULL AUTO_INCREMENT,
  created_dt  Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  modified_dt Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  uuid        NVarChar(64) COLLATE utf8_general_ci,
  blog_id     BigInt(20) NOT NULL,
  title       NVarChar(128) COLLATE utf8_general_ci,
  body        MediumText CHARACTER SET utf8 COLLATE utf8_general_ci,
  status      SmallInt(6) DEFAULT 0,
  PRIMARY KEY (
      id
  )
) ENGINE=InnoDB AUTO_INCREMENT=1 ROW_FORMAT=DYNAMIC DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE blog_articles COMMENT = '';
CREATE TABLE blog_blogs (
  id          BigInt(20) NOT NULL AUTO_INCREMENT,
  created_dt  Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  modified_dt Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  uuid        NVarChar(64) COLLATE utf8_general_ci,
  account_id  BigInt(20) NOT NULL,
  title       NVarChar(128) COLLATE utf8_general_ci,
  description Text CHARACTER SET utf8 COLLATE utf8_general_ci,
  status      SmallInt(6) DEFAULT 0,
  PRIMARY KEY (
      id
  )
) ENGINE=InnoDB AUTO_INCREMENT=1 ROW_FORMAT=DYNAMIC DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE blog_blogs COMMENT = '';
CREATE TABLE blog_comments (
  id          BigInt(20) NOT NULL AUTO_INCREMENT,
  created_dt  Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  modified_dt Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  uuid        NVarChar(64) COLLATE utf8_general_ci,
  article_id  BigInt(20) NOT NULL,
  account_id  BigInt(20) NOT NULL,
  `comment`   Text CHARACTER SET utf8 COLLATE utf8_general_ci,
  status      SmallInt(6) DEFAULT 0,
  PRIMARY KEY (
      id
  )
) ENGINE=InnoDB AUTO_INCREMENT=1 ROW_FORMAT=DYNAMIC DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE blog_comments COMMENT = '';
CREATE TABLE blog_tokens (
  id          BigInt(20) NOT NULL AUTO_INCREMENT,
  created_dt  Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  modified_dt Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  sessionid   NVarChar(64) COLLATE utf8_general_ci,
  account_id  BigInt(20) NOT NULL,
  expires_dt  Timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  status      SmallInt(6) DEFAULT 0,
  PRIMARY KEY (
      id
  )
) ENGINE=InnoDB AUTO_INCREMENT=1 ROW_FORMAT=DYNAMIC DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE blog_tokens COMMENT = '';