diff options
| author | Sean Dague | 2008-01-23 20:42:50 +0000 |
|---|---|---|
| committer | Sean Dague | 2008-01-23 20:42:50 +0000 |
| commit | 781187e16f27fe140b241481d4879e6de631ade8 (patch) | |
| tree | cbdba39afab9024f6a1c766184f4e8e8e51cb1da /OpenSim/Framework/Data.SQLite/Resources/001_AssetStore.sql | |
| parent | * Changing log messages to use 24 hour clock rather than 12 hour - hope nobod... (diff) | |
| download | opensim-SC_OLD-781187e16f27fe140b241481d4879e6de631ade8.zip opensim-SC_OLD-781187e16f27fe140b241481d4879e6de631ade8.tar.gz opensim-SC_OLD-781187e16f27fe140b241481d4879e6de631ade8.tar.bz2 opensim-SC_OLD-781187e16f27fe140b241481d4879e6de631ade8.tar.xz | |
put the number in front of the migrations to make them easier to deal with
Diffstat (limited to 'OpenSim/Framework/Data.SQLite/Resources/001_AssetStore.sql')
| -rw-r--r-- | OpenSim/Framework/Data.SQLite/Resources/001_AssetStore.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/OpenSim/Framework/Data.SQLite/Resources/001_AssetStore.sql b/OpenSim/Framework/Data.SQLite/Resources/001_AssetStore.sql new file mode 100644 index 0000000..1dc05d8 --- /dev/null +++ b/OpenSim/Framework/Data.SQLite/Resources/001_AssetStore.sql | |||
| @@ -0,0 +1,13 @@ | |||
| 1 | BEGIN TRANSACTION; | ||
| 2 | |||
| 3 | CREATE TABLE assets( | ||
| 4 | UUID varchar(255) primary key, | ||
| 5 | Name varchar(255), | ||
| 6 | Description varchar(255), | ||
| 7 | Type integer, | ||
| 8 | InvType integer, | ||
| 9 | Local integer, | ||
| 10 | Temporary integer, | ||
| 11 | Data blob); | ||
| 12 | |||
| 13 | COMMIT; | ||