2
# Create database structure with default values
5
-- --------------------------------------------------------
8
-- Structure de la table `actionsTimestamps`
11
DROP TABLE IF EXISTS `actionsTimestamps`;
12
CREATE TABLE `actionsTimestamps` (
13
`type_at` varchar(50) NOT NULL default '',
14
`date_at` datetime NOT NULL default '0000-00-00 00:00:00'
15
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
18
-- Contenu de la table `actionsTimestamps`
22
-- --------------------------------------------------------
25
-- Structure de la table `blocksFiles_archived`
28
DROP TABLE IF EXISTS `blocksFiles_archived`;
29
CREATE TABLE `blocksFiles_archived` (
30
`id` int(11) unsigned NOT NULL auto_increment,
31
`page` int(11) unsigned NOT NULL default '0',
32
`clientSpaceID` varchar(100) NOT NULL default '',
33
`rowID` varchar(100) NOT NULL default '',
34
`blockID` varchar(100) NOT NULL default '',
35
`label` varchar(255) NOT NULL default '',
36
`file` varchar(255) NOT NULL default '',
39
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
42
-- Contenu de la table `blocksFiles_archived`
46
-- --------------------------------------------------------
49
-- Structure de la table `blocksFiles_deleted`
52
DROP TABLE IF EXISTS `blocksFiles_deleted`;
53
CREATE TABLE `blocksFiles_deleted` (
54
`id` int(11) unsigned NOT NULL auto_increment,
55
`page` int(11) unsigned NOT NULL default '0',
56
`clientSpaceID` varchar(100) NOT NULL default '',
57
`rowID` varchar(100) NOT NULL default '',
58
`blockID` varchar(100) NOT NULL default '',
59
`label` varchar(255) NOT NULL default '',
60
`file` varchar(255) NOT NULL default '',
63
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
66
-- Contenu de la table `blocksFiles_deleted`
70
-- --------------------------------------------------------
73
-- Structure de la table `blocksFiles_edited`
76
DROP TABLE IF EXISTS `blocksFiles_edited`;
77
CREATE TABLE `blocksFiles_edited` (
78
`id` int(11) unsigned NOT NULL auto_increment,
79
`page` int(11) unsigned NOT NULL default '0',
80
`clientSpaceID` varchar(100) NOT NULL default '',
81
`rowID` varchar(100) NOT NULL default '',
82
`blockID` varchar(100) NOT NULL default '',
83
`label` varchar(255) NOT NULL default '',
84
`file` varchar(255) NOT NULL default '',
87
FULLTEXT KEY `label` (`label`)
88
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
91
-- Contenu de la table `blocksFiles_edited`
95
-- --------------------------------------------------------
98
-- Structure de la table `blocksFiles_edition`
101
DROP TABLE IF EXISTS `blocksFiles_edition`;
102
CREATE TABLE `blocksFiles_edition` (
103
`id` int(11) unsigned NOT NULL auto_increment,
104
`page` int(11) unsigned NOT NULL default '0',
105
`clientSpaceID` varchar(100) NOT NULL default '',
106
`rowID` varchar(100) NOT NULL default '',
107
`blockID` varchar(100) NOT NULL default '',
108
`label` varchar(255) NOT NULL default '',
109
`file` varchar(255) NOT NULL default '',
112
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
115
-- Contenu de la table `blocksFiles_edition`
119
-- --------------------------------------------------------
122
-- Structure de la table `blocksFiles_public`
125
DROP TABLE IF EXISTS `blocksFiles_public`;
126
CREATE TABLE `blocksFiles_public` (
127
`id` int(11) unsigned NOT NULL auto_increment,
128
`page` int(11) unsigned NOT NULL default '0',
129
`clientSpaceID` varchar(100) NOT NULL default '',
130
`rowID` varchar(100) NOT NULL default '',
131
`blockID` varchar(100) NOT NULL default '',
132
`label` varchar(255) NOT NULL default '',
133
`file` varchar(255) NOT NULL default '',
136
FULLTEXT KEY `label` (`label`)
137
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
140
-- Contenu de la table `blocksFiles_public`
144
-- --------------------------------------------------------
147
-- Structure de la table `blocksFlashes_archived`
150
DROP TABLE IF EXISTS `blocksFlashes_archived`;
151
CREATE TABLE `blocksFlashes_archived` (
152
`id` int(11) unsigned NOT NULL auto_increment,
153
`page` int(11) unsigned NOT NULL default '0',
154
`clientSpaceID` varchar(100) NOT NULL default '',
155
`rowID` varchar(100) NOT NULL default '',
156
`blockID` varchar(100) NOT NULL default '',
157
`file` varchar(255) NOT NULL default '',
158
`width` int(4) unsigned NOT NULL default '200',
159
`height` int(4) unsigned NOT NULL default '100',
160
`name` varchar(100) NOT NULL default '',
161
`version` varchar(100) NOT NULL default '',
162
`params` text NOT NULL,
163
`flashvars` text NOT NULL,
164
`attributes` text NOT NULL,
167
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
170
-- Contenu de la table `blocksFlashes_archived`
174
-- --------------------------------------------------------
177
-- Structure de la table `blocksFlashes_deleted`
180
DROP TABLE IF EXISTS `blocksFlashes_deleted`;
181
CREATE TABLE `blocksFlashes_deleted` (
182
`id` int(11) unsigned NOT NULL auto_increment,
183
`page` int(11) unsigned NOT NULL default '0',
184
`clientSpaceID` varchar(100) NOT NULL default '',
185
`rowID` varchar(100) NOT NULL default '',
186
`blockID` varchar(100) NOT NULL default '',
187
`file` varchar(255) NOT NULL default '',
188
`width` int(4) unsigned NOT NULL default '200',
189
`height` int(4) unsigned NOT NULL default '100',
190
`name` varchar(100) NOT NULL default '',
191
`version` varchar(100) NOT NULL default '',
192
`params` text NOT NULL,
193
`flashvars` text NOT NULL,
194
`attributes` text NOT NULL,
197
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
200
-- Contenu de la table `blocksFlashes_deleted`
204
-- --------------------------------------------------------
207
-- Structure de la table `blocksFlashes_edited`
210
DROP TABLE IF EXISTS `blocksFlashes_edited`;
211
CREATE TABLE `blocksFlashes_edited` (
212
`id` int(11) unsigned NOT NULL auto_increment,
213
`page` int(11) unsigned NOT NULL default '0',
214
`clientSpaceID` varchar(100) NOT NULL default '',
215
`rowID` varchar(100) NOT NULL default '',
216
`blockID` varchar(100) NOT NULL default '',
217
`file` varchar(255) NOT NULL default '',
218
`width` int(4) unsigned NOT NULL default '200',
219
`height` int(4) unsigned NOT NULL default '100',
220
`name` varchar(100) NOT NULL default '',
221
`version` varchar(100) NOT NULL default '',
222
`params` text NOT NULL,
223
`flashvars` text NOT NULL,
224
`attributes` text NOT NULL,
227
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
230
-- Contenu de la table `blocksFlashes_edited`
234
-- --------------------------------------------------------
237
-- Structure de la table `blocksFlashes_edition`
240
DROP TABLE IF EXISTS `blocksFlashes_edition`;
241
CREATE TABLE `blocksFlashes_edition` (
242
`id` int(11) unsigned NOT NULL auto_increment,
243
`page` int(11) unsigned NOT NULL default '0',
244
`clientSpaceID` varchar(100) NOT NULL default '',
245
`rowID` varchar(100) NOT NULL default '',
246
`blockID` varchar(100) NOT NULL default '',
247
`file` varchar(255) NOT NULL default '',
248
`width` int(4) unsigned NOT NULL default '200',
249
`height` int(4) unsigned NOT NULL default '100',
250
`name` varchar(100) NOT NULL default '',
251
`version` varchar(100) NOT NULL default '',
252
`params` text NOT NULL,
253
`flashvars` text NOT NULL,
254
`attributes` text NOT NULL,
257
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
260
-- Contenu de la table `blocksFlashes_edition`
264
-- --------------------------------------------------------
267
-- Structure de la table `blocksFlashes_public`
270
DROP TABLE IF EXISTS `blocksFlashes_public`;
271
CREATE TABLE `blocksFlashes_public` (
272
`id` int(11) unsigned NOT NULL auto_increment,
273
`page` int(11) unsigned NOT NULL default '0',
274
`clientSpaceID` varchar(100) NOT NULL default '',
275
`rowID` varchar(100) NOT NULL default '',
276
`blockID` varchar(100) NOT NULL default '',
277
`file` varchar(255) NOT NULL default '',
278
`width` int(4) unsigned NOT NULL default '200',
279
`height` int(4) unsigned NOT NULL default '100',
280
`name` varchar(100) NOT NULL default '',
281
`version` varchar(100) NOT NULL default '',
282
`params` text NOT NULL,
283
`flashvars` text NOT NULL,
284
`attributes` text NOT NULL,
287
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
290
-- Contenu de la table `blocksFlashes_public`
294
-- --------------------------------------------------------
297
-- Structure de la table `blocksImages_archived`
300
DROP TABLE IF EXISTS `blocksImages_archived`;
301
CREATE TABLE `blocksImages_archived` (
302
`id` int(11) unsigned NOT NULL auto_increment,
303
`page` int(11) unsigned NOT NULL default '0',
304
`clientSpaceID` varchar(100) NOT NULL default '',
305
`rowID` varchar(100) NOT NULL default '',
306
`blockID` varchar(100) NOT NULL default '',
307
`label` varchar(255) NOT NULL default '',
308
`file` varchar(255) NOT NULL default '',
309
`enlargedFile` varchar(255) NOT NULL default '',
310
`externalLink` varchar(255) NOT NULL default '',
313
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
316
-- Contenu de la table `blocksImages_archived`
320
-- --------------------------------------------------------
323
-- Structure de la table `blocksImages_deleted`
326
DROP TABLE IF EXISTS `blocksImages_deleted`;
327
CREATE TABLE `blocksImages_deleted` (
328
`id` int(11) unsigned NOT NULL auto_increment,
329
`page` int(11) unsigned NOT NULL default '0',
330
`clientSpaceID` varchar(100) NOT NULL default '',
331
`rowID` varchar(100) NOT NULL default '',
332
`blockID` varchar(100) NOT NULL default '',
333
`label` varchar(255) NOT NULL default '',
334
`file` varchar(255) NOT NULL default '',
335
`enlargedFile` varchar(255) NOT NULL default '',
336
`externalLink` varchar(255) NOT NULL default '',
339
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
342
-- Contenu de la table `blocksImages_deleted`
346
-- --------------------------------------------------------
349
-- Structure de la table `blocksImages_edited`
352
DROP TABLE IF EXISTS `blocksImages_edited`;
353
CREATE TABLE `blocksImages_edited` (
354
`id` int(11) unsigned NOT NULL auto_increment,
355
`page` int(11) unsigned NOT NULL default '0',
356
`clientSpaceID` varchar(100) NOT NULL default '',
357
`rowID` varchar(100) NOT NULL default '',
358
`blockID` varchar(100) NOT NULL default '',
359
`label` varchar(255) NOT NULL default '',
360
`file` varchar(255) NOT NULL default '',
361
`enlargedFile` varchar(255) NOT NULL default '',
362
`externalLink` varchar(255) NOT NULL default '',
365
FULLTEXT KEY `label` (`label`)
366
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
369
-- Contenu de la table `blocksImages_edited`
373
-- --------------------------------------------------------
376
-- Structure de la table `blocksImages_edition`
379
DROP TABLE IF EXISTS `blocksImages_edition`;
380
CREATE TABLE `blocksImages_edition` (
381
`id` int(11) unsigned NOT NULL auto_increment,
382
`page` int(11) unsigned NOT NULL default '0',
383
`clientSpaceID` varchar(100) NOT NULL default '',
384
`rowID` varchar(100) NOT NULL default '',
385
`blockID` varchar(100) NOT NULL default '',
386
`label` varchar(255) NOT NULL default '',
387
`file` varchar(255) NOT NULL default '',
388
`enlargedFile` varchar(255) NOT NULL default '',
389
`externalLink` varchar(255) NOT NULL default '',
392
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
395
-- Contenu de la table `blocksImages_edition`
399
-- --------------------------------------------------------
402
-- Structure de la table `blocksImages_public`
405
DROP TABLE IF EXISTS `blocksImages_public`;
406
CREATE TABLE `blocksImages_public` (
407
`id` int(11) unsigned NOT NULL auto_increment,
408
`page` int(11) unsigned NOT NULL default '0',
409
`clientSpaceID` varchar(100) NOT NULL default '',
410
`rowID` varchar(100) NOT NULL default '',
411
`blockID` varchar(100) NOT NULL default '',
412
`label` varchar(255) NOT NULL default '',
413
`file` varchar(255) NOT NULL default '',
414
`enlargedFile` varchar(255) NOT NULL default '',
415
`externalLink` varchar(255) NOT NULL default '',
418
FULLTEXT KEY `label` (`label`)
419
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
422
-- Contenu de la table `blocksImages_public`
426
-- --------------------------------------------------------
429
-- Structure de la table `blocksRawDatas_archived`
432
DROP TABLE IF EXISTS `blocksRawDatas_archived`;
433
CREATE TABLE `blocksRawDatas_archived` (
434
`id` int(11) unsigned NOT NULL auto_increment,
435
`page` int(11) unsigned NOT NULL default '0',
436
`clientSpaceID` varchar(100) NOT NULL default '',
437
`rowID` varchar(100) NOT NULL default '',
438
`blockID` varchar(100) NOT NULL default '',
439
`value` text NOT NULL,
442
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
445
-- Contenu de la table `blocksRawDatas_archived`
449
-- --------------------------------------------------------
452
-- Structure de la table `blocksRawDatas_deleted`
455
DROP TABLE IF EXISTS `blocksRawDatas_deleted`;
456
CREATE TABLE `blocksRawDatas_deleted` (
457
`id` int(11) unsigned NOT NULL auto_increment,
458
`page` int(11) unsigned NOT NULL default '0',
459
`clientSpaceID` varchar(100) NOT NULL default '',
460
`rowID` varchar(100) NOT NULL default '',
461
`blockID` varchar(100) NOT NULL default '',
462
`value` text NOT NULL,
465
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
468
-- Contenu de la table `blocksRawDatas_deleted`
472
-- --------------------------------------------------------
475
-- Structure de la table `blocksRawDatas_edited`
478
DROP TABLE IF EXISTS `blocksRawDatas_edited`;
479
CREATE TABLE `blocksRawDatas_edited` (
480
`id` int(11) unsigned NOT NULL auto_increment,
481
`page` int(11) unsigned NOT NULL default '0',
482
`clientSpaceID` varchar(100) NOT NULL default '',
483
`rowID` varchar(100) NOT NULL default '',
484
`blockID` varchar(100) NOT NULL default '',
485
`value` text NOT NULL,
488
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
491
-- Contenu de la table `blocksRawDatas_edited`
495
-- --------------------------------------------------------
498
-- Structure de la table `blocksRawDatas_edition`
501
DROP TABLE IF EXISTS `blocksRawDatas_edition`;
502
CREATE TABLE `blocksRawDatas_edition` (
503
`id` int(11) unsigned NOT NULL auto_increment,
504
`page` int(11) unsigned NOT NULL default '0',
505
`clientSpaceID` varchar(100) NOT NULL default '',
506
`rowID` varchar(100) NOT NULL default '',
507
`blockID` varchar(100) NOT NULL default '',
508
`value` text NOT NULL,
511
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
514
-- Contenu de la table `blocksRawDatas_edition`
518
-- --------------------------------------------------------
521
-- Structure de la table `blocksRawDatas_public`
524
DROP TABLE IF EXISTS `blocksRawDatas_public`;
525
CREATE TABLE `blocksRawDatas_public` (
526
`id` int(11) unsigned NOT NULL auto_increment,
527
`page` int(11) unsigned NOT NULL default '0',
528
`clientSpaceID` varchar(100) NOT NULL default '',
529
`rowID` varchar(100) NOT NULL default '',
530
`blockID` varchar(100) NOT NULL default '',
531
`value` text NOT NULL,
534
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
537
-- Contenu de la table `blocksRawDatas_public`
541
-- --------------------------------------------------------
544
-- Structure de la table `blocksTexts_archived`
547
DROP TABLE IF EXISTS `blocksTexts_archived`;
548
CREATE TABLE `blocksTexts_archived` (
549
`id` int(11) unsigned NOT NULL auto_increment,
550
`page` int(11) unsigned NOT NULL default '0',
551
`clientSpaceID` varchar(100) NOT NULL default '',
552
`rowID` varchar(100) NOT NULL default '',
553
`blockID` varchar(100) NOT NULL default '',
554
`value` text NOT NULL,
557
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
560
-- Contenu de la table `blocksTexts_archived`
564
-- --------------------------------------------------------
567
-- Structure de la table `blocksTexts_deleted`
570
DROP TABLE IF EXISTS `blocksTexts_deleted`;
571
CREATE TABLE `blocksTexts_deleted` (
572
`id` int(11) unsigned NOT NULL auto_increment,
573
`page` int(11) unsigned NOT NULL default '0',
574
`clientSpaceID` varchar(100) NOT NULL default '',
575
`rowID` varchar(100) NOT NULL default '',
576
`blockID` varchar(100) NOT NULL default '',
577
`value` text NOT NULL,
580
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
583
-- Contenu de la table `blocksTexts_deleted`
587
-- --------------------------------------------------------
590
-- Structure de la table `blocksTexts_edited`
593
DROP TABLE IF EXISTS `blocksTexts_edited`;
594
CREATE TABLE `blocksTexts_edited` (
595
`id` int(11) unsigned NOT NULL auto_increment,
596
`page` int(11) unsigned NOT NULL default '0',
597
`clientSpaceID` varchar(100) NOT NULL default '',
598
`rowID` varchar(100) NOT NULL default '',
599
`blockID` varchar(100) NOT NULL default '',
600
`value` text NOT NULL,
603
FULLTEXT KEY `value` (`value`)
604
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
607
-- Contenu de la table `blocksTexts_edited`
611
-- --------------------------------------------------------
614
-- Structure de la table `blocksTexts_edition`
617
DROP TABLE IF EXISTS `blocksTexts_edition`;
618
CREATE TABLE `blocksTexts_edition` (
619
`id` int(11) unsigned NOT NULL auto_increment,
620
`page` int(11) unsigned NOT NULL default '0',
621
`clientSpaceID` varchar(100) NOT NULL default '',
622
`rowID` varchar(100) NOT NULL default '',
623
`blockID` varchar(100) NOT NULL default '',
624
`value` text NOT NULL,
627
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
630
-- Contenu de la table `blocksTexts_edition`
634
-- --------------------------------------------------------
637
-- Structure de la table `blocksTexts_public`
640
DROP TABLE IF EXISTS `blocksTexts_public`;
641
CREATE TABLE `blocksTexts_public` (
642
`id` int(11) unsigned NOT NULL auto_increment,
643
`page` int(11) unsigned NOT NULL default '0',
644
`clientSpaceID` varchar(100) NOT NULL default '',
645
`rowID` varchar(100) NOT NULL default '',
646
`blockID` varchar(100) NOT NULL default '',
647
`value` text NOT NULL,
650
FULLTEXT KEY `value` (`value`)
651
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
654
-- Contenu de la table `blocksTexts_public`
658
-- --------------------------------------------------------
661
-- Structure de la table `blocksVarchars_archived`
664
DROP TABLE IF EXISTS `blocksVarchars_archived`;
665
CREATE TABLE `blocksVarchars_archived` (
666
`id` int(11) unsigned NOT NULL auto_increment,
667
`page` int(11) unsigned NOT NULL default '0',
668
`clientSpaceID` varchar(100) NOT NULL default '',
669
`rowID` varchar(100) NOT NULL default '',
670
`blockID` varchar(100) NOT NULL default '',
671
`value` varchar(255) NOT NULL default '',
674
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
677
-- Contenu de la table `blocksVarchars_archived`
681
-- --------------------------------------------------------
684
-- Structure de la table `blocksVarchars_deleted`
687
DROP TABLE IF EXISTS `blocksVarchars_deleted`;
688
CREATE TABLE `blocksVarchars_deleted` (
689
`id` int(11) unsigned NOT NULL auto_increment,
690
`page` int(11) unsigned NOT NULL default '0',
691
`clientSpaceID` varchar(100) NOT NULL default '',
692
`rowID` varchar(100) NOT NULL default '',
693
`blockID` varchar(100) NOT NULL default '',
694
`value` varchar(255) NOT NULL default '',
697
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
700
-- Contenu de la table `blocksVarchars_deleted`
704
-- --------------------------------------------------------
707
-- Structure de la table `blocksVarchars_edited`
710
DROP TABLE IF EXISTS `blocksVarchars_edited`;
711
CREATE TABLE `blocksVarchars_edited` (
712
`id` int(11) unsigned NOT NULL auto_increment,
713
`page` int(11) unsigned NOT NULL default '0',
714
`clientSpaceID` varchar(100) NOT NULL default '',
715
`rowID` varchar(100) NOT NULL default '',
716
`blockID` varchar(100) NOT NULL default '',
717
`value` varchar(255) NOT NULL default '',
720
FULLTEXT KEY `value` (`value`)
721
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
724
-- Contenu de la table `blocksVarchars_edited`
728
-- --------------------------------------------------------
731
-- Structure de la table `blocksVarchars_edition`
734
DROP TABLE IF EXISTS `blocksVarchars_edition`;
735
CREATE TABLE `blocksVarchars_edition` (
736
`id` int(11) unsigned NOT NULL auto_increment,
737
`page` int(11) unsigned NOT NULL default '0',
738
`clientSpaceID` varchar(100) NOT NULL default '',
739
`rowID` varchar(100) NOT NULL default '',
740
`blockID` varchar(100) NOT NULL default '',
741
`value` varchar(255) NOT NULL default '',
744
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
747
-- Contenu de la table `blocksVarchars_edition`
751
-- --------------------------------------------------------
754
-- Structure de la table `blocksVarchars_public`
757
DROP TABLE IF EXISTS `blocksVarchars_public`;
758
CREATE TABLE `blocksVarchars_public` (
759
`id` int(11) unsigned NOT NULL auto_increment,
760
`page` int(11) unsigned NOT NULL default '0',
761
`clientSpaceID` varchar(100) NOT NULL default '',
762
`rowID` varchar(100) NOT NULL default '',
763
`blockID` varchar(100) NOT NULL default '',
764
`value` varchar(255) NOT NULL default '',
767
FULLTEXT KEY `value` (`value`)
768
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
771
-- Contenu de la table `blocksVarchars_public`
775
-- --------------------------------------------------------
778
-- Structure de la table `contactDatas`
781
DROP TABLE IF EXISTS `contactDatas`;
782
CREATE TABLE `contactDatas` (
783
`id_cd` int(11) unsigned NOT NULL auto_increment,
784
`service_cd` varchar(100) NOT NULL default '',
785
`jobTitle_cd` varchar(100) NOT NULL default '',
786
`addressField1_cd` varchar(255) NOT NULL default '',
787
`addressField2_cd` varchar(255) NOT NULL default '',
788
`addressField3_cd` varchar(255) NOT NULL default '',
789
`zip_cd` varchar(20) NOT NULL default '',
790
`city_cd` varchar(100) NOT NULL default '',
791
`state_cd` varchar(50) NOT NULL default '',
792
`country_cd` varchar(100) NOT NULL default '',
793
`phone_cd` varchar(20) NOT NULL default '',
794
`cellphone_cd` varchar(20) NOT NULL default '',
795
`fax_cd` varchar(20) NOT NULL default '',
796
`email_cd` varchar(255) NOT NULL default '',
797
PRIMARY KEY (`id_cd`)
798
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
801
-- Contenu de la table `contactDatas`
804
INSERT INTO `contactDatas` (`id_cd`, `service_cd`, `jobTitle_cd`, `addressField1_cd`, `addressField2_cd`, `addressField3_cd`, `zip_cd`, `city_cd`, `state_cd`, `country_cd`, `phone_cd`, `cellphone_cd`, `fax_cd`, `email_cd`) VALUES(1, '', '', '', '', '', '', '', '', '', '', '', '', 'root@localhost');
805
INSERT INTO `contactDatas` (`id_cd`, `service_cd`, `jobTitle_cd`, `addressField1_cd`, `addressField2_cd`, `addressField3_cd`, `zip_cd`, `city_cd`, `state_cd`, `country_cd`, `phone_cd`, `cellphone_cd`, `fax_cd`, `email_cd`) VALUES(3, '', '', '', '', '', '', '', '', '', '', '', '', 'nobody@localhost');
807
-- --------------------------------------------------------
810
-- Structure de la table `languages`
813
DROP TABLE IF EXISTS `languages`;
814
CREATE TABLE `languages` (
815
`code_lng` varchar(5) NOT NULL default '',
816
`label_lng` varchar(50) NOT NULL default '',
817
`dateFormat_lng` varchar(5) NOT NULL default 'm/d/Y',
818
`availableForBackoffice_lng` tinyint(4) NOT NULL default '0',
819
`modulesDenied_lng` varchar(255) NOT NULL default '',
820
PRIMARY KEY (`code_lng`)
821
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
824
-- Contenu de la table `languages`
827
INSERT INTO `languages` (`code_lng`, `label_lng`, `dateFormat_lng`, `availableForBackoffice_lng`, `modulesDenied_lng`) VALUES('fr', 'Français', 'd/m/Y', 1, '');
828
INSERT INTO `languages` (`code_lng`, `label_lng`, `dateFormat_lng`, `availableForBackoffice_lng`, `modulesDenied_lng`) VALUES('en', 'English', 'm/d/Y', 1, '');
830
-- --------------------------------------------------------
833
-- Structure de la table `linx_real_public`
836
DROP TABLE IF EXISTS `linx_real_public`;
837
CREATE TABLE `linx_real_public` (
838
`start_lre` int(11) unsigned NOT NULL default '0',
839
`stop_lre` int(11) NOT NULL default '0',
840
UNIQUE KEY `start_lre` (`start_lre`,`stop_lre`)
841
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
844
-- Contenu de la table `linx_real_public`
848
-- --------------------------------------------------------
851
-- Structure de la table `linx_tree_edited`
854
DROP TABLE IF EXISTS `linx_tree_edited`;
855
CREATE TABLE `linx_tree_edited` (
856
`id_ltr` int(11) unsigned NOT NULL auto_increment,
857
`father_ltr` int(11) unsigned NOT NULL default '0',
858
`sibling_ltr` int(11) unsigned NOT NULL default '0',
859
`order_ltr` int(11) unsigned NOT NULL default '0',
860
PRIMARY KEY (`id_ltr`),
861
KEY `father_ltr` (`father_ltr`),
862
KEY `sibling_ltr` (`sibling_ltr`)
863
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
866
-- Contenu de la table `linx_tree_edited`
870
-- --------------------------------------------------------
873
-- Structure de la table `linx_tree_public`
876
DROP TABLE IF EXISTS `linx_tree_public`;
877
CREATE TABLE `linx_tree_public` (
878
`id_ltr` int(11) unsigned NOT NULL auto_increment,
879
`father_ltr` int(11) unsigned NOT NULL default '0',
880
`sibling_ltr` int(11) unsigned NOT NULL default '0',
881
`order_ltr` int(11) unsigned NOT NULL default '0',
882
PRIMARY KEY (`id_ltr`),
883
KEY `father_ltr` (`father_ltr`),
884
KEY `sibling_ltr` (`sibling_ltr`)
885
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
888
-- Contenu de la table `linx_tree_public`
892
-- --------------------------------------------------------
895
-- Structure de la table `linx_watch_public`
898
DROP TABLE IF EXISTS `linx_watch_public`;
899
CREATE TABLE `linx_watch_public` (
900
`page_lwa` int(11) unsigned NOT NULL default '0',
901
`target_lwa` int(11) unsigned NOT NULL default '0',
902
UNIQUE KEY `page_lwa` (`page_lwa`,`target_lwa`)
903
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
906
-- Contenu de la table `linx_watch_public`
910
-- --------------------------------------------------------
913
-- Structure de la table `locks`
916
DROP TABLE IF EXISTS `locks`;
917
CREATE TABLE `locks` (
918
`id_lok` int(11) unsigned NOT NULL auto_increment,
919
`resource_lok` int(11) unsigned NOT NULL default '0',
920
`locksmithData_lok` int(11) unsigned NOT NULL default '0',
921
`date_lok` datetime NOT NULL default '0000-00-00 00:00:00',
922
PRIMARY KEY (`id_lok`),
923
KEY `resource_lok` (`resource_lok`)
924
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
927
-- Contenu de la table `locks`
931
-- --------------------------------------------------------
934
-- Structure de la table `log`
937
DROP TABLE IF EXISTS `log`;
939
`id_log` int(11) unsigned NOT NULL auto_increment,
940
`user_log` int(11) unsigned NOT NULL default '0',
941
`action_log` int(11) unsigned NOT NULL default '0',
942
`datetime_log` datetime NOT NULL default '0000-00-00 00:00:00',
943
`textData_log` mediumtext NOT NULL,
944
`label_log` tinytext NOT NULL,
945
`module_log` varchar(100) NOT NULL default '',
946
`resource_log` int(11) unsigned NOT NULL default '0',
947
`rsAfterLocation_log` tinyint(4) unsigned NOT NULL default '0',
948
`rsAfterProposedFor_log` tinyint(4) unsigned NOT NULL default '0',
949
`rsAfterEditions_log` tinyint(4) unsigned NOT NULL default '0',
950
`rsAfterValidationsRefused_log` tinyint(4) unsigned NOT NULL default '0',
951
`rsAfterPublication_log` tinyint(4) unsigned NOT NULL default '0',
952
PRIMARY KEY (`id_log`),
953
KEY `user_log` (`user_log`),
954
KEY `action_log` (`action_log`)
955
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
958
-- Contenu de la table `log`
962
-- --------------------------------------------------------
965
-- Structure de la table `messages`
968
DROP TABLE IF EXISTS `messages`;
969
CREATE TABLE `messages` (
970
`id_mes` int(11) unsigned NOT NULL auto_increment,
971
`module_mes` varchar(50) NOT NULL,
972
`language_mes` varchar(3) NOT NULL,
973
`message_mes` text NOT NULL,
974
UNIQUE KEY `id` (`id_mes`,`module_mes`,`language_mes`),
975
KEY `module` (`module_mes`),
976
KEY `language` (`language_mes`)
977
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
980
-- Contenu de la table `messages`
984
-- --------------------------------------------------------
987
-- Structure de la table `modules`
990
DROP TABLE IF EXISTS `modules`;
991
CREATE TABLE `modules` (
992
`id_mod` int(11) unsigned NOT NULL auto_increment,
993
`label_mod` int(11) unsigned NOT NULL default '0',
994
`codename_mod` varchar(20) NOT NULL default '',
995
`administrationFrontend_mod` varchar(100) NOT NULL default '',
996
`hasParameters_mod` tinyint(4) NOT NULL default '0',
997
`isPolymod_mod` int(1) unsigned NOT NULL default '0',
998
PRIMARY KEY (`id_mod`),
999
KEY `codename_mod` (`codename_mod`),
1000
KEY `isPolymod_mod` (`isPolymod_mod`)
1001
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1004
-- Contenu de la table `modules`
1007
INSERT INTO `modules` (`id_mod`, `label_mod`, `codename_mod`, `administrationFrontend_mod`, `hasParameters_mod`, `isPolymod_mod`) VALUES(1, 243, 'standard', '', 1, 0);
1008
INSERT INTO `modules` (`id_mod`, `label_mod`, `codename_mod`, `administrationFrontend_mod`, `hasParameters_mod`, `isPolymod_mod`) VALUES(2, 1, 'cms_aliases', 'index.php', 0, 0);
1009
INSERT INTO `modules` (`id_mod`, `label_mod`, `codename_mod`, `administrationFrontend_mod`, `hasParameters_mod`, `isPolymod_mod`) VALUES(3, 1, 'cms_forms', 'index.php', 1, 0);
1010
INSERT INTO `modules` (`id_mod`, `label_mod`, `codename_mod`, `administrationFrontend_mod`, `hasParameters_mod`, `isPolymod_mod`) VALUES(4, 1, 'pnews', 'index.php', 0, 1);
1011
INSERT INTO `modules` (`id_mod`, `label_mod`, `codename_mod`, `administrationFrontend_mod`, `hasParameters_mod`, `isPolymod_mod`) VALUES(5, 1, 'pmedia', 'index.php', 0, 1);
1013
-- --------------------------------------------------------
1016
-- Structure de la table `modulesCategories`
1019
DROP TABLE IF EXISTS `modulesCategories`;
1020
CREATE TABLE `modulesCategories` (
1021
`id_mca` int(11) unsigned NOT NULL auto_increment,
1022
`uuid_mca` varchar(36) NOT NULL,
1023
`module_mca` varchar(20) NOT NULL default '',
1024
`parent_mca` int(10) unsigned NOT NULL default '0',
1025
`root_mca` int(10) unsigned NOT NULL default '0',
1026
`lineage_mca` varchar(255) NOT NULL default '',
1027
`order_mca` int(10) unsigned NOT NULL default '1',
1028
`icon_mca` varchar(255) NOT NULL default '',
1029
PRIMARY KEY (`id_mca`),
1030
KEY `module` (`module_mca`),
1031
KEY `lineage` (`lineage_mca`),
1032
KEY `parent` (`parent_mca`),
1033
KEY `root` (`root_mca`)
1034
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1037
-- Contenu de la table `modulesCategories`
1040
INSERT INTO `modulesCategories` (`id_mca`, `uuid_mca`, `module_mca`, `parent_mca`, `root_mca`, `lineage_mca`, `order_mca`, `icon_mca`) VALUES(1, '3e60e534-0ba9-102e-80e2-001a6470da26', 'cms_forms', 0, 0, '1', 1, '');
1041
INSERT INTO `modulesCategories` (`id_mca`, `uuid_mca`, `module_mca`, `parent_mca`, `root_mca`, `lineage_mca`, `order_mca`, `icon_mca`) VALUES(2, '3e60e656-0ba9-102e-80e2-001a6470da26', 'pnews', 0, 0, '2', 2, '');
1042
INSERT INTO `modulesCategories` (`id_mca`, `uuid_mca`, `module_mca`, `parent_mca`, `root_mca`, `lineage_mca`, `order_mca`, `icon_mca`) VALUES(18, '3e60e714-0ba9-102e-80e2-001a6470da26', 'pmedia', 0, 0, '18', 5, '');
1044
-- --------------------------------------------------------
1047
-- Structure de la table `modulesCategories_clearances`
1050
DROP TABLE IF EXISTS `modulesCategories_clearances`;
1051
CREATE TABLE `modulesCategories_clearances` (
1052
`id_mcc` int(11) unsigned NOT NULL auto_increment,
1053
`profile_mcc` int(11) unsigned NOT NULL default '0',
1054
`category_mcc` int(10) unsigned NOT NULL default '0',
1055
`clearance_mcc` tinyint(16) unsigned NOT NULL default '0',
1056
PRIMARY KEY (`id_mcc`),
1057
UNIQUE KEY `profilecategories` (`profile_mcc`,`category_mcc`),
1058
KEY `profile` (`profile_mcc`),
1059
KEY `category` (`category_mcc`)
1060
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1063
-- Contenu de la table `modulesCategories_clearances`
1066
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(668, 1, 18, 3);
1067
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(172, 3, 2, 1);
1068
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(171, 3, 1, 1);
1069
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(667, 1, 2, 3);
1070
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(626, 4, 2, 3);
1071
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(625, 4, 1, 3);
1072
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(666, 1, 1, 3);
1073
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(645, 10, 18, 3);
1074
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(644, 10, 2, 3);
1075
INSERT INTO `modulesCategories_clearances` (`id_mcc`, `profile_mcc`, `category_mcc`, `clearance_mcc`) VALUES(629, 4, 18, 3);
1077
-- --------------------------------------------------------
1080
-- Structure de la table `modulesCategories_i18nm`
1083
DROP TABLE IF EXISTS `modulesCategories_i18nm`;
1084
CREATE TABLE `modulesCategories_i18nm` (
1085
`id_mcl` int(11) unsigned NOT NULL auto_increment,
1086
`category_mcl` int(11) unsigned NOT NULL default '0',
1087
`language_mcl` char(2) NOT NULL default 'en',
1088
`label_mcl` varchar(255) NOT NULL default '',
1089
`description_mcl` text NOT NULL,
1090
`file_mcl` varchar(255) NOT NULL default '',
1091
PRIMARY KEY (`id_mcl`),
1092
UNIQUE KEY `categoryperlang` (`category_mcl`,`language_mcl`),
1093
KEY `category` (`category_mcl`),
1094
KEY `language` (`language_mcl`)
1095
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1098
-- Contenu de la table `modulesCategories_i18nm`
1101
INSERT INTO `modulesCategories_i18nm` (`id_mcl`, `category_mcl`, `language_mcl`, `label_mcl`, `description_mcl`, `file_mcl`) VALUES(167, 1, 'en', 'Forms', '', '');
1102
INSERT INTO `modulesCategories_i18nm` (`id_mcl`, `category_mcl`, `language_mcl`, `label_mcl`, `description_mcl`, `file_mcl`) VALUES(168, 1, 'fr', 'Formulaire', '', '');
1103
INSERT INTO `modulesCategories_i18nm` (`id_mcl`, `category_mcl`, `language_mcl`, `label_mcl`, `description_mcl`, `file_mcl`) VALUES(155, 2, 'en', 'News', '', '');
1104
INSERT INTO `modulesCategories_i18nm` (`id_mcl`, `category_mcl`, `language_mcl`, `label_mcl`, `description_mcl`, `file_mcl`) VALUES(156, 2, 'fr', 'Actualités', '', '');
1105
INSERT INTO `modulesCategories_i18nm` (`id_mcl`, `category_mcl`, `language_mcl`, `label_mcl`, `description_mcl`, `file_mcl`) VALUES(113, 18, 'en', 'Media', '', '');
1106
INSERT INTO `modulesCategories_i18nm` (`id_mcl`, `category_mcl`, `language_mcl`, `label_mcl`, `description_mcl`, `file_mcl`) VALUES(114, 18, 'fr', 'Média', '', '');
1108
-- --------------------------------------------------------
1111
-- Structure de la table `mod_ase_document`
1114
DROP TABLE IF EXISTS `mod_ase_document`;
1115
CREATE TABLE `mod_ase_document` (
1116
`id_mased` int(11) unsigned NOT NULL auto_increment,
1117
`xid_mased` varchar(255) NOT NULL default '',
1118
`uid_mased` varchar(255) NOT NULL default '',
1119
`module_mased` varchar(20) NOT NULL default '',
1120
`language_mased` char(2) NOT NULL default '',
1121
`type_mased` varchar(10) NOT NULL default '',
1122
PRIMARY KEY (`id_mased`),
1123
UNIQUE KEY `mod-uid` (`uid_mased`,`module_mased`),
1124
KEY `xid_mased` (`xid_mased`)
1125
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1128
-- Contenu de la table `mod_ase_document`
1132
-- --------------------------------------------------------
1135
-- Structure de la table `mod_cms_aliases`
1138
DROP TABLE IF EXISTS `mod_cms_aliases`;
1139
CREATE TABLE `mod_cms_aliases` (
1140
`id_ma` int(11) unsigned NOT NULL auto_increment,
1141
`parent_ma` int(11) unsigned NOT NULL default '0',
1142
`page_ma` int(11) NOT NULL default '0',
1143
`url_ma` varchar(255) NOT NULL default '',
1144
`alias_ma` varchar(255) NOT NULL default '',
1145
PRIMARY KEY (`id_ma`),
1146
KEY `alias_ma` (`alias_ma`)
1147
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1150
-- Contenu de la table `mod_cms_aliases`
1154
-- --------------------------------------------------------
1157
-- Structure de la table `mod_cms_forms_actions`
1160
DROP TABLE IF EXISTS `mod_cms_forms_actions`;
1161
CREATE TABLE `mod_cms_forms_actions` (
1162
`id_act` int(10) unsigned NOT NULL auto_increment,
1163
`form_act` int(11) unsigned NOT NULL default '0',
1164
`value_act` mediumtext NOT NULL,
1165
`type_act` tinyint(2) unsigned NOT NULL default '0',
1166
`text_act` mediumtext NOT NULL,
1167
PRIMARY KEY (`id_act`)
1168
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1171
-- Contenu de la table `mod_cms_forms_actions`
1175
-- --------------------------------------------------------
1178
-- Structure de la table `mod_cms_forms_categories`
1181
DROP TABLE IF EXISTS `mod_cms_forms_categories`;
1182
CREATE TABLE `mod_cms_forms_categories` (
1183
`id_fca` int(11) unsigned NOT NULL auto_increment,
1184
`form_fca` int(11) unsigned NOT NULL default '0',
1185
`category_fca` int(11) unsigned NOT NULL default '0',
1186
PRIMARY KEY (`id_fca`)
1187
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1190
-- Contenu de la table `mod_cms_forms_categories`
1194
-- --------------------------------------------------------
1197
-- Structure de la table `mod_cms_forms_fields`
1200
DROP TABLE IF EXISTS `mod_cms_forms_fields`;
1201
CREATE TABLE `mod_cms_forms_fields` (
1202
`id_fld` int(11) unsigned NOT NULL auto_increment,
1203
`form_fld` int(11) unsigned NOT NULL default '0',
1204
`name_fld` varchar(32) NOT NULL default '',
1205
`label_fld` varchar(255) NOT NULL default '',
1206
`defaultValue_fld` mediumtext NOT NULL,
1207
`dataValidation_fld` varchar(100) NOT NULL default '',
1208
`type_fld` varchar(255) NOT NULL default '',
1209
`options_fld` mediumtext NOT NULL,
1210
`required_fld` int(1) NOT NULL default '0',
1211
`active_fld` int(1) NOT NULL default '0',
1212
`order_fld` int(11) unsigned NOT NULL default '0',
1213
`params_fld` mediumtext NOT NULL,
1214
PRIMARY KEY (`id_fld`)
1215
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1218
-- Contenu de la table `mod_cms_forms_fields`
1222
-- --------------------------------------------------------
1225
-- Structure de la table `mod_cms_forms_formulars`
1228
DROP TABLE IF EXISTS `mod_cms_forms_formulars`;
1229
CREATE TABLE `mod_cms_forms_formulars` (
1230
`id_frm` int(11) unsigned NOT NULL auto_increment,
1231
`name_frm` varchar(255) NOT NULL default '',
1232
`source_frm` text NOT NULL,
1233
`language_frm` char(2) NOT NULL default 'en',
1234
`owner_frm` int(11) unsigned NOT NULL default '0',
1235
`closed_frm` tinyint(1) NOT NULL default '0',
1236
`destinationType_frm` int(2) NOT NULL default '0',
1237
`DestinationData_frm` mediumtext NOT NULL,
1238
`responses_frm` int(11) unsigned NOT NULL default '0',
1239
PRIMARY KEY (`id_frm`)
1240
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1243
-- Contenu de la table `mod_cms_forms_formulars`
1247
-- --------------------------------------------------------
1250
-- Structure de la table `mod_cms_forms_records`
1253
DROP TABLE IF EXISTS `mod_cms_forms_records`;
1254
CREATE TABLE `mod_cms_forms_records` (
1255
`id_rec` int(11) unsigned NOT NULL auto_increment,
1256
`sending_rec` int(11) unsigned NOT NULL default '0',
1257
`field_rec` int(11) unsigned NOT NULL default '0',
1258
`value_rec` text NOT NULL,
1259
PRIMARY KEY (`id_rec`)
1260
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1263
-- Contenu de la table `mod_cms_forms_records`
1267
-- --------------------------------------------------------
1270
-- Structure de la table `mod_cms_forms_senders`
1273
DROP TABLE IF EXISTS `mod_cms_forms_senders`;
1274
CREATE TABLE `mod_cms_forms_senders` (
1275
`id_snd` int(11) unsigned NOT NULL auto_increment,
1276
`clientIP_snd` varchar(255) NOT NULL default '',
1277
`dateInserted_snd` datetime default '0000-00-00 00:00:00',
1278
`sessionID_snd` varchar(100) NOT NULL default '',
1279
`userAgent_snd` varchar(255) NOT NULL default '',
1280
`languages_snd` varchar(255) NOT NULL default '',
1281
`userID_snd` int(11) unsigned NOT NULL default '0',
1282
PRIMARY KEY (`id_snd`),
1283
KEY `userID_snd` (`userID_snd`),
1284
KEY `sessionID_snd` (`sessionID_snd`)
1285
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1288
-- Contenu de la table `mod_cms_forms_senders`
1292
-- --------------------------------------------------------
1295
-- Structure de la table `mod_object_definition`
1298
DROP TABLE IF EXISTS `mod_object_definition`;
1299
CREATE TABLE `mod_object_definition` (
1300
`id_mod` int(11) unsigned NOT NULL auto_increment,
1301
`uuid_mod` varchar(36) NOT NULL,
1302
`label_id_mod` int(11) unsigned NOT NULL default '0',
1303
`description_id_mod` int(11) unsigned NOT NULL default '0',
1304
`resource_usage_mod` int(2) unsigned NOT NULL default '0',
1305
`module_mod` varchar(255) NOT NULL default '',
1306
`admineditable_mod` int(1) unsigned NOT NULL default '0',
1307
`composedLabel_mod` varchar(255) NOT NULL default '',
1308
`previewURL_mod` varchar(255) NOT NULL default '',
1309
`indexable_mod` int(1) NOT NULL default '0',
1310
`indexURL_mod` mediumtext NOT NULL,
1311
`compiledIndexURL_mod` mediumtext NOT NULL,
1312
`resultsDefinition_mod` mediumtext NOT NULL,
1313
PRIMARY KEY (`id_mod`),
1314
KEY `module_mod` (`module_mod`)
1315
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1318
-- Contenu de la table `mod_object_definition`
1321
INSERT INTO `mod_object_definition` (`id_mod`, `uuid_mod`, `label_id_mod`, `description_id_mod`, `resource_usage_mod`, `module_mod`, `admineditable_mod`, `composedLabel_mod`, `previewURL_mod`, `indexable_mod`, `indexURL_mod`, `compiledIndexURL_mod`, `resultsDefinition_mod`) VALUES(1, '3e517ad6-0ba9-102e-80e2-001a6470da26', 1, 2, 1, 'pnews', 0, '', '', 0, '', '', '');
1322
INSERT INTO `mod_object_definition` (`id_mod`, `uuid_mod`, `label_id_mod`, `description_id_mod`, `resource_usage_mod`, `module_mod`, `admineditable_mod`, `composedLabel_mod`, `previewURL_mod`, `indexable_mod`, `indexURL_mod`, `compiledIndexURL_mod`, `resultsDefinition_mod`) VALUES(2, '3e517c2a-0ba9-102e-80e2-001a6470da26', 70, 71, 1, 'pmedia', 0, '', '', 0, '', '', '<div class="pmedias">\r\n <atm-if what="{[''object2''][''fields''][9][''thumbnail'']} && {[''object2''][''fields''][9][''fileExtension'']} != ''flv'' && {[''object2''][''fields''][9][''fileExtension'']} != ''mp3''">\r\n <p style="float:right;"><a href="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}" target="_blank"><img src="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''thumbnail'']}" /></a></p>\r\n </atm-if>\r\n <atm-if what="{[''object2''][''fields''][9][''fileExtension'']} == ''flv''">\r\n <atm-if what="{[''object2''][''fields''][9][''thumbnail'']}">\r\n <script type="text/javascript">\r\n swfobject.embedSWF(''{constant:string:PATH_REALROOT_WR}/automne/playerflv/player_flv.swf'', ''media-{[''object2''][''id'']}'', ''320'', ''200'', ''9.0.0'', ''{constant:string:PATH_REALROOT_WR}/automne/swfobject/expressInstall.swf'', {flv:''{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}'', configxml:''{constant:string:PATH_REALROOT_WR}/automne/playerflv/config_playerflv.xml'', startimage:''{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''thumbnail'']}''}, {allowfullscreen:true, wmode:''transparent''}, {''style'':''float:right;''});\r\n </script>\r\n </atm-if>\r\n <atm-if what="!{[''object2''][''fields''][9][''thumbnail'']}">\r\n <script type="text/javascript">\r\n swfobject.embedSWF(''{constant:string:PATH_REALROOT_WR}/automne/playerflv/player_flv.swf'', ''media-{[''object2''][''id'']}'', ''320'', ''200'', ''9.0.0'', ''{constant:string:PATH_REALROOT_WR}/automne/swfobject/expressInstall.swf'', {flv:''{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}'', configxml:''{constant:string:PATH_REALROOT_WR}/automne/playerflv/config_playerflv.xml''}, {allowfullscreen:true, wmode:''transparent''}, {''style'':''float:right;''});\r\n </script>\r\n </atm-if>\r\n <div id="media-{[''object2''][''id'']}" class="pmedias-video" style="width:320px;height:200px;float:right;">\r\n <p><a href="http://www.adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a></p>\r\n </div>\r\n </atm-if>\r\n <atm-if what="{[''object2''][''fields''][9][''fileExtension'']} == ''mp3''">\r\n <script type="text/javascript">\r\n swfobject.embedSWF(''{constant:string:PATH_REALROOT_WR}/automne/playermp3/player_mp3.swf'', ''media-{[''object2''][''id'']}'', ''200'', ''20'', ''9.0.0'', ''{constant:string:PATH_REALROOT_WR}/automne/swfobject/expressInstall.swf'', {mp3:''{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}'', configxml:''{constant:string:PATH_REALROOT_WR}/automne/playermp3/config_playermp3.xml''}, {wmode:''transparent''}, {''style'':''float:right;''});\r\n </script>\r\n <div id="media-{[''object2''][''id'']}" class="pmedias-audio" style="width:200px;height:20px;float:right;">\r\n <p><a href="http://www.adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a></p>\r\n </div>\r\n </atm-if>\r\n <p>{[''object2''][''fields''][9][''fieldname'']} : <strong><atm-if what="{[''object2''][''fields''][9][''fileIcon'']}"><img src="{[''object2''][''fields''][9][''fileIcon'']}" alt="{[''object2''][''fields''][9][''fileExtension'']}" title="{[''object2''][''fields''][9][''fileExtension'']}" /></atm-if> {[''object2''][''fields''][9][''fileHTML'']} ({[''object2''][''fields''][9][''fileSize'']}Mo)</strong></p>\r\n <p>{[''object2''][''fields''][8][''fieldname'']} : <strong>{[''object2''][''fields''][8][''label'']}</strong></p>\r\n <div style="clear:both;"> </div>\r\n</div>');
1324
-- --------------------------------------------------------
1327
-- Structure de la table `mod_object_field`
1330
DROP TABLE IF EXISTS `mod_object_field`;
1331
CREATE TABLE `mod_object_field` (
1332
`id_mof` int(11) unsigned NOT NULL auto_increment,
1333
`uuid_mof` varchar(36) NOT NULL,
1334
`object_id_mof` int(11) unsigned NOT NULL default '0',
1335
`label_id_mof` int(11) unsigned NOT NULL default '0',
1336
`desc_id_mof` int(11) unsigned NOT NULL default '0',
1337
`type_mof` varchar(255) NOT NULL default '',
1338
`order_mof` int(11) unsigned NOT NULL default '0',
1339
`system_mof` int(1) unsigned NOT NULL default '0',
1340
`required_mof` int(1) unsigned NOT NULL default '0',
1341
`indexable_mof` int(1) unsigned NOT NULL default '0',
1342
`searchlist_mof` int(1) unsigned NOT NULL default '0',
1343
`searchable_mof` int(1) unsigned NOT NULL default '0',
1344
`params_mof` mediumtext NOT NULL,
1345
PRIMARY KEY (`id_mof`),
1346
KEY `object_id_mof` (`object_id_mof`,`type_mof`)
1347
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1350
-- Contenu de la table `mod_object_field`
1353
INSERT INTO `mod_object_field` (`id_mof`, `uuid_mof`, `object_id_mof`, `label_id_mof`, `desc_id_mof`, `type_mof`, `order_mof`, `system_mof`, `required_mof`, `indexable_mof`, `searchlist_mof`, `searchable_mof`, `params_mof`) VALUES(1, '3e5932bc-0ba9-102e-80e2-001a6470da26', 1, 3, 0, 'CMS_object_string', 1, 0, 1, 0, 0, 1, 'a:3:{s:9:"maxLength";s:3:"255";s:7:"isEmail";b:0;s:8:"matchExp";s:0:"";}');
1354
INSERT INTO `mod_object_field` (`id_mof`, `uuid_mof`, `object_id_mof`, `label_id_mof`, `desc_id_mof`, `type_mof`, `order_mof`, `system_mof`, `required_mof`, `indexable_mof`, `searchlist_mof`, `searchable_mof`, `params_mof`) VALUES(2, '3e5933de-0ba9-102e-80e2-001a6470da26', 1, 4, 5, 'CMS_object_text', 3, 0, 1, 0, 0, 1, 'a:4:{s:4:"html";b:1;s:7:"toolbar";s:9:"BasicLink";s:12:"toolbarWidth";s:3:"550";s:13:"toolbarHeight";s:3:"200";}');
1355
INSERT INTO `mod_object_field` (`id_mof`, `uuid_mof`, `object_id_mof`, `label_id_mof`, `desc_id_mof`, `type_mof`, `order_mof`, `system_mof`, `required_mof`, `indexable_mof`, `searchlist_mof`, `searchable_mof`, `params_mof`) VALUES(3, '3e5934b0-0ba9-102e-80e2-001a6470da26', 1, 6, 7, 'CMS_object_text', 4, 0, 0, 0, 0, 1, 'a:4:{s:4:"html";b:1;s:7:"toolbar";s:9:"BasicLink";s:12:"toolbarWidth";s:3:"550";s:13:"toolbarHeight";s:3:"500";}');
1356
INSERT INTO `mod_object_field` (`id_mof`, `uuid_mof`, `object_id_mof`, `label_id_mof`, `desc_id_mof`, `type_mof`, `order_mof`, `system_mof`, `required_mof`, `indexable_mof`, `searchlist_mof`, `searchable_mof`, `params_mof`) VALUES(4, '3e593582-0ba9-102e-80e2-001a6470da26', 1, 8, 0, 'CMS_object_image', 5, 0, 0, 0, 0, 1, 'a:5:{s:8:"maxWidth";s:3:"100";s:9:"maxHeight";s:0:"";s:15:"useDistinctZoom";b:0;s:8:"makeZoom";b:1;s:14:"maxWidthPreviz";s:2:"16";}');
1357
INSERT INTO `mod_object_field` (`id_mof`, `uuid_mof`, `object_id_mof`, `label_id_mof`, `desc_id_mof`, `type_mof`, `order_mof`, `system_mof`, `required_mof`, `indexable_mof`, `searchlist_mof`, `searchable_mof`, `params_mof`) VALUES(5, '3e59364a-0ba9-102e-80e2-001a6470da26', 1, 9, 0, 'CMS_object_categories', 2, 0, 1, 0, 1, 1, 'a:6:{s:15:"multiCategories";b:0;s:12:"rootCategory";s:1:"2";s:12:"defaultValue";s:0:"";s:15:"associateUnused";b:0;s:11:"selectWidth";s:0:"";s:12:"selectHeight";s:0:"";}');
1358
INSERT INTO `mod_object_field` (`id_mof`, `uuid_mof`, `object_id_mof`, `label_id_mof`, `desc_id_mof`, `type_mof`, `order_mof`, `system_mof`, `required_mof`, `indexable_mof`, `searchlist_mof`, `searchable_mof`, `params_mof`) VALUES(6, '3e593712-0ba9-102e-80e2-001a6470da26', 2, 80, 0, 'CMS_object_string', 1, 0, 1, 0, 0, 1, 'a:3:{s:9:"maxLength";s:3:"255";s:7:"isEmail";b:0;s:8:"matchExp";s:0:"";}');
1359
INSERT INTO `mod_object_field` (`id_mof`, `uuid_mof`, `object_id_mof`, `label_id_mof`, `desc_id_mof`, `type_mof`, `order_mof`, `system_mof`, `required_mof`, `indexable_mof`, `searchlist_mof`, `searchable_mof`, `params_mof`) VALUES(7, '3e5937da-0ba9-102e-80e2-001a6470da26', 2, 83, 0, 'CMS_object_text', 2, 0, 0, 0, 0, 1, 'a:4:{s:4:"html";b:1;s:7:"toolbar";s:9:"BasicLink";s:12:"toolbarWidth";s:4:"100%";s:13:"toolbarHeight";s:3:"200";}');
1360
INSERT INTO `mod_object_field` (`id_mof`, `uuid_mof`, `object_id_mof`, `label_id_mof`, `desc_id_mof`, `type_mof`, `order_mof`, `system_mof`, `required_mof`, `indexable_mof`, `searchlist_mof`, `searchable_mof`, `params_mof`) VALUES(8, '3e5938ac-0ba9-102e-80e2-001a6470da26', 2, 84, 0, 'CMS_object_categories', 3, 0, 1, 0, 1, 1, 'a:6:{s:15:"multiCategories";b:0;s:12:"rootCategory";s:2:"18";s:12:"defaultValue";s:0:"";s:15:"associateUnused";b:0;s:11:"selectWidth";s:0:"";s:12:"selectHeight";s:0:"";}');
1361
INSERT INTO `mod_object_field` (`id_mof`, `uuid_mof`, `object_id_mof`, `label_id_mof`, `desc_id_mof`, `type_mof`, `order_mof`, `system_mof`, `required_mof`, `indexable_mof`, `searchlist_mof`, `searchable_mof`, `params_mof`) VALUES(9, '3e593974-0ba9-102e-80e2-001a6470da26', 2, 85, 86, 'CMS_object_file', 4, 0, 1, 0, 1, 1, 'a:8:{s:12:"useThumbnail";b:1;s:13:"thumbMaxWidth";s:3:"200";s:14:"thumbMaxHeight";s:0:"";s:9:"fileIcons";a:18:{s:3:"doc";s:7:"doc.gif";s:3:"gif";s:7:"gif.gif";s:4:"html";s:8:"html.gif";s:3:"htm";s:8:"html.gif";s:3:"jpg";s:7:"jpg.gif";s:4:"jpeg";s:7:"jpg.gif";s:3:"jpe";s:7:"jpg.gif";s:3:"mov";s:7:"mov.gif";s:3:"mp3";s:7:"mp3.gif";s:3:"pdf";s:7:"pdf.gif";s:3:"png";s:7:"png.gif";s:3:"ppt";s:7:"ppt.gif";s:3:"pps";s:7:"ppt.gif";s:3:"swf";s:7:"swf.gif";s:3:"sxw";s:7:"sxw.gif";s:3:"url";s:7:"url.gif";s:3:"xls";s:7:"xls.gif";s:3:"xml";s:7:"xml.gif";}s:8:"allowFtp";b:0;s:6:"ftpDir";s:13:"/automne/tmp/";s:11:"allowedType";s:0:"";s:14:"disallowedType";s:31:"exe,php,pif,vbs,bat,com,scr,reg";}');
1363
-- --------------------------------------------------------
1366
-- Structure de la table `mod_object_i18nm`
1369
DROP TABLE IF EXISTS `mod_object_i18nm`;
1370
CREATE TABLE `mod_object_i18nm` (
1371
`id_i18nm` int(11) unsigned NOT NULL auto_increment,
1372
`code_i18nm` char(2) NOT NULL default '',
1373
`value_i18nm` mediumtext NOT NULL,
1374
UNIQUE KEY `id` (`id_i18nm`,`code_i18nm`),
1375
KEY `code` (`code_i18nm`),
1376
KEY `id_2` (`id_i18nm`)
1377
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1380
-- Contenu de la table `mod_object_i18nm`
1383
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(1, 'fr', 'Actualités');
1384
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(1, 'en', 'News');
1385
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(2, 'fr', 'Cet élément permet de saisir des textes catégorisés et soumis à une date de publication.');
1386
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(2, 'en', 'This item allows you to enter texts categorized and subject to publication date.');
1387
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(3, 'fr', 'Titre');
1388
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(3, 'en', 'Title');
1389
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(4, 'fr', 'Introduction');
1390
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(4, 'en', 'Introduction');
1391
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(5, 'fr', 'Visible sur la page d''accueil');
1392
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(5, 'en', '');
1393
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(6, 'fr', 'Texte');
1394
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(6, 'en', 'Text');
1395
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(7, 'fr', 'Ce texte sera visible dans le détail d''une actualité');
1396
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(7, 'en', 'This text will be visible in the news detail');
1397
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(8, 'fr', 'Image');
1398
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(8, 'en', 'Image');
1399
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(9, 'fr', 'Catégorie');
1400
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(9, 'en', 'Category');
1401
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(10, 'fr', 'Automne : Actualités');
1402
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(10, 'en', '');
1403
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(11, 'fr', 'Fil RSS des actualités de la démonstration d''Automne');
1404
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(11, 'en', '');
1405
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(13, 'fr', 'Un document est un fichier Word, PDF au autre complété par un titre, une description, etc.');
1406
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(13, 'en', '');
1407
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(20, 'fr', 'Insérez un lien vers un document français dans vos textes.');
1408
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(20, 'en', 'Insert a link to a french document into your texts');
1409
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(22, 'fr', 'Insérez un lien vers un document anglais dans vos textes');
1410
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(22, 'en', 'Insert a link to an english document into your texts');
1411
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(24, 'fr', 'Cette ressource permet de publier des images soumises à validation');
1412
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(24, 'en', '');
1413
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(26, 'fr', 'Permet de catégoriser les images');
1414
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(26, 'en', '');
1415
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(29, 'fr', 'Titre de l''image');
1416
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(29, 'en', '');
1417
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(31, 'fr', 'Image de la photothèque, alignée à droite');
1418
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(31, 'en', '');
1419
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(33, 'fr', 'Image de la photothèque, alignée à gauche');
1420
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(33, 'en', '');
1421
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(34, 'fr', 'RSS de la photothèque');
1422
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(34, 'en', 'Pictures RSS');
1423
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(35, 'fr', 'Fil RSS de la photothèque');
1424
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(35, 'en', 'Pictures RSS feed');
1425
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(36, 'fr', 'Actualités de Automne');
1426
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(36, 'en', '');
1427
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(37, 'fr', 'Flux RSS du site de démonstration d''automne');
1428
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(37, 'en', '');
1429
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(38, 'fr', 'Actualités de Automne');
1430
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(38, 'en', '');
1431
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(39, 'fr', 'Flux RSS du site de démonstration d''automne');
1432
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(39, 'en', '');
1433
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(40, 'fr', 'Actualités de la démo Automne');
1434
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(40, 'en', 'News of Automne demo');
1435
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(41, 'fr', 'Flux RSS du site de démonstration d''automne');
1436
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(41, 'en', 'RSS feed of the Automne demonstration website.');
1437
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(42, 'fr', 'Média');
1438
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(42, 'en', 'Media');
1439
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(43, 'fr', 'Fichier média à télécharger. Ce peut-être une vidéo (flv), un son (mp3), une image (jpg, png, gif) ou bien tout autre document (doc, pdf, txt, etc.).');
1440
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(43, 'en', '');
1441
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(44, 'fr', 'Média');
1442
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(44, 'en', 'Media');
1443
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(45, 'fr', 'test');
1444
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(45, 'en', '');
1445
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(46, 'fr', 'Média');
1446
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(46, 'en', 'Media');
1447
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(47, 'fr', '');
1448
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(47, 'en', '');
1449
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(48, 'fr', 'Média');
1450
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(48, 'en', 'Media');
1451
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(49, 'fr', '');
1452
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(49, 'en', '');
1453
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(50, 'fr', 'Média');
1454
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(50, 'en', 'Media');
1455
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(51, 'fr', '');
1456
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(51, 'en', '');
1457
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(52, 'fr', 'Média');
1458
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(52, 'en', 'Media');
1459
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(53, 'fr', '');
1460
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(53, 'en', '');
1461
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(54, 'fr', 'Média');
1462
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(54, 'en', 'Media');
1463
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(55, 'fr', '');
1464
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(55, 'en', '');
1465
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(56, 'fr', 'Média');
1466
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(56, 'en', 'Media');
1467
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(57, 'fr', 'test');
1468
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(57, 'en', '');
1469
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(58, 'fr', 'Média');
1470
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(58, 'en', 'Media');
1471
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(59, 'fr', 'test');
1472
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(59, 'en', '');
1473
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(60, 'fr', 'Média');
1474
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(60, 'en', 'Media');
1475
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(61, 'fr', 'test');
1476
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(61, 'en', '');
1477
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(62, 'fr', 'Média');
1478
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(62, 'en', 'Media');
1479
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(63, 'fr', 'test');
1480
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(63, 'en', '');
1481
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(64, 'fr', 'Média');
1482
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(64, 'en', 'Media');
1483
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(65, 'fr', 'test');
1484
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(65, 'en', '');
1485
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(66, 'fr', 'Média');
1486
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(66, 'en', 'Media');
1487
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(67, 'fr', 'test');
1488
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(67, 'en', '');
1489
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(68, 'fr', 'Média');
1490
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(68, 'en', 'Media');
1491
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(69, 'fr', 'test');
1492
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(69, 'en', '');
1493
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(70, 'fr', 'Média');
1494
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(70, 'en', 'Media');
1495
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(71, 'fr', 'Média à télécharger de type Vidéo (flv), Image (jpg, gif, png), Son (mp3) ou tout autre type de fichier (doc, pdf, etc.).');
1496
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(71, 'en', 'Downloadable Media of type Video (flv), image (jpg, gif, png), Audio (mp3) or any other file type (doc, pdf, etc.).');
1497
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(72, 'fr', 'Titre');
1498
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(72, 'en', 'Title');
1499
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(73, 'fr', 'Titre');
1500
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(73, 'en', 'Title');
1501
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(74, 'fr', 'Titre');
1502
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(74, 'en', 'Title');
1503
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(75, 'fr', 'Titre');
1504
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(75, 'en', 'Title');
1505
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(76, 'fr', 'Titre');
1506
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(76, 'en', 'Title');
1507
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(77, 'fr', 'Titre');
1508
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(77, 'en', 'Title');
1509
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(78, 'fr', 'Titre');
1510
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(78, 'en', 'Title');
1511
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(79, 'fr', 'Titre');
1512
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(79, 'en', 'Title');
1513
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(80, 'fr', 'Titre');
1514
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(80, 'en', 'Title');
1515
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(81, 'fr', 'Description');
1516
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(82, 'fr', 'Description');
1517
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(83, 'fr', 'Description');
1518
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(83, 'en', 'Description');
1519
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(84, 'fr', 'Catégorie');
1520
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(84, 'en', 'Category');
1521
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(85, 'fr', 'Fichier');
1522
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(85, 'en', 'File');
1523
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(86, 'fr', 'Média à télécharger de type Vidéo (flv), Image (jpg, gif, png), Son (mp3) ou tout autre type de fichier (doc, pdf, etc.).');
1524
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(86, 'en', 'Downloadable Media type Video (flv), image (jpg, gif, png), Audio (mp3) or any other file type (doc, pdf, etc.).');
1525
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(87, 'fr', 'Insérer un Média');
1526
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(87, 'en', 'Insert a Media');
1527
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(88, 'fr', 'Insérez un Média depuis la Médiathèque directement dans votre texte.');
1528
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(88, 'en', 'Insert a Media from the Mediacenter directly into your text.');
1529
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(89, 'fr', 'Lien vers un Média');
1530
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(89, 'en', 'Link to Media');
1531
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(90, 'fr', 'Faites un lien depuis votre texte sélectionné vers un Média géré par le module Médiathèque');
1532
INSERT INTO `mod_object_i18nm` (`id_i18nm`, `code_i18nm`, `value_i18nm`) VALUES(90, 'en', 'Make a link from your selected text to a Media managed by the Mediacenter module');
1534
-- --------------------------------------------------------
1537
-- Structure de la table `mod_object_plugin_definition`
1540
DROP TABLE IF EXISTS `mod_object_plugin_definition`;
1541
CREATE TABLE `mod_object_plugin_definition` (
1542
`id_mowd` int(11) unsigned NOT NULL auto_increment,
1543
`uuid_mowd` varchar(36) NOT NULL,
1544
`object_id_mowd` int(11) unsigned NOT NULL default '0',
1545
`label_id_mowd` int(11) unsigned NOT NULL default '0',
1546
`description_id_mowd` int(11) unsigned NOT NULL default '0',
1547
`query_mowd` mediumtext NOT NULL,
1548
`definition_mowd` mediumtext NOT NULL,
1549
`compiled_definition_mowd` mediumtext NOT NULL,
1550
PRIMARY KEY (`id_mowd`),
1551
KEY `object_id_mowd` (`object_id_mowd`)
1552
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1555
-- Contenu de la table `mod_object_plugin_definition`
1558
INSERT INTO `mod_object_plugin_definition` (`id_mowd`, `uuid_mowd`, `object_id_mowd`, `label_id_mowd`, `description_id_mowd`, `query_mowd`, `definition_mowd`, `compiled_definition_mowd`) VALUES(1, '3e69e1a2-0ba9-102e-80e2-001a6470da26', 2, 87, 88, 'a:1:{i:8;s:1:"0";}', '<atm-plugin language="fr">\r\n <atm-plugin-valid>\r\n <atm-if what="{[''object2''][''fields''][9][''fileExtension'']} != ''flv'' && {[''object2''][''fields''][9][''fileExtension'']} != ''mp3'' && {[''object2''][''fields''][9][''fileExtension'']} != ''jpg'' && {[''object2''][''fields''][9][''fileExtension'']} != ''gif'' && {[''object2''][''fields''][9][''fileExtension'']} != ''png''">\r\n <a href="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}" target="_blank" title="Télécharger le document ''{[''object2''][''fields''][9][''fileLabel'']}'' ({[''object2''][''fields''][9][''fileExtension'']} - {[''object2''][''fields''][9][''fileSize'']}Mo)"><atm-if what="{[''object2''][''fields''][9][''fileIcon'']}"><img src="{[''object2''][''fields''][9][''fileIcon'']}" alt="Fichier {[''object2''][''fields''][9][''fileExtension'']}" title="Fichier {[''object2''][''fields''][9][''fileExtension'']}" /></atm-if> {[''object2''][''label'']}</a>\r\n </atm-if>\r\n <atm-if what="{[''object2''][''fields''][9][''fileExtension'']} == ''flv''">\r\n <atm-if what="{[''object2''][''fields''][9][''thumbnail'']}">\r\n <script type="text/javascript" src="js/modules/pmedia/swfobject.js"></script>\r\n <script type="text/javascript">\r\n swfobject.addLoadEvent(function(){\r\n swfobject.embedSWF(''automne/playerflv/player_flv.swf'', ''media-{[''object2''][''id'']}'', ''320'', ''200'', ''9.0.0'', ''automne/swfobject/expressInstall.swf'', {flv:''{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}'', configxml:''automne/playerflv/config_playerflv.xml'', startimage:''{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''thumbnail'']}''}, {allowfullscreen:true, wmode:''transparent''}, false);\r\n });\r\n </script>\r\n </atm-if>\r\n <atm-if what="!{[''object2''][''fields''][9][''thumbnail'']}">\r\n <script type="text/javascript" src="js/modules/pmedia/swfobject.js"></script>\r\n <script type="text/javascript">\r\n swfobject.addLoadEvent(function(){\r\n swfobject.embedSWF(''automne/playerflv/player_flv.swf'', ''media-{[''object2''][''id'']}'', ''320'', ''200'', ''9.0.0'', ''automne/swfobject/expressInstall.swf'', {flv:''{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}'', configxml:''automne/playerflv/config_playerflv.xml''}, {allowfullscreen:true, wmode:''transparent''}, false);\r\n });\r\n </script>\r\n </atm-if>\r\n <div id="media-{[''object2''][''id'']}" class="pmedias-video" style="width:320px;height:200px;">\r\n <p><a href="http://www.adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a></p>\r\n </div>\r\n </atm-if>\r\n <atm-if what="{[''object2''][''fields''][9][''fileExtension'']} == ''mp3''">\r\n <script type="text/javascript" src="js/modules/pmedia/swfobject.js"></script>\r\n <script type="text/javascript">\r\n swfobject.addLoadEvent(function(){\r\n swfobject.embedSWF(''automne/playermp3/player_mp3.swf'', ''media-{[''object2''][''id'']}'', ''200'', ''20'', ''9.0.0'', ''automne/swfobject/expressInstall.swf'', {mp3:''{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}'', configxml:''automne/playermp3/config_playermp3.xml''}, {wmode:''transparent''}, false);\r\n });\r\n </script>\r\n <div id="media-{[''object2''][''id'']}" class="pmedias-audio" style="width:200px;height:20px;">\r\n <p><a href="http://www.adobe.com/go/getflashplayer"><img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" /></a></p>\r\n </div>\r\n </atm-if>\r\n <atm-if what="{[''object2''][''fields''][9][''fileExtension'']} == ''jpg'' || {[''object2''][''fields''][9][''fileExtension'']} == ''gif'' || {[''object2''][''fields''][9][''fileExtension'']} == ''png''">\r\n <atm-if what="{[''object2''][''fields''][9][''thumbnail'']}">\r\n <a href="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}" onclick="javascript:CMS_openPopUpImage(''imagezoom.php?location=public&module=pmedia&file={[''object2''][''fields''][9][''filename'']}&label={[''object2''][''label'']|js}'');return false;" target="_blank" title="Voir l''image ''{[''object2''][''label'']}'' ({[''object2''][''fields''][9][''fileExtension'']} - {[''object2''][''fields''][9][''fileSize'']}Mo)"><img src="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''thumbnail'']}" alt="{[''object2''][''label'']}" title="{[''object2''][''label'']}" /></a>\r\n </atm-if>\r\n <atm-if what="!{[''object2''][''fields''][9][''thumbnail'']}">\r\n <img src="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}" alt="{[''object2''][''label'']}" title="{[''object2''][''label'']}" style="max-width:200px;" />\r\n </atm-if>\r\n </atm-if>\r\n </atm-plugin-valid>\r\n <atm-plugin-view>\r\n <atm-if what="{[''object2''][''fields''][9][''fileExtension'']} != ''jpg'' && {[''object2''][''fields''][9][''fileExtension'']} != ''gif'' && {[''object2''][''fields''][9][''fileExtension'']} != ''png''">\r\n <a href="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}" target="_blank" title="Télécharger le document ''{[''object2''][''fields''][9][''fileLabel'']}'' ({[''object2''][''fields''][9][''fileExtension'']} - {[''object2''][''fields''][9][''fileSize'']}Mo)"><atm-if what="{[''object2''][''fields''][9][''fileIcon'']}"><img src="{[''object2''][''fields''][9][''fileIcon'']}" alt="Fichier {[''object2''][''fields''][9][''fileExtension'']}" title="Fichier {[''object2''][''fields''][9][''fileExtension'']}" /></atm-if> {[''object2''][''label'']}</a>\r\n </atm-if>\r\n <atm-if what="{[''object2''][''fields''][9][''fileExtension'']} == ''jpg'' || {[''object2''][''fields''][9][''fileExtension'']} == ''gif'' || {[''object2''][''fields''][9][''fileExtension'']} == ''png''">\r\n <atm-if what="{[''object2''][''fields''][9][''thumbnail'']}">\r\n <a href="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}" onclick="javascript:CMS_openPopUpImage(''imagezoom.php?location=public&module=pmedia&file={[''object2''][''fields''][9][''filename'']}&label={[''object2''][''label'']|js}'');return false;" target="_blank" title="Voir l''image ''{[''object2''][''label'']}'' ({[''object2''][''fields''][9][''fileExtension'']} - {[''object2''][''fields''][9][''fileSize'']}Mo)"><img src="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''thumbnail'']}" alt="{[''object2''][''label'']}" title="{[''object2''][''label'']}" /></a>\r\n </atm-if>\r\n <atm-if what="!{[''object2''][''fields''][9][''thumbnail'']}">\r\n <img src="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}" alt="{[''object2''][''label'']}" title="{[''object2''][''label'']}" style="max-width:200px;" />\r\n </atm-if>\r\n </atm-if>\r\n </atm-plugin-view>\r\n</atm-plugin>', '<?php\n/*Generated on Fri, 10 Sep 2010 16:48:53 +0200 by Automne (TM) 4.1.0a1 */\nif(!APPLICATION_ENFORCES_ACCESS_CONTROL || (isset($cms_user) && is_a($cms_user, ''CMS_profile_user'') && $cms_user->hasModuleClearance(''pmedia'', CLEARANCE_MODULE_VIEW))){\n $content = "";\n $replace = "";\n $atmIfResults = array();\n if (!isset($objectDefinitions) || !is_array($objectDefinitions)) $objectDefinitions = array();\n $parameters[''objectID''] = 2;\n if (!isset($cms_language) || (isset($cms_language) && $cms_language->getCode() != ''fr'')) $cms_language = new CMS_language(''fr'');\n $parameters[''public''] = (isset($parameters[''public''])) ? $parameters[''public''] : true;\n if (isset($parameters[''item''])) {$parameters[''objectID''] = $parameters[''item'']->getObjectID();} elseif (isset($parameters[''itemID'']) && sensitiveIO::isPositiveInteger($parameters[''itemID'']) && !isset($parameters[''objectID''])) $parameters[''objectID''] = CMS_poly_object_catalog::getObjectDefinitionByID($parameters[''itemID'']);\n if (!isset($object) || !is_array($object)) $object = array();\n if (!isset($object[2])) $object[2] = new CMS_poly_object(2, 0, array(), $parameters[''public'']);\n $parameters[''module''] = ''pmedia'';\n //PLUGIN TAG START 19_42c3db\n if (!sensitiveIO::isPositiveInteger($parameters[''itemID'']) || !sensitiveIO::isPositiveInteger($parameters[''objectID''])) {\n CMS_grandFather::raiseError(''Error into atm-plugin tag : can\\''t found object infos to use into : $parameters[\\''itemID\\''] and $parameters[\\''objectID\\'']'');\n } else {\n //search needed object (need to search it for publications and rights purpose)\n if (!isset($objectDefinitions[$parameters[''objectID'']])) {\n $objectDefinitions[$parameters[''objectID'']] = new CMS_poly_object_definition($parameters[''objectID'']);\n }\n $search_19_42c3db = new CMS_object_search($objectDefinitions[$parameters[''objectID'']], $parameters[''public'']);\n $search_19_42c3db->addWhereCondition(''item'', $parameters[''itemID'']);\n $results_19_42c3db = $search_19_42c3db->search();\n if (isset($results_19_42c3db[$parameters[''itemID'']]) && is_object($results_19_42c3db[$parameters[''itemID'']])) {\n $object[$parameters[''objectID'']] = $results_19_42c3db[$parameters[''itemID'']];\n } else {\n $object[$parameters[''objectID'']] = new CMS_poly_object($parameters[''objectID''], 0, array(), $parameters[''public'']);\n }\n unset($search_19_42c3db);\n $parameters[''has-plugin-view''] = true;\n //PLUGIN-VALID TAG START 20_c9ca95\n if ($object[$parameters[''objectID'']]->isInUserSpace() && !(@$parameters[''plugin-view''] && @$parameters[''has-plugin-view'']) ) {\n //IF TAG START 21_8fc252\n $ifcondition_21_8fc252 = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." != ''flv'' && ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." != ''mp3'' && ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." != ''jpg'' && ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." != ''gif'' && ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." != ''png''", $replace);\n if ($ifcondition_21_8fc252) {\n $func_21_8fc252 = create_function("","return (".$ifcondition_21_8fc252.");");\n if ($func_21_8fc252()) {\n $content .="\n <a href=\\"".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."\\" target=\\"_blank\\" title=\\"Télécharger le document ''".$object[2]->objectValues(9)->getValue(''fileLabel'','''')."'' (".$object[2]->objectValues(9)->getValue(''fileExtension'','''')." - ".$object[2]->objectValues(9)->getValue(''fileSize'','''')."Mo)\\">";\n //IF TAG START 22_e81162\n $ifcondition_22_e81162 = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileIcon'','''')), $replace);\n if ($ifcondition_22_e81162) {\n $func_22_e81162 = create_function("","return (".$ifcondition_22_e81162.");");\n if ($func_22_e81162()) {\n $content .="<img src=\\"".$object[2]->objectValues(9)->getValue(''fileIcon'','''')."\\" alt=\\"Fichier ".$object[2]->objectValues(9)->getValue(''fileExtension'','''')."\\" title=\\"Fichier ".$object[2]->objectValues(9)->getValue(''fileExtension'','''')."\\" />";\n }\n unset($func_22_e81162);\n }\n unset($ifcondition_22_e81162);\n //IF TAG END 22_e81162\n $content .=" ".$object[2]->getValue(''label'','''')."</a>\n ";\n }\n unset($func_21_8fc252);\n }\n unset($ifcondition_21_8fc252);\n //IF TAG END 21_8fc252\n //IF TAG START 23_c79f4d\n $ifcondition_23_c79f4d = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." == ''flv''", $replace);\n if ($ifcondition_23_c79f4d) {\n $func_23_c79f4d = create_function("","return (".$ifcondition_23_c79f4d.");");\n if ($func_23_c79f4d()) {\n //IF TAG START 24_a6db21\n $ifcondition_24_a6db21 = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''thumbnail'','''')), $replace);\n if ($ifcondition_24_a6db21) {\n $func_24_a6db21 = create_function("","return (".$ifcondition_24_a6db21.");");\n if ($func_24_a6db21()) {\n $content .="\n <script type=\\"text/javascript\\" src=\\"js/modules/pmedia/swfobject.js\\"></script>\n <script type=\\"text/javascript\\">\n swfobject.addLoadEvent(function(){\n swfobject.embedSWF(''automne/playerflv/player_flv.swf'', ''media-".$object[2]->getValue(''id'','''')."'', ''320'', ''200'', ''9.0.0'', ''automne/swfobject/expressInstall.swf'', {flv:''".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."'', configxml:''automne/playerflv/config_playerflv.xml'', startimage:''".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''thumbnail'','''')."''}, {allowfullscreen:true, wmode:''transparent''}, false);\n });\n </script>\n ";\n }\n unset($func_24_a6db21);\n }\n unset($ifcondition_24_a6db21);\n //IF TAG END 24_a6db21\n //IF TAG START 25_21cb8e\n $ifcondition_25_21cb8e = CMS_polymod_definition_parsing::replaceVars("!".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''thumbnail'','''')), $replace);\n if ($ifcondition_25_21cb8e) {\n $func_25_21cb8e = create_function("","return (".$ifcondition_25_21cb8e.");");\n if ($func_25_21cb8e()) {\n $content .="\n <script type=\\"text/javascript\\" src=\\"js/modules/pmedia/swfobject.js\\"></script>\n <script type=\\"text/javascript\\">\n swfobject.addLoadEvent(function(){\n swfobject.embedSWF(''automne/playerflv/player_flv.swf'', ''media-".$object[2]->getValue(''id'','''')."'', ''320'', ''200'', ''9.0.0'', ''automne/swfobject/expressInstall.swf'', {flv:''".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."'', configxml:''automne/playerflv/config_playerflv.xml''}, {allowfullscreen:true, wmode:''transparent''}, false);\n });\n </script>\n ";\n }\n unset($func_25_21cb8e);\n }\n unset($ifcondition_25_21cb8e);\n //IF TAG END 25_21cb8e\n $content .="\n <div id=\\"media-".$object[2]->getValue(''id'','''')."\\" class=\\"pmedias-video\\" style=\\"width:320px;height:200px;\\">\n <p><a href=\\"http://www.adobe.com/go/getflashplayer\\"><img src=\\"http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif\\" alt=\\"Get Adobe Flash player\\" /></a></p>\n </div>\n ";\n }\n unset($func_23_c79f4d);\n }\n unset($ifcondition_23_c79f4d);\n //IF TAG END 23_c79f4d\n //IF TAG START 26_9eb7ee\n $ifcondition_26_9eb7ee = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." == ''mp3''", $replace);\n if ($ifcondition_26_9eb7ee) {\n $func_26_9eb7ee = create_function("","return (".$ifcondition_26_9eb7ee.");");\n if ($func_26_9eb7ee()) {\n $content .="\n <script type=\\"text/javascript\\" src=\\"js/modules/pmedia/swfobject.js\\"></script>\n <script type=\\"text/javascript\\">\n swfobject.addLoadEvent(function(){\n swfobject.embedSWF(''automne/playermp3/player_mp3.swf'', ''media-".$object[2]->getValue(''id'','''')."'', ''200'', ''20'', ''9.0.0'', ''automne/swfobject/expressInstall.swf'', {mp3:''".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."'', configxml:''automne/playermp3/config_playermp3.xml''}, {wmode:''transparent''}, false);\n });\n </script>\n <div id=\\"media-".$object[2]->getValue(''id'','''')."\\" class=\\"pmedias-audio\\" style=\\"width:200px;height:20px;\\">\n <p><a href=\\"http://www.adobe.com/go/getflashplayer\\"><img src=\\"http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif\\" alt=\\"Get Adobe Flash player\\" /></a></p>\n </div>\n ";\n }\n unset($func_26_9eb7ee);\n }\n unset($ifcondition_26_9eb7ee);\n //IF TAG END 26_9eb7ee\n //IF TAG START 27_427d6a\n $ifcondition_27_427d6a = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." == ''jpg'' || ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." == ''gif'' || ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." == ''png''", $replace);\n if ($ifcondition_27_427d6a) {\n $func_27_427d6a = create_function("","return (".$ifcondition_27_427d6a.");");\n if ($func_27_427d6a()) {\n //IF TAG START 28_9a69cc\n $ifcondition_28_9a69cc = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''thumbnail'','''')), $replace);\n if ($ifcondition_28_9a69cc) {\n $func_28_9a69cc = create_function("","return (".$ifcondition_28_9a69cc.");");\n if ($func_28_9a69cc()) {\n $content .="\n <a href=\\"".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."\\" onclick=\\"javascript:CMS_openPopUpImage(''imagezoom.php?location=public&module=pmedia&file=".$object[2]->objectValues(9)->getValue(''filename'','''')."&label=".$object[2]->getValue(''label'',''js'')."'');return false;\\" target=\\"_blank\\" title=\\"Voir l''image ''".$object[2]->getValue(''label'','''')."'' (".$object[2]->objectValues(9)->getValue(''fileExtension'','''')." - ".$object[2]->objectValues(9)->getValue(''fileSize'','''')."Mo)\\"><img src=\\"".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''thumbnail'','''')."\\" alt=\\"".$object[2]->getValue(''label'','''')."\\" title=\\"".$object[2]->getValue(''label'','''')."\\" /></a>\n ";\n }\n unset($func_28_9a69cc);\n }\n unset($ifcondition_28_9a69cc);\n //IF TAG END 28_9a69cc\n //IF TAG START 29_a16612\n $ifcondition_29_a16612 = CMS_polymod_definition_parsing::replaceVars("!".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''thumbnail'','''')), $replace);\n if ($ifcondition_29_a16612) {\n $func_29_a16612 = create_function("","return (".$ifcondition_29_a16612.");");\n if ($func_29_a16612()) {\n $content .="\n <img src=\\"".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."\\" alt=\\"".$object[2]->getValue(''label'','''')."\\" title=\\"".$object[2]->getValue(''label'','''')."\\" style=\\"max-width:200px;\\" />\n ";\n }\n unset($func_29_a16612);\n }\n unset($ifcondition_29_a16612);\n //IF TAG END 29_a16612\n }\n unset($func_27_427d6a);\n }\n unset($ifcondition_27_427d6a);\n //IF TAG END 27_427d6a\n }\n //PLUGIN-VALID END 20_c9ca95\n //PLUGIN-VIEW TAG START 30_b94642\n if ($object[$parameters[''objectID'']]->isInUserSpace() && isset($parameters[''plugin-view''])) {\n //IF TAG START 31_8c02eb\n $ifcondition_31_8c02eb = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." != ''jpg'' && ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." != ''gif'' && ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." != ''png''", $replace);\n if ($ifcondition_31_8c02eb) {\n $func_31_8c02eb = create_function("","return (".$ifcondition_31_8c02eb.");");\n if ($func_31_8c02eb()) {\n $content .="\n <a href=\\"".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."\\" target=\\"_blank\\" title=\\"Télécharger le document ''".$object[2]->objectValues(9)->getValue(''fileLabel'','''')."'' (".$object[2]->objectValues(9)->getValue(''fileExtension'','''')." - ".$object[2]->objectValues(9)->getValue(''fileSize'','''')."Mo)\\">";\n //IF TAG START 32_625efd\n $ifcondition_32_625efd = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileIcon'','''')), $replace);\n if ($ifcondition_32_625efd) {\n $func_32_625efd = create_function("","return (".$ifcondition_32_625efd.");");\n if ($func_32_625efd()) {\n $content .="<img src=\\"".$object[2]->objectValues(9)->getValue(''fileIcon'','''')."\\" alt=\\"Fichier ".$object[2]->objectValues(9)->getValue(''fileExtension'','''')."\\" title=\\"Fichier ".$object[2]->objectValues(9)->getValue(''fileExtension'','''')."\\" />";\n }\n unset($func_32_625efd);\n }\n unset($ifcondition_32_625efd);\n //IF TAG END 32_625efd\n $content .=" ".$object[2]->getValue(''label'','''')."</a>\n ";\n }\n unset($func_31_8c02eb);\n }\n unset($ifcondition_31_8c02eb);\n //IF TAG END 31_8c02eb\n //IF TAG START 33_e1042e\n $ifcondition_33_e1042e = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." == ''jpg'' || ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." == ''gif'' || ".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileExtension'',''''))." == ''png''", $replace);\n if ($ifcondition_33_e1042e) {\n $func_33_e1042e = create_function("","return (".$ifcondition_33_e1042e.");");\n if ($func_33_e1042e()) {\n //IF TAG START 34_d85f75\n $ifcondition_34_d85f75 = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''thumbnail'','''')), $replace);\n if ($ifcondition_34_d85f75) {\n $func_34_d85f75 = create_function("","return (".$ifcondition_34_d85f75.");");\n if ($func_34_d85f75()) {\n $content .="\n <a href=\\"".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."\\" onclick=\\"javascript:CMS_openPopUpImage(''imagezoom.php?location=public&module=pmedia&file=".$object[2]->objectValues(9)->getValue(''filename'','''')."&label=".$object[2]->getValue(''label'',''js'')."'');return false;\\" target=\\"_blank\\" title=\\"Voir l''image ''".$object[2]->getValue(''label'','''')."'' (".$object[2]->objectValues(9)->getValue(''fileExtension'','''')." - ".$object[2]->objectValues(9)->getValue(''fileSize'','''')."Mo)\\"><img src=\\"".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''thumbnail'','''')."\\" alt=\\"".$object[2]->getValue(''label'','''')."\\" title=\\"".$object[2]->getValue(''label'','''')."\\" /></a>\n ";\n }\n unset($func_34_d85f75);\n }\n unset($ifcondition_34_d85f75);\n //IF TAG END 34_d85f75\n //IF TAG START 35_2523b4\n $ifcondition_35_2523b4 = CMS_polymod_definition_parsing::replaceVars("!".CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''thumbnail'','''')), $replace);\n if ($ifcondition_35_2523b4) {\n $func_35_2523b4 = create_function("","return (".$ifcondition_35_2523b4.");");\n if ($func_35_2523b4()) {\n $content .="\n <img src=\\"".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."\\" alt=\\"".$object[2]->getValue(''label'','''')."\\" title=\\"".$object[2]->getValue(''label'','''')."\\" style=\\"max-width:200px;\\" />\n ";\n }\n unset($func_35_2523b4);\n }\n unset($ifcondition_35_2523b4);\n //IF TAG END 35_2523b4\n }\n unset($func_33_e1042e);\n }\n unset($ifcondition_33_e1042e);\n //IF TAG END 33_e1042e\n }\n //PLUGIN-VIEW END 30_b94642\n $content .="\n ";\n }\n //PLUGIN TAG END 19_42c3db\n $content = CMS_polymod_definition_parsing::replaceVars($content, $replace);\n $content .= ''<!--{elements:''.base64_encode(serialize(array (\n ''module'' =>\n array (\n 0 => ''pmedia'',\n ),\n ))).''}-->'';\n echo $content;\n unset($content);}\n ?>');
1559
INSERT INTO `mod_object_plugin_definition` (`id_mowd`, `uuid_mowd`, `object_id_mowd`, `label_id_mowd`, `description_id_mowd`, `query_mowd`, `definition_mowd`, `compiled_definition_mowd`) VALUES(2, '3e69e3be-0ba9-102e-80e2-001a6470da26', 2, 89, 90, 'a:1:{i:8;s:1:"0";}', '<atm-plugin language="fr">\r\n <atm-plugin-valid>\r\n <a href="{[''object2''][''fields''][9][''filePath'']}/{[''object2''][''fields''][9][''filename'']}" target="_blank" title="Télécharger le document ''{[''object2''][''fields''][9][''fileLabel'']}'' ({[''object2''][''fields''][9][''fileExtension'']} - {[''object2''][''fields''][9][''fileSize'']}Mo)"><atm-if what="{[''object2''][''fields''][9][''fileIcon'']}"><img src="{[''object2''][''fields''][9][''fileIcon'']}" alt="Fichier {[''object2''][''fields''][9][''fileExtension'']}" title="Fichier {[''object2''][''fields''][9][''fileExtension'']}" /> </atm-if>{plugin:selection}</a>\r\n </atm-plugin-valid>\r\n <atm-plugin-invalid>\r\n {plugin:selection}\r\n </atm-plugin-invalid>\r\n</atm-plugin>', '<?php\n/*Generated on Fri, 10 Sep 2010 16:47:45 +0200 by Automne (TM) 4.1.0a1 */\nif(!APPLICATION_ENFORCES_ACCESS_CONTROL || (isset($cms_user) && is_a($cms_user, ''CMS_profile_user'') && $cms_user->hasModuleClearance(''pmedia'', CLEARANCE_MODULE_VIEW))){\n $content = "";\n $replace = "";\n $atmIfResults = array();\n if (!isset($objectDefinitions) || !is_array($objectDefinitions)) $objectDefinitions = array();\n $parameters[''objectID''] = 2;\n if (!isset($cms_language) || (isset($cms_language) && $cms_language->getCode() != ''fr'')) $cms_language = new CMS_language(''fr'');\n $parameters[''public''] = (isset($parameters[''public''])) ? $parameters[''public''] : true;\n if (isset($parameters[''item''])) {$parameters[''objectID''] = $parameters[''item'']->getObjectID();} elseif (isset($parameters[''itemID'']) && sensitiveIO::isPositiveInteger($parameters[''itemID'']) && !isset($parameters[''objectID''])) $parameters[''objectID''] = CMS_poly_object_catalog::getObjectDefinitionByID($parameters[''itemID'']);\n if (!isset($object) || !is_array($object)) $object = array();\n if (!isset($object[2])) $object[2] = new CMS_poly_object(2, 0, array(), $parameters[''public'']);\n $parameters[''module''] = ''pmedia'';\n //PLUGIN TAG START 19_e45d46\n if (!sensitiveIO::isPositiveInteger($parameters[''itemID'']) || !sensitiveIO::isPositiveInteger($parameters[''objectID''])) {\n CMS_grandFather::raiseError(''Error into atm-plugin tag : can\\''t found object infos to use into : $parameters[\\''itemID\\''] and $parameters[\\''objectID\\'']'');\n } else {\n //search needed object (need to search it for publications and rights purpose)\n if (!isset($objectDefinitions[$parameters[''objectID'']])) {\n $objectDefinitions[$parameters[''objectID'']] = new CMS_poly_object_definition($parameters[''objectID'']);\n }\n $search_19_e45d46 = new CMS_object_search($objectDefinitions[$parameters[''objectID'']], $parameters[''public'']);\n $search_19_e45d46->addWhereCondition(''item'', $parameters[''itemID'']);\n $results_19_e45d46 = $search_19_e45d46->search();\n if (isset($results_19_e45d46[$parameters[''itemID'']]) && is_object($results_19_e45d46[$parameters[''itemID'']])) {\n $object[$parameters[''objectID'']] = $results_19_e45d46[$parameters[''itemID'']];\n } else {\n $object[$parameters[''objectID'']] = new CMS_poly_object($parameters[''objectID''], 0, array(), $parameters[''public'']);\n }\n unset($search_19_e45d46);\n $parameters[''has-plugin-view''] = false;\n //PLUGIN-VALID TAG START 20_530222\n if ($object[$parameters[''objectID'']]->isInUserSpace() && !(@$parameters[''plugin-view''] && @$parameters[''has-plugin-view'']) ) {\n $content .="\n <a href=\\"".$object[2]->objectValues(9)->getValue(''filePath'','''')."/".$object[2]->objectValues(9)->getValue(''filename'','''')."\\" target=\\"_blank\\" title=\\"Télécharger le document ''".$object[2]->objectValues(9)->getValue(''fileLabel'','''')."'' (".$object[2]->objectValues(9)->getValue(''fileExtension'','''')." - ".$object[2]->objectValues(9)->getValue(''fileSize'','''')."Mo)\\">";\n //IF TAG START 21_52063c\n $ifcondition_21_52063c = CMS_polymod_definition_parsing::replaceVars(CMS_polymod_definition_parsing::prepareVar($object[2]->objectValues(9)->getValue(''fileIcon'','''')), $replace);\n if ($ifcondition_21_52063c) {\n $func_21_52063c = create_function("","return (".$ifcondition_21_52063c.");");\n if ($func_21_52063c()) {\n $content .="<img src=\\"".$object[2]->objectValues(9)->getValue(''fileIcon'','''')."\\" alt=\\"Fichier ".$object[2]->objectValues(9)->getValue(''fileExtension'','''')."\\" title=\\"Fichier ".$object[2]->objectValues(9)->getValue(''fileExtension'','''')."\\" /> ";\n }\n unset($func_21_52063c);\n }\n unset($ifcondition_21_52063c);\n //IF TAG END 21_52063c\n $content .=$parameters[''selection'']."</a>\n ";\n }\n //PLUGIN-VALID END 20_530222\n //PLUGIN-INVALID TAG START 22_3a2761\n if (!$object[$parameters[''objectID'']]->isInUserSpace()) {\n $content .="\n ".$parameters[''selection'']."\n ";\n }\n //PLUGIN-INVALID END 22_3a2761\n $content .="\n ";\n }\n //PLUGIN TAG END 19_e45d46\n $content = CMS_polymod_definition_parsing::replaceVars($content, $replace);\n $content .= ''<!--{elements:''.base64_encode(serialize(array (\n ''module'' =>\n array (\n 0 => ''pmedia'',\n ),\n ))).''}-->'';\n echo $content;\n unset($content);}\n ?>');
1561
-- --------------------------------------------------------
1564
-- Structure de la table `mod_object_polyobjects`
1567
DROP TABLE IF EXISTS `mod_object_polyobjects`;
1568
CREATE TABLE `mod_object_polyobjects` (
1569
`id_moo` int(11) unsigned NOT NULL auto_increment,
1570
`object_type_id_moo` int(11) unsigned NOT NULL default '0',
1571
`deleted_moo` int(1) NOT NULL default '0',
1572
PRIMARY KEY (`id_moo`),
1573
KEY `object_id_moo` (`object_type_id_moo`),
1574
KEY `deleted_moo` (`deleted_moo`)
1575
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1578
-- Contenu de la table `mod_object_polyobjects`
1582
-- --------------------------------------------------------
1585
-- Structure de la table `mod_object_rss_definition`
1588
DROP TABLE IF EXISTS `mod_object_rss_definition`;
1589
CREATE TABLE `mod_object_rss_definition` (
1590
`id_mord` int(11) unsigned NOT NULL auto_increment,
1591
`uuid_mord` varchar(36) NOT NULL,
1592
`object_id_mord` int(11) unsigned NOT NULL default '0',
1593
`label_id_mord` int(11) unsigned NOT NULL default '0',
1594
`description_id_mord` int(11) unsigned NOT NULL default '0',
1595
`link_mord` varchar(255) NOT NULL default '',
1596
`author_mord` varchar(255) NOT NULL default '',
1597
`copyright_mord` varchar(255) NOT NULL default '',
1598
`categories_mord` mediumtext NOT NULL,
1599
`ttl_mord` int(11) NOT NULL default '0',
1600
`email_mord` varchar(255) NOT NULL default '',
1601
`definition_mord` mediumtext NOT NULL,
1602
`compiled_definition_mord` mediumtext NOT NULL,
1603
`last_compilation_mord` datetime NOT NULL default '0000-00-00 00:00:00',
1604
PRIMARY KEY (`id_mord`),
1605
KEY `object_id_mord` (`object_id_mord`)
1606
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1609
-- Contenu de la table `mod_object_rss_definition`
1613
-- --------------------------------------------------------
1616
-- Structure de la table `mod_standard_clientSpaces_archived`
1619
DROP TABLE IF EXISTS `mod_standard_clientSpaces_archived`;
1620
CREATE TABLE `mod_standard_clientSpaces_archived` (
1621
`template_cs` int(11) unsigned NOT NULL default '0',
1622
`tagID_cs` varchar(100) NOT NULL default '',
1623
`rowsDefinition_cs` varchar(255) NOT NULL default '',
1624
`type_cs` int(11) NOT NULL default '0',
1625
`order_cs` int(11) NOT NULL default '0',
1626
PRIMARY KEY (`template_cs`,`tagID_cs`,`order_cs`),
1627
KEY `template_cs` (`template_cs`),
1628
KEY `type_cs` (`type_cs`)
1629
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1632
-- Contenu de la table `mod_standard_clientSpaces_archived`
1636
-- --------------------------------------------------------
1639
-- Structure de la table `mod_standard_clientSpaces_deleted`
1642
DROP TABLE IF EXISTS `mod_standard_clientSpaces_deleted`;
1643
CREATE TABLE `mod_standard_clientSpaces_deleted` (
1644
`template_cs` int(11) unsigned NOT NULL default '0',
1645
`tagID_cs` varchar(100) NOT NULL default '',
1646
`rowsDefinition_cs` varchar(255) NOT NULL default '',
1647
`type_cs` int(11) NOT NULL default '0',
1648
`order_cs` int(11) NOT NULL default '0',
1649
PRIMARY KEY (`template_cs`,`tagID_cs`,`order_cs`),
1650
KEY `template_cs` (`template_cs`),
1651
KEY `type_cs` (`type_cs`)
1652
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1655
-- Contenu de la table `mod_standard_clientSpaces_deleted`
1659
-- --------------------------------------------------------
1662
-- Structure de la table `mod_standard_clientSpaces_edited`
1665
DROP TABLE IF EXISTS `mod_standard_clientSpaces_edited`;
1666
CREATE TABLE `mod_standard_clientSpaces_edited` (
1667
`template_cs` int(11) unsigned NOT NULL default '0',
1668
`tagID_cs` varchar(100) NOT NULL default '',
1669
`rowsDefinition_cs` varchar(255) NOT NULL default '',
1670
`type_cs` int(11) NOT NULL default '0',
1671
`order_cs` int(11) NOT NULL default '0',
1672
PRIMARY KEY (`template_cs`,`tagID_cs`,`order_cs`),
1673
KEY `template_cs` (`template_cs`),
1674
KEY `type_cs` (`type_cs`)
1675
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1678
-- Contenu de la table `mod_standard_clientSpaces_edited`
1682
-- --------------------------------------------------------
1685
-- Structure de la table `mod_standard_clientSpaces_edition`
1688
DROP TABLE IF EXISTS `mod_standard_clientSpaces_edition`;
1689
CREATE TABLE `mod_standard_clientSpaces_edition` (
1690
`template_cs` int(11) unsigned NOT NULL default '0',
1691
`tagID_cs` varchar(100) NOT NULL default '',
1692
`rowsDefinition_cs` varchar(255) NOT NULL default '',
1693
`type_cs` int(11) NOT NULL default '0',
1694
`order_cs` int(11) NOT NULL default '0',
1695
PRIMARY KEY (`template_cs`,`tagID_cs`,`order_cs`),
1696
KEY `template_cs` (`template_cs`),
1697
KEY `type_cs` (`type_cs`)
1698
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1701
-- Contenu de la table `mod_standard_clientSpaces_edition`
1705
-- --------------------------------------------------------
1708
-- Structure de la table `mod_standard_clientSpaces_public`
1711
DROP TABLE IF EXISTS `mod_standard_clientSpaces_public`;
1712
CREATE TABLE `mod_standard_clientSpaces_public` (
1713
`template_cs` int(11) unsigned NOT NULL default '0',
1714
`tagID_cs` varchar(100) NOT NULL default '',
1715
`rowsDefinition_cs` varchar(255) NOT NULL default '',
1716
`type_cs` int(11) NOT NULL default '0',
1717
`order_cs` int(11) NOT NULL default '0',
1718
PRIMARY KEY (`template_cs`,`tagID_cs`,`order_cs`),
1719
KEY `template_cs` (`template_cs`),
1720
KEY `type_cs` (`type_cs`)
1721
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1724
-- Contenu de la table `mod_standard_clientSpaces_public`
1728
-- --------------------------------------------------------
1731
-- Structure de la table `mod_standard_rows`
1734
DROP TABLE IF EXISTS `mod_standard_rows`;
1735
CREATE TABLE `mod_standard_rows` (
1736
`id_row` int(11) unsigned NOT NULL auto_increment,
1737
`uuid_row` varchar(36) NOT NULL,
1738
`label_row` varchar(100) NOT NULL default '',
1739
`definitionFile_row` varchar(100) NOT NULL default '',
1740
`modulesStack_row` varchar(255) NOT NULL default '',
1741
`groupsStack_row` varchar(255) NOT NULL default '',
1742
`image_row` varchar(255) NOT NULL default '',
1743
`description_row` text NOT NULL,
1744
`tplfilter_row` varchar(255) NOT NULL default '',
1745
`useable_row` int(1) NOT NULL default '0',
1746
PRIMARY KEY (`id_row`),
1747
FULLTEXT KEY `label_row` (`label_row`,`description_row`)
1748
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1751
-- Contenu de la table `mod_standard_rows`
1754
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(25, '3e79ad9e-0ba9-102e-80e2-001a6470da26', '000 Exemple', 'r25_Complet.xml', 'standard', '', 'nopicto.gif', 'Cette rangée regroupe des exemples des différents types de blocs à votre disposition : chaîne de caractères, texte, image, fichier, animation Flash', '', 0);
1755
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(46, '3e79b0be-0ba9-102e-80e2-001a6470da26', '220 Texte et Image Gauche', 'r46_220_Texte_et_Image_Gauche.xml', 'standard', '', 'text-img-left.gif', 'Cette rangée permet d''insérer du texte qu''on pourra mettre en forme via l''éditeur Wysiwyg et elle permet d''insérer en plus une image alignée sur le côté gauche', '', 0);
1756
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(45, '3e79b3c0-0ba9-102e-80e2-001a6470da26', '210 Texte et Image Droite', 'r45_210_Texte__image_droite.xml', 'standard', '', 'text-img-right.gif', 'Cette rangée permet d''insérer du texte qu''on pourra mettre en forme via l''éditeur Wysiwyg et elle permet d''insérer en plus une image alignée sur le côté droit', '', 0);
1757
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(44, '3e79b6b8-0ba9-102e-80e2-001a6470da26', '200 Texte', 'r44_200_Texte.xml', 'standard', '', 'text.gif', 'Cette rangée peut contenir du texte mis en forme (liens, listes à puces, tableaux, etc.) à l''aide de l''éditeur Wysiwyg. Elle permet aussi d''insérer des liens vers des contenus stockés dans les modules', '', 1);
1758
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(43, '3e79ba14-0ba9-102e-80e2-001a6470da26', '110 Sous Titre (niveau 2)', 'r43_100_Sous_Titre.xml', 'standard', '', 'title.gif', 'Cette rangée permet d''insérer un titre de niveau 2 correspondant à l''élément H2 en HTML', '', 1);
1759
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(42, '3e79bc26-0ba9-102e-80e2-001a6470da26', '100 Titre (niveau 1)', 'r42_000_Titre.xml', 'standard', '', 'title.gif', 'Cette rangée vous permet d''insérer un titre de niveau 1 correspondant à l''élément H1 en HTML', '', 1);
1760
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(47, '3e79be2e-0ba9-102e-80e2-001a6470da26', '400 Télécharger un fichier', 'r47_400_Telecharger_un_fichier.xml', 'standard', '', 'file.gif', 'Cette rangée permet d''insérer un fichier à télécharger', '', 0);
1761
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(48, '3e79bfdc-0ba9-102e-80e2-001a6470da26', '300 Image Centrée', 'r48_300_Image_Centree.xml', 'standard', '', 'img.gif', 'Cette rangée insère une image centrée dont la largeur est limitée à 500px', '', 0);
1762
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(49, '3e79c1c6-0ba9-102e-80e2-001a6470da26', '410 Animation Flash', 'r49_500_Animation_Flash.xml', 'standard', '', 'flash.gif', 'Cette rangée permet d''insérer une animation Flash (.swf)', '', 0);
1763
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(54, '3e79c36a-0ba9-102e-80e2-001a6470da26', '700 Plan du site', 'r54_700_Plan_du_site.xml', 'standard', 'admin', 'tree.gif', 'Cette rangée génère un plan du site à partir de la racine du site sur 3 niveaux de profondeur', '', 0);
1764
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(55, '3e79c572-0ba9-102e-80e2-001a6470da26', '800 [Formulaire]', 'r55_800_Formulaire.xml', 'cms_forms', 'admin', 'form.gif', 'Cette rangée permet d''insérer un formulaire créé à partir du module formulaire', '', 0);
1765
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(61, '3e79c75c-0ba9-102e-80e2-001a6470da26', '900 Carte Google', 'r61_900_Google_Maps.xml', 'standard', 'admin', 'nopicto.gif', 'Cette rangée vous permet d''insérer une carte Google Maps à partir d''une adresse postale.\nVous devez posséder une clef valide pour utiliser ce service. Voir le code source de la rangée pour plus d''informations', '', 0);
1766
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(67, '3e79cb1c-0ba9-102e-80e2-001a6470da26', '120 Mini Titre (niveau 3)', 'r67_120_Sous_Sous_Titre.xml', 'standard', '', 'title.gif', 'Cette rangée vous permet d''insérer un titre de niveau 3 correspondant à l''élément H3 en HTML', '', 1);
1767
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(69, '3e79cd42-0ba9-102e-80e2-001a6470da26', '230 Texte et Média à Droite', 'r69_Texte_-_Media_a_droite.xml', 'pmedia;standard', '', 'text-mod-right.gif', 'Cette rangée permet d''insérer du texte qu''on pourra mettre en forme via l''éditeur Wysiwyg avec, aligné à droite, un élément issu du module médiathèque', '', 1);
1768
INSERT INTO `mod_standard_rows` (`id_row`, `uuid_row`, `label_row`, `definitionFile_row`, `modulesStack_row`, `groupsStack_row`, `image_row`, `description_row`, `tplfilter_row`, `useable_row`) VALUES(70, '3e79d04e-0ba9-102e-80e2-001a6470da26', '240 Texte et Média à Gauche', 'r70_240_Texte_et_Media_a_Gauche.xml', 'pmedia;standard', '', 'text-mod-left.gif', 'Cette rangée permet d''insérer du texte qu''on pourra mettre en forme via l''éditeur Wysiwyg avec, aligné à gauche, un élément issu du module médiathèque', '', 1);
1770
-- --------------------------------------------------------
1773
-- Structure de la table `mod_subobject_date_deleted`
1776
DROP TABLE IF EXISTS `mod_subobject_date_deleted`;
1777
CREATE TABLE `mod_subobject_date_deleted` (
1778
`id` int(11) unsigned NOT NULL auto_increment,
1779
`objectID` int(11) unsigned NOT NULL default '0',
1780
`objectFieldID` int(11) unsigned NOT NULL default '0',
1781
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
1782
`value` datetime NOT NULL default '0000-00-00 00:00:00',
1784
KEY `objectID` (`objectID`),
1785
KEY `objectFieldID` (`objectFieldID`),
1786
KEY `objectSubFieldID` (`objectSubFieldID`)
1787
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1790
-- Contenu de la table `mod_subobject_date_deleted`
1794
-- --------------------------------------------------------
1797
-- Structure de la table `mod_subobject_date_edited`
1800
DROP TABLE IF EXISTS `mod_subobject_date_edited`;
1801
CREATE TABLE `mod_subobject_date_edited` (
1802
`id` int(11) unsigned NOT NULL auto_increment,
1803
`objectID` int(11) unsigned NOT NULL default '0',
1804
`objectFieldID` int(11) unsigned NOT NULL default '0',
1805
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
1806
`value` datetime NOT NULL default '0000-00-00 00:00:00',
1808
KEY `objectID` (`objectID`),
1809
KEY `objectFieldID` (`objectFieldID`),
1810
KEY `objectSubFieldID` (`objectSubFieldID`)
1811
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1814
-- Contenu de la table `mod_subobject_date_edited`
1818
-- --------------------------------------------------------
1821
-- Structure de la table `mod_subobject_date_public`
1824
DROP TABLE IF EXISTS `mod_subobject_date_public`;
1825
CREATE TABLE `mod_subobject_date_public` (
1826
`id` int(11) unsigned NOT NULL auto_increment,
1827
`objectID` int(11) unsigned NOT NULL default '0',
1828
`objectFieldID` int(11) unsigned NOT NULL default '0',
1829
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
1830
`value` datetime NOT NULL default '0000-00-00 00:00:00',
1832
KEY `objectID` (`objectID`),
1833
KEY `objectFieldID` (`objectFieldID`),
1834
KEY `objectSubFieldID` (`objectSubFieldID`)
1835
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1838
-- Contenu de la table `mod_subobject_date_public`
1842
-- --------------------------------------------------------
1845
-- Structure de la table `mod_subobject_integer_deleted`
1848
DROP TABLE IF EXISTS `mod_subobject_integer_deleted`;
1849
CREATE TABLE `mod_subobject_integer_deleted` (
1850
`id` int(11) unsigned NOT NULL auto_increment,
1851
`objectID` int(11) unsigned NOT NULL default '0',
1852
`objectFieldID` int(11) unsigned NOT NULL default '0',
1853
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
1854
`value` int(11) NOT NULL default '0',
1856
KEY `objectID` (`objectID`),
1857
KEY `objectFieldID` (`objectFieldID`),
1858
KEY `objectSubFieldID` (`objectSubFieldID`)
1859
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1862
-- Contenu de la table `mod_subobject_integer_deleted`
1866
-- --------------------------------------------------------
1869
-- Structure de la table `mod_subobject_integer_edited`
1872
DROP TABLE IF EXISTS `mod_subobject_integer_edited`;
1873
CREATE TABLE `mod_subobject_integer_edited` (
1874
`id` int(11) unsigned NOT NULL auto_increment,
1875
`objectID` int(11) unsigned NOT NULL default '0',
1876
`objectFieldID` int(11) unsigned NOT NULL default '0',
1877
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
1878
`value` int(11) NOT NULL default '0',
1880
KEY `objectID` (`objectID`),
1881
KEY `objectFieldID` (`objectFieldID`),
1882
KEY `objectSubFieldID` (`objectSubFieldID`)
1883
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1886
-- Contenu de la table `mod_subobject_integer_edited`
1890
-- --------------------------------------------------------
1893
-- Structure de la table `mod_subobject_integer_public`
1896
DROP TABLE IF EXISTS `mod_subobject_integer_public`;
1897
CREATE TABLE `mod_subobject_integer_public` (
1898
`id` int(11) unsigned NOT NULL auto_increment,
1899
`objectID` int(11) unsigned NOT NULL default '0',
1900
`objectFieldID` int(11) unsigned NOT NULL default '0',
1901
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
1902
`value` int(11) NOT NULL default '0',
1904
KEY `objectID` (`objectID`),
1905
KEY `objectFieldID` (`objectFieldID`),
1906
KEY `objectSubFieldID` (`objectSubFieldID`)
1907
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1910
-- Contenu de la table `mod_subobject_integer_public`
1914
-- --------------------------------------------------------
1917
-- Structure de la table `mod_subobject_string_deleted`
1920
DROP TABLE IF EXISTS `mod_subobject_string_deleted`;
1921
CREATE TABLE `mod_subobject_string_deleted` (
1922
`id` int(11) unsigned NOT NULL auto_increment,
1923
`objectID` int(11) unsigned NOT NULL default '0',
1924
`objectFieldID` int(11) unsigned NOT NULL default '0',
1925
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
1926
`value` varchar(255) NOT NULL default '',
1928
KEY `objectID` (`objectID`),
1929
KEY `objectFieldID` (`objectFieldID`),
1930
KEY `objectSubFieldID` (`objectSubFieldID`)
1931
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1934
-- Contenu de la table `mod_subobject_string_deleted`
1938
-- --------------------------------------------------------
1941
-- Structure de la table `mod_subobject_string_edited`
1944
DROP TABLE IF EXISTS `mod_subobject_string_edited`;
1945
CREATE TABLE `mod_subobject_string_edited` (
1946
`id` int(11) unsigned NOT NULL auto_increment,
1947
`objectID` int(11) unsigned NOT NULL default '0',
1948
`objectFieldID` int(11) unsigned NOT NULL default '0',
1949
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
1950
`value` varchar(255) NOT NULL default '',
1952
KEY `objectID` (`objectID`),
1953
KEY `objectFieldID` (`objectFieldID`),
1954
KEY `objectSubFieldID` (`objectSubFieldID`),
1955
FULLTEXT KEY `value` (`value`)
1956
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1959
-- Contenu de la table `mod_subobject_string_edited`
1963
-- --------------------------------------------------------
1966
-- Structure de la table `mod_subobject_string_public`
1969
DROP TABLE IF EXISTS `mod_subobject_string_public`;
1970
CREATE TABLE `mod_subobject_string_public` (
1971
`id` int(11) unsigned NOT NULL auto_increment,
1972
`objectID` int(11) unsigned NOT NULL default '0',
1973
`objectFieldID` int(11) unsigned NOT NULL default '0',
1974
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
1975
`value` varchar(255) NOT NULL default '',
1977
KEY `objectID` (`objectID`),
1978
KEY `objectFieldID` (`objectFieldID`),
1979
KEY `objectSubFieldID` (`objectSubFieldID`),
1980
FULLTEXT KEY `value` (`value`)
1981
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1984
-- Contenu de la table `mod_subobject_string_public`
1988
-- --------------------------------------------------------
1991
-- Structure de la table `mod_subobject_text_deleted`
1994
DROP TABLE IF EXISTS `mod_subobject_text_deleted`;
1995
CREATE TABLE `mod_subobject_text_deleted` (
1996
`id` int(11) unsigned NOT NULL auto_increment,
1997
`objectID` int(11) unsigned NOT NULL default '0',
1998
`objectFieldID` int(11) unsigned NOT NULL default '0',
1999
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
2000
`value` text NOT NULL,
2002
KEY `objectID` (`objectID`),
2003
KEY `objectFieldID` (`objectFieldID`),
2004
KEY `objectSubFieldID` (`objectSubFieldID`)
2005
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2008
-- Contenu de la table `mod_subobject_text_deleted`
2012
-- --------------------------------------------------------
2015
-- Structure de la table `mod_subobject_text_edited`
2018
DROP TABLE IF EXISTS `mod_subobject_text_edited`;
2019
CREATE TABLE `mod_subobject_text_edited` (
2020
`id` int(11) unsigned NOT NULL auto_increment,
2021
`objectID` int(11) unsigned NOT NULL default '0',
2022
`objectFieldID` int(11) unsigned NOT NULL default '0',
2023
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
2024
`value` text NOT NULL,
2026
KEY `objectID` (`objectID`),
2027
KEY `objectFieldID` (`objectFieldID`),
2028
KEY `objectSubFieldID` (`objectSubFieldID`),
2029
FULLTEXT KEY `value` (`value`)
2030
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2033
-- Contenu de la table `mod_subobject_text_edited`
2037
-- --------------------------------------------------------
2040
-- Structure de la table `mod_subobject_text_public`
2043
DROP TABLE IF EXISTS `mod_subobject_text_public`;
2044
CREATE TABLE `mod_subobject_text_public` (
2045
`id` int(11) unsigned NOT NULL auto_increment,
2046
`objectID` int(11) unsigned NOT NULL default '0',
2047
`objectFieldID` int(11) unsigned NOT NULL default '0',
2048
`objectSubFieldID` int(11) unsigned NOT NULL default '0',
2049
`value` text NOT NULL,
2051
KEY `objectID` (`objectID`),
2052
KEY `objectFieldID` (`objectFieldID`),
2053
KEY `objectSubFieldID` (`objectSubFieldID`),
2054
FULLTEXT KEY `value` (`value`)
2055
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2058
-- Contenu de la table `mod_subobject_text_public`
2062
-- --------------------------------------------------------
2065
-- Structure de la table `pages`
2068
DROP TABLE IF EXISTS `pages`;
2069
CREATE TABLE `pages` (
2070
`id_pag` int(11) unsigned NOT NULL auto_increment,
2071
`resource_pag` int(11) unsigned NOT NULL default '0',
2072
`remindedEditorsStack_pag` varchar(255) NOT NULL default '',
2073
`lastReminder_pag` date NOT NULL default '0000-00-00',
2074
`template_pag` int(11) unsigned NOT NULL default '0',
2075
`lastFileCreation_pag` datetime NOT NULL default '0000-00-00 00:00:00',
2076
`url_pag` varchar(255) NOT NULL default '',
2077
PRIMARY KEY (`id_pag`),
2078
KEY `id_pag` (`id_pag`),
2079
KEY `template_pag` (`template_pag`)
2080
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2083
-- Contenu de la table `pages`
2086
INSERT INTO `pages` (`id_pag`, `resource_pag`, `remindedEditorsStack_pag`, `lastReminder_pag`, `template_pag`, `lastFileCreation_pag`, `url_pag`) VALUES(1, 1, '1', '2010-06-02', 1, '2010-06-02 16:51:00', '1-accueil.php');
2088
-- --------------------------------------------------------
2091
-- Structure de la table `pagesBaseData_archived`
2094
DROP TABLE IF EXISTS `pagesBaseData_archived`;
2095
CREATE TABLE `pagesBaseData_archived` (
2096
`id_pbd` int(11) unsigned NOT NULL auto_increment,
2097
`page_pbd` int(11) unsigned NOT NULL default '0',
2098
`title_pbd` varchar(150) NOT NULL default '',
2099
`linkTitle_pbd` varchar(150) NOT NULL default '',
2100
`keywords_pbd` mediumtext NOT NULL,
2101
`description_pbd` mediumtext NOT NULL,
2102
`reminderPeriodicity_pbd` smallint(6) unsigned NOT NULL default '0',
2103
`reminderOn_pbd` date NOT NULL default '0000-00-00',
2104
`reminderOnMessage_pbd` mediumtext NOT NULL,
2105
`category_pbd` varchar(255) NOT NULL default '',
2106
`author_pbd` varchar(255) NOT NULL default '',
2107
`replyto_pbd` varchar(255) NOT NULL default '',
2108
`copyright_pbd` varchar(255) NOT NULL default '',
2109
`language_pbd` varchar(255) NOT NULL default '',
2110
`robots_pbd` varchar(255) NOT NULL default '',
2111
`pragma_pbd` varchar(255) NOT NULL default '',
2112
`refresh_pbd` varchar(255) NOT NULL default '',
2113
`redirect_pbd` varchar(255) NOT NULL default '',
2114
`refreshUrl_pbd` int(1) NOT NULL default '0',
2115
`url_pbd` varchar(255) NOT NULL default '',
2116
`metas_pbd` text NOT NULL,
2117
`codename_pbd` varchar(20) NOT NULL,
2118
PRIMARY KEY (`id_pbd`),
2119
KEY `page_pbd` (`page_pbd`)
2120
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2123
-- Contenu de la table `pagesBaseData_archived`
2127
-- --------------------------------------------------------
2130
-- Structure de la table `pagesBaseData_deleted`
2133
DROP TABLE IF EXISTS `pagesBaseData_deleted`;
2134
CREATE TABLE `pagesBaseData_deleted` (
2135
`id_pbd` int(11) unsigned NOT NULL auto_increment,
2136
`page_pbd` int(11) unsigned NOT NULL default '0',
2137
`title_pbd` varchar(150) NOT NULL default '',
2138
`linkTitle_pbd` varchar(150) NOT NULL default '',
2139
`keywords_pbd` mediumtext NOT NULL,
2140
`description_pbd` mediumtext NOT NULL,
2141
`reminderPeriodicity_pbd` smallint(6) unsigned NOT NULL default '0',
2142
`reminderOn_pbd` date NOT NULL default '0000-00-00',
2143
`reminderOnMessage_pbd` mediumtext NOT NULL,
2144
`category_pbd` varchar(255) NOT NULL default '',
2145
`author_pbd` varchar(255) NOT NULL default '',
2146
`replyto_pbd` varchar(255) NOT NULL default '',
2147
`copyright_pbd` varchar(255) NOT NULL default '',
2148
`language_pbd` varchar(255) NOT NULL default '',
2149
`robots_pbd` varchar(255) NOT NULL default '',
2150
`pragma_pbd` varchar(255) NOT NULL default '',
2151
`refresh_pbd` varchar(255) NOT NULL default '',
2152
`redirect_pbd` varchar(255) NOT NULL default '',
2153
`refreshUrl_pbd` int(1) NOT NULL default '0',
2154
`url_pbd` varchar(255) NOT NULL default '',
2155
`metas_pbd` text NOT NULL,
2156
`codename_pbd` varchar(20) NOT NULL,
2157
PRIMARY KEY (`id_pbd`),
2158
KEY `page_pbd` (`page_pbd`)
2159
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2162
-- Contenu de la table `pagesBaseData_deleted`
2166
-- --------------------------------------------------------
2169
-- Structure de la table `pagesBaseData_edited`
2172
DROP TABLE IF EXISTS `pagesBaseData_edited`;
2173
CREATE TABLE `pagesBaseData_edited` (
2174
`id_pbd` int(11) unsigned NOT NULL auto_increment,
2175
`page_pbd` int(11) unsigned NOT NULL default '0',
2176
`title_pbd` varchar(150) NOT NULL default '',
2177
`linkTitle_pbd` varchar(150) NOT NULL default '',
2178
`keywords_pbd` mediumtext NOT NULL,
2179
`description_pbd` mediumtext NOT NULL,
2180
`reminderPeriodicity_pbd` smallint(6) unsigned NOT NULL default '0',
2181
`reminderOn_pbd` date NOT NULL default '0000-00-00',
2182
`reminderOnMessage_pbd` mediumtext NOT NULL,
2183
`category_pbd` varchar(255) NOT NULL default '',
2184
`author_pbd` varchar(255) NOT NULL default '',
2185
`replyto_pbd` varchar(255) NOT NULL default '',
2186
`copyright_pbd` varchar(255) NOT NULL default '',
2187
`language_pbd` varchar(255) NOT NULL default '',
2188
`robots_pbd` varchar(255) NOT NULL default '',
2189
`pragma_pbd` varchar(255) NOT NULL default '',
2190
`refresh_pbd` varchar(255) NOT NULL default '',
2191
`redirect_pbd` varchar(255) NOT NULL default '',
2192
`refreshUrl_pbd` int(1) NOT NULL default '0',
2193
`url_pbd` varchar(255) NOT NULL default '',
2194
`metas_pbd` text NOT NULL,
2195
`codename_pbd` varchar(20) NOT NULL,
2196
PRIMARY KEY (`id_pbd`),
2197
KEY `page_pbd` (`page_pbd`),
2198
FULLTEXT KEY `title_pbd` (`title_pbd`,`linkTitle_pbd`,`keywords_pbd`,`description_pbd`,`codename_pbd`)
2199
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2202
-- Contenu de la table `pagesBaseData_edited`
2205
INSERT INTO `pagesBaseData_edited` (`id_pbd`, `page_pbd`, `title_pbd`, `linkTitle_pbd`, `keywords_pbd`, `description_pbd`, `reminderPeriodicity_pbd`, `reminderOn_pbd`, `reminderOnMessage_pbd`, `category_pbd`, `author_pbd`, `replyto_pbd`, `copyright_pbd`, `language_pbd`, `robots_pbd`, `pragma_pbd`, `refresh_pbd`, `redirect_pbd`, `refreshUrl_pbd`, `url_pbd`, `metas_pbd`, `codename_pbd`) VALUES(1, 1, 'Automne', 'Automne', '', '', 0, '0000-00-00', '', '', '', '', '', '', '', '', '', '', 0, '', '', 'root');
2207
-- --------------------------------------------------------
2210
-- Structure de la table `pagesBaseData_public`
2213
DROP TABLE IF EXISTS `pagesBaseData_public`;
2214
CREATE TABLE `pagesBaseData_public` (
2215
`id_pbd` int(11) unsigned NOT NULL auto_increment,
2216
`page_pbd` int(11) unsigned NOT NULL default '0',
2217
`title_pbd` varchar(150) NOT NULL default '',
2218
`linkTitle_pbd` varchar(150) NOT NULL default '',
2219
`keywords_pbd` mediumtext NOT NULL,
2220
`description_pbd` mediumtext NOT NULL,
2221
`reminderPeriodicity_pbd` smallint(6) unsigned NOT NULL default '0',
2222
`reminderOn_pbd` date NOT NULL default '0000-00-00',
2223
`reminderOnMessage_pbd` mediumtext NOT NULL,
2224
`category_pbd` varchar(255) NOT NULL default '',
2225
`author_pbd` varchar(255) NOT NULL default '',
2226
`replyto_pbd` varchar(255) NOT NULL default '',
2227
`copyright_pbd` varchar(255) NOT NULL default '',
2228
`language_pbd` varchar(255) NOT NULL default '',
2229
`robots_pbd` varchar(255) NOT NULL default '',
2230
`pragma_pbd` varchar(255) NOT NULL default '',
2231
`refresh_pbd` varchar(255) NOT NULL default '',
2232
`redirect_pbd` varchar(255) NOT NULL default '',
2233
`refreshUrl_pbd` int(1) NOT NULL default '0',
2234
`url_pbd` varchar(255) NOT NULL default '',
2235
`metas_pbd` text NOT NULL,
2236
`codename_pbd` varchar(20) NOT NULL,
2237
PRIMARY KEY (`id_pbd`),
2238
KEY `page_pbd` (`page_pbd`),
2239
FULLTEXT KEY `title_pbd` (`title_pbd`,`linkTitle_pbd`,`keywords_pbd`,`description_pbd`,`codename_pbd`)
2240
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2243
-- Contenu de la table `pagesBaseData_public`
2246
INSERT INTO `pagesBaseData_public` (`id_pbd`, `page_pbd`, `title_pbd`, `linkTitle_pbd`, `keywords_pbd`, `description_pbd`, `reminderPeriodicity_pbd`, `reminderOn_pbd`, `reminderOnMessage_pbd`, `category_pbd`, `author_pbd`, `replyto_pbd`, `copyright_pbd`, `language_pbd`, `robots_pbd`, `pragma_pbd`, `refresh_pbd`, `redirect_pbd`, `refreshUrl_pbd`, `url_pbd`, `metas_pbd`, `codename_pbd`) VALUES(1, 1, 'Automne', 'Automne', '', '', 0, '0000-00-00', '', '', '', '', '', '', '', '', '', '', 0, '', '', 'root');
2248
-- --------------------------------------------------------
2251
-- Structure de la table `pageTemplates`
2254
DROP TABLE IF EXISTS `pageTemplates`;
2255
CREATE TABLE `pageTemplates` (
2256
`id_pt` int(11) unsigned NOT NULL auto_increment,
2257
`label_pt` varchar(100) NOT NULL default '',
2258
`groupsStack_pt` varchar(255) NOT NULL default '',
2259
`modulesStack_pt` varchar(255) NOT NULL default '1',
2260
`definitionFile_pt` varchar(100) NOT NULL default '',
2261
`creator_pt` int(11) unsigned NOT NULL default '0',
2262
`private_pt` tinyint(4) NOT NULL default '0',
2263
`image_pt` varchar(255) NOT NULL default '',
2264
`inUse_pt` tinyint(4) unsigned NOT NULL default '0',
2265
`printingCSOrder_pt` varchar(255) NOT NULL default '',
2266
`description_pt` text NOT NULL,
2267
`websitesdenied_pt` varchar(255) NOT NULL default '',
2268
PRIMARY KEY (`id_pt`),
2269
KEY `definitionFile_pt` (`definitionFile_pt`),
2270
FULLTEXT KEY `label_pt` (`label_pt`,`description_pt`)
2271
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2274
-- Contenu de la table `pageTemplates`
2277
INSERT INTO `pageTemplates` (`id_pt`, `label_pt`, `groupsStack_pt`, `modulesStack_pt`, `definitionFile_pt`, `creator_pt`, `private_pt`, `image_pt`, `inUse_pt`, `printingCSOrder_pt`, `description_pt`, `websitesdenied_pt`) VALUES(1, 'Splash', 'fr', '', 'splash.xml', 0, 0, 'nopicto.gif', 0, '', 'Modèle vide. Employé pour les pages de redirections.', '');
2278
INSERT INTO `pageTemplates` (`id_pt`, `label_pt`, `groupsStack_pt`, `modulesStack_pt`, `definitionFile_pt`, `creator_pt`, `private_pt`, `image_pt`, `inUse_pt`, `printingCSOrder_pt`, `description_pt`, `websitesdenied_pt`) VALUES(2, 'Exemple', 'fr', 'standard', 'example.xml', 0, 0, 'nopicto.gif', 0, '', 'Modèle d''exemple.', '');
2280
-- --------------------------------------------------------
2283
-- Structure de la table `profiles`
2286
DROP TABLE IF EXISTS `profiles`;
2287
CREATE TABLE `profiles` (
2288
`id_pr` int(11) unsigned NOT NULL auto_increment,
2289
`templateGroupsDeniedStack_pr` varchar(255) NOT NULL default '',
2290
`rowGroupsDeniedStack_pr` varchar(255) NOT NULL default '',
2291
`pageClearancesStack_pr` text NOT NULL,
2292
`moduleClearancesStack_pr` text NOT NULL,
2293
`validationClearancesStack_pr` text NOT NULL,
2294
`administrationClearance_pr` int(11) unsigned NOT NULL default '0',
2295
PRIMARY KEY (`id_pr`)
2296
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2299
-- Contenu de la table `profiles`
2302
INSERT INTO `profiles` (`id_pr`, `templateGroupsDeniedStack_pr`, `rowGroupsDeniedStack_pr`, `pageClearancesStack_pr`, `moduleClearancesStack_pr`, `validationClearancesStack_pr`, `administrationClearance_pr`) VALUES(1, '', '', '1,2', 'standard,2;cms_aliases,2;pnews,2;cms_forms,2;ppictures,2', 'standard', 319);
2303
INSERT INTO `profiles` (`id_pr`, `templateGroupsDeniedStack_pr`, `rowGroupsDeniedStack_pr`, `pageClearancesStack_pr`, `moduleClearancesStack_pr`, `validationClearancesStack_pr`, `administrationClearance_pr`) VALUES(3, 'fr;en', '', '1,1', '', '', 0);
2305
-- --------------------------------------------------------
2308
-- Structure de la table `profilesUsers`
2311
DROP TABLE IF EXISTS `profilesUsers`;
2312
CREATE TABLE `profilesUsers` (
2313
`id_pru` int(11) unsigned NOT NULL auto_increment,
2314
`login_pru` varchar(50) NOT NULL default '',
2315
`password_pru` varchar(32) NOT NULL default '',
2316
`firstName_pru` varchar(50) NOT NULL default '',
2317
`lastName_pru` varchar(50) NOT NULL default '',
2318
`contactData_pru` int(11) unsigned NOT NULL default '0',
2319
`profile_pru` int(11) unsigned NOT NULL default '0',
2320
`language_pru` varchar(16) NOT NULL default 'fr',
2321
`dn_pru` varchar(255) NOT NULL default '',
2322
`active_pru` tinyint(4) NOT NULL default '0',
2323
`deleted_pru` tinyint(4) unsigned NOT NULL default '0',
2324
`alerts_pru` text NOT NULL,
2325
`favorites_pru` text NOT NULL,
2326
PRIMARY KEY (`id_pru`),
2327
KEY `ldapDN_pru` (`dn_pru`),
2328
FULLTEXT KEY `login_pru` (`login_pru`,`firstName_pru`,`lastName_pru`)
2329
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2332
-- Contenu de la table `profilesUsers`
2335
INSERT INTO `profilesUsers` (`id_pru`, `login_pru`, `password_pru`, `firstName_pru`, `lastName_pru`, `contactData_pru`, `profile_pru`, `language_pru`, `dn_pru`, `active_pru`, `deleted_pru`, `alerts_pru`, `favorites_pru`) VALUES(1, 'root', '3b0d99b9bb927794036aa828050f364d', '', 'Super Administrator', 1, 1, 'en', '', 1, 0, 'standard,7;pnews,1;pmedia,1', '');
2336
INSERT INTO `profilesUsers` (`id_pru`, `login_pru`, `password_pru`, `firstName_pru`, `lastName_pru`, `contactData_pru`, `profile_pru`, `language_pru`, `dn_pru`, `active_pru`, `deleted_pru`, `alerts_pru`, `favorites_pru`) VALUES(3, 'anonymous', '294de3557d9d00b3d2d8a1e6aab028cf', '', 'Anonymous User', 3, 3, 'en', '', 1, 0, '', '');
2338
-- --------------------------------------------------------
2341
-- Structure de la table `profilesUsersGroups`
2344
DROP TABLE IF EXISTS `profilesUsersGroups`;
2345
CREATE TABLE `profilesUsersGroups` (
2346
`id_prg` int(11) unsigned NOT NULL auto_increment,
2347
`description_prg` mediumtext NOT NULL,
2348
`label_prg` varchar(50) NOT NULL default '',
2349
`profile_prg` int(11) unsigned NOT NULL default '0',
2350
`dn_prg` varchar(255) NOT NULL default '',
2351
`invertdn_prg` int(1) NOT NULL default '0',
2352
PRIMARY KEY (`id_prg`),
2353
KEY `ldapDN_prg` (`dn_prg`),
2354
FULLTEXT KEY `description_prg` (`description_prg`,`label_prg`)
2355
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2358
-- Contenu de la table `profilesUsersGroups`
2362
-- --------------------------------------------------------
2365
-- Structure de la table `profilesUsers_validators`
2368
DROP TABLE IF EXISTS `profilesUsers_validators`;
2369
CREATE TABLE `profilesUsers_validators` (
2370
`id_puv` int(11) NOT NULL auto_increment,
2371
`userId_puv` int(11) unsigned NOT NULL default '0',
2372
`module_puv` varchar(100) default NULL,
2373
PRIMARY KEY (`id_puv`)
2374
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2377
-- Contenu de la table `profilesUsers_validators`
2381
-- --------------------------------------------------------
2384
-- Structure de la table `profileUsersByGroup`
2387
DROP TABLE IF EXISTS `profileUsersByGroup`;
2388
CREATE TABLE `profileUsersByGroup` (
2389
`id_gu` int(11) NOT NULL auto_increment,
2390
`groupId_gu` int(11) NOT NULL default '0',
2391
`userId_gu` int(11) NOT NULL default '0',
2392
PRIMARY KEY (`id_gu`),
2393
KEY `groupId_gu` (`groupId_gu`),
2394
KEY `userId_gu` (`userId_gu`)
2395
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2398
-- Contenu de la table `profileUsersByGroup`
2402
-- --------------------------------------------------------
2405
-- Structure de la table `regenerator`
2408
DROP TABLE IF EXISTS `regenerator`;
2409
CREATE TABLE `regenerator` (
2410
`id_reg` int(11) unsigned NOT NULL auto_increment,
2411
`module_reg` varchar(255) NOT NULL default '0',
2412
`parameters_reg` text NOT NULL,
2413
PRIMARY KEY (`id_reg`)
2414
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2417
-- Contenu de la table `regenerator`
2421
-- --------------------------------------------------------
2424
-- Structure de la table `resources`
2427
DROP TABLE IF EXISTS `resources`;
2428
CREATE TABLE `resources` (
2429
`id_res` int(11) unsigned NOT NULL auto_increment,
2430
`status_res` int(11) unsigned NOT NULL default '0',
2431
`editorsStack_res` varchar(255) NOT NULL default '',
2432
PRIMARY KEY (`id_res`)
2433
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2436
-- Contenu de la table `resources`
2439
INSERT INTO `resources` (`id_res`, `status_res`, `editorsStack_res`) VALUES(1, 1, '');
2441
-- --------------------------------------------------------
2444
-- Structure de la table `resourceStatuses`
2447
DROP TABLE IF EXISTS `resourceStatuses`;
2448
CREATE TABLE `resourceStatuses` (
2449
`id_rs` int(11) unsigned NOT NULL auto_increment,
2450
`location_rs` tinyint(4) unsigned NOT NULL default '1',
2451
`proposedFor_rs` tinyint(4) unsigned NOT NULL default '0',
2452
`editions_rs` tinyint(4) unsigned NOT NULL default '0',
2453
`validationsRefused_rs` tinyint(4) unsigned NOT NULL default '0',
2454
`publication_rs` tinyint(4) unsigned NOT NULL default '0',
2455
`publicationDateStart_rs` date NOT NULL default '0000-00-00',
2456
`publicationDateEnd_rs` date NOT NULL default '0000-00-00',
2457
`publicationDateStartEdited_rs` date NOT NULL default '0000-00-00',
2458
`publicationDateEndEdited_rs` date NOT NULL default '0000-00-00',
2459
PRIMARY KEY (`id_rs`)
2460
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2463
-- Contenu de la table `resourceStatuses`
2466
INSERT INTO `resourceStatuses` (`id_rs`, `location_rs`, `proposedFor_rs`, `editions_rs`, `validationsRefused_rs`, `publication_rs`, `publicationDateStart_rs`, `publicationDateEnd_rs`, `publicationDateStartEdited_rs`, `publicationDateEndEdited_rs`) VALUES(1, 1, 0, 0, 0, 2, '2009-01-01', '0000-00-00', '2009-01-01', '0000-00-00');
2468
-- --------------------------------------------------------
2471
-- Structure de la table `resourceValidations`
2474
DROP TABLE IF EXISTS `resourceValidations`;
2475
CREATE TABLE `resourceValidations` (
2476
`id_rv` int(11) unsigned NOT NULL auto_increment,
2477
`module_rv` varchar(100) NOT NULL default '',
2478
`editions_rv` int(11) unsigned NOT NULL default '0',
2479
`resourceID_rv` int(11) unsigned NOT NULL default '0',
2480
`serializedObject_rv` mediumtext NOT NULL,
2481
`creationDate_rv` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2482
PRIMARY KEY (`id_rv`)
2483
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2486
-- Contenu de la table `resourceValidations`
2490
-- --------------------------------------------------------
2493
-- Structure de la table `scriptsStatuses`
2496
DROP TABLE IF EXISTS `scriptsStatuses`;
2497
CREATE TABLE `scriptsStatuses` (
2498
`scriptName_ss` varchar(255) NOT NULL default '',
2499
`launchDate_ss` datetime default NULL,
2500
`pidFileName_ss` varchar(255) NOT NULL default '',
2501
`module_ss` varchar(255) NOT NULL default '',
2502
`parameters_ss` text NOT NULL
2503
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2506
-- Contenu de la table `scriptsStatuses`
2510
-- --------------------------------------------------------
2513
-- Structure de la table `sessions`
2516
DROP TABLE IF EXISTS `sessions`;
2517
CREATE TABLE `sessions` (
2518
`id_ses` int(11) unsigned NOT NULL auto_increment,
2519
`phpid_ses` varchar(75) NOT NULL default '',
2520
`lastTouch_ses` datetime NOT NULL default '0000-00-00 00:00:00',
2521
`user_ses` int(11) unsigned NOT NULL default '0',
2522
`remote_addr_ses` varchar(64) NOT NULL,
2523
`http_user_agent_ses` varchar(255) NOT NULL default '',
2524
`cookie_expire_ses` datetime NOT NULL default '0000-00-00 00:00:00',
2525
PRIMARY KEY (`id_ses`),
2526
KEY `lastTouch_ses` (`lastTouch_ses`),
2527
KEY `phpid_ses` (`phpid_ses`),
2528
KEY `user_ses` (`user_ses`),
2529
KEY `cookie_expire_ses` (`cookie_expire_ses`)
2530
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2533
-- Contenu de la table `sessions`
2537
-- --------------------------------------------------------
2540
-- Structure de la table `toolbars`
2543
DROP TABLE IF EXISTS `toolbars`;
2544
CREATE TABLE `toolbars` (
2545
`id_tool` int(11) unsigned NOT NULL auto_increment,
2546
`code_tool` varchar(20) NOT NULL default '',
2547
`label_tool` varchar(255) NOT NULL default '',
2548
`elements_tool` text NOT NULL,
2549
PRIMARY KEY (`id_tool`),
2550
KEY `code_tool` (`code_tool`)
2551
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2554
-- Contenu de la table `toolbars`
2557
INSERT INTO `toolbars` (`id_tool`, `code_tool`, `label_tool`, `elements_tool`) VALUES(1, 'Default', 'Default', 'Source|Separator1|ShowBlocks|Separator2|Preview|Templates|Separator3|Cut|Copy|Paste|PasteText|PasteWord|Separator4|Print|Separator5|Undo|Redo|Separator6|Find|Replace|Separator7|SelectAll|RemoveFormat|Separator8|Bold|Italic|Underline|StrikeThrough|Separator9|Subscript|Superscript|Separator10|OrderedList|UnorderedList|Separator11|Outdent|Indent|Separator12|JustifyLeft|JustifyCenter|JustifyRight|JustifyFull|Separator13|Link|Unlink|Anchor|Separator14|Table|Rule|SpecialChar|Separator15|Style|FontFormat|FontSize|Separator16|TextColor|BGColor|Separator17|automneLinks|polymod|Image');
2558
INSERT INTO `toolbars` (`id_tool`, `code_tool`, `label_tool`, `elements_tool`) VALUES(2, 'Basic', 'Basic', 'Source|Cut|Copy|Paste|PasteText|PasteWord|Separator4|Undo|Redo|Separator6|Bold|Italic|Underline|StrikeThrough|Separator9|Subscript|Superscript|Separator10|OrderedList|UnorderedList|Separator11|Outdent|Indent|Separator12|JustifyLeft|JustifyCenter|JustifyRight|JustifyFull|Separator13|Table|Rule|SpecialChar|Separator1');
2559
INSERT INTO `toolbars` (`id_tool`, `code_tool`, `label_tool`, `elements_tool`) VALUES(3, 'BasicLink', 'BasicLink', 'Source|Separator1|Cut|Copy|Paste|PasteText|PasteWord|Separator4|Undo|Redo|Separator6|Bold|Italic|Underline|StrikeThrough|Separator9|Subscript|Superscript|Separator10|OrderedList|UnorderedList|Separator11|Outdent|Indent|Separator12|JustifyLeft|JustifyCenter|JustifyRight|JustifyFull|Separator13|Link|Unlink|Anchor|Separator14|Table|Rule|SpecialChar|Separator16|automneLinks|polymod');
2561
-- --------------------------------------------------------
2564
-- Structure de la table `websites`
2567
DROP TABLE IF EXISTS `websites`;
2568
CREATE TABLE `websites` (
2569
`id_web` int(11) unsigned NOT NULL auto_increment,
2570
`codename_web` varchar(255) NOT NULL,
2571
`label_web` varchar(255) NOT NULL default '',
2572
`url_web` varchar(255) NOT NULL default '',
2573
`altdomains_web` text NOT NULL,
2574
`root_web` int(11) unsigned NOT NULL default '0',
2575
`keywords_web` mediumtext NOT NULL,
2576
`description_web` mediumtext NOT NULL,
2577
`category_web` varchar(255) NOT NULL default '',
2578
`author_web` varchar(255) NOT NULL default '',
2579
`replyto_web` varchar(255) NOT NULL default '',
2580
`copyright_web` varchar(255) NOT NULL default '',
2581
`language_web` varchar(255) NOT NULL default '',
2582
`robots_web` varchar(255) NOT NULL default '',
2583
`favicon_web` varchar(255) NOT NULL default '',
2584
`metas_web` text NOT NULL,
2585
`order_web` int(11) unsigned NOT NULL default '0',
2586
PRIMARY KEY (`id_web`)
2587
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2590
-- Contenu de la table `websites`
2593
INSERT INTO `websites` (`id_web`, `codename_web`, `label_web`, `url_web`, `altdomains_web`, `root_web`, `keywords_web`, `description_web`, `category_web`, `author_web`, `replyto_web`, `copyright_web`, `language_web`, `robots_web`, `favicon_web`, `metas_web`, `order_web`) VALUES(1, 'root', 'Site principal', '127.0.0.1', '', 1, '', '', '', '', '', '', 'en', '', '/favicon.ico', '', 1);