diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | 35 |
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 @@ | |||
1 | CREATE TABLE `prims` ( | 1 | CREATE 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 | |||
53 | CREATE 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; | ||