-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: disc
-- Generation Time: Mar 25, 2008 at 01:00 PM
-- Server version: 4.1.20
-- PHP Version: 4.3.9
-- 
-- Database: `usac`
-- 

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

-- 
-- Table structure for table `clubs`
-- 

CREATE TABLE `clubs` (
  `club_id` int(10) unsigned NOT NULL auto_increment,
  `cyc_org` varchar(10) NOT NULL default '',
  `aff_type` smallint(6) NOT NULL default '0',
  `name` varchar(80) NOT NULL default '',
  `address1` varchar(30) NOT NULL default '',
  `address2` varchar(30) NOT NULL default '',
  `city` varchar(25) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zip` varchar(10) NOT NULL default '',
  `shipaddr1` varchar(30) NOT NULL default '',
  `shipaddr2` varchar(30) NOT NULL default '',
  `shipcity` varchar(25) NOT NULL default '',
  `shipstate` char(2) NOT NULL default '',
  `shipzip` varchar(10) NOT NULL default '',
  `phone` varchar(20) NOT NULL default '',
  `fax` varchar(20) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `web_page` varchar(100) NOT NULL default '',
  `pend` varchar(100) NOT NULL default '',
  `sponsored` char(1) NOT NULL default 'N',
  `ncca_conf` char(3) NOT NULL default '',
  `division` char(3) NOT NULL default '',
  `send_packet` char(1) NOT NULL default 'Y',
  `bad_addr` char(1) NOT NULL default 'N',
  `date_join` date NOT NULL default '0000-00-00',
  `date_exp` date NOT NULL default '0000-00-00',
  `date_update` datetime NOT NULL default '0000-00-00 00:00:00',
  `update_user` int(11) NOT NULL default '0',
  `notes` text NOT NULL,
  `hide` char(1) NOT NULL default 'N',
  PRIMARY KEY  (`club_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Club information' AUTO_INCREMENT=12134 ;