schema.sql (6862B)
1 -- https://docs.microsoft.com/en-us/previous-versions/sql/compact/sql-server-compact-3.5-sp2/ms173372(v=sql.105)?redirectedfrom=MSDN 2 3 CREATE TABLE GameData 4 ( 5 Title nvarchar(250), 6 OpeningMessage ntext, 7 HideMainPicDisplay bit, 8 UseInlineImages bit, 9 HidePortrait bit, 10 AuthorName nvarchar(250), 11 GameVersion nvarchar(50), 12 GameInformation ntext, 13 bgMusic nvarchar(250), 14 RepeatbgMusic bit, 15 PasswordProtected bit, 16 GamePassword nvarchar(250), 17 ObjectVersionNumber nvarchar(250), 18 GameFont nvarchar(250) 19 ); 20 21 CREATE TABLE Rooms 22 ( 23 UniqueID nvarchar(250), 24 Description ntext, 25 SDesc nvarchar(250), 26 Name nvarchar(250), 27 RoomPic nvarchar(250), 28 EnterFirstTime bit, 29 LeaveFirstTime bit, 30 [Group] nvarchar(250), 31 LayeredRoomPic nvarchar(250) 32 ); 33 34 CREATE TABLE RoomActions 35 ( 36 ID int IDENTITY (1, 1) NOT NULL, 37 RoomID nvarchar(250), 38 Data ntext 39 ); 40 41 CREATE TABLE RoomProperties 42 ( 43 ID int IDENTITY (1, 1) NOT NULL, 44 RoomID nvarchar(250), 45 Name nvarchar(250), 46 Value ntext 47 ); 48 49 CREATE TABLE RoomExits 50 ( 51 ID int IDENTITY (1, 1) NOT NULL, 52 RoomID nvarchar(250), 53 Direction int, 54 Active bit, 55 DestinationRoom nvarchar(250), 56 PortalObjectName nvarchar(250) 57 ); 58 59 CREATE TABLE Items 60 ( 61 UniqueID nvarchar(250), 62 Name nvarchar(250), 63 Description ntext, 64 SDesc nvarchar(250), 65 Preposition nvarchar(250), 66 LocationName nvarchar(250), 67 LocationType int, 68 Carryable bit, 69 Wearable bit, 70 Openable bit, 71 Lockable bit, 72 Enterable bit, 73 Readable bit, 74 Container bit, 75 Weight float, 76 Worn bit, 77 [Read] bit, 78 Locked bit, 79 [Open] bit, 80 Entered bit, 81 Visible bit, 82 EnterFirstTime bit, 83 LeaveFirstTime bit 84 ); 85 86 CREATE TABLE ItemActions 87 ( 88 ID int IDENTITY (1, 1) NOT NULL, 89 ItemID nvarchar(250), 90 Data ntext 91 ); 92 93 CREATE TABLE ItemProperties 94 ( 95 ID int IDENTITY (1, 1) NOT NULL, 96 ItemID nvarchar(250), 97 Name nvarchar(250), 98 Value ntext 99 ); 100 101 CREATE TABLE ItemLayeredZoneLevels 102 ( 103 ID int IDENTITY (1, 1) NOT NULL, 104 ItemID nvarchar(250), 105 Data nvarchar(250) 106 ); 107 108 CREATE TABLE Media 109 ( 110 Name nvarchar(250), 111 BackgroundColor nvarchar(250), 112 TextColor nvarchar(250), 113 TextFont nvarchar(250), 114 ImageName nvarchar(250), 115 UseEnhancedGraphics bit, 116 NewImage nvarchar(250), 117 Data image 118 ); 119 120 CREATE TABLE MediaLayeredImages 121 ( 122 ID int IDENTITY (1, 1) NOT NULL, 123 MediaName nvarchar(250), 124 Data nvarchar(250) 125 ); 126 127 CREATE TABLE Player 128 ( 129 Name nvarchar(250), 130 Description ntext, 131 StartingRoom nvarchar(250), 132 CurrentRoom nvarchar(250), 133 PlayerLayeredImage nvarchar(250), 134 PlayerGender int, 135 PromptForName bit, 136 PromptForGender bit, 137 PlayerPortrait nvarchar(250), 138 EnforceWeight bit, 139 WeightLimit float 140 ); 141 142 CREATE TABLE PlayerActions 143 ( 144 ID int IDENTITY (1, 1) NOT NULL, 145 Data ntext 146 ); 147 148 CREATE TABLE PlayerProperties 149 ( 150 ID int IDENTITY (1, 1) NOT NULL, 151 Name nvarchar(250), 152 Value ntext 153 ); 154 155 CREATE TABLE Characters 156 ( 157 Charname nvarchar(250), 158 CharnameOverride nvarchar(250), 159 CharGender int, 160 CurrentRoom nvarchar(250), 161 Description ntext, 162 AllowInventoryInteraction bit, 163 EnterFirstTime bit, 164 LeaveFirstTime bit 165 ); 166 167 CREATE TABLE CharacterActions 168 ( 169 ID int IDENTITY (1, 1) NOT NULL, 170 Charname nvarchar(250), 171 Data ntext 172 ); 173 174 CREATE TABLE CharacterProperties 175 ( 176 ID int IDENTITY (1, 1) NOT NULL, 177 Charname nvarchar(250), 178 Name nvarchar(250), 179 Value ntext 180 ); 181 182 CREATE TABLE Variables 183 ( 184 VarName nvarchar(250), 185 String ntext, 186 NumType float, 187 Min nvarchar(50), 188 Max nvarchar(50), 189 EnforceRestrictions bit, 190 VarComment ntext, 191 dtDateTime datetime, 192 VarType int, 193 VarArray ntext 194 ); 195 196 CREATE TABLE VariableProperties 197 ( 198 ID int IDENTITY (1, 1) NOT NULL, 199 VarName nvarchar(250), 200 Name nvarchar(250), 201 Value ntext 202 ); 203 204 CREATE TABLE Timer 205 ( 206 Name nvarchar(250), 207 TType int, 208 Active bit, 209 Restart bit, 210 TurnNumber int, 211 Length int, 212 LiveTimer bit, 213 TimerSeconds int 214 ); 215 216 CREATE TABLE TimerActions 217 ( 218 ID int IDENTITY (1, 1) NOT NULL, 219 Name nvarchar(250), 220 Data ntext 221 ); 222 223 CREATE TABLE TimerProperties 224 ( 225 ID int IDENTITY (1, 1) NOT NULL, 226 TimerName nvarchar(250), 227 Name nvarchar(250), 228 Value ntext 229 ); 230 231 -- 232 233 SELECT COUNT(*) 234 FROM INFORMATION_SCHEMA.TABLES 235 WHERE TABLE_NAME = 'MediaGroups'; 236 237 CREATE TABLE MediaGroups 238 ( 239 ID int IDENTITY (1, 1) NOT NULL, 240 Name nvarchar(255), 241 Parent nvarchar(255) 242 ); 243 244 SELECT COUNT(*) 245 FROM INFORMATION_SCHEMA.COLUMNS 246 WHERE TABLE_NAME = 'Items' 247 AND COLUMN_NAME = 'GroupName'; 248 249 ALTER TABLE Items ADD COLUMN 250 GroupName nvarchar(255); 251 252 SELECT COUNT(*) 253 FROM INFORMATION_SCHEMA.COLUMNS 254 WHERE TABLE_NAME = 'Items' 255 AND COLUMN_NAME = 'Important'; 256 257 ALTER TABLE Items ADD COLUMN 258 Important bit NOT NULL DEFAULT (0); 259 260 SELECT COUNT(*) 261 FROM INFORMATION_SCHEMA.COLUMNS 262 WHERE TABLE_NAME = 'GameData' 263 AND COLUMN_NAME = 'RoomGroups'; 264 265 ALTER TABLE GameData ADD COLUMN 266 RoomGroups ntext; 267 268 SELECT COUNT(*) 269 FROM INFORMATION_SCHEMA.COLUMNS 270 WHERE TABLE_NAME = 'GameData' 271 AND COLUMN_NAME = 'ClothingZoneLevels'; 272 273 ALTER TABLE GameData ADD COLUMN 274 ClothingZoneLevels ntext; 275 276 SELECT COUNT(*) 277 FROM INFORMATION_SCHEMA.COLUMNS 278 WHERE TABLE_NAME = 'GameData' 279 AND COLUMN_NAME = 'NotificationsOff'; 280 281 ALTER TABLE GameData ADD COLUMN 282 NotificationsOff bit NOT NULL DEFAULT (0); 283 284 SELECT COUNT(*) 285 FROM INFORMATION_SCHEMA.COLUMNS 286 WHERE TABLE_NAME = 'GameData' 287 AND COLUMN_NAME = 'SortOrderRoom'; 288 289 ALTER TABLE GameData ADD COLUMN 290 SortOrderRoom int NOT NULL DEFAULT (0), 291 SortOrderCharacters int NOT NULL DEFAULT (0), 292 SortOrderInventory int NOT NULL DEFAULT (0); 293 294 SELECT COUNT(*) 295 FROM INFORMATION_SCHEMA.COLUMNS 296 WHERE TABLE_NAME = 'Media' 297 AND COLUMN_NAME = 'GroupName'; 298 299 ALTER TABLE Media ADD COLUMN 300 GroupName nvarchar(255); 301 302 SELECT COUNT(*) 303 FROM INFORMATION_SCHEMA.TABLES 304 WHERE TABLE_NAME = 'ItemGroups'; 305 306 CREATE TABLE ItemGroups 307 ( 308 ID int IDENTITY (1, 1) NOT NULL, 309 Name nvarchar(255), 310 Parent nvarchar(255) 311 ); 312 313 SELECT COUNT(*) 314 FROM INFORMATION_SCHEMA.TABLES 315 WHERE TABLE_NAME = 'VariableGroups'; 316 317 CREATE TABLE VariableGroups 318 ( 319 ID int IDENTITY (1, 1) NOT NULL, 320 Name nvarchar(255), 321 Parent nvarchar(255) 322 ); 323 324 SELECT COUNT(*) 325 FROM INFORMATION_SCHEMA.COLUMNS 326 WHERE TABLE_NAME = 'Variables' 327 AND COLUMN_NAME = 'GroupName'; 328 329 ALTER TABLE Variables ADD COLUMN 330 GroupName nvarchar(255); 331 332 SELECT COUNT(*) 333 FROM INFORMATION_SCHEMA.TABLES 334 WHERE TABLE_NAME = 'StatusBarItems'; 335 336 CREATE TABLE StatusBarItems 337 ( 338 ID int IDENTITY (1, 1) NOT NULL, 339 Name nvarchar(255), 340 Text ntext, 341 Width int 342 ); 343 344 SELECT COUNT(*) 345 FROM INFORMATION_SCHEMA.COLUMNS 346 WHERE TABLE_NAME = 'StatusBarItems' 347 AND COLUMN_NAME = 'Visible'; 348 349 ALTER TABLE StatusBarItems ADD COLUMN 350 Visible bit NOT NULL DEFAULT (1); 351 352 SELECT COUNT(*) 353 FROM INFORMATION_SCHEMA.COLUMNS 354 WHERE TABLE_NAME = 'Characters' 355 AND COLUMN_NAME = 'CharPortrait'; 356 357 ALTER TABLE Characters ADD COLUMN 358 CharPortrait nvarchar(255); 359 360 SELECT COUNT(*) 361 FROM INFORMATION_SCHEMA.COLUMNS 362 WHERE TABLE_NAME = 'MediaLayeredImages' 363 AND COLUMN_NAME = 'Order'; 364 365 ALTER TABLE MediaLayeredImages ADD COLUMN 366 [Order] int;