1 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql
new file mode 100644
index 0000000..b3e974a
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql
@@ -0,0 +1,10 @@
+CREATE TABLE Assets (
+  ID VARCHAR(36) NOT NULL,
+  Type SMALLINT DEFAULT NULL,
+  Name VARCHAR(64) DEFAULT NULL,
+  Description VARCHAR(64) DEFAULT NULL,
+  Local BOOLEAN DEFAULT NULL,
+  Temporary BOOLEAN DEFAULT NULL,
+  Data BYTEA,
+  PRIMARY KEY (ID)
+);

diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql new file mode 100644 index 0000000..b3e974a --- /dev/null +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql
@@ -0,0 +1,10 @@
	1	CREATE TABLE Assets (
	2	ID VARCHAR(36) NOT NULL,
	3	Type SMALLINT DEFAULT NULL,
	4	Name VARCHAR(64) DEFAULT NULL,
	5	Description VARCHAR(64) DEFAULT NULL,
	6	Local BOOLEAN DEFAULT NULL,
	7	Temporary BOOLEAN DEFAULT NULL,
	8	Data BYTEA,
	9	PRIMARY KEY (ID)
	10	);