Czy jest jakiś program, do którego wrzucę kod tabel bazy i wygeneruje mi model relacyjny??
Oto kod:
CREATE TABLE forum_access_levels (
access_lvl tinyint(4) NOT NULL auto_increment,
access_name varchar(50) NOT NULL default '',
PRIMARY KEY (access_lvl)
);
CREATE TABLE forum_admin (
id int(11) NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
value varchar(255) NOT NULL default '',
constant varchar(100) NOT NULL default '',
PRIMARY KEY (id)
);
CREATE TABLE IF NOT EXISTS forum_bbcode (
id int(11) NOT NULL auto_increment,
template varchar(255) NOT NULL default '',
replacement varchar(255) NOT NULL default '',
PRIMARY KEY (id)
);
CREATE TABLE forum_forum (
id int(11) NOT NULL auto_increment,
forum_name varchar(100) NOT NULL default '',
forum_desc varchar(255) NOT NULL default '',
forum_moderator int(11) NOT NULL default '0',
PRIMARY KEY (id)
);
CREATE TABLE forum_postcount (
user_id int(11) NOT NULL default '0',
count int(9) NOT NULL default '0',
PRIMARY KEY (user_id)
);
CREATE TABLE forum_posts (
id int(11) NOT NULL auto_increment,
topic_id int(11) NOT NULL default '0',
forum_id int(11) NOT NULL default '0',
author_id int(11) NOT NULL default '0',
update_id int(11) NOT NULL default '0',
date_posted datetime NOT NULL default '0000-00-00 00:00:00',
date_updated datetime NOT NULL default '0000-00-00 00:00:00',
subject varchar(255) NOT NULL default '',
body mediumtext NOT NULL,
PRIMARY KEY (id),
KEY IdxArticle (forum_id,topic_id,author_id,date_posted),
FULLTEXT KEY IdxText (subject,body)
);
CREATE TABLE forum_users (
id int(11) NOT NULL auto_increment,
email varchar(255) NOT NULL default '',
passwd varchar(50) NOT NULL default '',
name varchar(100) NOT NULL default '',
access_lvl tinyint(4) NOT NULL default '1',
signature varchar(255) NOT NULL default '',
date_joined datetime NOT NULL default '0000-00-00 00:00:00',
last_login datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id),
UNIQUE KEY uniq_email (email)
);