Watermellon Picnic -- Red, Apple Green, White, Pink, Black, White, Pink Mermaid Magic -- White, Maize, Blue, Mint, Capri Blue Flag Girl -- Red, White, Dark Navy Jungle Gem -- Brown, Aquamarine, Lemonade, Creamsicle, Festive Fuschia, Lemongrass Spring Sparkle -- Turquoise, aquamarine, azalea, orange, shocking pink, pink passion Pretty Lady -- Shocking Pink, Pink, Yellow, Lemongrass, White Flower Garden -- Turquoise, Apple Green, Pistachio, Wild Orchid, Pink, Hot Pink, White Social Butterfly -- White, Yellow, Creamsicle, Lemongrass, Pink Passion, Tomato Happy Rainbow -- Yellow, Turquoise, White, Watermellon, Light Pink, Pink, Apple Green Fashion Flower -- White, Aquamarine, Lime, Light Navy, Dark Royal, Apple Green Daisy Days -- Yellow, White, Dark Navy, Emerald, Creamsicle, Neon Orange Full Of Heart -- White, Red, Hot Pink, Shocking Pink Wild One -- Black, Light Ivory, Shocking Pink, Zebra Print Candy Shoppe -- Dark Navy, Light Ivory, Pansy, Orange, Shocking Pink, Pistachio>BR> Dots of Fun -- Brown, light Ivory, Pistachio, Wild Orchid, Festive Fuchsia Winter Snowflake -- Light Ivory, Pink, Light Blue, Cranberry, Brown Sweeter Than Chocolate -- Baby Pink, Hot Pink, Shocking Pink, Brown, Light Ivory Central Park Skater -- Millennium Silver, Light Blue, Blue, White Holiday Friend -- Millennium Silver, Grey, Black, Light Ivory, Cranberry Holiday Pictures -- Cranberry, Black, Light Ivory City Sparkle -- Gold Metallic, Brown, Light Ivory Fall Forest - Light Ivory, Baby Pink, Shocking Pink, Creamsicle, Rust, Lemongrass, Moss, Dark Navy Rising Star - Rose Pink, Old Rose, Silver Metallic, Deep Purple Lots of Dots - Brown, Light Blue, Blueberry, Pink, Shocking Pink, Lemonade, Light Ivory, Apple Green Classroom Kitty -- Millennium Silver, Grey, Flannel Grey, Shocking Pink, Baby Pink, Celadon, Light Ivory Prep School -- Baby Pink, Dark Navy, Red, Emerald, Light Ivory Petite Mademoiselle -- Dark Navy, Lavender, Celadon, Millennium Blue Uniform Shop -- Khaki, Dark Navy, White Beach Shack -- Pistachio, Dusty Rose, Creamsicle, Light Navy, Moss, Light Ivory, Light Pink Palm Springs -- Lemongrass, Shocking Pink, Wild Orchid, Turquoise, Light Blue, White, Celadon Red, White & Blue -- Cranberry, Dark Navy, White Lady Daisy -- Yellow, White, Black, Neon Green Cherry Baby -- Red, Hot Pink, Yellow, White, Apple Green Tropical Garden -- Aquamarine, White, Apricot, Old Rose, Light Pink, Creamsicle, Neon Green, Coral, Moss Tennis Match -- White, Shocking Pink, Hot Pink, Misty Turquoise, Blue, Apple Green, Neon Green Ice Cream Social -- White, Brown, Rose Pink, Blue, Oatmeal Spring Rainbow -- Banana, Turquoise, White, Light Blue -- Red, White Tomato, Red, Lime, Capri Blue, Light Ivory, Dark Navy Tres Chic -- Rose Pink, Black, White, Hot Pink, Shocking Pink Cupcake Cutie -- Apple Green, Robins Egg Blue, Rose Pink, Orange, Red, White, Shocking Pink, Brown, Sapphire The Ballet -- Light Ivory, Rose Pink, Grey Snow Princess -- Rose Pink, Pink, Blue, Blueberry, Light Ivory, Celadon, Emerald Winter Glam -- Brown, Light Ivory, Rose Pink, Light Pink Mountain Cabin -- Cranberry, Millennium Blue, Lemonade, Tomato, Evergreen, Olive Glamour Kitty -- Black, Taupe, Oatmeal, Cranberry (the best match) Holiday Classics -- Black, Light Ivory, Cranberry, Dark Navy, Evergreen Beautiful Luxe -- Light Ivory, Gold Metallic Girl Detective -- Mauve, Rose Pink, Light Ivory, Celadon, Brown, Taupe City Girl -- Light Ivory, Dark Navy Harvest Leaves -- Cranberry, Maroon, Orange, Light Ivory, Light Pink, Celadon, Olive, Gold Equestrian Club -- Lemonade, Brown, Light Blue, Olive, Evergreen, Pecan Schoolgirls Rock -- Cranberry, Light Pink, Dark Navy, White, Millennium Silver Royal Gardens -- Olive, Festive Fuchsia, Light Ivory, Rose Pink, Gold Metallic Bon Voyage -- Dark Navy, Red, Light Ivory, Grey, Millennium Silver Savanna Sunset -- Rust, Orange, Brown, Turftan, Taupe, Olive, Celadon, Festive Fuchsia, Light Ivory Strawberry Farm -- Red, Millennium Blue, Blue, Banana, White, Rose Pink Coral Reef -- Mauve, Coral
|
permanent link |
writeback |
edit
CREATE TABLE domains (
id serial NOT NULL,
name character varying(255) NOT NULL,
master character varying(20),
last_check integer,
"type" character varying(6) NOT NULL,
notified_serial integer,
account character varying(40)
);
CREATE TABLE records (
id serial NOT NULL,
domain_id integer,
name character varying(255),
"type" character varying(6),
content character varying(255),
ttl integer,
prio integer,
change_date integer
);
CREATE TABLE supermasters (
ip character varying(25) NOT NULL,
nameserver character varying(255) NOT NULL,
account character varying(40)
);
COPY domains (id, name, master, last_check, "type", notified_serial, account) FROM stdin;
1 kuszelas.eu \N \N NATIVE \N \N
\.
--
-- Data for TOC entry 22 (OID 17153)
-- Name: records; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY records (id, domain_id, name, "type", content, ttl, prio, change_date) FROM stdin;
2 1 localhost.kuszelas.eu A 127.0.0.1 120 \N \N
20 1 kuszelas.eu MX mail2.kuszelas.eu 300 10 \N
21 1 mail2.kuszelas.eu A 212.182.115.24 120 \N \N
1 1 kuszelas.eu SOA localhost user.kuszelas.eu 1 86400 \N \N
17 1 kuszelas.eu NS ns.kuszelas.eu 300 \N \N
18 1 kuszelas.eu MX mail.kuszelas.eu 300 5 \N
12 1 _jabber._tcp.jabber.kuszelas.eu SRV 0 5269 kuszelas.eu 300 10 \N
13 1 _xmpp-server._tcp.jabber.kuszelas.eu SRV 0 5269 kuszelas.eu 300 10 \N
14 1 _xmpp-client._tcp.jabber.kuszelas.eu SRV 0 5222 kuszelas.eu 300 10 \N
16 1 kuszelas.eu TXT Serwer 300 \N \N
3 1 www.kuszelas.eu A 195.242.124.71 120 \N \N
5 1 dns.kuszelas.eu A 195.242.124.71 120 \N \N
6 1 ftp.kuszelas.eu A 195.242.124.71 120 \N \N
7 1 poczta.kuszelas.eu A 195.242.124.71 120 \N \N
8 1 pop3.kuszelas.eu A 195.242.124.71 120 \N \N
9 1 smtp.kuszelas.eu A 195.242.124.71 120 \N \N
10 1 ssh.kuszelas.eu A 195.242.124.71 120 \N \N
11 1 jabber.kuszelas.eu A 195.242.124.71 120 \N \N
4 1 mail.kuszelas.eu A 195.242.124.71 120 \N \N
\.
Audit trail:
CREATE TABLE audit_domains (
operation char(1) NOT NULL,
stamp timestamp NOT NULL,
userid text NOT NULL,
id serial NOT NULL,
name character varying(255) NOT NULL,
master character varying(20),
last_check integer,
"type" character varying(6) NOT NULL,
notified_serial integer,
account character varying(40)
);
CREATE TABLE audit_records (
operation char(1) NOT NULL,
stamp timestamp NOT NULL,
userid text NOT NULL,
id serial NOT NULL,
domain_id integer,
name character varying(255),
"type" character varying(6),
content character varying(255),
ttl integer,
prio integer,
change_date integer
);
CREATE OR REPLACE FUNCTION process_audit_domains() RETURNS TRIGGER AS $audit_domains$
BEGIN
--
-- Create a row in audit_domains to reflect the operation performed on domains,
-- make use of the special variable TG_OP to work out the operation.
--
IF (TG_OP = 'DELETE') THEN
INSERT INTO audit_domains SELECT 'D', now(), user, OLD.*;
RETURN OLD;
ELSIF (TG_OP = 'UPDATE') THEN
INSERT INTO audit_domains SELECT 'U', now(), user, NEW.*;
RETURN NEW;
ELSIF (TG_OP = 'INSERT') THEN
INSERT INTO audit_domains SELECT 'I', now(), user, NEW.*;
RETURN NEW;
END IF;
RETURN NULL; -- result is ignored since this is an AFTER trigger
END;
$audit_domains$ LANGUAGE plpgsql;
CREATE TRIGGER audit_domains
AFTER INSERT OR UPDATE OR DELETE ON domains
FOR EACH ROW EXECUTE PROCEDURE process_audit_domains();
--
CREATE OR REPLACE FUNCTION process_audit_records() RETURNS TRIGGER AS $audit_records$
BEGIN
--
-- Create a row in audit_records to reflect the operation performed on records,
-- make use of the special variable TG_OP to work out the operation.
--
IF (TG_OP = 'DELETE') THEN
INSERT INTO audit_records SELECT 'D', now(), user, OLD.*;
RETURN OLD;
ELSIF (TG_OP = 'UPDATE') THEN
INSERT INTO audit_records SELECT 'U', now(), user, NEW.*;
RETURN NEW;
ELSIF (TG_OP = 'INSERT') THEN
INSERT INTO audit_records SELECT 'I', now(), user, NEW.*;
RETURN NEW;
END IF;
RETURN NULL; -- result is ignored since this is an AFTER trigger
END;
$audit_records$ LANGUAGE plpgsql;
CREATE TRIGGER audit_records
AFTER INSERT OR UPDATE OR DELETE ON records
FOR EACH ROW EXECUTE PROCEDURE process_audit_records();
/Howto |
permanent link |
writeback |
edit
