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

Rev	Author	Line No.	Line
3	dev	1	--
11	dev	2	-- kickup sql tables
3	dev	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
10	dev	23	create table acts
		24	(
		25	id integer not null,
		26	name varchar(255) not null,
		27	comment text,
		28	mod_stamp timestamp,
		29
		30	constraint acts_prim primary key (id),
		31	constraint acts_name unique(name)
		32	);
		33
		34	create table apartments
		35	(
		36	id integer not null,
		37	name varchar(255) not null,
		38	address text,
		39	price decimal,
		40	url varchar(4000),
		41	comment text,
		42	mod_stamp timestamp,
		43
		44	constraint apartments_prim primary key (id)
		45	);
		46
3	dev	47	create table events
		48	(
		49	id integer not null,
		50	name varchar(255) not null,
		51	place varchar(255),
		52	address text,
		53	transport_desc text,
		54	start date,
		55	stop date,
		56	last_register date,
		57	last_unregister date,
		58	price decimal,
		59	money_account text,
		60	enabled char(1) default '1',
		61	comment text,
		62	mod_stamp timestamp,
		63
		64	constraint events_prim primary key (id),
		65	constraint events_name unique(name)
		66	);
		67
		68	create table event_files
		69	(
		70	id integer not null,
		71	event integer not null,
		72	name varchar(255) not null,
		73	data file,
		74	type char(1),
		75	comment text,
		76	mod_stamp timestamp,
		77
		78	constraint event_files_prim primary key (id)
		79	);
		80
		81	create table event_apartments
		82	(
		83	id integer not null,
		84	event integer not null,
9	dev	85	apartment integer not null,
3	dev	86	distance decimal,
		87	comment text,
		88	mod_stamp timestamp,
		89
9	dev	90	constraint event_apartments_prim primary key (event, apartment)
3	dev	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 11