Created
April 16, 2009 08:14
-
-
Save low/96312 to your computer and use it in GitHub Desktop.
Cleans up a new ExpressionEngine installation
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# get rid of template groups | |
TRUNCATE TABLE exp_template_groups; | |
INSERT INTO exp_template_groups | |
(group_name, group_order, is_site_default) | |
VALUES | |
('home', '1', 'y'); | |
# get rid of templates | |
TRUNCATE TABLE exp_templates; | |
INSERT INTO exp_templates | |
(group_id, template_name) | |
VALUES | |
('1', 'index'); | |
# better html buttons | |
TRUNCATE TABLE exp_html_buttons; | |
INSERT INTO exp_html_buttons | |
(tag_name, tag_open, tag_close, accesskey, tag_order) | |
VALUES | |
('h2', '<h2>', '</h2>', '2', 1), | |
('h3', '<h3>', '</h3>', '3', 2), | |
('em', '<em>', '</em>', 'i', 3), | |
('strong', '<strong>', '</strong>', 'b', 4); | |
# no categories please | |
TRUNCATE TABLE exp_category_posts; | |
TRUNCATE TABLE exp_categories; | |
TRUNCATE TABLE exp_category_groups; | |
TRUNCATE TABLE exp_category_field_data; | |
# no weblog entries please | |
TRUNCATE TABLE exp_weblog_titles; | |
TRUNCATE TABLE exp_weblog_data; | |
TRUNCATE TABLE exp_weblog_fields; | |
# just one weblog field | |
ALTER TABLE exp_weblog_data DROP field_id_2, DROP field_ft_2, DROP field_id_3, DROP field_ft_3; | |
INSERT INTO exp_weblog_fields | |
(group_id, field_name, field_label, field_type, field_ta_rows, field_search, field_order) | |
VALUES | |
(1, 'body', 'Body', 'textarea', 8, 'y', 1); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment