cb_install SQL scripts contain errors

[mtlynch]

There seem to be several simple errors in the SQL install scripts. They should all be very easy to fix:

cb_install/sql/structure.sql

• 609: CREATE TABLE should be CREATE TABLE IF NOT EXISTS
• 1053-1054: {tbl_prefix}_video - extra underscore after {tbl_prefix}
• 1107: This line is formatted incorrectly ({table_prefix} appears in the wrong place) and can be deleted because the statement on 1197 has the same effect
• 1141: This line is not necessary because the file_directory column already appears in the original CREATE TABLE statement on 490
• 1148: Line is not necessary because video_version column already appears in the original CREATE TABLE statement on 898
• 1149: Line is not necessary because extras column already appears in the original CREATE TABLE statement on 898
• 1191: Line is not necessary because file_directory column was added on 1142
• 1201: Line is not necessary because parent_id appears in original CREATE TABLE query on 108

cb_install/sql/configs.sql

• 224: Fails because the primary key 224 was already used on 158

cb_install/sql/user_levels.sql

• 83-88: Fails because these lines already appear in structure.sql:1116-1116

[RealDekkia]

Just FYI, this Issue has been mentionend in a blog-post: https://mtlynch.io/digitizing-2/#clipbucket-the-open-source-youtube-clone-you-cant-really-install