WebSVN – general – Blame – /kickup/trunk/sql/00.tables.sql/

Rev	Author	Line No.	Line
3	dev	1	--
		2	-- it-ru sql tables
		3	--
		4
		5	create sequence hibernate_sequence;
		6
9	dev	7	/* removed in this version
3	dev	8	create table participants
		9	(
		10	id integer not null,
		11	nick varchar(255) not null,
		12	email varchar(255) not null,
		13	name varchar(255),
		14	phone varchar(255),
		15	comment text,
		16	mod_stamp timestamp,
		17
		18	constraint participants_prim primary key (id),
		19	constraint participants_email unique(email)
		20	);
9	dev	21	*/
3	dev	22
		23	create table events
		24	(
		25	id integer not null,
		26	name varchar(255) not null,
		27	place varchar(255),
		28	address text,
		29	transport_desc text,
		30	start date,
		31	stop date,
		32	last_register date,
		33	last_unregister date,
		34	price decimal,
		35	money_account text,
		36	enabled char(1) default '1',
		37	comment text,
		38	mod_stamp timestamp,
		39
		40	constraint events_prim primary key (id),
		41	constraint events_name unique(name)
		42	);
		43
		44	create table event_files
		45	(
		46	id integer not null,
		47	event integer not null,
		48	name varchar(255) not null,
		49	data file,
		50	type char(1),
		51	comment text,
		52	mod_stamp timestamp,
		53
		54	constraint event_files_prim primary key (id)
		55	);
		56
		57	create table apartments
		58	(
		59	id integer not null,
		60	name varchar(255) not null,
		61	address text,
		62	price decimal,
		63	url varchar(4000),
		64	comment text,
		65	mod_stamp timestamp,
		66
		67	constraint apartments_prim primary key (id)
		68	);
		69
		70	create table event_apartments
		71	(
		72	id integer not null,
		73	event integer not null,
9	dev	74	apartment integer not null,
3	dev	75	distance decimal,
		76	comment text,
		77	mod_stamp timestamp,
		78
9	dev	79	constraint event_apartments_prim primary key (event, apartment)
3	dev	80	);
		81
		82	create table acts
		83	(
		84	id integer not null,
		85	name varchar(255) not null,
		86	comment text,
		87	mod_stamp timestamp,
		88
		89	constraint acts_prim primary key (id),
		90	constraint acts_name unique(name)
		91	);
		92
		93	create table event_acts
		94	(
		95	id integer not null,
		96	event integer not null,
		97	act integer not null,
		98	comment text,
		99	mod_stamp timestamp,
		100
		101	constraint event_acts_prim primary key (event, act)
		102	);
		103
9	dev	104	/* removed in this version
3	dev	105	create table participant_events
		106	(
		107	participant integer not null,
		108	event integer not null,
		109	persons integer,
		110	from_zip varchar(10),
		111	from_city varchar(10),
		112	departure datetime,
		113	free_transport integer,
		114	transport_comment integer,
		115	free_sleep integer,
		116	sleep_comment text,
9	dev	117	payed char(1) default ' ',
3	dev	118	comment text,
		119	mod_stamp timestamp,
		120
		121	constraint participant_events_prim primary key (participant, event)
		122	);
9	dev	123	*/
3	dev	124
9	dev	125	create table participants
		126	(
		127	id integer not null,
		128	ident varchar(255) not null,
		129	nick varchar(255) not null,
		130	email varchar(255) not null,
		131	email_public char(1) default ' ',
		132	name varchar(255),
		133	phone varchar(255),
		134	event integer not null,
		135	persons integer,
		136	from_zip varchar(10),
		137	from_city varchar(10),
		138	departure timestamp,
		139	free_transport integer,
		140	transport_comment text,
		141	free_sleep integer,
		142	sleep_comment text,
		143	payed char(1) default ' ',
		144	comment text,
		145	private_comment text,
		146	mod_stamp timestamp,
		147
		148	constraint participants_prim primary key (id),
		149	constraint participants_email unique(email)
		150	);
		151
3	dev	152	create table participant_acts
		153	(
		154	participant integer not null,
		155	event integer not null,
		156	act integer not null,
		157	comment text,
		158	mod_stamp timestamp,
		159
		160	constraint participant_acts_prim primary key (participant, event, act)
		161	);

Subversion Repositories general

(root)/kickup/trunk/sql/00.tables.sql/ – Rev 9