File: v1.init_too_new.sql

package info (click to toggle)
chromium 139.0.7258.127-1
  • links: PTS, VCS
  • area: main
  • in suites:
  • size: 6,122,068 kB
  • sloc: cpp: 35,100,771; ansic: 7,163,530; javascript: 4,103,002; python: 1,436,920; asm: 946,517; xml: 746,709; pascal: 187,653; perl: 88,691; sh: 88,436; objc: 79,953; sql: 51,488; cs: 44,583; fortran: 24,137; makefile: 22,147; tcl: 15,277; php: 13,980; yacc: 8,984; ruby: 7,485; awk: 3,720; lisp: 3,096; lex: 1,327; ada: 727; jsp: 228; sed: 36
file content (27 lines) | stat: -rw-r--r-- 855 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
PRAGMA foreign_keys=OFF;

BEGIN TRANSACTION;

CREATE TABLE browsing_topics_api_usages (
hashed_context_domain INTEGER NOT NULL,
hashed_main_frame_host INTEGER NOT NULL,
last_usage_time INTEGER NOT NULL,
PRIMARY KEY (hashed_context_domain, hashed_main_frame_host));

CREATE INDEX last_usage_time_idx ON browsing_topics_api_usages(last_usage_time);

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

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

INSERT INTO browsing_topics_api_usages VALUES (111, 222, 333);

CREATE TABLE  browsing_topics_api_hashed_to_unhashed_domain(
hashed_context_domain INTEGER NOT NULL,
context_domain TEXT NOT NULL,
PRIMARY KEY (hashed_context_domain));

INSERT INTO browsing_topics_api_hashed_to_unhashed_domain VALUES (111, '111.com');

COMMIT;