aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql35
1 files changed, 33 insertions, 2 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
index f3b7a73..ede281c 100644
--- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql
@@ -1,4 +1,4 @@
1CREATE TABLE `prims` ( 1CREATE TABLE `Prims` (
2 `ParentID` int(11) default NULL, 2 `ParentID` int(11) default NULL,
3 `CreationDate` int(11) default NULL, 3 `CreationDate` int(11) default NULL,
4 `Name` varchar(255) default NULL, 4 `Name` varchar(255) default NULL,
@@ -48,4 +48,35 @@ CREATE TABLE `prims` (
48 PRIMARY KEY (`UUID`), 48 PRIMARY KEY (`UUID`),
49 KEY `prims_regionuuid` (`RegionID`), 49 KEY `prims_regionuuid` (`RegionID`),
50 KEY 'prims_parentuuid' ('ParentUUID') 50 KEY 'prims_parentuuid' ('ParentUUID')
51) ENGINE=InnoDB DEFAULT CHARSET=utf8 \ No newline at end of file 51) ENGINE=InnoDB DEFAULT CHARSET=utf8;
52
53CREATE TABLE `PrimShapes` (
54 `Shape` int(11) default NULL,
55 `ScaleX` float default NULL,
56 `ScaleY` float default NULL,
57 `ScaleZ` float default NULL,
58 `PCode` int(11) default NULL,
59 `PathBegin` int(11) default NULL,
60 `PathEnd` int(11) default NULL,
61 `PathScaleX` int(11) default NULL,
62 `PathScaleY` int(11) default NULL,
63 `PathShearX` int(11) default NULL,
64 `PathShearY` int(11) default NULL,
65 `PathSkew` int(11) default NULL,
66 `PathCurve` int(11) default NULL,
67 `PathRadiusOffset` int(11) default NULL,
68 `PathRevolutions` int(11) default NULL,
69 `PathTaperX` int(11) default NULL,
70 `PathTaperY` int(11) default NULL,
71 `PathTwist` int(11) default NULL,
72 `PathTwistBegin` int(11) default NULL,
73 `ProfileBegin` int(11) default NULL,
74 `ProfileEnd` int(11) default NULL,
75 `ProfileCurve` int(11) default NULL,
76 `ProfileHollow` int(11) default NULL,
77 `State` int(11) default NULL,
78 `Texture` longblob,
79 `ExtraParams` longblob,
80 `UUID` char(36) NOT NULL default '',
81 PRIMARY KEY (`UUID`)
82) ENGINE=InnoDB DEFAULT CHARSET=utf8;