-- teste

strings = {
	infos = {
		versao = "0.9b",
		segredoDaVidaDoUniversoEDeTudoMais = "42",
		_f=function(t) -- estadoEvolutivo
			return "sofisticação"
		end,
		personagem = {
			_list = { -- nome
				"Ford Perfect",
				"Artur Dent",
				"Bebop Beeblebosk",
				"Trixy",
				"Marvin"
			}
		},
	}
}

math.randomseed(os.time())

local func = { __index = function(t,v) return t._f(t) end }
local list = { __index = function(t,v) return t._list[math.random(#t._list)] end }

setmetatable(strings,func)
setmetatable(strings.infos,func)
setmetatable(strings.infos.personagem,list)


print(strings.infos.estadoEvolutivo)
print(strings.infos.personagem.nome)
print(strings.infos.personagem.nome)
print(strings.infos.personagem.nome)

--     12345678901234567
str = 'Alonso {nome1.yg} é \{nome\}} "{fe}" *{dsd}* ok'
print( str:find("\{[%a%d\.]*\}",1) )






CREATE TABLE IF NOT EXISTS "arquivos" (
_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
filename VARCHAR(255) DEFAULT "." NOT NULL,
is_folder BOOLEAN DEFAULT false NOT NULL,
parent INTEGER,
revisao INTEGER DEFAULT 0 NOT NULL,
ativo BOOLEAN DEFAULT true NOT NULL,
dono INTEGER DEFAULT 0 NOT NULL,
data_entrada INTEGER DEFAULT 0 NOT NULL,
path VARCHAR(255) DEFAULT "." NOT NULL,
md5 VARCHAR(32) NULL,
content BLOB NULL
);

CREATE INDEX IF NOT EXISTS ndx_path
ON arquivos (path);

CREATE TRIGGER IF NOT EXISTS INSERT_arquivo AFTER INSERT ON arquivos
BEGIN UPDATE arquivos SET data_entrada = strftime('%s','now') WHERE _id = new.rowid;
END;

CREATE TABLE IF NOT EXISTS "devArquivos" (
_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
arquivo_id INTEGER DEFAULT 0 NOT NULL,
cdate INTEGER DEFAULT 0 NOT NULL,
mdate INTEGER DEFAULT 0 NOT NULL,
size INTEGER,
original_path VARCHAR(255) ,
parent_dev INTEGER
);

# setup
INSERT INTO arquivos (filename,path,is_folder) VALUES("media","/media",true);
INSERT INTO arquivos (filename,path,is_folder) VALUES("bluebooks","/bluebooks",true);
INSERT INTO arquivos (filename,path,is_folder) VALUES("saves","/saves",true);
INSERT INTO arquivos (filename,path,is_folder) VALUES("users","/users",true);


###------------------

CREATE TABLE IF NOT EXISTS users (
_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
nome VARCHAR(255) NOT NULL DEFAULT "player1",
email VARCHAR(255),
feedback_enabled BOOLEAN NOT NULL DEFAULT false,
hiscore INTEGER NOT NULL DEFAULT 0,
so_name VARCHAR(255)
);

INSERT INTO users (_id, nome, so_name) VALUES(1,"system","Android");

###------------------
#procedures
CREATE TABLE IF NOT EXISTS procedures (
_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
nome VARCHAR(255) NOT NULL DEFAULT "function",
content TEXT NOT NULL DEFAULT "--- code ---",
cdate INTEGER NOT NULL DEFAULT 0
);


###----------------------

#Blue Book
CREATE TABLE IF NOT EXISTS bluebooks (
_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
nome VARCHAR(255) NOT NULL DEFAULT "book_of_",
arquivo_id INTEGER NOT NULL DEFAULT 0,
data_inicio INTEGER NOT NULL DEFAULT 0,
data_update INTEGER NOT NULL DEFAULT 0
);

CREATE TRIGGER IF NOT EXISTS INSERT_book AFTER INSERT ON bluebooks
BEGIN UPDATE bluebooks SET data_inicio=strftime('%s','now') WHERE _id=new.rowid;
END;

# Saves
#
CREATE TABLE saves (
_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
data_save INTEGER DEFAULT 0 NOT NULL,
dono INTEGER DEFAULT 0 NOT NULL,
bluebook_id INTEGER DEFAULT 0 NOT NULL,
horas_jogadas INTEGER DEFAULT 0 NOT NULL,
snapshot INTEGER DEFAULT 0 NOT NULL
);

CREATE TRIGGER IF NOT EXISTS INSERT_save AFTER INSERT ON saves
BEGIN UPDATE saves SET data_save=strftime('%s','now') WHERE _id=new.rowid;
END;

CREATE TRIGGER IF NOT EXISTS UPDATE_save AFTER UPDATE ON saves
BEGIN UPDATE saves SET data_save=strftime('%s','now') WHERE _id=new.rowid;
END;

###-----------------------------
CREATE TABLE bootstrap (
app_title VARCHAR(255) DEFAULT "Wild Witch Project - The Game" NOT NULL,
win_width INTEGER DEFAULT 800 NOT NULL,
win_height INTEGER DEFAULT 520 NOT NULL,
windomed BOOLEAN DEFAULT true NOT NULL,
check_updates BOOLEAN DEFAULT true NOT NULL
);