| .. | .. |
|---|
| 9 | 9 | CREATE TABLE IF NOT EXISTS user ( |
|---|
| 10 | 10 | username VARCHAR(45) NOT NULL , |
|---|
| 11 | 11 | password VARCHAR(100) NULL , |
|---|
| 12 | | - roles INT NULL , |
|---|
| 13 | | - full_name VARCHAR(100) NULL , |
|---|
| 14 | | - short_name VARCHAR(3) NULL , |
|---|
| 12 | + roles INT NOT NULL default 0, |
|---|
| 13 | + first_name VARCHAR(100) NULL , |
|---|
| 14 | + last_name VARCHAR(100) NULL , |
|---|
| 15 | 15 | last_login DATETIME NULL , |
|---|
| 16 | 16 | lang VARCHAR(10) NULL , |
|---|
| 17 | 17 | creation_timestamp DATETIME NULL , |
|---|
| .. | .. |
|---|
| 49 | 49 | |
|---|
| 50 | 50 | drop table IF EXISTS user_organization; |
|---|
| 51 | 51 | CREATE TABLE IF NOT EXISTS user_organization ( |
|---|
| 52 | | - user_id INT NOT NULL, |
|---|
| 52 | + username VARCHAR(45) NOT NULL, |
|---|
| 53 | 53 | organization_id INT NOT NULL, |
|---|
| 54 | | - PRIMARY KEY (user_id, organization_id)); |
|---|
| 54 | + PRIMARY KEY (username, organization_id)); |
|---|
| 55 | 55 | |
|---|
| 56 | 56 | drop table IF EXISTS pack; |
|---|
| 57 | 57 | CREATE TABLE IF NOT EXISTS pack ( |
|---|
