| .. | .. |
|---|
| 1 | +drop table IF EXISTS settings; |
|---|
| 2 | +CREATE TABLE IF NOT EXISTS settings ( |
|---|
| 3 | + key VARCHAR(100) NOT NULL , |
|---|
| 4 | + value VARCHAR(2000) NULL , |
|---|
| 5 | + timestamp DATETIME NOT NULL DEFAULT now() , |
|---|
| 6 | + PRIMARY KEY (key) ); |
|---|
| 7 | + |
|---|
| 8 | +drop table IF EXISTS user; |
|---|
| 9 | +CREATE TABLE IF NOT EXISTS user ( |
|---|
| 10 | + username VARCHAR(45) NOT NULL , |
|---|
| 11 | + password VARCHAR(100) NULL , |
|---|
| 12 | + roles INT NULL , |
|---|
| 13 | + full_name VARCHAR(100) NULL , |
|---|
| 14 | + short_name VARCHAR(3) NULL , |
|---|
| 15 | + last_login DATETIME NULL , |
|---|
| 16 | + lang VARCHAR(10) NULL , |
|---|
| 17 | + creation_timestamp DATETIME NULL , |
|---|
| 18 | + modification_timestamp DATETIME NULL , |
|---|
| 19 | + PRIMARY KEY (username)); |
|---|
| 20 | + |
|---|
| 21 | +drop table IF EXISTS application; |
|---|
| 22 | +CREATE TABLE IF NOT EXISTS application ( |
|---|
| 23 | + id INT NOT NULL, |
|---|
| 24 | + name VARCHAR(45) NOT NULL , |
|---|
| 25 | + description VARCHAR(500) NULL , |
|---|
| 26 | + creation_timestamp DATETIME NULL , |
|---|
| 27 | + PRIMARY KEY (id)); |
|---|
| 28 | + |
|---|
| 29 | + |
|---|
| 30 | +drop table IF EXISTS license_type; |
|---|
| 31 | +CREATE TABLE IF NOT EXISTS license_type ( |
|---|
| 32 | + id INT NOT NULL, |
|---|
| 33 | + code VARCHAR(10) NOT NULL , |
|---|
| 34 | + name VARCHAR(45) NOT NULL , |
|---|
| 35 | + description VARCHAR(100) NULL , |
|---|
| 36 | + application_id INT NULL , |
|---|
| 37 | + creation_timestamp DATETIME NULL , |
|---|
| 38 | + PRIMARY KEY (id)); |
|---|
| 39 | + |
|---|
| 40 | +drop table IF EXISTS organization; |
|---|
| 41 | +CREATE TABLE IF NOT EXISTS organization ( |
|---|
| 42 | + id INT NOT NULL auto_increment, |
|---|
| 43 | + code VARCHAR(10) NOT NULL , |
|---|
| 44 | + name VARCHAR(45) NOT NULL , |
|---|
| 45 | + description VARCHAR(100) NULL , |
|---|
| 46 | + org_parent_id INT NULL , |
|---|
| 47 | + creation_timestamp DATETIME NULL , |
|---|
| 48 | + PRIMARY KEY (id)); |
|---|
| 49 | + |
|---|
| 50 | +drop table IF EXISTS user_organization; |
|---|
| 51 | +CREATE TABLE IF NOT EXISTS user_organization ( |
|---|
| 52 | + user_id INT NOT NULL, |
|---|
| 53 | + organization_id INT NOT NULL, |
|---|
| 54 | + PRIMARY KEY (user_id, organization_id)); |
|---|
| 55 | + |
|---|
| 56 | +drop table IF EXISTS pack; |
|---|
| 57 | +CREATE TABLE IF NOT EXISTS pack ( |
|---|
| 58 | + id INT NOT NULL, |
|---|
| 59 | + code VARCHAR(50) NOT NULL , |
|---|
| 60 | + num_licenses INT NOT NULL , |
|---|
| 61 | + license_type_id INT NOT NULL, |
|---|
| 62 | + organization_id INT NOT NULL, |
|---|
| 63 | + created_by varchar(45) NULL , |
|---|
| 64 | + creation_timestamp DATETIME NOT NULL , |
|---|
| 65 | + PRIMARY KEY (id)); |
|---|
| 66 | + |
|---|
| 67 | +drop table IF EXISTS license; |
|---|
| 68 | +CREATE TABLE IF NOT EXISTS license ( |
|---|
| 69 | + id INT NOT NULL, |
|---|
| 70 | + code VARCHAR(100) NOT NULL , |
|---|
| 71 | + pack_id INT NOT NULL, |
|---|
| 72 | + user_name INT NULL, |
|---|
| 73 | + user_email INT NOT NULL, |
|---|
| 74 | + creation_timestamp DATETIME NOT NULL , |
|---|
| 75 | + sent_timestamp DATETIME NULL , |
|---|
| 76 | + modification_timestamp DATETIME NULL , |
|---|
| 77 | + cancelation_timestamp DATETIME NULL , |
|---|
| 78 | + canceled_by varchar(45) NULL , |
|---|
| 79 | + created_by varchar(45) NULL , |
|---|
| 80 | + status VARCHAR(3) NULL , |
|---|
| 81 | + PRIMARY KEY (id)); |
|---|
| 82 | + |
|---|
| 83 | + |
|---|
| 84 | + |
|---|
