SQLite format 3@ 5/Cindexsqlite_autoindex_tg_group_1tg_group stabledirectorsdirectorsCREATE TABLE directors ( director_id INTEGER NOT NULL, name VARCHAR(100) NOT NULL, PRIMARY KEY (director_id) )e'' tabletg_permissiontg_permissionCREATE TABLE tg_permission ( permission_id INTEGER NOT NULL, permission_name VARCHAR(16) NOT NULL, description VARCHAR(255), PRIMARY KEY (permission_id), UNIQUE (permission_name) )9M'indexsqlite_autoindex_tg_permission_1tg_permission+-tabletg_usertg_userCREATE TABLE tg_user ( user_id INTEGER NOT NULL, user_name VARCHAR(16) NOT NULL, email_address VARCHAR(255) NOT NULL, display_name VARCHAR(255), password VARCHAR(80), created TIMESTAMP, PRIMARY KEY (user_id), UNIQUE (user_name), UNIQUE (email_address) )-Aindexsqlite_autoindex_tg_user_2tg_user-Aindexsqlite_autoindex_tg_user_1tg  _7)-Aeditoreditor@somedomain.comExample editor82f8d08931786ae5fb817a06c5e8a798b3c80f89b282dd9dd54a1fb3bce1ea0688d7bbef3a6c2fe62009-09-27 09:33:15.1224059+-Amanagermanager@somedomain.comExample managerb3c3c8c5cbbf86d516bdca0fe9f92397e15283b231ab1cb76bc63984a179e83fe30bea644d49ee042009-09-27 09:33:15.121307  editor manager 7editor@somedomain.com9manager@somedomain.com    Joel Coen+Larry Wachowski)Andy Wachowski'David Fincher+Robert Zemeckis q)AmanagersThis permission give an administrative right to the bearerManagers Group2009-09-27 09:33:15.123691  managers ?This permission give an administrative right to the bearer H0k+-tabletg_usertg_userCREATE TABLE tg_user ( user_id INTEGER NOT NULL, user_name VARCHAR(16+-tabletg_usertg_userCREATE TABLE tg_user ( user_id INTEGER NOT NULL, user_name VARCHAR(16) NOT NULL, email_address VARCHAR(255) NOT NULL, display_name VARCHAR(255), password VARCHAR(80), created TIMESTAMP, PRIMARY KEY (user_id), UNIQUE (user_name), UNIQUE (email_address) )-Aindexsqlite_autoindex_tg_user_1tg_user-Aindexsqlite_autoindex_tg_user_2tg_usere'' tabletg_permissiontg_permissionCREATE TABLE tg_permission ( permission_id INTEGER NOT NULL, permission_name VARCHAR(16) NOT NULL, description VARCHAR(255), PRIMARY KEY (permission_id), UNIQUE (permission_name) )9M'indexsqlite_autoindex_tg_permission_1tg_permissionstabledirectorsdirectorsCREATE TABLE directors ( director_id INTEGER NOT NULL, name VARCHAR(100) NOT NULL, PRIMARY KEY (director_id) ) ,]tabletg_grouptg_groupCREATE TABLE tg_group ( group_id INTEGER NOT NULL, group_name VARCHAR(16) NOT NULL, description VARCHAR(255) NOT NULL, display_name VARCHAR(255), created TIMESTAMP, PRIMARY KEY (group_id), UNIQUE (group_name), UNIQUE (description) )/Cindexsqlite_autoindex_tg_group_1tg_group / Cindexsqlite_autoindex_tg_group_2tg_group ! ''tabletg_user_grouptg_user_group CREATE TABLE tg_user_group ( user_id INTEGER, group_id INTEGER, FOREIGN KEY(user_id) REFERENCES tg_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY(group_id) REFERENCES tg_group (group_id) ON DELETE CASCADE ON UPDATE CASCADE )K 33=tabletg_group_permissiontg_group_permissionCREATE TABLE tg_group_permission ( group_id INTEGER, permission_id INTEGER, FOREIGN KEY(group_id) REFERENCES tg_group (group_id) ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY(permission_id) REFERENCES tg_permission (permission_id) ON DELETE CASCADE ON UPDATE CASCADE )   +jF++sci-firead: furturism"?dramamakes your girlfriend cry!#1documentarypurely information#comedyfunny stuff2Wanimationcartoons and computer rendered flicks&Eactioncar chases, sex and violence =Q+indexsqlite_autoindex_movie_directo tablegenresgenresCREATE TABLE genres ( genre_id INTEGER NOT NULL, name VARCHAR(100), description VARCHAR(200), PRIMARY KEY (genre_id) )x KtablemoviesmoviesCREATE TABLE movies ( movie_id INTEGER NOT NULL, title VARCHAR(100) NOT NULL, description TEXT, genre_id INTEGER, release_date DATE, PRIMARY KEY (movie_id), FOREIGN KEY(genre_id) REFERENCES genres (genre_id) )$++tablemovie_directorsmovie_directorsCREATE TABLE movie_directors ( movie_id INTEGER NOT NULL, director_id INTEGER NOT NULL, PRIMARY KEY (movie_id, director_id), FOREIGN KEY(movie_id) REFERENCES movies (movie_id), FOREIGN KEY(director_id) REFERENCES directors (director_id) )=Q+indexsqlite_autoindex_movie_directors_1movie_directors sJ"s,-!!The Big Lebowski"Dude" Lebowski, mistaken for a millionaire Lebowski, seeks restitution for his ruined rug and enlists his bowling buddies to help get it.1998-03-06'!#!The MatrixA computer hacker learns from mysterious rebels about the true nature of his reality and his role in the war against the controllers of it.1999-03-31|!M!Fight ClubAn office employee and a soap salesman build a global organization to help vent male aggression.1999-10-1431+!Back to the FutureIn 1985, Doc Brown invents time travel; in 1955, Marty McFly accidentally prevents his parents from meeting, putting his own existence at stake1985-04-03