| Index: trunk/extensions/Review/Review.sql |
| — | — | @@ -4,6 +4,7 @@ |
| 5 | 5 | val_user int(10) NOT NULL, |
| 6 | 6 | val_page int(10) NOT NULL, |
| 7 | 7 | val_revision int(10) NOT NULL, |
| | 8 | + val_type int NOT NULL, |
| 8 | 9 | val_value int(2) NOT NULL, |
| 9 | 10 | val_comment varchar(255) NOT NULL default '', |
| 10 | 11 | val_ip varchar(255) NOT NULL default '', |
| Index: trunk/extensions/Review/Review.pg.sql |
| — | — | @@ -0,0 +1,18 @@ |
| | 2 | +-- This stores user rating data for revisions |
| | 3 | +-- Postgres version |
| | 4 | + |
| | 5 | +CREATE SEQUENCE validate_id_seq; |
| | 6 | + |
| | 7 | +CREATE TABLE validate ( |
| | 8 | + val_id INTEGER NOT NULL DEFAULT nextval('validate_id_seq'), |
| | 9 | + val_user INTEGER NOT NULL, |
| | 10 | + val_page INTEGER NOT NULL, |
| | 11 | + val_revision INTEGER NOT NULL, |
| | 12 | + val_type SMALLINT NOT NULL DEFAULT 1, |
| | 13 | + val_value SMALLINT NOT NULL, |
| | 14 | + val_comment TEXT NOT NULL DEFAULT '', |
| | 15 | + val_ip TEXT NOT NULL DEFAULT '', |
| | 16 | + PRIMARY KEY (val_id) |
| | 17 | +); |
| | 18 | + |
| | 19 | +CREATE INDEX validate_index ON validate(val_user,val_revision); |
| Property changes on: trunk/extensions/Review/Review.pg.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 20 | + native |
| Index: trunk/extensions/Review/Review.php |
| — | — | @@ -483,7 +483,7 @@ |
| 484 | 484 | /* FROM */ 'validate', |
| 485 | 485 | /* SELECT */ '*', |
| 486 | 486 | /* WHERE */ $conds, |
| 487 | | - $fname |
| | 487 | + __METHOD__ |
| 488 | 488 | ); |
| 489 | 489 | |
| 490 | 490 | $ret = array() ; |