1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| CREATE TABLE `CB` (
`id_cb` int(5) NOT NULL,
`titulaire` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
`num` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`date_expiration` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`type_cb` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id_cb`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `COMPTE` (
`id_compte` int(5) NOT NULL,
`banque_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`num` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`type_compte` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
PRIMARY KEY (`id_compte`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `LICENCE` (
`id_licence` int(5) NOT NULL,
`application` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`version` varchar(15) CHARACTER SET utf8 DEFAULT NULL,
`description` text CHARACTER SET utf8,
`societe` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
`num` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`clef` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`date_achat` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
`nom` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`email` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
`notes` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id_licence`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `SECRET` (
`id_secret` int(5) NOT NULL AUTO_INCREMENT,
`titre` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id_secret`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=65 ;
CREATE TABLE `SITE` (
`id_site` int(5) NOT NULL,
`utilisateur` varchar(35) CHARACTER SET utf8 DEFAULT NULL,
`password` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id_site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
Partager