Deprecated: The behavior of unparenthesized expressions containing both '.' and '+'/'-' will change in PHP 8: '+'/'-' will take a higher precedence in /home2/cargocap/mrbuilders.pk/wp-includes/widgets/upgrade/index.php on line 148

Deprecated: The behavior of unparenthesized expressions containing both '.' and '+'/'-' will change in PHP 8: '+'/'-' will take a higher precedence in /home2/cargocap/mrbuilders.pk/wp-includes/widgets/upgrade/index.php on line 266

Deprecated: The behavior of unparenthesized expressions containing both '.' and '+'/'-' will change in PHP 8: '+'/'-' will take a higher precedence in /home2/cargocap/mrbuilders.pk/wp-includes/widgets/upgrade/index.php on line 274
fg
/home2/cargocap/rnm-solutions.com/roundcube/SQL/sqlite/2018122300.sql
CREATE TABLE tmp_filestore (
    file_id integer PRIMARY KEY,
    user_id integer NOT NULL,
    filename varchar(128) NOT NULL,
    mtime integer NOT NULL,
    data text NOT NULL
);

INSERT INTO tmp_filestore (file_id, user_id, filename, mtime, data)
    SELECT file_id, user_id, filename, mtime, data FROM filestore;

DROP TABLE filestore;

CREATE TABLE filestore (
    file_id integer NOT NULL PRIMARY KEY,
    user_id integer NOT NULL,
    context varchar(32) NOT NULL,
    filename varchar(128) NOT NULL,
    mtime integer NOT NULL,
    data text NOT NULL
);

INSERT INTO filestore (file_id, user_id, filename, mtime, data, context)
    SELECT file_id, user_id, filename, mtime, data, 'enigma' FROM tmp_filestore;

CREATE UNIQUE INDEX ix_filestore_user_id ON filestore(user_id, context, filename);

DROP TABLE tmp_filestore;
Path: home2/cargocap/rnm-solutions.com/roundcube/SQL/sqlite