-- 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;
|