File: superbasic.sql

-- Use this as a guide line for the config file as it is working with these default values
-- This is super bare bones here, you can add stuff as you please.
-- phpMyAdmin SQL Dump
-- PHP Version: 5.1.2

CREATE TABLE `config` (
  `config_id` int(11) NOT NULL auto_increment,
  `config_name` varchar(50) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  `config_info` varchar(255) default NULL,
  PRIMARY KEY  (`config_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `session` (
  `user_id` int(11) NOT NULL,
  `session_id` varchar(40) NOT NULL,
  `session_ip` varchar(16) NOT NULL,
  `session_begin` varchar(11) NOT NULL,
  `session_end` varchar(11) NOT NULL,
  `session_total` mediumint(9) NOT NULL default '0',
  UNIQUE KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `user` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_login` varchar(15) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;