diff options
| author | Adam Soltys <[email protected]> | 2020-09-18 11:53:49 -0700 |
|---|---|---|
| committer | Adam Soltys <[email protected]> | 2020-09-18 11:53:59 -0700 |
| commit | ae48f3881cd6bf300c629d3332b2b72561e8e632 (patch) | |
| tree | 7816ab238d6b001da7d35ba13146812cb88803b0 /db/schema.sql | |
| parent | 3d2a86d67471b093debcaf0bdd68dd185561776c (diff) | |
| download | coinos-server-ae48f3881cd6bf300c629d3332b2b72561e8e632.tar.gz coinos-server-ae48f3881cd6bf300c629d3332b2b72561e8e632.zip | |
don't allow null tips
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/db/schema.sql b/db/schema.sql index 82248e1d..5299ba29 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -65,7 +65,7 @@ CREATE TABLE `accounts` ( `path` varchar(255) DEFAULT NULL, `network` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=4030 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=4037 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -100,7 +100,7 @@ CREATE TABLE `invoices` ( `address` varchar(255) DEFAULT NULL, `received` double DEFAULT NULL, `amount` double DEFAULT NULL, - `tip` double DEFAULT NULL, + `tip` double NOT NULL DEFAULT 0, `network` varchar(255) DEFAULT NULL, `unconfidential` varchar(255) DEFAULT NULL, `uuid` varchar(255) DEFAULT NULL, @@ -108,7 +108,7 @@ CREATE TABLE `invoices` ( `account_id` int(11) DEFAULT NULL, `path` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=6191 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=6264 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -125,7 +125,7 @@ CREATE TABLE `linkingkeys` ( `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=4583 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=4587 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -157,7 +157,7 @@ CREATE TABLE `payments` ( `redeemed` tinyint(1) NOT NULL DEFAULT 0, `path` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=5488 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=5511 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -226,7 +226,7 @@ CREATE TABLE `users` ( `index` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `ip` (`ip`) -) ENGINE=InnoDB AUTO_INCREMENT=712 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=715 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; @@ -238,4 +238,4 @@ CREATE TABLE `users` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-09-16 23:05:04 +-- Dump completed on 2020-09-18 11:53:57 |