| Index: trunk/extensions/CheckUser/cu_changes.pg.sql |
| — | — | @@ -7,24 +7,25 @@ |
| 8 | 8 | |
| 9 | 9 | CREATE SEQUENCE cu_changes_cu_id_seq; |
| 10 | 10 | CREATE TABLE cu_changes ( |
| 11 | | - cuc_id INTEGER NOT NULL DEFAULT nextval('cu_changes_cu_id_seq'), |
| 12 | | - cuc_namespace SMALLINT NOT NULL DEFAULT 0, |
| 13 | | - cuc_title TEXT NOT NULL DEFAULT '', |
| 14 | | - cuc_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, |
| 15 | | - cuc_user_text TEXT NOT NULL, |
| 16 | | - cuc_actiontext TEXT NOT NULL DEFAULT '', |
| 17 | | - cuc_comment TEXT NOT NULL DEFAULT '', |
| 18 | | - cuc_minor CHAR NOT NULL DEFAULT '0', |
| 19 | | - cuc_page_id INTEGER NULL REFERENCES page(page_id) ON DELETE SET NULL, |
| 20 | | - cuc_this_oldid INTEGER NOT NULL DEFAULT 0, |
| 21 | | - cuc_last_oldid INTEGER NOT NULL default 0, |
| 22 | | - cuc_type SMALLINT NOT NULL default '0', |
| 23 | | - cuc_timestamp TIMESTAMPTZ, |
| 24 | | - cuc_ip CIDR, |
| 25 | | - cuc_ip_hex TEXT, |
| 26 | | - cuc_xff TEXT, |
| 27 | | - cuc_xff_hex TEXT, |
| 28 | | - cuc_agent TEXT |
| | 11 | + cuc_id INTEGER NOT NULL DEFAULT nextval('cu_changes_cu_id_seq'), |
| | 12 | + cuc_namespace SMALLINT NOT NULL DEFAULT 0, |
| | 13 | + cuc_title TEXT NOT NULL DEFAULT '', |
| | 14 | + cuc_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, |
| | 15 | + cuc_user_text TEXT NOT NULL, |
| | 16 | + cuc_actiontext TEXT NOT NULL DEFAULT '', |
| | 17 | + cuc_comment TEXT NOT NULL DEFAULT '', |
| | 18 | + cuc_minor CHAR NOT NULL DEFAULT '0', |
| | 19 | + cuc_page_id INTEGER NULL REFERENCES page(page_id) ON DELETE SET NULL, |
| | 20 | + cuc_this_oldid INTEGER NOT NULL DEFAULT 0, |
| | 21 | + cuc_last_oldid INTEGER NOT NULL default 0, |
| | 22 | + cuc_type SMALLINT NOT NULL default '0', |
| | 23 | + cuc_timestamp TIMESTAMPTZ, |
| | 24 | + cuc_ip CIDR, |
| | 25 | + cuc_ip_hex TEXT, |
| | 26 | + cuc_xff TEXT, |
| | 27 | + cuc_xff_hex TEXT, |
| | 28 | + cuc_agent TEXT, |
| | 29 | + cuc_cookie_user TEXT |
| 29 | 30 | ); |
| 30 | 31 | |
| 31 | 32 | CREATE INDEX cu_changes_index ON cu_changes(cuc_user, cuc_ip_hex, cuc_xff_hex, cuc_timestamp); |