File: pgsql.start.dump

package info (click to toggle)
libphp-phplayersmenu 3.2.0rc-2
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 1,236 kB
  • ctags: 695
  • sloc: php: 2,676; makefile: 68; sh: 20
file content (30 lines) | stat: -rw-r--r-- 636 bytes parent folder | download | duplicates (7) 
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
 
--
-- Do not use this beginning line...
--
\connect - postgres
--
-- ... if you are importing the dump through phpPgAdmin :^)
--

CREATE SEQUENCE phplayersmenu_id_seq start 100 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE phplayersmenu (
	id int2 DEFAULT nextval('phplayersmenu_id_seq') NOT NULL,
	parent_id int2 DEFAULT 1 NOT NULL,
	text text,
	href text,
	title text,
	icon text,
	target text,
	orderfield int2 DEFAULT 0,
	expanded int2 DEFAULT 0,
	PRIMARY KEY (id)
);

CREATE TABLE phplayersmenu_i18n (
	language varchar(15) NOT NULL,
	id int2 NOT NULL,
	text text,
	title text,
	PRIMARY KEY (language, id)
);