summaryrefslogtreecommitdiff
path: root/hercules/templates/party.sql
blob: 0beb4391dcbb96aa59d5d89410ebc65c87dc2c49 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
DROP TABLE IF EXISTS `party`;

CREATE TABLE IF NOT EXISTS `party` (
  `party_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(24) NOT NULL DEFAULT '',
  `exp` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
  `item` TINYINT(11) UNSIGNED NOT NULL DEFAULT '0',
  `leader_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `leader_char` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`party_id`)
) ENGINE=InnoDB;