diff options
| author | Silvio Rhatto <rhatto@riseup.net> | 2020-10-01 17:48:30 -0300 |
|---|---|---|
| committer | Silvio Rhatto <rhatto@riseup.net> | 2020-10-01 17:48:30 -0300 |
| commit | b3bbae81b7b2c8132a4e43cfa49b81fae58dd8e5 (patch) | |
| tree | 28f70b6caff40a0b104177f893630c796e540e77 /data/tables.sql | |
| parent | 9a5f69a671a0ad841d9914293efbdcef0e1b75bf (diff) | |
| parent | ea04385bc16de6b7b65aab75c5c33cfe2d71ea84 (diff) | |
| download | semanticscuttle-b3bbae81b7b2c8132a4e43cfa49b81fae58dd8e5.tar.gz semanticscuttle-b3bbae81b7b2c8132a4e43cfa49b81fae58dd8e5.tar.bz2 | |
Merge remote-tracking branch 'querwurzelt/master' into mergev0.99.0
Diffstat (limited to 'data/tables.sql')
| -rw-r--r-- | data/tables.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/data/tables.sql b/data/tables.sql index 68d5ba9..de1bb8d 100644 --- a/data/tables.sql +++ b/data/tables.sql @@ -5,6 +5,9 @@ -- Table structure for table `sc_bookmarks` -- +# to avoid STRICT_TRANS_TABLES mode +SET sql_mode = ''; + CREATE TABLE `sc_bookmarks` ( `bId` int(11) NOT NULL auto_increment, `uId` int(11) NOT NULL default '0', @@ -17,8 +20,8 @@ CREATE TABLE `sc_bookmarks` ( `bDescription` text default NULL, `bPrivateNote` text default NULL, `bHash` varchar(32) NOT NULL default '', - `bVotes` int(11) NOT NULL, - `bVoting` int(11) NOT NULL, + `bVotes` int(11) NOT NULL default '0', + `bVoting` int(11) NOT NULL default '0', `bShort` varchar(16) default NULL, PRIMARY KEY (`bId`), KEY `sc_bookmarks_usd` (`uId`,`bStatus`,`bDatetime`), |