Changeset 32


Ignore:
Timestamp:
Apr 17, 2007, 11:31:16 AM (12 years ago)
Author:
julian
Message:
  • current db structure
  • two small design fixes
Location:
trunk
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/docs/dbstructure.sql

    r29 r32  
     1# HeidiSQL Dump
     2#
     3# --------------------------------------------------------
     4# Host:                 localhost
     5# Database:             tbb2test
     6# Server version:       4.1.14-nt
     7# Server OS:            Win32
     8# Target-Compatibility: MySQL 4.1
     9# Extended INSERTs:     Y
     10# max_allowed_packet:   1048576
     11# HeidiSQL version:     3.0 Revision: 572
     12# --------------------------------------------------------
     13
    114/*!40100 SET CHARACTER SET latin1*/;
    215
     
    122135
    123136CREATE TABLE /*!32312 IF NOT EXISTS*/ `tbb2_groups_members` (
    124   `GroupID` smallint(5) unsigned NOT NULL default '0',
    125   `MemberID` mediumint(8) unsigned NOT NULL default '0',
    126   `MemberStatus` tinyint(1) unsigned NOT NULL default '0',
    127   KEY `group_id` (`GroupID`),
    128   KEY `member_id_group_id` (`MemberID`,`GroupID`)
     137  `groupID` smallint(5) unsigned NOT NULL default '0',
     138  `memberID` mediumint(8) unsigned NOT NULL default '0',
     139  `memberStatus` tinyint(1) unsigned NOT NULL default '0',
     140  KEY `group_id` (`groupID`),
     141  KEY `member_id_group_id` (`memberID`,`groupID`)
    129142) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    130143
     
    179192
    180193CREATE TABLE /*!32312 IF NOT EXISTS*/ `tbb2_polls` (
    181   `poll_id` mediumint(8) unsigned NOT NULL auto_increment,
    182   `topic_id` mediumint(8) unsigned NOT NULL default '0',
    183   `poster_id` mediumint(8) unsigned NOT NULL default '0',
    184   `poll_title` varchar(255) NOT NULL default '',
    185   `poll_votes` mediumint(8) unsigned NOT NULL default '0',
    186   `poll_guest_nick` varchar(255) NOT NULL default '',
    187   `poll_start_time` int(10) unsigned NOT NULL default '0',
    188   `poll_end_time` int(10) unsigned NOT NULL default '0',
    189   PRIMARY KEY  (`poll_id`),
    190   KEY `topic_id_poll_id` (`topic_id`,`poll_id`),
    191   KEY `poster_id` (`poster_id`)
     194  `pollID` mediumint(8) unsigned NOT NULL auto_increment,
     195  `topicID` mediumint(8) unsigned NOT NULL default '0',
     196  `posterID` mediumint(8) unsigned NOT NULL default '0',
     197  `pollTitle` varchar(255) NOT NULL default '',
     198  `pollVotes` mediumint(8) unsigned NOT NULL default '0',
     199  `pollGuestNick` varchar(255) NOT NULL default '',
     200  `pollStartTimestamp` int(10) unsigned NOT NULL default '0',
     201  `pollEndTimestamp` int(10) unsigned NOT NULL default '0',
     202  PRIMARY KEY  (`pollID`),
     203  KEY `topic_id_poll_id` (`topicID`,`pollID`),
     204  KEY `poster_id` (`posterID`)
    192205) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    193206
     
    199212
    200213CREATE TABLE /*!32312 IF NOT EXISTS*/ `tbb2_polls_options` (
    201   `poll_id` mediumint(8) unsigned NOT NULL default '0',
    202   `option_id` smallint(5) unsigned NOT NULL default '0',
    203   `option_title` varchar(255) NOT NULL default '',
    204   `option_votes` mediumint(8) NOT NULL default '0',
    205   KEY `option_id` (`option_id`),
    206   KEY `poll_id_option_id` (`poll_id`,`option_id`)
     214  `pollID` mediumint(8) unsigned NOT NULL default '0',
     215  `optionID` smallint(5) unsigned NOT NULL default '0',
     216  `optionTitle` varchar(255) NOT NULL default '',
     217  `optionVotesCounter` mediumint(8) NOT NULL default '0',
     218  KEY `option_id` (`optionID`),
     219  KEY `poll_id_option_id` (`pollID`,`optionID`)
    207220) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    208221
     
    214227
    215228CREATE TABLE /*!32312 IF NOT EXISTS*/ `tbb2_polls_votes` (
    216   `poll_id` mediumint(8) unsigned NOT NULL default '0',
    217   `voter_id` mediumint(8) unsigned NOT NULL default '0',
    218   KEY `poll_id` (`poll_id`),
    219   KEY `voter_id_poll_id` (`voter_id`,`poll_id`)
     229  `pollID` mediumint(8) unsigned NOT NULL default '0',
     230  `voterID` mediumint(8) unsigned NOT NULL default '0',
     231  KEY `poll_id` (`pollID`),
     232  KEY `voter_id_poll_id` (`voterID`,`pollID`)
    220233) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    221234
     
    324337
    325338CREATE TABLE /*!32312 IF NOT EXISTS*/ `tbb2_search_results` (
    326   `search_id` varchar(32) NOT NULL default '',
    327   `session_id` varchar(32) NOT NULL default '',
    328   `search_last_access` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    329   `search_results` text NOT NULL,
    330   PRIMARY KEY  (`search_id`)
     339  `searchID` varchar(32) NOT NULL default '',
     340  `sessionID` varchar(32) NOT NULL default '',
     341  `searchLastAccess` timestamp NOT NULL default '0000-00-00 00:00:00',
     342  `searchResults` text NOT NULL,
     343  PRIMARY KEY  (`searchID`)
    331344) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    332345
     
    355368
    356369CREATE TABLE /*!32312 IF NOT EXISTS*/ `tbb2_smilies` (
    357   `SmileyID` smallint(5) unsigned NOT NULL auto_increment,
    358   `SmileyType` tinyint(1) unsigned NOT NULL default '0',
    359   `SmileyFileName` varchar(255) NOT NULL default '',
    360   `SmileySynonym` varchar(255) NOT NULL default '',
    361   `SmileyStatus` tinyint(1) unsigned NOT NULL default '0',
    362   PRIMARY KEY  (`SmileyID`)
     370  `smileyID` smallint(5) unsigned NOT NULL auto_increment,
     371  `smileyType` tinyint(1) unsigned NOT NULL default '0',
     372  `smileyFileName` varchar(255) NOT NULL default '',
     373  `smileySynonym` varchar(255) NOT NULL default '',
     374  `smileyStatus` tinyint(1) unsigned NOT NULL default '0',
     375  PRIMARY KEY  (`smileyID`)
    363376) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    364377
     
    449462
    450463CREATE TABLE /*!32312 IF NOT EXISTS*/ `tbb2_users_locks` (
    451   `user_id` mediumint(8) unsigned NOT NULL default '0',
    452   `lock_type` tinyint(1) unsigned NOT NULL default '0',
    453   `lock_start_time` int(10) unsigned NOT NULL default '0',
    454   `lock_dur_time` int(10) unsigned NOT NULL default '0',
    455   KEY `user_id` (`user_id`),
    456   KEY `lock_type_user_id` (`lock_type`,`user_id`)
    457 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    458 
     464  `userID` mediumint(8) unsigned NOT NULL default '0',
     465  `lockType` tinyint(1) unsigned NOT NULL default '0',
     466  `lockStartTimestamp` int(10) unsigned NOT NULL default '0',
     467  `lockEndTimestamp` int(10) unsigned NOT NULL default '0',
     468  KEY `user_id` (`userID`),
     469  KEY `lock_type_user_id` (`lockType`,`userID`)
     470) ENGINE=MyISAM DEFAULT CHARSET=latin1;
     471
  • trunk/languages/de/EditProfile.language

    r26 r32  
    77Memo = Notizzettel
    88Update_memo = Notizzettel aktualisieren
    9 memo_info = Hier können Sie sich beliebige Dinge notieren und abspeichern, um sie später wieder abzurufen. Diese Notizzettel ist nur Ihnen zugänglich.
     9memo_info = Hier können Sie sich beliebige Dinge notieren und abspeichern, um sie später wieder abzurufen. Dieser Notizzettel ist nur Ihnen zugänglich.
    1010Memo_updated = Notitzzettel aktualisiert
    1111No_topic_subscriptions_found = -- Keine Themenabos gefunden --
  • trunk/templates/std/files/EditProfileMemo.tpl

    r17 r32  
    44{if $memoWasUpdated == TRUE}<tr><td class="CellInfoBox"><span class="FontInfoBox">{$modules.Language->getString('message_memo_updated')}</span></td></tr>{/if}
    55<tr><td class="CellStd">
    6  <div class="DivInfoBox"><span class="FontInfoBox"><img src="templates/std/templates/images/lightbulb_a.gif" style="vertical-align:middle; padding:5px;"/>{$modules.Language->getString('memo_info')}</span></div>
     6 <div class="DivInfoBox"><span class="FontInfoBox"><img src="{$modules.Template->getTD()}/images/icons/Info.png" style="vertical-align:middle; padding:5px;"/>{$modules.Language->getString('memo_info')}</span></div>
    77 <textarea class="FormTextArea" cols="150" rows="25" name="p_user_memo" style="width:99%;">{$p.userMemo}</textarea>
    88</td></tr>
Note: See TracChangeset for help on using the changeset viewer.