diff options
| author | Adam Soltys <[email protected]> | 2022-10-08 06:29:24 +0000 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2022-10-08 06:29:24 +0000 |
| commit | 6a7b6678f4a1cc562a6c1d82414ed28a91ba4574 (patch) | |
| tree | be5341f1c2da4cce59b8d74fe3ab3adead0cded7 /db | |
| parent | c8ad07959fe5437064dbcc61bc12b4e52103fff7 (diff) | |
| download | coinos-server-6a7b6678f4a1cc562a6c1d82414ed28a91ba4574.tar.gz coinos-server-6a7b6678f4a1cc562a6c1d82414ed28a91ba4574.zip | |
schema
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema.sql | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/db/schema.sql b/db/schema.sql index 22dfcd54..4f7e9b7d 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -70,7 +70,7 @@ CREATE TABLE `accounts` ( `lightning_credits` double NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `asset` (`asset`) -) ENGINE=InnoDB AUTO_INCREMENT=38821 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=38966 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -136,7 +136,7 @@ CREATE TABLE `invoices` ( `rate` double DEFAULT NULL, `currency` varchar(255) NOT NULL, `address` varchar(255) DEFAULT NULL, - `received` double DEFAULT NULL, + `received` bigint(20) DEFAULT NULL, `amount` double DEFAULT NULL, `tip` double DEFAULT NULL, `network` varchar(255) DEFAULT NULL, @@ -147,6 +147,7 @@ CREATE TABLE `invoices` ( `path` varchar(255) DEFAULT NULL, `webhook` text DEFAULT NULL, `status` varchar(255) DEFAULT 'unpaid', + `prompt` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `part_of_unconfidential` (`unconfidential`(10)), KEY `text_index` (`text`(100)), @@ -156,7 +157,7 @@ CREATE TABLE `invoices` ( KEY `invoices_account_id_foreign` (`account_id`), KEY `invoices_time_index` (`createdAt`), KEY `uuid` (`uuid`(10)) -) ENGINE=InnoDB AUTO_INCREMENT=371007 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=372769 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -173,7 +174,7 @@ CREATE TABLE `linkingkeys` ( `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=26671 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=26721 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -304,7 +305,7 @@ CREATE TABLE `payments` ( KEY `payments_time_index` (`createdAt`), KEY `hash` (`hash`(10)), CONSTRAINT `fk_account_id` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=206858 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=208429 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -508,10 +509,11 @@ CREATE TABLE `users` ( `profile` tinyint(1) DEFAULT 0, `banner` tinyint(1) DEFAULT 0, `theme` varchar(255) DEFAULT NULL, + `uuid` varchar(255) NOT NULL DEFAULT uuid(), PRIMARY KEY (`id`), KEY `ip` (`ip`), KEY `username` (`username`) -) ENGINE=InnoDB AUTO_INCREMENT=29734 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=29850 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -570,4 +572,4 @@ CREATE TABLE `withdrawals` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2022-09-24 16:23:35 +-- Dump completed on 2022-10-08 6:29:13 |