Context Navigation

Chaostr

Timestamp:

03/10/08 02:37:32 (5 years ago)

Author:

vkgtaro

Message:

lang/perl/Chaostr: テーブル定義してみた

Location:

lang/perl/Chaostr/trunk

Files:

r7662	r7734
	1	CREATE TABLE timeline (
	2	id int UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	3	type text NOT NULL,
	4	created_by int UNSIGNED,
	5	created_on DATETIME,
	6	updated_on DATETIME
	7	)TYPE=InnoDB CHARACTER SET utf8;
	8
	9	CREATE TABLE text (
	10	id int UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	11	timeline_id int UNSIGNED,
	12	title text,
	13	text mediumtext NOT NULL,
	14	foreign key(timeline_id) references timeline(id) on delete cascade
	15	)TYPE=InnoDB CHARACTER SET utf8;
	16
	17	CREATE TABLE photo (
	18	id int UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	19	timeline_id int UNSIGNED,
	20	photo text,
	21	caption mediumtext NOT NULL,
	22	foreign key(timeline_id) references timeline(id) on delete cascade
	23	)TYPE=InnoDB CHARACTER SET utf8;
	24
	25	CREATE TABLE quote (
	26	id int UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	27	timeline_id int UNSIGNED,
	28	quote mediumtext,
	29	source mediumtext,
	30	foreign key(timeline_id) references timeline(id) on delete cascade
	31	)TYPE=InnoDB CHARACTER SET utf8;
	32
	33	CREATE TABLE link (
	34	id int UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	35	timeline_id int UNSIGNED,
	36	name text,
	37	url text NOT NULL,
	38	foreign key(timeline_id) references timeline(id) on delete cascade
	39	)TYPE=InnoDB CHARACTER SET utf8;
	40
	41	CREATE TABLE video (
	42	id int UNSIGNED AUTO_INCREMENT PRIMARY KEY,
	43	timeline_id int UNSIGNED,
	44	url text NOT NULL,
	45	text text,
	46	foreign key(timeline_id) references timeline(id) on delete cascade
	47	)TYPE=InnoDB CHARACTER SET utf8;
	48
1	49	CREATE TABLE user (
2	50	id int UNSIGNED AUTO_INCREMENT PRIMARY KEY,