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)));
|
