DIR : /home/kozerus/public_html/go/dgs/dgs.db3

/home/kozerus/public_html/go/dgs

 fid  varchar,
 Voter_ID  varchar,
 Points tiny varchar DEFAULT '0',
 Lastchanged datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
 ID  varchar,
 Parent  varchar DEFAULT '0',
 Level tinyint UNSIGNED NOT NULL DEFAULT '0',
 SortOrder small varchar DEFAULT '0',
 Question  varchar DEFAULT '0',
 Answer  varchar DEFAULT '0',
 Flags tinyint UNSIGNED NOT NULL DEFAULT '128',
 Reference varchar(255) NOT NULL DEFAULT ''
CREATE TABLE Contacts (
 uid  varchar,
 cid  varchar,
 SystemFlags smallint UNSIGNED NOT NULL DEFAULT '0',
 UserFlags int UNSIGNED NOT NULL DEFAULT '0',
 Created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Lastchanged datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Notes varchar(255) NOT NULL DEFAULT ''
 User_ID  varchar,
 StatusFlags small varchar DEFAULT '3',
 StatusFolders char(40) NOT NULL DEFAULT '',
 ForumFlags tinyint UNSIGNED NOT NULL DEFAULT '8',
 ColumnsStatusGames  varchar DEFAULT '-1',
 ColumnsStatusTournaments  varchar DEFAULT '-1',
 ColumnsWaitingroom  varchar DEFAULT '-1',
 ColumnsUsers  varchar DEFAULT '-1',
 ColumnsOpponents  varchar DEFAULT '-1',
 ColumnsContacts  varchar DEFAULT '-1',
 ColumnsGamesRunningAll  varchar DEFAULT '-1',
 ColumnsGamesRunningAll2  varchar DEFAULT '-1',
 ColumnsGamesRunningUser  varchar DEFAULT '-1',
 ColumnsGamesRunningUser2  varchar DEFAULT '-1',
 ColumnsGamesFinishedAll  varchar DEFAULT '-1',
 ColumnsGamesFinishedAll2  varchar DEFAULT '-1',
 ColumnsGamesFinishedUser  varchar DEFAULT '-1',
 ColumnsGamesFinishedUser2  varchar DEFAULT '-1',
 ColumnsGamesObserved  varchar DEFAULT '-1',
 ColumnsGamesObserved2  varchar DEFAULT '-1',
 ColumnsGamesObservedAll  varchar DEFAULT '-1',
 ColumnsGamesObservedAll2  varchar DEFAULT '-1',
 ColumnsBulletinList  varchar DEFAULT '-1',
 ColumnsFeatureList  varchar DEFAULT '-1',
 ColumnsTournaments  varchar DEFAULT '-1',
 ColumnsTournamentParticipants  varchar DEFAULT '-1',
 ColumnsTDTournamentParticipants  varchar DEFAULT '-1',
 ColumnsTournamentResults  varchar DEFAULT '-1',
 ColumnsTournamentLadderView  varchar DEFAULT '-1',
 ColumnsTournamentPoolView  varchar DEFAULT '-1'
 User_ID  varchar,
 Stonesize varchar,
 Woodcolor  varchar,
 BoardFlags varchar,
 Boardcoords varchar,
 MoveNumbers varchar,
 MoveModulo varchar,
 NotesSmallHeight varchar,
 NotesSmallWidth varchar,
 NotesSmallMode varchar,
 NotesLargeHeight varchar,
 NotesLargeWidth varchar,
 NotesLargeMode varchar,
 NotesCutoff varchar
 ID small varchar,
 Ticks  varchar,
 Lastchanged varchar,
 Finished varchar
 bid  varchar,
 uid  varchar
 bid  varchar,
 uid  varchar
 ID  varchar,
 uid  varchar, 
 LockVersion varchar,
 Category varchar,
 Status varchar,
 TargetType varchar,
 TargetRatingMin  varchar,
 TargetRating varchar,Max
 Flags varchar,
 PublishTime varchar,
 ExpireTime varchar,
 tid varchar,
 gid varchar,
 CountReads varchar,
 AdminNote varchar,
 Subject varchar,
 Text varchar,
 Lastchanged varchar
 ID  varchar,
 uid  varchar,
 Category varchar,
 Text varchar,
 SortOrder varchar
 ID  varchar,
 uid  varchar,
 Handle varchar,
 Message varchar,
 Date varchar,
 IP varchar
 ID  varchar,
 uid  varchar,
 Folder_nr tiny varchar DEFAULT '0',
 Name char(40) NOT NULL,
 BGColor char(8) NOT NULL DEFAULT 'f7f5e3FF',
 FGColor char(6) NOT NULL DEFAULT '000000'
 ID  varchar,
 uid  varchar,
 Created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Changes tiny varchar DEFAULT '0',
 Rating double NOT NULL DEFAULT '-9999'
 ID  varchar,
 uid  varchar,
 gid  varchar
 uid  varchar DEFAULT '0',
 SlotTime smallint UNSIGNED NOT NULL DEFAULT '0',
 SlotWDay tiny varchar DEFAULT '0',
 SlotWeek tiny varchar DEFAULT '0',
 Counter mediumint UNSIGNED NOT NULL DEFAULT '0'
 ID  varchar,
 gid  varchar,
 MoveNr smallint UNSIGNED NOT NULL,
 Stone tinyint UNSIGNED NOT NULL DEFAULT '0',
 PosX tiny varchar,
 PosY tiny varchar,
 Hours smallint UNSIGNED NOT NULL
 gid  varchar,
 MoveNr smallint UNSIGNED NOT NULL DEFAULT '0',
 Text varchar NOT NULL
 ID  varchar,
 Parent  varchar DEFAULT '0',
 Level tinyint UNSIGNED NOT NULL DEFAULT '0',
 SortOrder small varchar DEFAULT '0',
 Question  varchar DEFAULT '0',
 Answer  varchar DEFAULT '0',
 Flags tinyint UNSIGNED NOT NULL DEFAULT '128',
 Reference varchar(255) NOT NULL DEFAULT ''
 uid  varchar DEFAULT '0',
 Page char(4) NOT NULL DEFAULT '',
 IP char(16) NOT NULL,
 Counter int UNSIGNED NOT NULL DEFAULT '0',
 Created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Lastchanged datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
 ID  varchar,
 Parent  varchar DEFAULT '0',
 Level tinyint UNSIGNED NOT NULL DEFAULT '0',
 SortOrder small varchar DEFAULT '0',
 Question  varchar DEFAULT '0',
 Answer  varchar DEFAULT '0',
 Flags tinyint UNSIGNED NOT NULL DEFAULT '128',
 Reference varchar(255) NOT NULL DEFAULT ''
 uid  varchar,
 oid  varchar,
 Running smallint UNSIGNED NOT NULL DEFAULT '0',
 Finished mediumint UNSIGNED NOT NULL DEFAULT '0'
 gid  varchar,
 uid  varchar,
 Priority small varchar DEFAULT '0'
 gid  varchar,
 uid  varchar,
 Lastchanged datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 SgfData blob NOT NULL
 ID small varchar,
 Name char(40) NOT NULL DEFAULT '',
 Description char(128) NOT NULL DEFAULT '',
 SortOrder tinyint UNSIGNED NOT NULL DEFAULT '0',
 Options int UNSIGNED NOT NULL DEFAULT '0',
 LastPost  varchar DEFAULT '0',
 Updated datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 ThreadsInForum mediumint UNSIGNED NOT NULL DEFAULT '0',
 PostsInForum mediumint UNSIGNED NOT NULL DEFAULT '0'
 User_ID  varchar DEFAULT '0',
 Forum_ID small varchar DEFAULT '0',
 Thread_ID  varchar DEFAULT '0',
 Time datetime NOT NULL,
 HasNew tiny varchar DEFAULT '0'
 ID  varchar,
 User_ID  varchar,
 Thread_ID  varchar,
 Post_ID  varchar,
 Time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Action varchar(40) NOT NULL,
 IP varchar(16) NOT NULL DEFAULT ''
 tid  varchar,
 rid  varchar,
 uid  varchar,
 Flags tinyint UNSIGNED NOT NULL DEFAULT '0',
 Created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 RankChanged datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Rank smallint UNSIGNED NOT NULL DEFAULT '0',
 BestRank smallint UNSIGNED NOT NULL DEFAULT '0',
 StartRank smallint UNSIGNED NOT NULL DEFAULT '0',
 PeriodRank smallint UNSIGNED NOT NULL DEFAULT '0',
 HistoryRank smallint UNSIGNED NOT NULL DEFAULT '0',
 ChallengesIn tinyint UNSIGNED NOT NULL DEFAULT '0',
 ChallengesOut tinyint UNSIGNED NOT NULL DEFAULT '0',
 SeqWins smallint UNSIGNED NOT NULL DEFAULT '0',
 SeqWinsBest smallint UNSIGNED NOT NULL DEFAULT '0'
 tid  varchar,
 Property smallint UNSIGNED NOT NULL,
 IntValue  varchar DEFAULT '0',
 DateValue datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Lastchanged datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 ChangedBy char(54) NOT NULL DEFAULT ''
 tid  varchar,
 uid  varchar,
 Flags smallint UNSIGNED NOT NULL DEFAULT '0',
 Comment varchar(255) NOT NULL DEFAULT ''
 ID  varchar,
 User_ID  varchar,
 Name varchar(64) NOT NULL,
 ColorBG char(6) NOT NULL,
 ColorFG char(6) NOT NULL
 User_ID  varchar,
 Tag_ID  varchar,
 Post_ID  varchar
 soid  varchar,
 uid  varchar DEFAULT '0',
 Points tiny varchar DEFAULT '0'
)X!!
}tableSurveyUserSurveyUser#CREATE TABLE SurveyUser (
 sid  varchar,
 uid  varchar
 ID  varchar,
 sid  varchar DEFAULT '0',
 Tag tinyint UNSIGNED NOT NULL DEFAULT '0',
 SortOrder tinyint UNSIGNED NOT NULL DEFAULT '0',
 MinPoints tiny varchar DEFAULT '0',
 Score  varchar DEFAULT '0',
 Title varchar(255) NOT NULL DEFAULT '',
 Text varchar NOT NULL
 ID  varchar,
 Time datetime NOT NULL,
 Hits  varchar,
 Users  varchar,
 Moves  varchar,
 MovesFinished  varchar,
 MovesRunning  varchar,
 Games  varchar,
 GamesFinished  varchar,
 GamesRunning  varchar,
 Activity  varchar
 ID  varchar,
 uid  varchar,
 Name varchar(40) NOT NULL DEFAULT '',
 Size tinyint UNSIGNED NOT NULL,
 Flags tinyint UNSIGNED NOT NULL DEFAULT '0',
 Snapshot varchar(216) NOT NULL DEFAULT '',
 Notes varchar NOT NULL,
 Created datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Lastchanged datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
 ID  varchar,
 uid  varchar,
 gid  varchar,
 Time datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Rating double NOT NULL,
 RatingMin double NOT NULL,
 RatingMax double NOT NULL,
 RatingDiff float NOT NULL
 Page char(64) NOT NULL,
 Group_ID  varchar
 ID  varchar,
 Language char(32) NOT NULL,
 Name char(32) NOT NULL
 ID  varchar,
 Groupname char(32) NOT NULL
 Text_ID  varchar,
 Group_ID  varchar
 uid  varchar,
 tid  varchar,
 VisitTime datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 VisitType tinyint UNSIGNED NOT NULL
 ID  varchar,
 tid  varchar,
 uid  varchar,
 rid  varchar DEFAULT '0',
 Rating double NOT NULL DEFAULT '-9999',
 Type tinyint UNSIGNED NOT NULL DEFAULT '0',
 Round tinyint UNSIGNED NOT NULL DEFAULT '1',
 StartTime datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 EndTime datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Result medium varchar DEFAULT '0',
 Rank smallint UNSIGNED NOT NULL DEFAULT '0',
 Comment varchar(128) NOT NULL DEFAULT '',
 Note varchar(255) NOT NULL DEFAULT ''
 ID  varchar,
 tid  varchar,
 Round tinyint UNSIGNED NOT NULL,
 Tier tinyint UNSIGNED NOT NULL DEFAULT '1',
 Pool smallint UNSIGNED NOT NULL,
 uid  varchar DEFAULT '0',
 Rank tiny varchar DEFAULT '-100'
 ID  varchar,
 tid  varchar,
 uid  varchar,
 Date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 Type char(2) NOT NULL,
 Object varchar(16) NOT NULL DEFAULT 'T',
 Action varchar(16) NOT NULL,
 actuid  varchar DEFAULT '0',
 Message varchar NOT NULL
)