[Openposs-cvs-commits] CVS: Database MySQL_Creation_Script,1.7,1.8

[<ope...@li...>]

Update of /cvsroot/openposs/Database
In directory usw-pr-cvs1:/tmp/cvs-serv13177

Modified Files:
	MySQL_Creation_Script 
Log Message:

Added Phone number fields, added install instructions


Index: MySQL_Creation_Script
===================================================================
RCS file: /cvsroot/openposs/Database/MySQL_Creation_Script,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** MySQL_Creation_Script	25 Jun 2002 02:53:00 -0000	1.7
--- MySQL_Creation_Script	26 Jun 2002 01:22:26 -0000	1.8
***************
*** 11,22 ****
  # RDBMS             : MySQL
  #
! ###############################################################################
! # Last Update # Who # Changes Made                                            #
! #-----------------------------------------------------------------------------#
! # Apr 5, 2002 # BAC # Initial Creation                                        #
! ###############################################################################
  # Who Key
  # BAC - Brian A Cheeseman
  #
  
  #
--- 11,89 ----
  # RDBMS             : MySQL
  #
! 
! ################################################################################
! # Last Update  # Who # Changes Made                                            #
! #------------------------------------------------------------------------------#
! # Apr  5, 2002 # BAC # Initial Creation                                        #
! #              #     #                                                         #
! # Jun 24, 2002 # CWS # Added Setup Instructions section. Added field 'term_ip' #
! #              #     # to table 'openPOS.Transactions'.  The purpose of this   #
! #              #     # is to provide a tracking methond for which terminal the #
! #              #     # transaction originated from. Also added 'HomePhone',    #
! #              #     # 'WorkPhone', and 'OtherPhone' to table                  #
! #              #     # 'openPOS.Customer'.                                     #
! #              #     #                                                         #
! ################################################################################
! #
  # Who Key
  # BAC - Brian A Cheeseman
+ # CWS - Chris W Shaffer
+ 
+ #
+ # Setup Instructions
+ #
+ # There are a few different ways to create teh database and insert the
+ # necessary records. The most straight-forward way is through the
+ # command line.  At your terminal prompt (DOS window), enter the following
+ # command:
+ #
+ #       %> mysql -uUSER -p /path/to/MySQL_Creation_Script.txt
  #
+ # where '%>' is your prompt (don't type that!) and USER is your database
+ # username.  You will be prompted for your database password, enter it, and
+ # if no error messages were generated, you have a freshly installed copy of
+ # the OpenPOS database and all the required tables. Now, to confirm that
+ # the database exists:
+ #
+ #        %> mysql -uUSER -p
+ #
+ # Once again, you will be prompted for your password.  After you enter you
+ # password, you will be greeted with the following prompt:
+ #
+ #        mysql>
+ #
+ # Execute the following commands:
+ #
+ #        mysql> USE openPOS;
+ #
+ #        mysql> SHOW tables;
+ #
+ # If all went well with your installation, you will be greeted with
+ # the following output:
+ #
+ #        +-------------------+
+ #        | Tables_in_openPOS |
+ #        +-------------------+
+ #        | auditlog          |
+ #        | configuration     |
+ #        | customers         |
+ #        | grouprights       |
+ #        | orderitems        |
+ #        | orders            |
+ #        | stock_list        |
+ #        | systemgroups      |
+ #        | systemusers       |
+ #        | transactions      |
+ #        | userrights        |
+ #        | usertogroup       |
+ #        +-------------------+
+ #        12 rows in set (0.00 sec)
+ #
+ # Congratulations, you are now ready to procede with the rest of the
+ # OpenPOSS setup.
+ #
+ #
+ ########################################################################
+ 
  
  #
***************
*** 119,122 ****
--- 186,190 ----
                                     uid int,
                                     oid int,
+                                    term_ip varchar(15),
                                     DT datetime,
                                     KEY idx_Transaction_uid (uid));
***************
*** 159,161 ****
--- 227,232 ----
  				        BillingZip char(10),
  				        BillingCountry varchar(255),
+                                         HomePhone varchar(25) NULL,
+ 				        WorkPhone varchar(25) NULL,
+ 				        OtherPhone varchar(25) NULL, 
  				        KEY idx_Customer_Surname (Surname(10)));