| MirandaLK |
07-28-2010 02:12 PM |
Need help with MySQL Database
I don't understand any of this and my moderator won't help me cos he doesn't know either -_-
someone please help me :( What do I do?
I don't know what goes where..
Quote:
CREATE TABLE adopts_content (page varchar(20), title varchar(75), date varchar(15), content varchar(15000), level varchar(50));
INSERT INTO adopts_content (page, title, date, content, level) VALUES ('index', 'This is the index page', 'Jan-10-1999', 'This is a sample article. All of this text you can change in the script admin control panel.','');
INSERT INTO adopts_content (page, title, date, content, level) VALUES ('tos', 'This is the Terms of Service Page', 'Jan-10-1999', 'Put your terms of service here. All of this text you can change in the script admin control panel.','');
CREATE TABLE adopts_settings (name varchar(20), value varchar(350));
INSERT INTO adopts_settings (name, value) VALUES ('themeurl', 'templates/default/template.html');
INSERT INTO adopts_settings (name, value) VALUES ('browsertitle', 'This is the site title as pulled from the DB');
INSERT INTO adopts_settings (name, value) VALUES ('sitename', 'Your site name goes here.');
INSERT INTO adopts_settings (name, value) VALUES ('admincontact', 'any@email.com');
INSERT INTO adopts_settings (name, value) VALUES ('slogan', 'Test Slogan');
INSERT INTO adopts_settings (name, value) VALUES ('gdimages', 'yes');
INSERT INTO adopts_settings (name, value) VALUES ('usealtbbcode', 'yes');
INSERT INTO adopts_settings (name, value) VALUES ('systememail', 'any@email.com');
CREATE TABLE adopts_users (uid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, username varchar(20) UNIQUE, password varchar(100), email varchar(60), usergroup INT, newmessagenotify varchar(10), membersince varchar(20), isbanned INT, website varchar(80), profilepic varchar(80), aim varchar(80), yahoo varchar(80), msn varchar(80));
CREATE TABLE adopts_groups (gid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, groupname varchar(20) UNIQUE, canadopt varchar(10), canpm varchar(10), cancp varchar(10), canmanageadopts varchar(10), canmanagecontent varchar(10), canmanageads varchar(10), canmanagesettings varchar(10), canmanageusers varchar(10));
INSERT INTO adopts_groups VALUES ('', 'rootadmins', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes');
INSERT INTO adopts_groups VALUES ('', 'admins', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes');
INSERT INTO adopts_groups VALUES ('', 'registered', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 'no');
INSERT INTO adopts_groups VALUES ('', 'artists', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'no');
CREATE TABLE adopts_owned_adoptables (aid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, type varchar(40), name varchar(40), owner varchar(40), currentlevel INT, totalclicks INT, code INT, imageurl varchar(120), usealternates varchar(10), tradestatus varchar(15), isfrozen varchar(10));
CREATE TABLE adopts_adoptables (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, type varchar(40), description varchar(300), eggimage varchar(120), whenisavail varchar(50), promocode varchar(50), freqcond varchar(50), number INT, datecond varchar(50), date varchar(20), adoptscond varchar(20), moreless varchar(20), morelessnum INT, levelgrle varchar(25), grlelevel INT, alternates varchar(10), altoutlevel INT, altchance INT);
CREATE TABLE adopts_levels (adoptiename varchar(50), thisislevel INT, requiredclicks INT, primaryimage varchar(120), alternateimage varchar(120), rewarduser varchar(10), promocode varchar(25));
CREATE TABLE adopts_vote_voters (date varchar(30), username varchar(50), ip varchar(50), adoptableid int(10));
CREATE TABLE adopts_filesmap (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, serverpath varchar(150), wwwpath varchar(200), friendlyname varchar(50));
CREATE TABLE adopts_acp_hooks (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, linktext varchar(150), linkurl varchar(200), pluginname varchar(50), pluginstatus INT);
CREATE TABLE adopts_themes (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, themename varchar(150), themeurl varchar(200));
INSERT INTO adopts_themes VALUES ('', 'Default', 'templates/default/template.html');
CREATE TABLE adopts_links (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, linktext varchar(150), linkurl varchar(200));
INSERT INTO adopts_links VALUES ('', 'Home', 'index.php');
INSERT INTO adopts_links VALUES ('', 'Adopt', 'adopt.php');
INSERT INTO adopts_links VALUES ('', 'My Adopts', 'myadopts.php');
INSERT INTO adopts_links VALUES ('', 'My Account', 'account.php');
INSERT INTO adopts_links VALUES ('', 'Message Center', 'messages.php');
INSERT INTO adopts_links VALUES ('', 'Top 10', 'stats.php');
CREATE TABLE adopts_ads (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, adname varchar(50), text varchar(1650), page varchar(50), impressions INT, actualimpressions INT, date varchar(50), status varchar(15), user varchar(45), extra varchar(100));
CREATE TABLE adopts_messages (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, fromuser varchar(50), touser varchar(1650), status varchar(20), datesent varchar(25), messagetitle varchar(100), messagetext varchar(2500));
CREATE TABLE adopts_passwordresets (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, username varchar(20), email varchar(50), code varchar(70), ip varchar(30), date varchar(20));
|
|
