XtEKuv10

1CREATE TABLE IF NOT EXISTS USER_PROFILE (
2  id                BIGINT       NOT NULL AUTO_INCREMENT,
3  user_id           BIGINT       NOT NULL,      
4  name              VARCHAR(100) NOT NULL,
5  username          VARCHAR(100) NOT NULL,
6  mobile            BIGINT       NOT NULL,      
7  description       VARCHAR(100),
8  created_date      DATETIME,
9  modified_date     DATETIME,
10  PRIMARY KEY (id),
11  UNIQUE (user_id)
12); 
13     
14CREATE TABLE IF NOT EXISTS USER_DESCRIPTION_HISTORY (
15  id           BIGINT        NOT NULL   AUTO_INCREMENT,
16  user_id      BIGINT        NOT NULL,
17  description  VARCHAR(100),
18  dt_datetime  DATETIME      NOT NULL   DEFAULT CURRENT_TIMESTAMP,
19  PRIMARY KEY(id),
20  CONSTRAINT FOREIGN KEY (user_id) REFERENCES USER_PROFILE (id)  
21);