summaryrefslogtreecommitdiff
path: root/sql/Pg-upgrade-2.0.8-2.2.0.sql
diff options
context:
space:
mode:
authorchristopherm <christopherm@4979c152-3d1c-0410-bac9-87ea11338e46>2006-09-01 01:16:38 +0000
committerchristopherm <christopherm@4979c152-3d1c-0410-bac9-87ea11338e46>2006-09-01 01:16:38 +0000
commitac5b087ea2d9ba7428d367aaeb288534158fee9a (patch)
tree2dbe0bdea0b653a215ba9ddfdf627cb57855050d /sql/Pg-upgrade-2.0.8-2.2.0.sql
Initial Import
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/ledger-smb@1 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/Pg-upgrade-2.0.8-2.2.0.sql')
-rwxr-xr-xsql/Pg-upgrade-2.0.8-2.2.0.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/Pg-upgrade-2.0.8-2.2.0.sql b/sql/Pg-upgrade-2.0.8-2.2.0.sql
new file mode 100755
index 00000000..00778722
--- /dev/null
+++ b/sql/Pg-upgrade-2.0.8-2.2.0.sql
@@ -0,0 +1,9 @@
+--
+create unique index projectnumber_key on project (projectnumber);
+create unique index partsgroup_key on partsgroup (partsgroup);
+--
+alter table ar add till varchar(20);
+alter table ap add till varchar(20);
+--
+update defaults set version = '2.2.0';
+--