wwwdb.dump

使用perl和C写的基于Web的管理数据库表的程序

\connect - wwwrun
CREATE SEQUENCE seq start 1000 increment 1 maxvalue 1000000 minvalue 1000  cache 1 ;
CREATE TABLE contacts (
	title character varying(50),
	sex character varying(1),
	first_name character varying(100),
	last_name character varying(100),
	company character varying(200),
	conttyp1 character varying(10),
	contadr1 character varying(100),
	conttyp2 character varying(10),
	contadr2 character varying(100),
	conttyp3 character varying(10),
	contadr3 character varying(100),
	conttyp4 character varying(10),
	contadr4 character varying(100),
	conttyp5 character varying(10),
	contadr5 character varying(100),
	comments character varying(256),
	state character varying(10),
	last_change datetime);
REVOKE ALL on contacts from PUBLIC;
GRANT ALL on contacts to PUBLIC;
CREATE TABLE wwwdb_test (
	x_int2 int2 NOT NULL,
	x_int4 int4,
	x_char_10 character(10),
	x_varchar_10 character varying(10),
	x_text text,
	x_float4 float4,
	x_float8 float8,
	x_abstime abstime,
	x_date date,
	x_datetime datetime,
	x_interval timespan,
	x_reltime reltime,
	x_time time);
CREATE TABLE wwwdb_state (
	session_id character varying(20) NOT NULL,
	key character varying(128) NOT NULL,
	key_value character varying(512),
	last_change datetime);
CREATE TABLE wwwdb_lookup (
	key character varying(50),
	sort_nr int2,
	label character varying(50),
	key_value character varying(100),
	last_change datetime);
REVOKE ALL on wwwdb_lookup from PUBLIC;
GRANT ALL on wwwdb_lookup to PUBLIC;
CREATE TABLE wwwdb_sword (
	id_sword int4 NOT NULL,
	sword character varying(64),
	last_change datetime);
CREATE TABLE wwwdb_object (
	id_object int4 NOT NULL,
	link character varying(64),
	descript character varying(256),
	sort_nr int4,
	attribs character varying(256),
	last_change datetime);
CREATE TABLE wwwdb_category (
	id_category int4 NOT NULL,
	description character varying(128),
	id_cat_of_cat int4,
	name character varying(64),
	id_chain character varying(2048),
	name_chain character varying(2048),
	nr_of_subcats int4,
	nr_of_objs int4,
	sort_nr int4,
	attribs character varying(256),
	last_change datetime);
CREATE TABLE wwwdb_obj_swd (
	id_sword int4 NOT NULL,
	id_object int4 NOT NULL,
	last_change datetime);
CREATE TABLE wwwdb_obj_obj (
	id_obj_of_obj int4 NOT NULL,
	id_object int4 NOT NULL,
	last_change datetime);
CREATE TABLE wwwdb_obj_cat (
	id_category int4 NOT NULL,
	id_object int4 NOT NULL,
	access_chain character varying(256),
	last_change datetime);
CREATE TABLE wwwdb_swd_swd (
	id_swd_of_swd int4 NOT NULL,
	id_sword int4 NOT NULL,
	last_change datetime);
CREATE TABLE wwwdb_cat_cat (
	id_cat_of_cat int4 NOT NULL,
	id_category int4 NOT NULL,
	last_change datetime);
CREATE TABLE wwwdb_get_swd_of_obj (
	id_object int4,
	id_sword int4,
	sword character varying(64));
CREATE TABLE wwwdb_get_obj_parent (
	id_obj_child int4,
	id_obj_parent int4);
CREATE TABLE wwwdb_get_obj_child (
	id_obj_parent int4,
	id_obj_child int4);
CREATE TABLE wwwdb_get_swd_of_swd (
	sword character varying(64),
	id_swd_of_swd int4,
	id_sword int4,
	sword_alias character varying(64));
CREATE TABLE wwwdb_get_obj_of_swd (
	id_sword int4,
	sword character varying(64),
	id_object int4,
	link character varying(64),
	descript character varying(256));
CREATE TABLE wwwdb_get_cat_of_swd (
	id_category int4,
	name character varying(64),
	description character varying(128),
	descript character varying(256),
	link character varying(64),
	sword character varying(64));
CREATE TABLE wwwdb_get_cat_of_obj (
	id_category int4,
	id_object int4,
	description character varying(128),
	id_chain character varying(2048),
	name_chain character varying(2048),
	nr_of_subcats int4,
	nr_of_objs int4,
	link character varying(64),
	descript character varying(256));
CREATE TABLE wwwdb_nav_in_cat (
	id_category int4,
	name character varying(64),
	description character varying(128),
	id_cat_of_cat int4,
	nr_of_subcats int4,
	nr_of_objs int4,
	sort_nr int4,
	attribs character varying(256));
CREATE TABLE wwwdb_get_cat_of_cat (
	id_cat_of_cat int4,
	id_category int4,
	name character varying(64),
	description character varying(128),
	nr_of_subcats int4,
	nr_of_objs int4,
	sort_nr int4,
	attribs character varying(256));
CREATE TABLE wwwdb_get_obj_of_cat (
	id_category int4,
	id_object int4,
	description character varying(128),
	name character varying(64),
	id_chain character varying(2048),
	name_chain character varying(2048),
	nr_of_subcats int4,
	nr_of_objs int4,
	link character varying(64),
	descript character varying(256),
	sort_nr int4,
	attribs character varying(256));
CREATE TABLE wwwdb_doc (
	id_doc int4 NOT NULL,
	category character varying(64),
	sub_category character varying(64),
	description character varying(128),
	text text,
	sort_nr int4,
	last_change datetime);
CREATE FUNCTION one ( ) RETURNS int4 AS 'select 1::int4; ' LANGUAGE 'SQL';
INSERT INTO contacts (title,sex,first_name,last_name,company,conttyp1,contadr1,conttyp2,contadr2,conttyp3,contadr3,conttyp4,contadr4,conttyp5,contadr5,comments,state,last_change) values ('Herr','m','Klaus','Reger','TWC','eml','[e-mail]','','','','','','','','','','','Tue Nov 02 12:05:33 1999 MET');
INSERT INTO wwwdb_test (x_int2,x_int4,x_char_10,x_varchar_10,x_text,x_float4,x_float8,x_abstime,x_date,x_datetime,x_interval,x_reltime,x_time) values (1,2,'abcde     ','abcde','abcde',1.2,1111.222,'epoch','12-24-1999','Thu Oct 21 14:17:38 1999 MEST','@ 1 year 2 mons','@ 0','12:00:00');
INSERT INTO wwwdb_test (x_int2,x_int4,x_char_10,x_varchar_10,x_text,x_float4,x_float8,x_abstime,x_date,x_datetime,x_interval,x_reltime,x_time) values (3,2,'abcde     ','abcde','abcde',1.2,1111.222,'epoch','01-01-1999','Thu Oct 21 14:17:38 1999 MEST','@ 1 year 2 mons','@ 0','12:00:00');
INSERT INTO wwwdb_test (x_int2,x_int4,x_char_10,x_varchar_10,x_text,x_float4,x_float8,x_abstime,x_date,x_datetime,x_interval,x_reltime,x_time) values (1111,22222222,'char10    ','varchar10','text',1.2,34.56,'Thu Jan 01 01:00:02 1970 MET','07-06-1989','Tue Aug 07 23:45:01 1990 MEST','@ 1 day','@ 1 sec','01:02:03');
INSERT INTO wwwdb_test (x_int2,x_int4,x_char_10,x_varchar_10,x_text,x_float4,x_float8,x_abstime,x_date,x_datetime,x_interval,x_reltime,x_time) values (1111,22222222,'char10    ','varchar10','text',1234.57,12345678.1234568,'Mon Nov 22 11:22:33 1999 MET','07-06-1989','Tue Aug 07 23:45:01 1990 MEST','@ 1 day','@ 12 mons','01:02:03');
INSERT INTO wwwdb_test (x_int2,x_int4,x_char_10,x_varchar_10,x_text,x_float4,x_float8,x_abstime,x_date,x_datetime,x_interval,x_reltime,x_time) values (1,2,'abcde     ','abcde','abcde',1.2,1111.222,'Sun Mar 21 00:00:00 1999 MET','02-03-1999','Thu Oct 21 14:17:38 1999 MEST','@ 2 secs','@ 2 mons 9 days 10 hours 40 mins','12:00:00');
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','CreateAppRc_1,DbDriver','PG1.rc',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','Last_Ins','Mon Nov 22 09:46:14 1999',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[Debug] Level','',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[GUI] BgColor','',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[GUI] BgImage','/WWWdb/lib/Images/WWWdb_bg_blue.png',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[GUI] DontConfirmAfterDelete','1',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[GUI] DontConfirmAfterInsert','1',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[GUI] DontConfirmAfterUpdate','1',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[Layout Table] BgColor','',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[Layout Table] BgColor1stCol','',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[Layout Table] Border','0',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[Layout Table] LinkWidth','150',NULL);
INSERT INTO wwwdb_state (session_id,key,key_value,last_change) values ('0000000000000000','[Layout Table] Width','100%',NULL);