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
		7	create table participants
		8	(
		9	id integer not null,
		10	nick varchar(255) not null,
		11	email varchar(255) not null,
		12	name varchar(255),
		13	phone varchar(255),
		14	comment text,
		15	mod_stamp timestamp,
		16
		17	constraint participants_prim primary key (id),
		18	constraint participants_email unique(email)
		19	);
		20
		21	create table events
		22	(
		23	id integer not null,
		24	name varchar(255) not null,
		25	place varchar(255),
		26	address text,
		27	transport_desc text,
		28	start date,
		29	stop date,
		30	last_register date,
		31	last_unregister date,
		32	price decimal,
		33	money_account text,
		34	enabled char(1) default '1',
		35	comment text,
		36	mod_stamp timestamp,
		37
		38	constraint events_prim primary key (id),
		39	constraint events_name unique(name)
		40	);
		41
		42	create table event_files
		43	(
		44	id integer not null,
		45	event integer not null,
		46	name varchar(255) not null,
		47	data file,
		48	type char(1),
		49	comment text,
		50	mod_stamp timestamp,
		51
		52	constraint event_files_prim primary key (id)
		53	);
		54
		55	create table apartments
		56	(
		57	id integer not null,
		58	name varchar(255) not null,
		59	address text,
		60	price decimal,
		61	url varchar(4000),
		62	comment text,
		63	mod_stamp timestamp,
		64
		65	constraint apartments_prim primary key (id)
		66	);
		67
		68	create table event_apartments
		69	(
		70	id integer not null,
		71	event integer not null,
		72	apartments integer not null,
		73	distance decimal,
		74	comment text,
		75	mod_stamp timestamp,
		76
		77	constraint event_apartments_prim primary key (event, apartments)
		78	);
		79
		80	create table acts
		81	(
		82	id integer not null,
		83	name varchar(255) not null,
		84	comment text,
		85	mod_stamp timestamp,
		86
		87	constraint acts_prim primary key (id),
		88	constraint acts_name unique(name)
		89	);
		90
		91	create table event_acts
		92	(
		93	id integer not null,
		94	event integer not null,
		95	act integer not null,
		96	comment text,
		97	mod_stamp timestamp,
		98
		99	constraint event_acts_prim primary key (event, act)
		100	);
		101
		102	create table participant_events
		103	(
		104	participant integer not null,
		105	event integer not null,
		106	persons integer,
		107	from_zip varchar(10),
		108	from_city varchar(10),
		109	departure datetime,
		110	free_transport integer,
		111	transport_comment integer,
		112	free_sleep integer,
		113	sleep_comment text,
		114	comment text,
		115	mod_stamp timestamp,
		116
		117	constraint participant_events_prim primary key (participant, event)
		118	);
		119
		120	create table participant_acts
		121	(
		122	participant integer not null,
		123	event integer not null,
		124	act integer not null,
		125	comment text,
		126	mod_stamp timestamp,
		127
		128	constraint participant_acts_prim primary key (participant, event, act)
		129	);

Subversion Repositories general

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