|
1
|
use salarymarket ;
|
|
2
|
INSERT INTO solution_setting_business_sector (id, code) VALUES
|
|
3
|
(1,'BS01'),
|
|
4
|
(2,'BS02'),
|
|
5
|
(3,'BS03'),
|
|
6
|
(4,'BS04'),
|
|
7
|
(5,'BS05');
|
|
8
|
INSERT INTO solution_setting_business_sector_translate (label, businessSectorCode, languageId) VALUES
|
|
9
|
('Marché général','BS01', 2),('General market','BS01', 1),
|
|
10
|
('Marché Banque et Assurance','BS02', 2),('Banking and Insurance Market','BS02', 1),
|
|
11
|
('Marché pharmaceutique','BS03', 2),('Pharmaceutical market','BS03', 1),
|
|
12
|
('Marché industriel','BS04', 2),('Industrial market','BS04', 2),
|
|
13
|
('Marché technologies de l''information','BS05', 2),('Information technology market','BS05', 1);
|
|
14
|
|
|
15
|
INSERT INTO solution_setting_sub_sector(code,businessSectorCode) VALUES
|
|
16
|
('BS02S01' ,'BS02') ,
|
|
17
|
('BS02S02' ,'BS02'),
|
|
18
|
('BS02S03' ,'BS02');
|
|
19
|
INSERT INTO solution_setting_sub_sector_translate(Label,subSectorCode,languageId) VALUES
|
|
20
|
('Assurance','BS02S01',2),('Insurance','BS02S01',1),
|
|
21
|
('Banque et établisement financier','BS02S02',2),('Banking and Financial Institutions','BS02S02',1),
|
|
22
|
('Microfinance','BS02S03',2),('Microfinance','BS02S03',1);
|
|
23
|
|
|
24
|
INSERT INTO solution_setting_sub_sector(code,businessSectorCode) VALUES
|
|
25
|
('BS03S01' ,'BS03'),
|
|
26
|
('BS03S02' ,'BS03');
|
|
27
|
INSERT INTO solution_setting_sub_sector_translate(Label,subSectorCode,languageId) VALUES
|
|
28
|
('Distribution pharmaceutique et parapharmaceutique','BS03S01',2),('Pharmaceutical and Parapharmaceutical Distribution','BS03S01',1),
|
|
29
|
('Industrie pharmaceutique','BS03S02',2),('Pharmaceutical Industry','BS03S02',1);
|
|
30
|
|
|
31
|
INSERT INTO solution_setting_sub_sector(code,businessSectorCode) VALUES
|
|
32
|
('BS05S01' ,'BS05'),
|
|
33
|
('BS05S02' ,'BS05'),
|
|
34
|
('BS05S03' ,'BS05'),
|
|
35
|
('BS05S04' ,'BS05'),
|
|
36
|
('BS05S05' ,'BS05'),
|
|
37
|
('BS05S06' ,'BS05');
|
|
38
|
INSERT INTO solution_setting_sub_sector_translate(Label,subSectorCode,languageId) VALUES
|
|
39
|
('Développement Electrique et Electronique','BS05S01',2),('Electrical and Electronic Development','BS05S01',1),
|
|
40
|
('Technologie de l’information','BS05S02',2),('Information Technology','BS05S02',1),
|
|
41
|
('Télécommunication','BS05S03',2),('Telecommunications','BS05S03',1),
|
|
42
|
('Entreprise de service numérique','BS05S04',2),('Digital service company','BS05S04',1),
|
|
43
|
('Fintech','BS05S05',2),('Fintech','BS05S05',1),
|
|
44
|
('Recherche et développement technlologique','BS05S06',2),('Technological research and development','BS05S06',1);
|
|
45
|
|
|
46
|
INSERT INTO solution_setting_sub_sector(code,businessSectorCode) VALUES
|
|
47
|
('BS04S01' ,'BS04'),
|
|
48
|
('BS04S02' ,'BS04'),
|
|
49
|
('BS04S03' ,'BS04'),
|
|
50
|
('BS04S04' ,'BS04'),
|
|
51
|
('BS04S05' ,'BS04'),
|
|
52
|
('BS04S06' ,'BS04'),
|
|
53
|
('BS04S07' ,'BS04'),
|
|
54
|
('BS04S08' ,'BS04'),
|
|
55
|
('BS04S09' ,'BS04'),
|
|
56
|
('BS04S10' ,'BS04'),
|
|
57
|
('BS04S11' ,'BS04'),
|
|
58
|
('BS04S12' ,'BS04'),
|
|
59
|
('BS04S13' ,'BS04'),
|
|
60
|
('BS04S14' ,'BS04'),
|
|
61
|
('BS04S15' ,'BS04'),
|
|
62
|
('BS04S16' ,'BS04');
|
|
63
|
INSERT INTO solution_setting_sub_sector_translate(Label,subSectorCode,languageId) VALUES
|
|
64
|
('Industrie de Plasturgie et d''emballage','BS04S01',2),('Plastics and Packaging Industry','BS04S01',1),
|
|
65
|
('Industrie ferroviaire','BS04S02',2),('Railway Industry','BS04S02',1),
|
|
66
|
('Industrie du bois et d''ameublement','BS04S03',2),('Wood and Furniture Industry','BS04S03',1),
|
|
67
|
('Industrie du papier et du carton','BS04S04',2),('Paper and Cardboard Industry','BS04S04',1),
|
|
68
|
('Industrie textile et d’habillement','BS04S05',2),('Textile and Clothing Industry','BS04S05',1),
|
|
69
|
('Industrie automobile','BS04S06',2),('Automotive Industry','BS04S06',1),
|
|
70
|
('Industrie Electrique et Electronique','BS04S07',2),('Electrical and Electronic Industry','BS04S07',1),
|
|
71
|
('Industrie agricole et agroalimentaire','BS04S08',2),('Agricultural and Agri-Food Industry','BS04S08',1),
|
|
72
|
('Secteur de la pétrochimie','BS04S09',2),('Petrochemical Sector','BS04S09',1),
|
|
73
|
('Industrie du cuir','BS04S10',2),('Leather industry','BS04S10',1),
|
|
74
|
('Industrie chimique','BS04S11',2),('Chemical Industry','BS04S11',1),
|
|
75
|
('Industrie de la peinture','BS04S12',2),('Paint Industry','BS04S12',1),
|
|
76
|
('Industrie de conserve et semi-concerne et de conditionnement d''huile','BS04S13',2),('Oil Canning and Semi-Canned and Packaging Industry','BS04S13',1),
|
|
77
|
('Industrie métallurgique','BS04S14',2),('Metallurgy Industry','BS04S14',1),
|
|
78
|
('Industrie de fabrication des produits de toilettes et de parfumerie','BS04S15',2),('Toiletries and Perfumery Manufacturing Industry','BS04S15',1),
|
|
79
|
('Industrie aéronautique ','BS04S16',2),('Aeronautical industry','BS04S16',1);
|
|
80
|
|
|
81
|
INSERT INTO solution_setting_sub_sector(code,businessSectorCode) VALUES
|
|
82
|
('BS01S01' ,'BS01'),
|
|
83
|
('BS01S02' ,'BS01'),
|
|
84
|
('BS01S03' ,'BS01'),
|
|
85
|
('BS01S04' ,'BS01'),
|
|
86
|
('BS01S05' ,'BS01'),
|
|
87
|
('BS01S06' ,'BS01'),
|
|
88
|
('BS01S07' ,'BS01'),
|
|
89
|
('BS01S08' ,'BS01'),
|
|
90
|
('BS01S09' ,'BS01'),
|
|
91
|
('BS01S10' ,'BS01'),
|
|
92
|
('BS01S11' ,'BS01'),
|
|
93
|
('BS01S12' ,'BS01'),
|
|
94
|
('BS01S13' ,'BS01'),
|
|
95
|
('BS01S14' ,'BS01'),
|
|
96
|
('BS01S15' ,'BS01'),
|
|
97
|
('BS01S16' ,'BS01'),
|
|
98
|
('BS01S17' ,'BS01'),
|
|
99
|
('BS01S18' ,'BS01'),
|
|
100
|
('BS01S19' ,'BS01'),
|
|
101
|
('BS01S20' ,'BS01'),
|
|
102
|
('BS01S21' ,'BS01'),
|
|
103
|
('BS01S22' ,'BS01'),
|
|
104
|
('BS01S23' ,'BS01'),
|
|
105
|
('BS01S24' ,'BS01'),
|
|
106
|
('BS01S25' ,'BS01'),
|
|
107
|
('BS01S26' ,'BS01'),
|
|
108
|
('BS01S27' ,'BS01'),
|
|
109
|
('BS01S28' ,'BS01'),
|
|
110
|
('BS01S29' ,'BS01'),
|
|
111
|
('BS01S30' ,'BS01'),
|
|
112
|
('BS01S31' ,'BS01'),
|
|
113
|
('BS01S32' ,'BS01'),
|
|
114
|
('BS01S33' ,'BS01'),
|
|
115
|
('BS01S34' ,'BS01'),
|
|
116
|
('BS01S35' ,'BS01'),
|
|
117
|
('BS01S36' ,'BS01'),
|
|
118
|
('BS01S37' ,'BS01'),
|
|
119
|
('BS01S38' ,'BS01'),
|
|
120
|
('BS01S39' ,'BS01'),
|
|
121
|
('BS01S40' ,'BS01'),
|
|
122
|
('BS01S41' ,'BS01');
|
|
123
|
INSERT INTO solution_setting_sub_sector_translate(Label,subSectorCode,languageId) VALUES
|
|
124
|
('Industrie de Plasturgie et d''emballage','BS01S01',2),('Plastics and Packaging Industry','BS01S01',1),
|
|
125
|
('Industrie ferroviaire','BS01S02',2),('Railway Industry','BS01S02',1),
|
|
126
|
('Industrie du bois et d''ameublement','BS01S03',2),('Wood and Furniture Industry','BS01S03',1),
|
|
127
|
('Industrie du papier et du carton','BS01S04',2),('Paper and Cardboard Industry','BS01S04',1),
|
|
128
|
('Industrie textile et d’habillement','BS01S05',2),('Textile and Clothing Industry','BS01S05',1),
|
|
129
|
('Industrie automobile','BS01S06',2),('Automotive Industry','BS01S06',1),
|
|
130
|
('Industrie Electrique et Electronique','BS01S07',2),('Electrical and Electronic Industry','BS01S07',1),
|
|
131
|
('Industrie agricole et agroalimentaire','BS01S08',2),('Agricultural and Agri-Food Industry','BS01S08',1),
|
|
132
|
('Secteur de la pétrochimie','BS01S09',2),('Petrochemical Sector','BS01S09',1),
|
|
133
|
('Industrie du cuir','BS01S10',2),('Leather industry','BS01S10',1),
|
|
134
|
('Industrie chimique','BS01S11',2),('Chemical Industry','BS01S11',1),
|
|
135
|
('Industrie de la peinture','BS01S12',2),('Paint Industry','BS01S12',1),
|
|
136
|
('Industrie de conserve et semi-concerne et de conditionnement d''huile','BS01S13',2),('Oil Canning and Semi-Canned and Packaging Industry','BS01S13',1),
|
|
137
|
('Industrie métallurgique','BS01S14',2),('Metallurgy Industry','BS01S14',1),
|
|
138
|
('Industrie de fabrication des produits de toilettes et de parfumerie','BS01S15',2),('Toiletries and Perfumery Manufacturing Industry','BS01S15',1),
|
|
139
|
('Industrie aéronautique ','BS01S16',2),('Aeronautical industry','BS01S16',1),
|
|
140
|
('Services logistiques','BS01S17',2),('Logistics Services','BS01S17',1),
|
|
141
|
('Commerce de gros, semi-gros et en détails','BS01S18',2),('Wholesale, Semi-Wholesale and Retail Trade','BS01S18',1),
|
|
142
|
('Commerce des matériaux de consutruction et du bois','BS01S19',2),('Trade in Building Materials and Wood','BS01S19',1),
|
|
143
|
('Hébergement et restauration','BS01S20',2),('Accommodation and Catering','BS01S20',1),
|
|
144
|
('Bâtiment et travaux publics','BS01S21',2),('Construction and Public Works','BS01S21',1),
|
|
145
|
('Agriculture, sylviculture et pêche','BS01S22',2),('Agriculture, Forestry and Fishing','BS01S22',1),
|
|
146
|
('Concessionnaire automobile','BS01S23',2),('Car Dealership','BS01S23',1),
|
|
147
|
('Réparation automobile','BS01S24',2),('Automotive Repair','BS01S24',1),
|
|
148
|
('Grande distribution','BS01S25',2),('Large-Scale Retailing','BS01S25',1),
|
|
149
|
('Energie renouvelable','BS01S26',2),('Renewable Energy','BS01S26',1),
|
|
150
|
('Association et ONG','BS01S27',2),('Associations and NGOs','BS01S27',1),
|
|
151
|
('Audiovisuel et média','BS01S28',2),('Audiovisual and Media','BS01S28',1),
|
|
152
|
('Transport','BS01S29',2),('Transportation','BS01S29',1),
|
|
153
|
('Sport et loisirs','BS01S30',2),('Sports and Leisure','BS01S30',1),
|
|
154
|
('Traitement de déchets liquide et solide','BS01S31',2),('Liquid and Solid Waste Treatment','BS01S31',1),
|
|
155
|
('Agence de voyage','BS01S32',2),('Travel Agency','BS01S32',1),
|
|
156
|
('Clinique privée','BS01S33',2),('Private Clinic','BS01S33',1),
|
|
157
|
('Commerce et distribution du pétrole et dérivés','BS01S34',2),('Trade and Distribution of Oil and Derivatives','BS01S34',1),
|
|
158
|
('Concessionnaire de matérial agricole et génie civil','BS01S35',2),('Agricultural Equipment and Civil Engineering Dealership','BS01S35',1),
|
|
159
|
('Enseignement privé','BS01S36',2),('Private Education','BS01S36',1),
|
|
160
|
('Secteur des mines','BS01S37',2),('Mining Sector','BS01S37',1),
|
|
161
|
('Gardiennage et sécurité des entreprises','BS01S38',2),('Business Guarding and Security','BS01S38',1),
|
|
162
|
('Autres Services aux entreprises','BS01S39',2),('Business Services Others','BS01S39',1),
|
|
163
|
('Service d''étude et de conseil','BS01S40',2),('Study and consultancy service','BS01S40',1),
|
|
164
|
('Centre de contact et de gestion client','BS01S41',2),('Contact and Customer Management Center','BS01S41',1);
|