-
Notifications
You must be signed in to change notification settings - Fork 0
/
test_audits.sql
24 lines (23 loc) · 1.41 KB
/
test_audits.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
-- Please do not run this script on files with data. This will probably delete the data.
PRAGMA foreign_keys=ON;
BEGIN TRANSACTION;
INSERT INTO metadata VALUES(6,0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,16384,16832,1,0,0,0,0);
INSERT INTO metadata VALUES(5,0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,16384,16832,1,0,0,0,0);
INSERT INTO metadata VALUES(2,0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,16384,16832,1,0,0,0,0);
INSERT INTO metadata VALUES(60,0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,16384,16832,1,0,0,0,0);
INSERT INTO metadata VALUES(61,0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,'1970-01-01 00:00:00',0,16384,16832,1,0,0,0,0);
UPDATE metadata SET id=62 WHERE id=63;
UPDATE metadata SET id=63 WHERE id=62;
INSERT INTO dentry VALUES(2,1,16384,'heyyou');
INSERT INTO dentry VALUES(2,1,16384,'heyyou2');
INSERT INTO dentry VALUES(2,1,16384,'heyyou3');
INSERT INTO dentry VALUES(2,1,16384,'heyyou4');
UPDATE dentry SET NAME='heyyou5' WHERE name='heyyou';
UPDATE dentry SET name='heyyou77' where name='heyyou2';
INSERT INTO xattr VALUES(2,1,16384);
UPDATE xattr SET name='heyyou77' where file_id=1;
DELETE FROM dentry;
DELETE FROM xattr;
DELETE FROM metadata;
DELETE FROM data;
COMMIT;