Changeset 34


Ignore:
Timestamp:
Apr 17, 2007, 8:17:36 PM (12 years ago)
Author:
julian
Message:
  • current db structure
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/docs/dbstructure.sql

    r32 r34  
    196196  `posterID` mediumint(8) unsigned NOT NULL default '0',
    197197  `pollTitle` varchar(255) NOT NULL default '',
    198   `pollVotes` mediumint(8) unsigned NOT NULL default '0',
     198  `pollVotesCounter` mediumint(8) unsigned NOT NULL default '0',
    199199  `pollGuestNick` varchar(255) NOT NULL default '',
    200200  `pollStartTimestamp` int(10) unsigned NOT NULL default '0',
    201201  `pollEndTimestamp` int(10) unsigned NOT NULL default '0',
     202  `pollGuestsVote` tinyint(1) unsigned NOT NULL default '0',
     203  `pollGuestsViewResults` tinyint(1) unsigned NOT NULL default '1',
     204  `pollShowResultsAfterEnd` tinyint(1) unsigned NOT NULL default '0',
    202205  PRIMARY KEY  (`pollID`),
    203   KEY `topic_id_poll_id` (`topicID`,`pollID`),
     206  UNIQUE KEY `topicID` (`topicID`),
    204207  KEY `poster_id` (`posterID`)
    205208) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Note: See TracChangeset for help on using the changeset viewer.