\connect - postgres
CREATE TABLE "dhcp_host" (
	"host_name" text,
	"host_ipaddress" text,
	"host_filename" text,
	"host_group" text,
	"host_option1" text,
	"host_option2" text,
	"host_option3" text,
	"host_option4" text,
	"host_macaddress" text,
	"host_fixedaddress" text);
CREATE TABLE "dhcp_global" (
	"option_name" text,
	"option_value" text);
CREATE TABLE "dhcp_groups" (
	"group_name" text,
	"group_option" text,
	"group_optionval" text);
CREATE TABLE "pga_queries" (
	"queryname" character varying(64),
	"querytype" character,
	"querycommand" text,
	"querytables" text,
	"querylinks" text,
	"queryresults" text,
	"querycomments" text);
REVOKE ALL on "pga_queries" from PUBLIC;
GRANT ALL on "pga_queries" to PUBLIC;
CREATE TABLE "pga_forms" (
	"formname" character varying(64),
	"formsource" text);
REVOKE ALL on "pga_forms" from PUBLIC;
GRANT ALL on "pga_forms" to PUBLIC;
CREATE TABLE "pga_scripts" (
	"scriptname" character varying(64),
	"scriptsource" text);
REVOKE ALL on "pga_scripts" from PUBLIC;
GRANT ALL on "pga_scripts" to PUBLIC;
CREATE TABLE "pga_reports" (
	"reportname" character varying(64),
	"reportsource" text,
	"reportbody" text,
	"reportprocs" text,
	"reportoptions" text);
REVOKE ALL on "pga_reports" from PUBLIC;
GRANT ALL on "pga_reports" to PUBLIC;
CREATE TABLE "pga_schema" (
	"schemaname" character varying(64),
	"schematables" text,
	"schemalinks" text);
REVOKE ALL on "pga_schema" from PUBLIC;
GRANT ALL on "pga_schema" to PUBLIC;
CREATE TABLE "pga_layout" (
	"tablename" character varying(64),
	"nrcols" int2,
	"colnames" text,
	"colwidth" text);
REVOKE ALL on "pga_layout" from PUBLIC;
GRANT ALL on "pga_layout" to PUBLIC;
CREATE TABLE "dhcp_subnet" (
	"subnet" text,
	"netmask" text,
	"rangestart" text,
	"rangeend" text,
	"option1" text,
	"option2" text,
	"option3" text,
	"option4" text);
COPY "dhcp_host" FROM stdin;
z	z	z	z	z	z	z	z	z	z
NEW1	100.200.3.00.400	NewImage	Office User		none known	zippo	nada	aa:ff:A:ok	
Counter	12.22.33.45	retailsales	checkout	opt1	opt2	opt3	opt4	00:af:42:33:bc:ff	
EatME		NO THANKS						NON AT ALL	
No KERNEL	1.1.1.1		Good Guys					aa:ff:4f:3a:b2	
Group Def	0.0.0.0		Single Group					a:d:f:b:c	
GroupDefs B	tcp/ip		Second TRY					11111	
Group Format Test	ip address		Group Name					mac address	
Good Format	IP		Propper Format					ether MAC	
Best Format	IP Adress		Group Format					Ether Address	
Formated group	0.0.0.0	KERNL TO BOOT	GROUPABC 123					MAC @@@@@	FIXED ADDRESS
Top-Sales_person	1.2.3.4	TOP-DOG	Floor Sales					0:22:af:bc:46	
New Sales person	2.2.2.2		Floor Sales					1:2:3:4:bb	
Jounior Sales	12.12.123.123	Limited Kernel	Floor Sales					23:aa:bb:cc:fa	
Checker AAA	123.123.12.123	retail-kernel	checkout					00:00:ad:af:4f	
City Desk A	123.123.12.11	City-Desk	Contractors Desk					22:33:ab:cd:ef	
City Desk Manager	123.123.123.100	Full-Kernel	Contractors Desk					aa:bb:cc:dd:ee	City Desk Top Dog
Management 1	123.123.45.12	full-kernel	Management					00:11:4b:54:f4	
DB-ONLY	2.3.4.5		Management					aa:bb:cc:d:ef	
dog dodo									
\.
COPY "dhcp_global" FROM stdin;
Global Parameter	Global VALUE
option lpr-servers	150.150.1.1
default-lease-time	86400
max-lease-time	86400
\.
COPY "dhcp_groups" FROM stdin;
Floor Sales	option lpr-servers 	12.24.25.39
checkout	rude dude	no service
Management	use-host-decl-names	true
Contractors Desk	option Eat Crap	Less Filling
\.
COPY "pga_queries" FROM stdin;
\.
COPY "pga_forms" FROM stdin;
\.
COPY "pga_scripts" FROM stdin;
\.
COPY "pga_reports" FROM stdin;
\.
COPY "pga_schema" FROM stdin;
\.
COPY "pga_layout" FROM stdin;
dhcp_global	2	option_name option_value	150 150
dhcp_host	10	host_name host_ipaddress host_filename host_group host_option1 host_option2 host_option3 host_option4 host_macaddress host_fixedaddress	150 150 150 150 150 150 150 150 150 150
dhcp_groups	3	group_name group_option group_optionval	150 150 150
dhcp_subnet	8	subnet netmask rangestart rangeend option1 option2 option3 option4	150 150 150 150 150 150 150 150
\.
COPY "dhcp_subnet" FROM stdin;
150.150.1.1	255.255.255.0	150.150.1.5	150.150.1.20	\N	\N	\N	\N
1.1.2.0	255.255.255.0	1.1.2.25	1.1.2.250	\N	\N	\N	\N
3.3.3.0	255.255.255.0	3.3.3.20	3.3.3.200	\N	\N	\N	\N
\.
CREATE UNIQUE INDEX "dhcp_host_host_name" on "dhcp_host" using btree ( "host_name" "text_ops" );
CREATE UNIQUE INDEX "dhcp_global_option_name" on "dhcp_global" using btree ( "option_name" "text_ops" );
CREATE UNIQUE INDEX "dhcp_subnet_subnet" on "dhcp_subnet" using btree ( "subnet" "text_ops" );
CREATE UNIQUE INDEX "dhcp_groups_group_name" on "dhcp_groups" using btree ( "group_name" "text_ops" );