CREATE TABLE IF NOT EXISTS `transaccions` (
	`id`		int(11) NOT NULL AUTO_INCREMENT,
	`token`		varchar(32) NOT NULL,
	`email`		varchar(90) NOT NULL,
	`concepte`	varchar(255) NOT NULL,
	`import`		float DEFAULT '0',
	`autoritzat`	int(1) DEFAULT '0',
	`cautorit`		varchar(50),
	`contracte`		varchar(50),
	`operacio`		varchar(12),
	`codiauth`		varchar(50),
	`resposta`		varchar(255),
	`callback`		varchar(90),
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`),
	KEY `transaccions_token_idx` (`token`),
	KEY `transaccions_operacio_idx` (`operacio`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8;

CREATE TABLE IF NOT EXISTS `userdata` (
	`transaccio_id`	int(11) NOT NULL,
	`token`		varchar(40) NOT NULL,
	`created`	datetime,
	`userdata`	text,
	KEY `userdata_transaccio_id_idx` (`transaccio_id`),
	KEY `userdata_token_idx` (`token`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8;

CREATE TABLE IF NOT EXISTS `missatges` (
	`id`		int(11) NOT NULL AUTO_INCREMENT,
	`transaccio_id`	int(11),
	`datahora`	datetime,
	`origen`	varchar(90),
	`token`		varchar(32),
	`missatge`	text,
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`),
	KEY `missatges_transaccio_id_idx` (`transaccio_id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8;

CREATE TABLE IF NOT EXISTS `pagaments` (
	`id`	int(11) NOT NULL AUTO_INCREMENT,
	`nom`		varchar(255),
	`email`		varchar(90),
	`operacio`	varchar(12),
	`import`	decimal(9, 2),
	`status`	varchar(1)	DEFAULT 'T',
	`token`		varchar(32),
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8;

CREATE TABLE IF NOT EXISTS `percobrar` (
	`id`		int(11) NOT NULL AUTO_INCREMENT,
	`numfra`	varchar(90) NOT NULL,
	`nomdeutor`	varchar(255) NOT NULL,
	`import`	DECIMAL (9, 2),
	`cautorit`	varchar(50),
	`operacio`	varchar(20),
	`status`	varchar(1),
	PRIMARY KEY (`id`),
	UNIQUE KEY `id` (`id`),
	KEY `percobrar_numfra_idx` (`numfra`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8;

CREATE TABLE IF NOT EXISTS `percobrar_transacions` (
	`percobrar_id`	int(11),
	`transaccio_id`	int(11),
	KEY `percobrar_transacions_percobrar_idx` (`percobrar_id`),
	KEY `percobrar_transacions_transaccio_idx` (`transaccio_id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8;

CREATE TABLE IF NOT EXISTS `percobrar_pagaments` (
	`percobrar_id`	int(11),
	`pagament_id`	int(11),
	KEY `percobrar_pagaments_percobrar_idx` (`percobrar_id`),
	KEY `percobrar_pagaments_pagament_idx` (`pagament_id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8;