diff options
| author | Adam Soltys <[email protected]> | 2020-07-17 20:55:47 -0700 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2020-07-17 20:55:59 -0700 |
| commit | 1962a6dcf1bb37bb8beb3fc4c0231d5a504a75fe (patch) | |
| tree | 46ffa53e3f7ebbdb2ea9c9abd1cf64405e1410cd /db/schema.sql | |
| parent | 4a8abaa2722b629cebebb677249c3fd4f51292fb (diff) | |
| download | coinos-server-1962a6dcf1bb37bb8beb3fc4c0231d5a504a75fe.tar.gz coinos-server-1962a6dcf1bb37bb8beb3fc4c0231d5a504a75fe.zip | |
memos
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 |