[BC3] Yapbb Mysql prob. - Serversoftware en clouddiensten

zaterdag 7 april 2001 18:08

Acties:

Verwijderd

Topicstarter

In de readme staat het volgende:

Next, you have to build the database which will be used. Open up the file
setup.sql for a list of the required queries and feed those queries to the
MySQL server. You can either use phpMyAdmin to do this the easy way, or do
it the oldfashioned way. Be sure to check the names of the tables in
''setup.sql'' and alter them appropriatly if needed.

Wat betekenen hier de queries?
oh, ik zal de setup.sql er bij geven dan begrijpt iedereen het.

CREATE TABLE avatar (id smallint(6) NOT NULL, url mediumtext NOT NULL, PRIMARY KEY (id), KEY id (id), UNIQUE id_2 (id));
CREATE TABLE bannedemail (id mediumint(9) NOT NULL auto_increment, host mediumtext NOT NULL, PRIMARY KEY (id), KEY id (id), UNIQUE id_2 (id));
CREATE TABLE category (ID mediumint(9) NOT NULL auto_increment, Description mediumtext NOT NULL, PRIMARY KEY (ID), KEY ID (ID), UNIQUE ID_2 (ID));
CREATE TABLE forum (id int(11) NOT NULL auto_increment, name mediumtext NOT NULL, description text NOT NULL, category int(11) NOT NULL, password tinyint(4) DEFAULT ''1'' NOT NULL, usehtml tinyint(4) DEFAULT ''1'' NOT NULL, useybb tinyint(4) DEFAULT ''1'' NOT NULL, PRIMARY KEY (id), KEY id (id), UNIQUE id_2 (id));
CREATE TABLE ipban (id bigint(20) NOT NULL auto_increment, ip mediumtext NOT NULL, PRIMARY KEY (id), KEY id (id), UNIQUE id_2 (id));
CREATE TABLE moderator (forumid bigint(20) NOT NULL, userid bigint(20) NOT NULL);
CREATE TABLE post (id tinyint(4) NOT NULL auto_increment, text longtext NOT NULL, topicid bigint(20) NOT NULL, posterid bigint(20) NOT NULL, date bigint(20) NOT NULL, ip mediumtext NOT NULL, iconid tinyint(4) NOT NULL, editorid bigint(20) NOT NULL, editdate bigint(20) NOT NULL, reactionto bigint(20) NOT NULL, PRIMARY KEY (id), KEY id (id), UNIQUE id_2 (id));
CREATE TABLE status (id int(11) NOT NULL auto_increment, description mediumtext NOT NULL, requirements bigint(20) NOT NULL, PRIMARY KEY (id), KEY id (id), UNIQUE id_2 (id));
CREATE TABLE subscription (userid bigint(20) NOT NULL, topicid bigint(20) NOT NULL, PRIMARY KEY (userid, topicid));
CREATE TABLE topic (id bigint(20) NOT NULL auto_increment, description mediumtext NOT NULL, postid bigint(20) NOT NULL, views bigint(20) NOT NULL, active tinyint(4) DEFAULT ''1'' NOT NULL, forumid bigint(20) NOT NULL, lastpostid bigint(20) NOT NULL, PRIMARY KEY (id), KEY id (id), UNIQUE id_2 (id));
CREATE TABLE user (id int(11) NOT NULL auto_increment, nickname mediumtext NOT NULL, password mediumtext NOT NULL, icq bigint(20) NOT NULL, email mediumtext NOT NULL, showemail tinyint(4) DEFAULT ''1'' NOT NULL, homepage mediumtext NOT NULL, wherefrom text NOT NULL, bio text NOT NULL, registerdate bigint(20) NOT NULL, posts bigint(20) NOT NULL, active tinyint(4) DEFAULT ''1'' NOT NULL, notes text NOT NULL, signature text NOT NULL, avatarid tinyint(4) NOT NULL, groupid tinyint(4) DEFAULT ''1'' NOT NULL, displayprofile tinyint(4) DEFAULT ''1'' NOT NULL, PRIMARY KEY (id), KEY id (id), UNIQUE id_2 (id));
CREATE TABLE useronline (userid bigint(20) NOT NULL, date bigint(20) NOT NULL);

INSERT INTO status VALUES (''1'',''Junior member'', ''0'');
INSERT INTO status VALUES (''2'',''Member'', ''100'');
INSERT INTO status VALUES (''3'',''Senior member'', ''1000'');
INSERT INTO status VALUES (''4'',''Very senior member'', ''10000'');
INSERT INTO status VALUES (''5'',''Spammer'', ''-999999'');
INSERT INTO avatar VALUES (''1'',''jester.jpg'');
INSERT INTO user VALUES (''1'', ''Admin23'', ''00000000'', ''0'', ''root@localhost'', ''0'', ''http://localhost'', ''World Wide Web'', ''The #1 admin of this board'', ''0'', ''0'', ''1'', '''', '''', ''0'', ''3'', ''1'');
INSERT INTO bannedemail VALUES ( ''1'', ''excite.com'');
INSERT INTO bannedemail VALUES ( ''2'', ''hotmail.com'');
INSERT INTO bannedemail VALUES ( ''3'', ''yahoo.com'');