From 081726a5517e98c4918a4659a7cbce17b34e843a Mon Sep 17 00:00:00 2001
From: amber <amber@54d463be-8e91-2dee-dedb-b68131a5f0ec>
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 <codemaster@54d463be-8e91-2dee-dedb-b68131a5f0ec>
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

