Since my provider doesnt want to response any of my message i decided to ask help here. Im not even sure if im in the correct section. Well this is about adding sql query to add tables. On my test server i can do it with no problem because i know how to use mysql workbench. But this is different. I might messed up my database. Because my server is already live. I dont wanna risk it. Can anyone help me?
Well this is my problem.
I want to add this line.
Spoiler
create table pvpladder (
char_id int(11) not null default '0' primary key,
name varchar(30) not null default '',
streaks smallint(6) unsigned not null default '0',
kills smallint(6) unsigned not null default '0',
deaths smallint(6) unsigned not null default '0',
streaktime datetime
) engine = myisam;
create table ownladder (
guild_id int(11) not null default '0' primary key,
name varchar(24) not null default '',
currentown smallint(6) unsigned not null default '0',
highestown smallint(6) unsigned not null default '0',
owntime datetime
) engine = myisam;
like i said using mysql workbench i can double lick the rathena schema and add a query with no problem.
This is the screenshot of my vps's phpMyAdmin (I dont know what to call it)
Can anybody guide me? The one i encircled is the schema required to use the script to make tables. Somebody? I thankyou bigtime in advance!
Question
Gidz Cross
Since my provider doesnt want to response any of my message i decided to ask help here. Im not even sure if im in the correct section. Well this is about adding sql query to add tables. On my test server i can do it with no problem because i know how to use mysql workbench. But this is different. I might messed up my database. Because my server is already live. I dont wanna risk it. Can anyone help me?
Well this is my problem.
I want to add this line.
create table pvpladder ( char_id int(11) not null default '0' primary key, name varchar(30) not null default '', streaks smallint(6) unsigned not null default '0', kills smallint(6) unsigned not null default '0', deaths smallint(6) unsigned not null default '0', streaktime datetime ) engine = myisam; create table ownladder ( guild_id int(11) not null default '0' primary key, name varchar(24) not null default '', currentown smallint(6) unsigned not null default '0', highestown smallint(6) unsigned not null default '0', owntime datetime ) engine = myisam;
like i said using mysql workbench i can double lick the rathena schema and add a query with no problem.
This is the screenshot of my vps's phpMyAdmin (I dont know what to call it)
Can anybody guide me? The one i encircled is the schema required to use the script to make tables. Somebody? I thankyou bigtime in advance!
Edited by gidzdlcrzLink to comment
Share on other sites
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.