DELETE FROM `user_role` WHERE `rid`= 0;
DELETE FROM `role_permission` WHERE `rid`= 0;
DELETE FROM `role_i18n` WHERE `rid` = 0;
DELETE FROM `role` WHERE `rid` = 0;

INSERT INTO `role` (`rid`, `weight`, `status`, `created_at`, `updated_at`) VALUES ('-1', '0', '3', NOW(), NOW());
UPDATE `role` SET `rid` = 0 WHERE `rid` = -1;

INSERT INTO `role_i18n` (`rid`, `culture`, `name`, `description`) VALUES ('0', 'de', 'anonymous', NULL);
INSERT INTO `role_i18n` (`rid`, `culture`, `name`, `description`) VALUES ('0', 'en', 'anonymous', NULL);

INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access audio', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access blog', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access blog comment', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access channel', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access document', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access group', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access media', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access media comment', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access photo', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access static text', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access tag', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access user comment', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access user profile', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'access video', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'search blog', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'search blog comment', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'search group', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'search media', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'search media comment', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'search static text', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'search tag', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'search user comment', NOW());
INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES ('0', 'use advanced search', NOW());

INSERT INTO `user_role` (`uid`, `rid`) VALUES ('0', '0');
