CREATE TABLE IF NOT EXISTS `numerals` (
	`id`			INTEGER	UNSIGNED NOT NULL AUTO_INCREMENT,
	`numeric`		INTEGER	NOT NULL,
	`ident`			VARCHAR(90) DEFAULT NULL,
	`romanic`		VARCHAR(90) DEFAULT NULL,
	`binari`		VARCHAR(90) DEFAULT NULL,
	`hexadec`		VARCHAR(90) DEFAULT NULL,
	`catalan`		VARCHAR(90) DEFAULT NULL,
	`spanish`		VARCHAR(90) DEFAULT NULL,
	`english`		VARCHAR(90) DEFAULT NULL,
	`french`		VARCHAR(90) DEFAULT NULL,
	`german`		VARCHAR(90) DEFAULT NULL,
	`italian`		VARCHAR(90) DEFAULT NULL,
	`portuguese`	VARCHAR(90) DEFAULT NULL,
	`danish`		VARCHAR(90) DEFAULT NULL,
	`rowpos`		INTEGER	DEFAULT NULL,
	`flags`			INTEGER	UNSIGNED DEFAULT '0',
	`status`		TINYINT	DEFAULT '1',
	PRIMARY KEY  (`id`),
	UNIQUE KEY `ident` (`ident`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `grups` (
	`id`	INTEGER UNSIGNED
			NOT NULL
			AUTO_INCREMENT,
	`nom`		VARCHAR(90)	NOT NULL,
	`ident`		VARCHAR(90)	DEFAULT NULL,
	`status`	TINYINT(1)	DEFAULT '1',
	PRIMARY KEY (id),
	UNIQUE KEY `ident` (`ident`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `numerals_grups` (
	`numeral_id`	INTEGER UNSIGNED NOT NULL,
	`grup_id`		INTEGER UNSIGNED NOT NULL,
	KEY (`numeral_id`),
	KEY (`grup_id`),
	UNIQUE KEY idx_numerals_grups_pk (`numeral_id`, `grup_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;