|
1
|
use salarymarket;
|
|
2
|
INSERT INTO solution_setting_town (id,code,countryCode) VALUES
|
|
3
|
(1, 'ARIANA', 'TN'),
|
|
4
|
(2, 'BEJA', 'TN'),
|
|
5
|
(3, 'BENAROUS', 'TN'),
|
|
6
|
(4, 'BIZERTE', 'TN'),
|
|
7
|
(5, 'GABES', 'TN'),
|
|
8
|
(6, 'GAFSA', 'TN'),
|
|
9
|
(7, 'JENDOUBA', 'TN'),
|
|
10
|
(8, 'KAIROUAN', 'TN'),
|
|
11
|
(9, 'KASSERINE', 'TN'),
|
|
12
|
(10, 'KEBILI', 'TN'),
|
|
13
|
(11, 'KEF', 'TN'),
|
|
14
|
(12, 'MAHDIA', 'TN'),
|
|
15
|
(13, 'MANOUBA', 'TN'),
|
|
16
|
(14, 'MEDENINE', 'TN'),
|
|
17
|
(15, 'MONASTIR', 'TN'),
|
|
18
|
(16, 'NABEUL', 'TN'),
|
|
19
|
(17, 'SFAX', 'TN'),
|
|
20
|
(18, 'SIDIBOUZID', 'TN'),
|
|
21
|
(19, 'SILIANA', 'TN'),
|
|
22
|
(20, 'SOUSSE', 'TN'),
|
|
23
|
(21, 'TATAOUINE', 'TN'),
|
|
24
|
(22, 'TOZEUR', 'TN'),
|
|
25
|
(23, 'TUNIS', 'TN'),
|
|
26
|
(24, 'ZAGHOUAN', 'TN');
|
|
27
|
|
|
28
|
INSERT INTO solution_setting_town_translate (id,Label,townCode,languageId) VALUES
|
|
29
|
(1, 'Ariana', 'ARIANA', 1),
|
|
30
|
(2, 'Béja', 'BEJA', 1),
|
|
31
|
(3, 'Ben Arous', 'BENAROUS', 1),
|
|
32
|
(4, 'Bizerte', 'BIZERTE', 1),
|
|
33
|
(5, 'Gabès', 'GABES', 1),
|
|
34
|
(6, 'Gafsa', 'GAFSA', 1),
|
|
35
|
(7, 'Jendouba', 'JENDOUBA', 1),
|
|
36
|
(8, 'Kairouan', 'KAIROUAN', 1),
|
|
37
|
(9, 'Kasserine', 'KASSERINE', 1),
|
|
38
|
(10, 'Kebili', 'KEBILI', 1),
|
|
39
|
(11, 'Kef', 'KEF', 1),
|
|
40
|
(12, 'Mahdia', 'MAHDIA', 1),
|
|
41
|
(13, 'Manouba', 'MANOUBA', 1),
|
|
42
|
(14, 'Médenine', 'MEDENINE', 1),
|
|
43
|
(15, 'Monastir', 'MONASTIR', 1),
|
|
44
|
(16, 'Nabeul', 'NABEUL', 1),
|
|
45
|
(17, 'Sfax', 'SFAX', 1),
|
|
46
|
(18, 'Sidi Bouzid', 'SIDIBOUZID', 1),
|
|
47
|
(19, 'Siliana', 'SILIANA', 1),
|
|
48
|
(20, 'Sousse', 'SOUSSE', 1),
|
|
49
|
(21, 'Tataouine', 'TATAOUINE', 1),
|
|
50
|
(22, 'Tozeur', 'TOZEUR', 1),
|
|
51
|
(23, 'Tunis', 'TUNIS', 1),
|
|
52
|
(24, 'Zaghouan', 'ZAGHOUAN', 1),
|
|
53
|
(25, 'Ariana', 'ARIANA', 2),
|
|
54
|
(26, 'Béja', 'BEJA', 2),
|
|
55
|
(27, 'Ben Arous', 'BENAROUS', 2),
|
|
56
|
(28, 'Bizerte', 'BIZERTE', 2),
|
|
57
|
(29, 'Gabès', 'GABES', 2),
|
|
58
|
(30, 'Gafsa', 'GAFSA', 2),
|
|
59
|
(31, 'Jendouba', 'JENDOUBA', 2),
|
|
60
|
(32, 'Kairouan', 'KAIROUAN', 2),
|
|
61
|
(33, 'Kasserine', 'KASSERINE', 2),
|
|
62
|
(34, 'Kebili', 'KEBILI', 2),
|
|
63
|
(35, 'Kef', 'KEF', 2),
|
|
64
|
(36, 'Mahdia', 'MAHDIA', 2),
|
|
65
|
(37, 'Manouba', 'MANOUBA', 2),
|
|
66
|
(38, 'Médenine', 'MEDENINE', 2),
|
|
67
|
(39, 'Monastir', 'MONASTIR', 2),
|
|
68
|
(40, 'Nabeul', 'NABEUL', 2),
|
|
69
|
(41, 'Sfax', 'SFAX', 2),
|
|
70
|
(42, 'Sidi Bouzid', 'SIDIBOUZID', 2),
|
|
71
|
(43, 'Siliana', 'SILIANA', 2),
|
|
72
|
(44, 'Sousse', 'SOUSSE', 2),
|
|
73
|
(45, 'Tataouine', 'TATAOUINE', 2),
|
|
74
|
(46, 'Tozeur', 'TOZEUR', 2),
|
|
75
|
(47, 'Tunis', 'TUNIS', 2),
|
|
76
|
(48, 'Zaghouan', 'ZAGHOUAN', 2);
|