create table gmja_sites ( siteid int(11) NOT NULL auto_increment, baseurl varchar(255) not null, dns varchar(255) not null, PRIMARY KEY (siteid) ); -- gm.ja is for the internal config / setup stuff. insert into gmja_sites values (1, '/ja/servlet/ja/index.html', 'gm.ja'); insert into gmja_sites values (2, '/ja/servlet/ja/index.html', 'gusmueller.com'); --insert into gmja_sites values (2, '/ja/servlet/ja/index.html', 'localhost'); insert into gmja_sites values (3, '/ja/servlet/ja/index.html', 'testgus.mu.org'); CREATE TABLE gmja_macros ( macroid int(11) not null auto_increment unique, siteid int(11) NOT NULL, macrokey varchar(255) NOT NULL, macro longblob NOT NULL, PRIMARY KEY (siteid, macrokey) ); insert into gmja_macros values ('', 1, 'header', '\nGMJa\n

Your website

\n
\n'); insert into gmja_macros values ('', 1, 'footer', '
Copyright (c) you.'); insert into gmja_macros values ('', 1, 'apple', 'Apple'); create table gmja_pages ( pageid int(11) not null, formatter varchar(255) not null, path varchar(255) not null, siteid int (11) not null, autohtml int(1) default '1', page blob ); insert into gmja_pages values(1, 'ja', '/index.html', 1, 1, 'Welcome to your website.'); create table gmja_attributes( siteid int(11) not null, id varchar(255) not null, attkey varchar(255) not null, value varchar(255) ); insert into gmja_attributes values (1, 'page.1', 'wrapper.header', 'header'); insert into gmja_attributes values (1, 'page.1', 'wrapper.footer', 'footer'); insert into gmja_attributes values (1, 'page.46', 'wrapper.header', 'header'); insert into gmja_attributes values (1, 'page.46', 'wrapper.footer', 'footer'); insert into gmja_attributes values (1, 'page.3', 'wrapper.header', 'header'); insert into gmja_attributes values (1, 'page.3', 'wrapper.footer', 'footer'); insert into gmja_attributes values (1, 'ja', 'timezone', '-6'); create table gmja_users ( userid int(11) not null, nickname varchar(255) not null, firstname varchar(255), lastname varchar(255), pass varchar(255) ); insert into gmja_users values (1, 'admin', 'Super', 'User', 'foo'); create table gmja_siteusers( siteid int(11) not null, userid int(11) not null ); -- test site insert into gmja_siteusers values (1, 1); -- gusmueller.com insert into gmja_siteusers values (2, 1); -- another test site insert into gmja_siteusers values (3, 1); --delete from gmja_pages; insert into gmja_pages (pageid, formatter, path, siteid, autohtml, page) select pageid, 'java', path, 2, 1, page from pages where site='gusmueller.com'; delete from gmja_pages where path='/index.html' and siteid = 2; update gmja_pages set path='/index.html' where path='/default.html'; --delete from gmja_macros; insert into gmja_macros (siteid, macrokey, macro) select 2, elementname, element from elements where site = 'gusmueller.com'; CREATE TABLE gmja_blog_users ( userid int(11) NOT NULL default '0', blogid int(11) NOT NULL default '0', PRIMARY KEY (userid,blogid) ); drop table gmja_skins; create table gmja_skins ( skinName varchar(128) NOT NULL, skinKey varchar(128) NOT NULL, skin longblob NOT NULL, PRIMARY KEY (skinName, skinKey) ); -- body stuff. insert into gmja_skins values ('ja', 'background', 'bgcolor="#ffffff"'); insert into gmja_skins values ('ja', 'text', 'text="#444444"'); insert into gmja_skins values ('ja', 'marginwidth', 'marginwidth="0"'); insert into gmja_skins values ('ja', 'marginheight', 'marginheight="0"'); insert into gmja_skins values ('ja', 'topmargin', 'topmargin="0"'); insert into gmja_skins values ('ja', 'leftmargin', 'leftmargin="0"'); insert into gmja_skins values ('ja', 'editHeader', '
'); insert into gmja_skins values ('ja', 'editFooter', '
'); create table gmja_logs ( hitDate datetime not null, serverName varchar(128) NOT NULL, uri varchar(255) NOT NULL, ip varchar(255) NOT NULL, referer varchar(128) ); -- update gmja_sites set dns = 'localhost' where dns='gusmueller.com'; -- update pages set site = 'localhost' where site = 'gusmueller.com';