/* tables config. backendmaker.com by Enrique Gonzalez Alonso
 this file is generated by the table_cfg_gen.php file. Refer to the documentation. */

/* *** TABLE TEST_CATALOG *** */

var test_catalog = new Table();
test_catalog.table = "test_catalog";
test_catalog.tableName = "Catalog";
test_catalog.keyfield = "id";
test_catalog.fields = {
			reference: { fieldName: "Reference", kindof: "text", size:50, maxlength:50, validation: { required:true } },
			idcat: { fieldName: "Category", kindof: "list", validation: { required:true } },
			name: { fieldName: "Name", kindof: "text", size:75, maxlength:75, validation: { required:true } },
			visible: { fieldName: "Visible", kindof: "bool", values: {'N':lng.no, 'Y':lng.yes}, validation: { required:true } },
			content: { fieldName: "Content", kindof: "tinymce", validation: { required:true } },
			image: { fieldName: "Image", kindof: "image",  uploaddir: "uploads", imageresize: { width:200, height:0, crop:false },maxfilesize : 1048576,  allowedtypes : ["gif","jpeg","jpg","png"], createthumb : { width:100, height:100, crop:true }, morethumbs: { "medium" : { width:500, height:0, crop:false } }, validation: { required:true } }
};
test_catalog.listFields = ["image","name","idcat","visible"];//
test_catalog.order = ["idcat","asc"];
test_catalog.bounds = { start:0, limit:10 };
test_catalog.relationFields = { idcat: { table: "test_category", relationField: "id", substField: "name" } }; // chainedWith:"modelo"
test_catalog.fieldHints = {
       image: "The image formats allowed are jpg and png"
};    
test_catalog.tabs = {};                                
test_catalog.template = "tpl_listedit.php";

/* *** TABLE TEST_CATEGORY *** */

var test_category = new Table();
test_category.table = "test_category";
test_category.tableName = "Categories";
test_category.keyfield = "id";
test_category.fields = {
			name: { fieldName: "Name", kindof: "text", validation: { required:true } },
			ord: { fieldName: "Order", kindof: "text",  size:10, maxlength:3, validation: { required:true, valideas:"integer" } },
			visible: { fieldName: "Visible", kindof: "bool", values: {'N':lng.no, 'Y':lng.yes}, validation: { required:true } },
			description: { fieldName: "Description", kindof: "textarea" }
};
test_category.listFields = ["name","ord","visible"];
test_category.order = ["name","asc"];
test_category.bounds = { start:0, limit:10 };
test_category.relationFields = {};
test_category.fieldHints = {};
test_category.tabs = {};     
test_category.template = "tpl_listedit.php";

/* *** TABLE TEST_NEWS *** */

var test_news = new Table();
test_news.table = "test_news";
test_news.tableName = "News";
test_news.keyfield = "id";
test_news.fields = {
			title: { fieldName: "Title", kindof: "text",size:100, maxlength:100, validation: { required:true } },
			content: { fieldName: "Content", kindof: "tinymce", validation: { required:true } },
			date: { fieldName: "Date", kindof: "date", validation: { required:true } },
			enddate: { fieldName: "End date", kindof: "date" },
			image: { fieldName: "Image", kindof: "image",  uploaddir: "uploads/news", imageresize: { width:250, height:150, crop:true },maxfilesize : 1048576,  allowedtypes : ["gif","jpeg","jpg","png"] },
		  visible: { fieldName: "Visible", kindof: "bool", values: {'N':lng.no, 'Y':lng.yes}, validation: { required:true } },
			firstpage: { fieldName: "On first page", kindof: "bool", values: {'N':lng.no, 'Y':lng.yes}, validation: { required:true } }
};
test_news.listFields = ["title","date","visible"];
test_news.order = ["date","desc"];
test_news.bounds = { start:0, limit:10 };
test_news.relationFields = {};
test_news.fieldHints = {
       enddate: "You can leave this blank if there's no end date"
};
test_news.tabs = {};     
test_news.template = "tpl_listedit.php";

/* *** TABLE TEST_PAGES *** */

var test_pages = new Table();
test_pages.table = "test_pages";
test_pages.tableName = "Web pages";
test_pages.keyfield = "id";
test_pages.fields = {
			title: { fieldName: "Title", kindof: "text", initvalue:"The title", size:50, maxlength:50, validation: { required:true } },
			content: { fieldName: "Content", kindof: "tinymce", validation: { required:true } },
			comments: { fieldName: "Comments", kindof: "textarea" },
			image: { fieldName: "Image", kindof: "image",  uploaddir: "uploads", maxfilesize : 1048576,  allowedtypes : ["gif","jpeg","jpg","png"], validation: { required:true }  },
			thetime: { fieldName: "The time", kindof: "time", validation: { required:true, valideas:"time"} },
			thedatetime: { fieldName: "The datetime", kindof: "datetime", validation: { required:true, valideas:"date" } },
			frontend: { fieldName: "Frontend", kindof: "bool", values: {'0':lng.no, '1':lng.yes} },
			file: { fieldName: "File", kindof: "file",  uploaddir: "uploads/files", maxfilesize : 1048576,  allowedtypes : ["pdf","doc"] , validation: { required:true } },
			thedate: { fieldName: "The date", kindof: "date", validation: { required:true, valideas:"date" } },
			editablefor: { fieldName: "Editable For", kindof: "multilist", validation: { required:true } }
};
test_pages.listFields = ["image","title","thedatetime"]; //
test_pages.order = ["thedatetime","desc"];
test_pages.bounds = { start:0, limit:10 };
test_pages.relationFields = {
	                      editablefor: {  table: "test_typeofusers",  relationField: "IdTypeUser", substField: "Type" }
	                     };
/*test_pages.relationFields = { 
         editablefor: { table: "test_typeofusers", static_array: { 1:"Administrator", 2:"Super User", 3:"User", 4:"Writer", 5:"Reader" } }
                            }; */                       
test_pages.fieldHints = {};
test_pages.tabs = { title:"Tab 1", frontend:"Tab 2"};     
test_pages.template = "tpl_listedit.php"; 

/* *** TABLE TEST_TYPEOFUSERS *** */
/*
var test_typeofusers = new Table();
test_typeofusers.table = "test_typeofusers";
test_typeofusers.tableName = "Type of users";
test_typeofusers.keyfield = "IdTypeUser";
test_typeofusers.fields = {
			Type: { fieldName: "Type of user", kindof: "text", validation: { required:true } },
			Comments: { fieldName: "Comments", kindof: "textarea" }
};
test_typeofusers.listFields = ["Type"];
test_typeofusers.order = ["Type","asc"];
test_typeofusers.bounds = { start:0, limit:10 };
test_typeofusers.relationFields = {};
test_typeofusers.fieldHints = {};
test_typeofusers.template = "tpl_listedit.php";
         */
/* *** TABLE TEST_USERS *** */

var test_users = new Table();
test_users.table = "test_users";
test_users.tableName = "Users";
test_users.keyfield = "id";
test_users.fields = {
            name: { fieldName: "Name", kindof: "text", validation: { required:true } },
			user: { fieldName: "User", kindof: "text",size:25, maxlength:25, validation: { required:true } },
			password: { fieldName: "Password", kindof: "password",size:25, maxlength:25 },
			typeofuser: { fieldName: "Typeofuser", kindof: "list", validation: { required:true } },
			location: { fieldName: "Location", kindof: "coords", map: null, marker: null, geocoder: null, validation: { required:false } }
};
test_users.listFields = ["user","name","typeofuser"];
test_users.order = ["user","asc"];
test_users.bounds = { start:0, limit:10 };
//test_users.relationFields = { typeofuser: { table: "test_typeofusers", relationField: "IdTypeUser", substField: "Type" } }
test_users.relationFields = { 
         typeofuser: { table: "test_typeofusers", static_array: { 1:"Administrator", 2:"Super User", 3:"User", 4:"Writer", 5:"Reader", 6:"Administrator2", 7:"Super User2", 8:"User2", 9:"Writer2" } }
                            };
test_users.fieldHints = {};
test_users.tabs = {};     
test_users.template = "tpl_listedit.php";

/* *** TABLE TEST_WEBDATA *** */

var test_webdata = new Table();
test_webdata.table = "test_webdata";
test_webdata.tableName = "Web data";
test_webdata.keyfield = "id";
test_webdata.fields = {
			title: { fieldName: "Title", kindof: "text", size:100, validation: { required:true } },
			description: { fieldName: "Description", kindof: "text", validation: { required:true } },
			keywords: { fieldName: "Keywords", kindof: "textarea", validation: { required:true } },
			nombre: { fieldName: "Nombre", kindof: "text", validation: { required:true } },
			usuario: { fieldName: "User", kindof: "text", size:25, maxlength:25, validation: { required:true } },
			contrasena: { fieldName: "Password", kindof: "password", size:25, maxlength:25, validation: { required:true } },
			email: { fieldName: "Email", kindof: "text" }
			};
test_webdata.listFields = [];
test_webdata.order = [];
test_webdata.bounds = {};
test_webdata.relationFields = {};
test_webdata.fieldHints = {email: "Escribe el email del administrador, si no, no podr‡s recuperar la contrase–a si la pierdes"};
test_webdata.tabs = {};     
test_webdata.template = "tpl_onlyedit.php";