Changeset 9969
- Timestamp:
- 11/18/08 09:28:59 (2 months ago)
- Files:
-
- trunk/jaws/html/install/schema/schema.xml (modified) (13 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/jaws/html/install/schema/schema.xml
r9240 r9969 7 7 8 8 <table> 9 <name><variable>table_prefix</variable> components</name>9 <name><variable>table_prefix</variable>registry</name> 10 10 <declaration> 11 11 … … 28 28 <type>integer</type> 29 29 <length>1</length> 30 <notnull>true</notnull>31 </field>32 33 <field>34 <name>enabled</name>35 <type>boolean</type>36 <notnull>true</notnull>37 <default>true</default>38 </field>39 40 <index>41 <name><variable>table_prefix</variable>components_name</name>42 <unique>true</unique>43 <field>44 <name>comp_name</name>45 </field>46 </index>47 48 </declaration>49 </table>50 51 <table>52 <name><variable>table_prefix</variable>registry</name>53 <declaration>54 55 <field>56 <name>id</name>57 <type>integer</type>58 <notnull>true</notnull>59 <autoincrement>true</autoincrement>60 </field>61 62 <field>63 <name>comp_id</name>64 <type>integer</type>65 30 <notnull>true</notnull> 66 31 </field> … … 87 52 <unique>true</unique> 88 53 <field> 89 <name>comp_id</name> 54 <name>comp_name</name> 55 </field> 56 <field> 57 <name>comp_type</name> 90 58 </field> 91 59 <field> … … 94 62 </index> 95 63 96 <foreign> 97 <name>registry_comp_frgn</name> 98 <field>comp_id</field> 99 <references> 100 <table><variable>table_prefix</variable>components</table> 101 <field>id</field> 102 </references> 103 <ondelete>cascade</ondelete> 104 </foreign> 64 <index> 65 <name><variable>table_prefix</variable>reg_comp_name</name> 66 <field> 67 <name>comp_name</name> 68 </field> 69 </index> 70 71 <index> 72 <name><variable>table_prefix</variable>reg_key_name</name> 73 <field> 74 <name>key_name</name> 75 </field> 76 </index> 105 77 106 78 </declaration> … … 119 91 120 92 <field> 121 <name>comp_id</name> 122 <type>integer</type> 93 <name>comp_name</name> 94 <type>text</type> 95 <length>32</length> 96 <notnull>true</notnull> 97 </field> 98 99 <field> 100 <name>comp_type</name> 101 <type>integer</type> 102 <length>1</length> 123 103 <notnull>true</notnull> 124 104 </field> … … 145 125 <unique>true</unique> 146 126 <field> 147 <name>comp_id</name> 127 <name>comp_name</name> 128 </field> 129 <field> 130 <name>comp_type</name> 148 131 </field> 149 132 <field> … … 152 135 </index> 153 136 154 <foreign> 155 <name>acl_comp_frgn</name> 156 <field>comp_id</field> 157 <references> 158 <table><variable>table_prefix</variable>components</table> 159 <field>id</field> 160 </references> 161 <ondelete>cascade</ondelete> 162 </foreign> 137 <index> 138 <name><variable>table_prefix</variable>acl_comp_name</name> 139 <field> 140 <name>comp_name</name> 141 </field> 142 </index> 143 144 <index> 145 <name><variable>table_prefix</variable>acl_key_name</name> 146 <field> 147 <name>key_name</name> 148 </field> 149 </index> 163 150 164 151 </declaration> … … 248 235 <table> 249 236 <name><variable>table_prefix</variable>shouters</name> 237 <was><variable>table_prefix</variable>gadget_shouters</was> 250 238 <declaration> 251 239 … … 267 255 <field> 268 256 <name>event</name> 257 <was>gadget_call</was> 269 258 <type>text</type> 270 259 <length>32</length> … … 297 286 <table> 298 287 <name><variable>table_prefix</variable>listeners</name> 288 <was><variable>table_prefix</variable>gadget_listeners</was> 299 289 <declaration> 300 290 … … 316 306 <field> 317 307 <name>event</name> 308 <was>gadget_call</was> 318 309 <type>text</type> 319 310 <length>32</length> … … 324 315 <field> 325 316 <name>method</name> 317 <was>gadget_method</was> 326 318 <type>text</type> 327 319 <length>32</length> … … 355 347 </table> 356 348 349 <table> 350 <name><variable>table_prefix</variable>comments</name> 351 <declaration> 352 353 <field> 354 <name>id</name> 355 <type>integer</type> 356 <notnull>true</notnull> 357 <autoincrement>true</autoincrement> 358 </field> 359 360 <field> 361 <name>parent</name> 362 <type>integer</type> 363 <notnull>true</notnull> 364 <default>0</default> 365 </field> 366 367 <field> 368 <name>gadget_reference</name> 369 <type>integer</type> 370 <notnull>true</notnull> 371 <default>0</default> 372 </field> 373 374 <field> 375 <name>gadget</name> 376 <type>text</type> 377 <length>80</length> 378 <notnull>true</notnull> 379 <default></default> 380 </field> 381 382 <field> 383 <name>name</name> 384 <type>text</type> 385 <length>255</length> 386 <notnull>true</notnull> 387 <default></default> 388 </field> 389 390 <field> 391 <name>email</name> 392 <type>text</type> 393 <length>255</length> 394 <notnull>true</notnull> 395 <default></default> 396 </field> 397 398 <field> 399 <name>url</name> 400 <type>text</type> 401 <length>120</length> 402 <notnull>true</notnull> 403 <default></default> 404 </field> 405 406 <field> 407 <name>ip</name> 408 <type>text</type> 409 <length>20</length> 410 <notnull>true</notnull> 411 <default>127.0.0.1</default> 412 </field> 413 414 <field> 415 <name>title</name> 416 <type>text</type> 417 <length>255</length> 418 <notnull>true</notnull> 419 <default></default> 420 </field> 421 422 <field> 423 <name>msg_txt</name> 424 <was>message</was> 425 <type>text</type> 426 </field> 427 428 <field> 429 <name>msg_key</name> 430 <was>message_key</was> 431 <type>text</type> 432 <length>32</length> 433 </field> 434 435 <field> 436 <name>createtime</name> 437 <type>timestamp</type> 438 </field> 439 440 <field> 441 <name>replies</name> 442 <type>integer</type> 443 <notnull>true</notnull> 444 <default>0</default> 445 </field> 446 447 <field> 448 <name>status</name> 449 <type>text</type> 450 <length>10</length> 451 <notnull>true</notnull> 452 <default>approved</default> 453 </field> 454 455 <index> 456 <name><variable>table_prefix</variable>comments</name> 457 <primary>true</primary> 458 <field> 459 <name>id</name> 460 </field> 461 </index> 462 463 <index> 464 <name><variable>table_prefix</variable>comments_g</name> 465 <field> 466 <name>gadget</name> 467 </field> 468 </index> 469 470 <index> 471 <name><variable>table_prefix</variable>comments_gr</name> 472 <field> 473 <name>gadget_reference</name> 474 </field> 475 </index> 476 477 <index> 478 <name><variable>table_prefix</variable>comments_p</name> 479 <field> 480 <name>parent</name> 481 </field> 482 </index> 483 484 <index> 485 <name><variable>table_prefix</variable>comments_mk</name> 486 <field> 487 <name>msg_key</name> 488 </field> 489 </index> 490 491 </declaration> 492 </table> 493 357 494 </database>
