38 lines
2.3 KiB
SQL
38 lines
2.3 KiB
SQL
## V 0.223
|
|
|
|
INSERT INTO language (id, name, name_eng) VALUES (1, 'English', 'English');
|
|
INSERT INTO language (id, name, name_eng) VALUES (2, 'German', 'German');
|
|
INSERT INTO language (id, name, name_eng) VALUES (3, 'Italian', 'Italian');
|
|
INSERT INTO language (id, name, name_eng) VALUES (4, 'Spanish', 'Spanish');
|
|
INSERT INTO language (id, name, name_eng) VALUES (5, 'Portugese', 'Portugese');
|
|
INSERT INTO language (id, name, name_eng) VALUES (6, 'Dutch', 'Dutch');
|
|
|
|
|
|
|
|
## V 0.223_2
|
|
UPDATE l_topic set name='Politics, democratic system, political participation, political parties, populism, LR placement' where id=1;
|
|
UPDATE l_topic set name='Citizenship, volunteering' where id=2;
|
|
UPDATE l_topic set name='Welfare stare, welfare attitudes, welfare chauvinism' where id=3;
|
|
UPDATE l_topic set name='Post-socialism, transition' where id=4;
|
|
UPDATE l_topic set name='Social inequalities, social class, social mobility' where id=5;
|
|
UPDATE l_topic set name='Immigration issues, ethnic diversity, ethnic discrimination' where id=6;
|
|
UPDATE l_topic set name='Nation, national identity' where id=7;
|
|
UPDATE l_topic set name='Crime, criminal justice, corruption' where id=8;
|
|
UPDATE l_topic set name='Economy, financial crisis, economic values, consumerism' where id=9;
|
|
UPDATE l_topic set name='Subjective well-being, happiness, life satisfaction, quality of life' where id=10;
|
|
UPDATE l_topic set name='Health, subjective health, health system ' where id=11;
|
|
UPDATE l_topic set name='Culture, values' where id=12;
|
|
UPDATE l_topic set name='Social capital, trust, social networks' where id=13;
|
|
UPDATE l_topic set name='Family, family roles, norms, work-life balance, family planning' where id=14;
|
|
UPDATE l_topic set name='Paid work, labour market, industrial relations, trade unions' where id=15;
|
|
UPDATE l_topic set name='Media, internet, ICT' where id=16;
|
|
UPDATE l_topic set name='Religion, religiosity, religious change' where id=17;
|
|
UPDATE l_topic set name='Education, skills, educational inequalities' where id=18;
|
|
UPDATE l_topic set name='Age groups, ageism, the elderly, the young' where id=19;
|
|
UPDATE l_topic set name='Gender issues, gender roles' where id=20;
|
|
UPDATE l_topic set name='Environment, climate change' where id=21;
|
|
UPDATE l_topic set name='Europe, European Union, euroscepticism' where id=22;
|
|
UPDATE l_topic set name='Survey methods' where id=99;
|
|
INSERT INTO l_topic VALUES (49, 'Covid-19 pandemic');
|
|
|