diff options
author | Dries Buytaert <dries@buytaert.net> | 2005-12-28 12:02:29 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2005-12-28 12:02:29 +0000 |
commit | 753f11d8c98982b3b8dd5c9266d6f7fd91f7e719 (patch) | |
tree | a6b4645eba917866909cd1622a45457b5b74b9cd /database/database.mysql | |
parent | 4c66ab52f31d0b9718b7f4255536797695d187fc (diff) | |
download | brdo-753f11d8c98982b3b8dd5c9266d6f7fd91f7e719.tar.gz brdo-753f11d8c98982b3b8dd5c9266d6f7fd91f7e719.tar.bz2 |
- Patch #41755 by Cvbge:
1. "int(10)" -> "int", fixed typo in index name [pgsql change only]
2. added defaults for uid and hostname (needed for both)
3. postgres supports "DROP column" syntax
4. added missing DELETEs for new table in poll_delete() and poll_update()
Diffstat (limited to 'database/database.mysql')
-rw-r--r-- | database/database.mysql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/database/database.mysql b/database/database.mysql index 92df2c686..f08db4f6f 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -546,8 +546,8 @@ CREATE TABLE poll ( CREATE TABLE poll_votes ( nid int(10) unsigned NOT NULL, - uid int(10) unsigned NOT NULL, - hostname varchar(128) NOT NULL, + uid int(10) unsigned NOT NULL default 0, + hostname varchar(128) NOT NULL default '', INDEX (nid), INDEX (uid), INDEX (hostname) |