diff options
| author | Sean Dague | 2007-08-08 15:50:48 +0000 |
|---|---|---|
| committer | Sean Dague | 2007-08-08 15:50:48 +0000 |
| commit | 4805460e89b448c849a7b5bf2808d9990e5e1125 (patch) | |
| tree | ed9929322ba8afd6942aa632a0d996bf13a96605 /share/sql | |
| parent | Commit works? (diff) | |
| download | opensim-SC_OLD-4805460e89b448c849a7b5bf2808d9990e5e1125.zip opensim-SC_OLD-4805460e89b448c849a7b5bf2808d9990e5e1125.tar.gz opensim-SC_OLD-4805460e89b448c849a7b5bf2808d9990e5e1125.tar.bz2 opensim-SC_OLD-4805460e89b448c849a7b5bf2808d9990e5e1125.tar.xz | |
updated to latest version
Diffstat (limited to 'share/sql')
| -rw-r--r-- | share/sql/sqlite3-prims.sql | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/share/sql/sqlite3-prims.sql b/share/sql/sqlite3-prims.sql index 7cb0a02..ef6ef5a 100644 --- a/share/sql/sqlite3-prims.sql +++ b/share/sql/sqlite3-prims.sql | |||
| @@ -8,16 +8,15 @@ | |||
| 8 | -- string => varchar(256) until such time as we know we need bigger | 8 | -- string => varchar(256) until such time as we know we need bigger |
| 9 | 9 | ||
| 10 | create table prims ( | 10 | create table prims ( |
| 11 | id integer primary key autoincrement, -- this.LocalID | 11 | UUID char(36) primary key, -- this.UUID |
| 12 | ParentID integer default 0, -- this.ParentID | 12 | ParentID integer default 0, -- this.ParentID |
| 13 | UUID char(36), -- this.UUID | ||
| 14 | CreationDate integer, -- this.CreationDate | 13 | CreationDate integer, -- this.CreationDate |
| 15 | Name varchar(256), | 14 | Name varchar(256), |
| 16 | -- various text fields | 15 | -- various text fields |
| 17 | Text varchar(256), | 16 | Text varchar(256), |
| 18 | Description varchar(256), | 17 | Description varchar(256), |
| 19 | SitName varchar(256), | 18 | SitName varchar(256), |
| 20 | TouchName | 19 | TouchName varchar(256), |
| 21 | -- permissions | 20 | -- permissions |
| 22 | CreatorID char(36), | 21 | CreatorID char(36), |
| 23 | OwnerID char(36), | 22 | OwnerID char(36), |