Revize ba18288a

#10523 refactor datoveho modelu

db/spade-configurations.sql

@@ -17 +17 @@
 password varchar(255) not null
 PRIMARY KEY(id)
 );
-
-
+--declare @userId as int
+insert into users(email,name,password) values('[e-mail]','default','2747CABBB481A433679F6DC8AAE833DD1B64452778B97E2729BD3C54DEDE0886')
+--set @userId = (select id from users where name='default')
 --rozkladova tabulka mapujici uzivatele a k nemu asociovane konfigurace
 if not exists (select * from sysobjects where name='user_configurations' and xtype='U')
 create table user_configurations (
 	userId int not null,
 	configId int not null,
+    configurationName nvarchar(255) not null,
 	foreign key(userId) references users(id),
 	foreign key(configId) references configurations(id),
 	primary key(userId,configId)
@@ -105 +107 @@
                 },
                 {
                     "thresholdName": "searchSubstringsWithProjectPlan",
-                    "value": "%pl?n projektu%||%project plan%||%plan project%||%projektov? pl?n%"
+                    "value": "%pl�n projektu%||%project plan%||%plan project%||%projektov� pl�n%"
                 }
             ]
         },
@@ -122 +124 @@
                 },
                 {
                     "thresholdName": "searchSubstringsWithFeedbackLoop",
-                    "value": "%sch?z%z?kazn?k%||%p?edveden?%z?kazn?k%||%z?kazn%demo%||%sch?z%zadavat%||%inform%sch?z%||%z?kazn%||%zadavatel%"
+                    "value": "%sch�z%z�kazn�k%||%p�edveden�%z�kazn�k%||%z�kazn%demo%||%sch�z%zadavat%||%inform%sch�z%||%z�kazn%||%zadavatel%"
                 }
             ]
         },
@@ -180 +182 @@
 
 
 )
+insert into user_configurations(userId,configId,configurationName) values (1,1,'default config')
 
-commit
+commit