ee_clean-install.sql

# 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);