[geeklog-cvs] Geeklog-1.x/sql mssql_tableanddata.php, 1.32, 1.33 mysql_tableanddata.php, 1.198, 1.199

[Dirk Haun]

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

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


Index: mssql_tableanddata.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mssql_tableanddata.php,v
retrieving revision 1.32
retrieving revision 1.33
diff -C2 -d -r1.32 -r1.33
*** mssql_tableanddata.php	6 Jan 2008 20:44:10 -0000	1.32
--- mssql_tableanddata.php	27 Jan 2008 15:23:32 -0000	1.33
***************
*** 155,159 ****
      [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 ,
--- 155,159 ----
      [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 ,
***************
*** 176,180 ****
      [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 ,
--- 176,180 ----
      [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 ,
***************
*** 282,286 ****
      [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 ,
--- 282,286 ----
      [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_tableanddata.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mysql_tableanddata.php,v
retrieving revision 1.198
retrieving revision 1.199
diff -C2 -d -r1.198 -r1.199
*** mysql_tableanddata.php	19 Jan 2008 14:53:12 -0000	1.198
--- mysql_tableanddata.php	27 Jan 2008 15:23:32 -0000	1.199
***************
*** 135,139 ****
    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',
--- 135,139 ----
    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',
***************
*** 161,165 ****
    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,
--- 161,165 ----
    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,
***************
*** 274,278 ****
    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',
--- 274,278 ----
    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',