bc9803019b431e227eeaf89db474b26f11129e11

Author: Sonny Scroggin

Date: 2009-05-26 19:07:15 -0700

adding schema snippets for quick and easy table creations

diff --git a/Snippets/New Schema.tmSnippet b/Snippets/New Schema.tmSnippet new file mode 100644 index 0000000..5582036 --- /dev/null +++ b/Snippets/New Schema.tmSnippet @@ -0,0 +1,22 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> +<plist version="1.0"> +<dict> + <key>content</key> + <string>var \$${1:table_name} = array( + 'id' =&gt; array('type' =&gt; 'integer', 'null' =&gt; false, 'default' =&gt; NULL, 'key' =&gt; 'primary'),$0 + 'created' =&gt; array('type' =&gt; 'datetime', 'null' =&gt; false), + 'modified' =&gt; array('type' =&gt; 'datetime', 'null' =&gt; false), + 'indexes' =&gt; array('PRIMARY' =&gt; array('column' =&gt; 'id', 'unique' =&gt; 1)) +); +</string> + <key>name</key> + <string>New Schema</string> + <key>scope</key> + <string>source.php.cake</string> + <key>tabTrigger</key> + <string>sch</string> + <key>uuid</key> + <string>B4249811-2173-41ED-98D0-875C19AC7ED5</string> +</dict> +</plist> diff --git a/Snippets/Schema Column.tmSnippet b/Snippets/Schema Column.tmSnippet new file mode 100644 index 0000000..1495d2c --- /dev/null +++ b/Snippets/Schema Column.tmSnippet @@ -0,0 +1,16 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> +<plist version="1.0"> +<dict> + <key>content</key> + <string>'${1:column}' =&gt; array('type' =&gt; '${2:string/text/integer/float/datetime/timestamp/time/date/binary/boolean}', 'null' =&gt; ${3:false}${4:, 'length' =&gt; ${5:255}}${6:, 'key' =&gt; 'unique'}),$0</string> + <key>name</key> + <string>Schema Column</string> + <key>scope</key> + <string>source.php.cake</string> + <key>tabTrigger</key> + <string>sch</string> + <key>uuid</key> + <string>44E83754-D2B8-4E9C-93A7-27C39040F264</string> +</dict> +</plist> diff --git a/Snippets/Unique Index.tmSnippet b/Snippets/Unique Index.tmSnippet new file mode 100644 index 0000000..4e9b106 --- /dev/null +++ b/Snippets/Unique Index.tmSnippet @@ -0,0 +1,17 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> +<plist version="1.0"> +<dict> + <key>content</key> + <string>'${1:column_name}' =&gt; array('column' =&gt; '${1:column_name}', 'unique' =&gt; 1) +</string> + <key>name</key> + <string>Unique Index</string> + <key>scope</key> + <string>source.php.cake</string> + <key>tabTrigger</key> + <string>sch</string> + <key>uuid</key> + <string>0D040AA1-BF6C-48B5-9C21-F23E7D83802A</string> +</dict> +</plist> diff --git a/info.plist b/info.plist index 5a2e211..1c58dbc 100644 --- a/info.plist +++ b/info.plist @@ -30,6 +30,7 @@ <string>125E47D2-7CE0-44B5-BD2D-A35E4734E4F9</string> <string>56C3B48F-FD28-47A2-80C6-92B7E9D257A0</string> <string>2362409F-501C-4AF2-9CD8-DDC99CC59AD9</string> + <string>9C39B690-AAFA-432B-B038-2547BC5771D6</string> <string>------------------------------------</string> <string>03D809B4-7F9C-4F30-A402-60DDF7F8EBE6</string> <string>91FFD2A3-AAC0-40AF-9807-1963325EBCD9</string> @@ -184,6 +185,17 @@ <key>name</key> <string>Session</string> </dict> + <key>9C39B690-AAFA-432B-B038-2547BC5771D6</key> + <dict> + <key>items</key> + <array> + <string>B4249811-2173-41ED-98D0-875C19AC7ED5</string> + <string>44E83754-D2B8-4E9C-93A7-27C39040F264</string> + <string>0D040AA1-BF6C-48B5-9C21-F23E7D83802A</string> + </array> + <key>name</key> + <string>Schema</string> + </dict> <key>ABF29B66-C053-4321-8350-199B57ABD092</key> <dict> <key>items</key> @@ -352,12 +364,9 @@ <string>B3FEFE65-1B72-4166-A181-5288DCA14F3E</string> <string>5100B3CC-EC3D-4F4B-A30E-C8B33B9635EF</string> <string>C5C4E48D-F3E1-473C-84A0-5389E4BD1438</string> - <string>F2C88F6A-CDA3-4270-9433-A23A8F8D82C3</string> - <string>B2B6011C-955C-4C6D-A5B8-7875C13CCDD1</string> - <string>5F94353B-7F33-488F-97DF-5C36066F2271</string> - <string>558C7AF5-FDAD-4AF7-9DEA-AF6943B3339C</string> - <string>A5BF43CF-5164-4955-9BB7-D25C1C6C013D</string> - <string>437FF714-397B-47BC-A1ED-680E48AD476E</string> + <string>B4249811-2173-41ED-98D0-875C19AC7ED5</string> + <string>44E83754-D2B8-4E9C-93A7-27C39040F264</string> + <string>0D040AA1-BF6C-48B5-9C21-F23E7D83802A</string> </array> <key>uuid</key> <string>4A2F1F37-F6DA-43A3-B329-CA8DCF017515</string>