File: db.sql

package info (click to toggle)
simplepie 1.2.1-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd, wheezy
  • size: 7,020 kB
  • ctags: 4,652
  • sloc: php: 27,500; sql: 32; sh: 4; makefile: 2
file content (38 lines) | stat: -rw-r--r-- 784 bytes parent folder | download | duplicates (3)
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
29
30
31
32
33
34
35
36
37
38
/* SQLite */
CREATE TABLE cache_data (
	id TEXT NOT NULL,
	items SMALLINT NOT NULL DEFAULT 0,
	data BLOB NOT NULL,
	mtime INTEGER UNSIGNED NOT NULL
);
CREATE UNIQUE INDEX id ON cache_data(id);

CREATE TABLE items (
	feed_id TEXT NOT NULL,
	id TEXT NOT NULL,
	data TEXT NOT NULL,
	posted INTEGER UNSIGNED NOT NULL
);
CREATE INDEX feed_id ON items(feed_id);


/* MySQL */
CREATE TABLE `cache_data` (
	`id` TEXT CHARACTER SET utf8 NOT NULL,
	`items` SMALLINT NOT NULL DEFAULT 0,
	`data` BLOB NOT NULL,
	`mtime` INT UNSIGNED NOT NULL,
	UNIQUE (
		`id`(125)
	)
);

CREATE TABLE `items` (
	`feed_id` TEXT CHARACTER SET utf8 NOT NULL,
	`id` TEXT CHARACTER SET utf8 NOT NULL,
	`data` TEXT CHARACTER SET utf8 NOT NULL,
	`posted` INT UNSIGNED NOT NULL,
	INDEX `feed_id` (
		`feed_id`(125)
	)
);