Update of /cvsroot/openposs/Database
In directory usw-pr-cvs1:/tmp/cvs-serv23835
Modified Files:
MySQL_Creation_Script
Log Message:
Added SuperUser permission to user Admin
Index: MySQL_Creation_Script
===================================================================
RCS file: /cvsroot/openposs/Database/MySQL_Creation_Script,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** MySQL_Creation_Script 9 Jul 2002 01:14:52 -0000 1.12
--- MySQL_Creation_Script 14 Jul 2002 19:52:13 -0000 1.13
***************
*** 115,131 ****
#
# 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 '',
! Description text,
! catagory int(6) NOT NULL default '999999',
! OrderCode varchar(50) NOT NULL default "",
! ScanCode varchar(50) NOT NULL default "",
! Cost decimal(7,2) unsigned NOT NULL default '0.00',
! Price decimal(7,2) unsigned NOT NULL default 0.00,
! StockLevel int NOT NULL default 0,
! MinStockLevel int NOT NULL default 0,
! StorageCap int NOT NULL default 0,
! ShelfCap int NOT NULL default 0,
! KEY idx_ScanCode (ScanCode(10)) );
#
--- 115,135 ----
#
# 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 '',
! Description text,
! catagory int(6) NOT NULL default '999999',
! OrderCode varchar(50) NOT NULL default '',
! ScanCode varchar(50) NOT NULL default '',
! Cost decimal(7,2) unsigned NOT NULL default '0.00',
! Price decimal(7,2) NOT NULL default '0.00',
! StockLevel int(11) NOT NULL default '0',
! MinStockLevel int(11) NOT NULL default '0',
! StorageCap int(11) NOT NULL default '0',
! ShelfCap int(11) NOT NULL default '0',
! PRIMARY KEY (sku),
! KEY idx_ScanCode (ScanCode(10))
! ) TYPE=MyISAM;
!
#
***************
*** 143,147 ****
# 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, 1);
#
--- 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);
#
***************
*** 167,174 ****
#--------REMOVE ME ONCE REAL MODULES ARE AVAILBE!!!-------
! INSERT INTO modules VALUES ('Transaction', 'The transaction module', 'A', 'Y');
! INSERT INTO modules VALUES ('Inventory', 'The inventory management module', 'A', 'Y');
! INSERT INTO modules VALUES ('Quote', NULL, 'A', 'Y');
! INSERT INTO modules VALUES ('Scheduling', NULL, 'I', 'Y');
#**********************************************************
--- 171,178 ----
#--------REMOVE ME ONCE REAL MODULES ARE AVAILBE!!!-------
! INSERT INTO modules VALUES ('Transaction', 'The transaction module','0.1.0','A', 'Y');
! INSERT INTO modules VALUES ('Inventory', 'The inventory management module','0.1.0','A', 'Y');
! INSERT INTO modules VALUES ('Quote', NULL,'0.1.0', 'A', 'Y');
! INSERT INTO modules VALUES ('Scheduling', NULL,'0.1.0', 'I', 'Y');
#**********************************************************
|
