diff options
| author | redmatrix <git@macgirvin.com> | 2016-05-27 23:57:47 -0700 |
|---|---|---|
| committer | redmatrix <git@macgirvin.com> | 2016-05-27 23:57:47 -0700 |
| commit | ac4688eac087854bf8cb0c893d7a79052ad63a20 (patch) | |
| tree | 1dba1fae0e25ffe07ccbe4406a2900535429b764 /install/schema_postgres.sql | |
| parent | ab6eb1c4b264b32e7feece290a2463eb747579ed (diff) | |
| download | volse-hubzilla-ac4688eac087854bf8cb0c893d7a79052ad63a20.tar.gz volse-hubzilla-ac4688eac087854bf8cb0c893d7a79052ad63a20.tar.bz2 volse-hubzilla-ac4688eac087854bf8cb0c893d7a79052ad63a20.zip | |
allow objs to represent inventory
Diffstat (limited to 'install/schema_postgres.sql')
| -rw-r--r-- | install/schema_postgres.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 75e53d3dd..e2c078dc1 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -873,6 +873,7 @@ CREATE TABLE "obj" ( "obj_imgurl" char(255) NOT NULL DEFAULT '', "obj_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', "obj_edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', + "obj_quantity" int(11) NOT NULL DEFAUL '0'. "allow_cid" text NOT NULL, "allow_gid" text NOT NULL, "deny_cid" text NOT NULL, @@ -890,6 +891,7 @@ create index "obj_url" on obj ("obj_url"); create index "obj_imgurl" on obj ("obj_imgurl"); create index "obj_created" on obj ("obj_created"); create index "obj_edited" on obj ("obj_edited"); +create index "obj_quantity" on obj ("obj_quantity"); CREATE TABLE "outq" ( "outq_hash" text NOT NULL, |