From 081726a5517e98c4918a4659a7cbce17b34e843a Mon Sep 17 00:00:00 2001 From: amber Date: Mon, 29 Nov 2004 04:49:37 +0000 Subject: removed a USE that should not be there git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@410 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'sql-files/main.sql') diff --git a/sql-files/main.sql b/sql-files/main.sql index 8ebe8ffca..bf266d65a 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -451,7 +451,6 @@ CREATE TABLE `storage` ( KEY `account_id` (`account_id`) ) TYPE=MyISAM; -USE `ragnarok`; CREATE TABLE `friends` ( `id` int(11) NOT NULL auto_increment, `account_id` int(11) NOT NULL default '0', @@ -497,4 +496,4 @@ CREATE TABLE `friends` ( `name20` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) -) TYPE=MyISAM \ No newline at end of file +) TYPE=MyISAM -- cgit v1.2.3-70-g09d2 From e7411b3a65c8adc9a0b6d7a16a2e5affe65bde8a Mon Sep 17 00:00:00 2001 From: codemaster Date: Sun, 19 Dec 2004 03:14:38 +0000 Subject: Added a friend0 column git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@620 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'sql-files/main.sql') diff --git a/sql-files/main.sql b/sql-files/main.sql index bf266d65a..5d56eff7b 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -454,6 +454,8 @@ CREATE TABLE `storage` ( CREATE TABLE `friends` ( `id` int(11) NOT NULL auto_increment, `account_id` int(11) NOT NULL default '0', + `friend_id0` int(11) NOT NULL default '0', + `name0` varchar(255) NOT NULL default '', `friend_id1` int(11) NOT NULL default '0', `name1` varchar(255) NOT NULL default '', `friend_id2` int(11) NOT NULL default '0', -- cgit v1.2.3-70-g09d2 From 6cb7f24e8447fb5149f19bb8a04d902472b3bd4e Mon Sep 17 00:00:00 2001 From: "(no author)" <(no author)@54d463be-8e91-2dee-dedb-b68131a5f0ec> Date: Thu, 10 Feb 2005 20:28:32 +0000 Subject: Added a auto increment 'start' value in the main.sql file ^^[Sirius] git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1071 54d463be-8e91-2dee-dedb-b68131a5f0ec --- sql-files/main.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql-files/main.sql') diff --git a/sql-files/main.sql b/sql-files/main.sql index 5d56eff7b..49c9848c5 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -70,7 +70,7 @@ CREATE TABLE `char` ( PRIMARY KEY (`char_id`), KEY `party_id` (`party_id`), KEY `guild_id` (`guild_id`) -) TYPE=MyISAM; +) TYPE=MyISAM AUTO_INCREMENT=15000; # Database: Ragnarok # Table: 'charlog' -- cgit v1.2.3-70-g09d2