Login   Register  
PHP Classes
elePHPant
Icontem

File: superbasic.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Danny Tucker  >  EZ Framework  >  superbasic.sql  >  Download  
File: superbasic.sql
Role: Auxiliary data
Content type: text/plain
Description: basic database structure
Class: EZ Framework
Framework providing several types of functionality
Author: By
Last change: remove none essential columns
Date: 2006-03-16 21:58
Size: 1,096 bytes
 

Contents

Class file image Download
-- 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;