[Openposs-cvs-commits] CVS: Database MySQL_Creation_Script,1.12,1.13

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

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');
  
  #**********************************************************