* Uncomment next line for versions <= 3.1 */ /* DROP INDEX rec_name_index ON records; */ ALTER TABLE records ADD disabled TI

The Fox and the Stork At one time the Fox and the Stork were on visiting terms and seemed very good friends. So the Fox invited the Stork to dinner, and for a joke put nothing before her but some soup in a very shallow dish. This the Fox could easily lap up, but the Stork could only wet the end of her long bill in it, and left the meal as hungry as when she began. "I am sorry," said the Fox, "the soup is not to your liking." "Pray do not apologise," said the Stork. "I hope you will return this visit, and come and dine with me soon." So a day was appointed when the Fox should visit the Stork; but when they were seated at table all that was for their dinner was contained in a very long-necked jar with a narrow mouth, in which the Fox could not insert his snout, so all he could manage to do was to lick the outside of the jar. "I will not apologise for the dinner," said the Stork: "One bad turn deserves another."
copy
2
1
* Uncomment next line for versions <= 3.1 */ /* DROP INDEX rec_name_index ON records; */ ALTER TABLE records ADD disabled TI/* Uncomment next line for versions <= 3.3 */ /* ALTER TABLE domains ADD CONSTRAINT c_lowercase_name CHECK (((name)::TEXT = LOWER((name)::TEXT))); */ ALTER TABLE records ADD disabled BOOL DEFAULT 'f'; ALTER TABLE records ALTER COLUMN content TYPE VARCHAR(65535); ALTER TABLE records ADD ordername VARCHAR(255); ALTER TABLE records ADD auth BOOL DEFAULT 't'; ALTER TABLE records ALTER COLUMN type TYPE VARCHAR(10); ALTER TABLE supermasters ALTER COLUMN ip TYPE INET USING ip::INET; ALTER TABLE supermasters ALTER COLUMN account SET DEFAULT NOT NULL; ALTER TABLE supermasters ADD CONSTRAINT supermasters_pkey PRIMARY KEY (ip, nameserver); CREATE INDEX recordorder ON records (domain_id, ordername text_pattern_ops); CREATE TABLE domainmetadata ( id SERIAL PRIMARY KEY, domain_id INT REFERENCES domains(id) ON DELETE CASCADE, kind VARCHAR(32), content TEXT ); CREATE INDEX domainidmetaindex ON domainmetadata(domain_id); CREATE TABLE cryptokeys ( id SERIAL PRIMARY KEY, domain_id INT REFERENCES domains(id) ON DELETE CASCADE, flags INT NOT NULL, active BOOL, content TEXT ); CREATE INDEX domainidindex ON cryptokeys(domain_id); CREATE TABLE tsigkeys ( id SERIAL PRIMARY KEY, name VARCHAR(255), algorithm VARCHAR(50), secret VARCHAR(255), constraint c_lowercase_name CHECK (((name)::TEXT = LOWER((name)::TEXT))) ); CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm); CREATE TABLE comments ( id SERIAL PRIMARY KEY, domain_id INT NOT NULL, name VARCHAR(255) NOT NULL, type VARCHAR(10) NOT NULL, modified_at INT NOT NULL, account VARCHAR(40) DEFAULT NULL, comment VARCHAR(65535) NOT NULL, CONSTRAINT domain_exists FOREIGN KEY(domain_id) REFERENCES domains(id) ON DELETE CASCADE, CONSTRAINT c_lowercase_name CHECK (((name)::TEXT = LOWER((name)::TEXT))) ); CREATE INDEX comments_domain_id_idx ON comments (domain_id); CREATE INDEX comments_name_type_idx ON comments (name, type); CREATE INDEX comments_order_idx ON comments (domain_id, modified_at); For gpgsql backend with dnssec schema: /* Uncomment next 2 lines for versions <= 3.3 */ /* ALTER TABLE domains ADD CONSTRAINT c_lowercase_name CHECK (((name)::TEXT = LOWER((name)::TEXT))); */ /* ALTER TABLE tsigkeys ADD CONSTRAINT c_lowercase_name CHECK (((name)::TEXT = LOWER((name)::TEXT))); */ ALTER TABLE records ADD disabled BOOL DEFAULT 'f'; ALTER TABLE records ALTER COLUMN content TYPE VARCHAR(65535); ALTER TABLE records ALTER COLUMN auth SET DEFAULT 't'; ALTER TABLE records ALTER COLUMN type TYPE VARCHAR(10); ALTER TABLE supermasters ALTER COLUMN ip TYPE INET USING ip::INET; ALTER TABLE supermasters ALTER COLUMN account SET DEFAULT NOT NULL; ALTER TABLE supermasters ADD CONSTRAINT supermasters_pkey PRIMARY KEY (ip, nameserver); ALTER TABLE domainmetadata ALTER COLUMN kind TYPE VARCHAR(32); ALTER TABLE tsigkeys ALTER COLUMN algorithm TYPE VARCHAR(50); CREATE INDEX recordorder ON records (domain_id, ordername text_pattern_ops); DROP INDEX IF EXISTS orderindex; CREATE TABLE comments ( id SERIAL PRIMARY KEY, domain_id INT NOT NULL, name VARCHAR(255) NOT NULL, type VARCHAR(10) NOT NULL, modified_at INT NOT NULL, account VARCHAR(40) DEFAULT NULL, comment VARCHAR(65535) NOT NULL, CONSTRAINT domain_exists FOREIGN KEY(domain_id) REFERENCES domains(id) ON DELETE CASCADE, CONSTRAINT c_lowercase_name CHECK (((name)::TEXT = LOWER((name)::TEXT))) ); CREATE INDEX comments_domain_id_idx ON comments (domain_id); CREATE INDEX comments_name_type_idx ON comments (name, type); CREATE INDEX comments_order_idx ON comments (domain_id, modified_at); For gsqlite3 backend with nodnssec schema: ALTER TABLE records ADD disabled BOOL DEFAULT 0; ALTER TABLE records ADD ordername VARCHAR(255); ALTER TABLE records ADD auth BOOL DEFAULT 1; CREATE INDEX orderindex ON records(ordername); CREATE TABLE domainmetadata ( id INTEGER PRIMARY KEY, domain_id INT NOT NULL, kind VARCHAR(32) COLLATE NOCASE, content TEXT ); CREATE INDEX domainmetaidindex on domainmetadata(domain_id); CREATE TABLE cryptokeys ( id INTEGER PRIMARY KEY, domain_id INT NOT NULL, flags INT NOT NULL, active BOOL, content TEXT ); CREATE INDEX domainidindex ON cryptokeys(domain_id); CREATE TABLE tsigkeys ( id INTEGER PRIMARY KEY, name VARCHAR(255) COLLATE NOCASE, algorithm VARCHAR(50) COLLATE NOCASE, secret VARCHAR(255) ); CREATE UNIQUE INDEX namealgoindex ON tsigkeys(name, algorithm); CREATE TABLE comments ( id INTEGER PRIMARY KEY, domain_id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, type VARCHAR(10) NOT NULL, modified_at INT NOT NULL, account VARCHAR(40) DEFAULT NULL, comment VARCHAR(65535) NOT NULL ); CREATE INDEX comments_domain_id_index ON comments (domain_id); CREATE INDEX comments_nametype_index ON comments (name, type); CREATE INDEX comments_order_idx ON comments (domain_id, modified_at); BEGIN TRANSACTION; CREATE TEMPORARY TABLE supermasters_backup ( ip VARCHAR(64) NOT NULL, nameserver VARCHAR(255) NOT NULL COLLATE NOCASE, account VARCHAR(40) DEFAULT NULL ); INSERT INTO supermasters_backup SELECT ip, nameserver, account FROM supermasters; UPDATE supermasters_backup SET account='' WHERE account IS NULL; DROP TABLE supermasters; CREATE TABLE supermasters ( ip VARCHAR(64) NOT NULL, nameserver VARCHAR(255) NOT NULL COLLATE NOCASE, account VARCHAR(40) NOT NULL ); CREATE UNIQUE INDEX ip_nameserver_pk ON supermasters(ip, nameserver); INSERT INTO supermasters SELECT ip, nameserver, account FROM supermasters_backup; DROP TABLE supermasters_backup; COMMIT; For gsqlite3 backend with dnssec schema: CREATE TABLE comments ( id INTEGER PRIMARY KEY, domain_id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, type VARCHAR(10) NOT NULL, modified_at INT NOT NULL, account VARCHAR(40) DEFAULT NULL, comment VARCHAR(65535) NOT NULL ); CREATE INDEX comments_domain_id_index ON comments (domain_id); CREATE INDEX comments_nametype_index ON comments (name, type); CREATE INDEX comments_order_idx ON comments (domain_id, modified_at); BEGIN TRANSACTION; CREATE TEMPORARY TABLE records_backup( id INTEGER PRIMARY KEY, domain_id INTEGER DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, type VARCHAR(10) DEFAULT NULL, content VARCHAR(65535) DEFAULT NULL, ttl INTEGER DEFAULT NULL, prio INTEGER DEFAULT NULL, change_date INTEGER DEFAULT NULL, ordername VARCHAR(255), auth BOOL DEFAULT 1 ); INSERT INTO records_backup SELECT id,domain_id,name,type,content,ttl,prio,change_date,ordername,auth FROM records; DROP TABLE records; CREATE TABLE records ( id INTEGER PRIMARY KEY, domain_id INTEGER DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, type VARCHAR(10) DEFAULT NULL, content VARCHAR(65535) DEFAULT NULL, ttl INTEGER DEFAULT NULL, prio INTEGER DEFAULT NULL, change_date INTEGER DEFAULT NULL, disabled BOOLEAN DEFAULT 0, ordername VARCHAR(255), auth BOOL DEFAULT 1 ); CREATE INDEX rec_name_index ON records(name); CREATE INDEX nametype_index ON records(name,type); CREATE INDEX domain_id ON records(domain_id); CREATE INDEX orderindex ON records(ordername); INSERT INTO records SELECT id,domain_id,name,type,content,ttl,prio,change_date,0,ordername,auth FROM records_backup; DROP TABLE records_backup; COMMIT; BEGIN TRANSACTION; CREATE TEMPORARY TABLE supermasters_backup ( ip VARCHAR(64) NOT NULL, nameserver VARCHAR(255) NOT NULL COLLATE NOCASE, account VARCHAR(40) DEFAULT NULL ); INSERT INTO supermasters_backup SELECT ip,nameserver,account FROM supermasters; UPDATE supermasters_backup SET account='' WHERE account IS NULL; DROP TABLE supermasters; CREATE TABLE supermasters ( ip VARCHAR(64) NOT NULL, nameserver VARCHAR(255) NOT NULL COLLATE NOCASE, account VARCHAR(40) NOT NULL ); CREATE UNIQUE INDEX ip_nameserver_pk ON supermasters(ip, nameserver); INSERT INTO supermasters SELECT ip,nameserver,account FROM supermasters_backup; DROP TABLE supermasters_backup; COMMIT; BEGIN TRANSACTION; CREATE TABLE domainmetadata_backup ( id INTEGER PRIMARY KEY, domain_id INT NOT NULL, kind VARCHAR(32) COLLATE NOCASE, content TEXT ); INSERT INTO domainmetadata_backup SELECT id,domain_id,kind,content FROM domainmetadata; DROP TABLE domainmetadata; CREATE TABLE domainmetadata ( id INTEGER PRIMARY KEY, domain_id INT NOT NULL, kind VARCHAR(32) COLLATE NOCASE, content TEXT ); CREATE INDEX domainmetaidindex ON domainmetadata(domain_id); INSERT INTO domainmetadata SELECT id,domain_id,kind,content FROM domainmetadata_backup; DROP TABLE domainmetadata_backup; COMMIT; For goracle backend: ALTER TABLE records ADD disabled INT DEFAULT 0; ALTER TABLE records MODIFY auth INT DEFAULT 1; UPDATE records SET auth=1 WHERE auth IS NULL; ALTER TABLE domainmetadata MODIFY kind VARCHAR2(32); The Fox and the Stork At one time the Fox and the Stork were on visiting terms and seemed very good friends. So the Fox invited the Stork to dinner, and for a joke put nothing before her but some soup in a very shallow dish. This the Fox could easily lap up, but the Stork could only wet the end of her long bill in it, and left the meal as hungry as when she began. "I am sorry," said the Fox, "the soup is not to your liking." "Pray do not apologise," said the Stork. "I hope you will return this visit, and come and dine with me soon." So a day was appointed when the Fox should visit the Stork; but when they were seated at table all that was for their dinner was contained in a very long-necked jar with a narrow mouth, in which the Fox could not insert his snout, so all he could manage to do was to lick the outside of the jar. "I will not apologise for the dinner," said the Stork: "One bad turn deserves another."

2 years, 4 months ago younes.haji.735 1 |

Result:

À mon propos 
Musique:

emminem , maria carry , ....... éditer
Films:

transporteur , street-fighters , bruce lee ,..... éditer
Télévision:

chiffres et lettres , mbc action ,........ éditer
Livres:

les méserables , les fables de la fontaine , le cid ,......... éditer
Sports:

équitation , natation , windsurfing , karaté , gymnastique ,....... éditer
Intérêts:

la lecture , le voyage , promenade à la foret et à plage ,...... éditer
Rêves:

je reve d'etre journaliste , et vivre en paix et surety....... éditer
Meilleurs attraits:

j'aime les belles fillettes , la beauté et la tranquilité , la sagesse , .... éditer
À mon propos:

je suis un mec sérieux et gentil , je souhaite trouver une fille charmante et adorable à motif sérieux .....♦♣◘○♠♥ éditer
One. I believe knowledge is po:

Please give this heart, to your precious friends who you care about... I will wait for mine if i am one of them... only for most dearest friend ... ♫♫↓$↓ ♀ ☼►‼↕◄Ï☼ we might not talk much but we still friends always even we don't talk i will hold u close to my heart éditersupprimer
Ajouter davantage de champs...