dates-1.sql

来自「zapatec suite 最新版 20070204,非常棒的ajax widg」· SQL 代码 · 共 31 行

# $Id: dates-1.sql 4322 2006-09-04 08:49:33Z shacka $
#
# phpMyAdmin MySQL-Dump
# version 2.2.3
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: Oct 27, 2005 at 10:00 PM
# Server version: 4.00.16
# PHP Version: 4.3.4
# Database : `calendar_dates`
# --------------------------------------------------------

#
# Table structure for table `dates`
#

CREATE TABLE dates (
  id tinyint(4) NOT NULL auto_increment,
  year int(11) default NULL,
  month tinyint(4) default NULL,
  day tinyint(4) default NULL,
  div1 text NOT NULL,
  div2 text NOT NULL,
  user_id tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY year (year,month,day)
) TYPE=MyISAM;