| Index: trunk/extensions/FlaggedRevs/FlaggedRevs.pg.sql |
| — | — | @@ -1,45 +1,45 @@ |
| 2 | | -
|
| 3 | | -BEGIN;
|
| 4 | | -
|
| 5 | | -CREATE TABLE flaggedrevs (
|
| 6 | | - fr_namespace SMALLINT NOT NULL DEFAULT 0,
|
| 7 | | - fr_title TEXT NOT NULL DEFAULT '',
|
| 8 | | - fr_rev_id INTEGER NOT NULL PRIMARY KEY DEFAULT 0 ,
|
| 9 | | - fr_user int(5) INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL,
|
| 10 | | - fr_timestamp TIMESTAMPTZ,
|
| 11 | | - fr_comment TEXT NOT NULL DEFAULT '',
|
| 12 | | - fr_text TEXT NOT NULL DEFAULT '',
|
| 13 | | - fr_quality SMALLINT NOT NULL DEFAULT 0
|
| 14 | | -);
|
| 15 | | -CREATE INDEX fr_namespace_title ON flaggedrevs (fr_namespace,fr_title,fr_quality,fr_rev_id);
|
| 16 | | -
|
| 17 | | -CREATE TABLE flaggedrevtags (
|
| 18 | | - frt_rev_id INTEGER NOT NULL DEFAULT 0 ,
|
| 19 | | - frt_dimension TEXT NOT NULL DEFAULT '',
|
| 20 | | - frt_value SMALLINT NOT NULL DEFAULT 0
|
| 21 | | -);
|
| 22 | | -CREATE UNIQUE INDEX frt_rev_dimension ON flaggedrevtags (frt_rev_id,frt_dimension);
|
| 23 | | -CREATE INDEX frt_rev_dim_val ON flaggedrevtags (frt_rev_id,frt_dimension,frt_value);
|
| 24 | | -
|
| 25 | | -CREATE TABLE flaggedtemplates (
|
| 26 | | - ft_rev_id INTEGER NOT NULL DEFAULT 0 ,
|
| 27 | | - ft_namespace SMALLINT NOT NULL DEFAULT 0,
|
| 28 | | - ft_title TEXT NOT NULL DEFAULT '',
|
| 29 | | - ft_tmp_rev_id INTEGER NOT NULL DEFAULT 0
|
| 30 | | -);
|
| 31 | | -CREATE UNIQUE INDEX ft_rev_ns_title ON flaggedtemplates (ft_rev_id,ft_namespace,ft_title);
|
| 32 | | -CREATE INDEX ft_rev_ns_title_id ON flaggedtemplates (ft_rev_id,ft_namespace,ft_title,ft_tmp_rev_id);
|
| 33 | | -
|
| 34 | | -CREATE TABLE flaggedimages (
|
| 35 | | - fi_rev_id INTEGER NOT NULL DEFAULT 0 ,
|
| 36 | | - fi_name TEXT NOT NULL PRIMARY KEY,
|
| 37 | | - fi_img_timestamp TIMESTAMPTZ,
|
| 38 | | - fi_img_sha1 CHAR(64)
|
| 39 | | -);
|
| 40 | | -CREATE UNIQUE INDEX fi_rev_name ON flaggedimages (fi_rev_id,fi_name);
|
| 41 | | -CREATE INDEX fi_rev_name_time ON flaggedimages (fi_rev_id,fi_name,fi_img_timestamp);
|
| 42 | | -CREATE INDEX fi_rev_img_sha1 ON flaggedimages (fi_rev_id,fi_name,fi_img_sha1);
|
| 43 | | -
|
| 44 | | -COMMIT;
|
| | 2 | +-- (c) Joerg Baach, Aaron Schulz, 2007 |
| | 3 | +-- See FlaggedRevs.sql for details |
| | 4 | + |
| | 5 | +BEGIN; |
| | 6 | + |
| | 7 | +CREATE TABLE flaggedrevs ( |
| | 8 | + fr_namespace SMALLINT NOT NULL DEFAULT 0, |
| | 9 | + fr_title TEXT NOT NULL DEFAULT '', |
| | 10 | + fr_rev_id INTEGER NOT NULL PRIMARY KEY DEFAULT 0 , |
| | 11 | + fr_user int(5) INTEGER NULL REFERENCES mwuser(user_id) ON DELETE SET NULL, |
| | 12 | + fr_timestamp TIMESTAMPTZ, |
| | 13 | + fr_comment TEXT NOT NULL DEFAULT '', |
| | 14 | + fr_text TEXT NOT NULL DEFAULT '', |
| | 15 | + fr_quality SMALLINT NOT NULL DEFAULT 0 |
| | 16 | +); |
| | 17 | +CREATE INDEX fr_namespace_title ON flaggedrevs (fr_namespace,fr_title,fr_quality,fr_rev_id); |
| | 18 | + |
| | 19 | +CREATE TABLE flaggedrevtags ( |
| | 20 | + frt_rev_id INTEGER NOT NULL DEFAULT 0 , |
| | 21 | + frt_dimension TEXT NOT NULL DEFAULT '', |
| | 22 | + frt_value SMALLINT NOT NULL DEFAULT 0 |
| | 23 | +); |
| | 24 | +CREATE UNIQUE INDEX frt_rev_dimension ON flaggedrevtags (frt_rev_id,frt_dimension); |
| | 25 | +CREATE INDEX frt_rev_dim_val ON flaggedrevtags (frt_rev_id,frt_dimension,frt_value); |
| | 26 | + |
| | 27 | +CREATE TABLE flaggedtemplates ( |
| | 28 | + ft_rev_id INTEGER NOT NULL DEFAULT 0 , |
| | 29 | + ft_namespace SMALLINT NOT NULL DEFAULT 0, |
| | 30 | + ft_title TEXT NOT NULL DEFAULT '', |
| | 31 | + ft_tmp_rev_id INTEGER NOT NULL DEFAULT 0 |
| | 32 | +); |
| | 33 | +CREATE UNIQUE INDEX ft_rev_ns_title ON flaggedtemplates (ft_rev_id,ft_namespace,ft_title); |
| | 34 | +CREATE INDEX ft_rev_ns_title_id ON flaggedtemplates (ft_rev_id,ft_namespace,ft_title,ft_tmp_rev_id); |
| | 35 | + |
| | 36 | +CREATE TABLE flaggedimages ( |
| | 37 | + fi_rev_id INTEGER NOT NULL DEFAULT 0 , |
| | 38 | + fi_name TEXT NOT NULL PRIMARY KEY, |
| | 39 | + fi_img_timestamp TIMESTAMPTZ, |
| | 40 | + fi_img_sha1 CHAR(64) |
| | 41 | +); |
| | 42 | +CREATE UNIQUE INDEX fi_rev_name ON flaggedimages (fi_rev_id,fi_name); |
| | 43 | +CREATE INDEX fi_rev_name_time ON flaggedimages (fi_rev_id,fi_name,fi_img_timestamp); |
| | 44 | +CREATE INDEX fi_rev_img_sha1 ON flaggedimages (fi_rev_id,fi_name,fi_img_sha1); |
| | 45 | + |
| | 46 | +COMMIT; |
| Property changes on: trunk/extensions/FlaggedRevs/FlaggedRevs.pg.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 45 | 47 | + native |
| Property changes on: trunk/extensions/Wikidata/OmegaWiki/small/ra3.pl |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 46 | 48 | + native |
| Property changes on: trunk/extensions/Wikidata/OmegaWiki/small/overload.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 47 | 49 | + native |
| Property changes on: trunk/extensions/Wikidata/OmegaWiki/small/listmatch.pl |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 48 | 50 | + native |
| Property changes on: trunk/extensions/Wikidata/OmegaWiki/small/functionvar.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 49 | 51 | + native |
| Property changes on: trunk/extensions/Wikidata/OmegaWiki/small/raO.pl |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 50 | 52 | + native |
| Property changes on: trunk/extensions/Wikidata/OmegaWiki/small/replace_attribs.pl |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 51 | 53 | + native |
| Property changes on: trunk/extensions/Wikidata/OmegaWiki/small/ra2.pl |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 52 | 54 | + native |
| Property changes on: trunk/extensions/Wikidata/util/umls/missing.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 53 | 55 | + native |
| Property changes on: trunk/extensions/Wikidata/util/umls/collection.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 54 | 56 | + native |
| Property changes on: trunk/extensions/Wikidata/util/umls/collections.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 55 | 57 | + native |
| Property changes on: trunk/extensions/Wikidata/util/umls/stats.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 56 | 58 | + native |
| Property changes on: trunk/extensions/geoserver/geoserver.psql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 57 | 59 | + native |
| Property changes on: trunk/extensions/PdfHandler/PdfImage.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 58 | 60 | + native |
| Property changes on: trunk/extensions/PdfHandler/PdfLoader.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 59 | 61 | + native |
| Property changes on: trunk/extensions/PdfHandler/PdfHandler.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 60 | 62 | + native |
| Property changes on: trunk/extensions/SemanticForms/specials/SF_CreateProperty.php |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 61 | 63 | + native |
| Property changes on: trunk/extensions/Gadgets/install.settings |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 62 | 64 | + native |
| Property changes on: trunk/extensions/Gadgets/README |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 63 | 65 | + native |