Web Wiz Forums - to MySql

to MySql

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15414
Printed Date: 13 April 2026 at 1:47pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: to MySql

Posted By: wang
Subject: to MySql
Date Posted: 09 June 2005 at 11:57pm

does anyone have txt file to create this tables in MySql?

-------------
I am a Robot.
http://www.irishmilk.com - my hobby is to create human.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 10 June 2005 at 3:43am

The present version will not work with mySQL as mySQL doesn't fully support ADO and the SQL used for mySQL is different to that used in Access or SQL Server

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: wang
Date Posted: 13 June 2005 at 4:54am

following is the sql for MySql:

because read is reserved word, i have to change read to reads in table tblpermission and tblforum.

the forum is works with mysql, but some sql string need to be changed inside the programe. i am not good at sql, if anyone done, please give a grant instruction.

-----------------------------------------------------------

SET FOREIGN_KEY_CHECKS=0;

use test;

CREATE TABLE tblconfiguration (
website_name varchar(50) NOT NULL default '',
forum_name varchar(50) default NULL,
forum_path varchar(70) default NULL,
website_path varchar(70) default NULL,
forum_email_address varchar(50) default NULL,
email_notify tinyint(4) default NULL,
mail_component varchar(10) default NULL,
mail_server varchar(60) default NULL,
IE_editor tinyint(4) default NULL,
L_code tinyint(4) default NULL,
Topics_per_page int(11) default NULL,
Title_image varchar(70) default NULL,
Text_link tinyint(4) default NULL,
Emoticons tinyint(4) default NULL,
Avatar tinyint(4) default NULL,
Email_activate tinyint(4) default NULL,
Email_post tinyint(4) default NULL,
Hot_views int(11) default NULL,
Hot_replies int(11) default NULL,
Private_msg tinyint(4) default NULL,
No_of_priavte_msg int(11) default NULL,
Threads_per_page int(11) default NULL,
Spam_seconds int(11) default NULL,
Spam_minutes int(11) default NULL,
Vote_choices int(11) default NULL,
Email_sys tinyint(4) default NULL,
Upload_img_path varchar(50) default NULL,
Upload_img_types varchar(50) default NULL,
Upload_img_size int(11) default NULL,
Upload_files_path varchar(50) default NULL,
Upload_files_type varchar(50) default NULL,
Upload_files_size int(11) default NULL,
Upload_avatar tinyint(4) default NULL,
Upload_avatar_path varchar(50) default NULL,
Upload_avatar_types varchar(50) default NULL,
Upload_avatar_size int(11) default NULL,
Upload_component varchar(10) default NULL,
Active_users tinyint(4) default NULL,
Forums_closed tinyint(4) default NULL,
Show_edit tinyint(4) default NULL,
Process_time tinyint(4) default NULL,
Flash tinyint(4) default NULL,
Show_mod tinyint(4) default NULL,
Reg_closed tinyint(4) default NULL,
PRIMARY KEY (website_name)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into tblconfiguration values
('My Website', 'Web Wiz Forums', 'http://www.myweb.coo/forum', 'http://www.webwizforums.com',
mailto:forum@myweb.coo - 'forum@myweb.coo' , 1, 'CDONTS', '', 1, 1, 12, 'forum_images/web_wiz_forums.gif', 1, 1, 1, 0, 1, 40, 10, 1, 25, 10, 15, 9, 6, 1, 'uploads', 'jpg;jpeg;gif;png', 35,
'uploads', 'zip;rar', 500, 1, 'uploads', 'jpg;jpeg;gif;png', 15, 'AspUpload', 1, 0, 1, 1, 0, 0, 0);

CREATE TABLE tblauthor (
Author_ID int(11) NOT NULL default '0',
Group_ID int(11) default NULL,
Username varchar(30) default NULL,
Real_name varchar(40) default NULL,
User_code varchar(50) default NULL,
Password varchar(50) default NULL,
Salt varchar(30) default NULL,
Author_email varchar(75) default NULL,
Show_email tinyint(4) default NULL,
Homepage varchar(50) default NULL,
Location varchar(60) default NULL,
MSN varchar(75) default NULL,
Yahoo varchar(75) default NULL,
ICQ varchar(20) default NULL,
AIM varchar(75) default NULL,
Occupation varchar(60) default NULL,
Interests varchar(160) default NULL,
DOB datetime default NULL,
Signature longtext,
Attach_signature tinyint(4) default NULL,
No_of_posts int(11) default NULL,
Join_date datetime default NULL,
Active tinyint(4) default NULL,
Avatar varchar(100) default NULL,
Avatar_title varchar(70) default NULL,
Last_visit datetime default NULL,
Time_offset char(1) default NULL,
Time_offset_hours int(11) default NULL,
Date_format varchar(10) default NULL,
Rich_editor tinyint(4) default NULL,
Reply_notify tinyint(4) default NULL,
PM_notify tinyint(4) default NULL,
PRIMARY KEY (Author_ID),
KEY fi0 (Group_ID),
CONSTRAINT tblauthor_ibfk_1 FOREIGN KEY (Group_ID) REFERENCES tblgroup (Group_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into tblauthor values
(1, 1, 'administrator', null, 'administrator2FC73499BAC5A41', 'A85B3E67CFA695D711570FB9822C0CF82871903B', '72964E7', null, 0, null, null, null, null, null,
null, null, null, null, null, 0, 0, '2003-10-01 19:55:43', 1, null, null, '2003-02-08 15:06:43', '+', 0, 'dd/mm/yy', 1, 0, 0),
(2, 2, 'Guests', null, 'Guest48CEE9Z2849AE95A6', '6734DDD7A6A6C9F4D34945B0C9CF9677F3221EC9', 'E4AC',
null, 0, null, null, null, null, null, null, null, null, null, null, 0, 0, '2003-10-01 15:24:22', 1, null, null, '2003-01-25 15:24:22', '+', 0, 'dd/mm/yy', 1, 0, 0);

CREATE TABLE tblbanlist (
Ban_ID int(11) NOT NULL default '0',
IP varchar(30) default NULL,
Email varchar(60) default NULL,
PRIMARY KEY (Ban_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE tblbuddylist (
Address_ID int(11) NOT NULL default '0',
Author_ID int(11) default NULL,
Buddy_ID int(11) default NULL,
Description varchar(35) default NULL,
Block tinyint(4) default NULL,
PRIMARY KEY (Address_ID),
KEY fi0 (Buddy_ID),
CONSTRAINT tblbuddylist_ibfk_1 FOREIGN KEY (Buddy_ID) REFERENCES tblauthor (Author_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE tblcategory (
Cat_ID int(11) NOT NULL default '0',
Cat_name varchar(51) default NULL,
Cat_order int(11) default NULL,
PRIMARY KEY (Cat_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE tbldatetimeformat (
Date_format varchar(10) NOT NULL default '',
Year_format varchar(6) default NULL,
Seporator varchar(15) default NULL,
Month1 varchar(15) default NULL,
Month2 varchar(15) default NULL,
Month3 varchar(15) default NULL,
Month4 varchar(15) default NULL,
Month5 varchar(15) default NULL,
Month6 varchar(15) default NULL,
Month7 varchar(15) default NULL,
Month8 varchar(15) default NULL,
Month9 varchar(15) default NULL,
Month10 varchar(15) default NULL,
Month11 varchar(15) default NULL,
Month12 varchar(15) default NULL,
Time_format int(11) default NULL,
am varchar(6) default NULL,
pm varchar(6) default NULL,
PRIMARY KEY (Date_format)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into tbldatetimeformat values
('dd/mm/yy', 'long', '?', 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December', 12, 'am', 'pm');

CREATE TABLE tblemailnotify (
Watch_ID int(11) NOT NULL default '0',
Author_ID int(11) default NULL,
Forum_ID int(11) default NULL,
Topic_ID int(11) default NULL,
PRIMARY KEY (Watch_ID),
KEY fi0 (Autho

-------------
I am a Robot.
http://www.irishmilk.com - my hobby is to create human.

Posted By: DoltHeadRapper
Date Posted: 13 June 2005 at 9:43am

-boRg- wrote:

The present version will not work with mySQL as mySQL doesn't fully support ADO and the SQL used for mySQL is different to that used in Access or SQL Server

Do you ever plan to make a version that will run on MySQL right out of the box?

Posted By: dj air
Date Posted: 13 June 2005 at 11:05am

please read the thread within the suggestions forum.

it was discussed ages ago and he said no,

then recently with MySQL developments it maybe possible, but if there is ever lickly to be it will be a long time yet, as he want s to finish V8, and he has other commitments.

so you are talking months maybe a year year and a half.. no reall time frame if any.

Posted By: JJLatWebWiz
Date Posted: 28 July 2005 at 5:26pm

I spent some time converting WWF 7.01 to run on MySQL. It's not a simple process. WWF makes extensive use of recordset pages, which of course MySQL does not support. Simulating the functionality for MySQL is fairly easy, but it has to be applied to almost every file, which means once you're done, all future patches and upgrades will require the same work. I did it though because I needed better performance than Access and didn't want to pay the premium for a host with MS SQL.

Good luck.