subzero@mojo-jojo:~> cd sqliteman/
subzero@mojo-jojo:~/sqliteman> mkdir schemas
subzero@mojo-jojo:~/sqliteman> sqlplus3 a.db
bash: sqlplus3: command not found

see what an idiot am I ;)

now I'm creating 2 dbs with the same structure

subzero@mojo-jojo:~/sqliteman> sqlite3 a.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> create table foo (bar text);
sqlite> .q

subzero@mojo-jojo:~/sqliteman> sqlite3 b.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> create table foo (bar text);
sqlite> .q

opening and attaching both dbs

subzero@mojo-jojo:~/sqliteman> sqlite3 a.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> attach "b.db" as attdb;

both "schemas" structure

sqlite> .schema
CREATE TABLE foo (bar text);
sqlite> select * from attdb.sqlite_master;
table|foo|foo|2|CREATE TABLE foo (bar text)

now I'm creating new index in the attached db - and it's good . It's in the attached schema. But it's working in sqliteman too.

sqlite> create index attdb.ix1 on foo (bar);
sqlite> .schema
CREATE TABLE foo (bar text);
sqlite> select * from attdb.sqlite_master;
table|foo|foo|2|CREATE TABLE foo (bar text)
index|ix1|foo|3|CREATE INDEX ix1 on foo (bar)
sqlite> select * from main.sqlite_master;
table|foo|foo|2|CREATE TABLE foo (bar text)


let's try the triggers now - create one in attached schema.

sqlite> create trigger attdb.v1 after delete on foo
   ...> begin
   ...> select * from sqlite_master;
   ...> end;

GEEZ! This is "The Syntax" (TM)
All is in the attached db.

sqlite> .schema
CREATE TABLE foo (bar text);

sqlite> select * from attdb.sqlite_master;
table|foo|foo|2|CREATE TABLE foo (bar text)
index|ix1|foo|3|CREATE INDEX ix1 on foo (bar)
trigger|v1|foo|0|CREATE TRIGGER v1 after delete on foo
begin
select * from sqlite_master;
end
sqlite> .q


Now the test of standalone databases

subzero@mojo-jojo:~/sqliteman> sqlite3 a.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> .schema
CREATE TABLE foo (bar text);
sqlite> .q

subzero@mojo-jojo:~/sqliteman> sqlite3 b.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> .schema
CREATE TABLE foo (bar text);
CREATE INDEX ix1 on foo (bar);
CREATE TRIGGER v1 after delete on foo
begin
select * from sqlite_master;
end;
sqlite> .q

game over