----
-- phpLiteAdmin database dump (http://phpliteadmin.googlecode.com)
-- phpLiteAdmin version: 1.9.3
-- Exported on Feb 11th, 2019, 09:05:48PM
-- Database file: ./master.dat
----
BEGIN TRANSACTION;

----
-- Table structure for samvend
----
CREATE TABLE 'samvend'  (  'codved' TEXT  PRIMARY KEY NOT NULL  ,  'nomved' TEXT  ,  'codzon' TEXT  ,  'comisi' REAL  ,  'empresa' TEXT  ,  'tipocomi' TEXT  ,  'consigna' TEXT  ,  'cedved' TEXT  ,  'telve1' TEXT  ,  'telve2' TEXT  ,  'dirv1' TEXT  ,  'dirv2' TEXT  ,  'clave' TEXT  ,  'nivel' TEXT  ,  'actpre' TEXT  ,  'email' TEXT  ,  'estene' REAL  ,  'estfeb' REAL  ,  'estmar' REAL  ,  'estabr' REAL  ,  'estmay' REAL  ,  'estjun' REAL  ,  'estjul' REAL  ,  'estago' REAL  ,  'estsep' REAL  ,  'estoct' REAL  ,  'estnov' REAL  ,  'estdic' REAL  );

----
-- Data dump for samvend, a total of 3 rows
----
INSERT INTO "samvend" ("codved","nomved","codzon","comisi","empresa","tipocomi","consigna","cedved","telve1","telve2","dirv1","dirv2","clave","nivel","actpre","email","estene","estfeb","estmar","estabr","estmay","estjun","estjul","estago","estsep","estoct","estnov","estdic") VALUES ('01','OPERADOR','','0.0','','V','','','','','','','123','9','','','800000.0','900000.0','1000000.0','13000000.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0','0.0');
INSERT INTO "samvend" ("codved","nomved","codzon","comisi","empresa","tipocomi","consigna","cedved","telve1","telve2","dirv1","dirv2","clave","nivel","actpre","email","estene","estfeb","estmar","estabr","estmay","estjun","estjul","estago","estsep","estoct","estnov","estdic") VALUES ('ADMIN','ADMINISTRADOR WEB','','0.0','','V','','','','','','','1473','9','','','100.0','200.0','300.0','400.0','500.0','600.0','700.0','800.0','900.0','100.0','1100.0','1200.0');
INSERT INTO "samvend" ("codved","nomved","codzon","comisi","empresa","tipocomi","consigna","cedved","telve1","telve2","dirv1","dirv2","clave","nivel","actpre","email","estene","estfeb","estmar","estabr","estmay","estjun","estjul","estago","estsep","estoct","estnov","estdic") VALUES ('02','VENDEDOR 02','','0.0','','V','','','5555','','','','123456','4','','','','','','','','','','','','','','');

----
-- Table structure for swmbanner
----
CREATE TABLE 'swmbanner' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'titulo' TEXT NOT NULL, 'imgbanner' TEXT NOT NULL);

----
-- Data dump for swmbanner, a total of 3 rows
----
INSERT INTO "swmbanner" ("id","titulo","imgbanner") VALUES ('0','ccccccccccccccccccccccc','../img/01/b1.png');
INSERT INTO "swmbanner" ("id","titulo","imgbanner") VALUES ('4','bbbbbbbbbbbbbbbbbbbbbbbbbb','../img/01/b1.png');
INSERT INTO "swmbanner" ("id","titulo","imgbanner") VALUES ('5','ddddddddddddddddddddd','../img/01/bn3.jpg');

----
-- Table structure for seccion
----
CREATE TABLE 'seccion' ('codsec' TEXT PRIMARY KEY NOT NULL, 'dessec' TEXT NOT NULL);

----
-- Data dump for seccion, a total of 4 rows
----
INSERT INTO "seccion" ("codsec","dessec") VALUES ('PORTADA','PORTADA');
INSERT INTO "seccion" ("codsec","dessec") VALUES ('BLOG','BLOG');
INSERT INTO "seccion" ("codsec","dessec") VALUES ('SERVICIO','SERVICIOS');
INSERT INTO "seccion" ("codsec","dessec") VALUES ('PRODUCTO','DESCRIPCION DE PRODUCTOS');

----
-- Table structure for documento
----
CREATE TABLE 'documento' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'aliasdoc' TEXT NOT NULL, 'codsec' TEXT NOT NULL, 'fechadoc' TEXT NOT NULL, 'tituldoc' TEXT NOT NULL, 'textodoc' TEXT NOT NULL, 'urldoc' TEXT NOT NULL, 'adjdoc' TEXT NOT NULL, 'imgdoc' TEXT NOT NULL);

----
-- Data dump for documento, a total of 4 rows
----
INSERT INTO "documento" ("id","aliasdoc","codsec","fechadoc","tituldoc","textodoc","urldoc","adjdoc","imgdoc") VALUES ('1','P1','BLOG','2019-01-01','DOCUMENTO','TEXTO DEL DOCUMENTO','http://siadm.com.ve','img/check.png','img/cabecera.jpg');
INSERT INTO "documento" ("id","aliasdoc","codsec","fechadoc","tituldoc","textodoc","urldoc","adjdoc","imgdoc") VALUES ('2','P1','BLOG','2019-01-01','DOCUMENTO','TEXTO DEL DOC 1','http://siadm.com.ve','../img/01/logo grupo1.jpg','../img/01/adnubis1.jpg');
INSERT INTO "documento" ("id","aliasdoc","codsec","fechadoc","tituldoc","textodoc","urldoc","adjdoc","imgdoc") VALUES ('3','A1','PORTADA','2019-02-01','DISEÑO WEB','documento doc 2','http://siadm.com.ve','../img/01/adnubis1.jpg','../img/01/logo grupo1.jpg');
INSERT INTO "documento" ("id","aliasdoc","codsec","fechadoc","tituldoc","textodoc","urldoc","adjdoc","imgdoc") VALUES ('4','b1','PORTADA','2019-02-07','Introduccion el Curso COMERCIALES 1','TEXTO DEL DOCUMENTO','','','');

----
-- Table structure for entradas
----
CREATE TABLE 'entradas' ('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'fecha' TEXT, 'pais' TEXT, 'ip' TEXT);

----
-- Data dump for entradas, a total of 0 rows
----

----
-- Table structure for empresa
----
CREATE TABLE 'empresa' ('id' INTEGER, 'emp_rif' TEXT,'emp_nombre' TEXT, 'emp_email' TEXT, 'emp_fb' TEXT, 'emp_inst' TEXT, 'emp_dir' TEXT, 'emp_tel1' TEXT, 'emp_tel2' TEXT,'emp_logo' TEXT);

----
-- Data dump for empresa, a total of 1 rows
----
INSERT INTO "empresa" ("id","emp_rif","emp_nombre","emp_email","emp_fb","emp_inst","emp_dir","emp_tel1","emp_tel2","emp_logo") VALUES ('1','V-12345678','DR. GUSTAVO GUERRERO','gustavo@gmail.com','http://facebook.com','http://instagram.com','San cristobal Edo. Tachira','+58 0414 7518521',NULL,'');

----
-- Structure for index sqlite_autoindex_samvend_1 on table samvend
----
;

----
-- Structure for index sqlite_autoindex_seccion_1 on table seccion
----
;
COMMIT;
