Ngiler SH3LL 360
Home
Information
Create File
Create Folder
:
/
var
/
softaculous
/
ospos
/
Information Server
MySQL :
OFF
Perl :
OFF
CURL :
ON
WGET :
OFF
PKEXEC :
OFF
Directive
Local Value
IP Address
63.250.38.10
System
Linux premium90.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
User
likhxapw
PHP Version
8.3.30
Software
LiteSpeed
Doc root
Writable
close
Edit File :
ospos.sql
| Size :
45.83
KB
Copy
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `ospos341` -- -- -------------------------------------------------------- -- -- Table structure for table `ospos_app_config` -- CREATE TABLE `ospos_app_config` ( `key` varchar(50) NOT NULL, `value` varchar(500) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `ospos_app_config` -- INSERT INTO `ospos_app_config` VALUES ('account_number', ''), ('address', '123 Nowhere street'), ('allow_duplicate_barcodes', '0'), ('barcode_content', 'id'), ('barcode_first_row', 'category'), ('barcode_font', 'Arial'), ('barcode_font_size', '10'), ('barcode_formats', '[]'), ('barcode_generate_if_empty', '0'), ('barcode_height', '50'), ('barcode_num_in_row', '2'), ('barcode_page_cellspacing', '20'), ('barcode_page_width', '100'), ('barcode_second_row', 'item_code'), ('barcode_third_row', 'unit_price'), ('barcode_type', 'C39'), ('barcode_width', '250'), ('cash_decimals', '2'), ('cash_rounding_code', '0'), ('category_dropdown', ''), ('company', 'Open Source Point of Sale'), ('company_logo', ''), ('country_codes', 'us'), ('currency_code', ''), ('currency_decimals', '2'), ('currency_symbol', '$'), ('customer_reward_enable', '0'), ('dateformat', 'm/d/Y'), ('date_or_time_format', ''), ('default_receivings_discount', '0'), ('default_receivings_discount_type', '0'), ('default_register_mode', 'sale'), ('default_sales_discount', '0'), ('default_sales_discount_type', '0'), ('default_tax_1_name', ''), ('default_tax_1_rate', ''), ('default_tax_2_name', ''), ('default_tax_2_rate', ''), ('default_tax_category', 'Standard'), ('default_tax_code', ''), ('default_tax_jurisdiction', ''), ('default_tax_rate', '8'), ('derive_sale_quantity', '0'), ('dinner_table_enable', '0'), ('email', 'changeme@example.com'), ('email_receipt_check_behaviour', 'last'), ('enforce_privacy', '0'), ('fax', ''), ('financial_year', '1'), ('gcaptcha_enable', '0'), ('gcaptcha_secret_key', ''), ('gcaptcha_site_key', ''), ('giftcard_number', 'series'), ('image_allowed_types', 'gif,jpg,png'), ('image_max_height', '480'), ('image_max_size', '128'), ('image_max_width', '640'), ('include_hsn', '0'), ('invoice_default_comments', 'This is a default comment'), ('invoice_email_message', 'Dear {CU}, In attachment the receipt for sale {ISEQ}'), ('invoice_enable', '1'), ('invoice_type', 'invoice'), ('language', 'english'), ('language_code', 'en'), ('last_used_invoice_number', '0'), ('last_used_quote_number', '0'), ('last_used_work_order_number', '0'), ('lines_per_page', '25'), ('line_sequence', '0'), ('login_form', ''), ('mailpath', '/usr/sbin/sendmail'), ('msg_msg', ''), ('msg_pwd', ''), ('msg_src', ''), ('msg_uid', ''), ('multi_pack_enabled', '0'), ('notify_horizontal_position', 'center'), ('notify_vertical_position', 'bottom'), ('number_locale', 'en_US'), ('payment_message', ''), ('payment_options_order', 'cashdebitcredit'), ('phone', '555-555-5555'), ('print_bottom_margin', '0'), ('print_delay_autoreturn', '0'), ('print_footer', '0'), ('print_header', '0'), ('print_left_margin', '0'), ('print_receipt_check_behaviour', 'last'), ('print_right_margin', '0'), ('print_silently', '1'), ('print_top_margin', '0'), ('protocol', 'mail'), ('quantity_decimals', '0'), ('quote_default_comments', 'This is a default quote comment'), ('receipt_font_size', '12'), ('receipt_show_company_name', '1'), ('receipt_show_description', '1'), ('receipt_show_serialnumber', '1'), ('receipt_show_taxes', '0'), ('receipt_show_tax_ind', '0'), ('receipt_show_total_discount', '1'), ('receipt_template', 'receipt_default'), ('receiving_calculate_average_price', ''), ('recv_invoice_format', '{CO}'), ('return_policy', 'Test'), ('sales_invoice_format', '{CO}'), ('sales_quote_format', 'Q%y{QSEQ:6}'), ('smtp_crypto', 'ssl'), ('smtp_host', ''), ('smtp_pass', ''), ('smtp_port', '465'), ('smtp_timeout', '5'), ('smtp_user', ''), ('statistics', '1'), ('suggestions_first_column', 'name'), ('suggestions_second_column', ''), ('suggestions_third_column', ''), ('tax_decimals', '2'), ('tax_id', ''), ('tax_included', '0'), ('theme', 'flatly'), ('thousands_separator', '1'), ('timeformat', 'H:i:s'), ('timezone', 'America/New_York'), ('use_destination_based_tax', '0'), ('website', ''), ('work_order_enable', '0'), ('work_order_format', 'W%y{WSEQ:6}'); -- -------------------------------------------------------- -- -- Table structure for table `ospos_attribute_definitions` -- CREATE TABLE `ospos_attribute_definitions` ( `definition_id` int(10) NOT NULL AUTO_INCREMENT, `definition_name` varchar(255) NOT NULL, `definition_type` varchar(45) NOT NULL, `definition_unit` varchar(16) DEFAULT NULL, `definition_flags` tinyint(1) NOT NULL, `definition_fk` int(10) DEFAULT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`definition_id`), KEY `definition_fk` (`definition_fk`), KEY `definition_name` (`definition_name`), KEY `definition_type` (`definition_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_attribute_links` -- CREATE TABLE `ospos_attribute_links` ( `attribute_id` int(11) DEFAULT NULL, `definition_id` int(11) NOT NULL, `item_id` int(11) DEFAULT NULL, `sale_id` int(11) DEFAULT NULL, `receiving_id` int(11) DEFAULT NULL, UNIQUE KEY `attribute_links_uq1` (`attribute_id`,`definition_id`,`item_id`,`sale_id`,`receiving_id`), UNIQUE KEY `attribute_links_uq2` (`item_id`,`receiving_id`,`sale_id`,`definition_id`,`attribute_id`), KEY `attribute_id` (`attribute_id`), KEY `definition_id` (`definition_id`), KEY `item_id` (`item_id`), KEY `sale_id` (`sale_id`), KEY `receiving_id` (`receiving_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_attribute_values` -- CREATE TABLE `ospos_attribute_values` ( `attribute_id` int(11) NOT NULL AUTO_INCREMENT, `attribute_value` varchar(255) DEFAULT NULL, `attribute_date` date DEFAULT NULL, `attribute_decimal` decimal(7,3) DEFAULT NULL, PRIMARY KEY (`attribute_id`), UNIQUE KEY `attribute_value` (`attribute_value`), UNIQUE KEY `attribute_date` (`attribute_date`), UNIQUE KEY `attribute_decimal` (`attribute_decimal`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_cash_up` -- CREATE TABLE `ospos_cash_up` ( `cashup_id` int(10) NOT NULL AUTO_INCREMENT, `open_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `close_date` timestamp NULL DEFAULT NULL, `open_amount_cash` decimal(15,2) NOT NULL, `transfer_amount_cash` decimal(15,2) NOT NULL, `note` tinyint(4) NOT NULL DEFAULT '0', `closed_amount_cash` decimal(15,2) NOT NULL, `closed_amount_card` decimal(15,2) NOT NULL, `closed_amount_check` decimal(15,2) NOT NULL, `closed_amount_total` decimal(15,2) NOT NULL, `description` varchar(255) NOT NULL, `open_employee_id` int(10) NOT NULL, `close_employee_id` int(10) NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', `closed_amount_due` decimal(15,2) NOT NULL, PRIMARY KEY (`cashup_id`), KEY `open_employee_id` (`open_employee_id`), KEY `close_employee_id` (`close_employee_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_customers` -- CREATE TABLE `ospos_customers` ( `person_id` int(10) NOT NULL, `company_name` varchar(255) DEFAULT NULL, `account_number` varchar(255) DEFAULT NULL, `taxable` tinyint(1) NOT NULL DEFAULT '1', `tax_id` varchar(32) NOT NULL DEFAULT '', `sales_tax_code_id` int(11) DEFAULT NULL, `package_id` int(11) DEFAULT NULL, `points` int(11) DEFAULT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', `discount` decimal(15,2) NOT NULL DEFAULT '0.00', `discount_type` tinyint(1) NOT NULL DEFAULT '0', `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `employee_id` int(10) NOT NULL, `consent` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`person_id`), KEY `package_id` (`package_id`), KEY `sales_tax_code_id` (`sales_tax_code_id`), KEY `account_number` (`account_number`), KEY `company_name` (`company_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_customers_packages` -- CREATE TABLE `ospos_customers_packages` ( `package_id` int(11) NOT NULL AUTO_INCREMENT, `package_name` varchar(255) DEFAULT NULL, `points_percent` float NOT NULL DEFAULT '0', `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`package_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; -- -- Dumping data for table `ospos_customers_packages` -- INSERT INTO `ospos_customers_packages` VALUES (1, 'Default', 0, 0), (2, 'Bronze', 10, 0), (3, 'Silver', 20, 0), (4, 'Gold', 30, 0), (5, 'Premium', 50, 0); -- -------------------------------------------------------- -- -- Table structure for table `ospos_customers_points` -- CREATE TABLE `ospos_customers_points` ( `id` int(11) NOT NULL AUTO_INCREMENT, `person_id` int(11) NOT NULL, `package_id` int(11) NOT NULL, `sale_id` int(11) NOT NULL, `points_earned` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `person_id` (`person_id`), KEY `package_id` (`package_id`), KEY `sale_id` (`sale_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_dinner_tables` -- CREATE TABLE `ospos_dinner_tables` ( `dinner_table_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT '0', `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`dinner_table_id`), KEY `status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `ospos_dinner_tables` -- INSERT INTO `ospos_dinner_tables` VALUES (1, 'Delivery', 0, 0), (2, 'Take Away', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `ospos_employees` -- CREATE TABLE `ospos_employees` ( `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `person_id` int(10) NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', `hash_version` tinyint(1) NOT NULL DEFAULT '2', `language` varchar(48) DEFAULT NULL, `language_code` varchar(8) DEFAULT NULL, PRIMARY KEY (`person_id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `ospos_employees` -- INSERT INTO `ospos_employees` VALUES ('[[admin_username]]', '[[admin_pass]]', 1, 0, 2, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `ospos_expenses` -- CREATE TABLE `ospos_expenses` ( `expense_id` int(10) NOT NULL AUTO_INCREMENT, `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `amount` decimal(15,2) NOT NULL, `payment_type` varchar(40) NOT NULL, `expense_category_id` int(11) NOT NULL, `description` varchar(255) NOT NULL, `employee_id` int(10) NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', `supplier_tax_code` varchar(255) DEFAULT NULL, `tax_amount` decimal(15,2) DEFAULT NULL, `supplier_id` int(10) DEFAULT NULL, PRIMARY KEY (`expense_id`), KEY `expense_category_id` (`expense_category_id`), KEY `employee_id` (`employee_id`), KEY `date` (`date`), KEY `payment_type` (`payment_type`), KEY `amount` (`amount`), KEY `ospos_expenses_ibfk_3` (`supplier_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_expense_categories` -- CREATE TABLE `ospos_expense_categories` ( `expense_category_id` int(10) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) DEFAULT NULL, `category_description` varchar(255) NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`expense_category_id`), UNIQUE KEY `category_name` (`category_name`), KEY `category_description` (`category_description`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_giftcards` -- CREATE TABLE `ospos_giftcards` ( `record_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `giftcard_id` int(11) NOT NULL AUTO_INCREMENT, `giftcard_number` varchar(255) DEFAULT NULL, `value` decimal(15,2) NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', `person_id` int(10) DEFAULT NULL, PRIMARY KEY (`giftcard_id`), UNIQUE KEY `giftcard_number` (`giftcard_number`), KEY `person_id` (`person_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_grants` -- CREATE TABLE `ospos_grants` ( `permission_id` varchar(255) NOT NULL, `person_id` int(10) NOT NULL, `menu_group` varchar(32) DEFAULT 'home', PRIMARY KEY (`permission_id`,`person_id`), KEY `ospos_grants_ibfk_2` (`person_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `ospos_grants` -- INSERT INTO `ospos_grants` VALUES ('attributes', 1, 'office'), ('cashups', 1, 'home'), ('config', 1, 'office'), ('customers', 1, 'home'), ('employees', 1, 'office'), ('expenses', 1, 'home'), ('expenses_categories', 1, 'office'), ('giftcards', 1, 'home'), ('home', 1, 'office'), ('items', 1, 'home'), ('items_stock', 1, 'home'), ('item_kits', 1, 'home'), ('messages', 1, 'home'), ('office', 1, 'home'), ('receivings', 1, 'home'), ('receivings_stock', 1, 'home'), ('reports', 1, 'home'), ('reports_categories', 1, 'home'), ('reports_customers', 1, 'home'), ('reports_discounts', 1, 'home'), ('reports_employees', 1, 'home'), ('reports_expenses_categories', 1, 'home'), ('reports_inventory', 1, 'home'), ('reports_items', 1, 'home'), ('reports_payments', 1, 'home'), ('reports_receivings', 1, 'home'), ('reports_sales', 1, 'home'), ('reports_sales_taxes', 1, 'home'), ('reports_suppliers', 1, 'home'), ('reports_taxes', 1, 'home'), ('sales', 1, 'home'), ('sales_change_price', 1, '--'), ('sales_delete', 1, '--'), ('sales_stock', 1, 'home'), ('suppliers', 1, 'home'); -- -------------------------------------------------------- -- -- Table structure for table `ospos_inventory` -- CREATE TABLE `ospos_inventory` ( `trans_id` int(11) NOT NULL AUTO_INCREMENT, `trans_items` int(11) NOT NULL DEFAULT '0', `trans_user` int(11) NOT NULL DEFAULT '0', `trans_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `trans_comment` text NOT NULL, `trans_location` int(11) NOT NULL, `trans_inventory` decimal(15,3) NOT NULL DEFAULT '0.000', PRIMARY KEY (`trans_id`), KEY `trans_items` (`trans_items`), KEY `trans_user` (`trans_user`), KEY `trans_location` (`trans_location`), KEY `trans_date` (`trans_date`), KEY `trans_items_trans_date` (`trans_items`,`trans_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_items` -- CREATE TABLE `ospos_items` ( `name` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `supplier_id` int(11) DEFAULT NULL, `item_number` varchar(255) DEFAULT NULL, `description` varchar(255) NOT NULL, `cost_price` decimal(15,2) NOT NULL, `unit_price` decimal(15,2) NOT NULL, `reorder_level` decimal(15,3) NOT NULL DEFAULT '0.000', `receiving_quantity` decimal(15,3) NOT NULL DEFAULT '1.000', `item_id` int(10) NOT NULL AUTO_INCREMENT, `pic_filename` varchar(255) DEFAULT NULL, `allow_alt_description` tinyint(1) NOT NULL, `is_serialized` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', `stock_type` tinyint(1) NOT NULL DEFAULT '0', `item_type` tinyint(1) NOT NULL DEFAULT '0', `tax_category_id` int(10) DEFAULT NULL, `qty_per_pack` decimal(15,3) NOT NULL DEFAULT '1.000', `pack_name` varchar(8) DEFAULT 'Each', `low_sell_item_id` int(10) DEFAULT '0', `hsn_code` varchar(32) NOT NULL DEFAULT '', PRIMARY KEY (`item_id`), UNIQUE KEY `items_uq1` (`supplier_id`,`item_id`,`deleted`,`item_type`), KEY `supplier_id` (`supplier_id`), KEY `item_number` (`item_number`), KEY `deleted` (`deleted`,`item_type`), KEY `item_id` (`item_id`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_items_taxes` -- CREATE TABLE `ospos_items_taxes` ( `item_id` int(10) NOT NULL, `name` varchar(255) NOT NULL, `percent` decimal(15,3) NOT NULL, PRIMARY KEY (`item_id`,`name`,`percent`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_item_kits` -- CREATE TABLE `ospos_item_kits` ( `item_kit_id` int(11) NOT NULL AUTO_INCREMENT, `item_kit_number` varchar(255) DEFAULT NULL, `name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `item_id` int(10) NOT NULL DEFAULT '0', `kit_discount` decimal(15,2) NOT NULL DEFAULT '0.00', `kit_discount_type` tinyint(1) NOT NULL DEFAULT '0', `price_option` tinyint(1) NOT NULL DEFAULT '0', `print_option` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`item_kit_id`), KEY `item_kit_number` (`item_kit_number`), KEY `name` (`name`,`description`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_item_kit_items` -- CREATE TABLE `ospos_item_kit_items` ( `item_kit_id` int(11) NOT NULL, `item_id` int(11) NOT NULL, `quantity` decimal(15,3) NOT NULL, `kit_sequence` int(3) NOT NULL DEFAULT '0', PRIMARY KEY (`item_kit_id`,`item_id`,`quantity`), KEY `ospos_item_kit_items_ibfk_2` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_item_quantities` -- CREATE TABLE `ospos_item_quantities` ( `item_id` int(11) NOT NULL, `location_id` int(11) NOT NULL, `quantity` decimal(15,3) NOT NULL DEFAULT '0.000', PRIMARY KEY (`item_id`,`location_id`), KEY `item_id` (`item_id`), KEY `location_id` (`location_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_migrations` -- CREATE TABLE `ospos_migrations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `version` varchar(255) NOT NULL, `class` varchar(255) NOT NULL, `group` varchar(255) NOT NULL, `namespace` varchar(255) NOT NULL, `time` int(11) NOT NULL, `batch` int(11) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=41 ; -- -- Dumping data for table `ospos_migrations` -- INSERT INTO `ospos_migrations` VALUES (1, '20170501150000', 'App\\Database\\Migrations\\Migration_Upgrade_To_3_1_1', 'default', 'App', [[timestamp]], 1), (2, '20170502221506', 'App\\Database\\Migrations\\Migration_Sales_Tax_Data', 'default', 'App', [[timestamp]], 1), (3, '20180225100000', 'App\\Database\\Migrations\\Migration_Upgrade_To_3_2_0', 'default', 'App', [[timestamp]], 1), (4, '20180501100000', 'App\\Database\\Migrations\\Migration_Upgrade_To_3_2_1', 'default', 'App', [[timestamp]], 1), (5, '20181015100000', 'App\\Database\\Migrations\\Migration_Attributes', 'default', 'App', [[timestamp]], 1), (6, '20190111270000', 'App\\Database\\Migrations\\Migration_Upgrade_To_3_3_0', 'default', 'App', [[timestamp]], 1), (7, '20190129212600', 'App\\Database\\Migrations\\Migration_IndiaGST', 'default', 'App', [[timestamp]], 1), (8, '20190213210000', 'App\\Database\\Migrations\\Migration_IndiaGST1', 'default', 'App', [[timestamp]], 1), (9, '20190220210000', 'App\\Database\\Migrations\\Migration_IndiaGST2', 'default', 'App', [[timestamp]], 1), (10, '20190301124900', 'App\\Database\\Migrations\\Migration_decimal_attribute_type', 'default', 'App', [[timestamp]], 1), (11, '20190317102600', 'App\\Database\\Migrations\\Migration_add_iso_4217', 'default', 'App', [[timestamp]], 1), (12, '20190427100000', 'App\\Database\\Migrations\\Migration_PaymentTracking', 'default', 'App', [[timestamp]], 1), (13, '20190502100000', 'App\\Database\\Migrations\\Migration_RefundTracking', 'default', 'App', [[timestamp]], 1), (14, '20190612100000', 'App\\Database\\Migrations\\Migration_DBFix', 'default', 'App', [[timestamp]], 1), (15, '20190615100000', 'App\\Database\\Migrations\\Migration_fix_attribute_datetime', 'default', 'App', [[timestamp]], 1), (16, '20190712150200', 'App\\Database\\Migrations\\Migration_fix_empty_reports', 'default', 'App', [[timestamp]], 1), (17, '20191008100000', 'App\\Database\\Migrations\\Migration_receipttaxindicator', 'default', 'App', [[timestamp]], 1), (18, '20191231100000', 'App\\Database\\Migrations\\Migration_PaymentDateFix', 'default', 'App', [[timestamp]], 1), (19, '20200125100000', 'App\\Database\\Migrations\\Migration_SalesChangePrice', 'default', 'App', [[timestamp]], 1), (20, '20200202000000', 'App\\Database\\Migrations\\Migration_TaxAmount', 'default', 'App', [[timestamp]], 1), (21, '20200215100000', 'App\\Database\\Migrations\\Migration_taxgroupconstraint', 'default', 'App', [[timestamp]], 1), (22, '20200508000000', 'App\\Database\\Migrations\\Migration_image_upload_defaults', 'default', 'App', [[timestamp]], 1), (23, '20200819000000', 'App\\Database\\Migrations\\Migration_modify_attr_links_constraint', 'default', 'App', [[timestamp]], 1), (24, '20201108100000', 'App\\Database\\Migrations\\Migration_cashrounding', 'default', 'App', [[timestamp]], 1), (25, '20201110000000', 'App\\Database\\Migrations\\Migration_add_item_kit_number', 'default', 'App', [[timestamp]], 1), (26, '20210103000000', 'App\\Database\\Migrations\\Migration_modify_session_datatype', 'default', 'App', [[timestamp]], 1), (27, '20210422000000', 'App\\Database\\Migrations\\Migration_database_optimizations', 'default', 'App', [[timestamp]], 1), (28, '20210422000001', 'App\\Database\\Migrations\\Migration_remove_duplicate_links', 'default', 'App', [[timestamp]], 1), (29, '20210714140000', 'App\\Database\\Migrations\\Migration_move_expenses_categories', 'default', 'App', [[timestamp]], 1), (30, '20220127000000', 'App\\Database\\Migrations\\Convert_to_ci4', 'default', 'App', [[timestamp]], 1), (31, '20230307000000', 'App\\Database\\Migrations\\IntToTinyint', 'default', 'App', [[timestamp]], 1), (32, '20230412000000', 'App\\Database\\Migrations\\Migration_add_missing_config', 'default', 'App', [[timestamp]], 1), (33, '20230412000001', 'App\\Database\\Migrations\\Migration_drop_account_number_index', 'default', 'App', [[timestamp]], 1), (34, '20240319000000', 'App\\Database\\Migrations\\Migration_Convert_Barcode_Types', 'default', 'App', [[timestamp]], 1), (35, '20240630000001', 'App\\Database\\Migrations\\Migration_fix_keys_for_db_upgrade', 'default', 'App', [[timestamp]], 1), (36, '20240826000000', 'App\\Database\\Migrations\\fix_duplicate_attributes', 'default', 'App', [[timestamp]], 1), (37, '20250213000000', 'App\\Database\\Migrations\\Migration_Attributes_fix_cascading_delete', 'default', 'App', [[timestamp]], 1), (38, '20250425000000', 'App\\Database\\Migrations\\Migration_sessions_migration', 'default', 'App', [[timestamp]], 1), (39, '20250519000000', 'App\\Database\\Migrations\\MigrationOptimizationIndices', 'default', 'App', [[timestamp]], 1), (40, '20250522000000', 'App\\Database\\Migrations\\AttributeLinksUniqueConstraint', 'default', 'App', [[timestamp]], 1); -- -------------------------------------------------------- -- -- Table structure for table `ospos_modules` -- CREATE TABLE `ospos_modules` ( `name_lang_key` varchar(255) NOT NULL, `desc_lang_key` varchar(255) NOT NULL, `sort` int(10) NOT NULL, `module_id` varchar(255) NOT NULL, PRIMARY KEY (`module_id`), UNIQUE KEY `desc_lang_key` (`desc_lang_key`), UNIQUE KEY `name_lang_key` (`name_lang_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `ospos_modules` -- INSERT INTO `ospos_modules` VALUES ('module_attributes', 'module_attributes_desc', 107, 'attributes'), ('module_cashups', 'module_cashups_desc', 110, 'cashups'), ('module_config', 'module_config_desc', 900, 'config'), ('module_customers', 'module_customers_desc', 10, 'customers'), ('module_employees', 'module_employees_desc', 80, 'employees'), ('module_expenses', 'module_expenses_desc', 108, 'expenses'), ('module_expenses_categories', 'module_expenses_categories_desc', 109, 'expenses_categories'), ('module_giftcards', 'module_giftcards_desc', 90, 'giftcards'), ('module_home', 'module_home_desc', 1, 'home'), ('module_items', 'module_items_desc', 20, 'items'), ('module_item_kits', 'module_item_kits_desc', 30, 'item_kits'), ('module_messages', 'module_messages_desc', 98, 'messages'), ('module_office', 'module_office_desc', 999, 'office'), ('module_receivings', 'module_receivings_desc', 60, 'receivings'), ('module_reports', 'module_reports_desc', 50, 'reports'), ('module_sales', 'module_sales_desc', 70, 'sales'), ('module_suppliers', 'module_suppliers_desc', 40, 'suppliers'), ('module_taxes', 'module_taxes_desc', 105, 'taxes'); -- -------------------------------------------------------- -- -- Table structure for table `ospos_people` -- CREATE TABLE `ospos_people` ( `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `gender` int(1) DEFAULT NULL, `phone_number` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `address_1` varchar(255) NOT NULL, `address_2` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `zip` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `comments` text NOT NULL, `person_id` int(10) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`person_id`), KEY `email` (`email`), KEY `first_name` (`first_name`,`last_name`,`email`,`phone_number`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `ospos_people` -- INSERT INTO `ospos_people` VALUES ('[[admin_fname]]', '[[admin_lname]]', NULL, '555-555-5555', '[[admin_email]]', 'Address 1', '', '', '', '', '', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `ospos_permissions` -- CREATE TABLE `ospos_permissions` ( `permission_id` varchar(255) NOT NULL, `module_id` varchar(255) NOT NULL, `location_id` int(10) DEFAULT NULL, PRIMARY KEY (`permission_id`), KEY `module_id` (`module_id`), KEY `ospos_permissions_ibfk_2` (`location_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `ospos_permissions` -- INSERT INTO `ospos_permissions` VALUES ('attributes', 'attributes', NULL), ('cashups', 'cashups', NULL), ('config', 'config', NULL), ('customers', 'customers', NULL), ('employees', 'employees', NULL), ('expenses', 'expenses', NULL), ('expenses_categories', 'expenses_categories', NULL), ('giftcards', 'giftcards', NULL), ('home', 'home', NULL), ('items', 'items', NULL), ('items_stock', 'items', 1), ('item_kits', 'item_kits', NULL), ('messages', 'messages', NULL), ('office', 'office', NULL), ('receivings', 'receivings', NULL), ('receivings_stock', 'receivings', 1), ('reports', 'reports', NULL), ('reports_categories', 'reports', NULL), ('reports_customers', 'reports', NULL), ('reports_discounts', 'reports', NULL), ('reports_employees', 'reports', NULL), ('reports_expenses_categories', 'reports', NULL), ('reports_inventory', 'reports', NULL), ('reports_items', 'reports', NULL), ('reports_payments', 'reports', NULL), ('reports_receivings', 'reports', NULL), ('reports_sales', 'reports', NULL), ('reports_sales_taxes', 'reports', NULL), ('reports_suppliers', 'reports', NULL), ('reports_taxes', 'reports', NULL), ('sales', 'sales', NULL), ('sales_change_price', 'sales', NULL), ('sales_delete', 'sales', NULL), ('sales_stock', 'sales', 1), ('suppliers', 'suppliers', NULL), ('taxes', 'taxes', NULL); -- -------------------------------------------------------- -- -- Table structure for table `ospos_receivings` -- CREATE TABLE `ospos_receivings` ( `receiving_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `supplier_id` int(10) DEFAULT NULL, `employee_id` int(10) NOT NULL DEFAULT '0', `comment` text NOT NULL, `receiving_id` int(10) NOT NULL AUTO_INCREMENT, `payment_type` varchar(20) DEFAULT NULL, `reference` varchar(32) DEFAULT NULL, PRIMARY KEY (`receiving_id`), KEY `supplier_id` (`supplier_id`), KEY `employee_id` (`employee_id`), KEY `reference` (`reference`), KEY `receiving_time` (`receiving_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_receivings_items` -- CREATE TABLE `ospos_receivings_items` ( `receiving_id` int(10) NOT NULL DEFAULT '0', `item_id` int(10) NOT NULL DEFAULT '0', `description` varchar(30) DEFAULT NULL, `serialnumber` varchar(30) DEFAULT NULL, `line` int(3) NOT NULL, `quantity_purchased` decimal(15,3) NOT NULL DEFAULT '0.000', `item_cost_price` decimal(15,2) NOT NULL, `item_unit_price` decimal(15,2) NOT NULL, `discount` decimal(15,2) NOT NULL DEFAULT '0.00', `discount_type` tinyint(1) NOT NULL DEFAULT '0', `item_location` int(11) NOT NULL, `receiving_quantity` decimal(15,3) NOT NULL DEFAULT '1.000', PRIMARY KEY (`receiving_id`,`item_id`,`line`), KEY `item_id` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_sales` -- CREATE TABLE `ospos_sales` ( `sale_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `customer_id` int(10) DEFAULT NULL, `employee_id` int(10) NOT NULL DEFAULT '0', `comment` text NOT NULL, `invoice_number` varchar(32) DEFAULT NULL, `dinner_table_id` int(11) DEFAULT NULL, `sale_id` int(10) NOT NULL AUTO_INCREMENT, `quote_number` varchar(32) DEFAULT NULL, `sale_status` tinyint(1) NOT NULL DEFAULT '0', `work_order_number` varchar(32) DEFAULT NULL, `sale_type` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`sale_id`), UNIQUE KEY `invoice_number` (`invoice_number`), KEY `customer_id` (`customer_id`), KEY `employee_id` (`employee_id`), KEY `sale_time` (`sale_time`), KEY `dinner_table_id` (`dinner_table_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_sales_items` -- CREATE TABLE `ospos_sales_items` ( `sale_id` int(10) NOT NULL DEFAULT '0', `item_id` int(10) NOT NULL DEFAULT '0', `description` varchar(255) DEFAULT NULL, `serialnumber` varchar(30) DEFAULT NULL, `line` int(3) NOT NULL DEFAULT '0', `quantity_purchased` decimal(15,3) NOT NULL DEFAULT '0.000', `item_cost_price` decimal(15,2) NOT NULL, `item_unit_price` decimal(15,2) NOT NULL, `discount` decimal(15,2) NOT NULL DEFAULT '0.00', `discount_type` tinyint(1) NOT NULL DEFAULT '0', `item_location` int(11) NOT NULL, `print_option` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`sale_id`,`item_id`,`line`), KEY `sale_id` (`sale_id`), KEY `item_id` (`item_id`), KEY `item_location` (`item_location`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_sales_items_taxes` -- CREATE TABLE `ospos_sales_items_taxes` ( `sale_id` int(10) NOT NULL, `item_id` int(10) NOT NULL, `line` int(3) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL, `percent` decimal(15,4) NOT NULL DEFAULT '0.0000', `tax_type` tinyint(1) NOT NULL DEFAULT '0', `rounding_code` tinyint(1) NOT NULL DEFAULT '0', `cascade_sequence` tinyint(1) NOT NULL DEFAULT '0', `item_tax_amount` decimal(15,4) NOT NULL DEFAULT '0.0000', `sales_tax_code_id` int(11) DEFAULT NULL, `jurisdiction_id` int(11) DEFAULT NULL, `tax_category_id` int(11) DEFAULT NULL, PRIMARY KEY (`sale_id`,`item_id`,`line`,`name`,`percent`), KEY `sale_id` (`sale_id`), KEY `item_id` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_sales_payments` -- CREATE TABLE `ospos_sales_payments` ( `payment_id` int(11) NOT NULL AUTO_INCREMENT, `sale_id` int(10) NOT NULL, `payment_type` varchar(40) NOT NULL, `payment_amount` decimal(15,2) NOT NULL, `cash_refund` decimal(15,2) NOT NULL DEFAULT '0.00', `cash_adjustment` tinyint(4) NOT NULL DEFAULT '0', `employee_id` int(11) DEFAULT NULL, `payment_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `reference_code` varchar(40) NOT NULL DEFAULT '', PRIMARY KEY (`payment_id`), KEY `payment_sale` (`sale_id`,`payment_type`), KEY `employee_id` (`employee_id`), KEY `payment_time` (`payment_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_sales_reward_points` -- CREATE TABLE `ospos_sales_reward_points` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sale_id` int(11) NOT NULL, `earned` float NOT NULL, `used` float NOT NULL, PRIMARY KEY (`id`), KEY `sale_id` (`sale_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_sales_taxes` -- CREATE TABLE `ospos_sales_taxes` ( `sales_taxes_id` int(11) NOT NULL AUTO_INCREMENT, `sale_id` int(10) NOT NULL, `jurisdiction_id` int(11) DEFAULT NULL, `tax_category_id` int(11) DEFAULT NULL, `tax_type` smallint(2) NOT NULL, `tax_group` varchar(32) NOT NULL, `sale_tax_basis` decimal(15,4) NOT NULL, `sale_tax_amount` decimal(15,4) NOT NULL, `print_sequence` tinyint(1) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL, `tax_rate` decimal(15,4) NOT NULL, `sales_tax_code_id` int(11) DEFAULT NULL, `rounding_code` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`sales_taxes_id`), KEY `print_sequence` (`sale_id`,`print_sequence`,`tax_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_sessions` -- CREATE TABLE `ospos_sessions` ( `id` varchar(128) NOT NULL, `ip_address` varchar(45) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `data` blob NOT NULL, PRIMARY KEY (`id`,`ip_address`), KEY `ospos_sessions_timestamp` (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_stock_locations` -- CREATE TABLE `ospos_stock_locations` ( `location_id` int(11) NOT NULL AUTO_INCREMENT, `location_name` varchar(255) DEFAULT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`location_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `ospos_stock_locations` -- INSERT INTO `ospos_stock_locations` VALUES (1, 'stock', 0); -- -------------------------------------------------------- -- -- Table structure for table `ospos_suppliers` -- CREATE TABLE `ospos_suppliers` ( `person_id` int(10) NOT NULL, `company_name` varchar(255) NOT NULL, `agency_name` varchar(255) NOT NULL, `account_number` varchar(255) DEFAULT NULL, `tax_id` varchar(32) NOT NULL DEFAULT '', `deleted` tinyint(1) NOT NULL DEFAULT '0', `category` tinyint(1) NOT NULL, PRIMARY KEY (`person_id`), UNIQUE KEY `account_number` (`account_number`), KEY `category` (`category`), KEY `company_name` (`company_name`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `ospos_tax_categories` -- CREATE TABLE `ospos_tax_categories` ( `tax_category_id` int(10) NOT NULL AUTO_INCREMENT, `tax_category` varchar(32) NOT NULL, `tax_group_sequence` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`tax_category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_tax_codes` -- CREATE TABLE `ospos_tax_codes` ( `tax_code_id` int(11) NOT NULL AUTO_INCREMENT, `tax_code` varchar(32) NOT NULL, `tax_code_name` varchar(255) NOT NULL DEFAULT '', `city` varchar(255) NOT NULL DEFAULT '', `state` varchar(255) NOT NULL DEFAULT '', `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`tax_code_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_tax_jurisdictions` -- CREATE TABLE `ospos_tax_jurisdictions` ( `jurisdiction_id` int(11) NOT NULL AUTO_INCREMENT, `jurisdiction_name` varchar(255) DEFAULT NULL, `tax_group` varchar(32) NOT NULL, `tax_type` smallint(2) NOT NULL, `reporting_authority` varchar(255) DEFAULT NULL, `tax_group_sequence` tinyint(1) NOT NULL DEFAULT '0', `cascade_sequence` tinyint(1) NOT NULL DEFAULT '0', `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`jurisdiction_id`), UNIQUE KEY `tax_jurisdictions_uq1` (`tax_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `ospos_tax_rates` -- CREATE TABLE `ospos_tax_rates` ( `tax_rate_id` int(11) NOT NULL AUTO_INCREMENT, `rate_tax_code_id` int(11) NOT NULL, `rate_tax_category_id` int(10) NOT NULL, `rate_jurisdiction_id` int(11) NOT NULL, `tax_rate` decimal(15,4) NOT NULL DEFAULT '0.0000', `tax_rounding_code` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`tax_rate_id`), KEY `rate_tax_category_id` (`rate_tax_category_id`), KEY `rate_tax_code_id` (`rate_tax_code_id`), KEY `rate_jurisdiction_id` (`rate_jurisdiction_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Constraints for dumped tables -- -- -- Constraints for table `ospos_attribute_definitions` -- ALTER TABLE `ospos_attribute_definitions` ADD CONSTRAINT `fk_ospos_attribute_definitions_ibfk_1` FOREIGN KEY (`definition_fk`) REFERENCES `ospos_attribute_definitions` (`definition_id`); -- -- Constraints for table `ospos_attribute_links` -- ALTER TABLE `ospos_attribute_links` ADD CONSTRAINT `ospos_attribute_links_ibfk_1` FOREIGN KEY (`definition_id`) REFERENCES `ospos_attribute_definitions` (`definition_id`) ON DELETE CASCADE, ADD CONSTRAINT `ospos_attribute_links_ibfk_2` FOREIGN KEY (`attribute_id`) REFERENCES `ospos_attribute_values` (`attribute_id`) ON DELETE CASCADE, ADD CONSTRAINT `ospos_attribute_links_ibfk_3` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`), ADD CONSTRAINT `ospos_attribute_links_ibfk_4` FOREIGN KEY (`receiving_id`) REFERENCES `ospos_receivings` (`receiving_id`), ADD CONSTRAINT `ospos_attribute_links_ibfk_5` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`); -- -- Constraints for table `ospos_cash_up` -- ALTER TABLE `ospos_cash_up` ADD CONSTRAINT `ospos_cash_up_ibfk_1` FOREIGN KEY (`open_employee_id`) REFERENCES `ospos_employees` (`person_id`), ADD CONSTRAINT `ospos_cash_up_ibfk_2` FOREIGN KEY (`close_employee_id`) REFERENCES `ospos_employees` (`person_id`); -- -- Constraints for table `ospos_customers` -- ALTER TABLE `ospos_customers` ADD CONSTRAINT `ospos_customers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`), ADD CONSTRAINT `ospos_customers_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `ospos_customers_packages` (`package_id`), ADD CONSTRAINT `ospos_customers_ibfk_3` FOREIGN KEY (`sales_tax_code_id`) REFERENCES `ospos_tax_codes` (`tax_code_id`); -- -- Constraints for table `ospos_customers_points` -- ALTER TABLE `ospos_customers_points` ADD CONSTRAINT `ospos_customers_points_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_customers` (`person_id`), ADD CONSTRAINT `ospos_customers_points_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `ospos_customers_packages` (`package_id`), ADD CONSTRAINT `ospos_customers_points_ibfk_3` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`); -- -- Constraints for table `ospos_employees` -- ALTER TABLE `ospos_employees` ADD CONSTRAINT `ospos_employees_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`); -- -- Constraints for table `ospos_expenses` -- ALTER TABLE `ospos_expenses` ADD CONSTRAINT `ospos_expenses_ibfk_1` FOREIGN KEY (`expense_category_id`) REFERENCES `ospos_expense_categories` (`expense_category_id`), ADD CONSTRAINT `ospos_expenses_ibfk_2` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`), ADD CONSTRAINT `ospos_expenses_ibfk_3` FOREIGN KEY (`supplier_id`) REFERENCES `ospos_suppliers` (`person_id`); -- -- Constraints for table `ospos_giftcards` -- ALTER TABLE `ospos_giftcards` ADD CONSTRAINT `ospos_giftcards_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`); -- -- Constraints for table `ospos_grants` -- ALTER TABLE `ospos_grants` ADD CONSTRAINT `ospos_grants_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `ospos_permissions` (`permission_id`) ON DELETE CASCADE, ADD CONSTRAINT `ospos_grants_ibfk_2` FOREIGN KEY (`person_id`) REFERENCES `ospos_employees` (`person_id`) ON DELETE CASCADE; -- -- Constraints for table `ospos_inventory` -- ALTER TABLE `ospos_inventory` ADD CONSTRAINT `ospos_inventory_ibfk_1` FOREIGN KEY (`trans_items`) REFERENCES `ospos_items` (`item_id`), ADD CONSTRAINT `ospos_inventory_ibfk_2` FOREIGN KEY (`trans_user`) REFERENCES `ospos_employees` (`person_id`), ADD CONSTRAINT `ospos_inventory_ibfk_3` FOREIGN KEY (`trans_location`) REFERENCES `ospos_stock_locations` (`location_id`); -- -- Constraints for table `ospos_items` -- ALTER TABLE `ospos_items` ADD CONSTRAINT `ospos_items_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `ospos_suppliers` (`person_id`); -- -- Constraints for table `ospos_items_taxes` -- ALTER TABLE `ospos_items_taxes` ADD CONSTRAINT `ospos_items_taxes_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`) ON DELETE CASCADE; -- -- Constraints for table `ospos_item_kit_items` -- ALTER TABLE `ospos_item_kit_items` ADD CONSTRAINT `ospos_item_kit_items_ibfk_1` FOREIGN KEY (`item_kit_id`) REFERENCES `ospos_item_kits` (`item_kit_id`) ON DELETE CASCADE, ADD CONSTRAINT `ospos_item_kit_items_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`) ON DELETE CASCADE; -- -- Constraints for table `ospos_item_quantities` -- ALTER TABLE `ospos_item_quantities` ADD CONSTRAINT `ospos_item_quantities_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`), ADD CONSTRAINT `ospos_item_quantities_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `ospos_stock_locations` (`location_id`); -- -- Constraints for table `ospos_permissions` -- ALTER TABLE `ospos_permissions` ADD CONSTRAINT `ospos_permissions_ibfk_1` FOREIGN KEY (`module_id`) REFERENCES `ospos_modules` (`module_id`) ON DELETE CASCADE, ADD CONSTRAINT `ospos_permissions_ibfk_2` FOREIGN KEY (`location_id`) REFERENCES `ospos_stock_locations` (`location_id`) ON DELETE CASCADE; -- -- Constraints for table `ospos_receivings` -- ALTER TABLE `ospos_receivings` ADD CONSTRAINT `ospos_receivings_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`), ADD CONSTRAINT `ospos_receivings_ibfk_2` FOREIGN KEY (`supplier_id`) REFERENCES `ospos_suppliers` (`person_id`); -- -- Constraints for table `ospos_receivings_items` -- ALTER TABLE `ospos_receivings_items` ADD CONSTRAINT `ospos_receivings_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`), ADD CONSTRAINT `ospos_receivings_items_ibfk_2` FOREIGN KEY (`receiving_id`) REFERENCES `ospos_receivings` (`receiving_id`); -- -- Constraints for table `ospos_sales` -- ALTER TABLE `ospos_sales` ADD CONSTRAINT `ospos_sales_ibfk_1` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`), ADD CONSTRAINT `ospos_sales_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `ospos_customers` (`person_id`), ADD CONSTRAINT `ospos_sales_ibfk_3` FOREIGN KEY (`dinner_table_id`) REFERENCES `ospos_dinner_tables` (`dinner_table_id`); -- -- Constraints for table `ospos_sales_items` -- ALTER TABLE `ospos_sales_items` ADD CONSTRAINT `ospos_sales_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`), ADD CONSTRAINT `ospos_sales_items_ibfk_2` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`), ADD CONSTRAINT `ospos_sales_items_ibfk_3` FOREIGN KEY (`item_location`) REFERENCES `ospos_stock_locations` (`location_id`); -- -- Constraints for table `ospos_sales_items_taxes` -- ALTER TABLE `ospos_sales_items_taxes` ADD CONSTRAINT `ospos_sales_items_taxes_ibfk_1` FOREIGN KEY (`sale_id`, `item_id`, `line`) REFERENCES `ospos_sales_items` (`sale_id`, `item_id`, `line`), ADD CONSTRAINT `ospos_sales_items_taxes_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `ospos_items` (`item_id`); -- -- Constraints for table `ospos_sales_payments` -- ALTER TABLE `ospos_sales_payments` ADD CONSTRAINT `ospos_sales_payments_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`), ADD CONSTRAINT `ospos_sales_payments_ibfk_2` FOREIGN KEY (`employee_id`) REFERENCES `ospos_employees` (`person_id`); -- -- Constraints for table `ospos_sales_reward_points` -- ALTER TABLE `ospos_sales_reward_points` ADD CONSTRAINT `ospos_sales_reward_points_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `ospos_sales` (`sale_id`); -- -- Constraints for table `ospos_suppliers` -- ALTER TABLE `ospos_suppliers` ADD CONSTRAINT `ospos_suppliers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `ospos_people` (`person_id`); -- -- Constraints for table `ospos_tax_rates` -- ALTER TABLE `ospos_tax_rates` ADD CONSTRAINT `ospos_tax_rates_ibfk_1` FOREIGN KEY (`rate_tax_category_id`) REFERENCES `ospos_tax_categories` (`tax_category_id`), ADD CONSTRAINT `ospos_tax_rates_ibfk_2` FOREIGN KEY (`rate_tax_code_id`) REFERENCES `ospos_tax_codes` (`tax_code_id`), ADD CONSTRAINT `ospos_tax_rates_ibfk_3` FOREIGN KEY (`rate_jurisdiction_id`) REFERENCES `ospos_tax_jurisdictions` (`jurisdiction_id`); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Back