Platon Technologies
neprihlásený Prihlásiť Registrácia
SlovakEnglish
open source software development oslavujeme 10 rokov vývoja otvoreného softvéru! Nedeľa, 27. november 2022

Súbor: [Platon] / Metafox / sql / dump / make-dump.sh (stiahnutie)

Revízia 1.9, Fri Sep 28 18:49:48 2012 UTC (10 years, 2 months ago) by nepto


Zmeny od 1.8: +2 -2 [lines]

Changed slogan to: flexible content management system

#!/bin/sh

#
# Metafox - flexible content management system
#
# _sql/dump/make-dump.sh - creates initial SQL dump
# ____________________________________________________________
#
# Developed by Ondrej Jombik <nepto@platon.sk>
# Copyright (c) 2002,2004 Platon Group, http://platon.sk/
# All rights reserved.
#
# See README file for more information about this software.
# See COPYING file for license information.
#
# Download the latest version from
# http://platon.sk/projects/Metafox/
#

# $Platon: Metafox/sql/dump/make-dump.sh,v 1.8 2012-04-29 16:20:55 nepto Exp $

mysqldump -u metafox -pkofola metafox -d --add-drop-table > mysql.sql 
grep '^DROP TABLE' mysql.sql | sed 's/^.*\(ezin_[a-z_]\+\).*$/\1/g' > table-list.txt
mysqldump -u metafox -pkofola metafox -t ezin_roles >> mysql.sql 
cat >> mysql.sql <<EOF
--
-- Default users
--
INSERT INTO ezin_users (id,username,password,author_id,role_id) VALUES
    (1,'admin','896ae34257056a6edb7643e3db85bb21',0,1);
INSERT INTO ezin_users (id,username,password,author_id,role_id) VALUES
    (2,'user', '896ae34257056a6edb7643e3db85bb21',0,3);

--
-- Default authors
--
INSERT INTO ezin_authors (id,type,name,email,homepage,description) VALUES
    (1,'internal','Admin','platon@platon.sk','http://platon.sk/','This is Admin.');
INSERT INTO ezin_authors (id,type,name,email,homepage,description) VALUES
    (2,'internal','Ondrej Jombík','nepto@platon.sk','http://nepto.sk/','This is Nepto. ;-)');

--
-- Default section
--
INSERT INTO ezin_sections
    (id, author_id, ord, a_limit,
    type2, display, \`select\`,
    accesses_count, sessions_count, raw_accesses_count, raw_sessions_count,
    access_key, template_key, name, link)
VALUES
    (1,0,100,10,
    'global','in_list,articles_enabled','articles',
    0,0,0,0,
    'index','','Index','');
--
-- Default article
--
INSERT INTO ezin_articles
    (id, author_id, section_id,
    accesses_count, sessions_count, message_count,
    status, display, datetime, access_key, template_key,
    title, atitle, hometext, bodytext)
VALUES (1,2,1,
    0,0,0,
    'showed','enabled','2002-09-13 16:23:00','','',
    'Default article title','Default article annotation title',
    'Default article home text (annotation)',
    'Default article body text');
--
-- Default config
--
INSERT INTO ezin_config (a_key,value) VALUES ('name','Metafox Default');
INSERT INTO ezin_config (a_key,value) VALUES ('abbreviation','dflt');
INSERT INTO ezin_config (a_key,value) VALUES ('theme','default');
INSERT INTO ezin_config (a_key,value) VALUES ('url',NULL);
INSERT INTO ezin_config (a_key,value) VALUES ('redirect_index','S1');
INSERT INTO ezin_config (a_key,value) VALUES ('redirect_other',NULL);
INSERT INTO ezin_config (a_key,value) VALUES ('admin_session_timeout',1800);

EOF


Platon Group <platon@platon.sk> http://platon.sk/
Copyright © 2002-2006 Platon Group
Stránka používa redakčný systém Metafox
Na začiatok