· 7 years ago · Oct 19, 2018, 02:52 PM
1 _
2 : \
3 ;\ \_ _
4 ;@: ~: _,-;@)
5 ;@: ;~: _,' _,'@;
6 ;@; ;~; ,-' _,@@@,'
7 |@( ; ) ,-'@@@-;
8 ;@; |~~( _/ /@@@@@@/
9 \@\ ; _/ _/ /@@@@@@;~
10 \@\ / / ,'@@@,-'~
11 \\ ( ) :@@(~
12 ___ )-'~~~~`--/ ___
13 ( `--_ _,--' )
14 (~`- ___ \ / ___ -'~)
15 __~\_( \_~~_/ )_/~__
16 /\ /\ /\ ,-'~~~~~`-._ 0\/0 _,-'~~~~~`-.
17| |: ::| ; ______ `----' ______ :
18| `' `'| ; { \ ~ / } |
19 \_ _/ `-._ ,-,' ~~ `.-. _,' |\
20 \ /_ `----' ,' `, `----' : \
21 |_( ) `-._/#\_,-' : )
22 ,-' ~) _,--./ (###)__ : :
23 (~~~~_) / ; `-' `--, | ;
24 (~~~' ) ; /@@@@@@. `. | /
25 `.HH~; ,-' ,- |@@@ @@@@. `. .')
26 `HH `. ,' / |@@@@@ @@@@. `. / /(~)
27 HH \_ ,' _/`. |@@@@@ @@@@@; `. ; (~~)
28 ~~`. \_,' / ; .@@@@@ @@@@@@;\_ \___ ; H~\)
29 \_ _/ `. |@@@@@@ @@@@@; \ `----'_HH[~)
30 \___/ `. :@@@@@ @@@@@@' \__,------' HH ~
31 ______ ; |@@@@@@ @@@' HH
32 _) \_, ; :@@@@@@@@@; ~~
33 _; \\ ,' |@@@@@@@@@:
34 ,' ; : \_, :@@@@@@@@@@.
35 `.__,-'~~`._,-. , :@@@@@@@@@@`.
36 \/ /@@@@@@@@@@@@:
37 / ,@@@@@@@@@@@@@@.
38 | ,@@@@@@@@@@@@@@@:
39 | :@@@@@@@@@@@@@@@'
40 `. \@@@@/ `@@@@@/(
41 ) ~~~/ \~~~~ \
42 : / \_ \
43 ( / \_ `.
44 / ; \_ `.
45 / / \ `.
46 / / `. \
47 ,' ,'/~~) ; /
48 { `' ( / /
49 `.___,-' \ / /
50 __/ | / /
51 / | : : __
52 : | ; : _; )__
53 ( | | / / `,' ~ )_
54 `-:__;-' : ,' ~~ ;
55 / (_,--'
56 ( ,-'~~
57 \__,-'~
58â•”â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•—
59 Target: https://learning.estia.fr
60â•šâ•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•â•
61DROP TABLE IF EXISTS `vtiger_users`;
62/*!40101 SET @saved_cs_client = @@character_set_client */;
63/*!40101 SET character_set_client = utf8 */;
64CREATE TABLE `vtiger_users` (
65 `id` int(11) NOT NULL AUTO_INCREMENT,
66 `user_name` varchar(255) DEFAULT NULL,
67 `user_password` varchar(200) DEFAULT NULL,
68 `user_hash` varchar(32) DEFAULT NULL,
69 `cal_color` varchar(25) DEFAULT '#E6FAD8',
70 `first_name` varchar(30) DEFAULT NULL,
71 `last_name` varchar(30) DEFAULT NULL,
72 `reports_to_id` varchar(36) DEFAULT NULL,
73 `is_admin` varchar(3) DEFAULT '0',
74 `currency_id` int(19) NOT NULL DEFAULT '1',
75 `description` text,
76 `date_entered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
77 `date_modified` datetime DEFAULT NULL,
78 `modified_user_id` varchar(36) DEFAULT NULL,
79 `title` varchar(50) DEFAULT NULL,
80 `department` varchar(50) DEFAULT NULL,
81 `phone_home` varchar(50) DEFAULT NULL,
82 `phone_mobile` varchar(50) DEFAULT NULL,
83 `phone_work` varchar(50) DEFAULT NULL,
84 `phone_other` varchar(50) DEFAULT NULL,
85 `phone_fax` varchar(50) DEFAULT NULL,
86 `email1` varchar(100) DEFAULT NULL,
87 `email2` varchar(100) DEFAULT NULL,
88 `secondaryemail` varchar(100) DEFAULT NULL,
89 `status` varchar(25) DEFAULT NULL,
90 `signature` text,
91 `address_street` varchar(150) DEFAULT NULL,
92 `address_city` varchar(100) DEFAULT NULL,
93 `address_state` varchar(100) DEFAULT NULL,
94 `address_country` varchar(25) DEFAULT NULL,
95 `address_postalcode` varchar(9) DEFAULT NULL,
96 `user_preferences` text,
97 `tz` varchar(30) DEFAULT NULL,
98 `holidays` varchar(60) DEFAULT NULL,
99 `namedays` varchar(60) DEFAULT NULL,
100 `workdays` varchar(30) DEFAULT NULL,
101 `weekstart` int(11) DEFAULT NULL,
102 `date_format` varchar(200) DEFAULT NULL,
103 `hour_format` varchar(30) DEFAULT 'am/pm',
104 `start_hour` varchar(30) DEFAULT '10:00',
105 `end_hour` varchar(30) DEFAULT '23:00',
106 `activity_view` varchar(200) DEFAULT 'Today',
107 `lead_view` varchar(200) DEFAULT 'Today',
108 `imagename` varchar(250) DEFAULT NULL,
109 `deleted` int(1) NOT NULL DEFAULT '0',
110 `confirm_password` varchar(300) DEFAULT NULL,
111 `internal_mailer` varchar(3) NOT NULL DEFAULT '1',
112 `reminder_interval` varchar(100) DEFAULT NULL,
113 `reminder_next_time` varchar(100) DEFAULT NULL,
114 `crypt_type` varchar(20) NOT NULL DEFAULT 'MD5',
115 `accesskey` varchar(36) DEFAULT NULL,
116 `theme` varchar(100) DEFAULT NULL,
117 `language` varchar(36) DEFAULT NULL,
118 `time_zone` varchar(200) DEFAULT NULL,
119 `currency_grouping_pattern` varchar(100) DEFAULT NULL,
120 `currency_decimal_separator` varchar(2) DEFAULT NULL,
121 `currency_grouping_separator` varchar(2) DEFAULT NULL,
122 `currency_symbol_placement` varchar(20) DEFAULT NULL,
123 `phone_crm_extension` varchar(100) DEFAULT NULL,
124 `no_of_currency_decimals` varchar(2) DEFAULT NULL,
125 `truncate_trailing_zeros` varchar(3) DEFAULT NULL,
126 `dayoftheweek` varchar(100) DEFAULT NULL,
127 `callduration` varchar(100) DEFAULT NULL,
128 `othereventduration` varchar(100) DEFAULT NULL,
129 `calendarsharedtype` varchar(100) DEFAULT NULL,
130 `default_record_view` varchar(10) DEFAULT NULL,
131 `leftpanelhide` varchar(3) DEFAULT NULL,
132 `rowheight` varchar(10) DEFAULT NULL,
133 `defaulteventstatus` varchar(50) DEFAULT NULL,
134 `defaultactivitytype` varchar(50) DEFAULT NULL,
135 `hidecompletedevents` int(11) DEFAULT NULL,
136 `is_owner` varchar(5) DEFAULT NULL,
137 `defaultcalendarview` varchar(100) DEFAULT NULL,
138 PRIMARY KEY (`id`),
139 KEY `user_user_name_idx` (`user_name`),
140 KEY `user_user_password_idx` (`user_password`)
141) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
142/*!40101 SET character_set_client = @saved_cs_client */;
143
144--
145-- Dumping data for table `vtiger_users`
146--
147
148LOCK TABLES `vtiger_users` WRITE;
149/*!40000 ALTER TABLE `vtiger_users` DISABLE KEYS */;
150INSERT INTO `vtiger_users` VALUES (1,'admin','$1$ad000000$/4Z3xrrqVFt03PJoMpRHE0','50b2e4c9e501dcaf54dfd7984707d583','#E6FAD8','ESTIA','Administrateur','','on',1,'','2018-05-09 15:41:19',NULL,NULL,'','','','','','','','nezar.lghiouane@gmail.com','','','Active','','','','','','',NULL,NULL,NULL,NULL,NULL,NULL,'dd-mm-yyyy','12','00:00','23:00','This Week','Today','',0,'$1$ad000000$/4Z3xrrqVFt03PJoMpRHE0','1','1 Minute',NULL,'PHP5.3MD5','5LTOGSjYrTs7o0Cs','softed','fr_fr','Europe/Brussels','123,456,789','.',',','$1.0','','2','1','Sunday','5','5','public','Summary','0','medium','Planned','Call',0,'1','MyCalendar');
151/*!40000 ALTER TABLE `vtiger_users` ENABLE KEYS */;