diff options
author | Chaoyi Zha <summermontreal@gmail.com> | 2015-10-18 18:08:32 +0300 |
---|---|---|
committer | Chaoyi Zha <summermontreal@gmail.com> | 2015-10-18 18:08:32 +0300 |
commit | b48ff99a6dcd093b8d10f2dcda9376edc604faaf (patch) | |
tree | 3fbbd7742793e6e701843f874fbdbac661cc8f00 | |
parent | 9d2a333e654ca8d4efd068dc2da29871db5b04b5 (diff) |
Use int rather than smallint to stop overflow
smallint overflows at 2^15-1 (32,767)
int overflows at 2^31-1 (2,147,483,647)
-rw-r--r-- | setup.php | 4 |
1 files changed, 2 insertions, 2 deletions
@@ -218,7 +218,7 @@ PHP; sqlrun(' CREATE TABLE `redirinfo` ( `rurl` text NOT NULL, - `rid` smallint(200) NOT NULL AUTO_INCREMENT, + `rid` int(11) NOT NULL AUTO_INCREMENT, `baseval` varchar(30) NOT NULL, `ip` varchar(90) NOT NULL, `iscustom` varchar(4) NOT NULL, @@ -238,7 +238,7 @@ PHP; sqlrun(' CREATE TABLE `redirinfo-temp` ( `rurl` text NOT NULL, - `rid` smallint(200) NOT NULL AUTO_INCREMENT, + `rid` int(11) NOT NULL AUTO_INCREMENT, `baseval` varchar(30) NOT NULL, `ip` varchar(90) NOT NULL, `iscustom` varchar(4) NOT NULL, |