IMPRESSUM KONTAKT LETZTE AKTIONEN

Datenbankstruktur

Die zentrale Datenbank ist nach dem Vorbild der "table by concret class" aufgebaut.

Folgende Elemente der abstrakten Vaterklasse sind in jeder Tabelle enthalten:

  • read_cap_id int(10) unsigned NOT NULL

  • write_cap_id int(10) unsigned NOT NULL

  • pub_read tinyint(1) unsigned NOT NULL default '0'

  • pub_write tinyint(1) unsigned NOT NULL default '0'

  • source_client_id int(10) unsigned NOT NULL

  • id_at_source_client int(10) unsigned NOT NULL

  • original_entry int(10) unsigned NOT NULL

  • created datetime NOT NULL

  • changed datetime NOT NULL

  • views int(10) unsigned default '0'

  • user_id int(10) unsigned default NULL

 

Die Tabellen werden über Nummern identifiziert. Damit diese nun einfacher zu Lesen sind, wurde die dt.ini-Datei integriert, die diese Zahlen in Namen ändert.

dt.ini:

tag = 18
comment = 34
weblog = 2
weblog_article = 3
weblog_image = 5
weblog_bookmark = 4
weblog_video = 41
questbook = 43
keyword = 45
keyword_relation= 44
keyword_interest= 48
event = 29
event_date = 28
event_calendar = 27
location = 24
artist = 31
artist_detail = 54
artistdetail = 54
artist_members = 35
event_artist_relation = 26
theme = 6
shoutbox = 46
guestbook = 43
image = 30

forumtheme = 36
forumposting = 37
imagetag = 18
keywordtag_relation = 49

weblog_mashup = 50
license = 51
weblog_blogroll = 52
weblog_category = 53

weblog_article_artist = 55
location_artist = 56

upload = 57
offer = 61
objects_tag = 62
action = 64
artist_location = 65

production = 68
season = 69
production_presse = 81
artistfreetext = 82
artistsfreetex = 82

profileimage = 71
profile = 72
profile_freecontent = 73
ecard = 74
productionartist = 83

actorpart = 99