# phpMyAdmin MySQL-Dump # version 2.2.0 # http://phpwizard.net/phpMyAdmin/ # http://phpmyadmin.sourceforge.net/ (download page) # # Host: localhost # Generation Time: April 3, 2002, 5:48 pm # Server version: 3.23.44 # PHP Version: 4.1.2 # Database : `faqatron` # -------------------------------------------------------- # # Table structure for table `faq` #Sql120640_4 CREATE TABLE faq ( id int(10) unsigned NOT NULL auto_increment, parent int(10) unsigned NOT NULL default '0', pos int(10) unsigned NOT NULL default '0', name tinytext NOT NULL, title tinytext NOT NULL, text text NOT NULL, keywords tinytext NOT NULL, lastedit datetime NOT NULL default '0000-00-00 00:00:00', html tinyint(4) NOT NULL default '0', bbcode tinyint(4) NOT NULL default '0', PRIMARY KEY (id), KEY id (id) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `session` # CREATE TABLE session ( user_id int(10) unsigned NOT NULL default '0', cookie int(10) unsigned NOT NULL default '0', ip tinytext NOT NULL, lastvisit int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `themes` # CREATE TABLE themes ( theme_id int(10) NOT NULL auto_increment, theme_name varchar(35) default NULL, bgcolor varchar(10) default NULL, textcolor varchar(10) default NULL, color1 varchar(10) default NULL, color2 varchar(10) default NULL, table_bgcolor varchar(10) default NULL, header_image varchar(50) default NULL, newtopic_image varchar(50) default NULL, reply_image varchar(50) default NULL, linkcolor varchar(15) default NULL, vlinkcolor varchar(15) default NULL, theme_default int(2) default '0', fontface varchar(100) default NULL, fontsize1 varchar(5) default NULL, fontsize2 varchar(5) default NULL, fontsize3 varchar(5) default NULL, fontsize4 varchar(5) default NULL, tablewidth varchar(10) default NULL, replylocked_image varchar(255) default NULL, header text NOT NULL, footer text NOT NULL, PRIMARY KEY (theme_id) ) TYPE=MyISAM; # # Dumping data for table `themes` # INSERT INTO themes (theme_id, theme_name, bgcolor, textcolor, color1, color2, table_bgcolor, header_image, newtopic_image, reply_image, linkcolor, vlinkcolor, theme_default, fontface, fontsize1, fontsize2, fontsize3, fontsize4, tablewidth, replylocked_image, header, footer) VALUES (1,'Default','#000000','#FFFFFF','#6C706D','#2E4460','#001100','images/header-dark.jpg','images/new_topic-dark.jpg','images/reply-dark.jpg','#11C6BD','#11C6BD','','sans-serif','1','2','-2','+1','95%','images/reply_locked-dark.jpg','',''); INSERT INTO themes (theme_id, theme_name, bgcolor, textcolor, color1, color2, table_bgcolor, header_image, newtopic_image, reply_image, linkcolor, vlinkcolor, theme_default, fontface, fontsize1, fontsize2, fontsize3, fontsize4, tablewidth, replylocked_image, header, footer) VALUES (2,'Ocean','#FFFFFF','#000000','#CCCCCC','#9BB6DA','#000000','images/danceidol2forweb.gif','images/new_topic.jpg','images/reply.jpg','#011001','#2100cc',1,'sans-serif','+0','+2','-2','+1','95%','images/reply_locked-dark.jpg','',''); INSERT INTO themes (theme_id, theme_name, bgcolor, textcolor, color1, color2, table_bgcolor, header_image, newtopic_image, reply_image, linkcolor, vlinkcolor, theme_default, fontface, fontsize1, fontsize2, fontsize3, fontsize4, tablewidth, replylocked_image, header, footer) VALUES (3,'OCPrices.com','#FFFFFF','#000000','#efefef','#cdcdcd','#001100','images/header.jpg','images/new_topic.jpg','images/reply.jpg','#000000','#000000','','sans-serif','1','2','-2','+1','95%','images/reply_locked-dark.jpg','',''); # -------------------------------------------------------- # # Table structure for table `user` # CREATE TABLE user ( id int(10) unsigned NOT NULL auto_increment, name tinytext NOT NULL, email tinytext NOT NULL, password tinytext NOT NULL, user_level tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (id), KEY id (id) ) TYPE=MyISAM; # # Dumping data for table `user` # INSERT INTO user (id, name, email, password, user_level) VALUES (1,'admin','faqatron@iprcom.com','512d25bbb054694d9460fde14fa6861d',4);