-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Darbinė stotis: localhost
-- Atlikimo laikas:  2008 m. Sausio 22 d.  20:37
-- Serverio versija: 4.1.22
-- PHP versija: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Duombazė: `scriptso_photo2`
--

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

--
-- Sukurta duomenų struktūra lentelei `admin`
--

CREATE TABLE `admin` (
  `username` varchar(20) NOT NULL default '0',
  `password` varchar(20) default NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Sukurta duomenų kopija lentelei `admin`
--

INSERT INTO `admin` VALUES('admin', 'admin');

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

--
-- Sukurta duomenų struktūra lentelei `bannerclicks`
--

CREATE TABLE `bannerclicks` (
  `bannerclicksid` bigint(15) unsigned NOT NULL auto_increment,
  `insdate` date default NULL,
  `num` int(10) unsigned default NULL,
  `bannersid` bigint(15) unsigned default NULL,
  PRIMARY KEY  (`bannerclicksid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Sukurta duomenų kopija lentelei `bannerclicks`
--


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

--
-- Sukurta duomenų struktūra lentelei `banners`
--

CREATE TABLE `banners` (
  `bannersid` bigint(15) unsigned NOT NULL auto_increment,
  `categoryid` bigint(15) unsigned default NULL,
  `title` varchar(100) default NULL,
  `imgurl` varchar(200) default NULL,
  `imgfile` varchar(50) default NULL,
  `linkurl` varchar(200) default NULL,
  `alttext` varchar(255) default NULL,
  `winwidth` int(10) unsigned default NULL,
  `newwindow` char(1) default NULL,
  `linknewwindow` char(1) default NULL,
  `imgheight` int(10) unsigned default NULL,
  `imgwidth` int(10) unsigned default NULL,
  `startdate` date default NULL,
  `enddate` date default NULL,
  `active` int(10) unsigned default NULL,
  `expclicks` int(10) unsigned default NULL,
  `expviews` int(10) unsigned default NULL,
  `textad` text,
  `uniid` varchar(100) default NULL,
  `winheight` int(10) unsigned default NULL,
  PRIMARY KEY  (`bannersid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Sukurta duomenų kopija lentelei `banners`
--


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

--
-- Sukurta duomenų struktūra lentelei `bannerviews`
--

CREATE TABLE `bannerviews` (
  `bannerviewsid` bigint(15) unsigned NOT NULL auto_increment,
  `insdate` date default NULL,
  `num` int(10) unsigned default NULL,
  `bannersid` bigint(15) unsigned default NULL,
  PRIMARY KEY  (`bannerviewsid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Sukurta duomenų kopija lentelei `bannerviews`
--


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

--
-- Sukurta duomenų struktūra lentelei `comments`
--

CREATE TABLE `comments` (
  `commentsid` bigint(15) unsigned NOT NULL auto_increment,
  `comment` text,
  `photosid` bigint(15) unsigned default NULL,
  `byusername` varchar(12) default NULL,
  `approved` char(1) default NULL,
  `postdate` datetime default NULL,
  PRIMARY KEY  (`commentsid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Sukurta duomenų kopija lentelei `comments`
--


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

--
-- Sukurta duomenų struktūra lentelei `emailtemplates`
--

CREATE TABLE `emailtemplates` (
  `templatesid` bigint(15) unsigned NOT NULL auto_increment,
  `template` text,
  `usedfor` varchar(30) default NULL,
  PRIMARY KEY  (`templatesid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Sukurta duomenų kopija lentelei `emailtemplates`
--

INSERT INTO `emailtemplates` VALUES(1, 'Your username and validation code as given below\r\nUsername:%username%\r\nPassword:%password%\r\nValidation Code:%validcode%\r\nRegards,  \r\nSupport Team', 'EMAILVALIDATION');
INSERT INTO `emailtemplates` VALUES(2, 'Your username and validation code as given below\r\nUsername:%username%\r\nPassword:%password%\r\nRegards,\r\nSupport Team', 'NEWMEMBER');
INSERT INTO `emailtemplates` VALUES(3, 'Dear %toname%,\r\n%message%\r\nRegards,\r\n%fromname%', 'EMAILFRIEND');
INSERT INTO `emailtemplates` VALUES(4, 'Hi,\r\n%username% has written a comment on your picture.\r\nRegards,\r\nSupport Team', 'NEWCOMMENT');
INSERT INTO `emailtemplates` VALUES(5, 'Hi,\r\n%username% has sent you a message.\r\nRegards,\r\nSupport Team', 'NEWMESSAGE');

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

--
-- Sukurta duomenų struktūra lentelei `members`
--

CREATE TABLE `members` (
  `username` varchar(12) NOT NULL default '0',
  `password` varchar(12) default NULL,
  `email` varchar(40) default NULL,
  `age` int(10) default NULL,
  `subscribed` char(1) default NULL,
  `gender` char(2) default NULL,
  `about` text,
  `city` varchar(50) default NULL,
  `country` varchar(100) default NULL,
  `joindate` datetime default NULL,
  `msn` varchar(50) default NULL,
  `active` int(10) default NULL,
  `aol` varchar(50) default NULL,
  `yahoo` varchar(50) default NULL,
  `icq` varchar(50) default NULL,
  `fname` varchar(30) default NULL,
  `lname` varchar(30) default NULL,
  `commentemail` char(1) default NULL,
  `messageemail` char(1) default NULL,
  `validcode` varchar(20) default NULL,
  PRIMARY KEY  (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Sukurta duomenų kopija lentelei `members`
--


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

--
-- Sukurta duomenų struktūra lentelei `messages`
--

CREATE TABLE `messages` (
  `messagesid` bigint(15) unsigned NOT NULL auto_increment,
  `message` text,
  `fromusername` varchar(12) default NULL,
  `tousername` varchar(12) default NULL,
  `upldate` datetime default NULL,
  `seen` char(1) default 'N',
  `subject` varchar(100) default NULL,
  PRIMARY KEY  (`messagesid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Sukurta duomenų kopija lentelei `messages`
--


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

--
-- Sukurta duomenų struktūra lentelei `photos`
--

CREATE TABLE `photos` (
  `photosid` bigint(15) unsigned NOT NULL auto_increment,
  `url` varchar(100) default NULL,
  `filename` varchar(40) default NULL,
  `username` varchar(12) default NULL,
  `upldate` datetime default NULL,
  `approved` char(1) default NULL,
  PRIMARY KEY  (`photosid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Sukurta duomenų kopija lentelei `photos`
--


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

--
-- Sukurta duomenų struktūra lentelei `ratings`
--

CREATE TABLE `ratings` (
  `ratingsid` bigint(15) unsigned NOT NULL auto_increment,
  `numvotes` int(10) unsigned default NULL,
  `totrating` bigint(15) unsigned default NULL,
  `avgrating` float default NULL,
  `photosid` bigint(15) unsigned default NULL,
  PRIMARY KEY  (`ratingsid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Sukurta duomenų kopija lentelei `ratings`
--


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

--
-- Sukurta duomenų struktūra lentelei `settings`
--

CREATE TABLE `settings` (
  `setting` varchar(30) NOT NULL default '0',
  `settingvalue` text,
  PRIMARY KEY  (`setting`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Sukurta duomenų kopija lentelei `settings`
--

INSERT INTO `settings` VALUES('AUTOSIGNUP', 'N');
INSERT INTO `settings` VALUES('MAXPICTURES', '5');
INSERT INTO `settings` VALUES('APPROVEPIC', 'Y');
INSERT INTO `settings` VALUES('THUMBHEIGHT', '100');
INSERT INTO `settings` VALUES('THUMBWIDTH', '100');
INSERT INTO `settings` VALUES('URLDOMAIN', 'http://www.yourdomain.com');
INSERT INTO `settings` VALUES('INBOXSIZE', '20');
INSERT INTO `settings` VALUES('LATESTPICSIZE', '20');
INSERT INTO `settings` VALUES('TOPRATEDSIZE', '20');
INSERT INTO `settings` VALUES('SEARCHRESULTSIZE', '10');
INSERT INTO `settings` VALUES('ADMINEMAIL', 'youremail@youremail.com');
INSERT INTO `settings` VALUES('APPROVECOMMENTS', 'Y');
INSERT INTO `settings` VALUES('MAXPICSIZE', '400000');
INSERT INTO `settings` VALUES('ALLOWEDFORMATS', '.jpg,.gif,.GIF,.JPG');
INSERT INTO `settings` VALUES('SHOWLASTVOTE', 'Y');
INSERT INTO `settings` VALUES('SUBSCRIPTIONS', 'Y');
INSERT INTO `settings` VALUES('SUBSCRIBERMAXPICTURES', '20');
INSERT INTO `settings` VALUES('INBOXONLYFORSUBSCRIBERS', 'N');
INSERT INTO `settings` VALUES('PAYPALID', 'youremail@youremail.com');
INSERT INTO `settings` VALUES('SUBSCRIPTIONAMNT', '20');
INSERT INTO `settings` VALUES('PROFILEONLYFORSUBSCRIBERS', 'Y');
INSERT INTO `settings` VALUES('MAXPICWIDTH', '480');
INSERT INTO `settings` VALUES('WATERMARKIMAGES', 'N');
INSERT INTO `settings` VALUES('WATERMARKPOS', 'RND');
INSERT INTO `settings` VALUES('AdSense', 'AdSense Code here');
INSERT INTO `settings` VALUES('Welcome', 'Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here Welcome text here ');
INSERT INTO `settings` VALUES('HeaderImg', 'logo.gif');

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

--
-- Sukurta duomenų struktūra lentelei `transactions`
--

CREATE TABLE `transactions` (
  `transactionsid` bigint(15) unsigned NOT NULL auto_increment,
  `transdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `valid` char(1) NOT NULL default 'N',
  `username` varchar(20) NOT NULL default '',
  `amount` float NOT NULL default '0',
  PRIMARY KEY  (`transactionsid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Sukurta duomenų kopija lentelei `transactions`
--