| .. | .. |
|---|
| 76 | 76 | email VARCHAR(100) NOT NULL, |
|---|
| 77 | 77 | comments VARCHAR(1024) NULL , |
|---|
| 78 | 78 | creation_timestamp DATETIME NOT NULL , |
|---|
| 79 | | - send_timestamp DATETIME NULL , |
|---|
| 80 | 79 | modification_timestamp DATETIME NULL , |
|---|
| 81 | | - activation_timestamp DATETIME NULL , |
|---|
| 82 | | - cancelation_timestamp DATETIME NULL , |
|---|
| 83 | 80 | last_access_timestamp DATETIME NULL , |
|---|
| 84 | 81 | canceled_by varchar(45) NULL , |
|---|
| 85 | 82 | created_by varchar(45) NULL , |
|---|
| 86 | | - status VARCHAR(3) NOT NULL default 0, |
|---|
| 83 | + status INT NOT NULL default 0, |
|---|
| 84 | + PRIMARY KEY (id)); |
|---|
| 85 | + |
|---|
| 86 | + |
|---|
| 87 | +drop table IF EXISTS license_history; |
|---|
| 88 | +CREATE TABLE IF NOT EXISTS license_history ( |
|---|
| 89 | + id INT NOT NULL auto_increment, |
|---|
| 90 | + license_id INT NOT NULL, |
|---|
| 91 | + username VARCHAR(45) NOT NULL, |
|---|
| 92 | + timestamp DATETIME NOT NULL , |
|---|
| 93 | + action VARCHAR(40) , |
|---|
| 94 | + comments VARCHAR(512) , |
|---|
| 87 | 95 | PRIMARY KEY (id)); |
|---|
| 88 | 96 | |
|---|
| 89 | 97 | |
|---|
