[gnome-db] This SQL schema gets crazy to Mergeant (and me)
- From: Juan Manuel Mouriz <jmouriz gmail com>
- To: gnome-db-list gnome org
- Subject: [gnome-db] This SQL schema gets crazy to Mergeant (and me)
- Date: Mon, 17 Oct 2005 15:43:25 -0300
I send a SQL schema in MySQL that gets crazy to Mergeant
The table at issue is "clients", when I try view the table contents in Mergeant.
The first error that I get is:
0x4016849a in render_date_locale (date=0x0, locale=0x8232c68)
at gnome-db-handler-time.c:510
I put a g_return_val_if_fail in the code to avoid this in libgnomedb.
Later, I can view the table contents, but with several crashes. I send
the SQL script.
--
Juan M. Mouriz
-- MySQL dump 9.11
--
-- Host: localhost Database: db_avstafe
-- ------------------------------------------------------
-- Server version 4.0.24_Debian-10sarge1-log
--
-- Table structure for table `billing_info`
--
DROP TABLE IF EXISTS `billing_info`;
CREATE TABLE `billing_info` (
`bi_id` int(11) unsigned NOT NULL auto_increment,
`bi_trade_name` varchar(255) default NULL,
`bi_cuit` varchar(255) default NULL,
`bi_address` varchar(255) default NULL,
`bi_cp` varchar(255) default NULL,
`bi_iva_id` tinyint(3) unsigned NOT NULL default '0',
`bi_notes` text,
PRIMARY KEY (`bi_id`),
KEY `bi_iva_id` (`bi_iva_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `billing_info`
--
--
-- Table structure for table `clients`
--
DROP TABLE IF EXISTS `clients`;
CREATE TABLE `clients` (
`cli_id` int(11) unsigned NOT NULL auto_increment,
`cli_bi_id` int(11) unsigned NOT NULL default '0',
`cli_trade_name` varchar(255) default NULL,
`cli_gal_id` tinyint(3) unsigned NOT NULL default '0',
`cli_address` varchar(255) default NULL,
`cli_cp` varchar(255) default NULL,
`cli_open` text,
`cli_map_ref` smallint(5) NOT NULL default '0',
`cli_map_img` varchar(255) default NULL,
`cli_desc_short` varchar(255) default NULL,
`cli_desc_long` text,
`cli_home_img` varchar(255) default NULL,
`cli_logo1` varchar(255) default NULL,
`cli_logo2` varchar(255) default NULL,
`cli_isvisible` enum('Y','N') NOT NULL default 'N',
`cli_pln_id` tinyint(3) unsigned NOT NULL default '0',
`cli_int_ref` varchar(255) default NULL,
`cli_web_ref` varchar(255) default NULL,
`cli_vencimiento` date NOT NULL default '0000-00-00',
`cli_created_on` date NOT NULL default '0000-00-00',
`cli_created_by` smallint(5) unsigned NOT NULL default '0',
`cli_edited_on` date NOT NULL default '0000-00-00',
`cli_edited_by` smallint(5) unsigned NOT NULL default '0',
`cli_assigned_to` smallint(5) unsigned NOT NULL default '0',
`cli_keywords` text,
PRIMARY KEY (`cli_id`),
KEY `cli_bi_id` (`cli_bi_id`),
KEY `cli_gal_id` (`cli_gal_id`),
KEY `cli_pln_id` (`cli_pln_id`),
KEY `cli_created_by` (`cli_created_by`),
KEY `cli_edited_by` (`cli_edited_by`),
KEY `cli_assigned_to` (`cli_assigned_to`),
FULLTEXT KEY `cli_keywords` (`cli_keywords`,`cli_trade_name`,`cli_address`,`cli_desc_long`,`cli_desc_short`)
) TYPE=MyISAM;
--
-- Dumping data for table `clients`
--
INSERT INTO `clients` VALUES (1,0,'Crann|media',1,'Suipacha 211 Piso 22º C','',NULL,0,NULL,'Diseño y comunicación','Crann|media brinda soluciones integrales en tecnología, diseño y comunicación.','','','','Y',1,NULL,'www.crannmedia.com','0000-00-00','0000-00-00',0,'2005-10-05',6,0,'informática,tecnología,diseño,comunicación,servidores,programación,asesoramiento');
INSERT INTO `clients` VALUES (8,0,'Razón social',0,'Dirección','',NULL,0,NULL,'Descripción corta','Descripción larga','','','','Y',3,NULL,'www.razon-social.com.ar','0000-00-00','2005-09-27',6,'2005-10-05',6,0,'Algunas palabras clave');
INSERT INTO `clients` VALUES (15,0,'',0,'','',NULL,0,NULL,'','','','','','',3,NULL,'','0000-00-00','2005-10-04',6,'0000-00-00',0,0,'');
INSERT INTO `clients` VALUES (16,0,'',0,'','',NULL,0,NULL,'','','','','','',3,NULL,'','0000-00-00','2005-10-04',6,'0000-00-00',0,0,'');
INSERT INTO `clients` VALUES (17,0,'',0,'','',NULL,0,NULL,'','','','','','',3,NULL,'','0000-00-00','2005-10-04',6,'0000-00-00',0,0,'');
INSERT INTO `clients` VALUES (18,0,'',0,'','',NULL,0,NULL,'','','','','','',3,NULL,'','0000-00-00','2005-10-04',6,'0000-00-00',0,0,'');
INSERT INTO `clients` VALUES (19,0,'',0,'','',NULL,0,NULL,'','','','','','',3,NULL,'','0000-00-00','2005-10-04',6,'0000-00-00',0,0,'');
INSERT INTO `clients` VALUES (20,0,'XXXXX',0,'','',NULL,0,NULL,'','','','','','N',3,NULL,'','0000-00-00','2005-10-04',6,'2005-10-04',6,0,'');
INSERT INTO `clients` VALUES (21,0,'YYYYYY',0,'','',NULL,0,NULL,'','','','','','Y',3,NULL,'','0000-00-00','2005-10-04',6,'0000-00-00',0,0,'');
--
-- Table structure for table `fdp_data`
--
DROP TABLE IF EXISTS `fdp_data`;
CREATE TABLE `fdp_data` (
`fdpd_id` smallint(6) unsigned NOT NULL auto_increment,
`fdpd_caption` varchar(255) default NULL,
`fdpd_icon` varchar(255) default NULL,
`fdpd_text_only` enum('Y','N') NOT NULL default 'N',
`fdpd_alt_text` varchar(255) default NULL,
`fdpd_fdpg_id` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`fdpd_id`),
KEY `fdpd_fdpg_id` (`fdpd_fdpg_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `fdp_data`
--
--
-- Table structure for table `fdp_grp`
--
DROP TABLE IF EXISTS `fdp_grp`;
CREATE TABLE `fdp_grp` (
`fdpg_id` tinyint(3) unsigned NOT NULL auto_increment,
`fdpg_caption` varchar(255) default NULL,
`fpdg_order` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`fdpg_id`),
KEY `fpdg_order` (`fpdg_order`)
) TYPE=MyISAM;
--
-- Dumping data for table `fdp_grp`
--
--
-- Table structure for table `galerias`
--
DROP TABLE IF EXISTS `galerias`;
CREATE TABLE `galerias` (
`gal_id` tinyint(3) unsigned NOT NULL auto_increment,
`gal_name` varchar(255) default NULL,
`gal_address` varchar(255) default NULL,
PRIMARY KEY (`gal_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `galerias`
--
INSERT INTO `galerias` VALUES (1,'Araoz','Av. Santa Fé 3616');
INSERT INTO `galerias` VALUES (2,'Galería de muestra','');
--
-- Table structure for table `icons_data`
--
DROP TABLE IF EXISTS `icons_data`;
CREATE TABLE `icons_data` (
`icn_id` tinyint(3) unsigned NOT NULL auto_increment,
`icn_caption` varchar(255) default NULL,
`icn_img` varchar(255) default NULL,
`icn_alt_text` varchar(255) default NULL,
PRIMARY KEY (`icn_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `icons_data`
--
INSERT INTO `icons_data` VALUES (20,'Cupones','20.gif','');
INSERT INTO `icons_data` VALUES (21,'Correo electrónico','21.gif','');
INSERT INTO `icons_data` VALUES (22,'URL externa','22.gif','');
INSERT INTO `icons_data` VALUES (23,'Fotos','23.gif','');
INSERT INTO `icons_data` VALUES (24,'Radio Rivadavia','24.gif','');
--
-- Table structure for table `iva`
--
DROP TABLE IF EXISTS `iva`;
CREATE TABLE `iva` (
`iva_id` tinyint(3) unsigned NOT NULL auto_increment,
`iva_caption` varchar(255) default NULL,
PRIMARY KEY (`iva_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `iva`
--
--
-- Table structure for table `keywords`
--
DROP TABLE IF EXISTS `keywords`;
CREATE TABLE `keywords` (
`key_id` int(11) unsigned NOT NULL auto_increment,
`key_cli_id` int(11) unsigned NOT NULL default '0',
`key_keywords` text,
PRIMARY KEY (`key_id`),
KEY `key_cli_id` (`key_cli_id`),
KEY `key_keywords` (`key_keywords`(255))
) TYPE=MyISAM;
--
-- Dumping data for table `keywords`
--
--
-- Table structure for table `lifetime`
--
DROP TABLE IF EXISTS `lifetime`;
CREATE TABLE `lifetime` (
`lt_id` int(11) unsigned NOT NULL auto_increment,
`lt_cli_id` int(11) unsigned NOT NULL default '0',
`lt_status` enum('ON','OFF') NOT NULL default 'ON',
`lt_from` date NOT NULL default '0000-00-00',
`lt_or_id` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`lt_id`),
KEY `lt_cli_id` (`lt_cli_id`),
KEY `lt_or_id` (`lt_or_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `lifetime`
--
--
-- Table structure for table `maps_data`
--
DROP TABLE IF EXISTS `maps_data`;
CREATE TABLE `maps_data` (
`mapd_id` int(11) unsigned NOT NULL auto_increment,
`mapd_cli_id` int(11) unsigned NOT NULL default '0',
`mapd_mapr_id` tinyint(3) unsigned NOT NULL default '0',
`mapd_data` text,
PRIMARY KEY (`mapd_id`),
KEY `mapd_cli_id` (`mapd_cli_id`),
KEY `mapd_mapr_id` (`mapd_mapr_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `maps_data`
--
--
-- Table structure for table `maps_ref`
--
DROP TABLE IF EXISTS `maps_ref`;
CREATE TABLE `maps_ref` (
`mapr_id` tinyint(3) unsigned NOT NULL auto_increment,
`mapr_caption` varchar(255) default NULL,
`mapr_order` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`mapr_id`),
KEY `mapr_order` (`mapr_order`)
) TYPE=MyISAM;
--
-- Dumping data for table `maps_ref`
--
--
-- Table structure for table `off_reasons`
--
DROP TABLE IF EXISTS `off_reasons`;
CREATE TABLE `off_reasons` (
`or_id` tinyint(3) unsigned NOT NULL auto_increment,
`or_caption` varchar(255) default NULL,
PRIMARY KEY (`or_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `off_reasons`
--
--
-- Table structure for table `other_info`
--
DROP TABLE IF EXISTS `other_info`;
CREATE TABLE `other_info` (
`oi_id` smallint(5) unsigned NOT NULL auto_increment,
`oi_grp_num` smallint(3) unsigned NOT NULL default '0',
`oi_caption` varchar(255) default NULL,
`oi_desc` varchar(255) default NULL,
`oi_order` tinyint(3) unsigned NOT NULL default '0',
`oi_hide_all` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`oi_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `other_info`
--
--
-- Table structure for table `phone_types`
--
DROP TABLE IF EXISTS `phone_types`;
CREATE TABLE `phone_types` (
`phot_id` tinyint(3) unsigned NOT NULL auto_increment,
`phot_caption` varchar(255) default NULL,
`phot_order` tinyint(3) unsigned NOT NULL default '0',
`phot_inresults` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`phot_id`),
KEY `phot_order` (`phot_order`)
) TYPE=MyISAM;
--
-- Dumping data for table `phone_types`
--
--
-- Table structure for table `phones_data`
--
DROP TABLE IF EXISTS `phones_data`;
CREATE TABLE `phones_data` (
`pho_id` int(11) unsigned NOT NULL auto_increment,
`pho_phot_id` tinyint(3) unsigned NOT NULL default '0',
`pho_data` varchar(255) default NULL,
`pho_extra` varchar(255) default NULL,
`pho_cli_id` int(11) unsigned NOT NULL default '0',
`pho_isprivate` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`pho_id`),
KEY `pho_phot_id` (`pho_phot_id`),
KEY `pho_cli_id` (`pho_cli_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `phones_data`
--
--
-- Table structure for table `planes`
--
DROP TABLE IF EXISTS `planes`;
CREATE TABLE `planes` (
`pln_id` tinyint(3) unsigned NOT NULL auto_increment,
`pln_ref` varchar(255) default NULL,
`pln_caption` varchar(255) default NULL,
`pln_order` tinyint(3) unsigned NOT NULL default '0',
`pln_class_prefix` varchar(255) default NULL,
PRIMARY KEY (`pln_id`),
KEY `pln_order` (`pln_order`)
) TYPE=MyISAM;
--
-- Dumping data for table `planes`
--
INSERT INTO `planes` VALUES (1,'','Sofisticado',5,'p1');
INSERT INTO `planes` VALUES (2,'','Productos y servicios',4,'p2');
INSERT INTO `planes` VALUES (3,'','Institucional',3,'p3');
INSERT INTO `planes` VALUES (4,'','Simple',2,'p4');
INSERT INTO `planes` VALUES (5,'','Mini-Simple',1,'p5');
--
-- Table structure for table `prods_cats`
--
DROP TABLE IF EXISTS `prods_cats`;
CREATE TABLE `prods_cats` (
`pcat_id` int(11) unsigned NOT NULL auto_increment,
`pcat_caption` varchar(255) NOT NULL default '',
`pcat_order` tinyint(3) unsigned NOT NULL default '0',
`pcat_cli_id` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`pcat_id`),
KEY `pcat_cli_id` (`pcat_cli_id`),
KEY `pcat_order` (`pcat_order`)
) TYPE=MyISAM;
--
-- Dumping data for table `prods_cats`
--
--
-- Table structure for table `prods_data`
--
DROP TABLE IF EXISTS `prods_data`;
CREATE TABLE `prods_data` (
`pd_id` int(11) unsigned NOT NULL auto_increment,
`pd_title` varchar(255) default NULL,
`pd_description` text,
`pd_img_preview` varchar(255) default NULL,
`pd_img_detail` varchar(255) default NULL,
`pd_price` varchar(255) default NULL,
`pd_pcat_id` int(11) unsigned NOT NULL default '0',
`pd_cli_id` int(11) unsigned NOT NULL default '0',
`pd_isvisible` enum('Y','N') default 'Y',
`pd_order` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`pd_id`),
KEY `pd_pcat_id` (`pd_pcat_id`),
KEY `pd_cli_id` (`pd_cli_id`),
KEY `pd_order` (`pd_order`),
KEY `pd_title` (`pd_title`),
KEY `pd_description` (`pd_description`(255))
) TYPE=MyISAM;
--
-- Dumping data for table `prods_data`
--
--
-- Table structure for table `rel_cli_fdpd`
--
DROP TABLE IF EXISTS `rel_cli_fdpd`;
CREATE TABLE `rel_cli_fdpd` (
`rcf_id` int(11) unsigned NOT NULL auto_increment,
`rcf_cli_id` int(11) unsigned NOT NULL default '0',
`rcf_fdpd_id` smallint(6) unsigned NOT NULL default '0',
PRIMARY KEY (`rcf_id`),
KEY `rcr_cli_id` (`rcf_cli_id`),
KEY `rcf_fdpd_id` (`rcf_fdpd_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `rel_cli_fdpd`
--
--
-- Table structure for table `rel_cli_icn`
--
DROP TABLE IF EXISTS `rel_cli_icn`;
CREATE TABLE `rel_cli_icn` (
`rci_id` int(11) unsigned NOT NULL auto_increment,
`rci_cli_id` int(11) unsigned NOT NULL default '0',
`rci_icn_id` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rci_id`),
KEY `rci_cli_id` (`rci_cli_id`),
KEY `rci_icn_id` (`rci_icn_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `rel_cli_icn`
--
--
-- Table structure for table `rel_cli_oi`
--
DROP TABLE IF EXISTS `rel_cli_oi`;
CREATE TABLE `rel_cli_oi` (
`rco_cli_id` int(11) unsigned NOT NULL default '0',
`rco_oi_id` smallint(5) unsigned NOT NULL default '0',
KEY `rco_cli_id` (`rco_cli_id`),
KEY `rco_oi_id` (`rco_oi_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `rel_cli_oi`
--
--
-- Table structure for table `rel_cli_rubs`
--
DROP TABLE IF EXISTS `rel_cli_rubs`;
CREATE TABLE `rel_cli_rubs` (
`rcr_id` int(11) unsigned NOT NULL auto_increment,
`rcr_cli_id` int(11) unsigned NOT NULL default '0',
`rcr_rubs_id` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rcr_id`),
KEY `rcr_cli_id` (`rcr_cli_id`),
KEY `rcr_rubs_id` (`rcr_rubs_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `rel_cli_rubs`
--
--
-- Table structure for table `rubros_p`
--
DROP TABLE IF EXISTS `rubros_p`;
CREATE TABLE `rubros_p` (
`rubp_id` tinyint(3) unsigned NOT NULL auto_increment,
`rubp_caption` varchar(255) NOT NULL default '',
`rubp_img` varchar(255) default NULL,
`rubp_isvisible` enum('Y','N') NOT NULL default 'Y',
`rubp_order` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rubp_id`),
KEY `rubp_order` (`rubp_order`)
) TYPE=MyISAM;
--
-- Dumping data for table `rubros_p`
--
INSERT INTO `rubros_p` VALUES (1,'Bazar, Regalos y Artesanías','','Y',1);
INSERT INTO `rubros_p` VALUES (2,'Bebes y Niños','','Y',2);
INSERT INTO `rubros_p` VALUES (3,'Belleza y Estética','','Y',3);
INSERT INTO `rubros_p` VALUES (4,'Gastronomía','','Y',4);
INSERT INTO `rubros_p` VALUES (5,'Decoración y Antiguedades','','Y',5);
INSERT INTO `rubros_p` VALUES (6,'Electrónica','','Y',6);
INSERT INTO `rubros_p` VALUES (7,'Cueros y Marroquinería','','Y',7);
INSERT INTO `rubros_p` VALUES (8,'Servicios','','Y',8);
INSERT INTO `rubros_p` VALUES (9,'Flores','','Y',9);
INSERT INTO `rubros_p` VALUES (10,'Bijouterie','','Y',10);
INSERT INTO `rubros_p` VALUES (11,'Leceria y Mercería','','Y',11);
INSERT INTO `rubros_p` VALUES (12,'Librerías','','Y',12);
INSERT INTO `rubros_p` VALUES (13,'Opticas y Fotografia','','Y',13);
INSERT INTO `rubros_p` VALUES (14,'Indumentaria','','Y',14);
INSERT INTO `rubros_p` VALUES (15,'Farmacias y Veteriarias','','Y',15);
INSERT INTO `rubros_p` VALUES (16,'Zapatos y Carteras','','Y',16);
INSERT INTO `rubros_p` VALUES (17,'Deportes','','Y',17);
INSERT INTO `rubros_p` VALUES (18,'Inmuebles','','Y',18);
INSERT INTO `rubros_p` VALUES (19,'Entretenimiento y Recreación','','Y',19);
INSERT INTO `rubros_p` VALUES (20,'Educación','','Y',20);
INSERT INTO `rubros_p` VALUES (21,'Galerías','','Y',21);
INSERT INTO `rubros_p` VALUES (22,'Hoteles','','Y',22);
INSERT INTO `rubros_p` VALUES (23,'Bancos','','Y',23);
INSERT INTO `rubros_p` VALUES (24,'Estacionamientos','','Y',24);
INSERT INTO `rubros_p` VALUES (25,'Turismo','','Y',25);
INSERT INTO `rubros_p` VALUES (26,'Salud','','Y',26);
--
-- Table structure for table `rubros_s`
--
DROP TABLE IF EXISTS `rubros_s`;
CREATE TABLE `rubros_s` (
`rubs_id` tinyint(3) unsigned NOT NULL auto_increment,
`rubs_caption` varchar(255) NOT NULL default '',
`rubs_isvisible` enum('Y','N') NOT NULL default 'Y',
`rubs_rubp_id` tinyint(3) unsigned NOT NULL default '0',
`rubs_order` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rubs_id`),
KEY `rubs_order` (`rubs_order`),
KEY `rubs_rubp_id` (`rubs_rubp_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `rubros_s`
--
INSERT INTO `rubros_s` VALUES (1,'Artesanías','Y',1,1);
INSERT INTO `rubros_s` VALUES (2,'Regalos','Y',1,2);
INSERT INTO `rubros_s` VALUES (74,'Bazar','Y',1,3);
INSERT INTO `rubros_s` VALUES (82,'Souvenirs','Y',1,4);
INSERT INTO `rubros_s` VALUES (3,'Bebes y niños','Y',2,1);
INSERT INTO `rubros_s` VALUES (76,'Juguetería','Y',2,2);
INSERT INTO `rubros_s` VALUES (4,'Solarium','Y',3,1);
INSERT INTO `rubros_s` VALUES (5,'Peluquerías','Y',3,2);
INSERT INTO `rubros_s` VALUES (71,'Spa','Y',3,3);
INSERT INTO `rubros_s` VALUES (73,'Ortopedia, Pedicuría y Podología','Y',3,4);
INSERT INTO `rubros_s` VALUES (6,'Comida','Y',4,1);
INSERT INTO `rubros_s` VALUES (7,'Dietética','Y',4,2);
INSERT INTO `rubros_s` VALUES (8,'Bares','Y',4,3);
INSERT INTO `rubros_s` VALUES (9,'Cafés','Y',4,4);
INSERT INTO `rubros_s` VALUES (10,'Restaurant','Y',4,5);
INSERT INTO `rubros_s` VALUES (11,'Heladería','Y',4,6);
INSERT INTO `rubros_s` VALUES (12,'Confitería','Y',4,7);
INSERT INTO `rubros_s` VALUES (75,'Kiosco','Y',4,8);
INSERT INTO `rubros_s` VALUES (13,'Antiguedades','Y',5,1);
INSERT INTO `rubros_s` VALUES (14,'Muebles','Y',5,2);
INSERT INTO `rubros_s` VALUES (15,'Iluminación','Y',5,3);
INSERT INTO `rubros_s` VALUES (16,'Decoración','Y',5,4);
INSERT INTO `rubros_s` VALUES (17,'Baño y Cocina','Y',5,5);
INSERT INTO `rubros_s` VALUES (18,'Telas y Cortinados','Y',5,6);
INSERT INTO `rubros_s` VALUES (19,'Velas y Aromas','Y',5,7);
INSERT INTO `rubros_s` VALUES (20,'Vidrios','Y',5,8);
INSERT INTO `rubros_s` VALUES (21,'Pinturería','Y',5,9);
INSERT INTO `rubros_s` VALUES (72,'Diseño','Y',5,10);
INSERT INTO `rubros_s` VALUES (22,'Computación','Y',6,1);
INSERT INTO `rubros_s` VALUES (23,'Telefonía','Y',6,2);
INSERT INTO `rubros_s` VALUES (24,'Cyber','Y',6,3);
INSERT INTO `rubros_s` VALUES (25,'Música','Y',6,4);
INSERT INTO `rubros_s` VALUES (26,'Videos','Y',6,5);
INSERT INTO `rubros_s` VALUES (27,'Cueros y Marroquinería','Y',7,1);
INSERT INTO `rubros_s` VALUES (28,'Ferretería','Y',8,1);
INSERT INTO `rubros_s` VALUES (29,'Electricidad','Y',8,2);
INSERT INTO `rubros_s` VALUES (30,'Cerrajería','Y',8,3);
INSERT INTO `rubros_s` VALUES (31,'Lavandería','Y',8,4);
INSERT INTO `rubros_s` VALUES (32,'Modista','Y',8,5);
INSERT INTO `rubros_s` VALUES (33,'Tintorería','Y',8,6);
INSERT INTO `rubros_s` VALUES (34,'Restauraciones','Y',8,7);
INSERT INTO `rubros_s` VALUES (35,'Santería','Y',8,8);
INSERT INTO `rubros_s` VALUES (36,'Reparaciones','Y',8,9);
INSERT INTO `rubros_s` VALUES (37,'Flores','Y',9,1);
INSERT INTO `rubros_s` VALUES (38,'Joyería','Y',10,1);
INSERT INTO `rubros_s` VALUES (39,'Relojería','Y',10,2);
INSERT INTO `rubros_s` VALUES (40,'Bijouterie','Y',10,3);
INSERT INTO `rubros_s` VALUES (41,'Accesorios','Y',10,4);
INSERT INTO `rubros_s` VALUES (42,'Boutique','Y',10,5);
INSERT INTO `rubros_s` VALUES (43,'Lencería','Y',11,1);
INSERT INTO `rubros_s` VALUES (44,'Mercería','Y',11,2);
INSERT INTO `rubros_s` VALUES (45,'Librerías','Y',12,1);
INSERT INTO `rubros_s` VALUES (46,'Óptica','Y',13,1);
INSERT INTO `rubros_s` VALUES (47,'Fotografía','Y',13,2);
INSERT INTO `rubros_s` VALUES (48,'Femenina','Y',14,1);
INSERT INTO `rubros_s` VALUES (49,'Masculina','Y',14,2);
INSERT INTO `rubros_s` VALUES (50,'Femenina y Masculina','Y',14,3);
INSERT INTO `rubros_s` VALUES (51,'Deportiva','Y',14,4);
INSERT INTO `rubros_s` VALUES (52,'Mallas y Bikinis','Y',14,5);
INSERT INTO `rubros_s` VALUES (53,'Uniformes escolares','Y',14,6);
INSERT INTO `rubros_s` VALUES (54,'Futura mamá','Y',14,7);
INSERT INTO `rubros_s` VALUES (55,'Indumentaria Bebés','Y',14,8);
INSERT INTO `rubros_s` VALUES (80,'De vestir masculina','Y',14,9);
INSERT INTO `rubros_s` VALUES (81,'De vestir femenina','Y',14,10);
INSERT INTO `rubros_s` VALUES (83,'Sweaters','Y',14,11);
INSERT INTO `rubros_s` VALUES (84,'Pieles','Y',14,12);
INSERT INTO `rubros_s` VALUES (85,'Cueros','Y',14,13);
INSERT INTO `rubros_s` VALUES (56,'Farmacia','Y',15,1);
INSERT INTO `rubros_s` VALUES (57,'Veterinaria','Y',15,2);
INSERT INTO `rubros_s` VALUES (58,'Perfumería','Y',15,3);
INSERT INTO `rubros_s` VALUES (59,'Zapatos','Y',16,1);
INSERT INTO `rubros_s` VALUES (60,'Carteras','Y',16,2);
INSERT INTO `rubros_s` VALUES (61,'Gimansio','Y',17,1);
INSERT INTO `rubros_s` VALUES (62,'Inmuebles','Y',18,1);
INSERT INTO `rubros_s` VALUES (63,'Entretenimiento y Recreación','Y',19,1);
INSERT INTO `rubros_s` VALUES (77,'Juguetería','Y',19,2);
INSERT INTO `rubros_s` VALUES (78,'Música','Y',19,3);
INSERT INTO `rubros_s` VALUES (79,'Videos','Y',19,4);
INSERT INTO `rubros_s` VALUES (64,'Educación','Y',20,1);
INSERT INTO `rubros_s` VALUES (65,'Galerías','Y',21,1);
INSERT INTO `rubros_s` VALUES (66,'Hoteles','Y',22,1);
INSERT INTO `rubros_s` VALUES (67,'Bancos','Y',23,1);
INSERT INTO `rubros_s` VALUES (68,'Estacionamientos','Y',24,1);
INSERT INTO `rubros_s` VALUES (69,'Turismo','Y',25,1);
INSERT INTO `rubros_s` VALUES (70,'Salud','Y',26,1);
--
-- Table structure for table `tasks`
--
DROP TABLE IF EXISTS `tasks`;
CREATE TABLE `tasks` (
`tsk_id` int(11) unsigned NOT NULL auto_increment,
`tsk_cli_id` int(11) unsigned NOT NULL default '0',
`tsk_caption` varchar(255) default NULL,
`tsk_created_on` date default NULL,
`tsk_created_by` smallint(5) unsigned NOT NULL default '0',
`tsk_isdone` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`tsk_id`),
KEY `tsk_cli_id` (`tsk_cli_id`),
KEY `tsk_crated_by` (`tsk_created_by`)
) TYPE=MyISAM;
--
-- Dumping data for table `tasks`
--
--
-- Table structure for table `urls`
--
DROP TABLE IF EXISTS `urls`;
CREATE TABLE `urls` (
`url_id` int(11) unsigned NOT NULL auto_increment,
`url_data` varchar(255) default NULL,
`url_cli_id` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`url_id`),
KEY `url_cli_id` (`url_cli_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `urls`
--
--
-- Table structure for table `usr_sys`
--
DROP TABLE IF EXISTS `usr_sys`;
CREATE TABLE `usr_sys` (
`usrs_id` smallint(5) unsigned NOT NULL auto_increment,
`usrs_username` varchar(255) default NULL,
`usrs_pass` varchar(255) default NULL,
`usrs_alias` varchar(255) default NULL,
`usrs_usrt_id` tinyint(3) unsigned NOT NULL default '0',
`usrs_email` varchar(255) default NULL,
`usrs_isactive` enum('Y','N') NOT NULL default 'Y',
PRIMARY KEY (`usrs_id`),
KEY `usrs_usrt_id` (`usrs_usrt_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `usr_sys`
--
INSERT INTO `usr_sys` VALUES (6,'jmouriz','','Juan Manuel Mouriz',0,'jmouriz gmail com','Y');
INSERT INTO `usr_sys` VALUES (7,'guest','','Usuario invitado',0,'','Y');
--
-- Table structure for table `usr_types`
--
DROP TABLE IF EXISTS `usr_types`;
CREATE TABLE `usr_types` (
`usrt_id` smallint(5) unsigned NOT NULL auto_increment,
`usrt_caption` varchar(255) default NULL,
`usrt_level` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`usrt_id`)
) TYPE=MyISAM;
--
-- Dumping data for table `usr_types`
--
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
