Postgresql naar MySQL

Status
Niet open voor verdere reacties.
iets meer details gaat het over , het overplaatsen van de databank of wat wil je concreet ?
 
Ik heb een nieuw gecreëerde FluxBB forum met database in PostgreSQL
om te zien als u het naar MySQL converteren kunt. Ik heb het gemaakt van database-dump
met behulp van pg_dump.
 
Het is niet gemakkelijk en
u moet weten hoe een FluxBB MySQL dump zal uitzien.
weet je hoe je met Linux command line kan werken?
 
ik heb verstand van linux / unix en windows command line dus kom maar op met de info
 
--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: bans; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE bans (
id integer NOT NULL,
username character varying(200),
ip character varying(255),
email character varying(80),
message character varying(255),
expire integer,
ban_creator integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.bans OWNER TO postgres;

--
-- Name: bans_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE bans_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.bans_id_seq OWNER TO postgres;

--
-- Name: bans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE bans_id_seq OWNED BY bans.id;


--
-- Name: bans_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('bans_id_seq', 1, false);


--
-- Name: categories; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE categories (
id integer NOT NULL,
cat_name character varying(80) DEFAULT 'New Category'::character varying NOT NULL,
disp_position integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.categories OWNER TO postgres;

--
-- Name: categories_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE categories_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.categories_id_seq OWNER TO postgres;

--
-- Name: categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE categories_id_seq OWNED BY categories.id;


--
-- Name: categories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('categories_id_seq', 1, true);


--
-- Name: censoring; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE censoring (
id integer NOT NULL,
search_for character varying(60) DEFAULT ''::character varying NOT NULL,
replace_with character varying(60) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.censoring OWNER TO postgres;

--
-- Name: censoring_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE censoring_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.censoring_id_seq OWNER TO postgres;

--
-- Name: censoring_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE censoring_id_seq OWNED BY censoring.id;


--
-- Name: censoring_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('censoring_id_seq', 1, false);


--
-- Name: config; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE config (
conf_name character varying(255) DEFAULT ''::character varying NOT NULL,
conf_value text
);


ALTER TABLE public.config OWNER TO postgres;

--
-- Name: forum_perms; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE forum_perms (
group_id integer DEFAULT 0 NOT NULL,
forum_id integer DEFAULT 0 NOT NULL,
read_forum smallint DEFAULT 1 NOT NULL,
post_replies smallint DEFAULT 1 NOT NULL,
post_topics smallint DEFAULT 1 NOT NULL
);


ALTER TABLE public.forum_perms OWNER TO postgres;

--
-- Name: forum_subscriptions; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE forum_subscriptions (
user_id integer DEFAULT 0 NOT NULL,
forum_id integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.forum_subscriptions OWNER TO postgres;

--
-- Name: forums; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE forums (
id integer NOT NULL,
forum_name character varying(80) DEFAULT 'New forum'::character varying NOT NULL,
forum_desc text,
redirect_url character varying(100),
moderators text,
num_topics integer DEFAULT 0 NOT NULL,
num_posts integer DEFAULT 0 NOT NULL,
last_post integer,
last_post_id integer,
last_poster character varying(200),
sort_by smallint DEFAULT 0 NOT NULL,
disp_position integer DEFAULT 0 NOT NULL,
cat_id integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.forums OWNER TO postgres;

--
-- Name: forums_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE forums_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.forums_id_seq OWNER TO postgres;

--
-- Name: forums_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE forums_id_seq OWNED BY forums.id;


--
-- Name: forums_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('forums_id_seq', 1, true);


--
-- Name: groups; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE groups (
g_id integer NOT NULL,
g_title character varying(50) DEFAULT ''::character varying NOT NULL,
g_user_title character varying(50),
g_promote_min_posts integer DEFAULT 0 NOT NULL,
g_promote_next_group integer DEFAULT 0 NOT NULL,
g_moderator smallint DEFAULT 0 NOT NULL,
g_mod_edit_users smallint DEFAULT 0 NOT NULL,
g_mod_rename_users smallint DEFAULT 0 NOT NULL,
g_mod_change_passwords smallint DEFAULT 0 NOT NULL,
g_mod_ban_users smallint DEFAULT 0 NOT NULL,
g_read_board smallint DEFAULT 1 NOT NULL,
g_view_users smallint DEFAULT 1 NOT NULL,
g_post_replies smallint DEFAULT 1 NOT NULL,
g_post_topics smallint DEFAULT 1 NOT NULL,
g_edit_posts smallint DEFAULT 1 NOT NULL,
g_delete_posts smallint DEFAULT 1 NOT NULL,
g_delete_topics smallint DEFAULT 1 NOT NULL,
g_post_links smallint DEFAULT 1 NOT NULL,
g_set_title smallint DEFAULT 1 NOT NULL,
g_search smallint DEFAULT 1 NOT NULL,
g_search_users smallint DEFAULT 1 NOT NULL,
g_send_email smallint DEFAULT 1 NOT NULL,
g_post_flood smallint DEFAULT 30 NOT NULL,
g_search_flood smallint DEFAULT 30 NOT NULL,
g_email_flood smallint DEFAULT 60 NOT NULL,
g_report_flood smallint DEFAULT 60 NOT NULL
);


ALTER TABLE public.groups OWNER TO postgres;

--
-- Name: groups_g_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE groups_g_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.groups_g_id_seq OWNER TO postgres;

--
-- Name: groups_g_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE groups_g_id_seq OWNED BY groups.g_id;


--
-- Name: groups_g_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('groups_g_id_seq', 4, true);


--
-- Name: online; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE online (
user_id integer DEFAULT 1 NOT NULL,
ident character varying(200) DEFAULT ''::character varying NOT NULL,
logged integer DEFAULT 0 NOT NULL,
idle smallint DEFAULT 0 NOT NULL,
last_post integer,
last_search integer
);


ALTER TABLE public.online OWNER TO postgres;

--
-- Name: posts; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE posts (
id integer NOT NULL,
poster character varying(200) DEFAULT ''::character varying NOT NULL,
poster_id integer DEFAULT 1 NOT NULL,
poster_ip character varying(39),
poster_email character varying(80),
message text,
hide_smilies smallint DEFAULT 0 NOT NULL,
posted integer DEFAULT 0 NOT NULL,
edited integer,
edited_by character varying(200),
topic_id integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.posts OWNER TO postgres;

--
-- Name: posts_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE posts_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.posts_id_seq OWNER TO postgres;

--
-- Name: posts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE posts_id_seq OWNED BY posts.id;


--
-- Name: posts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('posts_id_seq', 2, true);


--
-- Name: reports; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE reports (
id integer NOT NULL,
post_id integer DEFAULT 0 NOT NULL,
topic_id integer DEFAULT 0 NOT NULL,
forum_id integer DEFAULT 0 NOT NULL,
reported_by integer DEFAULT 0 NOT NULL,
created integer DEFAULT 0 NOT NULL,
message text,
zapped integer,
zapped_by integer
);


ALTER TABLE public.reports OWNER TO postgres;

--
-- Name: reports_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE reports_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.reports_id_seq OWNER TO postgres;

--
-- Name: reports_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE reports_id_seq OWNED BY reports.id;


--
-- Name: reports_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('reports_id_seq', 1, false);


--
-- Name: search_cache; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE search_cache (
id integer DEFAULT 0 NOT NULL,
ident character varying(200) DEFAULT ''::character varying NOT NULL,
search_data text
);


ALTER TABLE public.search_cache OWNER TO postgres;

--
-- Name: search_matches; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE search_matches (
post_id integer DEFAULT 0 NOT NULL,
word_id integer DEFAULT 0 NOT NULL,
subject_match smallint DEFAULT 0 NOT NULL
);


ALTER TABLE public.search_matches OWNER TO postgres;

--
-- Name: search_words; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE search_words (
id integer NOT NULL,
word character varying(20) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.search_words OWNER TO postgres;

--
-- Name: search_words_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE search_words_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.search_words_id_seq OWNER TO postgres;

--
-- Name: search_words_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE search_words_id_seq OWNED BY search_words.id;


--
-- Name: search_words_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('search_words_id_seq', 17, true);


--
-- Name: topic_subscriptions; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE topic_subscriptions (
user_id integer DEFAULT 0 NOT NULL,
topic_id integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.topic_subscriptions OWNER TO postgres;

--
-- Name: topics; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE topics (
id integer NOT NULL,
poster character varying(200) DEFAULT ''::character varying NOT NULL,
subject character varying(255) DEFAULT ''::character varying NOT NULL,
posted integer DEFAULT 0 NOT NULL,
first_post_id integer DEFAULT 0 NOT NULL,
last_post integer DEFAULT 0 NOT NULL,
last_post_id integer DEFAULT 0 NOT NULL,
last_poster character varying(200),
num_views integer DEFAULT 0 NOT NULL,
num_replies integer DEFAULT 0 NOT NULL,
closed smallint DEFAULT 0 NOT NULL,
sticky smallint DEFAULT 0 NOT NULL,
moved_to integer,
forum_id integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.topics OWNER TO postgres;

--
-- Name: topics_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE topics_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.topics_id_seq OWNER TO postgres;

--
-- Name: topics_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE topics_id_seq OWNED BY topics.id;


--
-- Name: topics_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('topics_id_seq', 2, true);


--
-- Name: users; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--

CREATE TABLE users (
id integer NOT NULL,
group_id integer DEFAULT 3 NOT NULL,
username character varying(200) DEFAULT ''::character varying NOT NULL,
password character varying(40) DEFAULT ''::character varying NOT NULL,
email character varying(80) DEFAULT ''::character varying NOT NULL,
title character varying(50),
realname character varying(40),
url character varying(100),
jabber character varying(80),
icq character varying(12),
msn character varying(80),
aim character varying(30),
yahoo character varying(30),
location character varying(30),
signature text,
disp_topics smallint,
disp_posts smallint,
email_setting smallint DEFAULT 1 NOT NULL,
notify_with_post smallint DEFAULT 0 NOT NULL,
auto_notify smallint DEFAULT 0 NOT NULL,
show_smilies smallint DEFAULT 1 NOT NULL,
show_img smallint DEFAULT 1 NOT NULL,
show_img_sig smallint DEFAULT 1 NOT NULL,
show_avatars smallint DEFAULT 1 NOT NULL,
show_sig smallint DEFAULT 1 NOT NULL,
timezone real DEFAULT 0 NOT NULL,
dst smallint DEFAULT 0 NOT NULL,
time_format smallint DEFAULT 0 NOT NULL,
date_format smallint DEFAULT 0 NOT NULL,
language character varying(25) DEFAULT 'English'::character varying NOT NULL,
style character varying(25) DEFAULT 'Air'::character varying NOT NULL,
num_posts integer DEFAULT 0 NOT NULL,
last_post integer,
last_search integer,
last_email_sent integer,
last_report_sent integer,
registered integer DEFAULT 0 NOT NULL,
registration_ip character varying(39) DEFAULT '0.0.0.0'::character varying NOT NULL,
last_visit integer DEFAULT 0 NOT NULL,
admin_note character varying(30),
activate_string character varying(80),
activate_key character varying(8)
);


ALTER TABLE public.users OWNER TO postgres;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE users_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.users_id_seq OWNER TO postgres;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE users_id_seq OWNED BY users.id;


--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('users_id_seq', 3, true);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY bans ALTER COLUMN id SET DEFAULT nextval('bans_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY categories ALTER COLUMN id SET DEFAULT nextval('categories_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY censoring ALTER COLUMN id SET DEFAULT nextval('censoring_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY forums ALTER COLUMN id SET DEFAULT nextval('forums_id_seq'::regclass);


--
-- Name: g_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY groups ALTER COLUMN g_id SET DEFAULT nextval('groups_g_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY posts ALTER COLUMN id SET DEFAULT nextval('posts_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY reports ALTER COLUMN id SET DEFAULT nextval('reports_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY search_words ALTER COLUMN id SET DEFAULT nextval('search_words_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY topics ALTER COLUMN id SET DEFAULT nextval('topics_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);


--
-- Data for Name: bans; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY bans (id, username, ip, email, message, expire, ban_creator) FROM stdin;
\.


--
-- Data for Name: categories; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY categories (id, cat_name, disp_position) FROM stdin;
1 Test category 1
\.


--
-- Data for Name: censoring; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY censoring (id, search_for, replace_with) FROM stdin;
\.


--
-- Data for Name: config; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY config (conf_name, conf_value) FROM stdin;
o_cur_version 1.5.2
o_database_revision 18
o_searchindex_revision 2
o_parser_revision 2
o_board_title My FluxBB Forum
o_board_desc <p><span>Unfortunately no one can be told what FluxBB is - you have to see it for yourself.</span></p>
o_default_timezone 0
o_time_format H:i:s
o_date_format Y-m-d
o_timeout_visit 1800
o_timeout_online 300
o_redirect_delay 1
o_show_version 0
o_show_user_info 1
o_show_post_count 1
o_signatures 1
o_smilies 1
o_smilies_sig 1
o_make_links 1
o_default_lang English
o_default_style Air
o_default_user_group 4
o_topic_review 15
o_disp_topics_default 30
o_disp_posts_default 25
o_indent_num_spaces 4
o_quote_depth 3
o_quickpost 1
o_users_online 1
o_censoring 0
o_show_dot 0
o_topic_views 1
o_quickjump 1
o_gzip 0
o_additional_navlinks
o_report_method 0
o_regs_report 0
o_default_email_setting 1
o_mailing_list xxxxxxxxx@gmail.com
o_avatars 1
o_avatars_dir img/avatars
o_avatars_width 60
o_avatars_height 60
o_avatars_size 10240
o_search_all_forums 1
o_base_url http://test.org/test
o_admin_email xxxxxxxxxxxxx@gmail.com
o_webmaster_email xxxxxxxxxxxxx@gmail.com
o_forum_subscriptions 1
o_topic_subscriptions 1
o_smtp_host \N
o_smtp_user \N
o_smtp_pass \N
o_smtp_ssl 0
o_regs_allow 1
o_regs_verify 0
o_announcement 0
o_announcement_message Enter your announcement here.
o_rules 0
o_rules_message Enter your rules here
o_maintenance 0
o_maintenance_message The forums are temporarily down for maintenance. Please try again in a few minutes.
o_default_dst 0
o_feed_type 2
o_feed_ttl 0
p_message_bbcode 1
p_message_img_tag 1
p_message_all_caps 1
p_subject_all_caps 1
p_sig_all_caps 1
p_sig_bbcode 1
p_sig_img_tag 0
p_sig_length 400
p_sig_lines 4
p_allow_banned_email 1
p_allow_dupe_email 0
p_force_guest_email 1
\.


--
-- Data for Name: forum_perms; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY forum_perms (group_id, forum_id, read_forum, post_replies, post_topics) FROM stdin;
\.


--
-- Data for Name: forum_subscriptions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY forum_subscriptions (user_id, forum_id) FROM stdin;
\.


--
-- Data for Name: forums; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY forums (id, forum_name, forum_desc, redirect_url, moderators, num_topics, num_posts, last_post, last_post_id, last_poster, sort_by, disp_position, cat_id) FROM stdin;
1 Test forum This is just a test forum \N \N 2 2 1360612137 2 user2 0 1 1
\.


--
-- Data for Name: groups; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY groups (g_id, g_title, g_user_title, g_promote_min_posts, g_promote_next_group, g_moderator, g_mod_edit_users, g_mod_rename_users, g_mod_change_passwords, g_mod_ban_users, g_read_board, g_view_users, g_post_replies, g_post_topics, g_edit_posts, g_delete_posts, g_delete_topics, g_post_links, g_set_title, g_search, g_search_users, g_send_email, g_post_flood, g_search_flood, g_email_flood, g_report_flood) FROM stdin;
1 Administrators Administrator 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0
2 Moderators Moderator 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0
3 Guests \N 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 1 1 0 60 30 0 0
4 Members \N 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 0 1 1 1 60 30 60 60
\.


--
-- Data for Name: online; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY online (user_id, ident, logged, idle, last_post, last_search) FROM stdin;
1 85.247.30.240 1360611978 0 \N \N
1 82.154.24.7 1360612161 0 \N \N
\.


--
-- Data for Name: posts; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY posts (id, poster, poster_id, poster_ip, poster_email, message, hide_smilies, posted, edited, edited_by, topic_id) FROM stdin;
1 user 2 85.247.30.240 \N If you are looking at this (which I guess you are), the install of FluxBB appears to have worked! Now log in and head over to the administration control panel to configure your forum. 0 1360611857 \N \N 1
2 user2 3 82.154.24.7 \N Test message :P 0 1360612137 \N \N 2
\.


--
-- Data for Name: reports; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY reports (id, post_id, topic_id, forum_id, reported_by, created, message, zapped, zapped_by) FROM stdin;
\.


--
-- Data for Name: search_cache; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY search_cache (id, ident, search_data) FROM stdin;
\.


--
-- Data for Name: search_matches; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY search_matches (post_id, word_id, subject_match) FROM stdin;
1 1 0
1 2 0
1 3 0
1 4 0
1 5 0
1 6 0
1 7 0
1 8 0
1 9 0
1 10 0
1 11 0
1 12 0
1 13 0
1 14 1
1 15 1
2 14 0
2 16 0
2 14 1
2 17 1
\.


--
-- Data for Name: search_words; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY search_words (id, word) FROM stdin;
1 looking
2 guess
3 install
4 fluxbb
5 appears
6 worked
7 log
8 head
9 administration
10 control
11 panel
12 configure
13 forum
14 test
15 topic
16 message
17 subject
\.


--
-- Data for Name: topic_subscriptions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY topic_subscriptions (user_id, topic_id) FROM stdin;
\.


--
-- Data for Name: topics; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY topics (id, poster, subject, posted, first_post_id, last_post, last_post_id, last_poster, num_views, num_replies, closed, sticky, moved_to, forum_id) FROM stdin;
1 user Test topic 1360611857 1 1360611857 1 user 0 0 0 0 \N 1
2 user2 Test subject :) 1360612137 2 1360612137 2 user2 2 0 0 0 \N 1
\.


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY users (id, group_id, username, password, email, title, realname, url, jabber, icq, msn, aim, yahoo, location, signature, disp_topics, disp_posts, email_setting, notify_with_post, auto_notify, show_smilies, show_img, show_img_sig, show_avatars, show_sig, timezone, dst, time_format, date_format, language, style, num_posts, last_post, last_search, last_email_sent, last_report_sent, registered, registration_ip, last_visit, admin_note, activate_string, activate_key) FROM stdin;
1 3 Guest Guest Guest \N \N \N \N \N \N \N \N \N \N \N \N 1 0 0 1 1 1 1 1 0 0 0 0 English Air 0 \N \N \N \N 0 0.0.0.0 0 \N \N \N
2 1 user 175a291189e5fef553ded55a0d334399dcaaa156 xxxxxxxxx@gmail.com \N \N \N \N \N \N \N \N \N \N \N \N 1 0 0 1 1 1 1 1 0 0 0 0 English Air 1 1360611857 \N \N \N 1360611857 85.247.30.240 1360611935 \N \N \N
3 4 user 175a291189e5fef553ded55a0d334399dcaaa156 user352@mail.pt \N \N \N \N \N \N \N \N \N \N \N \N 1 0 0 1 1 1 1 1 0 0 0 0 English Air 1 1360612137 \N \N \N 1360612086 82.154.24.7 1360612154 \N \N \N
\.


--
-- Name: bans_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY bans
ADD CONSTRAINT bans_pkey PRIMARY KEY (id);


--
-- Name: categories_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY categories
ADD CONSTRAINT categories_pkey PRIMARY KEY (id);


--
-- Name: censoring_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY censoring
ADD CONSTRAINT censoring_pkey PRIMARY KEY (id);


--
-- Name: config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY config
ADD CONSTRAINT config_pkey PRIMARY KEY (conf_name);


--
-- Name: forum_perms_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY forum_perms
ADD CONSTRAINT forum_perms_pkey PRIMARY KEY (group_id, forum_id);


--
-- Name: forum_subscriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY forum_subscriptions
ADD CONSTRAINT forum_subscriptions_pkey PRIMARY KEY (user_id, forum_id);


--
-- Name: forums_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY forums
ADD CONSTRAINT forums_pkey PRIMARY KEY (id);


--
-- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY groups
ADD CONSTRAINT groups_pkey PRIMARY KEY (g_id);


--
-- Name: online_user_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY online
ADD CONSTRAINT online_user_id_key UNIQUE (user_id, ident);


--
-- Name: posts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY posts
ADD CONSTRAINT posts_pkey PRIMARY KEY (id);


--
-- Name: reports_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY reports
ADD CONSTRAINT reports_pkey PRIMARY KEY (id);


--
-- Name: search_cache_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY search_cache
ADD CONSTRAINT search_cache_pkey PRIMARY KEY (id);


--
-- Name: search_words_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY search_words
ADD CONSTRAINT search_words_pkey PRIMARY KEY (word);


--
-- Name: topic_subscriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY topic_subscriptions
ADD CONSTRAINT topic_subscriptions_pkey PRIMARY KEY (user_id, topic_id);


--
-- Name: topics_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY topics
ADD CONSTRAINT topics_pkey PRIMARY KEY (id);


--
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY users
ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: users_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--

ALTER TABLE ONLY users
ADD CONSTRAINT users_username_key UNIQUE (username);


--
-- Name: bans_username_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX bans_username_idx ON bans USING btree (username);


--
-- Name: online_ident_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX online_ident_idx ON online USING btree (ident);


--
-- Name: online_logged_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX online_logged_idx ON online USING btree (logged);


--
-- Name: posts_multi_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX posts_multi_idx ON posts USING btree (poster_id, topic_id);


--
-- Name: posts_topic_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX posts_topic_id_idx ON posts USING btree (topic_id);


--
-- Name: reports_zapped_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX reports_zapped_idx ON reports USING btree (zapped);


--
-- Name: search_cache_ident_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX search_cache_ident_idx ON search_cache USING btree (ident);


--
-- Name: search_matches_post_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX search_matches_post_id_idx ON search_matches USING btree (post_id);


--
-- Name: search_matches_word_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX search_matches_word_id_idx ON search_matches USING btree (word_id);


--
-- Name: search_words_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX search_words_id_idx ON search_words USING btree (id);


--
-- Name: topics_first_post_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX topics_first_post_id_idx ON topics USING btree (first_post_id);


--
-- Name: topics_forum_id_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX topics_forum_id_idx ON topics USING btree (forum_id);


--
-- Name: topics_last_post_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX topics_last_post_idx ON topics USING btree (last_post);


--
-- Name: topics_moved_to_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX topics_moved_to_idx ON topics USING btree (moved_to);


--
-- Name: users_registered_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--

CREATE INDEX users_registered_idx ON users USING btree (registered);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--
Klik om te vergroten...

ik wil dit converteren waar moet ik het bewerken?
 
alle komentaren verwijderen de rest van de syntax is gewoon hetzelfde met mysql , enkel zal je Revoke all on schema public from public moeten verwijderen , en alle data die in de tabbellen zal je ook moeten invoeren dit is enkel een structure create (dus database structuur zonder enige inhoud)
 
heb even het werk gedaan voor je

Code: 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone="+00:00";

CREATE TABLE bans (
id int(11) NOT NULL,
username varchar(200),
ip varchar(255),
email varchar(80),
message varchar(255),
expire int(11),
ban_creator int(11) DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE categories (
id int(11) NOT NULL,
cat_name varchar(80) DEFAULT 'New Category',
disp_position int(11) DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE censoring (
id int(11) NOT NULL,
search_for varchar(60) DEFAULT '',
replace_with varchar(60) DEFAULT ''
) TYPE=MyISAM;

CREATE TABLE config (
conf_name varchar(255) DEFAULT '',
conf_value text
) TYPE=MyISAM;

CREATE TABLE forum_perms (
group_id int(11) DEFAULT 0 NOT NULL,
forum_id int(11) DEFAULT 0 NOT NULL,
read_forum smallint DEFAULT 1 NOT NULL,
post_replies smallint DEFAULT 1 NOT NULL,
post_topics smallint DEFAULT 1 NOT NULL
) TYPE=MyISAM;

CREATE TABLE forum_subscriptions (
user_id int(11) DEFAULT 0 NOT NULL,
forum_id int(11) DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE forums (
id int(11) NOT NULL,
forum_name varchar(80) DEFAULT 'New forum',
forum_desc text,
redirect_url varchar(100),
moderators text,
num_topics int(11) DEFAULT 0 NOT NULL,
num_posts int(11) DEFAULT 0 NOT NULL,
last_post int(11),
last_post_id int(11),
last_poster varchar(200),
sort_by smallint DEFAULT 0 NOT NULL,
disp_position int(11) DEFAULT 0 NOT NULL,
cat_id int(11) DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE groups (
g_id int(11) NOT NULL,
g_title varchar(50) DEFAULT '',
g_user_title varchar(50),
g_promote_min_posts int(11) DEFAULT 0 NOT NULL,
g_promote_next_group int(11) DEFAULT 0 NOT NULL,
g_moderator smallint DEFAULT 0 NOT NULL,
g_mod_edit_users smallint DEFAULT 0 NOT NULL,
g_mod_rename_users smallint DEFAULT 0 NOT NULL,
g_mod_change_passwords smallint DEFAULT 0 NOT NULL,
g_mod_ban_users smallint DEFAULT 0 NOT NULL,
g_read_board smallint DEFAULT 1 NOT NULL,
g_view_users smallint DEFAULT 1 NOT NULL,
g_post_replies smallint DEFAULT 1 NOT NULL,
g_post_topics smallint DEFAULT 1 NOT NULL,
g_edit_posts smallint DEFAULT 1 NOT NULL,
g_delete_posts smallint DEFAULT 1 NOT NULL,
g_delete_topics smallint DEFAULT 1 NOT NULL,
g_post_links smallint DEFAULT 1 NOT NULL,
g_set_title smallint DEFAULT 1 NOT NULL,
g_search smallint DEFAULT 1 NOT NULL,
g_search_users smallint DEFAULT 1 NOT NULL,
g_send_email smallint DEFAULT 1 NOT NULL,
g_post_flood smallint DEFAULT 30 NOT NULL,
g_search_flood smallint DEFAULT 30 NOT NULL,
g_email_flood smallint DEFAULT 60 NOT NULL,
g_report_flood smallint DEFAULT 60 NOT NULL
) TYPE=MyISAM;

CREATE TABLE online (
user_id int(11) DEFAULT 1 NOT NULL,
ident varchar(200) DEFAULT '',
logged int(11) DEFAULT 0 NOT NULL,
idle smallint DEFAULT 0 NOT NULL,
last_post int(11),
last_search int(11)
) TYPE=MyISAM;

CREATE TABLE posts (
id int(11) NOT NULL,
poster varchar(200) DEFAULT '',
poster_id int(11) DEFAULT 1 NOT NULL,
poster_ip varchar(39),
poster_email varchar(80),
message text,
hide_smilies smallint DEFAULT 0 NOT NULL,
posted int(11) DEFAULT 0 NOT NULL,
edited int(11),
edited_by varchar(200),
topic_id int(11) DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE reports (
id int(11) NOT NULL,
post_id int(11) DEFAULT 0 NOT NULL,
topic_id int(11) DEFAULT 0 NOT NULL,
forum_id int(11) DEFAULT 0 NOT NULL,
reported_by int(11) DEFAULT 0 NOT NULL,
created int(11) DEFAULT 0 NOT NULL,
message text,
zapped int(11),
zapped_by int(11)
) TYPE=MyISAM;

CREATE TABLE search_cache (
id int(11) DEFAULT 0 NOT NULL,
ident varchar(200) DEFAULT '',
search_data text
) TYPE=MyISAM;

CREATE TABLE search_matches (
post_id int(11) DEFAULT 0 NOT NULL,
word_id int(11) DEFAULT 0 NOT NULL,
subject_match smallint DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE search_words (
id int(11) NOT NULL,
word varchar(20) DEFAULT ''
) TYPE=MyISAM;

CREATE TABLE topic_subscriptions (
user_id int(11) DEFAULT 0 NOT NULL,
topic_id int(11) DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE topics (
id int(11) NOT NULL,
poster varchar(200) DEFAULT '',
subject varchar(255) DEFAULT '',
posted int(11) DEFAULT 0 NOT NULL,
first_post_id int(11) DEFAULT 0 NOT NULL,
last_post int(11) DEFAULT 0 NOT NULL,
last_post_id int(11) DEFAULT 0 NOT NULL,
last_poster varchar(200),
num_views int(11) DEFAULT 0 NOT NULL,
num_replies int(11) DEFAULT 0 NOT NULL,
closed smallint DEFAULT 0 NOT NULL,
sticky smallint DEFAULT 0 NOT NULL,
moved_to int(11),
forum_id int(11) DEFAULT 0 NOT NULL
) TYPE=MyISAM;

CREATE TABLE users (
id int(11) NOT NULL,
group_id int(11) DEFAULT 3 NOT NULL,
username varchar(200) DEFAULT '',
password varchar(40) DEFAULT '',
email varchar(80) DEFAULT '',
title varchar(50),
realname varchar(40),
url varchar(100),
jabber varchar(80),
icq varchar(12),
msn varchar(80),
aim varchar(30),
yahoo varchar(30),
location varchar(30),
signature text,
disp_topics smallint,
disp_posts smallint,
email_setting smallint DEFAULT 1 NOT NULL,
notify_with_post smallint DEFAULT 0 NOT NULL,
auto_notify smallint DEFAULT 0 NOT NULL,
show_smilies smallint DEFAULT 1 NOT NULL,
show_img smallint DEFAULT 1 NOT NULL,
show_img_sig smallint DEFAULT 1 NOT NULL,
show_avatars smallint DEFAULT 1 NOT NULL,
show_sig smallint DEFAULT 1 NOT NULL,
timezone real DEFAULT 0 NOT NULL,
dst smallint DEFAULT 0 NOT NULL,
time_format smallint DEFAULT 0 NOT NULL,
date_format smallint DEFAULT 0 NOT NULL,
language varchar(25) DEFAULT 'English',
style varchar(25) DEFAULT 'Air',
num_posts int(11) DEFAULT 0 NOT NULL,
last_post int(11),
last_search int(11),
last_email_sent int(11),
last_report_sent int(11),
registered int(11) DEFAULT 0 NOT NULL,
registration_ip varchar(39) DEFAULT '0.0.0.0',
last_visit int(11) DEFAULT 0 NOT NULL,
admin_note varchar(30),
activate_string varchar(80),
activate_key varchar(8)
) TYPE=MyISAM;

ALTER TABLE bans
ADD CONSTRAINT bans_pkey PRIMARY KEY (id);
ALTER TABLE categories
ADD CONSTRAINT categories_pkey PRIMARY KEY (id);
ALTER TABLE censoring
ADD CONSTRAINT censoring_pkey PRIMARY KEY (id);
ALTER TABLE config
ADD CONSTRAINT config_pkey PRIMARY KEY (conf_name);
ALTER TABLE forum_perms
ADD CONSTRAINT forum_perms_pkey PRIMARY KEY (group_id, forum_id);
ALTER TABLE forum_subscriptions
ADD CONSTRAINT forum_subscriptions_pkey PRIMARY KEY (user_id, forum_id);
ALTER TABLE forums
ADD CONSTRAINT forums_pkey PRIMARY KEY (id);
ALTER TABLE groups
ADD CONSTRAINT groups_pkey PRIMARY KEY (g_id);
ALTER TABLE posts
ADD CONSTRAINT posts_pkey PRIMARY KEY (id);
ALTER TABLE reports
ADD CONSTRAINT reports_pkey PRIMARY KEY (id);
ALTER TABLE search_cache
ADD CONSTRAINT search_cache_pkey PRIMARY KEY (id);
ALTER TABLE search_words
ADD CONSTRAINT search_words_pkey PRIMARY KEY (word);
ALTER TABLE topic_subscriptions
ADD CONSTRAINT topic_subscriptions_pkey PRIMARY KEY (user_id, topic_id);
ALTER TABLE topics
ADD CONSTRAINT topics_pkey PRIMARY KEY (id);
ALTER TABLE users
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
ALTER TABLE `bans` ADD INDEX ( username ) ;
ALTER TABLE `online` ADD INDEX ( ident ) ;
ALTER TABLE `online` ADD INDEX ( logged ) ;
ALTER TABLE `posts` ADD INDEX ( poster_id, topic_id ) ;
ALTER TABLE `posts` ADD INDEX ( topic_id ) ;
ALTER TABLE `reports` ADD INDEX ( zapped ) ;
ALTER TABLE `search_cache` ADD INDEX ( ident ) ;
ALTER TABLE `search_matches` ADD INDEX ( post_id ) ;
ALTER TABLE `search_matches` ADD INDEX ( word_id ) ;
ALTER TABLE `search_words` ADD INDEX ( id ) ;
ALTER TABLE `topics` ADD INDEX ( first_post_id ) ;
ALTER TABLE `topics` ADD INDEX ( forum_id ) ;
ALTER TABLE `topics` ADD INDEX ( last_post ) ;
ALTER TABLE `topics` ADD INDEX ( moved_to ) ;
ALTER TABLE `users` ADD INDEX ( registered ) ;
 
Status
Niet open voor verdere reacties.
                    Steun ons                    

Nieuwste berichten

Terug
Bovenaan Onderaan