Pagina 1 van 1
Prime Trash Bin
Geplaatst: 08 okt 2010, 06:45
door Solidjeuh
Hoe kan ik onderstaand script toevoegen? is dat via mijn SQL?
Kan me iemand uitleggen hoe en wat ik juist moet doen daarmee..
ben een beginneling, moet nog veel leren... lol
SQL
Code: Selecteer alles
INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('f_delete_forever', 0, 1, 0);
Code: Selecteer alles
INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('f_undelete', 0, 1, 0);
Code: Selecteer alles
INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('m_delete_forever', 1, 1, 0);
Code: Selecteer alles
INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('m_undelete', 1, 1, 0);
Code: Selecteer alles
ALTER TABLE phpbb_topics ADD ( topic_deleted_from mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_user mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_time int(11) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_reason varchar(255) DEFAULT "" NOT NULL);
Code: Selecteer alles
ALTER TABLE phpbb_posts ADD ( post_deleted_from mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_user mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_time int(11) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_reason varchar(255) DEFAULT "" NOT NULL);
Re: Prime Trash Bin
Geplaatst: 08 okt 2010, 06:53
door Jim
Ja, je kan met het programma phpMyAdmin SQL queries uitvoeren op je database.
Voor informatie hierover, kijk in onze wiki!
http://wiki.phpbb.nl/Sql_query_uitvoeren
Re: Prime Trash Bin
Geplaatst: 08 okt 2010, 06:55
door Solidjeuh
Brrrr heb al schrik dat ik iets ga verkeerd doen.. lool
ach ja, met backup komt het wel goed hoop ik..
zullen eens proberen si
Re: Prime Trash Bin
Geplaatst: 08 okt 2010, 07:04
door Solidjeuh
Code: Selecteer alles
SQL query:
ALTER TABLE phpbb_posts ADD (
post_deleted_from mediumint( 8 ) UNSIGNED DEFAULT "0" NOT NULL ,
post_deleted_user mediumint( 8 ) UNSIGNED DEFAULT "0" NOT NULL ,
post_deleted_time int( 11 ) UNSIGNED DEFAULT "0" NOT NULL ,
post_deleted_reason varchar( 255 ) DEFAULT "" NOT NULL
)
MySQL said: Documentation
#1060 - Duplicate column name 'post_deleted_time'
een error? ik heb nogtands gwn gekopieerd en geplakt hoe het in de mod staat...
Deze:
Code: Selecteer alles
ALTER TABLE phpbb_topics ADD ( topic_deleted_from mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_user mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_time int(11) UNSIGNED DEFAULT "0" NOT NULL, topic_deleted_reason varchar(255) DEFAULT "" NOT NULL);
Code: Selecteer alles
ALTER TABLE phpbb_posts ADD ( post_deleted_from mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_user mediumint(8) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_time int(11) UNSIGNED DEFAULT "0" NOT NULL, post_deleted_reason varchar(255) DEFAULT "" NOT NULL);
Re: Prime Trash Bin
Geplaatst: 08 okt 2010, 17:04
door Kevin
Als dit telkens de error is dan wil dat meer zeggen dan dat de tabel die je wil toevoegen al bestaat in je database.
Code: Selecteer alles
MySQL said: Documentation
#1060 - Duplicate column name 'post_deleted_time'