diff options
Diffstat (limited to 'www/wiki/maintenance/postgres/archives/patch-site_stats-pk.sql')
-rw-r--r-- | www/wiki/maintenance/postgres/archives/patch-site_stats-pk.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/www/wiki/maintenance/postgres/archives/patch-site_stats-pk.sql b/www/wiki/maintenance/postgres/archives/patch-site_stats-pk.sql new file mode 100644 index 00000000..faa5e9f8 --- /dev/null +++ b/www/wiki/maintenance/postgres/archives/patch-site_stats-pk.sql @@ -0,0 +1,3 @@ +ALTER TABLE site_stats DROP CONSTRAINT site_stats_ss_row_id_key; +ALTER TABLE site_stats ADD PRIMARY KEY (ss_row_id); +ALTER TABLE site_stats ALTER ss_row_id SET DEFAULT 0; |