From 56d2db3a188461758dd1e4cec4536cf4f7bef684 Mon Sep 17 00:00:00 2001 From: TomTheDragon Date: Thu, 2 Nov 2017 23:53:19 -0400 Subject: Add a new experimental implementation of PGSQL FSAssets Signed-off-by: UbitUmarov --- OpenSim/Data/PGSQL/Resources/FSAssetStore.migrations | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 OpenSim/Data/PGSQL/Resources/FSAssetStore.migrations (limited to 'OpenSim/Data/PGSQL/Resources') diff --git a/OpenSim/Data/PGSQL/Resources/FSAssetStore.migrations b/OpenSim/Data/PGSQL/Resources/FSAssetStore.migrations new file mode 100644 index 0000000..3a072e5 --- /dev/null +++ b/OpenSim/Data/PGSQL/Resources/FSAssetStore.migrations @@ -0,0 +1,14 @@ +:VERSION 1 + +BEGIN TRANSACTION; + +CREATE TABLE fsassets ( + "id" uuid NOT NULL PRIMARY KEY, + "type" integer NOT NULL, + "hash" char(64) NOT NULL, + "create_time" integer NOT NULL DEFAULT '0', + "access_time" integer NOT NULL DEFAULT '0', + "asset_flags" integer NOT NULL DEFAULT '0' +); + +COMMIT; -- cgit v1.1