Files
opensourcepos/app/Database/Migrations/sqlscripts/pre-3.0.2/2.3.4_to_2.4.sql
2024-06-15 17:19:15 +02:00

10 lines
311 B
SQL

-- alter sessions table
DROP TABLE `ospos_sessions`;
CREATE TABLE `ospos_sessions` (
`id` varchar(40) NOT NULL DEFAULT '0',
`ip_address` varchar(45) NOT NULL DEFAULT '0',
`data` blob NOT NULL,
`timestamp` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;