SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Table structure for table `pagr_baner`
-- 

CREATE TABLE `pagr_baner` (
  `id` int(11) NOT NULL auto_increment,
  `tipas` varchar(1) NOT NULL,
  `click` int(11) NOT NULL default '0',
  `view` int(11) NOT NULL default '0',
  `ikiClick` int(11) default NULL,
  `ikiView` int(11) default NULL,
  `ikiData` int(11) default NULL,
  `adre` varchar(255) NOT NULL,
  `link` varchar(500) NOT NULL,
  `width` int(10) NOT NULL,
  `heigth` int(10) NOT NULL,
  `eileje` int(11) NOT NULL default '0',
  `veikia` enum('on','off') NOT NULL default 'on',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=78 ;

-- 
-- Dumping data for table `pagr_baner`
-- 


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

-- 
-- Table structure for table `pagr_formos`
-- 

CREATE TABLE `pagr_formos` (
  `id` int(11) NOT NULL auto_increment,
  `text` text NOT NULL,
  `meniuID` int(11) NOT NULL,
  `kalba` varchar(5) default NULL,
  `lastM` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- 
-- Dumping data for table `pagr_formos`
-- 


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

-- 
-- Table structure for table `pagr_g_album`
-- 

CREATE TABLE `pagr_g_album` (
  `id` int(11) NOT NULL auto_increment,
  `meniuID` int(11) NOT NULL,
  `imageID` int(11) NOT NULL,
  `pavad` varchar(1024) character set utf8 NOT NULL,
  `apras` text character set utf8 NOT NULL,
  `lastM` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=74 ;

-- 
-- Dumping data for table `pagr_g_album`
-- 


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

-- 
-- Table structure for table `pagr_kalba`
-- 

CREATE TABLE `pagr_kalba` (
  `tpav` varchar(2) NOT NULL,
  `ipav` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `pagr_kalba`
-- 

INSERT INTO `pagr_kalba` (`tpav`, `ipav`) VALUES 
('LT', 'Lietuviškai');

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

-- 
-- Table structure for table `pagr_koment`
-- 

CREATE TABLE `pagr_koment` (
  `id` int(11) NOT NULL auto_increment,
  `tipas` varchar(56) NOT NULL,
  `imageID` int(11) default NULL,
  `meniuID` int(11) default NULL,
  `vertinimas` smallint(6) default NULL,
  `vardas` varchar(56) NOT NULL,
  `email` varchar(100) NOT NULL,
  `lastM` int(11) NOT NULL,
  `kom` text NOT NULL,
  `kalba` varchar(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

-- 
-- Dumping data for table `pagr_koment`
-- 

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

-- 
-- Table structure for table `pagr_meniu`
-- 

CREATE TABLE `pagr_meniu` (
  `vieta` varchar(5) NOT NULL,
  `id` int(3) NOT NULL auto_increment,
  `meniuID` int(6) NOT NULL default '0',
  `pomeniuID` int(6) NOT NULL default '0',
  `eileje` int(5) NOT NULL,
  `tipas` varchar(56) NOT NULL,
  `lygis` tinyint(1) NOT NULL default '1',
  `veikia` enum('on','off') NOT NULL default 'on',
  `home` enum('on','off') NOT NULL default 'off',
  `edit_pav` enum('on','off') default NULL,
  `edit_view` enum('on','off') default NULL,
  `edit_rate` enum('on','off') default NULL,
  `edit_lastM` enum('on','off') default NULL,
  `edit_kom` enum('on','off') default NULL,
  `stylius` varchar(255) default NULL,
  `pavadinimas_LT` varchar(255) NOT NULL,
  `text_LT` longtext NOT NULL,
  `view_LT` int(8) NOT NULL default '0',
  `lastM_LT` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `pagr_meniu`
-- 


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

-- 
-- Table structure for table `pagr_news`
-- 

CREATE TABLE `pagr_news` (
  `id` tinyint(4) NOT NULL auto_increment,
  `meniuID` int(11) NOT NULL,
  `IMG` varchar(255) NOT NULL default '0',
  `arhyv` enum('on','off') NOT NULL default 'off',
  `pavadinimas_LT` varchar(255) NOT NULL default 'Nėra pavadinimo',
  `text_s_LT` longtext,
  `text_l_LT` longtext,
  `view_LT` int(11) NOT NULL default '0',
  `lastM_LT` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `pagr_news`
-- 


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

-- 
-- Table structure for table `pagr_nustatymai`
-- 

CREATE TABLE `pagr_nustatymai` (
  `kas` varchar(56) NOT NULL,
  `veiksmas` varchar(56) NOT NULL,
  `pavad` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `pagr_nustatymai`
-- 

INSERT INTO `pagr_nustatymai` (`kas`, `veiksmas`, `pavad`) VALUES 
('baner_did', 'on', NULL),
('baner_maz', 'on', NULL),
('poll', 'off', NULL),
('rusiav', 'on', NULL),
('email', 'osweee@gmail.com', NULL),
('emai', 'cola@email.lt', NULL),
('baner_maz_w', '150', NULL),
('baner_maz_h', '75', NULL),
('baner_did_w', '460', NULL),
('baner_did_h', '60', NULL),
('forma_email', 'off', NULL),
('forma_mysql', 'on', NULL),
('forma_email_adre', 'osweee@gmail.com', NULL),
('edit_pav', 'on', NULL),
('edit_view', 'off', NULL),
('edit_lastM', 'off', NULL),
('edit_kom', 'off', NULL),
('shoutbox', 'off', NULL),
('print', 'off', NULL),
('find', 'off', NULL),
('styliai', 'on', 'index.html'),
('styliai', 'home', 'pagr.html'),
('edit_rate', 'off', NULL),
('galerija_pavad', 'on', NULL),
('galerija_koment', 'off', NULL),
('galerija_lastM', 'on', NULL),
('galerija_apras', 'on', NULL),
('galerija_rodykles', 'on', NULL),
('galerija_cols', '3', NULL),
('galerija_rows', '4', NULL);

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

-- 
-- Table structure for table `pagr_papild`
-- 

CREATE TABLE `pagr_papild` (
  `id` int(11) NOT NULL auto_increment,
  `adresas` varchar(56) NOT NULL,
  `text_LT` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `pagr_papild`
-- 

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

-- 
-- Table structure for table `pagr_plugins`
-- 

CREATE TABLE `pagr_plugins` (
  `tipas` varchar(255) NOT NULL,
  `failoADRE` text NOT NULL,
  `simbol` varchar(56) NOT NULL,
  `pavad` varchar(255) NOT NULL,
  `apras` text NOT NULL,
  `pavad_admin` varchar(56) default NULL,
  `failoADRE_admin` varchar(756) default NULL,
  UNIQUE KEY `simbol` (`simbol`),
  UNIQUE KEY `simbol_2` (`simbol`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `pagr_plugins`
-- 


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

-- 
-- Table structure for table `pagr_sveciu`
-- 

CREATE TABLE `pagr_sveciu` (
  `id` int(11) NOT NULL auto_increment,
  `meniuID` int(11) NOT NULL,
  `nuotaika` varchar(512) NOT NULL,
  `kalba` varchar(5) NOT NULL,
  `lastM` int(11) NOT NULL,
  `vardas` varchar(255) NOT NULL,
  `email` varchar(512) NOT NULL,
  `koment` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;

-- 
-- Dumping data for table `pagr_sveciu`
-- 

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

-- 
-- Table structure for table `pagr_user`
-- 

CREATE TABLE `pagr_user` (
  `user` varchar(56) NOT NULL,
  `pass` varchar(56) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `lastM` int(11) NOT NULL,
  `lastL` int(11) NOT NULL,
  `view` int(11) NOT NULL default '0',
  `laipsnis` varchar(16) NOT NULL,
  UNIQUE KEY `user` (`user`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `email_2` (`email`),
  KEY `lastM` (`lastM`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `pagr_user`
-- 

INSERT INTO `pagr_user` (`user`, `pass`, `name`, `email`, `lastM`, `lastL`, `view`, `laipsnis`) VALUES 
('admin', '*4ACFE3202A5FF5CF467898FC58AAB1D615029441', 'Administratorius', 'admin@admin.lt', 1189105990, 1189867096, 181, 'admin'),
('asdfasdf', '*F6DD0C0AC75395CB5BFC12C46B8880CD156B4799', 'as', 'a', 1189022500, 0, 0, 'admin'),
('o', '*A5C666EC400A205E980891201970972DFA107615', 'Osvaldas Rokas', 'osweee@gmail.com', 1189099748, 1189105796, 95, 'admin');