/home/lnzliplg/www/2018122300.sql.tar
home/lnzliplg/public_html/roundcube/SQL/sqlite/2018122300.sql000064400000001476151727577470017400 0ustar00CREATE 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;

home/lnzliplg/public_html/roundcube/SQL/mssql/2018122300.sql000064400000000443151727602340017210 0ustar00ALTER TABLE [dbo].[filestore] ADD [context] varchar(32) COLLATE Latin1_General_CI_AI NOT NULL
GO

UPDATE [dbo].[filestore] SET [context] = 'enigma'
GO

CREATE UNIQUE INDEX [IX_filestore_user_id_context_filename] ON [dbo].[filestore]([user_id],[context],[filename]) ON [PRIMARY]
GO
Path: home/lnzliplg/www