-- phpMyAdmin SQL Dump
-- version 2.11.2.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Erstellungszeit: 04. Juni 2010 um 22:34
-- Server Version: 4.1.22
-- PHP-Version: 5.3.2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Datenbank: `ccforum_2`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `animations`
--
CREATE TABLE IF NOT EXISTS `animations` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE ascii_bin NOT NULL,
`comment` varchar(500) COLLATE ascii_bin NOT NULL,
`filesrc` varchar(50) COLLATE ascii_bin NOT NULL,
`srctype` varchar(50) COLLATE ascii_bin NOT NULL,
`rank` varchar(50) COLLATE ascii_bin NOT NULL,
`downloads` int(50) NOT NULL,
`uppedby` varchar(50) COLLATE ascii_bin NOT NULL,
`previewimage` varchar(50) COLLATE ascii_bin NOT NULL,
`voters` varchar(50) COLLATE ascii_bin NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin AUTO_INCREMENT=1 ;
--
-- Daten für Tabelle `animations`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `comments`
--
CREATE TABLE IF NOT EXISTS `comments` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`content` varchar(250) NOT NULL,
`author` varchar(25) NOT NULL,
`when` varchar(100) NOT NULL,
`animation` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Daten für Tabelle `comments`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `pms`
--
CREATE TABLE IF NOT EXISTS `pms` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`pmtitle` varchar(50) COLLATE ascii_bin NOT NULL,
`author` varchar(50) COLLATE ascii_bin NOT NULL,
`getter` varchar(50) COLLATE ascii_bin NOT NULL,
`content` varchar(1000) COLLATE ascii_bin NOT NULL,
`alrread` varchar(20) COLLATE ascii_bin NOT NULL DEFAULT 'unread',
`sentdate` varchar(60) COLLATE ascii_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii COLLATE=ascii_bin AUTO_INCREMENT=6 ;
--
-- Daten für Tabelle `pms`
--
INSERT INTO `pms` (`id`, `pmtitle`, `author`, `getter`, `content`, `alrread`, `sentdate`) VALUES
(1, 'Welcome to CC!', 'System', 'Tobse', 'Hi Tobse,<br>Welcome to CreatedCreativity!', 'read', 'at 11.12.2009 on 18:37'),
(2, 'Welcome to CC!', 'System', 'MasterMilo', 'Hi MasterMilo,<br>Welcome to CreatedCreativity!', 'unread', 'at 12.12.2009 on 12:32'),
(3, 'Hi', 'Tobse', 'Yannik', 'Hi, du bist ja on! Oder spinnt das sys o.O', 'read', 'at 16.12.2009 on 11:11'),
(4, 'Accountchanges', 'System', 'Yannik', 'Tobse has editet your homepgae-url. Reason: http:// ;).', 'unread', 'at 21.03.2010 on 13:47'),
(5, 'Welcome to CC!', 'System', 'Dummyus-', 'Hi Dummyus-,<br>Welcome to CreatedCreativity!', 'unread', 'at 20.05.2010 on 20:24');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) DEFAULT NULL,
`password` varchar(50) DEFAULT NULL,
`uploads` varchar(50) DEFAULT NULL,
`downloads` varchar(50) DEFAULT NULL,
`avatar` varchar(50) DEFAULT NULL,
`about_me` varchar(500) DEFAULT NULL,
`rights` varchar(50) DEFAULT NULL,
`mail` varchar(100) DEFAULT NULL,
`rank` varchar(50) DEFAULT NULL,
`regdate` varchar(50) NOT NULL,
`intrests` varchar(200) NOT NULL,
`sex` varchar(50) NOT NULL,
`homeurl` varchar(50) NOT NULL,
`birthday` varchar(50) NOT NULL,
`icq` varchar(9) NOT NULL DEFAULT 'No ICQ',
`status` varchar(20) NOT NULL DEFAULT 'offline',
`lastvisit` int(11) NOT NULL,
`lastlogin` int(11) NOT NULL,
`wholepms` int(20) NOT NULL DEFAULT '0',
`unreadpm` varchar(200) NOT NULL DEFAULT '0',
`sendetpms` varchar(20) NOT NULL DEFAULT '0',
`userstyle` varchar(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Daten für Tabelle `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `uploads`, `downloads`, `avatar`, `about_me`, `rights`, `mail`, `rank`, `regdate`, `intrests`, `sex`, `homeurl`, `birthday`, `icq`, `status`, `lastvisit`, `lastlogin`, `wholepms`, `unreadpm`, `sendetpms`, `userstyle`) VALUES
(1, 'Tobse', 'ac6425f70061a396c977aca7c33f01ae', '0', '0', 'avatars/Tobse.jpg', 'Im the inactive coder of the Portal....', 'Admin', 'trash95@online.de', 'Newbie Aniamtor', '11.12.2009', 'My intrest are FUCKING unintresting!', 'Not entered', 'http://thememania.net', '22:11:1995', '110', 'offline', 1274379823, 1274379797, 0, '0', '0', '3'),
(2, 'MasterMilo', '21f661da1ee63a61e5735fdf61b8ca08', '0', '0', 'avatars/MasterMilo.jpg', 'Not entered.', 'Admin', 'ricci.fuda@gmx.de', 'Newbie Aniamtor', '12.12.2009', 'Not entered', 'Not entered', 'MasterMilo has no homepage', 'MasterMilo did not enter a birthday', 'NO ICQ', 'unactivated', 1260617532, 0, 0, '0', '0', '3'),
(3, 'Warlords', '21f661da1ee63a61e5735fdf61b8ca08', '0', '0', 'avatars/Warlords.jpg', 'Not entered.', 'Admin', 'waralords@none.de', 'Normal', 'today', 'Not entered.', 'male', 'none', 'none', 'No ICQ', 'offline', 0, 0, 0, '0', '0', '3'),
(4, 'Yannik', '098f6bcd4621d373cade4e832627b4f6', '0', '0', 'avatars/no1.jpg', '-', 'normal', 'not-defined', 'normal', '0', '-', 'male', 'http://www.mactouch.eu', 'today :P', 'No ICQ', 'offline', 1260958326, 1260958316, 0, '0', '0', '3'),
(5, 'Dummyuser', '275876e34cf609db118f3d84b799a790', '0', '0', 'avatars/Dummyus-.jpg', 'Not entered.', 'normal', 'mail@thememania.net', 'Newbie Aniamtor', '20.05.2010', 'Not entered', 'Not entered', 'Dummyus- has no homepage', 'Dummyus- did not enter a birthday', 'NO ICQ', 'online', 1274380921, 1274380907, 0, '0', '0', '1');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `verifys`
--
CREATE TABLE IF NOT EXISTS `verifys` (
`acc` varchar(50) NOT NULL,
`code` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `verifys`
--