[geeklog-cvs] Geeklog-1.x/plugins/calendar/sql mssql_install.php, 1.3, 1.4 mysql_install.php, 1.1, 1.2

Dirk Haun dhaun at qs1489.pair.com
Sun Jan 27 10:23:35 EST 2008


Update of /cvsroot/geeklog/Geeklog-1.x/plugins/calendar/sql
In directory qs1489.pair.com:/tmp/cvs-serv35636/plugins/calendar/sql

Modified Files:
	mssql_install.php mysql_install.php 
Log Message:
Got rid of the $_STATES array and turned the states dropdown into a simple text entry field


Index: mssql_install.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/plugins/calendar/sql/mssql_install.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mssql_install.php	11 Oct 2006 01:36:11 -0000	1.3
--- mssql_install.php	27 Jan 2008 15:23:33 -0000	1.4
***************
*** 54,58 ****
      [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
!     [state] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [allday] [smallint] NULL ,
--- 54,58 ----
      [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
!     [state] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [allday] [smallint] NULL ,
***************
*** 75,79 ****
      [allday] [smallint] NOT NULL ,
      [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
!     [state] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
--- 75,79 ----
      [allday] [smallint] NOT NULL ,
      [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
!     [state] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
***************
*** 95,99 ****
      [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
!     [state] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [allday] [smallint] NOT NULL ,
--- 95,99 ----
      [address2] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [city] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
!     [state] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [zipcode] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [allday] [smallint] NOT NULL ,

Index: mysql_install.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/plugins/calendar/sql/mysql_install.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mysql_install.php	19 Aug 2006 18:51:48 -0000	1.1
--- mysql_install.php	27 Jan 2008 15:23:33 -0000	1.2
***************
*** 7,11 ****
  // | Installation SQL                                                          |
  // +---------------------------------------------------------------------------+
! // | Copyright (C) 2000-2006 by the following authors:                         |
  // |                                                                           |
  // | Authors: Tony Bibbs        - tony AT tonybibbs DOT com                    |
--- 7,11 ----
  // | Installation SQL                                                          |
  // +---------------------------------------------------------------------------+
! // | Copyright (C) 2000-2008 by the following authors:                         |
  // |                                                                           |
  // | Authors: Tony Bibbs        - tony AT tonybibbs DOT com                    |
***************
*** 52,56 ****
    address2 varchar(40) default NULL,
    city varchar(60) default NULL,
!   state char(2) default NULL,
    zipcode varchar(5) default NULL,
    allday tinyint(1) NOT NULL default '0',
--- 52,56 ----
    address2 varchar(40) default NULL,
    city varchar(60) default NULL,
!   state varchar(40) default NULL,
    zipcode varchar(5) default NULL,
    allday tinyint(1) NOT NULL default '0',
***************
*** 78,82 ****
    allday tinyint(1) NOT NULL default '0',
    zipcode varchar(5) default NULL,
!   state char(2) default NULL,
    city varchar(60) default NULL,
    address2 varchar(40) default NULL,
--- 78,82 ----
    allday tinyint(1) NOT NULL default '0',
    zipcode varchar(5) default NULL,
!   state varchar(40) default NULL,
    city varchar(60) default NULL,
    address2 varchar(40) default NULL,
***************
*** 99,103 ****
    address2 varchar(40) default NULL,
    city varchar(60) default NULL,
!   state char(2) default NULL,
    zipcode varchar(5) default NULL,
    allday tinyint(1) NOT NULL default '0',
--- 99,103 ----
    address2 varchar(40) default NULL,
    city varchar(60) default NULL,
!   state varchar(40) default NULL,
    zipcode varchar(5) default NULL,
    allday tinyint(1) NOT NULL default '0',




More information about the geeklog-cvs mailing list