PHP Classes

File: db/mysql.sql

Recommend this page to a friend!
  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: 17 years ago
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` --