diff options
| author | wizputer <wizputer@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2004-12-10 06:00:44 +0000 |
|---|---|---|
| committer | wizputer <wizputer@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2004-12-10 06:00:44 +0000 |
| commit | f7ca47e0e6c972cd826a2bba6380434ae61ce737 (patch) | |
| tree | f5833ff557a0625d2d884cab58fec8fcaacad8fd /sql-files/main-new.sql | |
| parent | cdda13efae3c824a1d84eaf3a02382c83d09f1df (diff) | |
| download | hercules-f7ca47e0e6c972cd826a2bba6380434ae61ce737.tar.gz hercules-f7ca47e0e6c972cd826a2bba6380434ae61ce737.tar.bz2 hercules-f7ca47e0e6c972cd826a2bba6380434ae61ce737.tar.xz hercules-f7ca47e0e6c972cd826a2bba6380434ae61ce737.zip | |
* char-server -UNTESTED- [Wizputer]
* new method for getting GMs [Wizputer]
* Added unique key for Char names [Wizputer]
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@529 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/main-new.sql')
| -rw-r--r-- | sql-files/main-new.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql-files/main-new.sql b/sql-files/main-new.sql index 5f8c2a145..c0293755a 100644 --- a/sql-files/main-new.sql +++ b/sql-files/main-new.sql @@ -187,9 +187,10 @@ CREATE TABLE `char` ( KEY (`partner_id`),
KEY (`party_id`),
KEY (`guild_id`),
+ UNIQUE (`name`),
FOREIGN KEY (`account_id`) REFERENCES `login` (`account_id`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`partner_id`) REFERENCES `char` (`char_id`) ON DELETE SET NULL
-) TYPE=INNODB AUTO_INCREMENT=150001;
+) TYPE=INNODB AUTO_INCREMENT=150000;
CREATE TABLE `friend` (
`char_id` mediumint(6) UNSIGNED NOT NULL default '0',
|