1<?xml version="1.0" encoding="ISO-8859-1" ?> 2<database> 3 4 <name><variable>database</variable></name> 5 <create><variable>create</variable></create> 6 7 <table> 8 9 <name>liveuser_applications</name> 10 11 <declaration> 12 13 <field> 14 <name>application_id</name> 15 <type>integer</type> 16 <default>0</default> 17 </field> 18 19 <field> 20 <name>application_define_name</name> 21 <type>text</type> 22 <length>32</length> 23 </field> 24 25 <index> 26 <name>application_id</name> 27 <unique>1</unique> 28 <field> 29 <name>application_id</name> 30 <sorting>ascending</sorting> 31 </field> 32 </index> 33 34 <index> 35 <name>define_name_i</name> 36 <unique>1</unique> 37 <field> 38 <name>application_define_name</name> 39 <sorting>ascending</sorting> 40 </field> 41 </index> 42 43 </declaration> 44 45 </table> 46 47 <table> 48 49 <name>liveuser_area_admin_areas</name> 50 51 <declaration> 52 53 <field> 54 <name>area_id</name> 55 <type>integer</type> 56 <default>0</default> 57 </field> 58 59 <field> 60 <name>perm_user_id</name> 61 <type>integer</type> 62 <default>0</default> 63 </field> 64 65 <index> 66 <name>id_i</name> 67 <unique>1</unique> 68 <field> 69 <name>area_id</name> 70 <sorting>ascending</sorting> 71 </field> 72 <field> 73 <name>perm_user_id</name> 74 <sorting>ascending</sorting> 75 </field> 76 </index> 77 78 </declaration> 79 80 </table> 81 82 <table> 83 84 <name>liveuser_areas</name> 85 86 <declaration> 87 88 <field> 89 <name>area_id</name> 90 <type>integer</type> 91 <default>0</default> 92 </field> 93 94 <field> 95 <name>application_id</name> 96 <type>integer</type> 97 <default>0</default> 98 </field> 99 100 <field> 101 <name>area_define_name</name> 102 <type>text</type> 103 <length>32</length> 104 </field> 105 106 <index> 107 <name>area_id</name> 108 <unique>1</unique> 109 <field> 110 <name>area_id</name> 111 <sorting>ascending</sorting> 112 </field> 113 </index> 114 115 <index> 116 <name>define_name_i</name> 117 <unique>1</unique> 118 <field> 119 <name>application_id</name> 120 <sorting>ascending</sorting> 121 </field> 122 <field> 123 <name>area_define_name</name> 124 <sorting>ascending</sorting> 125 </field> 126 </index> 127 128 </declaration> 129 130 </table> 131 132 <table> 133 134 <name>liveuser_group_subgroups</name> 135 136 <declaration> 137 138 <field> 139 <name>group_id</name> 140 <type>integer</type> 141 <default>0</default> 142 </field> 143 144 <field> 145 <name>subgroup_id</name> 146 <type>integer</type> 147 <default>0</default> 148 </field> 149 150 <index> 151 <name>id_i</name> 152 <unique>1</unique> 153 <field> 154 <name>group_id</name> 155 <sorting>ascending</sorting> 156 </field> 157 <field> 158 <name>subgroup_id</name> 159 <sorting>ascending</sorting> 160 </field> 161 </index> 162 163 </declaration> 164 165 </table> 166 167 <table> 168 169 <name>liveuser_grouprights</name> 170 171 <declaration> 172 173 <field> 174 <name>group_id</name> 175 <type>integer</type> 176 <default>0</default> 177 </field> 178 179 <field> 180 <name>right_id</name> 181 <type>integer</type> 182 <default>0</default> 183 </field> 184 185 <field> 186 <name>right_level</name> 187 <type>integer</type> 188 </field> 189 190 <index> 191 <name>id_i</name> 192 <unique>1</unique> 193 <field> 194 <name>group_id</name> 195 <sorting>ascending</sorting> 196 </field> 197 <field> 198 <name>right_id</name> 199 <sorting>ascending</sorting> 200 </field> 201 </index> 202 203 </declaration> 204 205 </table> 206 207 <table> 208 209 <name>liveuser_groups</name> 210 211 <declaration> 212 213 <field> 214 <name>group_id</name> 215 <type>integer</type> 216 <default>0</default> 217 </field> 218 219 <field> 220 <name>group_type</name> 221 <type>integer</type> 222 </field> 223 224 <field> 225 <name>group_define_name</name> 226 <type>text</type> 227 <length>32</length> 228 </field> 229 230 <field> 231 <name>is_active</name> 232 <type>boolean</type> 233 </field> 234 235 <index> 236 <name>group_id</name> 237 <unique>1</unique> 238 <field> 239 <name>group_id</name> 240 <sorting>ascending</sorting> 241 </field> 242 </index> 243 244 <index> 245 <name>define_name_i</name> 246 <unique>1</unique> 247 <field> 248 <name>group_define_name</name> 249 <sorting>ascending</sorting> 250 </field> 251 </index> 252 253 </declaration> 254 255 </table> 256 257 <table> 258 259 <name>liveuser_groupusers</name> 260 261 <declaration> 262 263 <field> 264 <name>perm_user_id</name> 265 <type>integer</type> 266 <default>0</default> 267 </field> 268 269 <field> 270 <name>group_id</name> 271 <type>integer</type> 272 <default>0</default> 273 </field> 274 275 <index> 276 <name>id_i</name> 277 <unique>1</unique> 278 <field> 279 <name>perm_user_id</name> 280 <sorting>ascending</sorting> 281 </field> 282 <field> 283 <name>group_id</name> 284 <sorting>ascending</sorting> 285 </field> 286 </index> 287 288 </declaration> 289 290 </table> 291 292 <table> 293 294 <name>liveuser_perm_users</name> 295 296 <declaration> 297 298 <field> 299 <name>perm_user_id</name> 300 <type>integer</type> 301 <default>0</default> 302 </field> 303 304 <field> 305 <name>auth_user_id</name> 306 <type>text</type> 307 <length>32</length> 308 </field> 309 310 <field> 311 <name>auth_container_name</name> 312 <type>text</type> 313 <length>32</length> 314 </field> 315 316 <field> 317 <name>perm_type</name> 318 <type>integer</type> 319 </field> 320 321 <index> 322 <name>perm_user_id</name> 323 <unique>1</unique> 324 <field> 325 <name>perm_user_id</name> 326 <sorting>ascending</sorting> 327 </field> 328 </index> 329 330 <index> 331 <name>auth_id_i</name> 332 <unique>1</unique> 333 <field> 334 <name>auth_user_id</name> 335 <sorting>ascending</sorting> 336 </field> 337 <field> 338 <name>auth_container_name</name> 339 <sorting>ascending</sorting> 340 </field> 341 </index> 342 343 </declaration> 344 345 </table> 346 347 <table> 348 349 <name>liveuser_right_implied</name> 350 351 <declaration> 352 353 <field> 354 <name>right_id</name> 355 <type>integer</type> 356 <default>0</default> 357 </field> 358 359 <field> 360 <name>implied_right_id</name> 361 <type>integer</type> 362 <default>0</default> 363 </field> 364 365 <index> 366 <name>id_i</name> 367 <unique>1</unique> 368 <field> 369 <name>right_id</name> 370 <sorting>ascending</sorting> 371 </field> 372 <field> 373 <name>implied_right_id</name> 374 <sorting>ascending</sorting> 375 </field> 376 </index> 377 378 </declaration> 379 380 </table> 381 382 <table> 383 384 <name>liveuser_rights</name> 385 386 <declaration> 387 388 <field> 389 <name>right_id</name> 390 <type>integer</type> 391 <default>0</default> 392 </field> 393 394 <field> 395 <name>area_id</name> 396 <type>integer</type> 397 <default>0</default> 398 </field> 399 400 <field> 401 <name>right_define_name</name> 402 <type>text</type> 403 <length>32</length> 404 </field> 405 406 <field> 407 <name>has_implied</name> 408 <type>boolean</type> 409 </field> 410 411 <index> 412 <name>right_id</name> 413 <unique>1</unique> 414 <field> 415 <name>right_id</name> 416 <sorting>ascending</sorting> 417 </field> 418 </index> 419 420 <index> 421 <name>define_name_i</name> 422 <unique>1</unique> 423 <field> 424 <name>area_id</name> 425 <sorting>ascending</sorting> 426 </field> 427 <field> 428 <name>right_define_name</name> 429 <sorting>ascending</sorting> 430 </field> 431 </index> 432 433 </declaration> 434 435 </table> 436 437 <table> 438 439 <name>liveuser_translations</name> 440 441 <declaration> 442 443 <field> 444 <name>translation_id</name> 445 <type>integer</type> 446 <default>0</default> 447 </field> 448 449 <field> 450 <name>section_id</name> 451 <type>integer</type> 452 <default>0</default> 453 </field> 454 455 <field> 456 <name>section_type</name> 457 <type>integer</type> 458 <default>0</default> 459 </field> 460 461 <field> 462 <name>language_id</name> 463 <type>text</type> 464 <length>32</length> 465 </field> 466 467 <field> 468 <name>name</name> 469 <type>text</type> 470 <length>200</length> 471 </field> 472 473 <field> 474 <name>description</name> 475 <type>text</type> 476 <length>200</length> 477 </field> 478 479 <index> 480 <name>translation_id</name> 481 <unique>1</unique> 482 <field> 483 <name>translation_id</name> 484 <sorting>ascending</sorting> 485 </field> 486 </index> 487 488 <index> 489 <name>translation_i</name> 490 <unique>1</unique> 491 <field> 492 <name>section_id</name> 493 <sorting>ascending</sorting> 494 </field> 495 <field> 496 <name>section_type</name> 497 <sorting>ascending</sorting> 498 </field> 499 <field> 500 <name>language_id</name> 501 <sorting>ascending</sorting> 502 </field> 503 </index> 504 505 </declaration> 506 507 </table> 508 509 <table> 510 511 <name>liveuser_userrights</name> 512 513 <declaration> 514 515 <field> 516 <name>perm_user_id</name> 517 <type>integer</type> 518 <default>0</default> 519 </field> 520 521 <field> 522 <name>right_id</name> 523 <type>integer</type> 524 <default>0</default> 525 </field> 526 527 <field> 528 <name>right_level</name> 529 <type>integer</type> 530 </field> 531 532 <index> 533 <name>id_i</name> 534 <unique>1</unique> 535 <field> 536 <name>perm_user_id</name> 537 <sorting>ascending</sorting> 538 </field> 539 <field> 540 <name>right_id</name> 541 <sorting>ascending</sorting> 542 </field> 543 </index> 544 545 </declaration> 546 547 </table> 548 549 <table> 550 551 <name>liveuser_users</name> 552 553 <declaration> 554 555 <field> 556 <name>user_id</name> 557 <type>text</type> 558 <length>32</length> 559 </field> 560 561 <field> 562 <name>handle</name> 563 <type>text</type> 564 <length>32</length> 565 </field> 566 567 <field> 568 <name>passwd</name> 569 <type>text</type> 570 <length>32</length> 571 </field> 572 573 <field> 574 <name>lastlogin</name> 575 <type>timestamp</type> 576 </field> 577 578 <field> 579 <name>isactive</name> 580 <type>boolean</type> 581 </field> 582 583 <field> 584 <name>name</name> 585 <type>text</type> 586 <length>50</length> 587 </field> 588 589 <field> 590 <name>email</name> 591 <type>text</type> 592 <length>100</length> 593 </field> 594 595 <index> 596 <name>user_id</name> 597 <unique>1</unique> 598 <field> 599 <name>user_id</name> 600 <sorting>ascending</sorting> 601 </field> 602 </index> 603 604 </declaration> 605 606 </table> 607 608 <sequence> 609 <name>liveuser_applications</name> 610 <on> 611 <table>liveuser_applications</table> 612 <field>application_id</field> 613 </on> 614 </sequence> 615 616 <sequence> 617 <name>liveuser_areas</name> 618 <on> 619 <table>liveuser_areas</table> 620 <field>area_id</field> 621 </on> 622 </sequence> 623 624 <sequence> 625 <name>liveuser_groups</name> 626 <on> 627 <table>liveuser_groups</table> 628 <field>group_id</field> 629 </on> 630 </sequence> 631 632 <sequence> 633 <name>liveuser_perm_users</name> 634 <on> 635 <table>liveuser_perm_users</table> 636 <field>perm_user_id</field> 637 </on> 638 </sequence> 639 640 <sequence> 641 <name>liveuser_rights</name> 642 <on> 643 <table>liveuser_rights</table> 644 <field>right_id</field> 645 </on> 646 </sequence> 647 648 <sequence> 649 <name>liveuser_translations</name> 650 <on> 651 <table>liveuser_translations</table> 652 <field>translation_id</field> 653 </on> 654 </sequence> 655 656 <sequence> 657 <name>liveuser_users</name> 658 <on> 659 <table>liveuser_users</table> 660 <field>auth_user_id</field> 661 </on> 662 </sequence> 663 664</database> 665