-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: p21.progreso.pl:3306
-- Czas wygenerowania: 09 Wrz 2010, 17:05
-- Wersja serwera: 4.1.22
-- Wersja PHP: 5.2.9

SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

--
-- Baza danych: `chart_dance`
--

-- --------------------------------------------------------

--
-- Struktura tabeli dla `animation`
--

CREATE TABLE `animation` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`img` varchar(255) NOT NULL default '',
`content` text NOT NULL,
`position` tinyint(4) NOT NULL default '1',
`bg_color` varchar(15) NOT NULL default '#000000',
`opacity` float NOT NULL default '0.5',
`align` varchar(15) NOT NULL default 'right',
`deletable` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

--
-- Struktura tabeli dla `articles`
--

CREATE TABLE `articles` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) default NULL,
`content` text,
`author` varchar(255) default NULL,
`id_parent` int(10) unsigned default NULL,
`date` timestamp NULL default CURRENT_TIMESTAMP,
`level` tinyint(4) NOT NULL default '1',
`priorytet` int(11) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '1',
`editable` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=58 ;

-- --------------------------------------------------------

--
-- Struktura tabeli dla `boxes`
--

CREATE TABLE `boxes` (
`id` int(10) unsigned NOT NULL auto_increment,
`description` varchar(255) default NULL,
`content` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabeli dla `news`
--

CREATE TABLE `news` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(255) default NULL,
`short` text,
`content` text,
`author` varchar(255) default NULL,
`id_parent` int(10) unsigned default NULL,
`date` timestamp NULL default CURRENT_TIMESTAMP,
`level` tinyint(4) NOT NULL default '1',
`priorytet` int(11) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '1',
`archive` tinyint(4) NOT NULL default '0',
`editable` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Struktura tabeli dla `popup`
--

CREATE TABLE `popup` (
`id` bigint(20) NOT NULL auto_increment,
`active` tinyint(4) NOT NULL default '0',
`url` varchar(127) NOT NULL default '',
`content` text NOT NULL,
`per_session` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Struktura tabeli dla `users`
--

CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL auto_increment,
`login` varchar(35) default NULL,
`pass` varchar(35) default NULL,
`users` tinyint(4) NOT NULL default '0',
`articles` tinyint(4) NOT NULL default '0',
`news` tinyint(4) NOT NULL default '0',
`gallery` tinyint(4) NOT NULL default '0',
`newsletter` tinyint(4) NOT NULL default '0',
`popup` tinyint(4) NOT NULL default '0',
`boxes` tinyint(4) NOT NULL default '0',
`animation` tinyint(4) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=2 ;