diff options
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/db/schema.sql b/db/schema.sql index e6a3c4b8..940a3490 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -57,7 +57,7 @@ CREATE TABLE `accounts` ( `ticker` varchar(255) DEFAULT NULL, `precision` int(11) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=3729 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=3730 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -96,8 +96,9 @@ CREATE TABLE `invoices` ( `network` varchar(255) DEFAULT NULL, `unconfidential` varchar(255) DEFAULT NULL, `uuid` varchar(255) DEFAULT NULL, + `memo` text DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=4600 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=4626 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -141,8 +142,9 @@ CREATE TABLE `payments` ( `network` varchar(255) DEFAULT NULL, `account_id` int(11) DEFAULT NULL, `preimage` varchar(255) DEFAULT NULL, + `memo` text DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=4437 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=4458 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -202,4 +204,4 @@ CREATE TABLE `users` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-07-16 13:52:58 +-- Dump completed on 2020-07-17 20:55:55 |