aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql
diff options
context:
space:
mode:
authorCharles Krinke2009-01-23 20:21:43 +0000
committerCharles Krinke2009-01-23 20:21:43 +0000
commitbd2c345e56f0857d4d48e8bea509e00954be5d9f (patch)
tree7161fc65dc3b945aa233cf31b680fc6183dd6609 /OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql
parent* Extend archive test to check for the presence of a control file in a saved ... (diff)
downloadopensim-SC-bd2c345e56f0857d4d48e8bea509e00954be5d9f.zip
opensim-SC-bd2c345e56f0857d4d48e8bea509e00954be5d9f.tar.gz
opensim-SC-bd2c345e56f0857d4d48e8bea509e00954be5d9f.tar.bz2
opensim-SC-bd2c345e56f0857d4d48e8bea509e00954be5d9f.tar.xz
Thank you kindly, TLaukkan (Tommil) for a patch that:
* Added Npgsql.dll and Mono.Security.dll which are NpgsqlDriver dlls. * Added missing field to schema creation scripts: PathTaperY. * Added schema creation scripts for PostgreSQL. * Added unit test classes for PostgreSQL. * Added schema creation script folder to NHibernate project in prebuild.xml * Added Npgsql.dll to NHibernate test project dependencies in prebuild.xml * Ensured that build works with both nant and Visual Studio. * Executed build unit tests with nant and NHibernate unit tests with NUnitGUI - Couple of region tests fail due to double precission float rounding errors need to sort out how these are handles in unit tests and if higher precission numeric field needs to be used in Postgresql.
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_AssetStore.sql10
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 @@
1CREATE 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);