| .. | .. |
|---|
| 68 | 68 | CREATE TABLE IF NOT EXISTS license ( |
|---|
| 69 | 69 | id INT NOT NULL, |
|---|
| 70 | 70 | code VARCHAR(100) NOT NULL , |
|---|
| 71 | + request_data VARCHAR(1024) NULL , |
|---|
| 72 | + license_data VARCHAR(1024) NULL , |
|---|
| 71 | 73 | pack_id INT NOT NULL, |
|---|
| 72 | | - user_name INT NULL, |
|---|
| 73 | | - user_email INT NOT NULL, |
|---|
| 74 | + full_name VARCHAR(150) NULL, |
|---|
| 75 | + email VARCHAR(100) NOT NULL, |
|---|
| 74 | 76 | creation_timestamp DATETIME NOT NULL , |
|---|
| 75 | | - sent_timestamp DATETIME NULL , |
|---|
| 77 | + send_timestamp DATETIME NULL , |
|---|
| 76 | 78 | modification_timestamp DATETIME NULL , |
|---|
| 79 | + activation_timestamp DATETIME NULL , |
|---|
| 77 | 80 | cancelation_timestamp DATETIME NULL , |
|---|
| 81 | + last_access_timestamp DATETIME NULL , |
|---|
| 78 | 82 | canceled_by varchar(45) NULL , |
|---|
| 79 | 83 | created_by varchar(45) NULL , |
|---|
| 80 | | - status VARCHAR(3) NULL , |
|---|
| 84 | + status VARCHAR(3) NOT NULL default 0, |
|---|
| 81 | 85 | PRIMARY KEY (id)); |
|---|
| 82 | 86 | |
|---|
| 83 | 87 | |
|---|
