|
From: <ope...@li...> - 2002-07-14 23:25:57
|
Update of /cvsroot/openposs/Database
In directory usw-pr-cvs1:/tmp/cvs-serv4059
Modified Files:
MySQL_Creation_Script
Log Message:
Took away Create openPOS statemnt. Will now rely on users to have there database created before executing the shell script. In future, have web-based install.
Index: MySQL_Creation_Script
===================================================================
RCS file: /cvsroot/openposs/Database/MySQL_Creation_Script,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** MySQL_Creation_Script 14 Jul 2002 19:52:13 -0000 1.13
--- MySQL_Creation_Script 14 Jul 2002 23:25:54 -0000 1.14
***************
*** 11,29 ****
# 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'. #
! # Jun 27,2002 # CWS # Added modules table. #
! # Jun 28,2002 # CWS # Primed modules table with generic values. once 'real' #
! # # # modules are avaiable, these need to be removed #
! ################################################################################
#
# Who Key
--- 11,29 ----
# 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 '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 *
! # * * 'Customer'. *
! # Jun 27,2002 * CWS * Added modules table. *
! # Jun 28,2002 * CWS * Primed modules table with generic values. once 'real' *
! # * * modules are avaiable, these need to be removed *
! #*******************************************************************************
#
# Who Key
***************
*** 39,46 ****
# 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
--- 39,50 ----
# command:
#
! # %> mysqladmin openPOS
! # %> mysql -uUSER -p /path/to/MySQL_Creation_Script
#
# where '%>' is your prompt (don't type that!) and USER is your database
! # username. The first line creates that database. If you wish to use
! # another name besides 'openPOS', then you should change that in the command
! # you issue, as well as the first line after the instructions in this file.
! # 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
***************
*** 85,102 ****
#
#
! ########################################################################
- #
- # Create the database
- #
- CREATE DATABASE openPOS;
USE openPOS;
#
# Create the Configuration Table
#
# This table is used to hold System Wide configurational information.
! CREATE TABLE openPOS.Configuration (`Parameter` varchar(255) NOT NULL default "",
`Value` varchar(255) NOT NULL default "");
--- 89,105 ----
#
#
! #
+ #Change the line below to what you named your database
USE openPOS;
+ #**********Do not edit below this line*********************
+
#
# Create the Configuration Table
#
# This table is used to hold System Wide configurational information.
! CREATE TABLE Configuration (`Parameter` varchar(255) NOT NULL default "",
`Value` varchar(255) NOT NULL default "");
***************
*** 104,113 ****
# Insert the default configuration into the configuration table
#
! INSERT INTO openPOS.Configuration (`Parameter`, `Value`) VALUES ("DBVersion", "DEV 0.1");
! INSERT INTO openPOS.Configuration (`Parameter`, `Value`) VALUES ("modUserManage", "On");
! INSERT INTO openPOS.Configuration (`Parameter`, `Value`) VALUES ("modUserLogin", "On");
! INSERT INTO openPOS.Configuration (`Parameter`, `Value`) VALUES ("modUserSecurity", "On");
! INSERT INTO openPOS.Configuration (`Parameter`, `Value`) VALUES ("modUserTypes", "On");
! INSERT INTO openPOS.Configuration (`Parameter`, `Value`) VALUES ("systemInstalled", "No");
#
--- 107,116 ----
# Insert the default configuration into the configuration table
#
! INSERT INTO Configuration (`Parameter`, `Value`) VALUES ("DBVersion", "DEV 0.1");
! INSERT INTO Configuration (`Parameter`, `Value`) VALUES ("modUserManage", "On");
! INSERT INTO Configuration (`Parameter`, `Value`) VALUES ("modUserLogin", "On");
! INSERT INTO Configuration (`Parameter`, `Value`) VALUES ("modUserSecurity", "On");
! INSERT INTO Configuration (`Parameter`, `Value`) VALUES ("modUserTypes", "On");
! INSERT INTO Configuration (`Parameter`, `Value`) VALUES ("systemInstalled", "No");
#
***************
*** 115,119 ****
#
# This table contains all the information describing the products available.
! CREATE TABLE openPOS.stock_list (
sku int(6) unsigned zerofill NOT NULL auto_increment,
Product varchar(100) NOT NULL default '',
--- 118,122 ----
#
# This table contains all the information describing the products available.
! CREATE TABLE stock_list (
sku int(6) unsigned zerofill NOT NULL auto_increment,
Product varchar(100) NOT NULL default '',
***************
*** 137,141 ****
#
# This table holds a list of users permitted to access the system.
! CREATE TABLE openPOS.SystemUsers (uid int auto_increment PRIMARY KEY,
UserName varchar(255) NOT NULL default "",
FullName varchar(255) NOT NULL default "",
--- 140,144 ----
#
# This table holds a list of users permitted to access the system.
! CREATE TABLE SystemUsers (uid int auto_increment PRIMARY KEY,
UserName varchar(255) NOT NULL default "",
FullName varchar(255) NOT NULL default "",
***************
*** 147,151 ****
# Password field correlates to "openPOS". The password of this user should be changed
# immediately on a production server, as this account can change anything within the system.
! INSERT INTO openPOS.SystemUsers (UserName, FullName, Password, Active, SuperUser) VALUES ("Admin", "openPOS Admin User", "7c524cbe562633af1c281279e048dc5b", 1, 127);
#
--- 150,154 ----
# Password field correlates to "openPOS". The password of this user should be changed
# immediately on a production server, as this account can change anything within the system.
! INSERT INTO SystemUsers (UserName, FullName, Password, Active, SuperUser) VALUES ("Admin", "openPOS Admin User", "7c524cbe562633af1c281279e048dc5b", 1, 127);
#
***************
*** 153,157 ****
#
# This table holds a list of Groups which should be user definable.
! CREATE TABLE openPOS.SystemGroups (gid int auto_increment PRIMARY KEY,
GroupName varchar(255) NOT NULL default "",
Active tinyint NOT NULL default 1);
--- 156,160 ----
#
# This table holds a list of Groups which should be user definable.
! CREATE TABLE SystemGroups (gid int auto_increment PRIMARY KEY,
GroupName varchar(255) NOT NULL default "",
Active tinyint NOT NULL default 1);
***************
*** 161,165 ****
#
! CREATE TABLE openPOS.modules (
name varchar(25) NOT NULL default '',
desciption varchar(100) default NULL,
--- 164,168 ----
#
! CREATE TABLE modules (
name varchar(25) NOT NULL default '',
desciption varchar(100) default NULL,
***************
*** 185,189 ****
#
# This table is used to link users to the groups which they belong.
! CREATE TABLE openPOS.UserToGroup (uid int NOT NULL PRIMARY KEY,
gid int NOT NULL,
KEY idx_gid (gid));
--- 188,192 ----
#
# This table is used to link users to the groups which they belong.
! CREATE TABLE UserToGroup (uid int NOT NULL PRIMARY KEY,
gid int NOT NULL,
KEY idx_gid (gid));
***************
*** 193,197 ****
#
# This table allows for giving specific users specific rights.
! CREATE TABLE openPOS.UserRights (uid int PRIMARY KEY,
Access int);
--- 196,200 ----
#
# This table allows for giving specific users specific rights.
! CREATE TABLE UserRights (uid int PRIMARY KEY,
Access int);
***************
*** 200,204 ****
#
# This table allows for setting rights for a group of users.
! CREATE TABLE openPOS.GroupRights (gid int PRIMARY KEY,
ACCESS int);
--- 203,207 ----
#
# This table allows for setting rights for a group of users.
! CREATE TABLE GroupRights (gid int PRIMARY KEY,
ACCESS int);
***************
*** 207,211 ****
#
# This table is used to log all actions performed by the users.
! CREATE TABLE openPOS.AuditLog (aid int auto_increment PRIMARY KEY,
uid int,
DT datetime,
--- 210,214 ----
#
# This table is used to log all actions performed by the users.
! CREATE TABLE AuditLog (aid int auto_increment PRIMARY KEY,
uid int,
DT datetime,
***************
*** 217,221 ****
#
# This table is used to track transactions performed by users.
! CREATE TABLE openPOS.Transactions (tid int auto_increment PRIMARY KEY,
uid int,
oid int,
--- 220,224 ----
#
# This table is used to track transactions performed by users.
! CREATE TABLE Transactions (tid int auto_increment PRIMARY KEY,
uid int,
oid int,
***************
*** 229,233 ****
# This table is used to link an Order/Transaction Number to
# the items involved in the Order/Transaction.
! CREATE TABLE openPOS.OrderItems (iid int PRIMARY KEY,
sid int);
--- 232,236 ----
# This table is used to link an Order/Transaction Number to
# the items involved in the Order/Transaction.
! CREATE TABLE OrderItems (iid int PRIMARY KEY,
sid int);
***************
*** 238,242 ****
# system. This allows for auto-notification to users that an order
# is able to be completed for a given customer.
! CREATE TABLE openPOS.Orders (oid int auto_increment PRIMARY KEY,
iid int,
cid int);
--- 241,245 ----
# system. This allows for auto-notification to users that an order
# is able to be completed for a given customer.
! CREATE TABLE Orders (oid int auto_increment PRIMARY KEY,
iid int,
cid int);
***************
*** 248,252 ****
# information will be used for orders which are placed through
# the retail outlet.
! CREATE TABLE openPOS.Customers (cid int auto_increment PRIMARY KEY,
Surname varchar(255),
GivenNames varchar(255),
--- 251,255 ----
# information will be used for orders which are placed through
# the retail outlet.
! CREATE TABLE Customers (cid int auto_increment PRIMARY KEY,
Surname varchar(255),
GivenNames varchar(255),
|