
#DROP TABLE IF EXISTS T_tank_list;
#CREATE TABLE `T_tank_list` 
#(
#	`id` 					int(10) 				unsigned NOT NULL AUTO_INCREMENT,
#	`serial` 			int(10) 				unsigned NOT NULL,
#	`type` 				int(11) 				NOT NULL,
#	`capacite` 		int(11) 				NOT NULL,
#	`hauteur` 		float 					NOT NULL,
#	`produit` 			int(11) 				DEFAULT NULL,
#	`localisation`	tinytext 				DEFAULT NULL,
#	`rem_max` 		float 					DEFAULT NULL,
#	`min_alarm` 	float 					DEFAULT NULL,
#	`min_hors` 		varchar(45) 		DEFAULT NULL,
#	PRIMARY KEY (`id`),
#	UNIQUE KEY `id_UNIQUE` (`id`),
#	UNIQUE KEY `serial_UNIQUE` (`serial`)
#);
class T_tank_list:
	create_clause = (
		"CREATE TABLE `T_tank_list`"
		"("
			"`id` 						int(10) 			unsigned NOT NULL AUTO_INCREMENT,"
			"`serial` 				int(10) 			unsigned NOT NULL,"
			"`type` 					int(11) 			NOT NULL,"
			"`capacite` 			int(11) 			NOT NULL,"
			"`hauteur` 			float 				NOT NULL,"
			"`produit` 			int(11) 			DEFAULT NULL,"
			"`localisation`	tinytext 		DEFAULT NULL,"
			"`rem_max` 			float 				DEFAULT NULL,"
			"`min_alarm` 		float 				DEFAULT NULL,"
			"`min_hors` 			varchar(45)	DEFAULT NULL,"
			"PRIMARY KEY (`id`),"
			"UNIQUE KEY `id_UNIQUE` (`id`),"
			"UNIQUE KEY `serial_UNIQUE` (`serial`)"
		");"
	)
	def __init__(self, theCon):
		self.con	= theCon
	None

#DROP TABLE IF EXISTS `T_produits`
#CREATE TABLE `T_produits` 
#(
#	`id` 					INT 						UNSIGNED NOT NULL AUTO_INCREMENT,
#	`id_produits` 	INT 						NOT NULL,
#	`langue` 			VARCHAR(5) 		NOT NULL,
#	`desciption`		VARCHAR(45) 	NOT NULL,
#	PRIMARY KEY (`id`),
#	UNIQUE INDEX `id_UNIQUE` (`id` ASC) 
#);

class T_produits:
	create_clause = (
		"CREATE TABLE `T_produits`", 
		"(", 
			"`id` 					INT 				UNSIGNED NOT NULL AUTO_INCREMENT,", 
			"`id_produits` INT 				NOT NULL,", 
			"`langue` 			VARCHAR(5) 	NOT NULL,", 
			"`desciption`	VARCHAR(45) 	NOT NULL,", 
			"PRIMARY KEY (`id`),", 
			"UNIQUE INDEX `id_UNIQUE` (`id` ASC)", 
		");"
		)
	def __init__(self, theCon):
		self.con	= theCon
	None

a00b36f277a34f9178c6996ec2b5827b6fc1a52f
<mask token>


class T_produits:
    create_clause = ('CREATE TABLE `T_produits`', '(',
        '`id` \t\t\t\t\tINT \t\t\t\tUNSIGNED NOT NULL AUTO_INCREMENT,',
        '`id_produits` INT \t\t\t\tNOT NULL,',
        '`langue` \t\t\tVARCHAR(5) \tNOT NULL,',
        '`desciption`\tVARCHAR(45) \tNOT NULL,', 'PRIMARY KEY (`id`),',
        'UNIQUE INDEX `id_UNIQUE` (`id` ASC)', ');')

    def __init__(self, theCon):
        self.con = theCon
    None

class T_tank_list:
    <mask token>
    <mask token>
    None


class T_produits:
    create_clause = ('CREATE TABLE `T_produits`', '(',
        '`id` \t\t\t\t\tINT \t\t\t\tUNSIGNED NOT NULL AUTO_INCREMENT,',
        '`id_produits` INT \t\t\t\tNOT NULL,',
        '`langue` \t\t\tVARCHAR(5) \tNOT NULL,',
        '`desciption`\tVARCHAR(45) \tNOT NULL,', 'PRIMARY KEY (`id`),',
        'UNIQUE INDEX `id_UNIQUE` (`id` ASC)', ');')

    def __init__(self, theCon):
        self.con = theCon
    None

class T_tank_list:
    <mask token>

    def __init__(self, theCon):
        self.con = theCon
    None


class T_produits:
    create_clause = ('CREATE TABLE `T_produits`', '(',
        '`id` \t\t\t\t\tINT \t\t\t\tUNSIGNED NOT NULL AUTO_INCREMENT,',
        '`id_produits` INT \t\t\t\tNOT NULL,',
        '`langue` \t\t\tVARCHAR(5) \tNOT NULL,',
        '`desciption`\tVARCHAR(45) \tNOT NULL,', 'PRIMARY KEY (`id`),',
        'UNIQUE INDEX `id_UNIQUE` (`id` ASC)', ');')

    def __init__(self, theCon):
        self.con = theCon
    None

class T_tank_list:
    create_clause = (
        'CREATE TABLE `T_tank_list`(`id` \t\t\t\t\t\tint(10) \t\t\tunsigned NOT NULL AUTO_INCREMENT,`serial` \t\t\t\tint(10) \t\t\tunsigned NOT NULL,`type` \t\t\t\t\tint(11) \t\t\tNOT NULL,`capacite` \t\t\tint(11) \t\t\tNOT NULL,`hauteur` \t\t\tfloat \t\t\t\tNOT NULL,`produit` \t\t\tint(11) \t\t\tDEFAULT NULL,`localisation`\ttinytext \t\tDEFAULT NULL,`rem_max` \t\t\tfloat \t\t\t\tDEFAULT NULL,`min_alarm` \t\tfloat \t\t\t\tDEFAULT NULL,`min_hors` \t\t\tvarchar(45)\tDEFAULT NULL,PRIMARY KEY (`id`),UNIQUE KEY `id_UNIQUE` (`id`),UNIQUE KEY `serial_UNIQUE` (`serial`));'
        )

    def __init__(self, theCon):
        self.con = theCon
    None


class T_produits:
    create_clause = ('CREATE TABLE `T_produits`', '(',
        '`id` \t\t\t\t\tINT \t\t\t\tUNSIGNED NOT NULL AUTO_INCREMENT,',
        '`id_produits` INT \t\t\t\tNOT NULL,',
        '`langue` \t\t\tVARCHAR(5) \tNOT NULL,',
        '`desciption`\tVARCHAR(45) \tNOT NULL,', 'PRIMARY KEY (`id`),',
        'UNIQUE INDEX `id_UNIQUE` (`id` ASC)', ');')

    def __init__(self, theCon):
        self.con = theCon
    None


#DROP TABLE IF EXISTS T_tank_list;
#CREATE TABLE `T_tank_list` 
#(
#	`id` 					int(10) 				unsigned NOT NULL AUTO_INCREMENT,
#	`serial` 			int(10) 				unsigned NOT NULL,
#	`type` 				int(11) 				NOT NULL,
#	`capacite` 		int(11) 				NOT NULL,
#	`hauteur` 		float 					NOT NULL,
#	`produit` 			int(11) 				DEFAULT NULL,
#	`localisation`	tinytext 				DEFAULT NULL,
#	`rem_max` 		float 					DEFAULT NULL,
#	`min_alarm` 	float 					DEFAULT NULL,
#	`min_hors` 		varchar(45) 		DEFAULT NULL,
#	PRIMARY KEY (`id`),
#	UNIQUE KEY `id_UNIQUE` (`id`),
#	UNIQUE KEY `serial_UNIQUE` (`serial`)
#);
class T_tank_list:
	create_clause = (
		"CREATE TABLE `T_tank_list`"
		"("
			"`id` 						int(10) 			unsigned NOT NULL AUTO_INCREMENT,"
			"`serial` 				int(10) 			unsigned NOT NULL,"
			"`type` 					int(11) 			NOT NULL,"
			"`capacite` 			int(11) 			NOT NULL,"
			"`hauteur` 			float 				NOT NULL,"
			"`produit` 			int(11) 			DEFAULT NULL,"
			"`localisation`	tinytext 		DEFAULT NULL,"
			"`rem_max` 			float 				DEFAULT NULL,"
			"`min_alarm` 		float 				DEFAULT NULL,"
			"`min_hors` 			varchar(45)	DEFAULT NULL,"
			"PRIMARY KEY (`id`),"
			"UNIQUE KEY `id_UNIQUE` (`id`),"
			"UNIQUE KEY `serial_UNIQUE` (`serial`)"
		");"
	)
	def __init__(self, theCon):
		self.con	= theCon
	None

#DROP TABLE IF EXISTS `T_produits`
#CREATE TABLE `T_produits` 
#(
#	`id` 					INT 						UNSIGNED NOT NULL AUTO_INCREMENT,
#	`id_produits` 	INT 						NOT NULL,
#	`langue` 			VARCHAR(5) 		NOT NULL,
#	`desciption`		VARCHAR(45) 	NOT NULL,
#	PRIMARY KEY (`id`),
#	UNIQUE INDEX `id_UNIQUE` (`id` ASC) 
#);

class T_produits:
	create_clause = (
		"CREATE TABLE `T_produits`", 
		"(", 
			"`id` 					INT 				UNSIGNED NOT NULL AUTO_INCREMENT,", 
			"`id_produits` INT 				NOT NULL,", 
			"`langue` 			VARCHAR(5) 	NOT NULL,", 
			"`desciption`	VARCHAR(45) 	NOT NULL,", 
			"PRIMARY KEY (`id`),", 
			"UNIQUE INDEX `id_UNIQUE` (`id` ASC)", 
		");"
		)
	def __init__(self, theCon):
		self.con	= theCon
	None
