#ifndef NSQL_H
	#include <nsql.h>
#endif
class C_user: public NSQL_RECORD{
public:
	NSQL_FIELD user_id;
	NSQL_FIELD id;
	NSQL_FIELD pass;
	NSQL_FIELD nom;
	NSQL_FIELD prenom;
	NSQL_FIELD ville;
	NSQL_FIELD etat;
	NSQL_FIELD pays;
	NSQL_FIELD courriel;
	NSQL_FIELD wallet_in;
	NSQL_FIELD wallet_out;
	NSQL_FIELD date_create;
	NSQL_FIELD date_modif;
	C_user()
	:
		user_id("user_id"),
		id("id"),
		pass("pass"),
		nom("nom"),
		prenom("prenom"),
		ville("ville"),
		etat("etat"),
		pays("pays"),
		courriel("courriel"),
		wallet_in("wallet_in"),
		wallet_out("wallet_out"),
		date_create("date_create"),
		date_modif("date_modif")
	{
		tb[0] = &user_id;
		tb[1] = &id;
		tb[2] = &pass;
		tb[3] = &nom;
		tb[4] = &prenom;
		tb[5] = &ville;
		tb[6] = &etat;
		tb[7] = &pays;
		tb[8] = &courriel;
		tb[9] = &wallet_in;
		tb[10] = &wallet_out;
		tb[11] = &date_create;
		tb[12] = &date_modif;
		nbfield=13;
		primkey=0;
	}
};
class C_comment: public NSQL_RECORD{
public:
	NSQL_FIELD comment_id;
	NSQL_FIELD user_id;
	NSQL_FIELD piece_id;
	NSQL_FIELD parent;
	NSQL_FIELD display_order;
	NSQL_FIELD date_create;
	NSQL_FIELD texte;
	C_comment()
	:
		comment_id("comment_id"),
		user_id("user_id"),
		piece_id("piece_id"),
		parent("parent"),
		display_order("display_order"),
		date_create("date_create"),
		texte("texte")
	{
		tb[0] = &comment_id;
		tb[1] = &user_id;
		tb[2] = &piece_id;
		tb[3] = &parent;
		tb[4] = &display_order;
		tb[5] = &date_create;
		tb[6] = &texte;
		nbfield=7;
		primkey=0;
	}
};
class C_piece: public NSQL_RECORD{
public:
	NSQL_FIELD piece_id;
	NSQL_FIELD user_id;
	NSQL_FIELD titre;
	NSQL_FIELD description;
	NSQL_FIELD md5sum;
	NSQL_FIELD cost;
	NSQL_FIELD date_create;
	C_piece()
	:
		piece_id("piece_id"),
		user_id("user_id"),
		titre("titre"),
		description("description"),
		md5sum("md5sum"),
		cost("cost"),
		date_create("date_create")
	{
		tb[0] = &piece_id;
		tb[1] = &user_id;
		tb[2] = &titre;
		tb[3] = &description;
		tb[4] = &md5sum;
		tb[5] = &cost;
		tb[6] = &date_create;
		nbfield=7;
		primkey=0;
	}
};
class C_achat: public NSQL_RECORD{
public:
	NSQL_FIELD user_id;
	NSQL_FIELD piece_id;
	NSQL_FIELD transaction;
	NSQL_FIELD date;
	C_achat()
	:
		user_id("user_id"),
		piece_id("piece_id"),
		transaction("transaction"),
		date("date")
	{
		tb[0] = &user_id;
		tb[1] = &piece_id;
		tb[2] = &transaction;
		tb[3] = &date;
		nbfield=4;
		primkey=-1;
	}
};
class C_piece_rating: public NSQL_RECORD{
public:
	NSQL_FIELD user_id;
	NSQL_FIELD piece_id;
	NSQL_FIELD drole;
	NSQL_FIELD interessant;
	NSQL_FIELD style;
	C_piece_rating()
	:
		user_id("user_id"),
		piece_id("piece_id"),
		drole("drole"),
		interessant("interessant"),
		style("style")
	{
		tb[0] = &user_id;
		tb[1] = &piece_id;
		tb[2] = &drole;
		tb[3] = &interessant;
		tb[4] = &style;
		nbfield=5;
		primkey=-1;
	}
};
class C_comment_rating: public NSQL_RECORD{
public:
	NSQL_FIELD user_id;
	NSQL_FIELD comment_id;
	NSQL_FIELD drole;
	NSQL_FIELD interessant;
	C_comment_rating()
	:
		user_id("user_id"),
		comment_id("comment_id"),
		drole("drole"),
		interessant("interessant")
	{
		tb[0] = &user_id;
		tb[1] = &comment_id;
		tb[2] = &drole;
		tb[3] = &interessant;
		nbfield=4;
		primkey=-1;
	}
};