1
# Database : `automne4`
2
# --------------------------------------------------------
5
# This script can help you to make a fresh and clean install of Automne
6
# It remove all pages, rows, users and data of Automne and all datas of the pre-installed Automne demo
7
# /!\ Use it carefully /!\
10
DELETE FROM actionsTimestamps;
12
DELETE FROM blocksFiles_archived;
13
DELETE FROM blocksFiles_deleted;
14
DELETE FROM blocksFiles_edited;
15
DELETE FROM blocksFiles_edition;
16
DELETE FROM blocksFiles_public;
18
DELETE FROM blocksFlashes_archived;
19
DELETE FROM blocksFlashes_deleted;
20
DELETE FROM blocksFlashes_edited;
21
DELETE FROM blocksFlashes_edition;
22
DELETE FROM blocksFlashes_public;
24
DELETE FROM blocksImages_archived;
25
DELETE FROM blocksImages_deleted;
26
DELETE FROM blocksImages_edited;
27
DELETE FROM blocksImages_edition;
28
DELETE FROM blocksImages_public;
30
DELETE FROM blocksTexts_archived;
31
DELETE FROM blocksTexts_deleted;
32
DELETE FROM blocksTexts_edited;
33
DELETE FROM blocksTexts_edition;
34
DELETE FROM blocksTexts_public;
36
DELETE FROM blocksVarchars_archived;
37
DELETE FROM blocksVarchars_deleted;
38
DELETE FROM blocksVarchars_edited;
39
DELETE FROM blocksVarchars_edition;
40
DELETE FROM blocksVarchars_public;
42
DELETE FROM blocksRawDatas_archived;
43
DELETE FROM blocksRawDatas_deleted;
44
DELETE FROM blocksRawDatas_edited;
45
DELETE FROM blocksRawDatas_edition;
46
DELETE FROM blocksRawDatas_public;
49
DELETE FROM contactDatas where id_cd not in (1, 3);
51
DELETE FROM linx_real_public;
52
DELETE FROM linx_tree_edited;
53
DELETE FROM linx_tree_public;
54
DELETE FROM linx_watch_public;
58
DELETE FROM mod_cms_forms_actions;
59
DELETE FROM mod_cms_forms_categories;
60
DELETE FROM mod_cms_forms_fields;
61
DELETE FROM mod_cms_forms_formulars;
62
DELETE FROM mod_cms_forms_records;
63
DELETE FROM mod_cms_forms_senders;
64
DELETE FROM mod_cms_aliases;
65
DELETE FROM mod_object_polyobjects;
66
DELETE FROM mod_object_rss_definition;
68
UPDATE mod_object_definition SET previewURL_mod = '';
70
DELETE FROM mod_standard_clientSpaces_edited;
71
DELETE FROM mod_standard_clientSpaces_edition;
72
DELETE FROM mod_standard_clientSpaces_public;
73
DELETE FROM mod_standard_clientSpaces_deleted;
74
DELETE FROM mod_standard_clientSpaces_archived;
76
DELETE FROM mod_subobject_date_deleted;
77
DELETE FROM mod_subobject_date_edited;
78
DELETE FROM mod_subobject_date_public;
79
DELETE FROM mod_subobject_integer_deleted;
80
DELETE FROM mod_subobject_integer_edited;
81
DELETE FROM mod_subobject_integer_public;
82
DELETE FROM mod_subobject_string_deleted;
83
DELETE FROM mod_subobject_string_edited;
84
DELETE FROM mod_subobject_string_public;
85
DELETE FROM mod_subobject_text_deleted;
86
DELETE FROM mod_subobject_text_edited;
87
DELETE FROM mod_subobject_text_public;
89
#Remove news and media rows
90
DELETE FROM mod_standard_rows WHERE id_row = '66';
91
DELETE FROM mod_standard_rows WHERE id_row = '58';
92
DELETE FROM mod_standard_rows WHERE id_row = '68';
94
DELETE FROM modulesCategories where id_mca not in (1,2,18);
95
DELETE FROM modulesCategories_clearances where category_mcc not in (1,2,18);
96
DELETE FROM modulesCategories_i18nm where category_mcl not in (1,2,18);
98
DELETE FROM pageTemplates;
99
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.', '');
100
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.', '');
103
DROP TABLE IF EXISTS `pages`;
104
CREATE TABLE `pages` (
105
`id_pag` int(11) unsigned NOT NULL auto_increment,
106
`resource_pag` int(11) unsigned NOT NULL default '0',
107
`remindedEditorsStack_pag` varchar(255) NOT NULL default '',
108
`lastReminder_pag` date NOT NULL default '0000-00-00',
109
`template_pag` int(11) unsigned NOT NULL default '0',
110
`lastFileCreation_pag` datetime NOT NULL default '0000-00-00 00:00:00',
111
`url_pag` varchar(255) NOT NULL default '',
112
PRIMARY KEY (`id_pag`),
113
KEY `id_pag` (`id_pag`),
114
KEY `template_pag` (`template_pag`)
115
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
116
INSERT INTO pages (id_pag, resource_pag, remindedEditorsStack_pag, lastReminder_pag, template_pag, lastFileCreation_pag, url_pag) VALUES (1, 1, '1', NOW(), 1, '2009-01-01 16:55:02', '');
118
DELETE FROM pagesBaseData_archived;
119
DELETE FROM pagesBaseData_deleted;
120
DELETE FROM pagesBaseData_edited;
121
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');
123
DELETE FROM pagesBaseData_public;
124
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');
126
DELETE FROM profileUsersByGroup;
128
DELETE FROM profiles where id_pr not in (1,3);
129
DELETE FROM profilesUsersGroups;
131
DELETE FROM profilesUsers where id_pru not in (1,3);
133
DELETE FROM profilesUsers_validators;
135
DELETE FROM resourceStatuses;
136
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');
139
DELETE FROM resourceValidations;
141
DELETE FROM resources;
142
INSERT INTO `resources` (`id_res`, `status_res`, `editorsStack_res`) VALUES (1, 1, '');
144
DELETE FROM sessions;
146
DELETE FROM websites where id_web != 1;
b'\\ No newline at end of file'