Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 8ea5197b09
Fetching contributors…

Cannot retrieve contributors at this time

15 lines (15 sloc) 0.514 kb
CREATE TABLE IF NOT EXISTS %snames (
`name_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(64) NOT NULL,
`gender` CHAR(1) NOT NULL DEFAULT 'B' COMMENT 'M for Male, F for Female, B for Both',
`isfirst` BOOL NOT NULL DEFAULT '1' COMMENT 'True for first name, false for last name',
`era_id` INT NOT NULL COMMENT 'Reference to applicable era',
`deleted_dt` TIMESTAMP NULL DEFAULT NULL,
INDEX (
`gender`,
`isfirst`,
`era_id`
)
)
ENGINE = MyISAM
COMMENT = 'First and last names for characters';
Jump to Line
Something went wrong with that request. Please try again.