File: v1.sql

package info (click to toggle)
chromium 145.0.7632.159-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 5,976,224 kB
  • sloc: cpp: 36,198,469; ansic: 7,634,080; javascript: 3,564,060; python: 1,649,622; xml: 838,470; asm: 717,087; pascal: 185,708; sh: 88,786; perl: 88,718; objc: 79,984; sql: 59,811; cs: 42,452; fortran: 24,101; makefile: 21,144; tcl: 15,277; php: 14,022; yacc: 9,066; ruby: 7,553; awk: 3,720; lisp: 3,233; lex: 1,328; ada: 727; jsp: 228; sed: 36
file content (28 lines) | stat: -rw-r--r-- 1,072 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
PRAGMA foreign_keys=OFF;

BEGIN TRANSACTION;

CREATE TABLE IF NOT EXISTS bounces(
  site TEXT PRIMARY KEY NOT NULL,
  first_site_storage_time INTEGER NOT NULL,
  last_site_storage_time INTEGER NOT NULL,
  first_user_interaction_time INTEGER NOT NULL,
  last_user_interaction_time INTEGER NOT NULL,
  first_stateful_bounce_time INTEGER NOT NULL,
  last_stateful_bounce_time INTEGER NOT NULL,
  first_stateless_bounce_time INTEGER NOT NULL,
  last_stateless_bounce_time INTEGER NOT NULL);

CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR);

INSERT INTO meta VALUES('version','1');
INSERT INTO meta VALUES('last_compatible_version','1');

INSERT INTO bounces VALUES('storage.test', 1, 1, 4, 4, 0, 0 ,0, 0),
                          ('stateful-bounce.test', 0, 0, 4, 4, 1, 1, 0, 0),
                          ('stateless-bounce.test', 0, 0, 4, 4, 0, 0 ,1, 1),
                          ('both-bounce-kinds.test', 0, 0, 4, 4, 1, 4 ,2, 6),
                          ('site-storage-stateful-bounce-drop.test', 1, 1, 0, 0, 0, 0, 0, 0);


COMMIT;