-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jan 10, 2006 at 12:18 AM
-- Server version: 4.0.12
-- PHP Version: 4.4.0
-- 
-- Database: `turbosyndicator`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `sy_main`
-- 

CREATE TABLE `sy_main` (
  `syndicatorid` int(11) NOT NULL auto_increment,
  `syndicatorname` varchar(50) NOT NULL default '',
  `header` text,
  `footer` text,
  `body` text,
  `expirydate` datetime default NULL,
  `frheight` char(3) default NULL,
  `frwidth` char(3) default NULL,
  `showborder` char(1) default NULL,
  PRIMARY KEY  (`syndicatorid`)
) TYPE=MyISAM AUTO_INCREMENT=45 ;

-- 
-- Dumping data for table `sy_main`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `sy_settings`
-- 

CREATE TABLE `sy_settings` (
  `settingsid` smallint(6) NOT NULL auto_increment,
  `header` text,
  `footer` text,
  `searchheader` text,
  `searchfooter` text,
  PRIMARY KEY  (`settingsid`)
) TYPE=MyISAM AUTO_INCREMENT=80 ;

-- 
-- Dumping data for table `sy_settings`
-- 

INSERT INTO `sy_settings` VALUES (79, '<HTML>\r\n<HEAD>\r\n<TITLE></TITLE>\r\n<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">\r\n<style>\r\n    BODY\r\n    {\r\n      font-family: Verdana;\r\n      font-size: 14px;\r\n      padding: 10px;\r\n    }\r\n    TD\r\n    {\r\n      font-size: 14px;\r\n    }\r\n    \r\n  </style>\r\n\r\n  \r\n</HEAD>\r\n<BODY background="http://www.use-sell.com/bgfinegrey.gif">\r\n<div align="center">\r\n  <table border="0" style="border-collapse: collapse" width="650" id="table1" bgcolor="#000080">\r\n\r\n    <tr>\r\n      <td>\r\n      <div align="center">\r\n\r\n        <table border="0" cellpadding="10" cellspacing="10" style="border-collapse: collapse" width="100%" bgcolor="#FFFFFF" id="table2">\r\n\r\n          <tr>\r\n            <td>\r\n            <p align="center"><b><font size="5">Turbo Syndicator</font></b><br>', '<br>\r\n<p align="center"></p>\r\n\r\n<p align=center>Copyright © 2006 The Internet Company LLC</center>\r\n\r\n<br><br>\r\n\r\n            </td>\r\n          </tr>\r\n\r\n        </table>\r\n      </div>\r\n      </td>\r\n    </t>', NULL, NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `sy_users`
-- 

CREATE TABLE `sy_users` (
  `userid` smallint(6) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `password` varchar(20) NOT NULL default '',
  `fullname` varchar(50) default NULL,
  PRIMARY KEY  (`userid`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `sy_users`
-- 

INSERT INTO `sy_users` VALUES (1, 'john', 'john', 'John Delavera');

