Skip to content

Instantly share code, notes, and snippets.

@pentium10

pentium10/table schema for all articles.sql

Created March 21, 2011 08:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pentium10/879172 to your computer and use it in GitHub Desktop.
Save pentium10/879172 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
table schema for all articles.sql
CREATE TABLE `licitatii_ue` (
`licitatii_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`nume` varchar(255) NOT NULL,
`tip_licitatie` int(1) DEFAULT NULL,
`surse_ue_id` int(11) NOT NULL,
`data_publicarii` int(11) DEFAULT NULL,
`data_limita` int(11) DEFAULT NULL,
`nr_ue` int(11) DEFAULT NULL,
`descriere` text,
`tara_id` int(10) unsigned DEFAULT NULL,
`creat` int(11) DEFAULT NULL,
`modificat` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT '0',
`status` int(1) DEFAULT '0',
PRIMARY KEY (`licitatii_id`),
UNIQUE KEY `nr_ue` (`nr_ue`),
KEY `nume` (`nume`),
KEY `tip_licitatie` (`tip_licitatie`),
KEY `surse_ue_id` (`surse_ue_id`),
KEY `data_publicarii` (`data_publicarii`),
KEY `tara_id` (`tara_id`),
KEY `creat` (`creat`),
KEY `data_limita` (`data_limita`),
FULLTEXT KEY `nume_fulltext` (`nume`,`descriere`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=335191 ;
+---------------+-------------+------------------+---------------+------------------+------------+--------------+-----------+---------+-------+-------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+---------------+-------------+------------------+---------------+------------------+------------+--------------+-----------+---------+-------+-------------+---------+
| licitatii_ue | 0 | PRIMARY | 1 | licitatii_id | A | 335190 | NULL | NULL | | BTREE | |
| licitatii_ue | 0 | nr_ue | 1 | nr_ue | A | 335190 | NULL | NULL | YES | BTREE | |
| licitatii_ue | 1 | nume | 1 | nume | A | 111730 | NULL | NULL | | BTREE | |
| licitatii_ue | 1 | tip_licitatie | 1 | tip_licitatie | A | 21 | NULL | NULL | YES | BTREE | |
| licitatii_ue | 1 | surse_ue_id | 1 | surse_ue_id | A | 1 | NULL | NULL | | BTREE | |
| licitatii_ue | 1 | data_publicarii | 1 | data_publicarii | A | 448 | NULL | NULL | YES | BTREE | |
| licitatii_ue | 1 | tara_id | 1 | tara_id | A | 41 | NULL | NULL | YES | BTREE | |
| licitatii_ue | 1 | creat | 1 | creat | A | 335190 | NULL | NULL | YES | BTREE | |
| licitatii_ue | 1 | data_limita | 1 | data_limita | A | 5078 | NULL | NULL | YES | BTREE | |
| licitatii_ue | 1 | nume_fulltext | 1 | nume | NULL | 335190 | NULL | NULL | | FULLTEXT | |
| licitatii_ue | 1 | nume_fulltext | 2 | descriere | NULL | 335190 | NULL | NULL | YES | FULLTEXT | |
+---------------+-------------+------------------+---------------+------------------+------------+--------------+-----------+---------+-------+-------------+---------+
CREATE TABLE `domenii` (
`domenii_id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0',
`nume` varchar(255) DEFAULT NULL,
`descriere` text NOT NULL,
`tip_domeniu` int(11) NOT NULL,
`pret1` float NOT NULL DEFAULT '0',
`pret2` float NOT NULL DEFAULT '0',
`pret3` float NOT NULL DEFAULT '0',
`creat` int(11) DEFAULT NULL,
`modificat` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`status` int(1) DEFAULT NULL,
PRIMARY KEY (`domenii_id`),
KEY `key_status_tip_domeniu` (`status`,`tip_domeniu`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=119 ;
+----------+-------------+-------------------------+---------------+--------------+------------+--------------+-----------+---------+-------+-------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+----------+-------------+-------------------------+---------------+--------------+------------+--------------+-----------+---------+-------+-------------+---------+
| domenii | 0 | PRIMARY | 1 | domenii_id | A | 120 | NULL | NULL | | BTREE | |
| domenii | 1 | key_status_tip_domeniu | 1 | status | A | 2 | NULL | NULL | YES | BTREE | |
| domenii | 1 | key_status_tip_domeniu | 2 | tip_domeniu | A | 5 | NULL | NULL | | BTREE | |
+----------+-------------+-------------------------+---------------+--------------+------------+--------------+-----------+---------+-------+-------------+---------+
CREATE TABLE `domenii_licitatii` (
`domenii_id` int(11) NOT NULL DEFAULT '0',
`licitatii_id` int(11) NOT NULL DEFAULT '0',
`tip_licitatie` tinyint(1) unsigned NOT NULL,
PRIMARY KEY (`domenii_id`,`licitatii_id`,`tip_licitatie`),
KEY `tip_licitatie` (`tip_licitatie`),
KEY `licitatii_id` (`licitatii_id`,`tip_licitatie`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+--------------------+-------------+----------------+---------------+----------------+------------+--------------+-----------+---------+-------+-------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------------------+-------------+----------------+---------------+----------------+------------+--------------+-----------+---------+-------+-------------+---------+
| domenii_licitatii | 0 | PRIMARY | 1 | domenii_id | A | 90 | NULL | NULL | | BTREE | |
| domenii_licitatii | 0 | PRIMARY | 2 | licitatii_id | A | 618125 | NULL | NULL | | BTREE | |
| domenii_licitatii | 0 | PRIMARY | 3 | tip_licitatie | A | 618125 | NULL | NULL | | BTREE | |
| domenii_licitatii | 1 | tip_licitatie | 1 | tip_licitatie | A | 2 | NULL | NULL | | BTREE | |
| domenii_licitatii | 1 | licitatii_id | 1 | licitatii_id | A | 309062 | NULL | NULL | | BTREE | |
| domenii_licitatii | 1 | licitatii_id | 2 | tip_licitatie | A | 618125 | NULL | NULL | | BTREE | |
+--------------------+-------------+----------------+---------------+----------------+------------+--------------+-----------+---------+-------+-------------+---------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment