Public Data

---------

phpmyadmin sql dump version 2.11.2.1 http://www.phpmyadmin.net host: localhost generation time: feb 11, 2008 at 10:04 am server version: 5.0.45 php version: 5.2.5

set sql_mode="no_auto_value_on_zero"; --- database: `publicpeople` --- ---------------------------------------------------------- table structure for table `admin` -create table `admin` ( `admin_id` int(11) not null auto_increment, `admin_name` varchar(50) not null default '', `password` varchar(20) not null default '', `email` varchar(100) not null default '', primary key (`admin_id`) ) engine=innodb default charset=latin1 auto_increment=2 ; --- dumping data for table `admin` -insert into `admin` (`admin_id`, `admin_name`, `password`, `email`) values (1, 'admin', 'admin', ''); -- ---------------------------------------------------------- table structure for table `album` -create table `album` ( `album_id` int(11) not null auto_increment, `user_id` int(11) not null, `album_name` varchar(100) not null, `date` varchar(100) not null, `views` varchar(100) not null, `vote` varchar(100) not null, `status` varchar(100) not null, primary key (`album_id`) ) engine=innodb default charset=latin1 auto_increment=2 ; --- dumping data for table `album` -insert into `album` (`album_id`, `user_id`, `album_name`, `date`, `views`, `vote`,

`status`) values (1, 1, 'test', '', '', '', ''); -- ---------------------------------------------------------- table structure for table `album_comment` -create table `album_comment` ( `alb_comm_id` int(11) not null auto_increment, `album_id` int(11) not null, `comment` text not null, `date` varchar(100) not null, primary key (`alb_comm_id`) ) engine=innodb default charset=latin1 auto_increment=1 ; --- dumping data for table `album_comment` --- ---------------------------------------------------------- table structure for table `image` -create table `image` ( `image_id` int(11) not null auto_increment, `user_id` int(11) not null, `album_id` int(11) not null, `photo_name` varchar(500) not null, `date` varchar(100) not null, `views` varchar(100) not null, `vote` varchar(100) not null, `status` varchar(100) not null, `caption` varchar(100) not null, primary key (`image_id`) ) engine=innodb default charset=latin1 auto_increment=3 ; --- dumping data for table `image` -insert into `image` (`image_id`, `user_id`, `album_id`, `photo_name`, `date`, `views`, `vote`, `status`, `caption`) values (2, 0, 1, '', '1202569615', '', '', '', ''); -- ---------------------------------------------------------- table structure for table `image_comment` -create table `image_comment` ( `img_comm_id` int(11) not null auto_increment, `image_id` int(11) not null,

`comment` text not null, `date` varchar(100) not null, primary key (`img_comm_id`) ) engine=innodb default charset=latin1 auto_increment=1 ; --- dumping data for table `image_comment` --- ---------------------------------------------------------- table structure for table `users` -create table `users` ( `id` int(11) not null auto_increment, `username` varchar(100) not null, `nickname` varchar(100) not null, `email` varchar(100) not null, `password` varchar(100) not null, `dob` varchar(100) not null, `gender` varchar(100) not null, `country` varchar(100) not null, `zip` varchar(100) not null, `featured` varchar(100) not null, `status` varchar(100) not null, `sexuality` varchar(100) not null, `partnerstatus` varchar(100) not null, `smoking` varchar(100) not null, `photo` varchar(500) not null, `online_status` int(11) not null, `current_login` int(11) not null, `temp_login` int(11) not null, `last_login` int(11) not null, `age` varchar(100) not null, `date` varchar(100) not null, `vote` varchar(100) not null, `views` varchar(100) not null, `resv1` varchar(100) not null, `resv2` varchar(100) not null, primary key (`id`) ) engine=innodb default charset=latin1 auto_increment=2 ; --- dumping data for table `users` -insert into `users` (`id`, `username`, `nickname`, `email`, `password`, `dob`, `gender`, `country`, `zip`, `featured`, `status`, `sexuality`, `partnerstatus`, `smoking`, `photo`, `online_status`, `current_login`, `temp_login`, `last_login`, `age`, `date`, `vote`, `views`, `resv1`, `resv2`) values (1, 'test123123', 'test', '[email protected]', 'test1', 'test', 'test', 'test', 'test', 'yes', 'active', 'test', 'test', 'test', 'test', 0, 0, 0, 0, '', '', '', '', '', ''); -- --------------------------------------------------------

--- table structure for table `user_comment` -create table `user_comment` ( `user_comm_id` int(11) not null auto_increment, `user_id` int(11) not null, `comment` text not null, `date` varchar(100) not null, primary key (`user_comm_id`) ) engine=innodb default charset=latin1 auto_increment=1 ; --- dumping data for table `user_comment` --- ---------------------------------------------------------- table structure for table `video` -create table `video` ( `video_id` int(11) not null auto_increment, `video_name` text not null, `video_src` text not null, `video_cat_name` varchar(100) not null, `user_id` int(11) not null, `date` varchar(100) not null, `status` varchar(100) not null, `vote` varchar(100) not null, `views` varchar(100) not null, `tags` varchar(100) not null, `description` text not null, primary key (`video_id`) ) engine=innodb default charset=latin1 auto_increment=1 ; --- dumping data for table `video` --- ---------------------------------------------------------- table structure for table `video_cat` -create table `video_cat` ( `vid_cat_id` int(11) not null auto_increment, `video_id` int(11) not null, `vid_cat_name` varchar(100) not null, `status` varchar(100) not null, `date` varchar(100) not null, `resv` varchar(100) not null, primary key (`vid_cat_id`)

) engine=innodb default charset=latin1 auto_increment=1 ; --- dumping data for table `video_cat` --- ---------------------------------------------------------- table structure for table `video_comment` -create table `video_comment` ( `vid_comm_id` int(11) not null auto_increment, `video_id` int(11) not null, `comment` text not null, `date` varchar(100) not null, primary key (`vid_comm_id`) ) engine=innodb default charset=latin1 auto_increment=1 ; --- dumping data for table `video_comment` --