SQL

CREATE TABLE IF NOT EXISTS `bit_crypto_coins` (
  `coinname` varchar(50) DEFAULT NULL,
  `amount` double DEFAULT NULL
);

INSERT INTO `bit_crypto_coins` (`coinname`, `amount`) VALUES
	('Bitcoin', 1.0),
	('Ethereum', 1.0),
	('Ripple', 1.0);

CREATE TABLE IF NOT EXISTS `bit_crypto_useraccount` (
  `useridentifier` varchar(50) DEFAULT NULL,
  `avatar` int(50) DEFAULT NULL,
  `notifications` int(10) DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS `bit_crypto_users` (
  `useridentifier` varchar(50) NOT NULL,
  `coinname` varchar(50) NOT NULL,
  `inverted` int(11) NOT NULL DEFAULT 0,
  `paid` int(100) NOT NULL
);