Login   Register  
PHP Classes
elePHPant
Icontem

File: db/mysql.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Dennis T Kaplan  >  dbStringIt  >  db/mysql.sql  >  Download  
File: db/mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: sql
Class: dbStringIt
Generate SQL to update databases from form values
Author: By
Last change:
Date: 2007-01-15 10:14
Size: 2,855 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump
-- version 2.8.2-Debian-0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 15, 2007 at 12:41 PM
-- Server version: 5.0.24
-- PHP Version: 5.1.6
--
-- Database: `user`
--
CREATE DATABASE `user` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `user`;

-- --------------------------------------------------------

--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `id` int(4) NOT NULL auto_increment,
  `cfg` varchar(15) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `config`
--

INSERT DELAYED INTO `config` (`id`, `cfg`, `value`) VALUES (1, 'group_names', 'a:4:{i:1;s:5:"Admin";i:2;s:4:"User";}');

-- --------------------------------------------------------

--
-- Table structure for table `identity`
--

CREATE TABLE `identity` (
  `uid` int(255) NOT NULL default '0',
  `Company` varchar(50) NOT NULL default '',
  `Street` varchar(65) NOT NULL default '',
  `City` varchar(20) NOT NULL default '',
  `State` char(2) NOT NULL default '',
  `Country` char(2) NOT NULL default '',
  `ZIP` varchar(10) NOT NULL,
  `ZIP4` varchar(5) NOT NULL,
  `Phone` varchar(20) NOT NULL default '',
  `Cell` varchar(20) NOT NULL default '',
  `Fax` varchar(20) NOT NULL default '',
  `email` varchar(40) NOT NULL default '',
  `Yahoo` varchar(255) NOT NULL default '',
  `MSN` varchar(255) NOT NULL default '',
  `ICQ` int(11) NOT NULL,
  `AIM` varchar(255) NOT NULL default '',
  `url` varchar(65) NOT NULL default '',
  `Birthday` date NOT NULL default '0000-00-00',
  `Notes` text NOT NULL,
  `last_db_change` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_joined` date NOT NULL default '0000-00-00',
  `newemail` varchar(40) NOT NULL default '',
  `confirmkey` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `identity`
--


-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `uid` int(255) NOT NULL auto_increment,
  `alias` varchar(40) NOT NULL,
  `pass` varchar(40) NOT NULL default '',
  `default_group` tinyint(4) NOT NULL default '2',
  `groups` varchar(255) NOT NULL default '2',
  `First_Name` varchar(20) NOT NULL default '',
  `Last_Name` varchar(20) NOT NULL default '',
  `GMT_Offset` tinyint(3) default NULL,
  `DTS` enum('Yes','No') default NULL,
  `IP` varchar(20) NOT NULL default '',
  `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
  `login_count` int(255) NOT NULL default '0',
  `status` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users`
--