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 | |
| parent | 4a8abaa2722b629cebebb677249c3fd4f51292fb (diff) | |
| download | coinos-server-1962a6dcf1bb37bb8beb3fc4c0231d5a504a75fe.tar.gz coinos-server-1962a6dcf1bb37bb8beb3fc4c0231d5a504a75fe.zip | |
memos
Diffstat (limited to 'db')
| -rw-r--r-- | db/models/invoices.js | 9 | ||||
| -rw-r--r-- | db/models/payments.js | 9 | ||||
| -rw-r--r-- | db/schema.sql | 10 |
3 files changed, 24 insertions, 4 deletions
diff --git a/db/models/invoices.js b/db/models/invoices.js index 6fb68c31..231ed6f6 100644 --- a/db/models/invoices.js +++ b/db/models/invoices.js @@ -64,6 +64,15 @@ const attributes = { comment: null, field: "uuid" }, + memo: { + type: DataTypes.TEXT, + allowNull: true, + defaultValue: null, + primaryKey: false, + autoIncrement: false, + comment: null, + field: "memo" + }, network: { type: DataTypes.STRING(255), allowNull: true, diff --git a/db/models/payments.js b/db/models/payments.js index 51ef2550..f5d970bb 100644 --- a/db/models/payments.js +++ b/db/models/payments.js @@ -28,6 +28,15 @@ const attributes = { comment: null, field: "user_id" }, + memo: { + type: DataTypes.TEXT, + allowNull: true, + defaultValue: null, + primaryKey: false, + autoIncrement: false, + comment: null, + field: "memo" + }, hash: { type: DataTypes.TEXT, allowNull: true, 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 |