Revize ff7b51d3
Přidáno uživatelem Jiří Trefil před více než 1 rok
| db/spawn/spade-configurations.sql | ||
|---|---|---|
| 5 | 5 |
id int identity(1, 1), |
| 6 | 6 |
configHash nvarchar(255), |
| 7 | 7 |
config nvarchar(max) not null, |
| 8 |
isDefault char(1) not null CHECK ( 'Y', 'N' ),
|
|
| 8 |
isDefault char(1) not null, |
|
| 9 | 9 |
defaultConfigName nvarchar(255), |
| 10 | 10 |
PRIMARY KEY(id) |
| 11 | 11 |
); |
| ... | ... | |
| 172 | 172 |
|
| 173 | 173 |
|
| 174 | 174 |
) |
| 175 |
insert into user_configurations(userId,configId,configurationName) values (1,1,'default config') |
|
| 176 | 175 |
|
| 177 |
commit |
|
| 176 |
commit |
|
Také k dispozici: Unified diff
Update spade-configurations.sql
vyhozen insert default usera - nepouziva se. Vyhozen check constraint, neni validni sql syntax