n/oldblog
Archived
1
0
Fork 0
This repository has been archived on 2024-02-13. You can view files and clone it, but cannot push or open issues or pull requests.
oldblog/liens/doc/sql.txt

38 lines
1,010 B
Text
Raw Permalink Normal View History

2023-04-30 21:28:42 +02:00
# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Serveur: localhost Base de donn<6E>es: annuaire
# --------------------------------------------------------
#
# Structure de la table 'annuaire_cat'
#
CREATE TABLE annuaire_cat (
id int(11) NOT NULL auto_increment,
nomcat varchar(100) NOT NULL,
idsubcat tinyint(4) DEFAULT '0' NOT NULL,
prio tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
# --------------------------------------------------------
#
# Structure de la table 'annuaire_sites'
#
CREATE TABLE annuaire_sites (
id int(11) NOT NULL auto_increment,
nomsite varchar(100) NOT NULL,
url varchar(50) NOT NULL,
description varchar(255) NOT NULL,
mcles text NOT NULL,
email varchar(100) NOT NULL,
date date DEFAULT '0000-00-00' NOT NULL,
cat1 int(11) DEFAULT '0' NOT NULL,
cat2 int(11) DEFAULT '0' NOT NULL,
cat3 int(11) DEFAULT '0' NOT NULL,
valid char(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);